Kamailio SIP Server Wiki

User Tools

Site Tools

Trace:
install:upgrade:3.3.x-to-4.0.0

Differences

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

Link to this comparison view

Next revision 		Previous revision
Next revision Both sides next revision
install:upgrade:3.3.x-to-4.0.0 [2013/01/23 14:37]
miconda created 		install:upgrade:3.3.x-to-4.0.0 [2013/01/23 19:09]
miconda [MySQL - New database tables]
Line 20: Line 20:
  
 <code sql> <code sql>
-ALTER TABLE active_watchers DROP INDEX active_watchers_pres; # was INDEX (presentity_uri) 
-ALTER TABLE active_watchers ADD INDEX active_watchers_pres (presentity_uri,event); 
 ALTER TABLE address CHANGE COLUMN ip_addr ip_addr varchar(50) NOT NULL; # was varchar(48) NOT NULL ALTER TABLE address CHANGE COLUMN ip_addr ip_addr varchar(50) NOT NULL; # was varchar(48) NOT NULL
 +
 ALTER TABLE aliases CHANGE COLUMN expires expires datetime NOT NULL DEFAULT '2030-05-28 21:32:15'; # was datetime NOT NULL DEFAULT '2020-05-28 21:32:15' ALTER TABLE aliases CHANGE COLUMN expires expires datetime NOT NULL DEFAULT '2030-05-28 21:32:15'; # was datetime NOT NULL DEFAULT '2020-05-28 21:32:15'
 ALTER TABLE aliases ADD UNIQUE ruid_idx (ruid); ALTER TABLE aliases ADD UNIQUE ruid_idx (ruid);
 +
 ALTER TABLE lcr_gw CHANGE COLUMN ip_addr ip_addr varchar(50) DEFAULT NULL; # was varchar(47) DEFAULT NULL ALTER TABLE lcr_gw CHANGE COLUMN ip_addr ip_addr varchar(50) DEFAULT NULL; # was varchar(47) DEFAULT NULL
 +
 ALTER TABLE location CHANGE COLUMN path path varchar(512) DEFAULT NULL; # was varchar(128) DEFAULT NULL ALTER TABLE location CHANGE COLUMN path path varchar(512) DEFAULT NULL; # was varchar(128) DEFAULT NULL
 ALTER TABLE location CHANGE COLUMN expires expires datetime NOT NULL DEFAULT '2030-05-28 21:32:15'; # was datetime NOT NULL DEFAULT '2020-05-28 21:32:15' ALTER TABLE location CHANGE COLUMN expires expires datetime NOT NULL DEFAULT '2030-05-28 21:32:15'; # was datetime NOT NULL DEFAULT '2020-05-28 21:32:15'
 ALTER TABLE location ADD UNIQUE ruid_idx (ruid); ALTER TABLE location ADD UNIQUE ruid_idx (ruid);
 ALTER TABLE location ADD INDEX expires_idx (expires); ALTER TABLE location ADD INDEX expires_idx (expires);
 +
 +ALTER TABLE active_watchers DROP INDEX active_watchers_pres; # was INDEX (presentity_uri)
 +ALTER TABLE active_watchers ADD INDEX active_watchers_pres (presentity_uri,event);
 +
 ALTER TABLE pua DROP INDEX tmp_record2_idx; # was INDEX (pres_id,etag) ALTER TABLE pua DROP INDEX tmp_record2_idx; # was INDEX (pres_id,etag)
 ALTER TABLE pua DROP INDEX tmp_dlg2_idx; # was INDEX (pres_id,pres_uri,call_id,from_tag) ALTER TABLE pua DROP INDEX tmp_dlg2_idx; # was INDEX (pres_id,pres_uri,call_id,from_tag)
Line 39: Line 44:
 ALTER TABLE pua DROP INDEX tmp_dlg1_idx; # was INDEX (call_id,from_tag) ALTER TABLE pua DROP INDEX tmp_dlg1_idx; # was INDEX (call_id,from_tag)
 ALTER TABLE pua ADD INDEX record_idx (pres_id); ALTER TABLE pua ADD INDEX record_idx (pres_id);
 +
 ALTER TABLE rls_watchers DROP INDEX rls_watchers_delete; # was INDEX (callid,to_tag) ALTER TABLE rls_watchers DROP INDEX rls_watchers_delete; # was INDEX (callid,to_tag)
 +
 ALTER TABLE version ADD UNIQUE table_name_idx (table_name); ALTER TABLE version ADD UNIQUE table_name_idx (table_name);
-INSERT INTO version (table_name, table_version) values ('location_attrs','1');+
 CREATE TABLE location_attrs ( CREATE TABLE location_attrs (
   id int(10) unsigned NOT NULL AUTO_INCREMENT,   id int(10) unsigned NOT NULL AUTO_INCREMENT,
Line 55: Line 62:
   KEY last_modified_idx (last_modified)   KEY last_modified_idx (last_modified)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1; ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 +
 +INSERT INTO version (table_name, table_version) values ('location_attrs','1');
 +DELETE FROM version WHERE table_name='address';
 +INSERT INTO version (table_name, table_version) values ('address','6');
 +DELETE FROM version WHERE table_name='lcr_gw';
 +INSERT INTO version (table_name, table_version) values ('lcr_gw','3');
 +DELETE FROM version WHERE table_name='aliases';
 +INSERT INTO version (table_name, table_version) values ('aliases','6');
 +DELETE FROM version WHERE table_name='location';
 +INSERT INTO version (table_name, table_version) values ('location','6');
 </code> </code>
  
Line 167: Line 184:
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1; ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 </code> </code>
 +
 +===== SER Modules =====
 +
 +SER modules that had no equivalent in Kamailio were moved to **modules/** folder. Several of them were renamed:
 +
 +  * auth_db => uid_auth_db
 +  * avp_db => uid_auth_db
 +  * domain => uid_domain
 +  * gflags => uid_gflags
 +  * uri_db => uid_uri_db
install/upgrade/3.3.x-to-4.0.0.txt ยท Last modified: 2014/09/23 11:35 by klaus3000

Page Tools

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki