Chromium Code Reviews
chromiumcodereview-hr@appspot.gserviceaccount.com (chromiumcodereview-hr) | Please choose your nickname with Settings | Help | Chromium Project | Gerrit Changes | Sign out
(588)

Unified Diff: infra/tools/antibody/ANTIBODY_DB_schema_setup.sql

Issue 1235373004: Added script to generate stats on a git checkout (Closed) Base URL: https://chromium.googlesource.com/infra/infra.git@new_antibody_db_schema
Patch Set: Rebase Created 5 years, 5 months ago
Use n/p to move between diff chunks; N/P to move between comments. Draft comments are only viewable by you.
Jump to:
View side-by-side diff with in-line comments
Download patch
« no previous file with comments | « no previous file | infra/tools/antibody/__main__.py » ('j') | no next file with comments »
Expand Comments ('e') | Collapse Comments ('c') | Show Comments Hide Comments ('s')
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 '',
« no previous file with comments | « no previous file | infra/tools/antibody/__main__.py » ('j') | no next file with comments »

Powered by Google App Engine
This is Rietveld 408576698