diff options
| author | jesse <jesse@jesterpm.net> | 2011-05-27 11:57:02 -0700 |
|---|---|---|
| committer | Jesse Morgan <jesse@jesterpm.net ; true> | 2011-05-27 11:57:02 -0700 |
| commit | b2a7cfb9b152dcad1333b92dde76af3a164af8f6 (patch) | |
| tree | 9f3e8de88043fd3e4ed22c249abbf1372f66971b /design | |
| parent | 7af236e2dea03ae3086f4d21e0ae1039c7ac3555 (diff) | |
Got image posting finished.
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, |