install:upgrade:3.2.x-to-3.3.0
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revision | |||
| install:upgrade:3.2.x-to-3.3.0 [2014/09/23 09:17] – syntax highlighting for SQL automatically writes the word domain in capital letters as it is a reserved word. Thus, ALTER TABLE DOMAIN will fail klaus3000 | install:upgrade:3.2.x-to-3.3.0 [2014/09/23 09: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: | ||
| - | < | + | < |
| -- 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.) | ||
| - | < | + | < |
| -- 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.1411463871.txt.gz · Last modified: 2014/09/23 09:17 by klaus3000