summaryrefslogtreecommitdiff
path: root/db/laconica.sql
diff options
context:
space:
mode:
authorEvan Prodromou <evan@controlyourself.ca>2009-05-22 20:54:07 -0400
committerEvan Prodromou <evan@controlyourself.ca>2009-05-22 20:54:07 -0400
commit2f0fe8e33ae29557911a0d1896a2c1b9725b5e55 (patch)
treea021d20ad40483b11b36977fbc7fc78758e39e0a /db/laconica.sql
parent356022f45ccb92a157de30a5db8a9b94f9d7ceb5 (diff)
add design table to DB
Diffstat (limited to 'db/laconica.sql')
-rw-r--r--db/laconica.sql10
1 files changed, 10 insertions, 0 deletions
diff --git a/db/laconica.sql b/db/laconica.sql
index 0b20bc172..d42c20e2a 100644
--- a/db/laconica.sql
+++ b/db/laconica.sql
@@ -482,3 +482,13 @@ create table file_to_post (
unique(file_id, post_id)
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin;
+
+create table design (
+ id integer primary key auto_increment comment 'design ID',
+ backgroundcolor integer comment 'main background color',
+ contentcolor integer comment 'content area background color',
+ sidebarcolor integer comment 'sidebar background color',
+ textcolor integer comment 'text color',
+ linkcolor integer comment 'link color',
+ backgroundimage varchar(255) comment 'background image, if any'
+) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin;