blob: bad41001ceb522b6565d296cb73f6a05182e5dae (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
CREATE TABLE IF NOT EXISTS galleries (
id SERIAL,
vanity char(12) NOT NULL,
title varchar(128),
description varchar(4096) NOT NULL,
datetime timestamp with time zone NOT NULL,
PRIMARY KEY (id)
);
CREATE TABLE IF NOT EXISTS images (
id SERIAL,
vanity char(12) NOT NULL,
title varchar(128),
filename varchar(64) NOT NULL,
thumb_filename varchar(64) NOT NULL,
datetime timestamp with time zone NOT NULL,
PRIMARY KEY (id)
);
|
