Don't accept non-objects before testing with "instanceof".

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

diff --git a/db/site.sql b/db/site.sql
index bc425841ddd014aab665ab8011969df63fe53a19..5e9693f5f71ac5b7d0fa4dad3dd9db1905c707fe 100644 (file)
--- 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',
     
     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'
 

-) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci;
+) 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',
 
 
 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;