[hcoop/portal.git] / create-active-node-table.sql

BEGIN;

CREATE TABLE ActiveWebNode
(
	id integer primary key,
	foreign key (id) references WebNode
);

INSERT INTO ActiveWebNode (id) VALUES (3);
INSERT INTO ActiveWebNode (id) VALUES (4);

COMMIT;
Commit	Line	Data
ee252433 CE	1	BEGIN;
	2
	3	CREATE TABLE ActiveWebNode
	4	(
	5	id integer primary key,
	6	foreign key (id) references WebNode
	7	);
	8
	9	INSERT INTO ActiveWebNode (id) VALUES (3);
	10	INSERT INTO ActiveWebNode (id) VALUES (4);
	11
	12	COMMIT;