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
install:upgrade:4.3.x-to-4.4.0 [2016/09/07 19:18]
giacomo.vacca [Postgres Database Structure]
install:upgrade:4.3.x-to-4.4.0 [2016/09/07 22:47] (current)
giacomo.vacca [Postgres Database Structure]
Line 89: Line 89:
 -- table: active_watchers -- table: active_watchers
 ALTER TABLE active_watchers ADD COLUMN flags INTEGER DEFAULT 0 NOT NULL; ALTER TABLE active_watchers ADD COLUMN flags INTEGER DEFAULT 0 NOT NULL;
-ALTER TABLE active_watchers ADD COLUMN user_agent ​VAR_CHAR(255) DEFAULT ''​ NOT NULL;+ALTER TABLE active_watchers 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'​);​
install/upgrade/4.3.x-to-4.4.0.txt ยท Last modified: 2016/09/07 22:47 by giacomo.vacca