Kamailio SIP Server Wiki

User Tools

Site Tools

Trace:
install:upgrade:4.0.x-to-4.1.0

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
Next revision Both sides next revision
install:upgrade:4.0.x-to-4.1.0 [2013/10/30 09:00]
miconda [Core Parameters] 		install:upgrade:4.0.x-to-4.1.0 [2013/11/04 12:15]
miconda [MySQL - Updates to old database tables]
Line 28: Line 28:
 ALTER TABLE dbaliases ADD INDEX alias_idx (alias_username,alias_domain); ALTER TABLE dbaliases ADD INDEX alias_idx (alias_username,alias_domain);
 ALTER TABLE dbaliases ADD INDEX alias_user_idx (alias_username); ALTER TABLE dbaliases ADD INDEX alias_user_idx (alias_username);
 +
 +INSERT INTO version (table_name, table_version) values ('acc_cdrs','1');
 CREATE TABLE acc_cdrs ( CREATE TABLE acc_cdrs (
   id int(10) unsigned NOT NULL AUTO_INCREMENT,   id int(10) unsigned NOT NULL AUTO_INCREMENT,
Line 37: Line 39:
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
 +INSERT INTO version (table_name, table_version) values ('mohqcalls','1');
 CREATE TABLE mohqcalls ( CREATE TABLE mohqcalls (
   id int(10) unsigned NOT NULL AUTO_INCREMENT,   id int(10) unsigned NOT NULL AUTO_INCREMENT,
Line 49: Line 52:
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
 +INSERT INTO version (table_name, table_version) values ('mohqueues','1');
 CREATE TABLE mohqueues ( CREATE TABLE mohqueues (
   id int(10) unsigned NOT NULL AUTO_INCREMENT,   id int(10) unsigned NOT NULL AUTO_INCREMENT,
Line 79: Line 83:
 ALTER TABLE dialplan ENGINE=InnoDB DEFAULT CHARSET=latin1; # was ENGINE=MyISAM DEFAULT CHARSET=latin1 ALTER TABLE dialplan ENGINE=InnoDB DEFAULT CHARSET=latin1; # was ENGINE=MyISAM DEFAULT CHARSET=latin1
 ALTER TABLE dispatcher ENGINE=InnoDB DEFAULT CHARSET=latin1; # was ENGINE=MyISAM DEFAULT CHARSET=latin1 ALTER TABLE dispatcher ENGINE=InnoDB DEFAULT CHARSET=latin1; # was ENGINE=MyISAM DEFAULT CHARSET=latin1
-ALTER TABLE domain ENGINE=InnoDB DEFAULT CHARSET=latin1; # was ENGINE=MyISAM DEFAULT CHARSET=latin1+ALTER TABLE `domain` ENGINE=InnoDB DEFAULT CHARSET=latin1; # was ENGINE=MyISAM DEFAULT CHARSET=latin1
 ALTER TABLE domain_attrs ENGINE=InnoDB DEFAULT CHARSET=latin1; # was ENGINE=MyISAM DEFAULT CHARSET=latin1 ALTER TABLE domain_attrs ENGINE=InnoDB DEFAULT CHARSET=latin1; # was ENGINE=MyISAM DEFAULT CHARSET=latin1
 ALTER TABLE domain_name ENGINE=InnoDB DEFAULT CHARSET=latin1; # was ENGINE=MyISAM DEFAULT CHARSET=latin1 ALTER TABLE domain_name ENGINE=InnoDB DEFAULT CHARSET=latin1; # was ENGINE=MyISAM DEFAULT CHARSET=latin1
Line 109: Line 113:
 ALTER TABLE speed_dial ENGINE=InnoDB DEFAULT CHARSET=latin1; # was ENGINE=MyISAM DEFAULT CHARSET=latin1 ALTER TABLE speed_dial ENGINE=InnoDB DEFAULT CHARSET=latin1; # was ENGINE=MyISAM DEFAULT CHARSET=latin1
 ALTER TABLE subscriber ENGINE=InnoDB DEFAULT CHARSET=latin1; # was ENGINE=MyISAM DEFAULT CHARSET=latin1 ALTER TABLE subscriber ENGINE=InnoDB DEFAULT CHARSET=latin1; # was ENGINE=MyISAM DEFAULT CHARSET=latin1
-ALTER TABLE trusted ENGINE=InnoDB DEFAULT CHARSET=latin1; # was ENGINE=MyISAM DEFAULT CHARSET=latin1+ALTER TABLE `trusted` ENGINE=InnoDB DEFAULT CHARSET=latin1; # was ENGINE=MyISAM DEFAULT CHARSET=latin1
 ALTER TABLE uacreg ENGINE=InnoDB DEFAULT CHARSET=latin1; # was ENGINE=MyISAM DEFAULT CHARSET=latin1 ALTER TABLE uacreg ENGINE=InnoDB DEFAULT CHARSET=latin1; # was ENGINE=MyISAM DEFAULT CHARSET=latin1
 ALTER TABLE uid_credentials ENGINE=InnoDB DEFAULT CHARSET=latin1; # was ENGINE=MyISAM DEFAULT CHARSET=latin1 ALTER TABLE uid_credentials ENGINE=InnoDB DEFAULT CHARSET=latin1; # was ENGINE=MyISAM DEFAULT CHARSET=latin1
install/upgrade/4.0.x-to-4.1.0.txt ยท Last modified: 2013/12/06 11:25 by miconda

Page Tools

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki