基于PHP的宠物用品商城源码 php版.zip

-- phpMyAdmin SQL Dump -- version 3.3.7 -- http://www.phpmyadmin.net -- -- 主机: localhost -- 生成日期: 2012 年 04 月 12 日 00:54 -- 服务器版本: 5.5.18 -- PHP 版本: 5.2.17 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=1 ; -- -- 转存表中的数据 `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=51 ; -- -- 转存表中的数据 `dev_advs_lb` -- INSERT INTO `dev_advs_lb` (`id`, `groupid`, `title`, `src`, `src1`, `url`, `xuhao`) VALUES (39, 1, '广告标题', 'advs/pics/20100118/1263803946.jpg', '', 'http://', 2), (48, 1, '广告标题', 'advs/pics/20100118/1263803974.jpg', '', 'http://', 3), (49, 1, '广告标题', 'advs/pics/20100330/1269922496.gif', '', 'http://', 1), (50, 1, '广告标题', 'advs/pics/20100118/1263803642.gif', '', 'http://', 4); -- -------------------------------------------------------- -- -- 表的结构 `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=2 ; -- -- 转存表中的数据 `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=52 ; -- -- 转存表中的数据 `dev_advs_link` -- INSERT INTO `dev_advs_link` (`id`, `groupid`, `name`, `url`, `xuhao`, `type`, `src`, `cl`) VALUES (21, 1, '支付宝', 'http://www.alipai.com', 1, '', '', 0), (22, 1, '淘宝网', 'http://www.taobao.com', 2, '', '', 0), (33, 1, '网上商城', 'http://www.baidu.com', 3, '', '', 0), (34, 1, '家电批发网', 'http://www.baidu.com', 8, '', '', 0), (35, 1, '松下电器网站', 'http://www.baidu.com', 7, '', '', 0), (36, 1, '都市生活网', 'http://www.baidu.com', 6, '', '', 0), (37, 1, '网银支付', 'http://www.baidu.com', 5, '', '', 0), (38, 1, '售后服务网', 'http://www.baidu.com', 10, '', '', 0), (39, 1, '家电维修网', 'http://www.baidu.com', 12, '', '', 0), (40, 1, '上海热线', 'http://www.baidu.com', 11, '', '', 0), (41, 1, '中国万网', 'http://www.baidu.com', 13, '', '', 0), (42, 1, '11', 'http://www.', 0, '', 'advs/pics/20091117/1258424299.jpg', 0), (43, 1, '12', 'http://www.', 0, '', 'advs/pics/20091117/1258424486.jpg', 0), (44, 1, '13', 'http://www', 0, '', 'advs/pics/20091117/1258424496.jpg', 0), (45, 1, '14', 'http://www', 0, '', 'advs/pics/20091117/1258424504.jpg', 0), (46, 1, '15', 'http://www', 0, '', 'advs/pics/20091117/1258424512.jpg', 0), (47, 1, '16', 'http://www', 0, '', 'advs/pics/20091117/1258424520.jpg', 0), (48, 1, '17', 'http://www', 0, '', 'advs/pics/20091117/1258424529.jpg', 0), (49, 1, '18', 'http://www', 0, '', 'advs/pics/20091117/1258424536.jpg', 0), (50, 1, '19', 'http://www', 0, '', 'advs/pics/20091117/1258424544.jpg', 0), (51, 1, '20', 'http://www', 0, '', 'advs/pics/20091117/1258425556.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=2 ; -- -- 转存表中的数据 `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=2 ; -- -- 转存表中的数据 `dev_advs_logo` -- INSERT INTO `dev_advs_logo` (`id`, `groupname`, `src`, `url`) VALUES (1, '网站标志一', 'advs/pics/20100329/1269853389.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=2 ; -- -- 转存表中的数据 `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=9 ; -- -- 转存表中的数据 `dev_advs_pic` -- INSERT INTO `dev_advs_pic` (`id`, `groupname`, `src`, `url`) VALUES (1, '页内广告1', 'advs/pics/20100330/1269926342.gif', 'http://www'), (2, '页内广告2', 'advs/pics/20100330/1269928485.gif', 'http://'), (3, '页内广告3', 'advs/pics/20100330/1269931066.jpg', 'http://'), (4, '页内广告4', 'advs/pics/20100330/1269931074.jpg', 'http://'), (5, '页内广告5', 'advs/pics/20100330/1269931081.jpg', 'http://'), (6, '页内广告6', 'advs/pics/20100330/1269931087.jpg', 'http://'), (7, '页内广告7', 'advs/pics/20100330/1269933965.jpg', 'http://'), (8, '横幅广告', 'advs/pics/20100330/1269938475.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, `popscrollb