| 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 PRIMARY KEY (`hash`) COMMENT ''); | 62 PRIMARY KEY (`hash`) COMMENT ''); |
| 63 | 63 |
| 64 | 64 |
| 65 -- ----------------------------------------------------- | 65 -- ----------------------------------------------------- |
| 66 -- Table `ANTIBODY_DB`.`commit_people` | 66 -- Table `ANTIBODY_2`.`commit_people` |
| 67 -- ----------------------------------------------------- | 67 -- ----------------------------------------------------- |
| 68 CREATE TABLE IF NOT EXISTS `ANTIBODY_DB`.`commit_people` ( | 68 CREATE TABLE IF NOT EXISTS `ANTIBODY_2`.`commit_people` ( |
| 69 `people_email_address` VARCHAR(200) NOT NULL COMMENT '', | 69 `people_email_address` VARCHAR(200) NOT NULL COMMENT '', |
| 70 `git_commit_hash` VARCHAR(40) NOT NULL COMMENT '', | 70 `git_commit_hash` VARCHAR(40) NOT NULL COMMENT '', |
| 71 `request_timestamp` TIMESTAMP NULL COMMENT '', | 71 `request_timestamp` TIMESTAMP NULL COMMENT '', |
| 72 `type` VARCHAR(10) NOT NULL COMMENT '', | 72 `type` VARCHAR(10) NOT NULL COMMENT '', |
| 73 PRIMARY KEY (`people_email_address`, `git_commit_hash`, `type`) COMMENT '') | 73 PRIMARY KEY (`people_email_address`, `git_commit_hash`, `type`) COMMENT '') |
| 74 ENGINE = InnoDB; | 74 ENGINE = InnoDB; |
| 75 | 75 |
| 76 | 76 |
| 77 -- ----------------------------------------------------- | 77 -- ----------------------------------------------------- |
| 78 -- Table `ANTIBODY_DB`.`review_people` | 78 -- Table `ANTIBODY_2`.`review_people` |
| 79 -- ----------------------------------------------------- | 79 -- ----------------------------------------------------- |
| 80 CREATE TABLE IF NOT EXISTS `ANTIBODY_DB`.`review_people` ( | 80 CREATE TABLE IF NOT EXISTS `ANTIBODY_2`.`review_people` ( |
| 81 `people_email_address` VARCHAR(200) NOT NULL COMMENT '', | 81 `people_email_address` VARCHAR(200) NOT NULL COMMENT '', |
| 82 `review_url` VARCHAR(200) NOT NULL COMMENT '', | 82 `review_url` VARCHAR(200) NOT NULL COMMENT '', |
| 83 `timestamp` TIMESTAMP NULL COMMENT '', | 83 `timestamp` TIMESTAMP NULL COMMENT '', |
| 84 `request_timestamp` TIMESTAMP NULL COMMENT '', | 84 `request_timestamp` TIMESTAMP NULL COMMENT '', |
| 85 `type` VARCHAR(10) NOT NULL COMMENT '', | 85 `type` VARCHAR(10) NOT NULL COMMENT '', |
| 86 PRIMARY KEY (`people_email_address`, `review_url`, `type`) COMMENT '') | 86 PRIMARY KEY (`people_email_address`, `review_url`, `type`) COMMENT '') |
| 87 ENGINE = InnoDB; | 87 ENGINE = InnoDB; |
| 88 | 88 |
| 89 | 89 |
| 90 SET SQL_MODE=@OLD_SQL_MODE; | 90 SET SQL_MODE=@OLD_SQL_MODE; |
| 91 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS; | 91 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS; |
| 92 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS; | 92 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS; |
| OLD | NEW |