/*
Navicat MySQL Data Transfer
Source Server : weizai
Source Server Version : 50617
Source Host : localhost:3306
Source Database : shop
Target Server Type : MYSQL
Target Server Version : 50617
File Encoding : 65001
Date: 2017-04-19 17:39:30
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for sw_auth
-- ----------------------------
DROP TABLE IF EXISTS `sw_auth`;
CREATE TABLE `sw_auth` (
`auth_id` int(11) NOT NULL AUTO_INCREMENT,
`auth_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '权限名称',
`auth_pid` int(11) NOT NULL COMMENT '父ID',
`auth_c` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '控制器',
`auth_a` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '操作方法',
`auth_path` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '全路径',
`auth_level` int(11) NOT NULL DEFAULT '0' COMMENT '级别',
PRIMARY KEY (`auth_id`)
) ENGINE=InnoDB AUTO_INCREMENT=129 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of sw_auth
-- ----------------------------
INSERT INTO `sw_auth` VALUES ('100', '商品管理', '0', '', '', '100', '0');
INSERT INTO `sw_auth` VALUES ('101', '订单管理', '0', '', '', '101', '0');
INSERT INTO `sw_auth` VALUES ('102', '权限管理', '0', '', '', '102', '0');
INSERT INTO `sw_auth` VALUES ('103', '商品列表', '100', 'Goods', 'showlist', '100-103', '1');
INSERT INTO `sw_auth` VALUES ('104', '添加商品', '100', 'Goods', 'tianjia', '100-104', '1');
INSERT INTO `sw_auth` VALUES ('105', '商品分类', '100', 'Goods', 'category', '100-105', '1');
INSERT INTO `sw_auth` VALUES ('106', '订单列表', '101', 'Order', 'showlist', '101-106', '1');
INSERT INTO `sw_auth` VALUES ('107', '订单查询', '101', 'Order', 'queryorders', '101-107', '1');
INSERT INTO `sw_auth` VALUES ('108', '订单打印', '101', 'Order', 'printorders', '101-108', '1');
INSERT INTO `sw_auth` VALUES ('109', '管理员列表', '102', 'Manager', 'showlist', '102-109', '1');
INSERT INTO `sw_auth` VALUES ('110', '角色列表', '102', 'Role', 'showlist', '102-110', '1');
INSERT INTO `sw_auth` VALUES ('111', '权限列表', '102', 'Auth', 'showlist', '102-111', '1');
INSERT INTO `sw_auth` VALUES ('127', '会员管理', '0', '', '', '127', '0');
INSERT INTO `sw_auth` VALUES ('128', '会员列表', '127', 'User', 'showlist', '127-128', '1');
-- ----------------------------
-- Table structure for sw_goods
-- ----------------------------
DROP TABLE IF EXISTS `sw_goods`;
CREATE TABLE `sw_goods` (
`goods_id` int(11) NOT NULL AUTO_INCREMENT,
`goods_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`goods_weight` int(11) NOT NULL,
`goods_price` decimal(10,2) NOT NULL,
`goods_number` int(11) NOT NULL,
`goods_category_id` int(11) NOT NULL,
`goods_brand_id` int(11) NOT NULL,
`goods_introduce` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`goods_big_img` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`goods_small_img` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`goods_create_time` int(11) NOT NULL,
`goods_last_time` int(11) NOT NULL,
PRIMARY KEY (`goods_id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of sw_goods
-- ----------------------------
INSERT INTO `sw_goods` VALUES ('1', 'nokia', '100', '2300.00', '10', '34', '45', 0x616161616161616161616161616161616161616161616161, 'bbbbbbbbbb', 'bbbbbbbbbb', '1', '2');
INSERT INTO `sw_goods` VALUES ('2', 'aaa', '12', '12.23', '23', '34', '45', 0x616161616161616161616161616161616161616161616161, 'bbbbbbbbbb', 'bbbbbbbbbb', '1', '2');
INSERT INTO `sw_goods` VALUES ('3', 'htc', '120', '1200.00', '6', '0', '0', '', '', '', '0', '0');
INSERT INTO `sw_goods` VALUES ('5', 'nokia', '100', '2300.00', '10', '0', '0', 0x373737, '', '', '0', '0');
INSERT INTO `sw_goods` VALUES ('6', 'htc3.0', '90', '1499.00', '25', '0', '0', 0x7065726665637421212121, '', '', '0', '0');
INSERT INTO `sw_goods` VALUES ('7', 'huawei1.0', '99', '999.00', '12', '0', '0', 0x6A75737420736F20736F21, '', '', '0', '0');
INSERT INTO `sw_goods` VALUES ('10', '', '0', '0.00', '0', '0', '0', '', './Public/uploads/2016-11-21/58326a027b202.jpg', '', '0', '0');
INSERT INTO `sw_goods` VALUES ('11', '', '0', '0.00', '0', '0', '0', '', './Public/uploads/2016-11-21/5832ca77ce785.jpg', '', '0', '0');
INSERT INTO `sw_goods` VALUES ('12', '', '0', '0.00', '0', '0', '0', '', './Public/uploads/2016-11-21/5832cb7037a43.jpg', './Public/uploads/2016-11-21/small_5832cb7037a43.jpg', '0', '0');
INSERT INTO `sw_goods` VALUES ('13', 'samsung6P', '180', '5000.00', '20', '0', '0', '', '', '', '0', '0');
INSERT INTO `sw_goods` VALUES ('14', 'IPhone6P', '110', '5299.00', '0', '0', '0', '', '', '', '0', '0');
INSERT INTO `sw_goods` VALUES ('15', 'htc', '120', '1000.00', '0', '0', '0', 0x7665727920676F6F64, '', '', '0', '0');
INSERT INTO `sw_goods` VALUES ('16', 'huawei', '150', '1299.00', '0', '0', '0', 0x6A75737420736F20736F, '', '', '0', '0');
INSERT INTO `sw_goods` VALUES ('17', '想要吗?', '160', '12000.00', '0', '0', '0', 0xE4B88DE7BB99E4BDA0E593A6, 'Public/Uploads/2017-04-09/58ea419619daf.jpg', 'Public/Uploads/2017-04-09/small_58ea419619daf.jpg', '0', '0');
INSERT INTO `sw_goods` VALUES ('18', 'meizu4x', '120', '1999.00', '0', '0', '0', 0x6D65697A756B616F6C61, 'Public/Uploads/2017-04-15/58f21b539273b.jpg', 'Public/Uploads/2017-04-15/small_58f21b539273b.jpg', '0', '0');
-- ----------------------------
-- Table structure for sw_manager
-- ----------------------------
DROP TABLE IF EXISTS `sw_manager`;
CREATE TABLE `sw_manager` (
`mg_id` int(11) NOT NULL AUTO_INCREMENT,
`mg_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`mg_pwd` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`mg_time` int(11) NOT NULL,
`mg_role_id` int(11) NOT NULL,
PRIMARY KEY (`mg_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of sw_manager
-- ----------------------------
INSERT INTO `sw_manager` VALUES ('1', 'xiaowei', '1234', '7126487', '10');
INSERT INTO `sw_manager` VALUES ('2', 'xiaomei', '123456', '1234784', '11');
INSERT INTO `sw_manager` VALUES ('3', 'admin', 'admin', '541566', '0');
-- ----------------------------
-- Table structure for sw_role
-- ----------------------------
DROP TABLE IF EXISTS `sw_role`;
CREATE TABLE `sw_role` (
`role_id` int(11) NOT NULL AUTO_INCREMENT,
`role_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`role_auth_ids` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`role_auth_ac` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
PRIMARY KEY (`role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of sw_role
-- ----------------------------
INSERT INTO `sw_role` VALUES ('10', '主管', '100,103,104,105,101,106,107,108', 0x476F6F64732D73686F776C6973742C476F6F64732D7469616E6A69612C476F6F64732D63617465676F72792C4F726465722D73686F776C6973742C4F726465722D71756572796F72646572732C4F726465722D7072696E746F7264657273);
INSERT INTO `sw_role` VALUES ('11', '经理', '100,104,101,106,107,108', 0x476F6F64732D7469616E6A69612C4F726465722D73686F776C6973742C4F726465722D71756572796F72646572732C4F726465722D7072696E746F7264657273);
-- ----------------------------
-- Table structure for sw_user
-- ----------------------------
DROP TABLE IF EXISTS `sw_user`;
CREATE TABLE `sw_user` (
`user_id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`password` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`user_email` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`user_sex` int(11) NOT N