Mercurial > libervia-pubsub

comparison db/pubsub.sql @ 182:4aa29b1a8c67

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Add send_last_published_item configuration item to nodes table definition.
author Ralph Meijer <ralphm@ik.nu>
date Fri, 11 Apr 2008 13:48:12 +0000
parents f766e46dce0f
children a5d267289e92
comparison
equal deleted inserted replaced
181:0d4474051eeb 182:4aa29b1a8c67
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'
12 check (send_last_published_item in ('never', 'on_sub')),
11 ); 13 );
12 14
13 create table affiliations ( 15 create table affiliations (
14 id serial primary key, 16 id serial primary key,
15 entity_id integer not null references entities on delete cascade, 17 entity_id integer not null references entities on delete cascade,