User Tools

Site Tools


install:upgrade:5.4.x-to-5.5.0

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
Last revision Both sides next revision
install:upgrade:5.4.x-to-5.5.0 [2021/04/27 12:20]
miconda [MySQL Database Structure]
install:upgrade:5.4.x-to-5.5.0 [2021/05/24 18:27]
miconda [Misc]
Line 48: Line 48:
 ); );
 </code> </code>
 +
 +Note also the changes in the column names and indexes.
 +
  
   * database table **userblacklist** renamed to **userblocklist** - its definition is now:   * database table **userblacklist** renamed to **userblocklist** - its definition is now:
Line 62: Line 65:
 ); );
 </code> </code>
 +
 +Note also the changes in the column names and indexes.
 +
 ===== Internal Libraries ===== ===== Internal Libraries =====
  
Line 78: Line 84:
 ==== Misc ==== ==== Misc ====
  
 +  * **#!substdef "/match/replacement/flags"** evaluates the **replacement** for variables to be coherent with **#!subst**, if there are variables that should not be evaluated during pre-processing phase, use **$$** at the beginning of variable (e.g., **$$var(x)***
 ===== Database ===== ===== Database =====
  
Line 96: Line 103:
 -- uacreg table -- uacreg table
 ALTER TABLE uacreg ADD COLUMN contact_addr varchar(255) NOT NULL DEFAULT ''; ALTER TABLE uacreg ADD COLUMN contact_addr varchar(255) NOT NULL DEFAULT '';
 +UPDATE version SET table_version=5 WHERE TABLE_NAME='uacreg';
  
 -- IMPORTANT: see also the notes about the userblocklist module -- IMPORTANT: see also the notes about the userblocklist module
 </code> </code>
install/upgrade/5.4.x-to-5.5.0.txt ยท Last modified: 2021/10/04 17:40 by henningw