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 revisionNext revision | Previous revision | ||
| install:upgrade:3.2.x-to-3.3.0 [2013/07/15 20:36] – [SQL Commands] PostgreSQL partially tested. Updates for lcr_rule version and domain_attrs privileges. elactrum | 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.1373920604.txt.gz · Last modified: 2013/07/15 20:36 (external edit)