blob: b2e6a81185a51e20eacde188a4ed3fb5b2e7bc7a (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
|
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`;
~~~
|
