This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
install:upgrade:4.3.x-to-4.4.0 [2016/07/26 15:23] linuxmaniac [MySQL Database Structure] |
install:upgrade:4.3.x-to-4.4.0 [2016/09/07 22:47] giacomo.vacca [Postgres Database Structure] |
||
---|---|---|---|
Line 78: | Line 78: | ||
INSERT INTO version (`table_name`, | INSERT INTO version (`table_name`, | ||
+ | |||
+ | </ | ||
+ | |||
+ | |||
+ | |||
+ | ==== Postgres Database Structure ==== | ||
+ | Run following SQL statements in psql client to upgrade database structure from v4.3 to v4.4: | ||
+ | |||
+ | <code sql> | ||
+ | -- table: active_watchers | ||
+ | ALTER TABLE active_watchers ADD COLUMN flags INTEGER DEFAULT 0 NOT NULL; | ||
+ | ALTER TABLE active_watchers ADD COLUMN user_agent VARCHAR(255) DEFAULT '' | ||
+ | DELETE FROM version WHERE TABLE_NAME=' | ||
+ | INSERT INTO version (TABLE_NAME, | ||
+ | |||
+ | -- table: trusted | ||
+ | ALTER TABLE trusted ADD COLUMN priority INTEGER DEFAULT 0 NOT NULL; | ||
+ | ALTER TABLE trusted ADD COLUMN ruri_pattern VARCHAR(64) NULL; | ||
+ | ALTER TABLE trusted ALTER COLUMN tag TYPE VARCHAR(64); | ||
+ | DELETE FROM version WHERE TABLE_NAME=' | ||
+ | INSERT INTO version (TABLE_NAME, | ||
+ | |||
+ | -- table: uacreg | ||
+ | ALTER TABLE uacreg ADD COLUMN reg_delay INTEGER DEFAULT 0 NOT NULL; | ||
+ | ALTER TABLE uacreg ADD COLUMN flags INTEGER DEFAULT 0 NOT NULL; | ||
+ | DELETE FROM version WHERE TABLE_NAME=' | ||
+ | INSERT INTO version (TABLE_NAME, | ||
</ | </ |