Mercurial > libervia-pubsub

comparison db/pubsub.sql @ 248:50f6ee966da8

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
item are gotten according to item's access model in getItems
author Goffi <goffi@goffi.org>
date Sun, 03 Jun 2012 15:57:28 +0200
parents 3ecc94407e36
children f0cd02c032b3
comparison
equal deleted inserted replaced
247:70fae534b83a 248:50f6ee966da8
51 item_id serial PRIMARY KEY, 51 item_id serial PRIMARY KEY,
52 node_id integer NOT NULL REFERENCES nodes ON DELETE CASCADE, 52 node_id integer NOT NULL REFERENCES nodes ON DELETE CASCADE,
53 item text NOT NULL, 53 item text NOT NULL,
54 publisher text NOT NULL, 54 publisher text NOT NULL,
55 data text, 55 data text,
56 access_model text NOT NULL DEFAULT 'default' 56 access_model text NOT NULL DEFAULT 'open'
57 CHECK (access_model IN ('default','open', 'roster')), 57 CHECK (access_model IN ('open', 'roster')),
58 date timestamp with time zone NOT NULL DEFAULT now(), 58 date timestamp with time zone NOT NULL DEFAULT now(),
59 UNIQUE (node_id, item) 59 UNIQUE (node_id, item)
60 ); 60 );
61 61
62 CREATE TABLE item_groups_authorized ( 62 CREATE TABLE item_groups_authorized (