/*
SQLyog Ultimate v12.09 (64 bit)
MySQL - 5.7.26 : Database - atcrowdfunding
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`atcrowdfundin` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci */;

USE `atcrowdfundin`;

/*Table structure for table `t_permission` */

DROP TABLE IF EXISTS `t_permission`;

CREATE TABLE `t_permission` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `pid` int(11) DEFAULT NULL,
  `url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `icon` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

/*Data for the table `t_permission` */

insert  into `t_permission`(`id`,`name`,`pid`,`url`,`icon`) values (1,'系统菜单',0,NULL,'glyphicon glyphicon-th-list'),(2,'控制面板',1,'/main','glyphicon glyphicon-dashboard'),(3,'权限维护',1,NULL,'glyphicon glyphicon-tasks'),(4,'用户维护',3,'/user/index','glyphicon glyphicon-user'),(5,'角色维护',3,'/role/index','glyphicon glyphicon-king'),(6,'许可维护',3,'/permission/index','glyphicon glyphicon-lock'),(13,'bbb',3,'http://funnywu.free.idcfengye.com',NULL),(20,'test01',19,'test01',NULL),(18,'sgres',3,'serges',NULL),(19,'test',1,'test',NULL);

/*Table structure for table `t_role` */

DROP TABLE IF EXISTS `t_role`;

CREATE TABLE `t_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

/*Data for the table `t_role` */

insert  into `t_role`(`id`,`name`) values (1,'PM-项目经理'),(2,'SE-软件工程师'),(3,'PG-程序员'),(4,'TL-组长'),(5,'GL-组员'),(6,'QC-品质控制'),(7,'SA-软件架构师'),(8,'CMO/CMS-配置管理'),(9,'SYSTEM-系统管理');

/*Table structure for table `t_role_permission` */

DROP TABLE IF EXISTS `t_role_permission`;

CREATE TABLE `t_role_permission` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `roleid` int(11) DEFAULT NULL,
  `permissionid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=59 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

/*Data for the table `t_role_permission` */

insert  into `t_role_permission`(`id`,`roleid`,`permissionid`) values (42,1,3),(19,2,4),(53,3,2),(15,2,4),(14,2,3),(13,2,1),(41,1,2),(40,1,1),(52,3,1),(44,1,5),(43,1,4),(58,9,6),(57,9,5),(56,9,3),(55,9,2),(54,9,1),(45,1,6);

/*Table structure for table `t_user` */

DROP TABLE IF EXISTS `t_user`;

CREATE TABLE `t_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(25) DEFAULT NULL,
  `loginacct` varchar(30) DEFAULT NULL,
  `userpwd` varchar(30) DEFAULT NULL,
  `email` varchar(30) DEFAULT NULL,
  `createTime` char(19) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;

/*Data for the table `t_user` */

insert  into `t_user`(`id`,`username`,`loginacct`,`userpwd`,`email`,`createTime`) values (1,'admin','admin','admin','admin@163.com','20-03-28 01:07:55'),(5,'funny','funny','funny','aa1163.com','2020-03-26 13:39:49'),(6,'bbb','bbb','abc123','bbb163.com','2020-03-26 18:19:56'),(15,'cc11','cc11','abc123','cc11@163.com','20-03-27 01:07:51'),(19,'cc','cc','abc123','cc@163.com','20-03-27 01:07:55'),(20,'dd','dd','abc123','dd@163.com','20-03-27 01:07:55'),(21,'ee','ee','abc123','ee@163.com','20-03-27 01:07:55'),(22,'ff','ff','abc123','ff@163.com','20-03-27 01:07:55');

/*Table structure for table `t_user_role` */

DROP TABLE IF EXISTS `t_user_role`;

CREATE TABLE `t_user_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) DEFAULT NULL,
  `roleid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

/*Data for the table `t_user_role` */

insert  into `t_user_role`(`id`,`userid`,`roleid`) values (25,1,9);

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;