/*
Navicat MySQL Data Transfer
Source Server : local
Source Server Version : 50621
Source Host : localhost:3306
Source Database : admin_student
Target Server Type : MYSQL
Target Server Version : 50621
File Encoding : 65001
Date: 2017-10-19 15:22:59
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `sys_andorra`
-- ----------------------------
DROP TABLE IF EXISTS `sys_andorra`;
CREATE TABLE `sys_andorra` (
`id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`title` varchar(200) DEFAULT NULL COMMENT '标题',
`content` varchar(200) DEFAULT NULL COMMENT '内容',
`type` char(2) DEFAULT NULL COMMENT '类型 ',
`adurl` varchar(200) DEFAULT NULL COMMENT '图片地址',
`publisher` varchar(50) DEFAULT NULL COMMENT '发布人',
`addtime` datetime DEFAULT NULL COMMENT '添加时间',
`uptime` datetime DEFAULT NULL COMMENT '修改时间',
`starttime` varchar(50) DEFAULT NULL COMMENT '开始时间',
`endtime` varchar(50) DEFAULT NULL COMMENT '结束时间',
`status` char(2) DEFAULT '0' COMMENT '状态 0为默认未启用,1为启用',
`tourl` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of sys_andorra
-- ----------------------------
INSERT INTO `sys_andorra` VALUES ('11', 'test', '<p style=\"\">text<img src=\"http://10.10.28.214:10300/TP/ae5f19486f2f46e6ba93b0252bea802e.png\" title=\"llq.png\"/></p>', '0', '', 'iuo', '2017-07-05 17:05:02', '2017-07-05 18:56:02', '2017-07-05', '2017-07-13', '0', '-ii');
INSERT INTO `sys_andorra` VALUES ('12', 'te', '<p><img src=\"/upload/43682f32dce94b6ea18dcba43e62b903.jpg\" title=\"c5d988e2b8ed99301d4da5793e682587.jpg\"/><img src=\"/upload/bb179e262cd7433291e92e530c6f7699.jpg\" title=\"手动é?手动é?阿斯蒂芬.jpg\"/></p>', '0', '12.jpg', 'f', '2017-07-05 19:05:47', '2017-07-05 19:06:47', '', '', '0', 'f');
-- ----------------------------
-- Table structure for `sys_menu`
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
`MENU_ID` int(11) NOT NULL COMMENT '菜单id',
`MENU_NAME` varchar(255) DEFAULT NULL COMMENT '菜单名',
`MENU_URL` varchar(255) DEFAULT NULL COMMENT '菜单url',
`PARENT_ID` int(25) DEFAULT NULL COMMENT '父级菜单id',
`MENU_ORDER` varchar(100) DEFAULT NULL COMMENT '菜单顺序',
`MENU_ICON` varchar(30) DEFAULT NULL COMMENT '菜单图标',
`MENU_TYPE` varchar(10) DEFAULT NULL COMMENT '菜单类型',
`CREATED_BY` varchar(20) DEFAULT NULL COMMENT '创建人',
`CREATION_DATE` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`LAST_UPDATE_BY` varchar(20) DEFAULT NULL COMMENT '更新人',
`LAST_UPDATE_DATE` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`CALL_CNT` int(11) DEFAULT NULL COMMENT '乐观锁',
`REMARK` varchar(200) DEFAULT NULL COMMENT '备注',
`STS_CD` char(1) DEFAULT NULL COMMENT '状态码',
PRIMARY KEY (`MENU_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of sys_menu
-- ----------------------------
INSERT INTO `sys_menu` VALUES ('1', '系统管理', '#', '0', '1', 'icon-desktop', '2', 'admin', '2017-07-18 16:59:34', 'admin', '2017-07-18 16:59:34', null, null, 'a');
INSERT INTO `sys_menu` VALUES ('2', '菜单权限', 'newRole/listRole', '1', '2', null, '2', 'admin', '2017-07-18 16:59:34', 'admin', '2017-07-27 09:12:15', null, null, 'a');
INSERT INTO `sys_menu` VALUES ('5', '系统用户', 'user/listUsers', '1', '3', null, '2', 'admin', '2017-07-18 16:59:34', 'admin', '2017-07-27 09:12:17', null, null, 'a');
INSERT INTO `sys_menu` VALUES ('8', '性能监控', 'druid/index.html', '9', '1', null, '2', 'admin', '2017-07-18 16:59:34', 'admin', '2017-07-18 16:59:34', null, null, 'a');
INSERT INTO `sys_menu` VALUES ('9', '系统工具', '#', '0', '2', 'icon-th', '2', 'admin', '2017-07-18 16:59:34', 'admin', '2017-07-18 16:59:34', null, null, 'a');
INSERT INTO `sys_menu` VALUES ('10', 'test', 'andorra/list', '1', '4', null, '2', 'admin', '2017-07-18 16:59:34', 'admin', '2017-07-27 09:12:18', null, null, 'a');
INSERT INTO `sys_menu` VALUES ('11', 'testp', 'pictures/list', '1', '5', null, '2', 'admin', '2017-07-18 16:59:34', 'admin', '2017-07-27 09:12:20', null, null, 'a');
INSERT INTO `sys_menu` VALUES ('16', '菜单列表', 'newMenu/listVisibleTopMenu', '1', '6', null, '2', 'admin', '2017-07-18 16:59:34', 'admin', '2017-07-26 16:20:42', null, 'last action is edit name', 'a');
INSERT INTO `sys_menu` VALUES ('20', '我的信息(制造商)', '#', '0', '7', null, '2', 'admin', '2017-07-18 16:59:34', 'admin', '2017-07-18 16:59:34', null, null, 'a');
INSERT INTO `sys_menu` VALUES ('21', '基本信息管理', 'manufacturerInfo/showManufacturerinfo', '20', '1', null, null, 'admin', '2017-07-18 16:59:34', 'admin', '2017-10-18 13:45:48', null, 'last action is edit', 'a');
INSERT INTO `sys_menu` VALUES ('22', '品牌管理', 'Brand/BrandList', '20', '2', null, '2', 'admin', '2017-07-18 16:59:34', 'admin', '2017-07-28 15:19:52', null, null, 'a');
INSERT INTO `sys_menu` VALUES ('23', '商品管理', 'product/showProductList', '20', '3', null, '2', 'admin', '2017-07-18 16:59:34', 'admin', '2017-07-28 15:36:17', null, null, 'a');
INSERT INTO `sys_menu` VALUES ('25', '商品录入', '#', '0', '8', null, '2', 'admin', '2017-07-18 16:59:34', 'admin', '2017-07-18 16:59:34', null, null, 'a');
INSERT INTO `sys_menu` VALUES ('26', '基础信息', 'product/showProductList', '25', '1', null, '2', 'admin', '2017-07-18 16:59:34', 'admin', '2017-07-28 17:10:13', null, null, 'a');
INSERT INTO `sys_menu` VALUES ('28', '图片', 'ImageController/findImageList', '25', '3', null, '2', 'admin', '2017-07-18 16:59:34', 'admin', '2017-07-31 09:45:59', null, null, 's');
INSERT INTO `sys_menu` VALUES ('29', '订单管理(制造商)', '#', '0', '9', null, '2', 'admin', '2017-07-18 16:59:34', 'admin', '2017-07-18 16:59:34', null, null, 'a');
INSERT INTO `sys_menu` VALUES ('30', '查看', 'order/findOrders', '29', '1', null, '2', 'admin', '2017-07-18 16:59:34', 'admin', '2017-07-30 21:03:36', null, null, 'a');
INSERT INTO `sys_menu` VALUES ('32', '钱包', '#', '0', '15', null, '2', 'admin', '2017-07-18 16:59:34', 'admin', '2017-07-18 16:59:34', null, null, 'a');
INSERT INTO `sys_menu` VALUES ('33', '账户管理', 'ewallet/account/home', '32', '1', null, '2', 'admin', '2017-07-18 16:59:34', 'admin', '2017-07-28 15:44:27', null, null, 'a');
INSERT INTO `sys_menu` VALUES ('34', '余额查看及提现', '#test', '32', '2', null, null, 'admin', '2017-07-18 16:59:34', 'admin', '2017-08-04 09:09:26', null, 'last action is edit', 'a');
INSERT INTO `sys_menu` VALUES ('35', '账户流水', '#', '32', '3', null, '2', 'admin', '2017-07-18 16:59:34', 'admin', '2017-07-18 16:59:34', null, null, 'a');
INSERT INTO `sys_menu` VALUES ('37', '我的信息(借卖方)', '#', '0', '11', null, '2', 'admin', '2017-07-18 16:59:34', 'admin', '2017-07-18 16:59:34', null, null, 'a');
INSERT INTO `sys_menu` VALUES ('38', '商品列表', 'dsrProduct/showProductList', '37', '1', null, null, 'admin', '2017-07-18 16:59:34', 'test2', '2017-07-28 16:50:40', null, 'last action is edit', 'a');
INSERT INTO `sys_menu` VALUES ('39', '网店管理', 'strstore/findStrStore', '37', '2', null, '2', 'admin', '2017-07-18 16:59:34', 'admin', '2017-07-28 16:48:36', null, null, 'a');
INSERT INTO `sys_menu` VALUES ('40', '商品管理', '#', '0', '12', null, '2', 'admin', '2017-07-18 16:59:34', 'admin', '2017-07-18 16:59:34', null, null, 'a');
INSERT INTO `sys_menu` VALUES ('41', '已有商品', 'product/showProductList', '40', '1', null, '2', 'admin', '2017-07-18 16:59:34', 'admin', '2017-07-27 09:49:46', null, null, 'a');
INSERT INTO `sys_menu` VALUES ('43', '订单管理(借卖方)', '#', '0', '1