PHP实例开发源码-化妆品商城源码php版.zip

-- phpMyAdmin SQL Dump -- version 3.3.7 -- http://www.phpmyadmin.net -- -- 主机: localhost -- 生成日期: 2012 年 04 月 30 日 09:40 -- 服务器版本: 5.0.90 -- PHP 版本: 5.2.14 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- 数据库: `abc` -- -- -------------------------------------------------------- -- -- 表的结构 `dev_advs_duilian` -- CREATE TABLE IF NOT EXISTS `dev_advs_duilian` ( `id` int(4) NOT NULL auto_increment, `groupname` char(200) NOT NULL, `src` char(100) NOT NULL default '', `src2` char(100) NOT NULL default '', `url` char(200) NOT NULL default '', `url2` varchar(200) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ; -- -- 转存表中的数据 `dev_advs_duilian` -- -- -------------------------------------------------------- -- -- 表的结构 `dev_advs_lb` -- CREATE TABLE IF NOT EXISTS `dev_advs_lb` ( `id` int(20) NOT NULL auto_increment, `groupid` int(5) NOT NULL default '1', `title` char(100) NOT NULL default '', `src` char(100) NOT NULL default '', `src1` char(255) NOT NULL, `url` char(100) NOT NULL default '', `xuhao` int(5) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=47 ; -- -- 转存表中的数据 `dev_advs_lb` -- INSERT INTO `dev_advs_lb` (`id`, `groupid`, `title`, `src`, `src1`, `url`, `xuhao`) VALUES (39, 1, '顶级品牌香水推荐', 'advs/pics/20101231/1293780977.jpg', '', '{#RP#}news/html/?378.html', 1), (40, 1, '迎中秋 3折起', 'advs/pics/20101231/1293780988.jpg', '', '{#RP#}news/html/?378.html', 3), (41, 1, '御泥坊免费试用', 'advs/pics/20101231/1293780983.jpg', '', 'http://', 2), (45, 1, '睛采 即刻惊现', 'advs/pics/20101231/1293781005.jpg', '', 'http://', 4), (46, 1, '晒妆品赢现金券', 'advs/pics/20101231/1293781010.jpg', '', 'http://', 5); -- -------------------------------------------------------- -- -- 表的结构 `dev_advs_lbgroup` -- CREATE TABLE IF NOT EXISTS `dev_advs_lbgroup` ( `id` int(3) NOT NULL auto_increment, `groupname` varchar(50) NOT NULL default '', `xuhao` int(5) NOT NULL default '0', `moveable` int(1) NOT NULL default '1', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ; -- -- 转存表中的数据 `dev_advs_lbgroup` -- INSERT INTO `dev_advs_lbgroup` (`id`, `groupname`, `xuhao`, `moveable`) VALUES (1, '默认轮播广告组', 1, 0); -- -------------------------------------------------------- -- -- 表的结构 `dev_advs_link` -- CREATE TABLE IF NOT EXISTS `dev_advs_link` ( `id` int(12) NOT NULL auto_increment, `groupid` int(5) NOT NULL default '0', `name` varchar(200) NOT NULL default '', `url` varchar(200) NOT NULL default '', `xuhao` int(5) NOT NULL default '0', `type` varchar(20) NOT NULL default '', `src` varchar(100) NOT NULL default '', `cl` int(10) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=68 ; -- -- 转存表中的数据 `dev_advs_link` -- INSERT INTO `dev_advs_link` (`id`, `groupid`, `name`, `url`, `xuhao`, `type`, `src`, `cl`) VALUES (61, 1, '1', 'http://www.baidu.com', 0, '', 'advs/pics/20110104/1294125764.jpg', 0), (62, 1, '1', 'http://www.baidu.com', 0, '', 'advs/pics/20110104/1294125770.jpg', 0), (63, 1, '1', 'http://www.google.com', 0, '', 'advs/pics/20110104/1294125780.jpg', 0), (64, 1, '1', 'http://www.google.com', 0, '', 'advs/pics/20110104/1294125787.jpg', 0), (65, 1, '1', 'http://www.google.com', 0, '', 'advs/pics/20110104/1294125796.jpg', 0), (66, 1, '1', 'http://www.google.com', 0, '', 'advs/pics/20110104/1294125846.jpg', 0), (67, 1, '1', 'http://www.google.com', 0, '', 'advs/pics/20110104/1294125852.jpg', 0); -- -------------------------------------------------------- -- -- 表的结构 `dev_advs_linkgroup` -- CREATE TABLE IF NOT EXISTS `dev_advs_linkgroup` ( `id` int(3) NOT NULL auto_increment, `groupname` varchar(50) NOT NULL default '', `xuhao` int(5) NOT NULL default '0', `moveable` int(1) NOT NULL default '1', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ; -- -- 转存表中的数据 `dev_advs_linkgroup` -- INSERT INTO `dev_advs_linkgroup` (`id`, `groupname`, `xuhao`, `moveable`) VALUES (1, '默认友情链接组', 1, 0); -- -------------------------------------------------------- -- -- 表的结构 `dev_advs_logo` -- CREATE TABLE IF NOT EXISTS `dev_advs_logo` ( `id` int(4) NOT NULL auto_increment, `groupname` char(200) NOT NULL, `src` char(100) NOT NULL default '', `url` char(200) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ; -- -- 转存表中的数据 `dev_advs_logo` -- INSERT INTO `dev_advs_logo` (`id`, `groupname`, `src`, `url`) VALUES (1, '网站标志一', 'advs/pics/20101115/1289789482.jpg', '#'); -- -------------------------------------------------------- -- -- 表的结构 `dev_advs_movi` -- CREATE TABLE IF NOT EXISTS `dev_advs_movi` ( `id` int(4) NOT NULL auto_increment, `groupname` char(200) NOT NULL, `src` char(100) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ; -- -- 转存表中的数据 `dev_advs_movi` -- INSERT INTO `dev_advs_movi` (`id`, `groupname`, `src`) VALUES (1, '视频广告测试一', 'http://vhead.blog.sina.com.cn/player/outer_player.swf?auto=1&vid=16205152&uid=1504617052'); -- -------------------------------------------------------- -- -- 表的结构 `dev_advs_pic` -- CREATE TABLE IF NOT EXISTS `dev_advs_pic` ( `id` int(4) NOT NULL auto_increment, `groupname` char(200) NOT NULL, `src` char(100) NOT NULL default '', `url` char(200) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=3 ; -- -- 转存表中的数据 `dev_advs_pic` -- INSERT INTO `dev_advs_pic` (`id`, `groupname`, `src`, `url`) VALUES (1, '图片广告', 'advs/pics/20110104/1294109090.jpg', ''), (2, '图片广告1', 'advs/pics/20110104/1294121362.jpg', 'http://'); -- -------------------------------------------------------- -- -- 表的结构 `dev_advs_pop` -- CREATE TABLE IF NOT EXISTS `dev_advs_pop` ( `id` int(12) NOT NULL auto_increment, `title` varchar(255) NOT NULL, `body` text, `ifpop` int(1) NOT NULL default '0', `popwidth` int(10) default NULL, `popheight` int(10) default NULL, `popleft` int(10) default NULL, `poptop` int(10) default NULL, `poptoolbar` int(1) default NULL, `popmenubar` int(1) default NULL, `popstatus` int(1) default NULL, `poplocation` int(1) default NULL, `popscrollbars` varchar(50) default NULL, `popresizable` int(1) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; -- -- 转存表中的数据 `dev_advs_pop` -- INSERT INTO `dev_advs_pop` (`id`, `title`, `body`, `ifpop`, `popwidth`, `popheight`, `popleft`, `poptop`, `poptoolbar`, `popmenubar`, `popstatus`, `poplocation`, `popscrollbars`, `popresizable`) VALUES (1, '弹出窗口', '窗口内容 ', 0, 400, 300, 0, 0, 0, 0, 0, 0, 'auto', 0); -- -------------------------------------------------------- -- -- 表的结构 `dev_advs_text` -- CREATE TABLE IF NOT EXISTS `dev_advs_text` ( `id` int(4) NOT NULL auto_increment, `groupname` char(200) NOT NULL, `text` char(200) NOT NULL default '', `url` char(200) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ; -- -- 转存表中的数据 `dev_advs_text` -- INSERT INTO `dev_advs_text` (`id`, `groupname`, `text`, `url`) VALUES (1, '促销广告一', '本季特大优惠活动开始啦qq', 'http://www.baidu.com'); -- -------------------------------------------------------- -- -- 表的