Move 'buildbot.tac' and 'buildbot' files to a common directory.

masters/state-template.txt

Index: masters/state-template.txt
diff --git a/masters/state-template.txt b/masters/state-template.txt
deleted file mode 100755
index a734569aa3d26f20b9403d1000ca6acf5a19ac56..0000000000000000000000000000000000000000
--- a/masters/state-template.txt
+++ /dev/null
@@ -1,164 +0,0 @@
-BEGIN TRANSACTION;
-CREATE TABLE migrate_version (
-	repository_id VARCHAR(250) NOT NULL, 
-	repository_path TEXT, 
-	version INTEGER, 
-	PRIMARY KEY (repository_id)
-);
-INSERT INTO "migrate_version" VALUES('Buildbot','../../third_party/buildbot_8_4p1/buildbot/db/migrate',8);
-CREATE TABLE change_links (
-	changeid INTEGER NOT NULL, 
-	link VARCHAR(1024) NOT NULL, 
-	FOREIGN KEY(changeid) REFERENCES changes (changeid)
-);
-CREATE TABLE scheduler_changes (
-	schedulerid INTEGER, 
-	changeid INTEGER, 
-	important SMALLINT, 
-	FOREIGN KEY(schedulerid) REFERENCES schedulers (schedulerid), 
-	FOREIGN KEY(changeid) REFERENCES changes (changeid)
-);
-CREATE TABLE change_properties (
-	changeid INTEGER NOT NULL, 
-	property_name VARCHAR(256) NOT NULL, 
-	property_value VARCHAR(1024) NOT NULL, 
-	FOREIGN KEY(changeid) REFERENCES changes (changeid)
-);
-CREATE TABLE change_files (
-	changeid INTEGER NOT NULL, 
-	filename VARCHAR(1024) NOT NULL, 
-	FOREIGN KEY(changeid) REFERENCES changes (changeid)
-);
-CREATE TABLE sourcestamp_changes (
-	sourcestampid INTEGER NOT NULL, 
-	changeid INTEGER NOT NULL, 
-	FOREIGN KEY(sourcestampid) REFERENCES sourcestamps (id), 
-	FOREIGN KEY(changeid) REFERENCES changes (changeid)
-);
-CREATE TABLE buildset_properties (
-	buildsetid INTEGER NOT NULL, 
-	property_name VARCHAR(256) NOT NULL, 
-	property_value VARCHAR(1024) NOT NULL, 
-	FOREIGN KEY(buildsetid) REFERENCES buildsets (id)
-);
-CREATE TABLE scheduler_upstream_buildsets (
-	buildsetid INTEGER, 
-	schedulerid INTEGER, 
-	active SMALLINT, 
-	FOREIGN KEY(buildsetid) REFERENCES buildsets (id), 
-	FOREIGN KEY(schedulerid) REFERENCES schedulers (schedulerid)
-);
-CREATE TABLE schedulers (
-	schedulerid INTEGER NOT NULL, 
-	name VARCHAR(128) NOT NULL, 
-	state VARCHAR(1024) NOT NULL, 
-	class_name VARCHAR(128) NOT NULL, 
-	PRIMARY KEY (schedulerid)
-);
-CREATE TABLE builds (
-	id INTEGER NOT NULL, 
-	number INTEGER NOT NULL, 
-	brid INTEGER NOT NULL, 
-	start_time INTEGER NOT NULL, 
-	finish_time INTEGER, 
-	PRIMARY KEY (id), 
-	FOREIGN KEY(brid) REFERENCES buildrequests (id)
-);
-CREATE TABLE changes (
-	changeid INTEGER NOT NULL, 
-	author VARCHAR(256) NOT NULL, 
-	comments VARCHAR(1024) NOT NULL, 
-	is_dir SMALLINT NOT NULL, 
-	branch VARCHAR(256), 
-	revision VARCHAR(256), 
-	revlink VARCHAR(256), 
-	when_timestamp INTEGER NOT NULL, 
-	category VARCHAR(256), 
-	repository TEXT DEFAULT '' NOT NULL, 
-	project TEXT DEFAULT '' NOT NULL, 
-	PRIMARY KEY (changeid)
-);
-CREATE TABLE buildrequests (
-	id INTEGER NOT NULL, 
-	buildsetid INTEGER NOT NULL, 
-	buildername VARCHAR NOT NULL, 
-	priority INTEGER DEFAULT '0' NOT NULL, 
-	claimed_at INTEGER DEFAULT '0', 
-	claimed_by_name VARCHAR, 
-	claimed_by_incarnation VARCHAR, 
-	complete INTEGER DEFAULT '0', 
-	results SMALLINT, 
-	submitted_at INTEGER NOT NULL, 
-	complete_at INTEGER, 
-	PRIMARY KEY (id), 
-	FOREIGN KEY(buildsetid) REFERENCES buildsets (id)
-);
-CREATE TABLE buildsets (
-	id INTEGER NOT NULL, 
-	external_idstring VARCHAR(256), 
-	reason VARCHAR(256), 
-	sourcestampid INTEGER NOT NULL, 
-	submitted_at INTEGER NOT NULL, 
-	complete SMALLINT DEFAULT '0' NOT NULL, 
-	complete_at INTEGER, 
-	results SMALLINT, 
-	PRIMARY KEY (id), 
-	FOREIGN KEY(sourcestampid) REFERENCES sourcestamps (id)
-);
-CREATE TABLE patches (
-	id INTEGER NOT NULL, 
-	patchlevel INTEGER NOT NULL, 
-	patch_base64 TEXT NOT NULL, 
-	subdir TEXT, 
-	PRIMARY KEY (id)
-);
-CREATE TABLE sourcestamps (
-	id INTEGER NOT NULL, 
-	branch VARCHAR(256), 
-	revision VARCHAR(256), 
-	patchid INTEGER, 
-	repository TEXT DEFAULT '' NOT NULL, 
-	project TEXT DEFAULT '' NOT NULL, 
-	PRIMARY KEY (id), 
-	FOREIGN KEY(patchid) REFERENCES patches (id)
-);
-CREATE TABLE objects (
-	id INTEGER NOT NULL, 
-	name VARCHAR(128) NOT NULL, 
-	class_name VARCHAR(128) NOT NULL, 
-	PRIMARY KEY (id), 
-	CONSTRAINT object_identity UNIQUE (name, class_name)
-);
-CREATE TABLE object_state (
-	objectid INTEGER NOT NULL, 
-	name VARCHAR(256) NOT NULL, 
-	value_json TEXT NOT NULL, 
-	CONSTRAINT name_per_object UNIQUE (objectid, name), 
-	FOREIGN KEY(objectid) REFERENCES objects (id)
-);
-CREATE INDEX buildrequests_buildsetid ON buildrequests (buildsetid);
-CREATE INDEX buildrequests_buildername ON buildrequests (buildername);
-CREATE INDEX buildrequests_complete ON buildrequests (complete);
-CREATE INDEX buildrequests_claimed_at ON buildrequests (claimed_at);
-CREATE INDEX buildrequests_claimed_by_name ON buildrequests (claimed_by_name);
-CREATE INDEX builds_number ON builds (number);
-CREATE INDEX builds_brid ON builds (brid);
-CREATE INDEX buildsets_complete ON buildsets (complete);
-CREATE INDEX buildsets_submitted_at ON buildsets (submitted_at);
-CREATE INDEX buildset_properties_buildsetid ON buildset_properties (buildsetid);
-CREATE INDEX changes_branch ON changes (branch);
-CREATE INDEX changes_revision ON changes (revision);
-CREATE INDEX changes_author ON changes (author);
-CREATE INDEX changes_category ON changes (category);
-CREATE INDEX changes_when_timestamp ON changes (when_timestamp);
-CREATE INDEX change_files_changeid ON change_files (changeid);
-CREATE INDEX change_links_changeid ON change_links (changeid);
-CREATE INDEX change_properties_changeid ON change_properties (changeid);
-CREATE INDEX scheduler_changes_schedulerid ON scheduler_changes (schedulerid);
-CREATE INDEX scheduler_changes_changeid ON scheduler_changes (changeid);
-CREATE INDEX scheduler_upstream_buildsets_buildsetid ON scheduler_upstream_buildsets (buildsetid);
-CREATE INDEX scheduler_upstream_buildsets_schedulerid ON scheduler_upstream_buildsets (schedulerid);
-CREATE INDEX scheduler_upstream_buildsets_active ON scheduler_upstream_buildsets (active);
-CREATE INDEX sourcestamp_changes_sourcestampid ON sourcestamp_changes (sourcestampid);
-CREATE UNIQUE INDEX scheduler_changes_unique ON scheduler_changes (schedulerid, changeid);
-COMMIT;