master

分支 (1)

管理

管理

master

p2p
/
p2p.sql

# Host: 10.1.11.30  (Version: 5.6.10-log)
# Date: 2014-12-08 21:06:24
# Generator: MySQL-Front 5.3  (Build 4.41)

/*!40101 SET NAMES utf8 */;

#
# Structure for table "admin"
#

CREATE TABLE `admin` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_login` varchar(50) DEFAULT NULL COMMENT '登录名',
  `user_pass` varchar(50) DEFAULT NULL COMMENT '密码',
  `user_name` varchar(50) NOT NULL DEFAULT '',
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `fax` varchar(50) DEFAULT NULL COMMENT '传真',
  `avatar_url` varchar(255) DEFAULT NULL,
  `user_status` int(11) DEFAULT NULL COMMENT '状态',
  `org_id` int(11) unsigned DEFAULT NULL,
  `parent_id` int(11) unsigned DEFAULT NULL,
  `site` int(1) DEFAULT '1',
  `gmt_create` datetime DEFAULT NULL,
  `gmt_modify` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8 COMMENT='管理员';

#
# Data for table "admin"
#

INSERT INTO `admin` VALUES (4,'liaojianfeng','e10adc3949ba59abbe56e057f20f883e','廖剑峰','liaojianfeng@hikvision.com.cn','123123',NULL,NULL,1,NULL,NULL,2048,'2014-08-15 10:33:40','2014-08-15 10:50:12'),(6,'lifahui','e10adc3949ba59abbe56e057f20f883e','LIFAHUI','lifahui@hikvision.com.cn','123456',NULL,NULL,1,NULL,NULL,2048,'2014-08-30 16:15:50','2014-10-30 09:48:22'),(19,'xishengchun','e10adc3949ba59abbe56e057f20f883e','xishengchun','xishengchun@hikvision.com.cn',NULL,NULL,NULL,1,NULL,NULL,2048,'2014-10-29 18:53:14','2014-10-30 09:47:48'),(20,'lulei3','e10adc3949ba59abbe56e057f20f883e','lulei3','lulei3@hikvision.com.cn',NULL,NULL,NULL,1,NULL,NULL,2048,'2014-10-29 20:13:52','2014-10-30 09:47:41'),(21,'wanfei','e10adc3949ba59abbe56e057f20f883e','宛斐','wanfei@hikvision.com.cn','13735465000',NULL,NULL,1,NULL,NULL,2048,'2014-10-29 20:16:45','2014-10-30 09:42:45'),(22,'guhailin','e10adc3949ba59abbe56e057f20f883e','顾海林','guhailin@hikvision.com.cn','18806535332',NULL,NULL,1,NULL,NULL,2048,'2014-10-30 08:30:09','2014-10-30 09:47:54'),(23,'huanghuazhang','e10adc3949ba59abbe56e057f20f883e','黄华章','huanghuazhang@hikvision.com.cn','17095212301',NULL,NULL,1,NULL,NULL,2048,'2014-10-30 08:48:53','2014-10-30 09:47:33'),(27,'lijinghuan','e10adc3949ba59abbe56e057f20f883e','李敬欢','lijinghuan@hikvision.com.cn','13806505016',NULL,NULL,1,NULL,NULL,2048,'2014-11-28 16:10:10','2014-11-28 16:24:09');

#
# Structure for table "admin_role"
#

CREATE TABLE `admin_role` (
  `admin_id` int(11) unsigned NOT NULL DEFAULT '0',
  `role_id` int(11) unsigned NOT NULL DEFAULT '0',
  `gmt_create` datetime DEFAULT NULL,
  PRIMARY KEY (`admin_id`,`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Data for table "admin_role"
#

INSERT INTO `admin_role` VALUES (1,1,'2014-08-05 19:36:23'),(4,1,'2014-08-15 10:50:12'),(5,1,'2014-08-19 13:57:00'),(6,2,'2014-10-30 09:48:22'),(14,1,'2014-09-15 19:16:54'),(19,2,'2014-10-30 09:47:48'),(20,2,'2014-10-30 09:47:41'),(21,1,'2014-10-30 09:42:45'),(22,2,'2014-10-30 09:47:54'),(23,2,'2014-10-30 09:47:33'),(27,2,'2014-11-28 16:24:09');

#
# Structure for table "permission_group"
#

CREATE TABLE `permission_group` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL COMMENT '分组名称',
  `parent_id` int(11) unsigned DEFAULT NULL COMMENT '父分组ID',
  `type` int(1) DEFAULT NULL,
  `site` int(1) DEFAULT '1' COMMENT '1-经销B2B,2-民用B2B',
  `gmt_create` datetime DEFAULT NULL,
  `gmt_modify` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

#
# Data for table "permission_group"
#

INSERT INTO `permission_group` VALUES (1,'system',NULL,NULL,1024,'2014-08-05 15:58:00','2014-08-05 16:00:06'),(2,'系统管理',NULL,NULL,1024,'2014-08-05 19:44:09','2014-08-05 19:44:09'),(3,'公众号',NULL,NULL,2048,'2014-10-30 09:45:52','2014-10-30 09:45:52');

#
# Structure for table "permissions"
#

CREATE TABLE `permissions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `component` varchar(255) DEFAULT NULL,
  `target` varchar(255) DEFAULT NULL,
  `action` varchar(255) DEFAULT NULL,
  `event` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `group_id` int(11) unsigned DEFAULT NULL,
  `site` int(1) DEFAULT '1' COMMENT '1-经销B2B,2-民用B2B',
  `gmt_create` datetime DEFAULT NULL,
  `gmt_modify` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

#
# Data for table "permissions"
#

INSERT INTO `permissions` VALUES (1,'首页','admin','/main',NULL,NULL,NULL,1,1024,'2014-08-05 16:30:01','2014-08-05 16:30:01'),(2,'角色列表','admin','/roles/list',NULL,NULL,NULL,2,1024,'2014-08-05 19:44:32','2014-08-05 19:44:32'),(3,'权限分组列表','admin','/permissions/listGroup',NULL,NULL,NULL,2,1024,'2014-08-05 19:45:09','2014-08-05 19:45:09'),(4,'权限列表','admin','/permissions/list',NULL,NULL,NULL,2,1024,'2014-08-05 19:45:30','2014-08-05 19:45:30'),(5,'系统用户列表','admin','/admins/list',NULL,NULL,NULL,2,1024,'2014-08-05 19:46:09','2014-08-05 19:46:09'),(6,'我的公众号','admin','/publicsMy/list',NULL,NULL,NULL,3,2048,'2014-10-30 09:47:06','2014-10-30 09:47:06');

#
# Structure for table "role_permission"
#

CREATE TABLE `role_permission` (
  `role_id` int(11) unsigned NOT NULL DEFAULT '0',
  `permission_id` int(11) unsigned NOT NULL DEFAULT '0',
  `gmt_create` datetime DEFAULT NULL,
  PRIMARY KEY (`role_id`,`permission_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色权限';

#
# Data for table "role_permission"
#

INSERT INTO `role_permission` VALUES (1,1,'2014-10-30 09:47:25'),(1,2,'2014-10-30 09:47:25'),(1,3,'2014-10-30 09:47:25'),(1,4,'2014-10-30 09:47:25'),(1,5,'2014-10-30 09:47:25'),(1,6,'2014-10-30 09:47:25'),(2,1,'2014-10-30 09:47:13'),(2,6,'2014-10-30 09:47:13');

#
# Structure for table "roles"
#

CREATE TABLE `roles` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `role_name` varchar(255) DEFAULT NULL,
  `role_type` int(11) DEFAULT NULL,
  `role_level` int(11) DEFAULT NULL,
  `site` int(1) DEFAULT '1' COMMENT '1-经销B2B,2-民用B2B',
  `gmt_create` datetime DEFAULT NULL,
  `gmt_modify` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

#
# Data for table "roles"
#

INSERT INTO `roles` VALUES (1,'系统管理员',NULL,10,1024,'2014-08-05 19:13:49','2014-08-05 19:13:49'),(2,'公众号管理员',NULL,50,2048,'2014-10-30 09:45:27','2014-10-30 09:45:27');