X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=db%2Fsite.sql;h=f87995b94362c0f7ecb596475f48e0a0649329ea;hb=6a848bcc8ac37066f7c4941132195d2d67d3b376;hp=660ba475bb586edff429a7c271e8f434c96c2e96;hpb=5953d56fe2db5cf610cd13e3806d5596964592cf;p=quix0rs-gnu-social.git

diff --git a/db/site.sql b/db/site.sql
index 660ba475bb..f87995b943 100644
--- a/db/site.sql
+++ b/db/site.sql
@@ -1,17 +1,33 @@
 /* For managing multiple sites */
 
 create table status_network (
-
-    nickname varchar(64) primary key comment 'nickname',
+       
+    site_id  integer auto_increment primary key comment 'unique id',
+    nickname varchar(64)  unique 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',
 
+    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'
 
 ) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci;
+
+create table status_network_tag (
+    site_id integer  comment 'unique id',
+    tag varchar(64) comment 'tag name',
+    created datetime not null comment 'date the record was created',
+
+    constraint primary key (site_id, tag)
+) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci;
+