diff options
Diffstat (limited to 'design')
-rw-r--r-- | design/database.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/design/database.sql b/design/database.sql index 6bb34da..b79316c 100644 --- a/design/database.sql +++ b/design/database.sql @@ -59,6 +59,13 @@ CREATE TABLE post ( UNIQUE KEY(secretid) ); +CREATE TABLE image ( + id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, + post_id INTEGER UNSIGNED NOT NULL, + + PRIMARY KEY(id) +); + CREATE TABLE user ( id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(60) NOT NULL, |