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;