text: /*
  Navicat MySQL Data Transfer
  
  Source Server         : localhost_3306
  Source Server Version : 50717
  Source Host           : localhost:3306
  Source Database       : test
  
  Target Server Type    : MYSQL
  Target Server Version : 50717
  File Encoding         : 65001
  
  Date: 2019-04-22 10:43:57
  */
  
  SET FOREIGN_KEY_CHECKS=0;
  
  -- ----------------------------
  -- Table structure for `actions`
  -- ----------------------------
  DROP TABLE IF EXISTS `actions`;
  CREATE TABLE `actions` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `user` int(11) DEFAULT NULL,
    `name` varchar(252) NOT NULL,
    `category` int(11) DEFAULT NULL,
    `style` int(11) DEFAULT NULL,
    `sleepnum` int(11) DEFAULT NULL,
    `sql` varchar(252) DEFAULT NULL,
    `testevent` int(11) DEFAULT NULL,
    `caseid` int(11) DEFAULT NULL,
    `requestsurl` varchar(252) DEFAULT NULL,
    `requestsparame` varchar(252) DEFAULT NULL,
    `requestmethod` varchar(8) DEFAULT NULL,
    `status` tinyint(1) DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `ix_actions_name` (`name`),
    KEY `user` (`user`),
    KEY `testevent` (`testevent`),
    CONSTRAINT `actions_ibfk_1` FOREIGN KEY (`user`) REFERENCES `users` (`id`),
    CONSTRAINT `actions_ibfk_2` FOREIGN KEY (`testevent`) REFERENCES `ceshihuanjing` (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of actions
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `alembic_version`
  -- ----------------------------
  DROP TABLE IF EXISTS `alembic_version`;
  CREATE TABLE `alembic_version` (
    `version_num` varchar(32) NOT NULL,
    PRIMARY KEY (`version_num`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of alembic_version
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `caseactions`
  -- ----------------------------
  DROP TABLE IF EXISTS `caseactions`;
  CREATE TABLE `caseactions` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `case` int(11) DEFAULT NULL,
    `action` int(11) DEFAULT NULL,
    `actiontype` int(11) DEFAULT NULL,
    `filed` varchar(252) DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `case` (`case`),
    KEY `action` (`action`),
    CONSTRAINT `caseactions_ibfk_1` FOREIGN KEY (`case`) REFERENCES `interfacetests` (`id`),
    CONSTRAINT `caseactions_ibfk_2` FOREIGN KEY (`action`) REFERENCES `actions` (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of caseactions
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `casegenerals`
  -- ----------------------------
  DROP TABLE IF EXISTS `casegenerals`;
  CREATE TABLE `casegenerals` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `case` int(11) DEFAULT NULL,
    `general` int(11) DEFAULT NULL,
    `filed` varchar(252) DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `case` (`case`),
    KEY `general` (`general`),
    CONSTRAINT `casegenerals_ibfk_1` FOREIGN KEY (`case`) REFERENCES `interfacetests` (`id`),
    CONSTRAINT `casegenerals_ibfk_2` FOREIGN KEY (`general`) REFERENCES `generalconfigurations` (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of casegenerals
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `ceshihuanjing`
  -- ----------------------------
  DROP TABLE IF EXISTS `ceshihuanjing`;
  CREATE TABLE `ceshihuanjing` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `make_user` int(11) DEFAULT NULL,
    `url` varchar(252) DEFAULT NULL,
    `desc` varchar(252) DEFAULT NULL,
    `database` varchar(252) DEFAULT NULL,
    `dbport` varchar(252) DEFAULT NULL,
    `dbhost` varchar(252) DEFAULT NULL,
    `databaseuser` varchar(32) DEFAULT NULL,
    `databasepassword` varchar(32) DEFAULT NULL,
    `project` int(11) DEFAULT NULL,
    `status` tinyint(1) DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `make_user` (`make_user`),
    KEY `project` (`project`),
    CONSTRAINT `ceshihuanjing_ibfk_1` FOREIGN KEY (`make_user`) REFERENCES `users` (`id`),
    CONSTRAINT `ceshihuanjing_ibfk_2` FOREIGN KEY (`project`) REFERENCES `projects` (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of ceshihuanjing
  -- ----------------------------
  INSERT INTO `ceshihuanjing` VALUES ('8', '1', '阿萨德撒的', '萨达萨达', null, null, null, null, null, null, '0');
  INSERT INTO `ceshihuanjing` VALUES ('9', '1', 'ss  ', 'asdasdasd', 'None', 'ddd', 'ddd', 'None', null, '6', '0');
  INSERT INTO `ceshihuanjing` VALUES ('10', '1', 'dasdasdasd  ', 'ssssssasa', 'None', 'asdas', 'asdsad', 'None', null, '6', '0');
  INSERT INTO `ceshihuanjing` VALUES ('11', '1', '萨达萨达   ', '萨达萨达', '阿萨德撒的', 'ddd', 'dd', '萨达萨达', '萨达萨达', '6', '0');
  INSERT INTO `ceshihuanjing` VALUES ('12', '1', 'http:127.0.0.1 ', '本地测试环境', 'testtuling', 'sadsad', 'sadsad', 'root', 'testurl', null, '1');
  INSERT INTO `ceshihuanjing` VALUES ('13', '1', 'dasdasdasd', 'dasdasdasd', 'dasdasdasd', 'dasdasdasd', 'dasdasdasd', 'dasdasdasd', 'dasdasdasd', null, '1');
  
  -- ----------------------------
  -- Table structure for `emailreports`
  -- ----------------------------
  DROP TABLE IF EXISTS `emailreports`;
  CREATE TABLE `emailreports` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `email_re_user_id` int(11) DEFAULT NULL,
    `send_email` varchar(64) DEFAULT NULL,
    `send_email_password` varchar(64) DEFAULT NULL,
    `stmp_email` varchar(64) DEFAULT NULL,
    `port` int(11) DEFAULT NULL,
    `to_email` varchar(64) DEFAULT NULL,
    `default_set` tinyint(1) DEFAULT NULL,
    `status` tinyint(1) DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `email_re_user_id` (`email_re_user_id`),
    CONSTRAINT `emailreports_ibfk_1` FOREIGN KEY (`email_re_user_id`) REFERENCES `users` (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of emailreports
  -- ----------------------------
  INSERT INTO `emailreports` VALUES ('3', '1', 'dd@qq.com', 'dwer', null, null, '[\'dsfsdf\']', '1', '0');
  INSERT INTO `emailreports` VALUES ('4', '1', 'sdfsdf@qq.tyuty', 'sdfsdf', null, null, '[\'asdasd\']', '0', '1');
  INSERT INTO `emailreports` VALUES ('5', '1', 'asdasd@qq.bb', 'sadasdas', null, null, '[\'sadasd\']', '1', '1');
  
  -- ----------------------------
  -- Table structure for `generalconfigurations`
  -- ----------------------------
  DROP TABLE IF EXISTS `generalconfigurations`;
  CREATE TABLE `generalconfigurations` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `user` int(11) DEFAULT NULL,
    `addtime` datetime DEFAULT NULL,
    `name` varchar(252) NOT NULL,
    `style` int(11) DEFAULT NULL,
    `key` varchar(252) DEFAULT NULL,
    `token_parame` varchar(252) DEFAULT NULL,
    `token_url` varchar(252) DEFAULT NULL,
    `token_method` varchar(16) DEFAULT NULL,
    `sqlurl` varchar(252) DEFAULT NULL,
    `request_url` varchar(252) DEFAULT NULL,
    `request_parame` varchar(252) DEFAULT NULL,
    `request_method` varchar(252) DEFAULT NULL,
    `testevent` int(11) DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `ix_generalconfigurations_name` (`name`),
    KEY `user` (`user`),
    KEY `testevent` (`testevent`),
    CONSTRAINT `generalconfigurations_ibfk_1` FOREIGN KEY (`user`) REFERENCES `users` (`id`),
    CONSTRAINT `generalconfigurations_ibfk_2` FOREIGN KEY (`testevent`) REFERENCES `ceshihuanjing` (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of generalconfigurations
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `interfaces`
  -- ----------------------------
  DROP TABLE IF EXISTS `interfaces`;
  CREATE TABLE `interfaces` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `model_id` int(11) DEFAULT NULL,
    `projects_id` int(11) DEFAULT NULL,
    `Interface_name` varchar(252) DEFAULT NULL,
    `Interface_url` varchar(252) DEFAULT NULL,
    `Interface_meth` varchar(252) DEFAULT NULL,
    `Interface_headers` varchar(252) DEFAULT NULL,
    `Interface_user_id` int(11) DEFAULT NULL,
    `interfacetype` varchar(32) DEFAULT NULL,
    `status` tinyint(1) DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `model_id` (`model_id`),
    KEY `projects_id` (`projects_id`),
    KEY `Interface_user_id` (`Interface_user_id`),
    CONSTRAINT `interfaces_ibfk_1` FOREIGN KEY (`model_id`) REFERENCES `models` (`id`),
    CONSTRAINT `interfaces_ibfk_2` FOREIGN KEY (`projects_id`) REFERENCES `projects` (`id`),
    CONSTRAINT `interfaces_ibfk_3` FOREIGN KEY (`Interface_user_id`) REFERENCES `users` (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of interfaces
  -- ----------------------------
  INSERT INTO `interfaces` VALUES ('1', '2', '9', '阿萨德撒的', '萨达萨达', '萨达萨达', null, '1', 'http', '0');
  INSERT INTO `interfaces` VALUES ('2', '2', null, 'asdasdasdasdasdasd', 'http://www.tuling123.com/openapi/api', 'POST', 'asdfasdfadsf', '1', 'http', '0');
  INSERT INTO `interfaces` VALUES ('4', '2', '9', '阿萨德撒的', '萨达萨达', '萨达萨达', null, '1', 'http', '0');
  INSERT INTO `interfaces` VALUES ('5', '2', null, 'asdasdasdasdasdasd', 'http://www.tuling123.com/openapi/api', 'POST', 'asdfasdfadsf', '1', 'http', '0');
  INSERT INTO `interfaces` VALUES ('7', '2', '9', '阿萨德撒的', '萨达萨达', '萨达萨达', null, '1', 'http', '0');
  INSERT INTO `interfaces` VALUES ('8', '2', null, 'asdasdasdasdasdasd', 'http://www.tuling123.com/openapi/api', 'POST', 'asdfasdfadsf', '1', 'http', '0');
  INSERT INTO `interfaces` VALUES ('10', '2', '9', '阿萨德撒的', '萨达萨达', '萨达萨达', null, '1', 'http', '0');
  INSERT INTO `interfaces` VALUES ('11', '2', null, 'asdasdasdasdasdasd', 'http://www.tuling123.com/openapi/api', 'POST', 'asdfasdfadsf', '1', 'http', '0');
  INSERT INTO `interfaces` VALUES ('13', '2', '9', '阿萨德撒的', '萨达萨达', '萨达萨达', null, '1', 'http', '0');
  INSERT INTO `interfaces` VALUES ('14', '2', null, 'asdasdasdasdasdasd', 'http://www.tuling123.com/openapi/api', 'POST', 'asdfasdfadsf', '1', 'http', '0');
  INSERT INTO `interfaces` VALUES ('16', '2', '9', '阿萨德撒的', '萨达萨达', '萨达萨达', null, '1', 'http', '0');
  INSERT INTO `interfaces` VALUES ('17', '2', null, 'asdasdasdasdasdasd', 'http://www.tuling123.com/openapi/api', 'POST', 'asdfasdfadsf', '1', 'http', '0');
  INSERT INTO `interfaces` VALUES ('19', '2', '9', '阿萨德撒的', '萨达萨达', '萨达萨达', null, '1', 'http', '0');
  INSERT INTO `interfaces` VALUES ('20', '2', null, 'asdasdasdasdasdasd', 'http://www.tuling123.com/openapi/api', 'POST', 'asdfasdfadsf', '1', 'http', '0');
  INSERT INTO `interfaces` VALUES ('22', '2', '9', '阿萨德撒的', '萨达萨达', '萨达萨达', null, '1', 'http', '0');
  INSERT INTO `interfaces` VALUES ('23', '2', null, 'asdasdasdasdasdasd', 'http://www.tuling123.com/openapi/api', 'POST', 'asdfasdfadsf', '1', 'http', '0');
  INSERT INTO `interfaces` VALUES ('25', '2', '9', '阿萨德撒的', '萨达萨达', '萨达萨达', null, '1', 'http', '0');
  INSERT INTO `interfaces` VALUES ('26', '2', null, 'asdasdasdasdasdasd', 'http://www.tuling123.com/openapi/api', 'POST', 'asdfasdfadsf', '1', 'http', '0');
  INSERT INTO `interfaces` VALUES ('28', '2', '9', '阿萨德撒的', '萨达萨达', '萨达萨达', null, '1', 'http', '0');
  INSERT INTO `interfaces` VALUES ('29', '2', null, 'asdasdasdasdasdasd', 'http://www.tuling123.com/openapi/api', 'POST', 'asdfasdfadsf', '1', 'http', '0');
  INSERT INTO `interfaces` VALUES ('31', '2', '9', '阿萨德撒的', '萨达萨达', '萨达萨达', null, '1', 'http', '0');
  INSERT INTO `interfaces` VALUES ('32', '2', null, 'asdasdasdasdasdasd', 'http://www.tuling123.com/openapi/api', 'POST', 'asdfasdfadsf', '1', 'http', '0');
  INSERT INTO `interfaces` VALUES ('34', '2', '9', '阿萨德撒的', '萨达萨达', '萨达萨达', null, '1', 'http', '0');
  INSERT INTO `interfaces` VALUES ('35', '2', null, 'asdasdasdasdasdasd', 'http://www.tuling123.com/openapi/api', 'POST', 'asdfasdfadsf', '1', 'http', '0');
  INSERT INTO `interfaces` VALUES ('37', '2', '9', '阿萨德撒的', '萨达萨达', '萨达萨达', null, '1', 'http', '0');
  INSERT INTO `interfaces` VALUES ('38', '2', null, 'asdasdasdasdasdasd', 'http://www.tuling123.com/openapi/api', 'POST', 'asdfasdfadsf', '1', 'http', '0');
  INSERT INTO `interfaces` VALUES ('40', '2', '9', '阿萨德撒的', '萨达萨达', '萨达萨达', null, '1', 'http', '0');
  INSERT INTO `interfaces` VALUES ('41', '2', null, 'asdasdasdasdasdasd', 'http://www.tuling123.com/openapi/api', 'POST', 'asdfasdfadsf', '1', 'http', '0');
  INSERT INTO `interfaces` VALUES ('43', '2', '9', '阿萨德撒的', '萨达萨达', '萨达萨达', null, '1', 'http', '0');
  INSERT INTO `interfaces` VALUES ('44', '2', null, 'asdasdasdasdasdasd', 'http://www.tuling123.com/openapi/api', 'POST', 'asdfasdfadsf', '1', 'http', '0');
  INSERT INTO `interfaces` VALUES ('46', '2', '9', '阿萨德撒的', '萨达萨达', '萨达萨达', null, '1', 'http', '0');
  INSERT INTO `interfaces` VALUES ('47', '2', null, 'asdasdasdasdasdasd', 'http://www.tuling123.com/openapi/api', 'POST', 'asdfasdfadsf', '1', 'http', '0');
  INSERT INTO `interfaces` VALUES ('49', '2', '9', '阿萨德撒的', '萨达萨达', '萨达萨达', null, '1', 'http', '0');
  INSERT INTO `interfaces` VALUES ('50', '2', null, 'asdasdasdasdasdasd', 'http://www.tuling123.com/openapi/api', 'POST', 'asdfasdfadsf', '1', 'http', '0');
  INSERT INTO `interfaces` VALUES ('52', '2', '9', '阿萨德撒的', '萨达萨达', '萨达萨达', null, '1', 'http', '0');
  INSERT INTO `interfaces` VALUES ('53', '2', null, 'asdasdasdasdasdasd', 'http://www.tuling123.com/openapi/api', 'POST', 'asdfasdfadsf', '1', 'http', '0');
  
  -- ----------------------------
  -- Table structure for `interfacetests`
  -- ----------------------------
  DROP TABLE IF EXISTS `interfacetests`;
  CREATE TABLE `interfacetests` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `model_id` int(11) DEFAULT NULL,
    `projects_id` int(11) DEFAULT NULL,
    `interface_id` int(11) DEFAULT NULL,
    `bian_num` varchar(252) DEFAULT NULL,
    `interface_type` varchar(16) DEFAULT NULL,
    `Interface_name` varchar(252) DEFAULT NULL,
    `Interface_url` varchar(252) DEFAULT NULL,
    `Interface_meth` varchar(252) DEFAULT NULL,
    `Interface_pase` varchar(252) DEFAULT NULL,
    `Interface_assert` varchar(252) DEFAULT NULL,
    `Interface_headers` varchar(252) DEFAULT NULL,
    `pid` int(11) DEFAULT NULL,
    `getattr_p` varchar(252) DEFAULT NULL,
    `Interface_is_tiaoshi` tinyint(1) DEFAULT NULL,
    `Interface_tiaoshi_shifou` tinyint(1) DEFAULT NULL,
    `Interface_user_id` int(11) DEFAULT NULL,
    `saveresult` tinyint(1) DEFAULT NULL,
    `is_database` tinyint(1) DEFAULT NULL,
    `chaxunshujuku` varchar(252) DEFAULT NULL,
    `databaseziduan` varchar(252) DEFAULT NULL,
    `status` tinyint(1) DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `model_id` (`model_id`),
    KEY `projects_id` (`projects_id`),
    KEY `interface_id` (`interface_id`),
    KEY `pid` (`pid`),
    KEY `Interface_user_id` (`Interface_user_id`),
    CONSTRAINT `interfacetests_ibfk_1` FOREIGN KEY (`model_id`) REFERENCES `models` (`id`),
    CONSTRAINT `interfacetests_ibfk_2` FOREIGN KEY (`projects_id`) REFERENCES `projects` (`id`),
    CONSTRAINT `interfacetests_ibfk_3` FOREIGN KEY (`interface_id`) REFERENCES `interfaces` (`id`),
    CONSTRAINT `interfacetests_ibfk_4` FOREIGN KEY (`pid`) REFERENCES `interfacetests` (`id`),
    CONSTRAINT `interfacetests_ibfk_5` FOREIGN KEY (`Interface_user_id`) REFERENCES `users` (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of interfacetests
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `mockserver`
  -- ----------------------------
  DROP TABLE IF EXISTS `mockserver`;
  CREATE TABLE `mockserver` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `make_uers` int(11) DEFAULT NULL,
    `name` varchar(55) DEFAULT NULL,
    `path` varchar(252) DEFAULT NULL,
    `methods` varchar(50) DEFAULT NULL,
    `headers` varchar(500) DEFAULT NULL,
    `description` varchar(50) DEFAULT NULL,
    `fanhui` varchar(500) DEFAULT NULL,
    `params` varchar(500) DEFAULT NULL,
    `rebacktype` varchar(32) DEFAULT NULL,
    `update_time` datetime DEFAULT NULL,
    `status` tinyint(1) DEFAULT NULL,
    `delete` tinyint(1) DEFAULT NULL,
    `ischeck` tinyint(1) DEFAULT NULL,
    `is_headers` tinyint(1) DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `make_uers` (`make_uers`),
    CONSTRAINT `mockserver_ibfk_1` FOREIGN KEY (`make_uers`) REFERENCES `users` (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of mockserver
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `models`
  -- ----------------------------
  DROP TABLE IF EXISTS `models`;
  CREATE TABLE `models` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `model_name` varchar(256) DEFAULT NULL,
    `model_user_id` int(11) DEFAULT NULL,
    `status` tinyint(1) DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `model_user_id` (`model_user_id`),
    CONSTRAINT `models_ibfk_1` FOREIGN KEY (`model_user_id`) REFERENCES `users` (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of models
  -- ----------------------------
  INSERT INTO `models` VALUES ('1', '添加', '1', '1');
  INSERT INTO `models` VALUES ('2', '登录', '1', '1');
  INSERT INTO `models` VALUES ('3', '的订单', '1', '0');
  INSERT INTO `models` VALUES ('4', '添加阿萨德撒的', '1', '0');
  INSERT INTO `models` VALUES ('5', '添加', '1', '1');
  INSERT INTO `models` VALUES ('6', '登录', '1', '1');
  INSERT INTO `models` VALUES ('7', '的订单', '1', '0');
  INSERT INTO `models` VALUES ('8', '添加阿萨德撒的', '1', '0');
  INSERT INTO `models` VALUES ('9', '添加', '1', '1');
  INSERT INTO `models` VALUES ('10', '登录', '1', '1');
  INSERT INTO `models` VALUES ('11', '的订单', '1', '0');
  INSERT INTO `models` VALUES ('12', '添加阿萨德撒的', '1', '0');
  INSERT INTO `models` VALUES ('13', '添加', '1', '1');
  INSERT INTO `models` VALUES ('14', '登录', '1', '1');
  INSERT INTO `models` VALUES ('15', '的订单', '1', '0');
  INSERT INTO `models` VALUES ('16', '添加阿萨德撒的', '1', '0');
  INSERT INTO `models` VALUES ('17', '添加', '1', '1');
  INSERT INTO `models` VALUES ('18', '登录', '1', '1');
  INSERT INTO `models` VALUES ('19', '的订单', '1', '0');
  INSERT INTO `models` VALUES ('20', '添加阿萨德撒的', '1', '0');
  INSERT INTO `models` VALUES ('21', '添加', '1', '1');
  INSERT INTO `models` VALUES ('22', '登录', '1', '1');
  INSERT INTO `models` VALUES ('23', '的订单', '1', '0');
  INSERT INTO `models` VALUES ('24', '添加阿萨德撒的', '1', '0');
  INSERT INTO `models` VALUES ('25', '添加', '1', '1');
  INSERT INTO `models` VALUES ('26', '登录', '1', '1');
  INSERT INTO `models` VALUES ('27', '的订单', '1', '0');
  INSERT INTO `models` VALUES ('28', '添加阿萨德撒的', '1', '0');
  
  -- ----------------------------
  -- Table structure for `parames`
  -- ----------------------------
  DROP TABLE IF EXISTS `parames`;
  CREATE TABLE `parames` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `interface_id` int(11) DEFAULT NULL,
    `parameter_type` varchar(64) DEFAULT NULL,
    `parameter_name` varchar(64) DEFAULT NULL,
    `necessary` tinyint(1) DEFAULT NULL,
    `type` int(11) DEFAULT NULL,
    `status` tinyint(1) DEFAULT NULL,
    `default` varchar(63) DEFAULT NULL,
    `desc` varchar(252) DEFAULT NULL,
    `user_id` int(11) DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `interface_id` (`interface_id`),
    KEY `user_id` (`user_id`),
    CONSTRAINT `parames_ibfk_1` FOREIGN KEY (`interface_id`) REFERENCES `interfaces` (`id`),
    CONSTRAINT `parames_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of parames
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `projects`
  -- ----------------------------
  DROP TABLE IF EXISTS `projects`;
  CREATE TABLE `projects` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `project_user_id` int(11) DEFAULT NULL,
    `project_name` varchar(252) DEFAULT NULL,
    `status` tinyint(1) DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `project_name` (`project_name`),
    KEY `project_user_id` (`project_user_id`),
    CONSTRAINT `projects_ibfk_1` FOREIGN KEY (`project_user_id`) REFERENCES `users` (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of projects
  -- ----------------------------
  INSERT INTO `projects` VALUES ('1', '1', '昨夜西风凋碧树', '0');
  INSERT INTO `projects` VALUES ('2', '1', 'asdasd', '0');
  INSERT INTO `projects` VALUES ('3', '1', '啊实打实的萨达萨达', '0');
  INSERT INTO `projects` VALUES ('4', '1', 'dasdasdsad', '1');
  INSERT INTO `projects` VALUES ('5', '1', 'asdsad', '0');
  INSERT INTO `projects` VALUES ('6', '1', 'asdasdasdasd', '1');
  INSERT INTO `projects` VALUES ('7', '1', 'sadf ', '0');
  INSERT INTO `projects` VALUES ('8', '7', 'dd', '0');
  INSERT INTO `projects` VALUES ('9', '7', 'ddss', '1');
  INSERT INTO `projects` VALUES ('10', '7', 'ddss1', '1');
  INSERT INTO `projects` VALUES ('11', '7', 'ddss122', '1');
  INSERT INTO `projects` VALUES ('12', '7', 'sdasd', '1');
  INSERT INTO `projects` VALUES ('13', '7', 'sdasddsd', '1');
  
  -- ----------------------------
  -- Table structure for `quanxians`
  -- ----------------------------
  DROP TABLE IF EXISTS `quanxians`;
  CREATE TABLE `quanxians` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `rose` int(11) DEFAULT NULL,
    `project` int(11) DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `rose` (`rose`),
    KEY `project` (`project`),
    CONSTRAINT `quanxians_ibfk_1` FOREIGN KEY (`rose`) REFERENCES `roles` (`id`),
    CONSTRAINT `quanxians_ibfk_2` FOREIGN KEY (`project`) REFERENCES `projects` (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of quanxians
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `quanxianusers`
  -- ----------------------------
  DROP TABLE IF EXISTS `quanxianusers`;
  CREATE TABLE `quanxianusers` (
    `user_id` int(11) DEFAULT NULL,
    `quanxians_id` int(11) DEFAULT NULL,
    KEY `user_id` (`user_id`),
    KEY `quanxians_id` (`quanxians_id`),
    CONSTRAINT `quanxianusers_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
    CONSTRAINT `quanxianusers_ibfk_2` FOREIGN KEY (`quanxians_id`) REFERENCES `quanxians` (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of quanxianusers
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `registrations`
  -- ----------------------------
  DROP TABLE IF EXISTS `registrations`;
  CREATE TABLE `registrations` (
    `task_id` int(11) DEFAULT NULL,
    `interfacetests_id` int(11) DEFAULT NULL,
    KEY `task_id` (`task_id`),
    KEY `interfacetests_id` (`interfacetests_id`),
    CONSTRAINT `registrations_ibfk_1` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`),
    CONSTRAINT `registrations_ibfk_2` FOREIGN KEY (`interfacetests_id`) REFERENCES `interfacetests` (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of registrations
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `roles`
  -- ----------------------------
  DROP TABLE IF EXISTS `roles`;
  CREATE TABLE `roles` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(64) DEFAULT NULL,
    `default` tinyint(1) DEFAULT NULL,
    `permissions` int(11) DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `name` (`name`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of roles
  -- ----------------------------
  INSERT INTO `roles` VALUES ('1', 'User', '0', '7');
  INSERT INTO `roles` VALUES ('2', 'Oneadmin', '0', '15');
  INSERT INTO `roles` VALUES ('3', 'Administrator', '0', '255');
  
  -- ----------------------------
  -- Table structure for `tasks`
  -- ----------------------------
  DROP TABLE IF EXISTS `tasks`;
  CREATE TABLE `tasks` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `makeuser` int(11) DEFAULT NULL,
    `taskname` varchar(32) DEFAULT NULL,
    `taskstart` varchar(252) DEFAULT NULL,
    `taskmakedate` datetime DEFAULT NULL,
    `taskrepor_to` varchar(252) DEFAULT NULL,
    `taskrepor_cao` varchar(252) DEFAULT NULL,
    `task_make_email` varchar(252) DEFAULT NULL,
    `status` tinyint(1) DEFAULT NULL,
    `yunxing_status` varchar(16) DEFAULT NULL,
    `prject` int(11) DEFAULT NULL,
    `testevent` int(11) DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `makeuser` (`makeuser`),
    KEY `prject` (`prject`),
    KEY `testevent` (`testevent`),
    CONSTRAINT `tasks_ibfk_1` FOREIGN KEY (`makeuser`) REFERENCES `users` (`id`),
    CONSTRAINT `tasks_ibfk_2` FOREIGN KEY (`prject`) REFERENCES `projects` (`id`),
    CONSTRAINT `tasks_ibfk_3` FOREIGN KEY (`testevent`) REFERENCES `ceshihuanjing` (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of tasks
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `testcaseresults`
  -- ----------------------------
  DROP TABLE IF EXISTS `testcaseresults`;
  CREATE TABLE `testcaseresults` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `case_id` int(11) DEFAULT NULL,
    `result` varchar(252) DEFAULT NULL,
    `date` datetime DEFAULT NULL,
    `testevir` int(11) DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `case_id` (`case_id`),
    KEY `testevir` (`testevir`),
    CONSTRAINT `testcaseresults_ibfk_1` FOREIGN KEY (`case_id`) REFERENCES `interfacetests` (`id`),
    CONSTRAINT `testcaseresults_ibfk_2` FOREIGN KEY (`testevir`) REFERENCES `ceshihuanjing` (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of testcaseresults
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `tstresults`
  -- ----------------------------
  DROP TABLE IF EXISTS `tstresults`;
  CREATE TABLE `tstresults` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `Test_user_id` int(11) DEFAULT NULL,
    `test_num` int(11) DEFAULT NULL,
    `pass_num` int(11) DEFAULT NULL,
    `fail_num` int(11) DEFAULT NULL,
    `Exception_num` int(11) DEFAULT NULL,
    `can_num` int(11) DEFAULT NULL,
    `wei_num` int(11) DEFAULT NULL,
    `projects_id` int(11) DEFAULT NULL,
    `test_time` datetime DEFAULT NULL,
    `hour_time` int(11) DEFAULT NULL,
    `test_rep` varchar(252) DEFAULT NULL,
    `test_log` varchar(252) DEFAULT NULL,
    `status` tinyint(1) DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `Test_user_id` (`Test_user_id`),
    KEY `projects_id` (`projects_id`),
    CONSTRAINT `tstresults_ibfk_1` FOREIGN KEY (`Test_user_id`) REFERENCES `users` (`id`),
    CONSTRAINT `tstresults_ibfk_2` FOREIGN KEY (`projects_id`) REFERENCES `projects` (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of tstresults
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `users`
  -- ----------------------------
  DROP TABLE IF EXISTS `users`;
  CREATE TABLE `users` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `username` varchar(63) DEFAULT NULL,
    `password` varchar(252) DEFAULT NULL,
    `user_email` varchar(64) DEFAULT NULL,
    `status` tinyint(1) DEFAULT NULL,
    `is_login` tinyint(1) DEFAULT NULL,
    `is_sper` tinyint(1) DEFAULT NULL,
    `work_id` int(11) DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `username` (`username`),
    UNIQUE KEY `user_email` (`user_email`),
    KEY `work_id` (`work_id`),
    CONSTRAINT `users_ibfk_1` FOREIGN KEY (`work_id`) REFERENCES `works` (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of users
  -- ----------------------------
  INSERT INTO `users` VALUES ('1', 'liwanlei', 'pbkdf2:sha256:50000$H2XVXtY6$06878e9c817c7a1dfba6caaa2e58256726f2fd4eafea8b493fddaa6236f74329', '952943386@qq.com', '0', '1', '1', '1');
  INSERT INTO `users` VALUES ('2', 'eewrewr', 'pbkdf2:sha256:50000$4i6Pbd9N$037662ab9611088b2b6cded8fcad9ab09e5886ca6ea979817c68df954c398499', '99324432432', '0', null, '0', '1');
  INSERT INTO `users` VALUES ('5', 'liwanleil', 'pbkdf2:sha256:50000$0OKoPwym$d41abf01a84d3b973103bd31ca3194633d4d3c04161d5e1d3d48e10d5ef291cc', '32423432', '0', null, '0', '2');
  INSERT INTO `users` VALUES ('7', 'liwanlei123', 'pbkdf2:sha256:50000$wmfUrJpv$66d849c3b279ef8fe863ee3c84977f9f4787255110c867ea7a8e0abf12db824b', 'liwanlei', '0', null, '0', '1');
  INSERT INTO `users` VALUES ('9', 'liwanlei11', 'pbkdf2:sha256:50000$215EW9H2$3904ebc2814d19d77d5b3410e9fc3ddd6b36be4ae8e65e6a5e6ce0ffcb1e1451', '12121212', '0', null, '0', '1');
  INSERT INTO `users` VALUES ('10', 'admin', 'pbkdf2:sha256:50000$FMK2Wp13$d41783225ddc9057a6b78076cde6df2111a52ab83cbfc42238b19fb25e7e622a', 'slitobo@163.com', '1', null, '0', '1');
  INSERT INTO `users` VALUES ('11', 'Test', 'pbkdf2:sha256:50000$85nqYzxM$853128989c4ca8854ba3cbc1792074338956c09d828c4e13ccc13c3eecd5970b', 'Test@qq.com', '0', null, '0', '1');
  INSERT INTO `users` VALUES ('12', 'liwanlei345', 'pbkdf2:sha256:50000$Gcrd8CAG$16c48e5863596e6f42a764eecd94c6cc90801ce8e2ba25155f41ffb6f1f03823', 'liwanlei@qq.com', '0', null, '0', '1');
  INSERT INTO `users` VALUES ('16', 'zhangyan', 'pbkdf2:sha256:50000$vnn1svKe$952ea026f8f2cae3c193254ca08ed11a7053ae294bea7c992f9f3e0b7592a401', '1392364470', '0', null, '0', '1');
  INSERT INTO `users` VALUES ('17', 'james', 'pbkdf2:sha256:50000$k1Agosjm$c704984da17747c5d8dc41fab46ca00fc1eadb389c9da342bf5d32acf458150a', '984106718@qq.com', '0', null, '0', '1');
  INSERT INTO `users` VALUES ('18', 'Ahre', 'pbkdf2:sha256:50000$GmY74OIM$c2bb446c0a09b27f968f9e81a14b03bb303027274cb2a0d935615be2584669ca', '121983006@qq.com', '0', null, '0', '1');
  INSERT INTO `users` VALUES ('19', '1234', 'pbkdf2:sha256:50000$y6zq0qWy$e8766a9ce6ca0ae4c0da8627bd741ea3d0d193bfd4679144997edb67ab456151', '123', '0', null, '0', null);
  INSERT INTO `users` VALUES ('20', '111111', 'pbkdf2:sha256:50000$wYgqrQQA$a36ee60eb57d61b7b31f1c30c6338e2dbd0ad7c57e133fccfea6a3298be5b393', '111', '0', null, '0', null);
  INSERT INTO `users` VALUES ('21', 'sky216', 'pbkdf2:sha256:50000$e6JMhZi3$4aea5ddeac3937a24b869e88b5e53f78918fb694efe8d7d37d3ca39fb00cc9f6', '3358372183@qq.com', '0', null, '0', null);
  INSERT INTO `users` VALUES ('22', 'test123', 'pbkdf2:sha256:50000$6RV2HjgA$4e1a7aec9190d770ba432f83b5472c4c51f1ee54c428f30e7e0a96216fcb87ed', 'test@test.com', '0', null, '0', null);
  
  -- ----------------------------
  -- Table structure for `works`
  -- ----------------------------
  DROP TABLE IF EXISTS `works`;
  CREATE TABLE `works` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(32) DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `name` (`name`)
  ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of works
  -- ----------------------------
  INSERT INTO `works` VALUES ('3', '测试主管');
  INSERT INTO `works` VALUES ('1', '测试工程师');
  INSERT INTO `works` VALUES ('4', '测试经理');
  INSERT INTO `works` VALUES ('2', '自动化测试工程师');
  
  -- ----------------------------
  -- Table structure for `yilai`
  -- ----------------------------
  DROP TABLE IF EXISTS `yilai`;
  CREATE TABLE `yilai` (
    `case_id` int(11) DEFAULT NULL,
    `cases_id` int(11) DEFAULT NULL,
    `attred` varchar(32) DEFAULT NULL,
    KEY `case_id` (`case_id`),
    KEY `cases_id` (`cases_id`),
    CONSTRAINT `yilai_ibfk_1` FOREIGN KEY (`case_id`) REFERENCES `interfacetests` (`id`),
    CONSTRAINT `yilai_ibfk_2` FOREIGN KEY (`cases_id`) REFERENCES `interfacetests` (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of yilai
  -- ----------------------------
  