1234567891011 |
- CREATE TABLE `sc_entry` (
- `ident` char(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
- `date` date NOT NULL,
- `created` datetime NOT NULL,
- `modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- `body` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
- `words` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
- PRIMARY KEY (`ident`) USING BTREE,
- KEY `date` (`date`),
- FULLTEXT KEY `words` (`words`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin
|