diff options
author | Evgeny Zinoviev <me@ch1p.io> | 2023-03-04 01:46:45 +0300 |
---|---|---|
committer | Evgeny Zinoviev <me@ch1p.io> | 2023-03-04 01:46:45 +0300 |
commit | eeb84c5be16ecca239adae9c851bc0f7db0875a1 (patch) | |
tree | 9aa1056e643212e4c6133d90f38a1966f0fa35ca /mysql_schema.sql | |
parent | 917d2622aa5fe748c1cda914eae94c12be743c42 (diff) |
blog: support ToC
Diffstat (limited to 'mysql_schema.sql')
-rw-r--r-- | mysql_schema.sql | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/mysql_schema.sql b/mysql_schema.sql index fa5459b..8246db5 100644 --- a/mysql_schema.sql +++ b/mysql_schema.sql @@ -43,7 +43,9 @@ CREATE TABLE `posts` ( PRIMARY KEY (`id`), UNIQUE KEY `short_name` (`short_name`), KEY ` visible_ts_idx` (`visible`,`ts`) -) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +ALTER TABLE `posts` ADD `toc` TINYINT(1) NOT NULL DEFAULT '0' AFTER `short_name`; +ALTER TABLE `posts` ADD `toc_html` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' AFTER `toc`; CREATE TABLE `posts_tags` ( `id` int(11) NOT NULL, |