Differences

This shows you the differences between two versions of the page.

--- install:upgrade:3.2.x-to-3.3.0 [2012/07/11 09:38] – [modules_k/presence] klaus3000
+++ install:upgrade:3.2.x-to-3.3.0 [2014/09/23 09:21] (current) – 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:
-<code sql>
+<code ->
 -- PERMISSIONS module
@@ Line 123: / Line 123: @@
   UNIQUE KEY domain_attrs_idx (did,name,value)
 ) 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
@@ Line 197: / Line 202: @@
 === PostgreSQL ===
-This is the translation of the above MySQL script for PostgreSQL (should work with 9.1.1, but is untested!)
+This is the translation of the above MySQL script for PostgreSQL (Should work with 9.1.1, partially tested on 9.1.5.)
-<code sql>
+<code ->
 -- PERMISSIONS module
 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
 DELETE FROM active_watchers;
@@ Line 335: / Line 345: @@
 DELETE FROM version WHERE table_name='dialog';
 INSERT INTO version (table_name, table_version) VALUES ('dialog','7');
+DELETE FROM version WHERE table_name='lcr_rule';
+INSERT INTO version (table_name, table_version) VALUES ('lcr_rule','2');
 DELETE FROM version WHERE table_name='domain';
 INSERT INTO version (table_name, table_version) VALUES ('domain','2');