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/11/04 12:15] miconda [MySQL - Updates to old database tables] |
install:upgrade:4.0.x-to-4.1.0 [2013/11/25 10:29] kolbu [Core Parameters] |
||
---|---|---|---|
Line 65: | 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 83: | 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 113: | 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 134: | Line 143: | ||
* **syn_branch** has been removed - core acts now always as syn_branch=0 - the Via header branch value is computed based on transaction attributes | * **syn_branch** has been removed - core acts now always as syn_branch=0 - the Via header branch value is computed based on transaction attributes | ||
+ | * **dns_naptr_ignore_rfc** has been added. Specifies if the Order field in a NAPTR record should be respected. Old code, and still default, is to ignore. |