User Tools

Site Tools


install:upgrade:4.3.x-to-4.4.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:4.3.x-to-4.4.0 [2016/03/29 11:39]
miconda
install:upgrade:4.3.x-to-4.4.0 [2016/07/26 15:23]
linuxmaniac [MySQL Database Structure]
Line 59: Line 59:
 ALTER TABLE active_watchers ALTER TABLE active_watchers
   ADD COLUMN flags int(11) NOT NULL DEFAULT '0',   ADD COLUMN flags int(11) NOT NULL DEFAULT '0',
-  ADD COLUMN user_agent varchar(255) NOT NULL;+  ADD COLUMN user_agent varchar(255) DEFAULT '' NOT NULL;
 DELETE FROM version WHERE TABLE_NAME='active_watchers'; DELETE FROM version WHERE TABLE_NAME='active_watchers';
 INSERT INTO version (`table_name`, `table_version`) VALUES ('active_watchers','12'); INSERT INTO version (`table_name`, `table_version`) VALUES ('active_watchers','12');
  
 -- table: trusted -- table: trusted
-ALTER TABLE trusted+ALTER TABLE `trusted`
   ADD COLUMN priority int(11) NOT NULL DEFAULT '0',   ADD COLUMN priority int(11) NOT NULL DEFAULT '0',
   ADD COLUMN ruri_pattern varchar(64) NULL,   ADD COLUMN ruri_pattern varchar(64) NULL,
install/upgrade/4.3.x-to-4.4.0.txt ยท Last modified: 2016/09/07 22:47 by giacomo.vacca