X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=db%2Fsite.sql;h=9e33fc007ccdcae8f9742e8917976a625b15785e;hb=b6be1a36591cef4a31b79f73026066996eac4fd4;hp=bc425841ddd014aab665ab8011969df63fe53a19;hpb=7065450f03078fb1ac2105b75f9c7a4e052bca9c;p=quix0rs-gnu-social.git

diff --git a/db/site.sql b/db/site.sql
index bc425841dd..9e33fc007c 100644
--- a/db/site.sql
+++ b/db/site.sql
@@ -16,16 +16,19 @@ create table status_network (
     theme varchar(255) comment 'theme name',
     logo varchar(255) comment 'site logo',
     
-    created datetime not null comment 'date this record was created',
-    modified timestamp comment 'date this record was modified'
+    tags text comment 'site meta-info tags (pipe-separated)',
 
-) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci;
+    created datetime not null comment 'date this record was created' default now(),
+    modified timestamp comment 'date this record was modified' default now()
+
+) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_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;
+    constraint primary key (site_id, tag),
+    index status_network_tag_tag_idx (tag)
+) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;