按此方法, 数据库xx表重建后,还是无法访问,
这是因为之前升级到 6.3 的时候没有执行一个迁移脚本。
你可以删掉 base_filecomment 表,然后用下面的语句重建:
CREATE TABLE `base_filecomment` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`author` varchar(255) NOT NULL,
`comment` longtext NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`uuid_id` char(32) NOT NULL,
`detail` longtext NOT NULL,
`resolved` tinyint(1) NOT NULL,
PRIMARY KEY (`id`),
KEY `base_filecomment_uuid_id_4f9a2ca2_fk_tags_fileuuidmap_uuid` (`uuid_id`),
KEY `base_filecomment_author_8a4d7e91` (`author`),
KEY `base_filecomment_resolved_e0717eca` (`resolved`),
CONSTRAINT `base_filecomment_uuid_id_4f9a2ca2_fk_tags_fileuuidmap_uuid` FOREIGN KEY (`uuid_id`) REFERENCES `tags_fileuuidmap` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
如果你使用的是 SQLite:
CREATE TABLE "base_filecomment" (
"id" integer NOT NULL PRIMARY KEY AUTOINCREMENT,
"author" varchar(255) NOT NULL,
"comment" text NOT NULL,
"created_at" datetime NOT NULL,
"updated_at" datetime NOT NULL,
"uuid_id" char(32) NOT NULL REFERENCES "tags_fileuuidmap" ("uuid"),
"detail" text NOT NULL,
"resolved" bool NOT NULL);