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
Next 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:21]
miconda [MySQL Database Structure]
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 96: Line 102:
 -- 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