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 revisionNext revision | Previous revision | ||
| install:upgrade:3.3.x-to-4.0.0 [2013/03/29 11:25] – [modules/tm] 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 57: | Line 57: | ||
| ruid varchar(64) NOT NULL DEFAULT '', | ruid varchar(64) NOT NULL DEFAULT '', | ||
| username varchar(64) NOT NULL DEFAULT '', | username varchar(64) NOT NULL DEFAULT '', | ||
| - | domain varchar(64) DEFAULT NULL, | + | |
| aname varchar(64) NOT NULL DEFAULT '', | aname varchar(64) NOT NULL DEFAULT '', | ||
| atype int(11) NOT NULL DEFAULT ' | atype int(11) NOT NULL DEFAULT ' | ||
| 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.1364556304.txt.gz · Last modified: 2013/03/29 11:25 by miconda