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