X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=db%2Fsite.sql;h=c630a83d522cfdbf7c35f72adfb572d65b5b5bbb;hb=c8bc124f0d4c2f7293bfe3d23acbd8865c91795a;hp=bc425841ddd014aab665ab8011969df63fe53a19;hpb=772018810b7b6ea2b8cf18a1b9275fbac8c78343;p=quix0rs-gnu-social.git

diff --git a/db/site.sql b/db/site.sql
index bc425841dd..c630a83d52 100644
--- 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',
     
+    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'
 
@@ -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',
 
-    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;