Merge remote-tracking branch 'origin/1.0.x' into 1.0.x

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

diff --git a/db/site.sql b/db/site.sql
index bc425841ddd014aab665ab8011969df63fe53a19..c630a83d522cfdbf7c35f72adfb572d65b5b5bbb 100644 (file)
--- a/db/site.sql
+++ b/db/site.sql
@@ -16,6 +16,8 @@ create table status_network (
     theme varchar(255) comment 'theme name',
     logo varchar(255) comment 'site logo',
     
     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'
 


@@ -26,6 +28,7 @@ create table status_network_tag (
     tag varchar(64) comment 'tag name',
     created datetime not null comment 'date the record was created',
 
     tag varchar(64) comment 'tag name',
     created datetime not null comment 'date the record was created',
 

-    constraint primary key (site_id, tag)
+    constraint primary key (site_id, tag),
+    index status_network_tag_tag_idx (tag)

 ) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci;
 
 ) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci;