install:upgrade:3.3.x-to-4.0.0
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revision | |||
| install:upgrade:3.3.x-to-4.0.0 [2014/02/26 15:54] – miconda | install:upgrade:3.3.x-to-4.0.0 [2014/09/23 09:35] (current) – syntax higlighting automatically writes reserved words in capital letters klaus3000 | ||
|---|---|---|---|
| Line 23: | Line 23: | ||
| Next are the SQL statements that must be executed to get the database structure required by modules that existed in v3.3.x. | Next are the SQL statements that must be executed to get the database structure required by modules that existed in v3.3.x. | ||
| - | < | + | < |
| ALTER TABLE address CHANGE COLUMN ip_addr ip_addr varchar(50) NOT NULL; # was varchar(48) NOT NULL | ALTER TABLE address CHANGE COLUMN ip_addr ip_addr varchar(50) NOT NULL; # was varchar(48) NOT NULL | ||
| Line 82: | Line 82: | ||
| Next are the SQL statements that must be executed to get the database structure required by new modules added in v4.0.0. | Next are the SQL statements that must be executed to get the database structure required by new modules added in v4.0.0. | ||
| - | < | + | < |
| CREATE TABLE sca_subscriptions ( | CREATE TABLE sca_subscriptions ( | ||
| id int(10) unsigned NOT NULL AUTO_INCREMENT, | id int(10) unsigned NOT NULL AUTO_INCREMENT, | ||
install/upgrade/3.3.x-to-4.0.0.txt · Last modified: 2014/09/23 09:35 by klaus3000