diff options
| author | Thomas Lange <code@nerdmind.de> | 2021-06-17 22:00:39 +0200 |
|---|---|---|
| committer | Thomas Lange <code@nerdmind.de> | 2021-06-17 22:00:39 +0200 |
| commit | 5555624546ea48d6327700f32b80848e0662dc90 (patch) | |
| tree | 47d61fb756a6cb008aaf33586d292fcfe43da2a1 /core/db/migrations/3.sql | |
| parent | 91d8a28c664afa5378735bcd0efe068dd74d589f (diff) | |
| parent | 0a2614cb69fc732c2115ef2f0c356f39f602d311 (diff) | |
| download | blog-5555624546ea48d6327700f32b80848e0662dc90.tar.gz blog-5555624546ea48d6327700f32b80848e0662dc90.tar.xz blog-5555624546ea48d6327700f32b80848e0662dc90.zip | |
Merge branch 'master' into 'optimization'optimization
Diffstat (limited to 'core/db/migrations/3.sql')
| -rw-r--r-- | core/db/migrations/3.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/core/db/migrations/3.sql b/core/db/migrations/3.sql new file mode 100644 index 0000000..ae46ed0 --- /dev/null +++ b/core/db/migrations/3.sql @@ -0,0 +1,6 @@ +ALTER TABLE `post` ENGINE=InnoDB; +ALTER TABLE `post` DROP INDEX `body`; +ALTER TABLE `page` ADD FULLTEXT KEY `search` (`name`, `body`); +ALTER TABLE `post` ADD FULLTEXT KEY `search` (`name`, `body`); +ALTER TABLE `post` ADD CONSTRAINT `post_user` FOREIGN KEY (`user`) + REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; |