Differences

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

--- 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:17]
klaus3000 syntax highlighting for SQL automatically writes the word domain in capital letters as it is a reserved word. Thus, ALTER TABLE DOMAIN will fail
@@ Line 202: / 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>
@@ 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
 DELETE FROM active_watchers;
@@ Line 340: / 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');

Kamailio SIP Server Wiki