X-Git-Url: http://git.onelab.eu/?a=blobdiff_plain;f=planetlab5.sql;h=95eb02b37d666342040a7504ff0a1fa70e8b19a7;hb=19d4a01ccf66af9e00914351b3eacd5fc880f988;hp=25b3edd358ab000d901aff16a70b106dedbb10cc;hpb=5d8a25ab329d0c44d34645b0ddeacba2f02331eb;p=plcapi.git diff --git a/planetlab5.sql b/planetlab5.sql index 25b3edd..95eb02b 100644 --- a/planetlab5.sql +++ b/planetlab5.sql @@ -12,9 +12,6 @@ -- -- NOTE: this file was first created for version 4.3, the filename might be confusing -- --- $Id$ --- $URL$ --- SET client_encoding = 'UNICODE'; @@ -72,6 +69,8 @@ CREATE TABLE tag_types ( tag_type_id serial PRIMARY KEY, -- ID tagname text UNIQUE NOT NULL, -- Tag Name description text, -- Optional Description +-- this is deprecated -- see migrations/104* +-- starting with subversion 104, a tag type has a SET OF roles attached to it min_role_id integer REFERENCES roles DEFAULT 10, -- set minimal role required category text NOT NULL DEFAULT 'general' -- Free text for grouping tags together ) WITH OIDS; @@ -841,7 +840,7 @@ CREATE TABLE initscripts ( initscript_id serial PRIMARY KEY, -- Initscript identifier name text NOT NULL, -- Initscript name enabled bool NOT NULL DEFAULT true, -- Initscript is active - script text NOT NULL, -- Initscript body + script text NOT NULL, -- Initscript code UNIQUE (name) ) WITH OIDS; CREATE INDEX initscripts_name_idx ON initscripts (name);