User Tools

Site Tools


install:upgrade:3.2.x-to-3.3.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.2.x-to-3.3.0 [2014/09/23 11:17]
klaus3000 syntax highlighting for SQL automatically writes the word domain in capital letters as it is a reserved word. Thus, ALTER TABLE DOMAIN will fail
install:upgrade:3.2.x-to-3.3.0 [2014/09/23 11:21] (current)
klaus3000
Line 73: Line 73:
 You can use next SQL commands (made for MySQL) to update the structure of existing tables in v3.2.x for v3.3.0: You can use next SQL commands (made for MySQL) to update the structure of existing tables in v3.2.x for v3.3.0:
  
-<​code ​sql>+<​code ​->
  
 -- PERMISSIONS module -- PERMISSIONS module
Line 204: Line 204:
 This is the translation of the above MySQL script for PostgreSQL (Should work with 9.1.1, partially tested on 9.1.5.) This is the translation of the above MySQL script for PostgreSQL (Should work with 9.1.1, partially tested on 9.1.5.)
  
-<​code ​sql>+<​code ​->
 -- PERMISSIONS module -- PERMISSIONS module
 ALTER TABLE address ALTER COLUMN ip_addr TYPE varchar(48);​ ALTER TABLE address ALTER COLUMN ip_addr TYPE varchar(48);​
install/upgrade/3.2.x-to-3.3.0.txt · Last modified: 2014/09/23 11:21 by klaus3000