| 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..f0e70790a9870d05f7654a5a374cbce9c64a072c 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,18 +42,18 @@ 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 '',
|
| @@ -63,9 +63,9 @@ CREATE TABLE IF NOT EXISTS `ANTIBODY_DB`.`git_commit` (
|
|
|
|
|
| -- -----------------------------------------------------
|
| --- 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 +75,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 '',
|
|
|