Changeset 1015
- Timestamp:
- 09/14/08 19:04:29 (2 months ago)
- Files:
Legend:
- Unmodified
- Added
- Removed
- Modified
- Copied
- Moved
trunk/DataBase/mysql-5.x/UPDATE-a2billing-v1.3.0-to-v1.4.0-mysql-NDBCLUSTER.sql
r1003 r1015 1096 1096 ALTER TABLE cc_call DROP terminatecause; 1097 1097 ALTER TABLE cc_call ADD INDEX ( terminatecauseid ); 1098 1099 1100 1098 1099 -- Add index on prefix 1100 ALTER TABLE cc_prefix ADD INDEX ( prefixe ); 1101 1102 -- optimization on CDR 1103 ALTER TABLE cc_call ADD COLUMN id_cc_prefix INT (11) DEFAULT 0; 1104 ALTER TABLE cc_ratecard ADD COLUMN id_cc_prefix INT (11) DEFAULT 0; 1105 1106 -- ALTER TABLE cc_ratecard DROP destination; 1107 1108 ALTER TABLE cc_call DROP username; 1109 ALTER TABLE cc_call DROP destination; 1110 ALTER TABLE cc_call DROP startdelay; 1111 ALTER TABLE cc_call DROP stopdelay; 1112 ALTER TABLE cc_call DROP usertariff; 1113 ALTER TABLE cc_call DROP calledprovider; 1114 ALTER TABLE cc_call DROP calledcountry; 1115 ALTER TABLE cc_call DROP calledsub; 1116 trunk/DataBase/mysql-5.x/UPDATE-a2billing-v1.3.0-to-v1.4.0-mysql.sql
r1003 r1015 1095 1095 ALTER TABLE cc_call DROP terminatecause; 1096 1096 ALTER TABLE cc_call ADD INDEX ( terminatecauseid ); 1097 1098 1099 1097 1098 -- Add index on prefix 1099 ALTER TABLE cc_prefix ADD INDEX ( prefixe ); 1100 1101 -- optimization on CDR 1102 ALTER TABLE cc_call ADD COLUMN id_cc_prefix INT (11) DEFAULT 0; 1103 ALTER TABLE cc_ratecard ADD COLUMN id_cc_prefix INT (11) DEFAULT 0; 1104 1105 -- ALTER TABLE cc_ratecard DROP destination; 1106 1107 ALTER TABLE cc_call DROP username; 1108 ALTER TABLE cc_call DROP destination; 1109 ALTER TABLE cc_call DROP startdelay; 1110 ALTER TABLE cc_call DROP stopdelay; 1111 ALTER TABLE cc_call DROP usertariff; 1112 ALTER TABLE cc_call DROP calledprovider; 1113 ALTER TABLE cc_call DROP calledcountry; 1114 ALTER TABLE cc_call DROP calledsub; 1115
