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:3.2.x-to-3.3.0 [2012/07/11 12:19] klaus3000 [SQL Commands] |
install:upgrade:3.2.x-to-3.3.0 [2014/09/23 11:13] klaus3000 test |
||
---|---|---|---|
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 202: | 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 |
<code sql> | <code sql> | ||
Line 284: | 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 340: | 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, |