summaryrefslogtreecommitdiffstats
path: root/upgrades/dbpatches/1.4/postgresql/patch/slides.sql
blob: 4d5fdd3a3703885b71e6fda1db6083a7a9185dca (plain)
1
2
3
4
5
6
7
8
9
CREATE TABLE slides (
        slideid         bigint	DEFAULT '0'     NOT NULL,
        slideshowid     bigint 	DEFAULT '0'     NOT NULL,
        step            integer         DEFAULT '0'     NOT NULL,
        delay           integer         DEFAULT '0'     NOT NULL,
        PRIMARY KEY (slideid)
);
CREATE INDEX slides_slides_1 on slides (slideshowid);