Index: infra/tools/antibody/ANTIBODY_DB_schema_setup.sql |
diff --git a/infra/tools/antibody/ANTIBODY_DB_schema_setup.sql b/infra/tools/antibody/ANTIBODY_DB_schema_setup.sql |
index b2294561d485812c80bb7fc8a6203f064adbc42b..42fdd0d6e7dc2506e229e92cb3a35b00a69204fb 100644 |
--- a/infra/tools/antibody/ANTIBODY_DB_schema_setup.sql |
+++ b/infra/tools/antibody/ANTIBODY_DB_schema_setup.sql |
@@ -8,19 +8,19 @@ SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0; |
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES'; |
-- ----------------------------------------------------- |
--- Schema ANTIBODY_DB |
+-- Schema ANTIBODY_2 |
-- ----------------------------------------------------- |
-- ----------------------------------------------------- |
--- Schema ANTIBODY_DB |
+-- Schema ANTIBODY_2 |
-- ----------------------------------------------------- |
-CREATE SCHEMA IF NOT EXISTS `ANTIBODY_DB` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ; |
-USE `ANTIBODY_DB` ; |
+CREATE SCHEMA IF NOT EXISTS `ANTIBODY_2` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ; |
+USE `ANTIBODY_2` ; |
-- ----------------------------------------------------- |
--- Table `ANTIBODY_DB`.`project` |
+-- Table `ANTIBODY_2`.`project` |
-- ----------------------------------------------------- |
-CREATE TABLE IF NOT EXISTS `ANTIBODY_DB`.`project` ( |
+CREATE TABLE IF NOT EXISTS `ANTIBODY_2`.`project` ( |
`prj_id` INT NOT NULL COMMENT '', |
`prj_name` VARCHAR(45) NULL COMMENT '', |
`prj_repository` VARCHAR(250) NOT NULL COMMENT '', |
@@ -29,9 +29,9 @@ ENGINE = InnoDB; |
-- ----------------------------------------------------- |
--- Table `ANTIBODY_DB`.`review` |
+-- Table `ANTIBODY_2`.`review` |
-- ----------------------------------------------------- |
-CREATE TABLE IF NOT EXISTS `ANTIBODY_DB`.`review` ( |
+CREATE TABLE IF NOT EXISTS `ANTIBODY_2`.`review` ( |
`review_url` VARCHAR(200) NOT NULL COMMENT '', |
`request_timestamp` TIMESTAMP NULL COMMENT '', |
`patchset_commited` TIMESTAMP NULL COMMENT '', |
@@ -42,30 +42,31 @@ CREATE TABLE IF NOT EXISTS `ANTIBODY_DB`.`review` ( |
-- ----------------------------------------------------- |
--- Table `ANTIBODY_DB`.`people` |
+-- Table `ANTIBODY_2`.`people` |
-- ----------------------------------------------------- |
-CREATE TABLE IF NOT EXISTS `ANTIBODY_DB`.`people` ( |
+CREATE TABLE IF NOT EXISTS `ANTIBODY_2`.`people` ( |
`email_address` VARCHAR(200) NOT NULL COMMENT '', |
`commiter_since` TIMESTAMP NULL COMMENT '', |
PRIMARY KEY (`email_address`) COMMENT ''); |
-- ----------------------------------------------------- |
--- Table `ANTIBODY_DB`.`git_commit` |
+-- Table `ANTIBODY_2`.`git_commit` |
-- ----------------------------------------------------- |
-CREATE TABLE IF NOT EXISTS `ANTIBODY_DB`.`git_commit` ( |
+CREATE TABLE IF NOT EXISTS `ANTIBODY_2`.`git_commit` ( |
`hash` VARCHAR(40) NOT NULL COMMENT '', |
`bug_url` VARCHAR(200) NULL COMMENT '', |
`timestamp` TIMESTAMP NULL COMMENT '', |
`review_url` VARCHAR(200) NULL COMMENT '', |
`project_prj_id` INT NULL COMMENT '', |
+ `subject` VARCHAR(500) NULL COMMENT '', |
PRIMARY KEY (`hash`) COMMENT ''); |
-- ----------------------------------------------------- |
--- Table `ANTIBODY_DB`.`commit_people` |
+-- Table `ANTIBODY_2`.`commit_people` |
-- ----------------------------------------------------- |
-CREATE TABLE IF NOT EXISTS `ANTIBODY_DB`.`commit_people` ( |
+CREATE TABLE IF NOT EXISTS `ANTIBODY_2`.`commit_people` ( |
`people_email_address` VARCHAR(200) NOT NULL COMMENT '', |
`git_commit_hash` VARCHAR(40) NOT NULL COMMENT '', |
`request_timestamp` TIMESTAMP NULL COMMENT '', |
@@ -75,9 +76,9 @@ ENGINE = InnoDB; |
-- ----------------------------------------------------- |
--- Table `ANTIBODY_DB`.`review_people` |
+-- Table `ANTIBODY_2`.`review_people` |
-- ----------------------------------------------------- |
-CREATE TABLE IF NOT EXISTS `ANTIBODY_DB`.`review_people` ( |
+CREATE TABLE IF NOT EXISTS `ANTIBODY_2`.`review_people` ( |
`people_email_address` VARCHAR(200) NOT NULL COMMENT '', |
`review_url` VARCHAR(200) NOT NULL COMMENT '', |
`timestamp` TIMESTAMP NULL COMMENT '', |