X-Git-Url: http://git.onelab.eu/?a=blobdiff_plain;f=planetlab5.sql;h=4083039a1968b32a76ef5db502f4060b2bd57af6;hb=f9bdeed07525fd5b861084165dd8fd451be17c5c;hp=25b3edd358ab000d901aff16a70b106dedbb10cc;hpb=5d8a25ab329d0c44d34645b0ddeacba2f02331eb;p=plcapi.git diff --git a/planetlab5.sql b/planetlab5.sql index 25b3edd..4083039 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;