Mercurial > libervia-pubsub

comparison db/pubsub.sql @ 188:a5d267289e92

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Fix syntax errors in database schema.
author Ralph Meijer <ralphm@ik.nu>
date Tue, 22 Apr 2008 09:52:50 +0000
parents 4aa29b1a8c67
children 274a45d2a5ab
comparison
equal deleted inserted replaced
187:69cdd8c6a431 188:a5d267289e92
5 5
6 create table nodes ( 6 create table nodes (
7 id serial primary key, 7 id serial primary key,
8 node text not null unique, 8 node text not null unique,
9 persistent boolean not null default true, 9 persistent boolean not null default true,
10 deliver_payload boolean not null default true 10 deliver_payload boolean not null default true,
11 send_last_published_item text not null default 'on_sub' 11 send_last_published_item text not null default 'on_sub'
12 check (send_last_published_item in ('never', 'on_sub')), 12 check (send_last_published_item in ('never', 'on_sub'))
13 ); 13 );
14 14
15 create table affiliations ( 15 create table affiliations (
16 id serial primary key, 16 id serial primary key,
17 entity_id integer not null references entities on delete cascade, 17 entity_id integer not null references entities on delete cascade,