Code/MergeQueues/DBModels

Not logged in - Log In / Register

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;

Code/MergeQueues/DBModels (last edited 2010-09-22 21:46:46 by rockstar)