Skip to content
  • 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);