wms.sql

/*
Navicat MySQL Data Transfer

Source Server         : mysql
Source Server Version : 50617
Source Host           : localhost:3306
Source Database       : wms

Target Server Type    : MYSQL
Target Server Version : 50617
File Encoding         : 65001

Date: 2016-08-07 09:54:10
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `wms_access`
-- ----------------------------
DROP TABLE IF EXISTS `wms_access`;
CREATE TABLE `wms_access` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主id',
  `role_id` smallint(6) unsigned NOT NULL COMMENT '角色id',
  `node_id` smallint(6) unsigned NOT NULL COMMENT '节点id',
  `level` tinyint(1) NOT NULL COMMENT '级别',
  `pid` smallint(6) DEFAULT NULL COMMENT '父id',
  `module` varchar(50) DEFAULT NULL COMMENT '模块',
  PRIMARY KEY (`id`),
  KEY `idx_role_id` (`role_id`),
  KEY `idx_node_id` (`node_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='权限分配';

-- ----------------------------
-- Records of wms_access
-- ----------------------------

-- ----------------------------
-- Table structure for `wms_ad`
-- ----------------------------
DROP TABLE IF EXISTS `wms_ad`;
CREATE TABLE `wms_ad` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主id',
  `name` varchar(40) NOT NULL DEFAULT '' COMMENT '广告位名称',
  `mark` varchar(30) NOT NULL DEFAULT '' COMMENT '广告位标识',
  `platform` tinyint(1) NOT NULL DEFAULT '0' COMMENT '设备平台[见配置文件]',
  `ad_type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1=代码2=文字3=图片',
  `time_limit` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '1=永不过期2=时间限制',
  `start_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '开始时间',
  `end_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '结束时间',
  `normal_content` text NOT NULL COMMENT '正常显示内容',
  `overdue_content` text NOT NULL COMMENT '过期显示内容',
  `status` tinyint(1) DEFAULT '1' COMMENT '1为可用 2为禁用',
  `is_deleted` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1=正常 2=删除',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `idx_time_limit` (`time_limit`),
  KEY `idx_mark` (`mark`),
  KEY `idx_start_time` (`start_time`),
  KEY `idx_end_time` (`end_time`),
  KEY `idx_status` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='广告';

-- ----------------------------
-- Records of wms_ad
-- ----------------------------

-- ----------------------------
-- Table structure for `wms_admin`
-- ----------------------------
DROP TABLE IF EXISTS `wms_admin`;
CREATE TABLE `wms_admin` (
  `id` mediumint(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `nickname` varchar(16) DEFAULT NULL COMMENT '昵称',
  `username` varchar(16) NOT NULL COMMENT '用户名',
  `password` varchar(32) NOT NULL COMMENT '密码',
  `tel` varchar(15) DEFAULT NULL,
  `email` varchar(15) DEFAULT NULL,
  `create_time` int(11) unsigned NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `nickname` (`nickname`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8 COMMENT='用户表';

-- ----------------------------
-- Records of wms_admin
-- ----------------------------
INSERT INTO `wms_admin` VALUES ('1', '布尔', 'bool', 'c506ff134babdd6e68ab3e6350e95305', '18101565685', '30024167@qq.com', '1475662263');
INSERT INTO `wms_admin` VALUES ('32', 'test', 'test', '098f6bcd4621d373cade4e832627b4f6', '222000', '200@qq.com', '1461049869');
INSERT INTO `wms_admin` VALUES ('33', 'admin', 'admin', 'd9b1d7db4cd6e70935368a1efb10e377', '11', '111@qq.com', '1461204870');

-- ----------------------------
-- Table structure for `wms_admin_role`
-- ----------------------------
DROP TABLE IF EXISTS `wms_admin_role`;
CREATE TABLE `wms_admin_role` (
  `role_id` mediumint(12) unsigned NOT NULL COMMENT '角色id',
  `admin_id` mediumint(12) unsigned NOT NULL COMMENT '用户id',
  KEY `role_id` (`role_id`),
  KEY `admin_id` (`admin_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of wms_admin_role
-- ----------------------------
INSERT INTO `wms_admin_role` VALUES ('1', '33');
INSERT INTO `wms_admin_role` VALUES ('7', '33');
INSERT INTO `wms_admin_role` VALUES ('1', '1');
INSERT INTO `wms_admin_role` VALUES ('7', '32');
INSERT INTO `wms_admin_role` VALUES ('10', '32');

-- ----------------------------
-- Table structure for `wms_attribute`
-- ----------------------------
DROP TABLE IF EXISTS `wms_attribute`;
CREATE TABLE `wms_attribute` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL,
  `type` enum('range','number','radio','file','checkbox','button','week','time','date','password','text','email','url','month','tel','search','select','color') DEFAULT 'text',
  `content` varchar(200) DEFAULT NULL,
  `note` varchar(200) DEFAULT NULL,
  `time` int(11) unsigned DEFAULT NULL,
  `status` tinyint(1) unsigned DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of wms_attribute
-- ----------------------------
INSERT INTO `wms_attribute` VALUES ('28', '号码', 'checkbox', '34,35,36,37,38,39,40,41,42,43,44,45,46', '鞋子号码', '1461557423', '0');
INSERT INTO `wms_attribute` VALUES ('29', '颜色', 'checkbox', '白色,黑色,蓝色,绿色,紫色,红色,天蓝色', '鞋子颜色', '1461557664', '0');
INSERT INTO `wms_attribute` VALUES ('31', '出厂日期', 'date', '', '出厂日期', '1461571851', '0');
INSERT INTO `wms_attribute` VALUES ('32', '号码', 'checkbox', 'XS,S,M,L,XL,XXL,XXXL', '衣服尺寸', '1461808173', '0');
INSERT INTO `wms_attribute` VALUES ('33', '颜色', 'checkbox', '白色,黑色,蓝色,绿色,紫色,红色,天蓝色', '衣服', '1461831605', '0');
INSERT INTO `wms_attribute` VALUES ('34', '季节', 'select', '春秋,夏季,冬季', '鞋子季节', '1461831862', '0');
INSERT INTO `wms_attribute` VALUES ('35', '材质', 'text', '', '鞋子的材质', '1461831994', '0');
INSERT INTO `wms_attribute` VALUES ('36', '款式', 'select', '商务,休闲,运动,韩版,英伦', '鞋子款式', '1461832335', '0');
INSERT INTO `wms_attribute` VALUES ('37', '适用对象', 'select', '儿童(6-18),青年(18-25周岁),中年(26-40),中老年(40-50),老年(50以上)', '鞋子适用对象', '1461832510', '1');
INSERT INTO `wms_attribute` VALUES ('38', '闭合方式', 'select', '系带,拉链', '鞋子闭合方式', '1461832716', '1');
INSERT INTO `wms_attribute` VALUES ('39', '鞋跟', 'select', '平底,中跟,高跟,内增高', '鞋子鞋跟样式', '1461832801', '0');

-- ----------------------------
-- Table structure for `wms_brand`
-- ----------------------------
DROP TABLE IF EXISTS `wms_brand`;
CREATE TABLE `wms_brand` (
  `id` mediumint(9) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(40) DEFAULT NULL,
  `time` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='品牌表';

-- ----------------------------
-- Records of wms_brand
-- ----------------------------
INSERT INTO `wms_brand` VALUES ('1', 'XTEP/特步', '1461312069');
INSERT INTO `wms_brand` VALUES ('2', '耐克NIKE', '1461312183');
INSERT INTO `wms_brand` VALUES ('3', 'ANTA/安踏', '1461312192');
INSERT INTO `wms_brand` VALUES ('4', '贵人鸟', '1461312200');
INSERT INTO `wms_brand` VALUES ('5', '李宁', '1461312246');
INSERT INTO `wms_brand` VALUES ('6', '乔丹', '1461312252');
INSERT INTO `wms_brand` VALUES ('7', 'erke/鸿星尔克', '1461312267');
INSERT INTO `wms_brand` VALUES ('8', '阿迪达斯', '1461312279');
INSERT INTO `wms_brand` VALUES ('9', '361°', '1461312279');

-- ----------------------------
-- Table structure for `wms_category`
-- ----------------------------
DROP TABLE IF EXISTS `wms_category`;
CREATE TABLE `wms_category` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(40) NOT NULL,
  `time` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='商品分类';

-- ----------------------------
-- Records of wms_category
-- ----------------------------
INSERT INTO `wms_category` VALUES ('1', '鞋子', '1461307800');
INSERT INTO `wms_category` VALUES ('2', '衣服', '1461307877');
INSERT INTO `wms_category` VALUES ('3', '袜子', '1461207877');
INSERT INTO `wms_category` VALUES ('4', '男鞋', '1461310483');
INSERT INTO `wms_category` VALUES ('5', '女鞋', '1461310492');
INSERT INTO `wms_category` VALUES ('6', '运动鞋', '1461310561');
INSERT INTO `wms_category` VALUES ('7', '休闲鞋', '1461310572');
INSERT INTO `wms_category` VALUES ('8', '帆布鞋', '1461310686');
INSERT INTO `wms_category` VALUES ('9', '皮鞋', '1461310759');

-- ----------------------------
-- Table structure for `wms_category_attribute`
-- ----------------------------
DROP TABLE IF EXISTS `wms_category_attribute`;
CREATE TABLE `wms_category_attribute` (
  `category_id` mediumint(12) unsigned NOT NULL COMMENT '鍟嗗搧id',
  `attribute_id` mediumint(12) unsigned NOT NULL COMMENT '灞炴€d'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of wms_category_attribute
-- ----------------------------
INSERT INTO `wms_category_attribute` VALUES ('1', '28');
INSERT INTO `wms_category_attribute` VALUES ('1', '29');
INSERT INTO `wms_category_attribute` VALUES ('4', '30');
INSERT INTO `wms_category_attribute` VALUES ('1', '31');
INSERT INTO `wms_category_attribute` VALUES ('2', '32');
INSERT INTO `wms_category_attribute` VALUES ('2', '33');
INSERT INTO `wms_category_attribute` VALUES ('1', '34');
INSERT INTO `wms_category_attribute` VALUES ('1', '35');
INSERT INTO `wms_category_attribute` VALUES ('1', '36');
INSERT INTO `wms_category_attribute` VALUES ('1', '37');
INSERT INTO `wms_category_attribute` VALUES ('1', '38');
INSERT INTO `wms_category_attribute` VALUES ('1', '39');

-- ----------------------------
-- Table structure for `wms_config`
-- ----------------------------
DROP TABLE IF EXISTS `wms_config`;
CREATE TABLE `wms_config` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键递增',
  `field_name` varchar(30) NOT NULL DEFAULT '' COMMENT '字段名称',
  `field_value` varchar(150) NOT NULL DEFAULT '' COMMENT '字段内容',
  `field_desc` varchar(30) NOT NULL DEFAULT '' COMMENT '字段描述',
  `type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '类型',
  `atta_type` tinyint(1) NOT NULL DEFAULT '2' COMMENT '1=有附件2=无',
  `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `idx_filed_name` (`field_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='网站配置';

-- ----------------------------
-- Records of wms_config
-- ----------------------------

-- ----------------------------
-- Table structure for `wms_depot`
-- ----------------------------
DROP TABLE IF EXISTS `wms_depot`;
CREATE TABLE `wms_depot` (
  `id` mediumint(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(60) NOT NULL COMMENT '仓库名称',
  `time` int(11) unsigned NOT NULL COMMENT '时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='仓库表';

-- ----------------------------
-- Records of wms_depot
-- ----------------------------

-- ----------------------------
-- Table structure for `wms_depot_store`
-- ----------------------------
DROP TABLE IF EXISTS `wms_depot_store`;
CREATE TABLE `wms_depot_store` (
  `depot_id` mediumint(12) unsigned NOT NULL COMMENT '仓库id',
  `store_id` mediumint(12) unsigned NOT NULL COMMENT '门店id',
  KEY `depot_id` (`depot_id`),
  KEY `store_id` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='仓库';

-- ----------------------------
-- Records of wms_depot_store
-- ----------------------------

-- ----------------------------
-- Table structure for `wms_goods`
-- ----------------------------
DROP TABLE IF EXISTS `wms_goods`;
CREATE TABLE `wms_goods` (
  `id` mediumint(12) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `sn` varchar(60) NOT NULL COMMENT 'sn',
  `name` varchar(60) NOT NULL COMMENT '名称',
  `brand_id` mediumint(9) unsigned NOT NULL COMMENT '品牌id',
  `time` int(11) unsigned DEFAULT NULL COMMENT '时间',
  `price` decimal(10,2) DEFAULT NULL,
  `sum` mediumint(12) unsigned DEFAULT NULL,
  `total` decimal(12,2) unsigned DEFAULT NULL,
  `store_id` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `sn` (`sn`) USING BTREE,
  KEY `brand_id` (`brand_id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of wms_goods
-- ----------------------------
INSERT INTO `wms_goods` VALUES ('1', '001', '特步01', '3', '1461576497', '20.00', '190', '3800.00', '1');
INSERT INTO `wms_goods` VALUES ('2', '002', '特步02', '1', '1461576854', '60.00', '20', '1200.00', null);
INSERT INTO `wms_goods` VALUES ('3', '003', '衣服', '1', '1461810099', '99.00', '11', '1089.00', '3');
INSERT INTO `wms_goods` VALUES ('4', '004', '贵人鸟鞋子', '4', '1462258269', '120.00', '30', '3600.00', null);
INSERT INTO `wms_goods` VALUES ('6', '005', '特步衣服', '1', '1462258724', '80.00', '50', '4000.00', null);
INSERT INTO `wms_goods` VALUES ('7', '006', '李宁', '5', '1462335589', '30.00', '80', '2400.00', null);
INSERT INTO `wms_goods` VALUES ('8', '007', '贵人鸟衣服', '4', '1462335911', '20.00', '50', '1000.00', null);
INSERT INTO `wms_goods` VALUES ('9', '008', 'bool', '1', '1462351559', '50.00', '50', '2500.00', null);
INSERT INTO `wms_goods` VALUES ('10', '009', '111', '1', '1462353852', '20.00', '100', '2000.00', null);
INSERT INTO `wms_goods` VALUES ('11', '0010', 'slaon', '7', '1462354174', '60.00', '50', '3000.00', null);
INSERT INTO `wms_goods` VALUES ('12', '0011', '测试', '1', '1462409831', '100.00', '140', '14000.00', null);
INSERT INTO `wms_goods` VALUES ('13', '0012', 'is_test', '1', '1462412320', '100.00', '40', '4000.00', null);
INSERT INTO `wms_goods` VALUES ('14', '0013', 'is bool', '1', '1462412576', '150.00', '180', '27000.00', null);
INSERT INTO `wms_goods` VALUES ('15', '0014', '搜索', '1', '1462412825', '160.00', '50', '8000.00', null);
INSERT INTO `wms_goods` VALUES ('16', '0015', '测试数据', '1', '1462413110', '39.00', '77', '3003.00', '2');
INSERT INTO `wms_goods` VALUES ('17', '0016', 'Haley', '1', '1462424710', '30.00', '158', '4740.00', null);
INSERT INTO `wms_goods` VALUES ('18', '0071', '1111二个', '4', '1462516379', '30.00', '10', '300.00', '2');

-- ----------------------------
-- Table structure for `wms_goods_attrbute`
-- ----------------------------
DROP TABLE IF EXISTS `wms_goods_attrbute`;
CREATE TABLE `wms_goods_attrbute` (
  `goods_id` mediumint(9) unsigned DEFAULT NULL,
  `attrbute_id` mediumint(9) unsigned DEFAULT NULL,
  `attrbute_value` varchar(50) DEFAULT NULL,
  `price` decimal(10,2) unsigned DEFAULT NULL,
  `count` mediumint(12) unsigned DEFAULT NULL,
  `val` varchar(30) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of wms_goods_attrbute
-- ----------------------------
INSERT INTO `wms_goods_attrbute` VALUES ('11', '0', 'XS:白色 ', '60.00', '9', null);
INSERT INTO `wms_goods_attrbute` VALUES ('11', '0', 'M:白色 ', '60.00', '30', null);
INSERT INTO `wms_goods_attrbute` VALUES ('2', '39', null, null, null, '中跟');
INSERT INTO `wms_goods_attrbute` VALUES ('2', '36', null, null, null, '韩版');
INSERT INTO `wms_goods_attrbute` VALUES ('2', '35', null, null, null, '棉布');
INSERT INTO `wms_goods_attrbute` VALUES ('2', '34', null, null, null, '春秋');
INSERT INTO `wms_goods_attrbute` VALUES ('2', '31', null, null, null, '2016-05-02');
INSERT INTO `wms_goods_attrbute` VALUES ('2', '0', '40:白色 ', '60.00', '19', null);
INSERT INTO `wms_goods_attrbute` VALUES ('4', '0', '40:白色 ', '120.00', '19', null);
INSERT INTO `wms_goods_attrbute` VALUES ('4', '0', '40:蓝色 ', '120.00', '10', null);
INSERT INTO `wms_goods_attrbute` VALUES ('4', '39', null, null, null, '平底');
INSERT INTO `wms_goods_attrbute` VALUES ('4', '36', null, null, null, '商务');
INSERT INTO `wms_goods_attrbute` VALUES ('4', '35', null, null, null, '皮革');
INSERT INTO `wms_goods_attrbute` VALUES ('4', '34', null, null, null, '春秋');
INSERT INTO `wms_goods_attrbute` VALUES ('4', '31', null, null, null, '2016-05-05');
INSERT INTO `wms_goods_attrbute` VALUES ('6', '0', 'M:白色 ', '80.00', '30', null);
INSERT INTO `wms_goods_attrbute` VALUES ('6', '0', 'M:黑色 ', '60.00', '20', null);
INSERT INTO `wms_goods_attrbute` VALUES ('8', '0', 'M:蓝色 ', '20.00', '19', null);
INSERT INTO `wms_goods_attrbute` VALUES ('8', '0', 'L:蓝色 ', '30.00', '19', null);
INSERT INTO `wms_goods_attrbute` VALUES ('7', '0', '40:白色 ', '30.00', '19', null);
INSERT INTO `wms_goods_attrbute` VALUES ('7', '0', '41:白色 ', '30.00', '30', null);
INSERT INTO `wms_goods_attrbute` VALUES ('7', '0', '42:白色 ', '30.00', '38', null);
INSERT INTO `wms_goods_attrbute` VALUES ('7', '39', null, null, null, '平底');
INSERT INTO `wms_goods_attrbute` VALUES ('7', '36', null, null, null, '商务');
INSERT INTO `wms_goods_attrbute` VALUES ('7', '35', null, null, null, '皮革');
INSERT INTO `wms_goods_attrbute` VALUES ('7', '34', null, null, null, '夏季');
INSERT INTO `wms_goods_attrbute` VALUES ('7', '31', null, null, null, '2016-05-03');
INSERT INTO `wms_goods_attrbute` VALUES ('15', '0', '40:白色 ', '160.00', '19', null);
INSERT INTO `wms_goods_attrbute` VALUES ('15', '0', '41:白色 ', '160.00', '30', null);
INSERT INTO `wms_goods_attrbute` VALUES ('15', '39', null, null, null, '平底');
INSERT INTO `wms_goods_attrbute` VALUES ('15', '36', null, null, null, '商务');
INSERT INTO `wms_goods_attrbute` VALUES ('15', '35', null, null, null, '漆皮PU');
INSERT INTO `wms_goods_attrbute` VALUES ('15', '34', null, null, null, '春秋');
INSERT INTO `wms_goods_attrbute` VALUES ('15', '31', null, null, null, '2016-05-06');
INSERT INTO `wms_goods_attrbute` VALUES ('14', '0', '34:白色 ', '34.00', '20', null);
INSERT INTO `wms_goods_attrbute` VALUES ('14', '0', '34:黑色 ', '34.00', '30', null);
INSERT INTO `wms_goods_attrbute` VALUES ('14', '0', '34:蓝色 ', '34.00', '34', null);
INSERT INTO `wms_goods_attrbute` VALUES ('14', '0', '35:白色 ', '35.00', '40', null);
INSERT INTO `wms_goods_attrbute` VALUES ('14', '0', '35:黑色 ', '35.00', '48', null);
INSERT INTO `wms_goods_attrbute` VALUES ('14', '0', '35:蓝色 ', '35.00', '35', null);
INSERT INTO `wms_goods_attrbute` VALUES ('14', '0', '36:白色 ', '36.00', '36', null);
INSERT INTO `wms_goods_attrbute` VALUES ('14', '0', '36:黑色 ', '36.00', '36', null);
INSERT INTO `wms_goods_attrbute` VALUES ('14', '0', '36:蓝色 ', '36.00', '36', null);
INSERT INTO `wms_goods_attrbute` VALUES ('14', '39', null, null, null, '平底');
INSERT INTO `wms_goods_attrbute` VALUES ('14', '36', null, null, null, '商务');
INSERT INTO `wms_goods_attrbute` VALUES ('14', '35', null, null, null, 'PU');
INSERT INTO `wms_goods_attrbute` VALUES ('14', '34', null, null, null, '春秋');
INSERT INTO `wms_goods_attrbute` VALUES ('14', '31', null, null, null, '2016-05-05');
INSERT INTO `wms_goods_attrbute` VALUES ('13', '0', '34:白色 ', '100.00', '20', null);
INSERT INTO `wms_goods_attrbute` VALUES ('13', '0', '34:黑色 ', '100.00', '30', null);
INSERT INTO `wms_goods_attrbute` VALUES ('13', '39', null, null, null, '平底');
INSERT INTO `wms_goods_attrbute` VALUES ('13', '36', null, null, null, '商务');
INSERT INTO `wms_goods_attrbute` VALUES ('13', '35', null, null, null, '帆布');
INSERT INTO `wms_goods_attrbute` VALUES ('13', '34', null, null, null, '春秋');
INSERT INTO `wms_goods_attrbute` VALUES ('13', '31', null, null, null, '2016-05-06');
INSERT INTO `wms_goods_attrbute` VALUES ('12', '0', '34:白色 ', '100.00', '20', null);
INSERT INTO `wms_goods_attrbute` VALUES ('12', '0', '34:黑色 ', '100.00', '30', null);
INSERT INTO `wms_goods_attrbute` VALUES ('12', '0', '35:白色 ', '100.00', '40', null);
INSERT INTO `wms_goods_attrbute` VALUES ('12', '0', '35:黑色 ', '100.00', '48', null);
INSERT INTO `wms_goods_attrbute` VALUES ('12', '39', null, null, null, '平底');
INSERT INTO `wms_goods_attrbute` VALUES ('12', '36', null, null, null, '商务');
INSERT INTO `wms_goods_attrbute` VALUES ('12', '35', null, null, null, '橡胶');
INSERT INTO `wms_goods_attrbute` VALUES ('12', '34', null, null, null, '夏季');
INSERT INTO `wms_goods_attrbute` VALUES ('12', '31', null, null, null, '2016-05-03');
INSERT INTO `wms_goods_attrbute` VALUES ('9', '0', '34:白色 ', '50.00', '20', null);
INSERT INTO `wms_goods_attrbute` VALUES ('9', '0', '34:黑色 ', '50.00', '30', null);
INSERT INTO `wms_goods_attrbute` VALUES ('9', '39', null, null, null, '平底');
INSERT INTO `wms_goods_attrbute` VALUES ('9', '36', null, null, null, '商务');
INSERT INTO `wms_goods_attrbute` VALUES ('9', '35', null, null, null, 'PVC');
INSERT INTO `wms_goods_attrbute` VALUES ('9', '34', null, null, null, '春秋');
INSERT INTO `wms_goods_attrbute` VALUES ('9', '31', null, null, null, '2016-05-04');
INSERT INTO `wms_goods_attrbute` VALUES ('10', '0', '34:白色 ', '20.00', '20', null);
INSERT INTO `wms_goods_attrbute` VALUES ('10', '0', '34:黑色 ', '20.00', '30', null);
INSERT INTO `wms_goods_attrbute` VALUES ('10', '0', '35:白色 ', '20.00', '40', null);
INSERT INTO `wms_goods_attrbute` VALUES ('10', '0', '35:黑色 ', '20.00', '48', null);
INSERT INTO `wms_goods_attrbute` VALUES ('10', '39', null, null, null, '平底');
INSERT INTO `wms_goods_attrbute` VALUES ('10', '36', null, null, null, '商务');
INSERT INTO `wms_goods_attrbute` VALUES ('10', '35', null, null, null, '网布');
INSERT INTO `wms_goods_attrbute` VALUES ('10', '34', null, null, null, '春秋');
INSERT INTO `wms_goods_attrbute` VALUES ('10', '31', null, null, null, '2016-05-01');
INSERT INTO `wms_goods_attrbute` VALUES ('17', '0', '39:白色 ', '30.00', '39', null);
INSERT INTO `wms_goods_attrbute` VALUES ('17', '0', '39:黑色 ', '30.00', '39', null);
INSERT INTO `wms_goods_attrbute` VALUES ('17', '0', '40:白色 ', '30.00', '19', null);
INSERT INTO `wms_goods_attrbute` VALUES ('17', '0', '40:黑色 ', '30.00', '40', null);
INSERT INTO `wms_goods_attrbute` VALUES ('17', '39', null, null, null, '平底');
INSERT INTO `wms_goods_attrbute` VALUES ('17', '36', null, null, null, '商务');
INSERT INTO `wms_goods_attrbute` VALUES ('17', '35', null, null, null, '皮革');
INSERT INTO `wms_goods_attrbute` VALUES ('17', '34', null, null, null, '春秋');
INSERT INTO `wms_goods_attrbute` VALUES ('17', '31', null, null, null, '2016-05-04');
INSERT INTO `wms_goods_attrbute` VALUES ('1', '0', '41:白色 ', '20.00', '30', null);
INSERT INTO `wms_goods_attrbute` VALUES ('1', '0', '41:黑色 ', '20.00', '29', null);
INSERT INTO `wms_goods_attrbute` VALUES ('1', '0', '42:白色 ', '20.00', '38', null);
INSERT INTO `wms_goods_attrbute` VALUES ('1', '0', '42:黑色 ', '20.00', '78', null);
INSERT INTO `wms_goods_attrbute` VALUES ('1', '39', null, null, null, '平底');
INSERT INTO `wms_goods_attrbute` VALUES ('1', '36', null, null, null, '商务');
INSERT INTO `wms_goods_attrbute` VALUES ('1', '35', null, null, null, '皮革');
INSERT INTO `wms_goods_attrbute` VALUES ('1', '34', null, null, null, '冬季');
INSERT INTO `wms_goods_attrbute` VALUES ('1', '31', null, null, null, '2016-04-30');
INSERT INTO `wms_goods_attrbute` VALUES ('3', '0', 'M:白色 ', '99.00', '1', null);
INSERT INTO `wms_goods_attrbute` VALUES ('3', '0', 'L:白色 ', '99.00', '10', null);
INSERT INTO `wms_goods_attrbute` VALUES ('16', '0', '38:蓝色 ', '39.00', '39', null);
INSERT INTO `wms_goods_attrbute` VALUES ('16', '0', '39:蓝色 ', '38.00', '38', null);
INSERT INTO `wms_goods_attrbute` VALUES ('16', '39', null, null, null, '平底');
INSERT INTO `wms_goods_attrbute` VALUES ('16', '36', null, null, null, '商务');
INSERT INTO `wms_goods_attrbute` VALUES ('16', '35', null, null, null, 'PU');
INSERT INTO `wms_goods_attrbute` VALUES ('16', '34', null, null, null, '夏季');
INSERT INTO `wms_goods_attrbute` VALUES ('16', '31', null, null, null, '2016-05-03');
INSERT INTO `wms_goods_attrbute` VALUES ('18', '0', 'XS:白色 ', '30.00', '9', null);

-- ----------------------------
-- Table structure for `wms_goods_category`
-- ----------------------------
DROP TABLE IF EXISTS `wms_goods_category`;
CREATE TABLE `wms_goods_category` (
  `goods_id` mediumint(9) unsigned NOT NULL,
  `category_id` mediumint(9) unsigned NOT NULL,
  KEY `category_id` (`category_id`),
  KEY `goods_id` (`goods_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of wms_goods_category
-- ----------------------------
INSERT INTO `wms_goods_category` VALUES ('11', '2');
INSERT INTO `wms_goods_category` VALUES ('2', '1');
INSERT INTO `wms_goods_category` VALUES ('4', '1');
INSERT INTO `wms_goods_category` VALUES ('6', '2');
INSERT INTO `wms_goods_category` VALUES ('8', '2');
INSERT INTO `wms_goods_category` VALUES ('7', '1');
INSERT INTO `wms_goods_category` VALUES ('15', '1');
INSERT INTO `wms_goods_category` VALUES ('14', '1');
INSERT INTO `wms_goods_category` VALUES ('13', '1');
INSERT INTO `wms_goods_category` VALUES ('12', '1');
INSERT INTO `wms_goods_category` VALUES ('9', '1');
INSERT INTO `wms_goods_category` VALUES ('10', '1');
INSERT INTO `wms_goods_category` VALUES ('17', '1');
INSERT INTO `wms_goods_category` VALUES ('1', '1');
INSERT INTO `wms_goods_category` VALUES ('3', '2');
INSERT INTO `wms_goods_category` VALUES ('16', '1');
INSERT INTO `wms_goods_category` VALUES ('18', '2');

-- ----------------------------
-- Table structure for `wms_goods_extend`
-- ----------------------------
DROP TABLE IF EXISTS `wms_goods_extend`;
CREATE TABLE `wms_goods_extend` (
  `goods_id` mediumint(9) unsigned DEFAULT NULL,
  `val` varchar(20) DEFAULT NULL,
  `price` decimal(10,2) DEFAULT NULL,
  `count` mediumint(12) unsigned DEFAULT NULL,
  `time` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of wms_goods_extend
-- ----------------------------

-- ----------------------------
-- Table structure for `wms_link`
-- ----------------------------
DROP TABLE IF EXISTS `wms_link`;
CREATE TABLE `wms_link` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键递增',
  `title` varchar(30) NOT NULL DEFAULT '' COMMENT '标题',
  `type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1=友情链接 2=合作伙伴',
  `icon` varchar(60) NOT NULL DEFAULT '' COMMENT '图片',
  `url` varchar(60) NOT NULL DEFAULT '' COMMENT '链接地址',
  `order` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1=启用 2=禁用',
  `is_deleted` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1=正常 2=删除',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `idx_create_time` (`create_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='友情链接';

-- ----------------------------
-- Records of wms_link
-- ----------------------------

-- ----------------------------
-- Table structure for `wms_news`
-- ----------------------------
DROP TABLE IF EXISTS `wms_news`;
CREATE TABLE `wms_news` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键递增',
  `title` varchar(30) NOT NULL DEFAULT '' COMMENT '标题',
  `category_id` int(10) NOT NULL DEFAULT '0' COMMENT '类别ID',
  `content` text NOT NULL COMMENT '内容',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1=启用 2=禁用',
  `is_deleted` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1=正常 2=删除',
  `publish_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '发布时间',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `idx_category_id` (`category_id`),
  KEY `idx_create_time` (`create_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='最新公告';

-- ----------------------------
-- Records of wms_news
-- ----------------------------

-- ----------------------------
-- Table structure for `wms_news_category`
-- ----------------------------
DROP TABLE IF EXISTS `wms_news_category`;
CREATE TABLE `wms_news_category` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '分类名称',
  `parent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '上级ID',
  `order` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1=正常 2=删除',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='资讯类别';

-- ----------------------------
-- Records of wms_news_category
-- ----------------------------

-- ----------------------------
-- Table structure for `wms_node`
-- ----------------------------
DROP TABLE IF EXISTS `wms_node`;
CREATE TABLE `wms_node` (
  `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT COMMENT '主id',
  `name` varchar(20) NOT NULL COMMENT '名字',
  `title` varchar(50) DEFAULT NULL COMMENT '标题',
  `status` tinyint(1) DEFAULT '0' COMMENT '状态',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `sort` smallint(6) unsigned DEFAULT NULL COMMENT '排序',
  `pid` smallint(6) unsigned NOT NULL COMMENT '父id',
  `level` tinyint(1) unsigned NOT NULL COMMENT '级别',
  PRIMARY KEY (`id`),
  KEY `idx_level` (`level`),
  KEY `idx_pid` (`pid`),
  KEY `idx_status` (`status`),
  KEY `idx_name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=utf8 COMMENT='权限节点';

-- ----------------------------
-- Records of wms_node
-- ----------------------------
INSERT INTO `wms_node` VALUES ('1', 'Admin', '后台管理', '1', 'WMS后台管理系统', '0', '0', '1');
INSERT INTO `wms_node` VALUES ('2', 'News', '资讯管理', '1', '', '0', '1', '2');
INSERT INTO `wms_node` VALUES ('3', 'index', '资讯列表', '1', '', '0', '2', '3');
INSERT INTO `wms_node` VALUES ('4', 'add', '添加', '1', '', '0', '2', '3');
INSERT INTO `wms_node` VALUES ('5', 'edit', '编辑', '1', '', '0', '2', '3');
INSERT INTO `wms_node` VALUES ('6', 'status', '启用/禁用', '1', '', '0', '2', '3');
INSERT INTO `wms_node` VALUES ('7', 'del', '删除', '1', '', '0', '2', '3');
INSERT INTO `wms_node` VALUES ('8', 'category', '资讯分类', '1', '', '0', '2', '3');
INSERT INTO `wms_node` VALUES ('9', 'Link', '链接管理', '1', '', '0', '1', '2');
INSERT INTO `wms_node` VALUES ('10', 'index', '链接列表', '1', '', '0', '9', '3');
INSERT INTO `wms_node` VALUES ('11', 'add', '添加', '1', '', '0', '9', '3');
INSERT INTO `wms_node` VALUES ('12', 'edit', '编辑', '1', '', '0', '9', '3');
INSERT INTO `wms_node` VALUES ('13', 'status', '启用/禁用', '1', '', '0', '9', '3');
INSERT INTO `wms_node` VALUES ('14', 'del', '删除', '1', '', '0', '9', '3');
INSERT INTO `wms_node` VALUES ('15', 'details', '详情', '1', '', '0', '9', '3');
INSERT INTO `wms_node` VALUES ('16', 'Ad', '广告管理', '1', '', '0', '1', '2');
INSERT INTO `wms_node` VALUES ('17', 'index', '广告列表', '1', '', '0', '16', '3');
INSERT INTO `wms_node` VALUES ('18', 'add', '添加', '1', '', '0', '16', '3');
INSERT INTO `wms_node` VALUES ('19', 'edit', '编辑', '1', '', '0', '16', '3');
INSERT INTO `wms_node` VALUES ('20', 'status', '启用/禁用', '1', '', '0', '16', '3');
INSERT INTO `wms_node` VALUES ('21', 'del', '删除', '1', '', '0', '16', '3');
INSERT INTO `wms_node` VALUES ('22', 'details', '详情', '1', '', '0', '16', '3');
INSERT INTO `wms_node` VALUES ('23', 'User', '用户管理', '1', '', '0', '1', '2');
INSERT INTO `wms_node` VALUES ('24', 'index', '用户列表', '1', '', '0', '23', '3');
INSERT INTO `wms_node` VALUES ('26', 'del', '删除', '1', '', '0', '23', '3');
INSERT INTO `wms_node` VALUES ('27', 'details', '详情', '1', '', '0', '23', '3');
INSERT INTO `wms_node` VALUES ('28', 'Admin', '管理员管理', '1', '', '0', '1', '2');
INSERT INTO `wms_node` VALUES ('29', 'index', '管理员列表', '1', '', '0', '28', '3');
INSERT INTO `wms_node` VALUES ('30', 'add', '添加', '1', '', '0', '28', '3');
INSERT INTO `wms_node` VALUES ('31', 'edit', '编辑', '1', '', '0', '28', '3');
INSERT INTO `wms_node` VALUES ('32', 'status', '启用/禁用', '1', '', '0', '28', '3');
INSERT INTO `wms_node` VALUES ('33', 'del', '删除', '1', '', '0', '28', '3');
INSERT INTO `wms_node` VALUES ('34', 'details', '详情', '1', '', '0', '28', '3');
INSERT INTO `wms_node` VALUES ('35', 'Config', '配置管理', '1', '', '0', '1', '2');
INSERT INTO `wms_node` VALUES ('36', 'index', '列表+编辑', '1', '', '0', '35', '3');
INSERT INTO `wms_node` VALUES ('37', 'add', '添加', '1', '', '0', '35', '3');
INSERT INTO `wms_node` VALUES ('38', 'Access', '权限管理', '1', '', '0', '1', '2');
INSERT INTO `wms_node` VALUES ('39', 'index', '节点列表', '1', '', '0', '38', '3');
INSERT INTO `wms_node` VALUES ('40', 'addNode', '添加节点', '1', '', '0', '38', '3');
INSERT INTO `wms_node` VALUES ('41', 'editNode', '编辑节点', '1', '', '0', '38', '3');
INSERT INTO `wms_node` VALUES ('42', 'opSort', '节点排序', '1', '', '0', '38', '3');
INSERT INTO `wms_node` VALUES ('43', 'opNodeStatus', '启用/禁用(节点)', '1', '', '0', '38', '3');
INSERT INTO `wms_node` VALUES ('44', 'delNode', '删除节点', '1', '', '0', '38', '3');
INSERT INTO `wms_node` VALUES ('45', 'roleList', '角色列表', '1', '', '0', '38', '3');
INSERT INTO `wms_node` VALUES ('46', 'addRole', '添加角色', '1', '', '0', '38', '3');
INSERT INTO `wms_node` VALUES ('47', 'editRole', '编辑角色', '1', '', '0', '38', '3');
INSERT INTO `wms_node` VALUES ('48', 'opRoleStatus', '启用/禁用(角色)', '1', '', '0', '38', '3');
INSERT INTO `wms_node` VALUES ('49', 'changeRole', '分配权限', '1', '', '0', '38', '3');
INSERT INTO `wms_node` VALUES ('50', 'Db', '数据库管理', '1', '', '0', '1', '2');
INSERT INTO `wms_node` VALUES ('51', 'index', '数据表列表', '1', '', '0', '50', '3');
INSERT INTO `wms_node` VALUES ('52', 'restore', '导入列表', '1', '', '0', '50', '3');
INSERT INTO `wms_node` VALUES ('53', 'zipList', '压缩包列表', '1', '', '0', '50', '3');
INSERT INTO `wms_node` VALUES ('54', 'repair', '优化与修复', '1', '', '0', '50', '3');
INSERT INTO `wms_node` VALUES ('55', 'status', '禁用/启用', '1', '', '0', '23', '3');
INSERT INTO `wms_node` VALUES ('56', 'restoreData', '导入', '1', '', '0', '50', '3');
INSERT INTO `wms_node` VALUES ('57', 'delSqlFiles', '删除SQL文件', '1', '', '0', '50', '3');
INSERT INTO `wms_node` VALUES ('58', 'sendSql', '发送邮箱', '1', '', '0', '50', '3');
INSERT INTO `wms_node` VALUES ('59', 'zipSql', '压缩为ZIP', '1', '', '0', '50', '3');
INSERT INTO `wms_node` VALUES ('60', 'unzipSqlfile', '解压缩为SQL', '1', '', '0', '50', '3');
INSERT INTO `wms_node` VALUES ('61', 'delZipFiles', '删除ZIP文件', '1', '', '0', '50', '3');
INSERT INTO `wms_node` VALUES ('62', 'downFile', '下载文件', '1', '', '0', '50', '3');
INSERT INTO `wms_node` VALUES ('63', 'Template', '模板管理', '1', '', '0', '1', '2');
INSERT INTO `wms_node` VALUES ('64', 'index', '文件列表', '1', '', '0', '63', '3');
INSERT INTO `wms_node` VALUES ('65', 'downFile', '下载文件', '1', '', '0', '63', '3');
INSERT INTO `wms_node` VALUES ('66', 'edit', '编辑', '1', '', '0', '63', '3');
INSERT INTO `wms_node` VALUES ('67', 'mkdir', '创建文件夹', '1', '', '0', '63', '3');
INSERT INTO `wms_node` VALUES ('68', 'reName', '重命名', '1', '', '0', '63', '3');
INSERT INTO `wms_node` VALUES ('69', 'delFile', '删除文件', '1', '', '0', '63', '3');
INSERT INTO `wms_node` VALUES ('70', 'Oplog', '日志管理', '1', '', '0', '1', '2');
INSERT INTO `wms_node` VALUES ('71', 'index', '日志列表', '1', '', '0', '70', '3');

-- ----------------------------
-- Table structure for `wms_oplog`
-- ----------------------------
DROP TABLE IF EXISTS `wms_oplog`;
CREATE TABLE `wms_oplog` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主id',
  `model` varchar(30) NOT NULL DEFAULT '' COMMENT '模块',
  `action` varchar(30) NOT NULL DEFAULT '' COMMENT '动作',
  `admin_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '用户id',
  `admin_name` varchar(50) DEFAULT '' COMMENT '用户名',
  `role_id` int(10) NOT NULL DEFAULT '0' COMMENT '管理角色id',
  `role_name` varchar(50) NOT NULL DEFAULT '' COMMENT '管理角色',
  `bak` varchar(256) NOT NULL DEFAULT '' COMMENT '备注',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='后台操作表';

-- ----------------------------
-- Records of wms_oplog
-- ----------------------------
INSERT INTO `wms_oplog` VALUES ('1', 'Public', 'loginout', '1', 'admin', '1', '管理员', '退出', '1406110377');
INSERT INTO `wms_oplog` VALUES ('2', 'Public', 'index', '1', 'admin', '1', '超级管理员', '登录', '1406110389');

-- ----------------------------
-- Table structure for `wms_position`
-- ----------------------------
DROP TABLE IF EXISTS `wms_position`;
CREATE TABLE `wms_position` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(40) NOT NULL COMMENT '职位名称',
  `time` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='职位表';

-- ----------------------------
-- Records of wms_position
-- ----------------------------
INSERT INTO `wms_position` VALUES ('1', '店长', '1461291852');
INSERT INTO `wms_position` VALUES ('2', '职员', '1461291852');

-- ----------------------------
-- Table structure for `wms_privilege`
-- ----------------------------
DROP TABLE IF EXISTS `wms_privilege`;
CREATE TABLE `wms_privilege` (
  `id` mediumint(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(60) NOT NULL COMMENT '权限名称',
  `parent_id` mediumint(11) unsigned DEFAULT '0' COMMENT '父级id',
  `controller` varchar(20) DEFAULT NULL,
  `module` varchar(20) DEFAULT NULL,
  `action` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `parent_id` (`parent_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COMMENT='权限表';

-- ----------------------------
-- Records of wms_privilege
-- ----------------------------
INSERT INTO `wms_privilege` VALUES ('1', '超级管理员', '0', '---', '---', '---');
INSERT INTO `wms_privilege` VALUES ('2', '角色管理', '0', 'Role', 'Role', 'index,add,edit,delete');
INSERT INTO `wms_privilege` VALUES ('3', '用户管理', '0', 'Account', 'User', 'index,add,edit,delete');
INSERT INTO `wms_privilege` VALUES ('4', '商品品牌', '0', 'Brand', 'Brand', 'index,add,edit,delete');
INSERT INTO `wms_privilege` VALUES ('5', '商品分类', '0', 'Category', 'Category', 'index,add,edit,delete');
INSERT INTO `wms_privilege` VALUES ('6', '商品管理', '0', 'Goods', 'Goods', 'index,add,edit,delete');
INSERT INTO `wms_privilege` VALUES ('7', '职位管理', '0', 'Position', 'Position', 'index,add,edit,delete');
INSERT INTO `wms_privilege` VALUES ('8', '权限管理', '0', 'Privilege', 'Privilege', 'index,add,edit,delete');
INSERT INTO `wms_privilege` VALUES ('9', '门店管理', '0', 'Store', 'Store', 'index,add,edit,delete');
INSERT INTO `wms_privilege` VALUES ('10', '管理员管理', '0', 'Admin', 'Admin', 'index,add,edit,delete');

-- ----------------------------
-- Table structure for `wms_record`
-- ----------------------------
DROP TABLE IF EXISTS `wms_record`;
CREATE TABLE `wms_record` (
  `goods_id` mediumint(9) unsigned NOT NULL,
  `no` varchar(40) NOT NULL COMMENT '员工编号',
  `name` varchar(18) NOT NULL COMMENT '员工姓名',
  `create_time` int(11) NOT NULL,
  `sn` varchar(50) NOT NULL,
  `goods_name` varchar(80) NOT NULL,
  `price` decimal(10,2) unsigned NOT NULL COMMENT '价格',
  `value` varchar(40) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='销售记录';

-- ----------------------------
-- Records of wms_record
-- ----------------------------
INSERT INTO `wms_record` VALUES ('1', '2016', 'bool', '1462774517', '001', '特步01', '20.00', 'L,蓝色 ');
INSERT INTO `wms_record` VALUES ('1', '2016', 'bool', '1462775581', '001', '特步01', '20.00', '41,黑色 ');
INSERT INTO `wms_record` VALUES ('2', '2016', 'bool', '1462775581', '001', '特步01', '20.00', '42,白色 ');
INSERT INTO `wms_record` VALUES ('2', '2016', 'bool', '1462775587', '001', '特步01', '20.00', '42,白色 ');
INSERT INTO `wms_record` VALUES ('2', '2016', 'bool', '1462775594', '001', '特步01', '20.00', '42,白色 ');
INSERT INTO `wms_record` VALUES ('2', '2016', 'bool', '1462775598', '001', '特步01', '20.00', '42,白色 ');
INSERT INTO `wms_record` VALUES ('1', '2016', 'bool', '1462775599', '001', '特步01', '20.00', '42,黑色 ');
INSERT INTO `wms_record` VALUES ('5', '2016', 'bool', '1462775637', '001', '特步01', '20.00', '40,白色 ');
INSERT INTO `wms_record` VALUES ('3', '2016', 'bool', '1462775637', '001', '特步01', '20.00', '41,白色 ');
INSERT INTO `wms_record` VALUES ('2', '2016', 'bool', '1462775637', '001', '特步01', '20.00', '42,白色 ');
INSERT INTO `wms_record` VALUES ('4', '2016', 'bool', '1462775657', '001', '特步01', '20.00', '34,白色 ');
INSERT INTO `wms_record` VALUES ('4', '2016', 'bool', '1462775657', '001', '特步01', '20.00', '34,黑色 ');
INSERT INTO `wms_record` VALUES ('3', '2016', 'bool', '1462775657', '001', '特步01', '20.00', '35,白色 ');
INSERT INTO `wms_record` VALUES ('3', '2016', 'bool', '1462775657', '001', '特步01', '20.00', '35,黑色 ');

-- ----------------------------
-- Table structure for `wms_role`
-- ----------------------------
DROP TABLE IF EXISTS `wms_role`;
CREATE TABLE `wms_role` (
  `id` mediumint(11) unsigned NOT NULL AUTO_INCREMENT,
  `role_name` varchar(30) NOT NULL COMMENT '角色名称',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COMMENT='角色表';

-- ----------------------------
-- Records of wms_role
-- ----------------------------
INSERT INTO `wms_role` VALUES ('1', '超级管理员');
INSERT INTO `wms_role` VALUES ('6', '用户管理员');
INSERT INTO `wms_role` VALUES ('7', '角色管理员');
INSERT INTO `wms_role` VALUES ('8', '商品管理员');
INSERT INTO `wms_role` VALUES ('9', '职位管理员');
INSERT INTO `wms_role` VALUES ('10', '权限管理员');
INSERT INTO `wms_role` VALUES ('11', '门店管理员');

-- ----------------------------
-- Table structure for `wms_role_privilege`
-- ----------------------------
DROP TABLE IF EXISTS `wms_role_privilege`;
CREATE TABLE `wms_role_privilege` (
  `privliege_id` mediumint(12) unsigned NOT NULL COMMENT '权限id',
  `role_id` mediumint(12) unsigned NOT NULL COMMENT '角色id',
  KEY `role_id` (`role_id`),
  KEY `privliege_id` (`privliege_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色权限表，角色->权限';

-- ----------------------------
-- Records of wms_role_privilege
-- ----------------------------
INSERT INTO `wms_role_privilege` VALUES ('3', '6');
INSERT INTO `wms_role_privilege` VALUES ('2', '7');
INSERT INTO `wms_role_privilege` VALUES ('4', '8');
INSERT INTO `wms_role_privilege` VALUES ('5', '8');
INSERT INTO `wms_role_privilege` VALUES ('6', '8');
INSERT INTO `wms_role_privilege` VALUES ('7', '9');
INSERT INTO `wms_role_privilege` VALUES ('8', '10');
INSERT INTO `wms_role_privilege` VALUES ('9', '11');
INSERT INTO `wms_role_privilege` VALUES ('1', '1');
INSERT INTO `wms_role_privilege` VALUES ('2', '1');
INSERT INTO `wms_role_privilege` VALUES ('3', '1');
INSERT INTO `wms_role_privilege` VALUES ('4', '1');
INSERT INTO `wms_role_privilege` VALUES ('5', '1');
INSERT INTO `wms_role_privilege` VALUES ('6', '1');
INSERT INTO `wms_role_privilege` VALUES ('7', '1');
INSERT INTO `wms_role_privilege` VALUES ('8', '1');
INSERT INTO `wms_role_privilege` VALUES ('9', '1');

-- ----------------------------
-- Table structure for `wms_role_user`
-- ----------------------------
DROP TABLE IF EXISTS `wms_role_user`;
CREATE TABLE `wms_role_user` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主id',
  `role_id` mediumint(9) unsigned DEFAULT NULL COMMENT '角色id',
  `user_id` char(32) DEFAULT NULL COMMENT '用户id',
  PRIMARY KEY (`id`),
  KEY `idx_role_id` (`role_id`),
  KEY `idx_user_id` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='用户角色';

-- ----------------------------
-- Records of wms_role_user
-- ----------------------------
INSERT INTO `wms_role_user` VALUES ('1', '1', '1');

-- ----------------------------
-- Table structure for `wms_sale`
-- ----------------------------
DROP TABLE IF EXISTS `wms_sale`;
CREATE TABLE `wms_sale` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='销售';

-- ----------------------------
-- Records of wms_sale
-- ----------------------------

-- ----------------------------
-- Table structure for `wms_stock`
-- ----------------------------
DROP TABLE IF EXISTS `wms_stock`;
CREATE TABLE `wms_stock` (
  `no_id` mediumint(12) unsigned NOT NULL COMMENT '货号id',
  `sn` varchar(30) NOT NULL COMMENT '产品sn号',
  `depot_id` mediumint(12) unsigned NOT NULL COMMENT '仓库id',
  `goods_id` mediumint(12) unsigned NOT NULL COMMENT '商品id',
  `store_id` mediumint(12) unsigned NOT NULL,
  `num` mediumint(12) unsigned NOT NULL,
  KEY `depot_id` (`depot_id`),
  KEY `goods_id` (`goods_id`),
  KEY `store_id` (`store_id`),
  KEY `sn` (`sn`),
  KEY `no_id` (`no_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='库存';

-- ----------------------------
-- Records of wms_stock
-- ----------------------------

-- ----------------------------
-- Table structure for `wms_store`
-- ----------------------------
DROP TABLE IF EXISTS `wms_store`;
CREATE TABLE `wms_store` (
  `id` mediumint(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `leader` varchar(30) DEFAULT NULL COMMENT '负责人，领导人',
  `name` varchar(60) NOT NULL COMMENT '门店名称',
  `tel` varchar(20) DEFAULT NULL,
  `address` varchar(100) NOT NULL COMMENT '地址',
  `desc` varchar(200) DEFAULT NULL,
  `create_time` varchar(20) NOT NULL COMMENT '创建时间',
  `status` tinyint(1) unsigned DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `leader` (`leader`),
  KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='门店表';

-- ----------------------------
-- Records of wms_store
-- ----------------------------
INSERT INTO `wms_store` VALUES ('1', '李先生', '东创科技园金枫路分店', '0512-5689107', '江苏省苏州市', '描述', '2016-04-14', '0');
INSERT INTO `wms_store` VALUES ('2', '李先生', '观前街分店', '0512-5689108', '苏州市观前街', '描述内容', '2016-04-14', '0');
INSERT INTO `wms_store` VALUES ('3', '赵先生', '工业园区湖东分店', '0512-5689105', '江苏省苏州市工业园区湖东', '描述', '2016-04-14', '0');
INSERT INTO `wms_store` VALUES ('4', '李先生', '苏州市高新区木渎分店', '0512-5689102', '苏州市高新区木渎分店', '苏州市高新区木渎分店', '2016-04-22', '0');

-- ----------------------------
-- Table structure for `wms_user`
-- ----------------------------
DROP TABLE IF EXISTS `wms_user`;
CREATE TABLE `wms_user` (
  `id` mediumint(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `nickname` varchar(16) DEFAULT NULL COMMENT '昵称',
  `username` varchar(16) NOT NULL COMMENT '用户名',
  `password` varchar(32) NOT NULL COMMENT '密码',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '状态，0正常 1禁止 2删除',
  `create_time` int(11) unsigned NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `nickname` (`nickname`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COMMENT='用户表';

-- ----------------------------
-- Records of wms_user
-- ----------------------------
INSERT INTO `wms_user` VALUES ('13', '布尔', 'bool', 'c506ff134babdd6e68ab3e6350e95305', '0', '1460968251');
INSERT INTO `wms_user` VALUES ('14', '毛毛', 'maomao', '4a8a08f09d37b73795649038408b5f33', '0', '1460969225');
INSERT INTO `wms_user` VALUES ('15', '布尔', 'a', '4a8a08f09d37b73795649038408b5f33', '0', '1460970912');
INSERT INTO `wms_user` VALUES ('16', '测试', 'b', '4a8a08f09d37b73795649038408b5f33', '0', '1460970931');
INSERT INTO `wms_user` VALUES ('17', 'ColorRabbit', 'ColorRabbit', '3e21a1642f4596362cf77c25c6d7a9d7', '0', '1461315134');
INSERT INTO `wms_user` VALUES ('18', '毛毛', 'maomao1', '202cb962ac59075b964b07152d234b70', '0', '1461721685');

-- ----------------------------
-- Table structure for `wms_userinfo`
-- ----------------------------
DROP TABLE IF EXISTS `wms_userinfo`;
CREATE TABLE `wms_userinfo` (
  `id` mediumint(11) unsigned NOT NULL,
  `no` varchar(25) DEFAULT NULL,
  `qq` int(11) unsigned DEFAULT NULL COMMENT 'qq',
  `tel` varchar(15) DEFAULT NULL COMMENT '电话',
  `email` varchar(40) DEFAULT NULL COMMENT '邮箱',
  `sex` enum('女','男') DEFAULT NULL,
  `position` int(10) unsigned DEFAULT NULL,
  `address` varchar(120) DEFAULT NULL,
  `post` int(7) DEFAULT NULL,
  `store_id` int(11) unsigned NOT NULL,
  KEY `store_id` (`store_id`),
  KEY `position` (`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of wms_userinfo
-- ----------------------------
INSERT INTO `wms_userinfo` VALUES ('13', '2016', '30024167', '18101565682', '30024167@qq.com', '男', '2', '江苏省苏州市工业园区', '267000', '1');
INSERT INTO `wms_userinfo` VALUES ('14', '44444444', '123456', '1414141414', '141414@qq.com', '男', '2', '河南省商丘市', '267000', '2');
INSERT INTO `wms_userinfo` VALUES ('15', '123', '1222', '123', '1', '男', '1', '1', '233', '3');
INSERT INTO `wms_userinfo` VALUES ('16', 'b', '1233', '123456', '123456@qq.com', '男', '2', '江苏省苏州市', '123', '1');
INSERT INTO `wms_userinfo` VALUES ('17', 'CR20160422', '0', '', '', '男', '1', '', '0', '2');
INSERT INTO `wms_userinfo` VALUES ('18', 'mao123', '0', '', '', '男', '2', '', '0', '2');