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:4.0.x-to-4.1.0 [2013/10/29 22:12] miconda [MySQL - Updates to old database tables] |
install:upgrade:4.0.x-to-4.1.0 [2013/11/15 13:17] miconda [MySQL - Updates to old database tables] |
||
---|---|---|---|
Line 28: | Line 28: | ||
ALTER TABLE dbaliases ADD INDEX alias_idx (alias_username, | ALTER TABLE dbaliases ADD INDEX alias_idx (alias_username, | ||
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, | ||
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, | ||
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, | ||
CREATE TABLE mohqueues ( | CREATE TABLE mohqueues ( | ||
id int(10) unsigned NOT NULL AUTO_INCREMENT, | id int(10) unsigned NOT NULL AUTO_INCREMENT, | ||
Line 61: | Line 65: | ||
) ENGINE=InnoDB DEFAULT CHARSET=latin1; | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; | ||
+ | INSERT INTO version (table_name, | ||
+ | CREATE TABLE rtpproxy ( | ||
+ | id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL, | ||
+ | setid VARCHAR(32) DEFAULT 00 NOT NULL, | ||
+ | url VARCHAR(64) DEFAULT '' | ||
+ | flags INT DEFAULT 0 NOT NULL, | ||
+ | weight INT DEFAULT 1 NOT NULL, | ||
+ | description VARCHAR(64) DEFAULT '' | ||
+ | ); | ||
</ | </ | ||
Line 79: | Line 92: | ||
ALTER TABLE dialplan ENGINE=InnoDB DEFAULT CHARSET=latin1; | ALTER TABLE dialplan ENGINE=InnoDB DEFAULT CHARSET=latin1; | ||
ALTER TABLE dispatcher ENGINE=InnoDB DEFAULT CHARSET=latin1; | ALTER TABLE dispatcher ENGINE=InnoDB DEFAULT CHARSET=latin1; | ||
- | ALTER TABLE domain ENGINE=InnoDB DEFAULT CHARSET=latin1; | + | ALTER TABLE `domain` ENGINE=InnoDB DEFAULT CHARSET=latin1; |
ALTER TABLE domain_attrs ENGINE=InnoDB DEFAULT CHARSET=latin1; | ALTER TABLE domain_attrs ENGINE=InnoDB DEFAULT CHARSET=latin1; | ||
ALTER TABLE domain_name ENGINE=InnoDB DEFAULT CHARSET=latin1; | ALTER TABLE domain_name ENGINE=InnoDB DEFAULT CHARSET=latin1; | ||
Line 109: | Line 122: | ||
ALTER TABLE speed_dial ENGINE=InnoDB DEFAULT CHARSET=latin1; | ALTER TABLE speed_dial ENGINE=InnoDB DEFAULT CHARSET=latin1; | ||
ALTER TABLE subscriber ENGINE=InnoDB DEFAULT CHARSET=latin1; | ALTER TABLE subscriber ENGINE=InnoDB DEFAULT CHARSET=latin1; | ||
- | ALTER TABLE trusted ENGINE=InnoDB DEFAULT CHARSET=latin1; | + | ALTER TABLE `trusted` ENGINE=InnoDB DEFAULT CHARSET=latin1; |
ALTER TABLE uacreg ENGINE=InnoDB DEFAULT CHARSET=latin1; | ALTER TABLE uacreg ENGINE=InnoDB DEFAULT CHARSET=latin1; | ||
ALTER TABLE uid_credentials ENGINE=InnoDB DEFAULT CHARSET=latin1; | ALTER TABLE uid_credentials ENGINE=InnoDB DEFAULT CHARSET=latin1; | ||
Line 127: | Line 140: | ||
===== Configuration File Language ===== | ===== Configuration File Language ===== | ||
+ | ==== Core Parameters ==== | ||
+ | * **syn_branch** has been removed - core acts now always as syn_branch=0 - the Via header branch value is computed based on transaction attributes |