From 186b5a1674ae345829b57c495f590140424e04ad Mon Sep 17 00:00:00 2001
From: Brenda Wallace <shiny@cpan.org>
Date: Fri, 26 Jun 2009 22:39:19 +1200
Subject: added design_id to user_group

---
 db/laconica_pg.sql | 3 +++
 1 file changed, 3 insertions(+)

(limited to 'db/laconica_pg.sql')

diff --git a/db/laconica_pg.sql b/db/laconica_pg.sql
index 92331181d..e70573bfb 100644
--- a/db/laconica_pg.sql
+++ b/db/laconica_pg.sql
@@ -1,3 +1,4 @@
+    design_id integer comment 'id of a design' references design(id),
 /* local and remote users have profiles */
 
 create sequence profile_seq;
@@ -390,6 +391,8 @@ create table user_group (
     homepage_logo varchar(255) /* comment 'homepage (profile) size logo' */,
     stream_logo varchar(255) /* comment 'stream-sized logo' */,
     mini_logo varchar(255) /* comment 'mini logo' */,
+    design_id integer /*comment 'id of a design' */ references design(id),
+
 
     created timestamp not null default CURRENT_TIMESTAMP /* comment 'date this record was created' */,
     modified timestamp /* comment 'date this record was modified' */
-- 
cgit v1.2.3-54-g00ecf

