X-Git-Url: http://git.onelab.eu/?a=blobdiff_plain;f=planetlab5.sql;h=95eb02b37d666342040a7504ff0a1fa70e8b19a7;hb=19d4a01ccf66af9e00914351b3eacd5fc880f988;hp=6ac84c57cffa97cec27795c2838464b331574629;hpb=8b0a5128b2582b1cf41b123680e8d4ec270ac9a3;p=plcapi.git diff --git a/planetlab5.sql b/planetlab5.sql index 6ac84c5..95eb02b 100644 --- a/planetlab5.sql +++ b/planetlab5.sql @@ -69,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; @@ -838,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);