diff options
| author | Brenda Wallace <shiny@cpan.org> | 2009-06-26 22:39:19 +1200 |
|---|---|---|
| committer | Brenda Wallace <shiny@cpan.org> | 2009-07-15 18:50:29 +1200 |
| commit | 186b5a1674ae345829b57c495f590140424e04ad (patch) | |
| tree | a7070b1eb099f93a36e179b8c6bb730d85b9ecd1 /db/laconica_pg.sql | |
| parent | f22ed5dc807392889a910d491b614c5d33efa8af (diff) | |
added design_id to user_group
Diffstat (limited to 'db/laconica_pg.sql')
| -rw-r--r-- | db/laconica_pg.sql | 3 |
1 files changed, 3 insertions, 0 deletions
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' */
|