nideshop-master.zip

SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for nideshop_ad -- ---------------------------- DROP TABLE IF EXISTS `nideshop_ad`; CREATE TABLE `nideshop_ad` ( `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `ad_position_id` smallint(5) unsigned NOT NULL DEFAULT '0', `media_type` tinyint(3) unsigned NOT NULL DEFAULT '0', `name` varchar(60) NOT NULL DEFAULT '', `link` varchar(255) NOT NULL DEFAULT '', `image_url` text NOT NULL, `content` varchar(255) NOT NULL DEFAULT '', `end_time` int(11) NOT NULL DEFAULT '0', `enabled` tinyint(3) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`id`), KEY `position_id` (`ad_position_id`), KEY `enabled` (`enabled`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4; -- ---------------------------- -- Records of nideshop_ad -- ---------------------------- BEGIN; INSERT INTO `nideshop_ad` VALUES (1, 1, 1, '合作 谁是你的菜', '', 'http://yanxuan.nosdn.127.net/65091eebc48899298171c2eb6696fe27.jpg', '合作 谁是你的菜', 0, 1); INSERT INTO `nideshop_ad` VALUES (2, 1, 1, '活动 美食节', '', 'http://yanxuan.nosdn.127.net/bff2e49136fcef1fd829f5036e07f116.jpg', '活动 美食节', 0, 1); INSERT INTO `nideshop_ad` VALUES (3, 1, 1, '活动 母亲节', '', 'http://yanxuan.nosdn.127.net/8e50c65fda145e6dd1bf4fb7ee0fcecc.jpg', '活动 母亲节', 0, 1); COMMIT; -- ---------------------------- -- Table structure for nideshop_ad_position -- ---------------------------- DROP TABLE IF EXISTS `nideshop_ad_position`; CREATE TABLE `nideshop_ad_position` ( `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(60) NOT NULL DEFAULT '', `width` smallint(5) unsigned NOT NULL DEFAULT '0', `height` smallint(5) unsigned NOT NULL DEFAULT '0', `desc` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4; -- ---------------------------- -- Records of nideshop_ad_position -- ---------------------------- BEGIN; INSERT INTO `nideshop_ad_position` VALUES (1, '移动端首页轮播广告', 750, 200, ''); COMMIT; -- ---------------------------- -- Table structure for nideshop_address -- ---------------------------- DROP TABLE IF EXISTS `nideshop_address`; CREATE TABLE `nideshop_address` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL DEFAULT '', `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `country_id` smallint(5) NOT NULL DEFAULT '0', `province_id` smallint(5) NOT NULL DEFAULT '0', `city_id` smallint(5) NOT NULL DEFAULT '0', `district_id` smallint(5) NOT NULL DEFAULT '0', `address` varchar(120) NOT NULL DEFAULT '', `mobile` varchar(60) NOT NULL DEFAULT '', `is_default` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `user_id` (`user_id`) ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4; -- ---------------------------- -- Records of nideshop_address -- ---------------------------- BEGIN; INSERT INTO `nideshop_address` VALUES (3, '小明', 1, 1, 20, 233, 2414, '民族大道1号', '13800008888', 1); COMMIT; -- ---------------------------- -- Table structure for nideshop_admin -- ---------------------------- DROP TABLE IF EXISTS `nideshop_admin`; CREATE TABLE `nideshop_admin` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(10) NOT NULL DEFAULT '''''', `password` varchar(255) NOT NULL DEFAULT '''''', `password_salt` varchar(255) NOT NULL DEFAULT '''''', `last_login_ip` varchar(60) NOT NULL DEFAULT '''''', `last_login_time` int(11) NOT NULL DEFAULT '0', `add_time` int(11) NOT NULL DEFAULT '0', `update_time` int(11) NOT NULL DEFAULT '0', `avatar` varchar(255) NOT NULL DEFAULT '''''', `admin_role_id` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4; -- ---------------------------- -- Records of nideshop_admin -- ---------------------------- BEGIN; INSERT INTO `nideshop_admin` VALUES (1, 'admin', 'bb87bf23d14b27de74530dec20e234f3', 'ABCDEF', '::ffff:127.0.0.1', 1505484711, 0, 0, '\'\'', 0); COMMIT; -- ---------------------------- -- Table structure for nideshop_attribute -- ---------------------------- DROP TABLE IF EXISTS `nideshop_attribute`; CREATE TABLE `nideshop_attribute` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `attribute_category_id` int(11) unsigned NOT NULL DEFAULT '0', `name` varchar(60) NOT NULL DEFAULT '', `input_type` tinyint(1) unsigned NOT NULL DEFAULT '1', `values` text NOT NULL, `sort_order` tinyint(3) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `cat_id` (`attribute_category_id`) ) ENGINE=InnoDB AUTO_INCREMENT=103 DEFAULT CHARSET=utf8mb4; -- ---------------------------- -- Records of nideshop_attribute -- ---------------------------- BEGIN; INSERT INTO `nideshop_attribute` VALUES (1, 1008009, '材质', 1, '', 0); INSERT INTO `nideshop_attribute` VALUES (2, 1008009, '适用床尺寸', 1, '', 0); INSERT INTO `nideshop_attribute` VALUES (3, 1008009, '件数', 1, '', 0); INSERT INTO `nideshop_attribute` VALUES (4, 1008009, '工艺', 1, '', 0); INSERT INTO `nideshop_attribute` VALUES (5, 1008009, '执行标准', 1, '', 0); INSERT INTO `nideshop_attribute` VALUES (6, 1008009, '产地', 1, '', 0); INSERT INTO `nideshop_attribute` VALUES (7, 1008009, '温馨提示', 1, '', 0); INSERT INTO `nideshop_attribute` VALUES (8, 1008008, '填充物重量', 1, '', 0); INSERT INTO `nideshop_attribute` VALUES (9, 1008008, '尺寸', 1, '', 0); INSERT INTO `nideshop_attribute` VALUES (10, 1008008, '面料', 1, '', 0); INSERT INTO `nideshop_attribute` VALUES (11, 1008008, '填充物', 1, '', 0); INSERT INTO `nideshop_attribute` VALUES (12, 1008008, '填充成分', 1, '', 0); INSERT INTO `nideshop_attribute` VALUES (13, 1008008, '面料成分', 1, '', 0); INSERT INTO `nideshop_attribute` VALUES (14, 1008008, '含绒量', 1, '', 0); INSERT INTO `nideshop_attribute` VALUES (15, 1008008, '重量', 1, '', 0); INSERT INTO `nideshop_attribute` VALUES (16, 1008002, '规格', 1, '', 0); INSERT INTO `nideshop_attribute` VALUES (17, 1008002, '外套材质', 1, '', 0); INSERT INTO `nideshop_attribute` VALUES (18, 1008002, '内胆材质', 1, '', 0); INSERT INTO `nideshop_attribute` VALUES (19, 1008002, '*温馨提示', 1, '', 0); INSERT INTO `nideshop_attribute` VALUES (20, 1036000, '安全技术', 1, '', 0); INSERT INTO `nideshop_attribute` VALUES (21, 1036000, '产品等级', 1, '', 0); INSERT INTO `nideshop_attribute` VALUES (22, 1008002, '面料成份', 1, '', 0); INSERT INTO `nideshop_attribute` VALUES (23, 1008002, '内芯面料', 1, '', 0); INSERT INTO `nideshop_attribute` VALUES (24, 1008008, '颜色', 1, '', 0); INSERT INTO `nideshop_attribute` VALUES (25, 1008008, '适用人数', 1, '', 0); INSERT INTO `nideshop_attribute` VALUES (26, 1008009, '安全类别', 1, '', 0); INSERT INTO `nideshop_attribute` VALUES (27, 1008009, '根数', 1, '', 0); INSERT INTO `nideshop_attribute` VALUES (28, 1036000, '安全技术类别', 1, '', 0); INSERT INTO `nideshop_attribute` VALUES (29, 1036000, '克重', 1, '', 0); INSERT INTO `nideshop_attribute` VALUES (30, 1008008, '外层面料', 1, '', 0); INSERT INTO `nideshop_attribute` VALUES (31, 1008008, '里层面料', 1, '', 0); INSERT INTO `nideshop_attribute` VALUES (32, 1008008, '内芯', 1, '', 0); INSERT INTO `nideshop_attribute` VALUES (33, 1008008, '外用面料', 1, '', 0); INSERT INTO `nideshop_attribute` VALUES (34, 1008008, '商品重量', 1, '', 0); INSERT INTO `nideshop_attribute` VALUES (35, 1008002, '坐垫外层面料', 1, '', 0); INSERT INTO `nideshop_attribute` VALUES (36, 1008002, '坐垫内芯材料', 1, '', 0); INSERT INTO `nideshop_attribute` VALUES (37, 1008002, '方形尺寸', 1, '', 0); INSERT INTO `nideshop_attribute` VALUES (38, 1008002, '圆形尺寸', 1, '', 0); INSERT INTO `nideshop_attribute` VALUES (39, 1008002, '坐垫套面料', 1, '', 0); INSERT INTO `nideshop_attribute` VALUES (40, 1008009, '安全及时', 1,