install:upgrade:3.3.x-to-4.0.0
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |||
|
install:upgrade:3.3.x-to-4.0.0 [2014/02/26 16:54] miconda |
install:upgrade:3.3.x-to-4.0.0 [2014/09/23 11:35] (current) klaus3000 syntax higlighting automatically writes reserved words in capital letters |
||
|---|---|---|---|
| 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 11:35 by klaus3000
Page Tools
