modules/subscription/subscription.pgsql

CREATE TABLE subscription_channels (
  cid int default '0',
  uid smallint default '0',
  name text default NULL,
  id text default NULL,
  daily int default '0'
);

INSERT INTO subscription_channels (cid, uid, name, id, daily) VALUES(2, 0, 'Instant mailer', 'simple_mail', 0);
INSERT INTO sequences (name, id) VALUES ("subscription_channels",3);

CREATE TABLE subscription_subscriptions (
  sid int primary key NOT NULL default '0',
  uid int NOT NULL default '0',
  condition text NOT NULL,
  cid int default '0',
  object text NOT NULL default ''
);

--grant all on subscription_channels to apache;
--grant all on subscription_subscriptions to apache;

1	CREATE TABLE subscription_channels (
2	cid int default '0',
3	uid smallint default '0',
4	name text default NULL,
5	id text default NULL,
6	daily int default '0'
7	);
8
9	INSERT INTO subscription_channels (cid, uid, name, id, daily) VALUES(2, 0, 'Instant mailer', 'simple_mail', 0);
10	INSERT INTO sequences (name, id) VALUES ("subscription_channels",3);
11
12	CREATE TABLE subscription_subscriptions (
13	sid int primary key NOT NULL default '0',
14	uid int NOT NULL default '0',
15	condition text NOT NULL,
16	cid int default '0',
17	object text NOT NULL default ''
18	);
19
20	--grant all on subscription_channels to apache;
21	--grant all on subscription_subscriptions to apache;
22