淘宝优站自定义程序 爆划算4.4

-- phpMyAdmin SQL Dump -- version 3.2.0.1 -- http://www.phpmyadmin.net -- -- 主机: localhost -- 生成日期: 2014 年 04 月 21 日 07:02 -- 服务器版本: 5.5.8 -- PHP 版本: 5.3.3 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- 数据库: `lan` -- -- -------------------------------------------------------- -- -- 表的结构 `articleb` -- CREATE TABLE IF NOT EXISTS `articleb` ( `id` int(11) NOT NULL AUTO_INCREMENT, `categoryid` int(11) NOT NULL DEFAULT '1', `title` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `images` text CHARACTER SET utf8 COLLATE utf8_bin, `details` text CHARACTER SET utf8 COLLATE utf8_bin, `status` int(11) unsigned NOT NULL DEFAULT '0', `link` text, PRIMARY KEY (`id`), KEY `id` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; -- -- 转存表中的数据 `articleb` -- INSERT INTO `articleb` (`id`, `categoryid`, `title`, `images`, `details`, `status`, `link`) VALUES (1, 29, '你好吗？', '', '<p>你好吗？</p>', 0, '/baohuasuan.com.cn/'), (2, 30, '韩版女式百搭蝴蝶结抹胸裹胸小吊带背心女打底衫莫代尔棉金缕梅', '', '<p>不错的</p>', 0, '/5idjg.uz.taobao.com'); -- -------------------------------------------------------- -- -- 表的结构 `categoryb` -- CREATE TABLE IF NOT EXISTS `categoryb` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(45) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `status` int(11) unsigned NOT NULL DEFAULT '0', `english` varchar(45) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ; -- -- 转存表中的数据 `categoryb` -- INSERT INTO `categoryb` (`id`, `name`, `status`, `english`) VALUES (19, '女装', 0, NULL), (20, '男装', 0, NULL), (21, '母婴', 0, NULL), (22, '鞋包', 0, NULL), (23, '家居', 0, NULL), (24, '美食', 0, NULL), (25, '配饰', 0, NULL), (27, '数码电器', 0, NULL), (28, '化妆品', 0, NULL), (29, '其他', 0, NULL), (30, '运动户外', 0, NULL); -- -------------------------------------------------------- -- -- 表的结构 `config` -- CREATE TABLE IF NOT EXISTS `config` ( `id` int(11) NOT NULL AUTO_INCREMENT, `parent_id` int(11) DEFAULT NULL, `alias` varchar(20) COLLATE utf8_bin DEFAULT NULL, `keyname` varchar(20) COLLATE utf8_bin DEFAULT NULL, `value` int(11) DEFAULT NULL, `type` varchar(10) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=14 ; -- -- 转存表中的数据 `config` -- INSERT INTO `config` (`id`, `parent_id`, `alias`, `keyname`, `value`, `type`) VALUES (1, 0, NULL, '积分设置', NULL, NULL), (2, 0, NULL, '金蛋设置', NULL, NULL), (3, 1, 'sign', '签到积分', 1, 'text'), (4, 1, 'frist_sign', '第一次签到', 1, 'text'), (5, 1, 'sign_max', '最大连续签到天数', 1, 'text'), (6, 1, 'sign_open', '开启', 1, 'radio'), (7, 1, 'invate_inte', '邀请积分', 1, 'text'), (8, 1, 'invate_max', '一天邀请次数', 1, 'text'), (9, 1, 'sign_add', '签到递增', 1, 'text'), (10, 0, NULL, '系统设置', NULL, NULL), (11, 10, 'index_page_count', '首页分页总数', 5, 'text'), (12, 2, 'zadan_open', '开启', 1, 'radio'), (13, 2, 'zadan_integral', '积分消耗', 3, 'text'); -- -------------------------------------------------------- -- -- 表的结构 `integral_goods` -- CREATE TABLE IF NOT EXISTS `integral_goods` ( `id` int(11) NOT NULL AUTO_INCREMENT, `iid` bigint(15) DEFAULT NULL, `goods_title` varchar(100) COLLATE utf8_bin DEFAULT NULL, `goods_url` varchar(255) COLLATE utf8_bin DEFAULT NULL, `goods_img` varchar(255) COLLATE utf8_bin DEFAULT NULL, `start_time` int(11) DEFAULT NULL, `end_time` int(11) DEFAULT NULL, `integral` int(11) DEFAULT NULL, `num` int(11) DEFAULT NULL, `price` float(11,2) DEFAULT NULL, `sort` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=2 ; -- -- 转存表中的数据 `integral_goods` -- INSERT INTO `integral_goods` (`id`, `iid`, `goods_title`, `goods_url`, `goods_img`, `start_time`, `end_time`, `integral`, `num`, `price`, `sort`) VALUES (1, 36253396356, '艾尔玉微 女羽绒棉服2013新款外套修身短款时尚百搭女士棉袄包邮', 'http://item.taobao.com/item.htm?id=36253396356&spm=2014.21335573.0.0', 'http://img01.taobaocdn.com/bao/uploaded/i1/12792031214070815/T1hq0wFe4iXXXXXXXX_!!0-item_pic.jpg', 1386554400, 1387591200, 300, 1, 499.00, 100); -- -------------------------------------------------------- -- -- 表的结构 `integral_goods_log` -- CREATE TABLE IF NOT EXISTS `integral_goods_log` ( `log_id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) DEFAULT NULL, `goods_id` int(11) DEFAULT NULL, `log_time` int(11) DEFAULT NULL, `integral` int(11) DEFAULT NULL, `address` varchar(255) COLLATE utf8_bin DEFAULT NULL, `qq` int(12) DEFAULT NULL, `mobile` bigint(12) DEFAULT NULL, `username` varchar(14) COLLATE utf8_bin DEFAULT NULL, `status` tinyint(2) DEFAULT NULL, `bid` varchar(100) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`log_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=12 ; -- -- 转存表中的数据 `integral_goods_log` -- INSERT INTO `integral_goods_log` (`log_id`, `uid`, `goods_id`, `log_time`, `integral`, `address`, `qq`, `mobile`, `username`, `status`, `bid`) VALUES (11, 5, 3, 1385024751, 30, '讽德诵功', 1232, 3124235345, '小黄', 1, '12345'); -- -------------------------------------------------------- -- -- 表的结构 `items` -- CREATE TABLE IF NOT EXISTS `items` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `iid` varchar(45) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `price` varchar(45) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `prom` varchar(45) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, `picurl` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `itemurl` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `categoryid` int(10) unsigned NOT NULL, `nick` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `title` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `status` int(11) unsigned NOT NULL DEFAULT '0', `promrate` varchar(45) DEFAULT NULL, `starttime` int(11) DEFAULT NULL, `endtime` int(11) DEFAULT NULL, `commrate` varchar(45) DEFAULT NULL, `commission` varchar(45) DEFAULT NULL, `volume` varchar(45) DEFAULT '', `promnum` varchar(45) DEFAULT NULL, `promvolu` varchar(45) DEFAULT NULL, `top` int(11) unsigned DEFAULT '0', `report` text CHARACTER SET utf8 COLLATE utf8_bin, `gg` int(11) unsigned NOT NULL DEFAULT '0', `start` int(11) unsigned NOT NULL DEFAULT '0', `partid` int(10) unsigned NOT NULL, `sorts` int(10) unsigned NOT NULL DEFAULT '100', `freeshipping` int(2) DEFAULT NULL, `stock` int(10) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1773 ; -- -- 转存表中的数据 `items` -- INSERT INTO `items` (`id`, `iid`, `price`, `prom`, `picurl`, `itemurl`, `categoryid`, `nick`, `title`, `status`, `promrate`, `starttime`, `endtime`, `commrate`, `commission`, `volume`, `promnum`, `promvolu`, `top`, `report`, `gg`, `start`, `partid`, `sorts`, `freeshipping`, `stock`) VALUES (1772, '22223859761', '145.00', '20.0', 'http://img03.taobaocdn.com/bao/uploaded/i3/T13FzmFcRgXXXXXXXX_!!0-item_pic.jpg', 'http://item.taobao.com/item.htm?id=22223859761&spm=2014.21444621.0.0', 29, '海客旗舰店', '耐热钢化保鲜碗大中两件套', 1, NULL, 20140420, 20140423, '0.08', '1.5', '', NULL, NULL, 1, '', 1, 0, 13, 454, 0, 5943); -- -------------------------------------------------------- -- -- 表的结构 `links` -- CREATE TABLE IF NOT EXISTS `links` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `title` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `location` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `picurl` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `url` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `statu