diff options
author | Thomas Lange <code@nerdmind.de> | 2021-06-17 19:23:58 +0200 |
---|---|---|
committer | Thomas Lange <code@nerdmind.de> | 2021-06-17 19:23:58 +0200 |
commit | ef1c84224bd3bc22b6e954794db6a355fe934821 (patch) | |
tree | d9f501aa4546b5a0614f23136224e60fa1a88115 /Upgrades.md | |
parent | 811cd36c0d60bd89e3290ebd6355d3798d5e8b74 (diff) | |
download | wiki-ef1c84224bd3bc22b6e954794db6a355fe934821.tar.gz wiki-ef1c84224bd3bc22b6e954794db6a355fe934821.tar.xz wiki-ef1c84224bd3bc22b6e954794db6a355fe934821.zip |
Rename Upgrades.md to Upgrading.md
Diffstat (limited to 'Upgrades.md')
-rw-r--r-- | Upgrades.md | 57 |
1 files changed, 0 insertions, 57 deletions
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`; -~~~ |