From a38245d4d184903ab4df6ee81396fd3ab8ae7bf5 Mon Sep 17 00:00:00 2001 From: Brenda Wallace Date: Thu, 25 Jun 2009 22:01:14 +1200 Subject: [PATCH] added missing table "design" --- db/laconica_pg.sql | 12 ++++++++++++ 1 file changed, 12 insertions(+) diff --git a/db/laconica_pg.sql b/db/laconica_pg.sql index f8362ae935..dae8b8fafe 100644 --- a/db/laconica_pg.sql +++ b/db/laconica_pg.sql @@ -486,6 +486,18 @@ create table file_to_post ( unique(file_id, post_id) ); +create sequence design_seq; +create table design ( + id bigint default nextval('design_seq') /* 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'*/, + disposition int default 1 /*comment 'bit 1 = hide background image, bit 2 = display background image, bit 4 = tile background image'*/, + primary key (id) +); /* Textsearch stuff */ -- 2.39.5