This shows you the differences between two versions of the page.
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 ' | ADD COLUMN flags int(11) NOT NULL DEFAULT ' | ||
- | ADD COLUMN user_agent varchar(255) NOT NULL; | + | ADD COLUMN user_agent varchar(255) |
DELETE FROM version WHERE TABLE_NAME=' | DELETE FROM version WHERE TABLE_NAME=' | ||
INSERT INTO version (`table_name`, | INSERT INTO version (`table_name`, | ||
-- table: trusted | -- table: trusted | ||
- | ALTER TABLE trusted | + | ALTER TABLE `trusted` |
ADD COLUMN priority int(11) NOT NULL DEFAULT ' | ADD COLUMN priority int(11) NOT NULL DEFAULT ' | ||
ADD COLUMN ruri_pattern varchar(64) NULL, | ADD COLUMN ruri_pattern varchar(64) NULL, |