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

Issues Search
    My Issues | Starred     Open | Closed | All

Side by Side Diff: masters/state-template.txt

Issue 2084383003: Move 'buildbot.tac' and 'buildbot' files to a common directory. (Closed) Base URL: https://chromium.googlesource.com/chromium/tools/build.git@master
Patch Set: Rebase Created 4 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 | « masters/start_master.sh ('k') | scripts/tools/actions_parser.py » ('j') | no next file with comments »
Toggle Intra-line Diffs ('i') | Expand Comments ('e') | Collapse Comments ('c') | Show Comments Hide Comments ('s')
OLDNEW
(Empty)
1 BEGIN TRANSACTION;
2 CREATE TABLE migrate_version (
3 repository_id VARCHAR(250) NOT NULL,
4 repository_path TEXT,
5 version INTEGER,
6 PRIMARY KEY (repository_id)
7 );
8 INSERT INTO "migrate_version" VALUES('Buildbot','../../third_party/buildbot_8_4p 1/buildbot/db/migrate',8);
9 CREATE TABLE change_links (
10 changeid INTEGER NOT NULL,
11 link VARCHAR(1024) NOT NULL,
12 FOREIGN KEY(changeid) REFERENCES changes (changeid)
13 );
14 CREATE TABLE scheduler_changes (
15 schedulerid INTEGER,
16 changeid INTEGER,
17 important SMALLINT,
18 FOREIGN KEY(schedulerid) REFERENCES schedulers (schedulerid),
19 FOREIGN KEY(changeid) REFERENCES changes (changeid)
20 );
21 CREATE TABLE change_properties (
22 changeid INTEGER NOT NULL,
23 property_name VARCHAR(256) NOT NULL,
24 property_value VARCHAR(1024) NOT NULL,
25 FOREIGN KEY(changeid) REFERENCES changes (changeid)
26 );
27 CREATE TABLE change_files (
28 changeid INTEGER NOT NULL,
29 filename VARCHAR(1024) NOT NULL,
30 FOREIGN KEY(changeid) REFERENCES changes (changeid)
31 );
32 CREATE TABLE sourcestamp_changes (
33 sourcestampid INTEGER NOT NULL,
34 changeid INTEGER NOT NULL,
35 FOREIGN KEY(sourcestampid) REFERENCES sourcestamps (id),
36 FOREIGN KEY(changeid) REFERENCES changes (changeid)
37 );
38 CREATE TABLE buildset_properties (
39 buildsetid INTEGER NOT NULL,
40 property_name VARCHAR(256) NOT NULL,
41 property_value VARCHAR(1024) NOT NULL,
42 FOREIGN KEY(buildsetid) REFERENCES buildsets (id)
43 );
44 CREATE TABLE scheduler_upstream_buildsets (
45 buildsetid INTEGER,
46 schedulerid INTEGER,
47 active SMALLINT,
48 FOREIGN KEY(buildsetid) REFERENCES buildsets (id),
49 FOREIGN KEY(schedulerid) REFERENCES schedulers (schedulerid)
50 );
51 CREATE TABLE schedulers (
52 schedulerid INTEGER NOT NULL,
53 name VARCHAR(128) NOT NULL,
54 state VARCHAR(1024) NOT NULL,
55 class_name VARCHAR(128) NOT NULL,
56 PRIMARY KEY (schedulerid)
57 );
58 CREATE TABLE builds (
59 id INTEGER NOT NULL,
60 number INTEGER NOT NULL,
61 brid INTEGER NOT NULL,
62 start_time INTEGER NOT NULL,
63 finish_time INTEGER,
64 PRIMARY KEY (id),
65 FOREIGN KEY(brid) REFERENCES buildrequests (id)
66 );
67 CREATE TABLE changes (
68 changeid INTEGER NOT NULL,
69 author VARCHAR(256) NOT NULL,
70 comments VARCHAR(1024) NOT NULL,
71 is_dir SMALLINT NOT NULL,
72 branch VARCHAR(256),
73 revision VARCHAR(256),
74 revlink VARCHAR(256),
75 when_timestamp INTEGER NOT NULL,
76 category VARCHAR(256),
77 repository TEXT DEFAULT '' NOT NULL,
78 project TEXT DEFAULT '' NOT NULL,
79 PRIMARY KEY (changeid)
80 );
81 CREATE TABLE buildrequests (
82 id INTEGER NOT NULL,
83 buildsetid INTEGER NOT NULL,
84 buildername VARCHAR NOT NULL,
85 priority INTEGER DEFAULT '0' NOT NULL,
86 claimed_at INTEGER DEFAULT '0',
87 claimed_by_name VARCHAR,
88 claimed_by_incarnation VARCHAR,
89 complete INTEGER DEFAULT '0',
90 results SMALLINT,
91 submitted_at INTEGER NOT NULL,
92 complete_at INTEGER,
93 PRIMARY KEY (id),
94 FOREIGN KEY(buildsetid) REFERENCES buildsets (id)
95 );
96 CREATE TABLE buildsets (
97 id INTEGER NOT NULL,
98 external_idstring VARCHAR(256),
99 reason VARCHAR(256),
100 sourcestampid INTEGER NOT NULL,
101 submitted_at INTEGER NOT NULL,
102 complete SMALLINT DEFAULT '0' NOT NULL,
103 complete_at INTEGER,
104 results SMALLINT,
105 PRIMARY KEY (id),
106 FOREIGN KEY(sourcestampid) REFERENCES sourcestamps (id)
107 );
108 CREATE TABLE patches (
109 id INTEGER NOT NULL,
110 patchlevel INTEGER NOT NULL,
111 patch_base64 TEXT NOT NULL,
112 subdir TEXT,
113 PRIMARY KEY (id)
114 );
115 CREATE TABLE sourcestamps (
116 id INTEGER NOT NULL,
117 branch VARCHAR(256),
118 revision VARCHAR(256),
119 patchid INTEGER,
120 repository TEXT DEFAULT '' NOT NULL,
121 project TEXT DEFAULT '' NOT NULL,
122 PRIMARY KEY (id),
123 FOREIGN KEY(patchid) REFERENCES patches (id)
124 );
125 CREATE TABLE objects (
126 id INTEGER NOT NULL,
127 name VARCHAR(128) NOT NULL,
128 class_name VARCHAR(128) NOT NULL,
129 PRIMARY KEY (id),
130 CONSTRAINT object_identity UNIQUE (name, class_name)
131 );
132 CREATE TABLE object_state (
133 objectid INTEGER NOT NULL,
134 name VARCHAR(256) NOT NULL,
135 value_json TEXT NOT NULL,
136 CONSTRAINT name_per_object UNIQUE (objectid, name),
137 FOREIGN KEY(objectid) REFERENCES objects (id)
138 );
139 CREATE INDEX buildrequests_buildsetid ON buildrequests (buildsetid);
140 CREATE INDEX buildrequests_buildername ON buildrequests (buildername);
141 CREATE INDEX buildrequests_complete ON buildrequests (complete);
142 CREATE INDEX buildrequests_claimed_at ON buildrequests (claimed_at);
143 CREATE INDEX buildrequests_claimed_by_name ON buildrequests (claimed_by_name);
144 CREATE INDEX builds_number ON builds (number);
145 CREATE INDEX builds_brid ON builds (brid);
146 CREATE INDEX buildsets_complete ON buildsets (complete);
147 CREATE INDEX buildsets_submitted_at ON buildsets (submitted_at);
148 CREATE INDEX buildset_properties_buildsetid ON buildset_properties (buildsetid);
149 CREATE INDEX changes_branch ON changes (branch);
150 CREATE INDEX changes_revision ON changes (revision);
151 CREATE INDEX changes_author ON changes (author);
152 CREATE INDEX changes_category ON changes (category);
153 CREATE INDEX changes_when_timestamp ON changes (when_timestamp);
154 CREATE INDEX change_files_changeid ON change_files (changeid);
155 CREATE INDEX change_links_changeid ON change_links (changeid);
156 CREATE INDEX change_properties_changeid ON change_properties (changeid);
157 CREATE INDEX scheduler_changes_schedulerid ON scheduler_changes (schedulerid);
158 CREATE INDEX scheduler_changes_changeid ON scheduler_changes (changeid);
159 CREATE INDEX scheduler_upstream_buildsets_buildsetid ON scheduler_upstream_build sets (buildsetid);
160 CREATE INDEX scheduler_upstream_buildsets_schedulerid ON scheduler_upstream_buil dsets (schedulerid);
161 CREATE INDEX scheduler_upstream_buildsets_active ON scheduler_upstream_buildsets (active);
162 CREATE INDEX sourcestamp_changes_sourcestampid ON sourcestamp_changes (sourcesta mpid);
163 CREATE UNIQUE INDEX scheduler_changes_unique ON scheduler_changes (schedulerid, changeid);
164 COMMIT;
OLDNEW
« no previous file with comments | « masters/start_master.sh ('k') | scripts/tools/actions_parser.py » ('j') | no next file with comments »

Powered by Google App Engine
This is Rietveld 408576698