ThinkPhp5.0电商源码（前端，后端）

/* Navicat MySQL Data Transfer Source Server : 127.0.0.1 Source Server Version : 50617 Source Host : localhost:3306 Source Database : tp5 Target Server Type : MYSQL Target Server Version : 50617 File Encoding : 65001 Date: 2016-06-12 09:19:01 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for admin_user -- ---------------------------- DROP TABLE IF EXISTS `admin_user`; CREATE TABLE `admin_user` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `admin_name` varchar(255) DEFAULT NULL, `admin_password` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `index_admin_name` (`admin_name`) USING BTREE, UNIQUE KEY `index_admin_password` (`admin_password`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of admin_user -- ---------------------------- INSERT INTO `admin_user` VALUES ('2', 'admin', '21232f297a57a5a743894a0e4a801fc3'); INSERT INTO `admin_user` VALUES ('3', 'root', '63a9f0ea7bb98050796b649e85481845'); -- ---------------------------- -- Table structure for auth_group -- ---------------------------- DROP TABLE IF EXISTS `auth_group`; CREATE TABLE `auth_group` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `title` char(100) NOT NULL DEFAULT '', `status` tinyint(1) NOT NULL DEFAULT '1', `rules` char(80) NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of auth_group -- ---------------------------- INSERT INTO `auth_group` VALUES ('3', '管理员管理', '1', '3'); INSERT INTO `auth_group` VALUES ('2', '商品管理员', '1', '2,4,5'); -- ---------------------------- -- Table structure for auth_group_access -- ---------------------------- DROP TABLE IF EXISTS `auth_group_access`; CREATE TABLE `auth_group_access` ( `uid` mediumint(8) unsigned NOT NULL, `group_id` mediumint(8) unsigned NOT NULL, UNIQUE KEY `uid_group_id` (`uid`,`group_id`), KEY `uid` (`uid`), KEY `group_id` (`group_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of auth_group_access -- ---------------------------- INSERT INTO `auth_group_access` VALUES ('1', '1'); INSERT INTO `auth_group_access` VALUES ('2', '2'); INSERT INTO `auth_group_access` VALUES ('3', '3'); -- ---------------------------- -- Table structure for auth_rule -- ---------------------------- DROP TABLE IF EXISTS `auth_rule`; CREATE TABLE `auth_rule` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `name` char(80) NOT NULL DEFAULT '', `title` char(20) NOT NULL DEFAULT '', `type` tinyint(1) NOT NULL DEFAULT '1', `status` tinyint(1) NOT NULL DEFAULT '1', `condition` char(100) NOT NULL DEFAULT '', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of auth_rule -- ---------------------------- INSERT INTO `auth_rule` VALUES ('3', 'index/users/admin_list', '管理员管理', '1', '1', ''); INSERT INTO `auth_rule` VALUES ('2', 'index/goods/product_category_add', '分类的添加', '1', '1', ''); INSERT INTO `auth_rule` VALUES ('4', 'index/index/index', '首页', '1', '1', ''); INSERT INTO `auth_rule` VALUES ('5', 'index/index/welcome', '欢迎页', '1', '1', ''); -- ---------------------------- -- Table structure for goods -- ---------------------------- DROP TABLE IF EXISTS `goods`; CREATE TABLE `goods` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '商品自增id', `goodsname` varchar(255) DEFAULT NULL COMMENT '商品的名字', `tid` int(11) DEFAULT NULL COMMENT '分类id', `tpid` int(255) DEFAULT NULL COMMENT '分类路径', `unit` char(255) DEFAULT NULL COMMENT '商品的单位', `attributes` enum('7','6','5','4','3','2','1') DEFAULT NULL COMMENT '商品的属性,1、推荐 2、新上 3、热卖 4、促销 5、包邮 6、限时卖 7、不参与会员折扣', `imagepath` varchar(255) DEFAULT NULL COMMENT '商品图片id', `number` int(11) DEFAULT NULL COMMENT '商品编号', `barcode` int(255) DEFAULT NULL COMMENT '条形码', `curprice` int(11) DEFAULT NULL COMMENT '现价', `oriprice` int(11) DEFAULT NULL COMMENT '市场价', `cosprice` int(11) DEFAULT NULL COMMENT '成本价', `inventory` int(255) DEFAULT NULL COMMENT '库存量', `restrict` int(255) DEFAULT NULL COMMENT '限制购买量', `already` int(255) DEFAULT NULL COMMENT '已经购买量', `freight` int(255) DEFAULT NULL COMMENT '运费', `status` enum('1','0') DEFAULT NULL COMMENT '是否上架,0为上架,1为下架,默认0上架', `reorder` int(255) DEFAULT NULL, `text` text, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of goods -- ---------------------------- INSERT INTO `goods` VALUES ('3', '芭蒂娜2015欧洲站秋季新品 拼接长袖印花秋装a字连衣裙 修身显瘦', '25', '20', '件', '1', '162,160,161,159', '0', '529', '529', '529', '529', '529', '529', '529', '529', '0', '22', '<ul id=\"\" style=\"padding: 0px; width: 1150px;\" class=\" list-paddingleft-2\"><li><p>品牌：&nbsp;芬迪/FENDI</p></li><li><p>货号：&nbsp;6534105100</p></li><li><p>主要材质：&nbsp;涤纶</p></li><li><p>裙长：&nbsp;短裙</p></li><li><p>裙摆：&nbsp;不对称</p></li><li><p>领型：&nbsp;圆领</p></li><li><p>袖型：&nbsp;短袖</p></li><li><p>款式：&nbsp;吊带</p></li><li><p>版型：&nbsp;修身型</p></li><li><p>上市时间：&nbsp;2016年</p></li></ul><p style=\"margin: 0px auto; padding: 0px; border: 0px; outline: 0px; font-weight: inherit; font-style: inherit; font-family: inherit; vertical-align: baseline;\"><img class=\"lazy\" data-original=\"http://malliccdn.baidu.com/https%3A//img.alicdn.com/imgextra/i2/854153843/TB2ZBiAepXXXXaaXXXXXXXXXXXX-854153843.jpg\" align=\"absmiddle\" src=\"http://malliccdn.baidu.com/https%3A//img.alicdn.com/imgextra/i2/854153843/TB2ZBiAepXXXXaaXXXXXXXXXXXX-854153843.jpg\" style=\"border: 0px; padding: 0px; margin: 0px auto; outline: 0px; font-weight: inherit; font-style: inherit; font-family: inherit; vertical-align: bottom; max-width: 790px; display: inline;\"/><img class=\"lazy\" data-original=\"http://malliccdn.baidu.com/https%3A//img.alicdn.com/imgextra/i4/854153843/TB22U1fepXXXXbjXpXXXXXXXXXX-854153843.jpg\" align=\"absmiddle\" src=\"http://malliccdn.baidu.com/https%3A//img.alicdn.com/imgextra/i4/854153843/TB22U1fepXXXXbjXpXXXXXXXXXX-854153843.jpg\" style=\"border: 0px; padding: 0px; margin: 0px auto; outline: 0px; font-weight: inherit; font-style: inherit; font-family: inherit; vertical-align: bottom; max-width: 790px; display: inline;\"/></p><p style=\"margin: 0px auto; padding: 0px; border: 0px; outline: 0px; font-weight: inherit; font-style: inherit; font-family: inherit; vertical-align: baseline;\"><img class=\"lazy\" align=\"absmiddle\" data-original=\"http://malliccdn.baidu.com/https%3A//img.alicdn.com/imgextra/i1/854153843/TB28YeGepXXXXXfXXXXXXXXXXXX-854153843.jpg\" src=\"http://malliccdn.baidu.com/https%3A//img.alicdn.com/imgextra/i1/854153843/TB28YeGepXXXXXfXXXXXXXXXXXX-854153843.jpg\" style=\"border: 0px; padding: 0px; margin: 0px auto; outline: 0px; font-weight: inherit; font-style: inherit; font-family: inherit; vertical-align: bottom; max-width: 790px; display: inline;\"/><img class=\"lazy\" align=\"absmiddle\" data-original=\"http://malliccdn.baidu.com/https%3A//img.alicdn.com/imgextra/i3/854153843/TB2uqpzeVXXXXcXXXXXXXXXXXXX-854153843.jpg\" src=\"http://malliccdn.baidu.com/https%3A//img.alicdn.com/imgextra/i3/854153843/TB2uqpzeVXXXXcXXXXXXXXXXXXX-854153843.jpg\" style=\"border: 0px; padding: 0px; margin: 0px auto; outline: 0px; font-weight: inherit; font-style: inherit; font-family: inherit; vertical-align: bottom; max-width: 790px; displ