User Tools

Site Tools


install:upgrade:3.3.x-to-4.0.0

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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.
  
-<​code ​sql>+<​code ​->
 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.
  
-<​code ​sql>+<​code ​->
 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