summaryrefslogtreecommitdiffstats
path: root/upgrades/dbpatches/1.4/postgresql/patch/httpstepitem.sql
blob: 7dea595a893c76ab1b9e290dcaa042e7f3eeaad3 (plain)
1
2
3
4
5
6
7
8
CREATE TABLE httpstepitem (
	httpstepitemid	bigint DEFAULT '0'	NOT NULL,
	httpstepid	bigint DEFAULT '0'	NOT NULL,
	itemid		bigint DEFAULT '0'	NOT NULL,
	type		integer		DEFAULT '0'	NOT NULL,
	PRIMARY KEY (httpstepitemid)
) with OIDS;
CREATE UNIQUE INDEX httpstepitem_httpstepitem_1 on httpstepitem (httpstepid,itemid);