This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
install:upgrade:3.2.x-to-3.3.0 [2012/07/11 11:38] klaus3000 [modules_k/presence] |
install:upgrade:3.2.x-to-3.3.0 [2014/09/23 11:21] klaus3000 |
||
---|---|---|---|
Line 73: | Line 73: | ||
You can use next SQL commands (made for MySQL) to update the structure of existing tables in v3.2.x for v3.3.0: | You can use next SQL commands (made for MySQL) to update the structure of existing tables in v3.2.x for v3.3.0: | ||
- | < | + | < |
-- PERMISSIONS module | -- PERMISSIONS module | ||
Line 123: | Line 123: | ||
UNIQUE KEY domain_attrs_idx (did, | UNIQUE KEY domain_attrs_idx (did, | ||
) ENGINE=MyISAM DEFAULT CHARSET=latin1; | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | ||
+ | |||
+ | GRANT ALL PRIVILEGES ON TABLE domain_attrs TO openser; | ||
+ | GRANT SELECT ON TABLE domain_attrs TO openserro; | ||
+ | GRANT ALL PRIVILEGES ON TABLE domain_attrs_id_seq TO openser; | ||
+ | GRANT SELECT ON TABLE domain_attrs_id_seq TO openserro; | ||
-- PRESENCE modules | -- PRESENCE modules | ||
Line 197: | Line 202: | ||
=== PostgreSQL === | === PostgreSQL === | ||
- | This is the translation of the above MySQL script for PostgreSQL (should | + | This is the translation of the above MySQL script for PostgreSQL (Should |
- | < | + | < |
-- PERMISSIONS module | -- PERMISSIONS module | ||
ALTER TABLE address ALTER COLUMN ip_addr TYPE varchar(48); | ALTER TABLE address ALTER COLUMN ip_addr TYPE varchar(48); | ||
Line 279: | Line 284: | ||
); | ); | ||
+ | GRANT ALL PRIVILEGES ON TABLE domain_attrs TO openser; | ||
+ | GRANT SELECT ON TABLE domain_attrs TO openserro; | ||
+ | GRANT ALL PRIVILEGES ON TABLE domain_attrs_id_seq TO openser; | ||
+ | GRANT SELECT ON TABLE domain_attrs_id_seq TO openserro; | ||
+ | |||
-- PRESENCE modules | -- PRESENCE modules | ||
DELETE FROM active_watchers; | DELETE FROM active_watchers; | ||
Line 335: | Line 345: | ||
DELETE FROM version WHERE table_name=' | DELETE FROM version WHERE table_name=' | ||
INSERT INTO version (table_name, | INSERT INTO version (table_name, | ||
+ | DELETE FROM version WHERE table_name=' | ||
+ | INSERT INTO version (table_name, | ||
DELETE FROM version WHERE table_name=' | DELETE FROM version WHERE table_name=' | ||
INSERT INTO version (table_name, | INSERT INTO version (table_name, |