iflyket/web/base_demo_yx.sql

/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50624
Source Host           : localhost:3306
Source Database       : base_demo_yx

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

Date: 2017-01-16 17:15:38
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `base_dept`
-- ----------------------------
DROP TABLE IF EXISTS `base_dept`;
CREATE TABLE `base_dept` (
  `id` int(11) NOT NULL,
  `name` varchar(50) DEFAULT NULL,
  `ddesc` varchar(50) DEFAULT NULL,

  `imgUrl` varchar(50) DEFAULT NULL,
  `dorder` int(11) DEFAULT NULL,
  `dstatus` int(11) DEFAULT NULL,
  `fid` int(11) DEFAULT NULL,
  `uid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ;

-- ----------------------------
-- Records of base_dept
-- ----------------------------
INSERT INTO `base_dept` VALUES ('1', 'ceshi', null, null, null, '1', '0', null);
INSERT INTO `base_dept` VALUES ('5', 'aaaaaa', null, null, null, '1', '0', null);
INSERT INTO `base_dept` VALUES ('6', 'aaa', null, null, null, '1', '0', null);
INSERT INTO `base_dept` VALUES ('7', 'c1', null, null, null, '1', '1', null);
INSERT INTO `base_dept` VALUES ('8', 'a1', null, null, null, '1', '6', null);

-- ----------------------------
-- Table structure for `base_dict`
-- ----------------------------
DROP TABLE IF EXISTS `base_dict`;
CREATE TABLE `base_dict` (
  `id` int(11) NOT NULL,
  `name` varchar(50) DEFAULT NULL,
  `ddesc` varchar(50) DEFAULT NULL,
  `imgUrl` varchar(50) DEFAULT NULL,
  `dorder` int(11) DEFAULT NULL,
  `dstatus` int(11) DEFAULT NULL,
  `fid` int(11) DEFAULT NULL,
  `code` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ;

-- ----------------------------
-- Records of base_dict
-- ----------------------------
INSERT INTO `base_dict` VALUES ('1', 'aaa', null, null, null, '1', '0', null);
INSERT INTO `base_dict` VALUES ('3', 'aaaaaaa', null, null, null, '0', '0', null);
INSERT INTO `base_dict` VALUES ('4', 'a1', null, null, null, '1', '1', null);
INSERT INTO `base_dict` VALUES ('5', 'a2', null, null, null, '1', '1', null);
INSERT INTO `base_dict` VALUES ('6', 'b', null, null, null, '1', '0', null);
INSERT INTO `base_dict` VALUES ('7', 'b1', null, null, null, '1', '6', null);
INSERT INTO `base_dict` VALUES ('8', 'b2', null, null, null, '1', '6', null);
INSERT INTO `base_dict` VALUES ('9', 'a11111', null, null, null, '1', '4', null);

-- ----------------------------
-- Table structure for `base_id_gen`
-- ----------------------------
DROP TABLE IF EXISTS `base_id_gen`;
CREATE TABLE `base_id_gen` (
  `id_key` varchar(20) NOT NULL,
  `id_value` int(11) DEFAULT NULL,
  PRIMARY KEY (`id_key`)
) ;

-- ----------------------------
-- Records of base_id_gen
-- ----------------------------
INSERT INTO `base_id_gen` VALUES ('aaaa', '1');
INSERT INTO `base_id_gen` VALUES ('base_dept', '8');
INSERT INTO `base_id_gen` VALUES ('base_dict', '9');
INSERT INTO `base_id_gen` VALUES ('base_menu_role', '11');
INSERT INTO `base_id_gen` VALUES ('base_mune', '26');
INSERT INTO `base_id_gen` VALUES ('base_role', '3');
INSERT INTO `base_id_gen` VALUES ('base_user_info', '2');
INSERT INTO `base_id_gen` VALUES ('cccc', '1');
INSERT INTO `base_id_gen` VALUES ('ccccc', '1');

-- ----------------------------
-- Table structure for `base_log`
-- ----------------------------
DROP TABLE IF EXISTS `base_log`;
CREATE TABLE `base_log` (
  `id` int(11) NOT NULL,
  `log_type` varchar(50) DEFAULT NULL,
  `event_log` varchar(50) DEFAULT NULL,
  `event_desc` varchar(50) DEFAULT NULL,
  `event_para` varchar(50) DEFAULT NULL,
  `event_user` varchar(50) DEFAULT NULL,
  `event_date` varchar(50) DEFAULT NULL,
  `result_code` varchar(50) DEFAULT NULL,
  `result_desc` varchar(50) DEFAULT NULL,
  `result_detail` varchar(50) DEFAULT NULL,
  `user_ip` varchar(50) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `user_name` varchar(50) DEFAULT NULL,
  `login_name` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ;

-- ----------------------------
-- Records of base_log
-- ----------------------------

-- ----------------------------
-- Table structure for `base_menu_role`
-- ----------------------------
DROP TABLE IF EXISTS `base_menu_role`;
CREATE TABLE `base_menu_role` (
  `rid` int(11) DEFAULT NULL,
  `mid` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL
) ;

-- ----------------------------
-- Records of base_menu_role
-- ----------------------------
INSERT INTO `base_menu_role` VALUES ('1', '2', '1');
INSERT INTO `base_menu_role` VALUES ('1', '3', '1');
INSERT INTO `base_menu_role` VALUES ('1', '4', '1');
INSERT INTO `base_menu_role` VALUES ('1', '7', '1');
INSERT INTO `base_menu_role` VALUES ('1', '8', '0');
INSERT INTO `base_menu_role` VALUES ('1', '9', '1');
INSERT INTO `base_menu_role` VALUES ('1', '10', '1');
INSERT INTO `base_menu_role` VALUES ('1', '11', '1');
INSERT INTO `base_menu_role` VALUES ('1', '12', '1');
INSERT INTO `base_menu_role` VALUES ('1', '13', '1');
INSERT INTO `base_menu_role` VALUES ('1', '14', '1');
INSERT INTO `base_menu_role` VALUES ('1', '15', '1');
INSERT INTO `base_menu_role` VALUES ('1', '16', '1');
INSERT INTO `base_menu_role` VALUES ('1', '17', '1');
INSERT INTO `base_menu_role` VALUES ('1', '18', '1');
INSERT INTO `base_menu_role` VALUES ('1', '19', '1');
INSERT INTO `base_menu_role` VALUES ('1', '20', '1');
INSERT INTO `base_menu_role` VALUES ('1', '21', '1');
INSERT INTO `base_menu_role` VALUES ('2', '2', '0');
INSERT INTO `base_menu_role` VALUES ('2', '3', '0');
INSERT INTO `base_menu_role` VALUES ('2', '4', '0');
INSERT INTO `base_menu_role` VALUES ('2', '7', '0');
INSERT INTO `base_menu_role` VALUES ('2', '8', '0');
INSERT INTO `base_menu_role` VALUES ('2', '9', '0');
INSERT INTO `base_menu_role` VALUES ('2', '10', '0');
INSERT INTO `base_menu_role` VALUES ('2', '11', '0');
INSERT INTO `base_menu_role` VALUES ('2', '12', '0');
INSERT INTO `base_menu_role` VALUES ('2', '13', '0');
INSERT INTO `base_menu_role` VALUES ('2', '14', '0');
INSERT INTO `base_menu_role` VALUES ('2', '15', '0');
INSERT INTO `base_menu_role` VALUES ('2', '16', '1');
INSERT INTO `base_menu_role` VALUES ('2', '17', '0');
INSERT INTO `base_menu_role` VALUES ('2', '18', '0');
INSERT INTO `base_menu_role` VALUES ('2', '19', '0');
INSERT INTO `base_menu_role` VALUES ('2', '20', '0');
INSERT INTO `base_menu_role` VALUES ('2', '21', '0');
INSERT INTO `base_menu_role` VALUES ('2', '22', '0');
INSERT INTO `base_menu_role` VALUES ('2', '24', '0');
INSERT INTO `base_menu_role` VALUES ('2', '25', '1');
INSERT INTO `base_menu_role` VALUES ('1', '22', '0');
INSERT INTO `base_menu_role` VALUES ('1', '24', '0');
INSERT INTO `base_menu_role` VALUES ('1', '25', '0');

-- ----------------------------
-- Table structure for `base_mune`
-- ----------------------------
DROP TABLE IF EXISTS `base_mune`;
CREATE TABLE `base_mune` (
  `id` int(11) NOT NULL,
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `imgurl` varchar(50) CHARACTER SET latin1 DEFAULT NULL,
  `mdesc` varchar(50) CHARACTER SET latin1 DEFAULT NULL,
  `address` varchar(50) CHARACTER SET latin1 DEFAULT NULL,
  `mstatus` int(11) DEFAULT NULL,
  `fid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of base_mune
-- ----------------------------
INSERT INTO `base_mune` VALUES ('2', '系统管理', null, null, '#', '1', '0');
INSERT INTO `base_mune` VALUES ('3', '菜单管理', null, null, '/html/menu.html', '1', '2');
INSERT INTO `base_mune` VALUES ('4', '角色管理', null, null, '/html/role.html', '1', '2');
INSERT INTO `base_mune` VALUES ('7', '用户管理', null, null, '/html/user.html', '1', '2');
INSERT INTO `base_mune` VALUES ('8', '日志管理', null, null, '/html/log.html', '1', '2');
INSERT INTO `base_mune` VALUES ('9', '备用', null, null, '/login.html', '1', '0');
INSERT INTO `base_mune` VALUES ('10', '部门管理', null, null, '/html/dept.html', '1', '2');
INSERT INTO `base_mune` VALUES ('11', '字典管理', null, null, '/html/dict.html', '1', '2');
INSERT INTO `base_mune` VALUES ('12', '备用', null, null, '/login.html', '1', '9');
INSERT INTO `base_mune` VALUES ('13', '备用', null, null, '/login.html', '1', '9');
INSERT INTO `base_mune` VALUES ('14', '备用', null, null, '/login.html', '1', '9');
INSERT INTO `base_mune` VALUES ('15', '备用', null, null, '/login.html', '1', '9');
INSERT INTO `base_mune` VALUES ('16', '备用', null, null, '/login.html', '1', '15');
INSERT INTO `base_mune` VALUES ('17', '备用', null, null, '/login.html', '1', '16');
INSERT INTO `base_mune` VALUES ('18', '备用', null, null, '/login.html', '1', '17');
INSERT INTO `base_mune` VALUES ('19', '备用', null, null, '/login.html', '1', '24');
INSERT INTO `base_mune` VALUES ('20', '备用', null, null, '/login.html', '1', '9');
INSERT INTO `base_mune` VALUES ('21', '备用', null, null, '/login.html', '1', '0');
INSERT INTO `base_mune` VALUES ('22', '测试1', null, null, 'ADRESSS1', '1', '0');
INSERT INTO `base_mune` VALUES ('24', '错错错', null, null, 'aaa', '1', '0');
INSERT INTO `base_mune` VALUES ('25', 'cc1', null, null, 'cc', '0', '0');
INSERT INTO `base_mune` VALUES ('26', 'cccc', null, null, 'cccc', '1', '24');

-- ----------------------------
-- Table structure for `base_role`
-- ----------------------------
DROP TABLE IF EXISTS `base_role`;
CREATE TABLE `base_role` (
  `id` int(11) NOT NULL,
  `name` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `rdesc` varchar(50) CHARACTER SET latin1 DEFAULT NULL,
  `code` varchar(50) CHARACTER SET latin1 DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of base_role
-- ----------------------------
INSERT INTO `base_role` VALUES ('1', '管理员', null, null, '1');
INSERT INTO `base_role` VALUES ('2', '测试222', null, null, '1');
INSERT INTO `base_role` VALUES ('3', 'cccc', null, null, '0');

-- ----------------------------
-- Table structure for `base_user`
-- ----------------------------
DROP TABLE IF EXISTS `base_user`;
CREATE TABLE `base_user` (
  `id` int(11) NOT NULL,
  `loginName` varchar(50) DEFAULT NULL,
  `loginPwd` varchar(50) DEFAULT NULL,
  `ustatus` int(11) DEFAULT NULL,
  `wrongCount` int(11) DEFAULT NULL,
  `udate` varchar(50) DEFAULT NULL,
  `rid` int(11) DEFAULT NULL,
  `did` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ;

-- ----------------------------
-- Records of base_user
-- ----------------------------
INSERT INTO `base_user` VALUES ('1', 'admin', '4QrcOUm6Wau+VuBX8g+IPg==', '1', '0', '1484366166054', '1', '1');
INSERT INTO `base_user` VALUES ('2', 'ceshi', '4QrcOUm6Wau+VuBX8g+IPg==', '1', '0', '1484366215445', '1', '7');

-- ----------------------------
-- Table structure for `base_user_info`
-- ----------------------------
DROP TABLE IF EXISTS `base_user_info`;
CREATE TABLE `base_user_info` (
  `id` int(11) NOT NULL,
  `name` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `niceName` varchar(50) DEFAULT NULL,
  `mobile` varchar(50) DEFAULT NULL,
  `emaiil` varchar(50) DEFAULT NULL,
  `IDcard` varchar(50) DEFAULT NULL,
  `address` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ;

-- ----------------------------
-- Records of base_user_info
-- ----------------------------
INSERT INTO `base_user_info` VALUES ('1', '管理员', null, '111', null, '', '');
INSERT INTO `base_user_info` VALUES ('2', '测试', null, '111111', null, '', '');