- Documentation >
- Upgrading Ibexa DXP >
- 5. Upgrade the database
5. Upgrade the database
Apply the following database update script:
mysql -u <username> -p <password> <database_name> < upgrade/db/mysql/ezplatform-2.5.latest-to-3.0.0.sql
or for PostgreSQL:
psql <database_name> < upgrade/db/postgresql/ezplatform-2.5.latest-to-3.0.0.sql
Solr configuration
If you use Solr as the search engine, make sure that Solr configuration is set to commit Solr index changes directly during Repository updates.
For more information, see Solr configuration.
Dxp
Site Factory upgrade
For production, create the ezsite
and ezsite_public_access
tables and manually import their schema definitions.
For MySQL:
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 | DROP TABLE IF EXISTS `ezsite`;
CREATE TABLE `ezsite` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
`created` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
--
DROP TABLE IF EXISTS `ezsite_public_access`;
CREATE TABLE `ezsite_public_access` (
`public_access_identifier` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`site_id` int(11) NOT NULL,
`site_access_group` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
`status` int(11) NOT NULL,
`config` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
`site_matcher_host` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
PRIMARY KEY (`public_access_identifier`),
KEY `ezsite_public_access_site_id` (`site_id`),
CONSTRAINT `fk_ezsite_public_access_site_id` FOREIGN KEY (`site_id`) REFERENCES `ezsite` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
|
For PostgreSQL:
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 | DROP TABLE IF EXISTS ezsite;
CREATE SEQUENCE ezsite_seq;
CREATE TABLE ezsite (
id int NOT NULL DEFAULT NEXTVAL ('ezsite_seq'),
name varchar(255) NOT NULL DEFAULT '',
created int NOT NULL,
PRIMARY KEY (id)
) ;
--
--
DROP TABLE IF EXISTS ezsite_public_access;
CREATE TABLE ezsite_public_access (
public_access_identifier varchar(255) NOT NULL,
site_id int NOT NULL,
site_access_group varchar(255) NOT NULL DEFAULT '',
status int NOT NULL,
config text NOT NULL,
site_matcher_host varchar(255) DEFAULT NULL,
PRIMARY KEY (public_access_identifier),
CONSTRAINT fk_ezsite_public_access_site_id FOREIGN KEY (site_id) REFERENCES ezsite (id)
) ;
CREATE INDEX ezsite_public_access_site_id ON ezsite_public_access (site_id);
|