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

Side by Side 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: Fixed nits and changed output for antibody stats 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 unified diff | Download patch
« no previous file with comments | « no previous file | infra/tools/antibody/__main__.py » ('j') | infra/tools/antibody/compute_stats.py » ('J')
Toggle Intra-line Diffs ('i') | Expand Comments ('e') | Collapse Comments ('c') | Show Comments Hide Comments ('s')
OLDNEW
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;
OLDNEW
« no previous file with comments | « no previous file | infra/tools/antibody/__main__.py » ('j') | infra/tools/antibody/compute_stats.py » ('J')

Powered by Google App Engine
This is Rietveld 408576698