865
Comment:
|
← Revision 7 as of 2010-09-22 21:46:46 ⇥
861
|
Deletions are marked like this. | Additions are marked like this. |
Line 25: | Line 25: |
id serial NOT NULL PRIMARY KEY, | |
Line 29: | Line 28: |
PRIMARY KEY (queue, branch) |
Merge Queues Database Model
ALTER TABLE Branch DROP COLUMN merge_robot; ALTER TABLE Branch DROP COLUMN merge_control_status; DROP TABLE BranchMergeRobot; CREATE TABLE BranchMergeQueue ( id serial NOT NULL PRIMARY KEY, registrant integer NOT NULL REFERENCES Person, owner integer NOT NULL REFERENCES Person, name TEXT NOT NULL, description TEXT, configuration TEXT, date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL, CONSTRAINT owner_name UNIQUE (owner, name) ); CREATE TABLE BranchQueue ( branch integer NOT NULL REFERENCES Branch, queue integer NOT NULL REFERENCES BranchMergeQueue, CONSTRAINT branch_unique UNIQUE (branch) PRIMARY KEY (queue, branch) ); ALTER TABLE Branch ADD COLUMN merge_queue_config TEXT;