From b2a7cfb9b152dcad1333b92dde76af3a164af8f6 Mon Sep 17 00:00:00 2001 From: jesse Date: Fri, 27 May 2011 11:57:02 -0700 Subject: Got image posting finished. --- design/database.sql | 7 +++++++ 1 file changed, 7 insertions(+) (limited to 'design') 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, -- cgit v1.2.3