From ef1c84224bd3bc22b6e954794db6a355fe934821 Mon Sep 17 00:00:00 2001 From: Thomas Lange Date: Thu, 17 Jun 2021 19:23:58 +0200 Subject: Rename Upgrades.md to Upgrading.md --- Upgrades.md | 57 --------------------------------------------------------- 1 file changed, 57 deletions(-) delete mode 100644 Upgrades.md (limited to 'Upgrades.md') diff --git a/Upgrades.md b/Upgrades.md deleted file mode 100644 index b2e6a81..0000000 --- a/Upgrades.md +++ /dev/null @@ -1,57 +0,0 @@ -This document describes how to upgrade the application and perform eventual database schema upgrades from an older release to a newer release. - -For example, if you are coming from `v2.1.2`, you need to perform all database schema upgrades *after* `v2.1.2` (in sequential order) till the release to which you want to upgrade. - -## Release `v2.4.1` (coming from `v2.4`) -For upgrading to this release, a manual database schema upgrade is required. Please execute the following SQL commands inside your blogs database. - -~~~sql -ALTER TABLE `page` MODIFY `argv` VARCHAR(250); -ALTER TABLE `post` MODIFY `argv` VARCHAR(250); -ALTER TABLE `user` MODIFY `argv` VARCHAR(250); -~~~ - -## Release `v2.4` (coming from `v2.3` or `v2.3.1`) -For upgrading to this release, a manual database schema upgrade is required. Please execute the following SQL commands inside your blogs database. - -**NOTICE:** -This upgrade requires MariaDB `>= 10.0.5` or MySQL `>= 5.6`! - -~~~sql -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; -~~~ - -## Release `v2.3` (coming from `v2.2` or `v2.2.1`) -For upgrading to this release, you need to replace the following strings inside your *customized* theme templates (if you have any). - -Search for: `$Language->template` -Replace with: `$Language->text` - -## Release `v2.2` (coming from `v2.1.2`) -For upgrading to this release, you need to replace the following strings inside your *customized* theme templates (if you have any). - -Search for: `['ID']` -Replace with: `['ATTR']['ID']` - -## Release `v2.1.2` (coming from `v2.0`, `v2.1` or `v2.1.1`) -For upgrading to this release, a manual database schema upgrade is required. Please execute the following SQL commands inside your blogs database. - -~~~sql -ALTER TABLE `page` ADD UNIQUE KEY `time_insert` (`time_insert`); -ALTER TABLE `post` ADD UNIQUE KEY `time_insert` (`time_insert`); -ALTER TABLE `user` ADD UNIQUE KEY `time_insert` (`time_insert`); -~~~ - -## Release `v2.0` (coming from `v1.*`) -For upgrading to this release, a manual database schema upgrade is required. Please execute the following SQL commands inside your blogs database. - -~~~sql -ALTER TABLE `page` ADD `argv` VARCHAR(100) NULL DEFAULT NULL AFTER `body`; -ALTER TABLE `post` ADD `argv` VARCHAR(100) NULL DEFAULT NULL AFTER `body`; -ALTER TABLE `user` ADD `argv` VARCHAR(100) NULL DEFAULT NULL AFTER `body`; -~~~ -- cgit v1.2.3