Mercurial > libervia-pubsub
comparison db/pubsub.sql @ 182:4aa29b1a8c67
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, |