upgrades/dbpatches/1.4/mysql/patch/slides.sql


1
2
3
4
5
6
7
8
9
10

CREATE TABLE slides (
        slideid         bigint unsigned         DEFAULT '0'     NOT NULL,
        slideshowid             bigint unsigned         DEFAULT '0'     NOT NULL,
        screenid             bigint unsigned         DEFAULT '0'     NOT NULL,
        step            integer         DEFAULT '0'     NOT NULL,
        delay           integer         DEFAULT '0'     NOT NULL,
        PRIMARY KEY (slideid)
)  ENGINE=InnoDB;
CREATE INDEX slides_slides_1 on slides (slideshowid);