User Tools
install:upgrade:4.0.x-to-4.1.0
Differences
This shows you the differences between two versions of the page.
| Both sides previous 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, | 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, | ||
install/upgrade/4.0.x-to-4.1.0.txt ยท Last modified: 2013/12/06 11:25 by miconda
Page Tools
