OLD | NEW |
1 -- MySQL Script generated by MySQL Workbench | 1 -- MySQL Script generated by MySQL Workbench |
2 -- Fri 10 Jul 2015 09:49:23 AM PDT | 2 -- Fri 10 Jul 2015 09:49:23 AM PDT |
3 -- Model: New Model Version: 1.0 | 3 -- Model: New Model Version: 1.0 |
4 -- MySQL Workbench Forward Engineering | 4 -- MySQL Workbench Forward Engineering |
5 | 5 |
6 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0; | 6 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0; |
7 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0; | 7 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0; |
8 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES'; | 8 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES'; |
9 | 9 |
10 -- ----------------------------------------------------- | 10 -- ----------------------------------------------------- |
11 -- Schema ANTIBODY_DB | 11 -- Schema ANTIBODY_2 |
12 -- ----------------------------------------------------- | 12 -- ----------------------------------------------------- |
13 | 13 |
14 -- ----------------------------------------------------- | 14 -- ----------------------------------------------------- |
15 -- Schema ANTIBODY_DB | 15 -- Schema ANTIBODY_2 |
16 -- ----------------------------------------------------- | 16 -- ----------------------------------------------------- |
17 CREATE SCHEMA IF NOT EXISTS `ANTIBODY_DB` DEFAULT CHARACTER SET utf8 COLLATE utf
8_general_ci ; | 17 CREATE SCHEMA IF NOT EXISTS `ANTIBODY_2` DEFAULT CHARACTER SET utf8 COLLATE utf8
_general_ci ; |
18 USE `ANTIBODY_DB` ; | 18 USE `ANTIBODY_2` ; |
19 | 19 |
20 -- ----------------------------------------------------- | 20 -- ----------------------------------------------------- |
21 -- Table `ANTIBODY_DB`.`project` | 21 -- Table `ANTIBODY_2`.`project` |
22 -- ----------------------------------------------------- | 22 -- ----------------------------------------------------- |
23 CREATE TABLE IF NOT EXISTS `ANTIBODY_DB`.`project` ( | 23 CREATE TABLE IF NOT EXISTS `ANTIBODY_2`.`project` ( |
24 `prj_id` INT NOT NULL COMMENT '', | 24 `prj_id` INT NOT NULL COMMENT '', |
25 `prj_name` VARCHAR(45) NULL COMMENT '', | 25 `prj_name` VARCHAR(45) NULL COMMENT '', |
26 `prj_repository` VARCHAR(250) NOT NULL COMMENT '', | 26 `prj_repository` VARCHAR(250) NOT NULL COMMENT '', |
27 PRIMARY KEY (`prj_id`) COMMENT '') | 27 PRIMARY KEY (`prj_id`) COMMENT '') |
28 ENGINE = InnoDB; | 28 ENGINE = InnoDB; |
29 | 29 |
30 | 30 |
31 -- ----------------------------------------------------- | 31 -- ----------------------------------------------------- |
32 -- Table `ANTIBODY_DB`.`review` | 32 -- Table `ANTIBODY_2`.`review` |
33 -- ----------------------------------------------------- | 33 -- ----------------------------------------------------- |
34 CREATE TABLE IF NOT EXISTS `ANTIBODY_DB`.`review` ( | 34 CREATE TABLE IF NOT EXISTS `ANTIBODY_2`.`review` ( |
35 `review_url` VARCHAR(200) NOT NULL COMMENT '', | 35 `review_url` VARCHAR(200) NOT NULL COMMENT '', |
36 `request_timestamp` TIMESTAMP NULL COMMENT '', | 36 `request_timestamp` TIMESTAMP NULL COMMENT '', |
37 `patchset_commited` TIMESTAMP NULL COMMENT '', | 37 `patchset_commited` TIMESTAMP NULL COMMENT '', |
38 `patchset_still_exists` TINYINT NULL COMMENT '', | 38 `patchset_still_exists` TINYINT NULL COMMENT '', |
39 `reverted` TINYINT NULL COMMENT '', | 39 `reverted` TINYINT NULL COMMENT '', |
40 `project_prj_id` INT NULL COMMENT '', | 40 `project_prj_id` INT NULL COMMENT '', |
41 PRIMARY KEY (`review_url`) COMMENT ''); | 41 PRIMARY KEY (`review_url`) COMMENT ''); |
42 | 42 |
43 | 43 |
44 -- ----------------------------------------------------- | 44 -- ----------------------------------------------------- |
45 -- Table `ANTIBODY_DB`.`people` | 45 -- Table `ANTIBODY_2`.`people` |
46 -- ----------------------------------------------------- | 46 -- ----------------------------------------------------- |
47 CREATE TABLE IF NOT EXISTS `ANTIBODY_DB`.`people` ( | 47 CREATE TABLE IF NOT EXISTS `ANTIBODY_2`.`people` ( |
48 `email_address` VARCHAR(200) NOT NULL COMMENT '', | 48 `email_address` VARCHAR(200) NOT NULL COMMENT '', |
49 `commiter_since` TIMESTAMP NULL COMMENT '', | 49 `commiter_since` TIMESTAMP NULL COMMENT '', |
50 PRIMARY KEY (`email_address`) COMMENT ''); | 50 PRIMARY KEY (`email_address`) COMMENT ''); |
51 | 51 |
52 | 52 |
53 -- ----------------------------------------------------- | 53 -- ----------------------------------------------------- |
54 -- Table `ANTIBODY_DB`.`git_commit` | 54 -- Table `ANTIBODY_2`.`git_commit` |
55 -- ----------------------------------------------------- | 55 -- ----------------------------------------------------- |
56 CREATE TABLE IF NOT EXISTS `ANTIBODY_DB`.`git_commit` ( | 56 CREATE TABLE IF NOT EXISTS `ANTIBODY_2`.`git_commit` ( |
57 `hash` VARCHAR(40) NOT NULL COMMENT '', | 57 `hash` VARCHAR(40) NOT NULL COMMENT '', |
58 `bug_url` VARCHAR(200) NULL COMMENT '', | 58 `bug_url` VARCHAR(200) NULL COMMENT '', |
59 `timestamp` TIMESTAMP NULL COMMENT '', | 59 `timestamp` TIMESTAMP NULL COMMENT '', |
60 `review_url` VARCHAR(200) NULL COMMENT '', | 60 `review_url` VARCHAR(200) NULL COMMENT '', |
61 `project_prj_id` INT NULL COMMENT '', | 61 `project_prj_id` INT NULL COMMENT '', |
| 62 `subject` VARCHAR(500) NULL COMMENT '', |
62 PRIMARY KEY (`hash`) COMMENT ''); | 63 PRIMARY KEY (`hash`) COMMENT ''); |
63 | 64 |
64 | 65 |
65 -- ----------------------------------------------------- | 66 -- ----------------------------------------------------- |
66 -- Table `ANTIBODY_DB`.`commit_people` | 67 -- Table `ANTIBODY_2`.`commit_people` |
67 -- ----------------------------------------------------- | 68 -- ----------------------------------------------------- |
68 CREATE TABLE IF NOT EXISTS `ANTIBODY_DB`.`commit_people` ( | 69 CREATE TABLE IF NOT EXISTS `ANTIBODY_2`.`commit_people` ( |
69 `people_email_address` VARCHAR(200) NOT NULL COMMENT '', | 70 `people_email_address` VARCHAR(200) NOT NULL COMMENT '', |
70 `git_commit_hash` VARCHAR(40) NOT NULL COMMENT '', | 71 `git_commit_hash` VARCHAR(40) NOT NULL COMMENT '', |
71 `request_timestamp` TIMESTAMP NULL COMMENT '', | 72 `request_timestamp` TIMESTAMP NULL COMMENT '', |
72 `type` VARCHAR(10) NOT NULL COMMENT '', | 73 `type` VARCHAR(10) NOT NULL COMMENT '', |
73 PRIMARY KEY (`people_email_address`, `git_commit_hash`, `type`) COMMENT '') | 74 PRIMARY KEY (`people_email_address`, `git_commit_hash`, `type`) COMMENT '') |
74 ENGINE = InnoDB; | 75 ENGINE = InnoDB; |
75 | 76 |
76 | 77 |
77 -- ----------------------------------------------------- | 78 -- ----------------------------------------------------- |
78 -- Table `ANTIBODY_DB`.`review_people` | 79 -- Table `ANTIBODY_2`.`review_people` |
79 -- ----------------------------------------------------- | 80 -- ----------------------------------------------------- |
80 CREATE TABLE IF NOT EXISTS `ANTIBODY_DB`.`review_people` ( | 81 CREATE TABLE IF NOT EXISTS `ANTIBODY_2`.`review_people` ( |
81 `people_email_address` VARCHAR(200) NOT NULL COMMENT '', | 82 `people_email_address` VARCHAR(200) NOT NULL COMMENT '', |
82 `review_url` VARCHAR(200) NOT NULL COMMENT '', | 83 `review_url` VARCHAR(200) NOT NULL COMMENT '', |
83 `timestamp` TIMESTAMP NULL COMMENT '', | 84 `timestamp` TIMESTAMP NULL COMMENT '', |
84 `request_timestamp` TIMESTAMP NULL COMMENT '', | 85 `request_timestamp` TIMESTAMP NULL COMMENT '', |
85 `type` VARCHAR(10) NOT NULL COMMENT '', | 86 `type` VARCHAR(10) NOT NULL COMMENT '', |
86 PRIMARY KEY (`people_email_address`, `review_url`, `type`) COMMENT '') | 87 PRIMARY KEY (`people_email_address`, `review_url`, `type`) COMMENT '') |
87 ENGINE = InnoDB; | 88 ENGINE = InnoDB; |
88 | 89 |
89 | 90 |
90 SET SQL_MODE=@OLD_SQL_MODE; | 91 SET SQL_MODE=@OLD_SQL_MODE; |
91 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS; | 92 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS; |
92 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS; | 93 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS; |
OLD | NEW |