added comsumer_secret to consumer table on postgres

[quix0rs-gnu-social.git] / db / site.sql

diff --git a/db/site.sql b/db/site.sql
index 660ba475bb586edff429a7c271e8f434c96c2e96..791303bd540885857f0f2baef805994684b8261a 100644 (file)
--- a/db/site.sql
+++ b/db/site.sql
@@ -5,12 +5,18 @@ create table status_network (
     nickname varchar(64) primary key comment 'nickname',
     hostname varchar(255) unique key comment 'alternate hostname if any',
     pathname varchar(255) unique key comment 'alternate pathname if any',
     nickname varchar(64) primary key comment 'nickname',
     hostname varchar(255) unique key comment 'alternate hostname if any',
     pathname varchar(255) unique key comment 'alternate pathname if any',

-    sitename varchar(255) comment 'display name',
+

     dbhost varchar(255) comment 'database host',
     dbuser varchar(255) comment 'database username',
     dbpass varchar(255) comment 'database password',
     dbname varchar(255) comment 'database name',
 
     dbhost varchar(255) comment 'database host',
     dbuser varchar(255) comment 'database username',
     dbpass varchar(255) comment 'database password',
     dbname varchar(255) comment 'database name',
 

+    sitename varchar(255) comment 'display name',
+    theme varchar(255) comment 'theme name',
+    logo varchar(255) comment 'site logo',
+    
+    tags text comment 'site meta-info tags (pipe-separated)',
+

     created datetime not null comment 'date this record was created',
     modified timestamp comment 'date this record was modified'
 
     created datetime not null comment 'date this record was created',
     modified timestamp comment 'date this record was modified'