summaryrefslogtreecommitdiff
path: root/design/database.sql
diff options
context:
space:
mode:
Diffstat (limited to 'design/database.sql')
-rw-r--r--design/database.sql7
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,