ALTER TABLE cc_tariffplan ADD COLUMN calleridprefix CHAR(30) NOT NULL DEFAULT 'all';INSERT INTO cc_currencies (id, currency, name, value, basecurrency) VALUES (150, 'GYD', 'Guyana Dollar (GYD)', 0.00527,  'USD');ALTER TABLE cc_charge ADD COLUMN id_cc_did bigint ;ALTER TABLE cc_charge ALTER COLUMN id_cc_did SET DEFAULT 0;ALTER TABLE cc_did ADD COLUMN reserved INT DEFAULT 0;ALTER TABLE cc_iax_buddies ADD COLUMN id_cc_card  INT DEFAULT 0 NOT NULL;ALTER TABLE cc_sip_buddies ADD COLUMN id_cc_card INT DEFAULT 0 NOT NULL;CREATE TABLE cc_did_use (    id 									BIGINT NOT NULL AUTO_INCREMENT,    id_cc_card 							BIGINT,    id_did 								BIGINT NOT NULL,    reservationdate 					TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,    releasedate 						TIMESTAMP,    activated 							INT DEFAULT 0,    month_payed 						INT DEFAULT 0,    PRIMARY KEY (id))ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_bin;	CREATE TABLE cc_prefix (	id 								BIGINT NOT NULL AUTO_INCREMENT,	id_cc_country 					BIGINT,	prefixe 						VARCHAR(50) NOT NULL,	destination 					VARCHAR(100) NOT NULL,	PRIMARY KEY (id))ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_bin;	INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Afghanistan','93','1');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Albania','355','2');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Algeria','213','3');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('American Samoa','684','4');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Andorra','376','5');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Angola','244','6');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Anguilla','1264','7');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Antarctica','672','8');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Antigua','1268',9);INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Argentina','54','10');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Armenia','374','11');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Aruba','297','12');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Ascension','247',NULL);INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Australia','61','13');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Australian External Territories','672','13');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Austria','43','14');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Azerbaijan','994','15');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Bahamas','1242','16');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Bahrain','973','17');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Bangladesh','880','18');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Barbados','1246','19');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Barbuda','1268',NULL);INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Belarus','375','20');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Belgium','32','21');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Belize','501','22');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Benin','229','23');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Bermuda','1441','24');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Bhutan','975','25');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Bolivia','591','26');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Bosnia & Herzegovina','387','27');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Botswana','267','28');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Brazil','55','30');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Brasil Telecom','5514','30');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Brazil Telefonica','5515','30');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Brazil Embratel','5521','30');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Brazil Intelig','5523','30');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Brazil Telemar','5531','30');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Brazil mobile phones','550','30');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('British Virgin Islands','1284','31');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Brunei Darussalam','673','32');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Bulgaria','359','33');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Burkina Faso','226','34');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Burundi','257','35');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Cambodia','855','36');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Cameroon','237','37');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Canada','1','38');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Cape Verde Islands','238','39');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Cayman Islands','1345','40');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Central African Republic','236','41');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Chad','235','42');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Chatham Island (New Zealand)','64',NULL);INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Chile','56','43');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('China (PRC)','86','44');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Christmas Island','618','45');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Cocos-Keeling Islands','61','46');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Colombia','57','47');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Colombia Mobile Phones','573','47');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Colombia Orbitel','575','47');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Colombia ETB','577','47');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Colombia Telecom','579','47');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Comoros','269','48');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Congo','242','49');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Congo, Dem. Rep. of  (former Zaire)','243',NULL);INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Cook Islands','682','51');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Costa Rica','506','52');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('C?te d''Ivoire (Ivory Coast)','225','53');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Croatia','385','54');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Cuba','53','55');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Cuba (Guantanamo Bay)','5399','55');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Curaao','599',NULL);INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Cyprus','357','56');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Czech Republic','420','57');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Denmark','45','58');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Diego Garcia','246','241');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Djibouti','253','59');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Dominica','1767','60');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Dominican Republic','1809','61');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('East Timor','670','211');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Easter Island','56',NULL);INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Ecuador','593','62');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Egypt','20','63');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('El Salvador','503','64');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Ellipso (Mobile Satellite service)','8812',NULL);INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('EMSAT (Mobile Satellite service)','88213',NULL);INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Equatorial Guinea','240','65');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Eritrea','291','66');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Estonia','372','67');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Ethiopia','251','68');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Falkland Islands (Malvinas)','500','69');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Faroe Islands','298','70');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Fiji Islands','679','71');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Finland','358','72');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('France','33','73');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('French Antilles','596','74');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('French Guiana','594','75');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('French Polynesia','689','76');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Gabonese Republic','241','77');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Gambia','220','78');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Georgia','995','79');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Germany','49','80');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Ghana','233','81');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Gibraltar','350','82');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Global Mobile Satellite System (GMSS)','881',NULL);INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('ICO Global','8810-8811',NULL);INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Ellipso','8812-8813',NULL);INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Iridium','8816-8817',NULL);INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Globalstar','8818-8819',NULL);INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Globalstar (Mobile Satellite Service)','8818-8819',NULL);INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Greece','30','83');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Greenland','299','84');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Grenada','1473','85');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Guadeloupe','590','86');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Guam','1671','87');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Guantanamo Bay','5399',NULL);INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Guatemala','502','88');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Guinea-Bissau','245','90');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Guinea','224','89');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Guyana','592','91');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Haiti','509','92');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Honduras','504','95');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Hong Kong','852','96');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Hungary','36','97');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('ICO Global (Mobile Satellite Service)','8810-8811',NULL);INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Iceland','354','98');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('India','91','99');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Indonesia','62','100');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Inmarsat (Atlantic Ocean - East)','871','242');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Inmarsat (Atlantic Ocean - West)','874','242');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Inmarsat (Indian Ocean)','873','242');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Inmarsat (Pacific Ocean)','872','242');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Inmarsat SNAC','870','242');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('International Freephone Service','800',NULL);INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('International Shared Cost Service (ISCS)','808',NULL);INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Iran','98','101');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Iraq','964','102');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Ireland','353','103');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Iridium (Mobile Satellite service)','8816-8817',NULL);INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Israel','972','104');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Italy','39','105');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Jamaica','1876','106');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Japan','81','107');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Jordan','962','108');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Kazakhstan','7','109');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Kenya','254','110');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Kiribati','686','111');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Korea (North)','850','112');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Korea (South)','82','113');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Kuwait','965','114');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Kyrgyz Republic','996','115');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Laos','856','116');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Latvia','371','117');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Lebanon','961','118');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Lesotho','266','119');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Liberia','231','120');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Libya','218','121');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Liechtenstein','423','122');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Lithuania','370','123');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Luxembourg','352','124');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Macao','853','125');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Macedonia (Former Yugoslav Rep of.)','389','126');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Madagascar','261','127');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Malawi','265','128');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Malaysia','60','129');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Maldives','960','130');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Mali Republic','223','131');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Malta','356','132');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Marshall Islands','692','133');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Martinique','596','134');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Mauritania','222','135');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Mauritius','230','136');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Mayotte Island','269','137');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Mexico','52','138');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Micronesia, (Federal States of)','691','139');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Midway Island','1808',NULL);INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Moldova','373','140');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Monaco','377','141');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Mongolia','976','142');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Montserrat','1664','143');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Morocco','212','144');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Mozambique','258','145');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Myanmar','95','146');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Namibia','264','147');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Nauru','674','148');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Nepal','977','149');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Netherlands','31','150');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Netherlands Antilles','599','151');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Nevis','1869',NULL);INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('New Caledonia','687','152');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('New Zealand','64','153');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Nicaragua','505','154');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Niger','227','155');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Nigeria','234','156');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Niue','683','157');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Norfolk Island','672','158');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Northern Marianas Islands(Saipan, Rota, & Tinian)','1670','159');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Norway','47','160');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Oman','968','161');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Pakistan','92','162');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Palau','680','163');