验证中...
wly.sql
Raw Copy
/*
Navicat MySQL Data Transfer
Source Server : 192.168.1.32
Source Server Version : 50644
Source Host : 192.168.1.32:3306
Source Database : wly
Target Server Type : MYSQL
Target Server Version : 50644
File Encoding : 65001
Date: 2019-05-17 13:48:12
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for auto_test_case
-- ----------------------------
DROP TABLE IF EXISTS `auto_test_case`;
CREATE TABLE `auto_test_case` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`model_id` tinyint(10) DEFAULT NULL,
`url` varchar(255) DEFAULT NULL,
`case_name` varchar(255) DEFAULT NULL,
`create_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
`update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
`is_delete` tinyint(1) DEFAULT NULL,
`value` varchar(255) DEFAULT NULL,
`ylzd1` varchar(255) DEFAULT NULL,
`ylzd2` varchar(255) DEFAULT NULL,
`ylzd3` varchar(255) DEFAULT NULL,
`ylzd4` varchar(255) DEFAULT NULL,
`ylzd5` varchar(255) DEFAULT NULL,
`ylzd6` varchar(255) DEFAULT NULL,
`ylzd7` varchar(255) DEFAULT NULL,
`ylzd8` varchar(255) DEFAULT NULL,
`ylzd9` varchar(255) DEFAULT NULL,
`case_id` smallint(10) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `model_id` (`model_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1472 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for auto_test_case_copy
-- ----------------------------
DROP TABLE IF EXISTS `auto_test_case_copy`;
CREATE TABLE `auto_test_case_copy` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`model_id` tinyint(10) DEFAULT NULL,
`url` varchar(255) DEFAULT NULL,
`case_name` varchar(255) DEFAULT NULL,
`create_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
`update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
`is_delete` tinyint(1) DEFAULT NULL,
`value` varchar(255) DEFAULT NULL,
`ylzd1` varchar(255) DEFAULT NULL,
`ylzd2` varchar(255) DEFAULT NULL,
`ylzd3` varchar(255) DEFAULT NULL,
`ylzd4` varchar(255) DEFAULT NULL,
`ylzd5` varchar(255) DEFAULT NULL,
`ylzd6` varchar(255) DEFAULT NULL,
`ylzd7` varchar(255) DEFAULT NULL,
`ylzd8` varchar(255) DEFAULT NULL,
`ylzd9` varchar(255) DEFAULT NULL,
`case_id` smallint(10) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `model_id` (`model_id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for wly_case
-- ----------------------------
DROP TABLE IF EXISTS `wly_case`;
CREATE TABLE `wly_case` (
`id` tinyint(10) NOT NULL AUTO_INCREMENT,
`case_name` varchar(255) DEFAULT NULL,
`model_id` tinyint(10) DEFAULT NULL,
`comments` varchar(255) DEFAULT NULL,
`from_test_py` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `model_id` (`model_id`),
CONSTRAINT `model_id` FOREIGN KEY (`model_id`) REFERENCES `wly_web_mode` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for wly_web_mode
-- ----------------------------
DROP TABLE IF EXISTS `wly_web_mode`;
CREATE TABLE `wly_web_mode` (
`id` tinyint(4) NOT NULL,
`wly_web_model` varchar(255) DEFAULT NULL,
KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Comment list( 0 )

You need to Sign in for post a comment

Help Search

Gitee_you_jiang_zheng_wen Zheng_wen_close