root/trunk/midgard/tools/midrepository/global.sql

CREATE TABLE proc (
        id int(11) NOT NULL auto_increment,
        proc_def_id int(11) NOT NULL default '0',
        src_id int(11) NOT NULL default '0',
        dest_id int(11) NOT NULL default '0',
        step_def_id int(11) NOT NULL default '0',
        collection_id int(11) NOT NULL default '0',
        status smallint NOT NULL default '0',
        comment longtext NOT NULL default '',
        locker char(32) NOT NULL default '',
        KEY (src_id, dest_id),
        KEY (proc_def_id),
        KEY (collection_id),
        KEY (status),
        PRIMARY KEY (id)
);

CREATE TABLE branch (
        id int(11) NOT NULL auto_increment,
        label varchar (255) NOT NULL default '',
        PRIMARY KEY(id)
);


CREATE TABLE substep ( 
        id int(11) NOT NULL auto_increment,
        proc_id int(11) NOT NULL default '0',   
        substep_def_id int(11) NOT NULL default '0',
        PRIMARY KEY (id),
        KEY proc_id(proc_id),
        KEY substep_def_id(substep_def_id)
);


CREATE TABLE collection (
        id int(11) NOT NULL auto_increment,
        up int(11) NOT NULL default '0',
        label varchar(255),
        PRIMARY KEY (id),
        KEY (up)
);

CREATE TABLE collection_pbr (
        id int(11) NOT NULL auto_increment,
        collection_id int(11) NOT NULL default '0',
        pbr_id int(11) NOT NULL default '0',
        PRIMARY KEY(id),
        KEY collection_id(collection_id),
        UNIQUE uniq(collection_id, pbr_id)
);

CREATE TABLE part (
        id int(11) NOT NULL auto_increment,
        guid char(32) NOT NULL default '',
        PRIMARY KEY(id),
        UNIQUE(guid)
);

CREATE TABLE part_branch (
        id int(11) NOT NULL auto_increment,
        part_id int(11) NOT NULL default '0',
        branch_id int(11) NOT NULL default '0',
        status smallint NOT NULL default '0',
        pending_author char(32) NOT NULL default '',
        lock_guid char(32) NOT NULL default '',
        path longtext NOT NULL default '',
        PRIMARY KEY(id),
        UNIQUE(part_id, branch_id),
        KEY(path(100)),
        KEY(status)
);

CREATE TABLE part_branch_revision (     
        id int(11) NOT NULL auto_increment,
        part_branch_id int (11) NOT NULL default '0',
        revision varchar(128) NOT NULL default '',
        path longtext NOT NULL default '',
        author char(32) NOT NULL default '',
        created datetime NOT NULL default '0000-00-00 00:00',
        deleted smallint NOT NULL default '0',
        PRIMARY KEY (id),
        KEY(path(100)),
        UNIQUE guidrev(part_branch_id, revision)
);

CREATE TABLE dep_up (
        id int(11) NOT NULL auto_increment,
        part_branch_revision_id int(11) NOT NULL default '0',
        dep char(32) NOT NULL default '',
        PRIMARY KEY (id),
        UNIQUE dep (part_branch_revision_id, dep)
);

CREATE TABLE dep_down (
        id int(11) NOT NULL auto_increment,
        guid char(32) NOT NULL default '',
        dep char(32) NOT NULL default '',
        lang int(11) NOT NULL default '0',
        PRIMARY KEY (id),
        UNIQUE dep (guid, dep)
);

CREATE TABLE comment (
        id int(11) NOT NULL auto_increment,
        ptable char(64) NOT NULL default '0',
        oid int(11) NOT NULL default '0',
        text longtext NOT NULL default '',
        created datetime NOT NULL default '0000-00-00 00:00',
        PRIMARY KEY (id),
        KEY (ptable, oid)
);

INSERT INTO branch (label) VALUES ('HEAD'), ('LIVE');