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