This shows you the differences between two versions of the page.
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 | + | ALTER TABLE active_watchers ADD COLUMN user_agent |
DELETE FROM version WHERE TABLE_NAME=' | DELETE FROM version WHERE TABLE_NAME=' | ||
INSERT INTO version (TABLE_NAME, | INSERT INTO version (TABLE_NAME, |