22 lines
483 B
SQL
22 lines
483 B
SQL
-- P5-5056: add startpage slideshow
|
|
|
|
CREATE TABLE slideshow_slides
|
|
(
|
|
id SERIAL PRIMARY KEY,
|
|
market_id INTEGER,
|
|
inserted TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT now(),
|
|
visible INTEGER NOT NULL DEFAULT 0,
|
|
position INTEGER,
|
|
comment TEXT,
|
|
target_url TEXT,
|
|
desktop_image TEXT,
|
|
mobile_image TEXT,
|
|
tablet_image TEXT
|
|
);
|
|
|
|
|
|
ALTER TABLE slideshow_slides
|
|
ADD CONSTRAINT market_id
|
|
FOREIGN KEY (market_id)
|
|
REFERENCES markets(id) MATCH SIMPLE;
|