Kind regards,Call Labs', '');INSERT INTO cc_trunk VALUES (1, 'default', '011', 'IAX2', 'kiki@switch-2.kiki.net', '', 0, 0, 0, '2005-03-14 01:01:36',0 ,0, NULL);---- Country table : Store the iso country list--CREATE TABLE cc_country (    id BIGINT NOT NULL AUTO_INCREMENT,    countrycode CHAR(80) NOT NULL,    countryname CHAR(80) NOT NULL,    PRIMARY KEY (id));INSERT INTO cc_country VALUES (1, 'AFG', 'Afghanistan');INSERT INTO cc_country VALUES (2, 'ALB', 'Albania');INSERT INTO cc_country VALUES (3, 'DZA', 'Algeria');INSERT INTO cc_country VALUES (4, 'ASM', 'American Samoa');INSERT INTO cc_country VALUES (5, 'AND', 'Andorra');INSERT INTO cc_country VALUES (6, 'AGO', 'Angola');INSERT INTO cc_country VALUES (7, 'AIA', 'Anguilla');INSERT INTO cc_country VALUES (8, 'ATA', 'Antarctica');INSERT INTO cc_country VALUES (9, 'ATG', 'Antigua And Barbuda');INSERT INTO cc_country VALUES (10, 'ARG', 'Argentina');INSERT INTO cc_country VALUES (11, 'ARM', 'Armenia');INSERT INTO cc_country VALUES (12, 'ABW', 'Aruba');INSERT INTO cc_country VALUES (13, 'AUS', 'Australia');INSERT INTO cc_country VALUES (14, 'AUT', 'Austria');INSERT INTO cc_country VALUES (15, 'AZE', 'Azerbaijan');INSERT INTO cc_country VALUES (16, 'BHS', 'Bahamas');INSERT INTO cc_country VALUES (17, 'BHR', 'Bahrain');INSERT INTO cc_country VALUES (18, 'BGD', 'Bangladesh');INSERT INTO cc_country VALUES (19, 'BRB', 'Barbados');INSERT INTO cc_country VALUES (20, 'BLR', 'Belarus');INSERT INTO cc_country VALUES (21, 'BEL', 'Belgium');INSERT INTO cc_country VALUES (22, 'BLZ', 'Belize');INSERT INTO cc_country VALUES (23, 'BEN', 'Benin');INSERT INTO cc_country VALUES (24, 'BMU', 'Bermuda');INSERT INTO cc_country VALUES (25, 'BTN', 'Bhutan');INSERT INTO cc_country VALUES (26, 'BOL', 'Bolivia');INSERT INTO cc_country VALUES (27, 'BIH', 'Bosnia And Herzegovina');INSERT INTO cc_country VALUES (28, 'BWA', 'Botswana');INSERT INTO cc_country VALUES (29, 'BV', 'Bouvet Island');INSERT INTO cc_country VALUES (30, 'BRA', 'Brazil');INSERT INTO cc_country VALUES (31, 'IO', 'British Indian Ocean Territory');INSERT INTO cc_country VALUES (32, 'BRN', 'Brunei Darussalam');INSERT INTO cc_country VALUES (33, 'BGR', 'Bulgaria');INSERT INTO cc_country VALUES (34, 'BFA', 'Burkina Faso');INSERT INTO cc_country VALUES (35, 'BDI', 'Burundi');INSERT INTO cc_country VALUES (36, 'KHM', 'Cambodia');INSERT INTO cc_country VALUES (37, 'CMR', 'Cameroon');INSERT INTO cc_country VALUES (38, 'CAN', 'Canada');INSERT INTO cc_country VALUES (39, 'CPV', 'Cape Verde');INSERT INTO cc_country VALUES (40, 'CYM', 'Cayman Islands');INSERT INTO cc_country VALUES (41, 'CAF', 'Central African Republic');INSERT INTO cc_country VALUES (42, 'TCD', 'Chad');INSERT INTO cc_country VALUES (43, 'CHL', 'Chile');INSERT INTO cc_country VALUES (44, 'CHN', 'China');INSERT INTO cc_country VALUES (45, 'CXR', 'Christmas Island');INSERT INTO cc_country VALUES (46, 'CCK', 'Cocos (Keeling) Islands');INSERT INTO cc_country VALUES (47, 'COL', 'Colombia');INSERT INTO cc_country VALUES (48, 'COM', 'Comoros');INSERT INTO cc_country VALUES (49, 'COG', 'Congo');INSERT INTO cc_country VALUES (50, 'COD', 'Congo, The Democratic Republic Of The');INSERT INTO cc_country VALUES (51, 'COK', 'Cook Islands');INSERT INTO cc_country VALUES (52, 'CRI', 'Costa Rica');INSERT INTO cc_country VALUES (54, 'HRV', 'Croatia');INSERT INTO cc_country VALUES (55, 'CUB', 'Cuba');INSERT INTO cc_country VALUES (56, 'CYP', 'Cyprus');INSERT INTO cc_country VALUES (57, 'CZE', 'Czech Republic');INSERT INTO cc_country VALUES (58, 'DNK', 'Denmark');INSERT INTO cc_country VALUES (59, 'DJI', 'Djibouti');INSERT INTO cc_country VALUES (60, 'DMA', 'Dominica');INSERT INTO cc_country VALUES (61, 'DOM', 'Dominican Republic');INSERT INTO cc_country VALUES (62, 'ECU', 'Ecuador');INSERT INTO cc_country VALUES (63, 'EGY', 'Egypt');INSERT INTO cc_country VALUES (64, 'SLV', 'El Salvador');INSERT INTO cc_country VALUES (65, 'GNQ', 'Equatorial Guinea');INSERT INTO cc_country VALUES (66, 'ERI', 'Eritrea');INSERT INTO cc_country VALUES (67, 'EST', 'Estonia');INSERT INTO cc_country VALUES (68, 'ETH', 'Ethiopia');INSERT INTO cc_country VALUES (69, 'FLK', 'Falkland Islands (Malvinas)');INSERT INTO cc_country VALUES (70, 'FRO', 'Faroe Islands');INSERT INTO cc_country VALUES (71, 'FJI', 'Fiji');INSERT INTO cc_country VALUES (72, 'FIN', 'Finland');INSERT INTO cc_country VALUES (73, 'FRA', 'France');INSERT INTO cc_country VALUES (74, 'GUF', 'French Guiana');INSERT INTO cc_country VALUES (75, 'PYF', 'French Polynesia');INSERT INTO cc_country VALUES (76, 'ATF', 'French Southern Territories');INSERT INTO cc_country VALUES (77, 'GAB', 'Gabon');INSERT INTO cc_country VALUES (78, 'GMB', 'Gambia');INSERT INTO cc_country VALUES (79, 'GEO', 'Georgia');INSERT INTO cc_country VALUES (80, 'DEU', 'Germany');INSERT INTO cc_country VALUES (81, 'GHA', 'Ghana');INSERT INTO cc_country VALUES (82, 'GIB', 'Gibraltar');INSERT INTO cc_country VALUES (83, 'GRC', 'Greece');INSERT INTO cc_country VALUES (84, 'GRL', 'Greenland');INSERT INTO cc_country VALUES (85, 'GRD', 'Grenada');INSERT INTO cc_country VALUES (86, 'GLP', 'Guadeloupe');INSERT INTO cc_country VALUES (87, 'GUM', 'Guam');INSERT INTO cc_country VALUES (88, 'GTM', 'Guatemala');INSERT INTO cc_country VALUES (89, 'GIN', 'Guinea');INSERT INTO cc_country VALUES (90, 'GNB', 'Guinea-Bissau');INSERT INTO cc_country VALUES (91, 'GUY', 'Guyana');INSERT INTO cc_country VALUES (92, 'HTI', 'Haiti');INSERT INTO cc_country VALUES (93, 'HM', 'Heard Island And McDonald Islands');INSERT INTO cc_country VALUES (94, 'VAT', 'Holy See (Vatican City State)');INSERT INTO cc_country VALUES (95, 'HND', 'Honduras');INSERT INTO cc_country VALUES (96, 'HKG', 'Hong Kong');INSERT INTO cc_country VALUES (97, 'HUN', 'Hungary');INSERT INTO cc_country VALUES (98, 'ISL', 'Iceland');INSERT INTO cc_country VALUES (99, 'IND', 'India');INSERT INTO cc_country VALUES (100, 'IDN', 'Indonesia');INSERT INTO cc_country VALUES (101, 'IRN', 'Iran, Islamic Republic Of');INSERT INTO cc_country VALUES (102, 'IRQ', 'Iraq');INSERT INTO cc_country VALUES (103, 'IRL', 'Ireland');INSERT INTO cc_country VALUES (104, 'ISR', 'Israel');INSERT INTO cc_country VALUES (105, 'ITA', 'Italy');INSERT INTO cc_country VALUES (106, 'JAM', 'Jamaica');INSERT INTO cc_country VALUES (107, 'JPN', 'Japan');INSERT INTO cc_country VALUES (108, 'JOR', 'Jordan');INSERT INTO cc_country VALUES (109, 'KAZ', 'Kazakhstan');INSERT INTO cc_country VALUES (110, 'KEN', 'Kenya');INSERT INTO cc_country VALUES (111, 'KIR', 'Kiribati');INSERT INTO cc_country VALUES (112, 'PRK', 'Korea, Democratic People''s Republic Of');INSERT INTO cc_country VALUES (113, 'KOR', 'Korea, Republic of');INSERT INTO cc_country VALUES (114, 'KWT', 'Kuwait');INSERT INTO cc_country VALUES (115, 'KGZ', 'Kyrgyzstan');INSERT INTO cc_country VALUES (116, 'LAO', 'Lao People''s Democratic Republic');INSERT INTO cc_country VALUES (117, 'LVA', 'Latvia');INSERT INTO cc_country VALUES (118, 'LBN', 'Lebanon');INSERT INTO cc_country VALUES (119, 'LSO', 'Lesotho');INSERT INTO cc_country VALUES (120, 'LBR', 'Liberia');INSERT INTO cc_country VALUES (121, 'LBY', 'Libyan Arab Jamahiriya');INSERT INTO cc_country VALUES (122, 'LIE', 'Liechtenstein');INSERT INTO cc_country VALUES (123, 'LTU', 'Lithuania');INSERT INTO cc_country VALUES (124, 'LUX', 'Luxembourg');INSERT INTO cc_country VALUES (125, 'MAC', 'Macao');INSERT INTO cc_country VALUES (126, 'MKD', 'Macedonia, The Former Yugoslav Republic Of');INSERT INTO cc_country VALUES (127, 'MDG', 'Madagascar');INSERT INTO cc_country VALUES (128, 'MWI', 'Malawi');INSERT INTO cc_country VALUES (129, 'MYS', 'Malaysia');INSERT INTO cc_country VALUES (130, 'MDV', 'Maldives');INSERT INTO cc_country VALUES (131, 'MLI', 'Mali');INSERT INTO cc_country VALUES (132, 'MLT', 'Malta');INSERT INTO cc_country VALUES (133, 'MHL', 'Marshall islands');INSERT INTO cc_country VALUES (134, 'MTQ', 'Martinique');INSERT INTO cc_country VALUES (135, 'MRT', 'Mauritania');INSERT INTO cc_country VALUES (136, 'MUS', 'Mauritius');INSERT INTO cc_country VALUES (137, 'MYT', 'Mayotte');INSERT INTO cc_country VALUES (138, 'MEX', 'Mexico');INSERT INTO cc_country VALUES (139, 'FSM', 'Micronesia, Federated States Of');INSERT INTO cc_country VALUES (140, 'MDA', 'Moldova, Republic Of');INSERT INTO cc_country VALUES (141, 'MCO', 'Monaco');INSERT INTO cc_country VALUES (142, 'MNG', 'Mongolia');INSERT INTO cc_country VALUES (143, 'MSR', 'Montserrat');INSERT INTO cc_country VALUES (144, 'MAR', 'Morocco');INSERT INTO cc_country VALUES (145, 'MOZ', 'Mozambique');INSERT INTO cc_country VALUES (146, 'MMR', 'Myanmar');INSERT INTO cc_country VALUES (147, 'NAM', 'Namibia');INSERT INTO cc_country VALUES (148, 'NRU', 'Nauru');INSERT INTO cc_country VALUES (149, 'NPL', 'Nepal');INSERT INTO cc_country VALUES (150, 'NLD', 'Netherlands');INSERT INTO cc_country VALUES (151, 'ANT', 'Netherlands Antilles');INSERT INTO cc_country VALUES (152, 'NCL', 'New Caledonia');INSERT INTO cc_country VALUES (153, 'NZL', 'New Zealand');INSERT INTO cc_country VALUES (154, 'NIC', 'Nicaragua');INSERT INTO cc_country VALUES (155, 'NER', 'Niger');INSERT INTO cc_country VALUES (156, 'NGA', 'Nigeria');INSERT INTO cc_country VALUES (157, 'NIU', 'Niue');INSERT INTO cc_country VALUES (158, 'NFK', 'Norfolk Island');INSERT INTO cc_country VALUES (159, 'MNP', 'Northern Mariana Islands');INSERT INTO cc_country VALUES (160, 'NOR', 'Norway');INSERT INTO cc_country VALUES (161, 'OMN', 'Oman');INSERT INTO cc_country VALUES (162, 'PAK', 'Pakistan');INSERT INTO cc_country VALUES (163, 'PLW', 'Palau');INSERT INTO cc_country VALUES (164, 'PSE', 'Palestinian Territory, Occupied');INSERT INTO cc_country VALUES (165, 'PAN', 'Panama');INSERT INTO cc_country VALUES (166, 'PNG', 'Papua New Guinea');INSERT INTO cc_country VALUES (167, 'PRY', 'Paraguay');INSERT INTO cc_country VALUES (168, 'PER', 'Peru');INSERT INTO cc_country VALUES (169, 'PHL', 'Philippines');INSERT INTO cc_country VALUES (170, 'PN', 'Pitcairn');INSERT INTO cc_country VALUES (171, 'POL', 'Poland');INSERT INTO cc_country VALUES (172, 'PRT', 'Portugal');INSERT INTO cc_country VALUES (173, 'PRI', 'Puerto Rico');INSERT INTO cc_country VALUES (174, 'QAT', 'Qatar');INSERT INTO cc_country VALUES (175, 'REU', 'Reunion');INSERT INTO cc_country VALUES (176, 'ROU', 'Romania');INSERT INTO cc_country VALUES (177, 'RUS', 'Russian Federation');INSERT INTO cc_country VALUES (178, 'RWA', 'Rwanda');INSERT INTO cc_country VALUES (179, 'SHN', 'Saint Helena');INSERT INTO cc_country VALUES (180, 'KNA', 'Saint Kitts And Nevis');INSERT INTO cc_country VALUES (181, 'LCA', 'Saint Lucia');INSERT INTO cc_country VALUES (182, 'SPM', 'Saint Pierre And Miquelon');INSERT INTO cc_country VALUES (183, 'VCT', 'Saint Vincent And The Grenadines');INSERT INTO cc_country VALUES (184, 'WSM', 'Samoa');INSERT INTO cc_country VALUES (185, 'SMR', 'San Marino');INSERT INTO cc_country VALUES (186, 'STP', 'Sao Tome And Principe');INSERT INTO cc_country VALUES (187, 'SAU', 'Saudi Arabia');INSERT INTO cc_country VALUES (188, 'SEN', 'Senegal');INSERT INTO cc_country VALUES (189, 'SYC', 'Seychelles');INSERT INTO cc_country VALUES (190, 'SLE', 'Sierra Leone');INSERT INTO cc_country VALUES (191, 'SGP', 'Singapore');INSERT INTO cc_country VALUES (192, 'SVK', 'Slovakia');INSERT INTO cc_country VALUES (193, 'SVN', 'Slovenia');INSERT INTO cc_country VALUES (194, 'SLB', 'Solomon Islands');INSERT INTO cc_country VALUES (195, 'SOM', 'Somalia');INSERT INTO cc_country VALUES (196, 'ZAF', 'South Africa');INSERT INTO cc_country VALUES (197, 'GS', 'South Georgia And The South Sandwich Islands');INSERT INTO cc_country VALUES (198, 'ESP', 'Spain');INSERT INTO cc_country VALUES (199, 'LKA', 'Sri Lanka');INSERT INTO cc_country VALUES (200, 'SDN', 'Sudan');INSERT INTO cc_country VALUES (201, 'SUR', 'Suriname');INSERT INTO cc_country VALUES (202, 'SJ', 'Svalbard and Jan Mayen');INSERT INTO cc_country VALUES (203, 'SWZ', 'Swaziland');INSERT INTO cc_country VALUES (204, 'SWE', 'Sweden');INSERT INTO cc_country VALUES (205, 'CHE', 'Switzerland');INSERT INTO cc_country VALUES (206, 'SYR', 'Syrian Arab Republic');INSERT INTO cc_country VALUES (207, 'TWN', 'Taiwan, Province Of China');INSERT INTO cc_country VALUES (208, 'TJK', 'Tajikistan');INSERT INTO cc_country VALUES (209, 'TZA', 'Tanzania, United Republic Of');INSERT INTO cc_country VALUES (210, 'THA', 'Thailand');INSERT INTO cc_country VALUES (211, 'TL', 'Timor L''Este');INSERT INTO cc_country VALUES (212, 'TGO', 'Togo');INSERT INTO cc_country VALUES (213, 'TKL', 'Tokelau');INSERT INTO cc_country VALUES (214, 'TON', 'Tonga');INSERT INTO cc_country VALUES (215, 'TTO', 'Trinidad And Tobago');INSERT INTO cc_country VALUES (216, 'TUN', 'Tunisia');INSERT INTO cc_country VALUES (217, 'TUR', 'Turkey');INSERT INTO cc_country VALUES (218, 'TKM', 'Turkmenistan');INSERT INTO cc_country VALUES (219, 'TCA', 'Turks And Caicos Islands');INSERT INTO cc_country VALUES (220, 'TUV', 'Tuvalu');INSERT INTO cc_country VALUES (221, 'UGA', 'Uganda');INSERT INTO cc_country VALUES (222, 'UKR', 'Ukraine');INSERT INTO cc_country VALUES (223, 'ARE', 'United Arab Emirates');INSERT INTO cc_country VALUES (224, 'GBR', 'United Kingdom');INSERT INTO cc_country VALUES (225, 'USA', 'United States');INSERT INTO cc_country VALUES (226, 'UM', 'United States Minor Outlying Islands');INSERT INTO cc_country VALUES (227, 'URY', 'Uruguay');INSERT INTO cc_country VALUES (228, 'UZB', 'Uzbekistan');INSERT INTO cc_country VALUES (229, 'VUT', 'Vanuatu');INSERT INTO cc_country VALUES (230, 'VEN', 'Venezuela');INSERT INTO cc_country VALUES (231, 'VNM', 'Vietnam');INSERT INTO cc_country VALUES (232, 'VGB', 'Virgin Islands, British');INSERT INTO cc_country VALUES (233, 'VIR', 'Virgin Islands, U.S.');INSERT INTO cc_country VALUES (234, 'WLF', 'Wallis And Futuna');INSERT INTO cc_country VALUES (235, 'EH', 'Western Sahara');INSERT INTO cc_country VALUES (236, 'YEM', 'Yemen');INSERT INTO cc_country VALUES (237, 'YUG', 'Yugoslavia');INSERT INTO cc_country VALUES (238, 'ZMB', 'Zambia');INSERT INTO cc_country VALUES (239, 'ZWE', 'Zimbabwe');INSERT INTO cc_country VALUES (240, 'ASC', 'Ascension Island');INSERT INTO cc_country VALUES (241, 'DGA', 'Diego Garcia');INSERT INTO cc_country VALUES (242, 'XNM', 'Inmarsat');INSERT INTO cc_country VALUES (243, 'TMP', 'East timor');INSERT INTO cc_country VALUES (244, 'AK', 'Alaska');INSERT INTO cc_country VALUES (245, 'HI', 'Hawaii');INSERT INTO cc_country VALUES (53, 'CIV', 'Cote d''Ivoire');---- Predictive Dialer update  database - Create database schema------ CURRENT_TIMESTAMP-- last_attempt TIMESTAMP DEFAULT 'now()' NOT NULL,  -- last_attempt TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,--CREATE TABLE cc_campaign (    id INT NOT NULL AUTO_INCREMENT,        campaign_name CHAR(50) NOT NULL,    creationdate TIMESTAMP DEFAULT 'now()' NOT NULL,    startingdate TIMESTAMP DEFAULT 'now()' NOT NULL,      expirationdate TIMESTAMP,    description MEDIUMTEXT,    id_trunk INT DEFAULT 0,    secondusedreal INT DEFAULT 0,    nb_callmade INT DEFAULT 0,