WebSVN – ALCASAR – Diff – /conf/empty-gammu-smsd-db.sql


 
-- 
 
 
-- Database for Gammu SMSD
 
 
 
 
 
 
 
 
 
 
 
 
-- 
-- In case you get errors about not supported charset, please
-- replace utf8mb4 with utf8.
 
 
 
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `gammu`
-- 
 
CREATE TABLE `gammu` (
  `Version` integer NOT NULL default '0' PRIMARY KEY
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
 
-- 
-- Dumping data for table `gammu`
-- 
 
INSERT INTO `gammu` (`Version`) VALUES (17);
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `inbox`
-- 
 
CREATE TABLE `inbox` (
  `UpdatedInDB` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `ReceivingDateTime` timestamp NOT NULL default '0000-00-00 00:00:00',
  `Text` text NOT NULL,
  `SenderNumber` varchar(20) NOT NULL default '',
  `Coding` enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression') NOT NULL default 'Default_No_Compression',
  `UDH` text NOT NULL,
  `SMSCNumber` varchar(20) NOT NULL default '',
  `Class` integer NOT NULL default '-1',
  `TextDecoded` text NOT NULL,
  `ID` integer unsigned NOT NULL auto_increment,
  `RecipientID` text NOT NULL,
  `Processed` enum('false','true') NOT NULL default 'false',
  `Status` integer NOT NULL default '-1',
  PRIMARY KEY `ID` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `outbox`
-- 
 
CREATE TABLE `outbox` (
  `UpdatedInDB` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `InsertIntoDB` timestamp NOT NULL default '0000-00-00 00:00:00',
  `SendingDateTime` timestamp NOT NULL default '0000-00-00 00:00:00',
  `SendBefore` time NOT NULL DEFAULT '23:59:59',
  `SendAfter` time NOT NULL DEFAULT '00:00:00',
  `Text` text,
  `DestinationNumber` varchar(20) NOT NULL default '',
  `Coding` enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression') NOT NULL default 'Default_No_Compression',
  `UDH` text,
  `Class` integer default '-1',
  `TextDecoded` text NOT NULL,
  `ID` integer unsigned NOT NULL auto_increment,
  `MultiPart` enum('false','true') default 'false',
  `RelativeValidity` integer default '-1',
  `SenderID` varchar(255),
  `SendingTimeOut` timestamp NULL default '0000-00-00 00:00:00',
  `DeliveryReport` enum('default','yes','no') default 'default',
  `CreatorID` text NOT NULL,
  `Retries` int(3) default 0,
  `Priority` integer default 0,
  `Status` enum('SendingOK','SendingOKNoReport','SendingError','DeliveryOK','DeliveryFailed','DeliveryPending','DeliveryUnknown','Error','Reserved') NOT NULL default 'Reserved',
  `StatusCode` integer NOT NULL default '-1',
  PRIMARY KEY `ID` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
 
CREATE INDEX outbox_date ON outbox(SendingDateTime, SendingTimeOut);
CREATE INDEX outbox_sender ON outbox(SenderID(250));
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `outbox_multipart`
-- 
 
CREATE TABLE `outbox_multipart` (
  `Text` text,
  `Coding` enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression') NOT NULL default 'Default_No_Compression',
  `UDH` text,
  `Class` integer default '-1',
  `TextDecoded` text,
  `ID` integer unsigned NOT NULL default '0',
  `SequencePosition` integer NOT NULL default '1',
  `Status` enum('SendingOK','SendingOKNoReport','SendingError','DeliveryOK','DeliveryFailed','DeliveryPending','DeliveryUnknown','Error','Reserved') NOT NULL default 'Reserved',
  `StatusCode` integer NOT NULL default '-1',
  PRIMARY KEY (`ID`, `SequencePosition`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `phones`
-- 
 
CREATE TABLE `phones` (
  `ID` text NOT NULL,
  `UpdatedInDB` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `InsertIntoDB` timestamp NOT NULL default '0000-00-00 00:00:00',
  `TimeOut` timestamp NOT NULL default '0000-00-00 00:00:00',
  `Send` enum('yes','no') NOT NULL default 'no',
  `Receive` enum('yes','no') NOT NULL default 'no',
  `IMEI` varchar(35) NOT NULL,
  `IMSI` varchar(35) NOT NULL,
  `NetCode` varchar(10) default 'ERROR',
  `NetName` varchar(35) default 'ERROR',
  `Client` text NOT NULL,
  `Battery` integer NOT NULL DEFAULT -1,
  `Signal` integer NOT NULL DEFAULT -1,
  `Sent` int NOT NULL DEFAULT 0,
  `Received` int NOT NULL DEFAULT 0,
  PRIMARY KEY (`IMEI`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
 
-- --------------------------------------------------------
 
-- 
-- Table structure for table `sentitems`
-- 
 
CREATE TABLE `sentitems` (
  `UpdatedInDB` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `InsertIntoDB` timestamp NOT NULL default '0000-00-00 00:00:00',
  `SendingDateTime` timestamp NOT NULL default '0000-00-00 00:00:00',
  `DeliveryDateTime` timestamp NULL,
  `Text` text NOT NULL,
  `DestinationNumber` varchar(20) NOT NULL default '',
  `Coding` enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression') NOT NULL default 'Default_No_Compression',
  `UDH` text NOT NULL,
  `SMSCNumber` varchar(20) NOT NULL default '',
  `Class` integer NOT NULL default '-1',
  `TextDecoded` text NOT NULL,
  `ID` integer unsigned NOT NULL default '0',
  `SenderID` varchar(255) NOT NULL,
  `SequencePosition` integer NOT NULL default '1',
  `Status` enum('SendingOK','SendingOKNoReport','SendingError','DeliveryOK','DeliveryFailed','DeliveryPending','DeliveryUnknown','Error') NOT NULL default 'SendingOK',
  `StatusError` integer NOT NULL default '-1',
  `TPMR` integer NOT NULL default '-1',
  `RelativeValidity` integer NOT NULL default '-1',
  `CreatorID` text NOT NULL,
  `StatusCode` integer NOT NULL default '-1',
  PRIMARY KEY (`ID`, `SequencePosition`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
 
CREATE INDEX sentitems_date ON sentitems(DeliveryDateTime);
CREATE INDEX sentitems_tpmr ON sentitems(TPMR);
CREATE INDEX sentitems_dest ON sentitems(DestinationNumber);
CREATE INDEX sentitems_sender ON sentitems(SenderID(250));
 
-- 
-- Triggers for setting default timestamps
-- 
 
DELIMITER //
 
CREATE TRIGGER inbox_timestamp BEFORE INSERT ON inbox
FOR EACH ROW
BEGIN
    IF NEW.ReceivingDateTime = '0000-00-00 00:00:00' THEN
        SET NEW.ReceivingDateTime = CURRENT_TIMESTAMP();
    END IF;
END;//
 
CREATE TRIGGER outbox_timestamp BEFORE INSERT ON outbox
FOR EACH ROW
BEGIN
    IF NEW.InsertIntoDB = '0000-00-00 00:00:00' THEN
        SET NEW.InsertIntoDB = CURRENT_TIMESTAMP();
    END IF;
    IF NEW.SendingDateTime = '0000-00-00 00:00:00' THEN
        SET NEW.SendingDateTime = CURRENT_TIMESTAMP();
    END IF;
    IF NEW.SendingTimeOut = '0000-00-00 00:00:00' THEN
        SET NEW.SendingTimeOut = CURRENT_TIMESTAMP();
    END IF;
END;//
 
CREATE TRIGGER phones_timestamp BEFORE INSERT ON phones
FOR EACH ROW
BEGIN
    IF NEW.InsertIntoDB = '0000-00-00 00:00:00' THEN
        SET NEW.InsertIntoDB = CURRENT_TIMESTAMP();
    END IF;
    IF NEW.TimeOut = '0000-00-00 00:00:00' THEN
        SET NEW.TimeOut = CURRENT_TIMESTAMP();
    END IF;
END;//
 
CREATE TRIGGER sentitems_timestamp BEFORE INSERT ON sentitems
FOR EACH ROW
BEGIN
    IF NEW.InsertIntoDB = '0000-00-00 00:00:00' THEN
        SET NEW.InsertIntoDB = CURRENT_TIMESTAMP();
    END IF;
    IF NEW.SendingDateTime = '0000-00-00 00:00:00' THEN
        SET NEW.SendingDateTime = CURRENT_TIMESTAMP();
    END IF;
END;//
 
DELIMITER ;
 
 
----------------------------------------
-----   ALCASAR specific table  --------
----------------------------------------
--
-- Table structure for table `SMS_ban_perm`
--
 
CREATE TABLE IF NOT EXISTS `SMS_ban_perm` (
  `SenderNumber` varchar(20) CHARACTER SET utf8 NOT NULL,
  `Expiration` varchar(255) CHARACTER SET utf8 NOT NULL,
  `Perm` int(11) NOT NULL,
  `date_add` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`SenderNumber`)
) ENGINE=MyISAM DEFAULT CHARSET=utf32;
 
--
-- Table structure for table `SMS_ban_temp`
--
 
CREATE TABLE IF NOT EXISTS `SMS_ban_temp` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `SenderNumber` varchar(20) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 
--
-- Table structure for table `SMS_country`
--
 
CREATE TABLE IF NOT EXISTS `SMS_country` (
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `id` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `status` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
--
-- Dumping data for table `SMS_country`
--
 
INSERT INTO `SMS_country` (`name`, `id`, `status`) VALUES
('Afghanistan', '+93', 0),
('Afrique du Sud', '+27', 0),
('Albanie', '+355', 0),
('Algerie', '+213', 0),
('Allemagne', '+49', 0),
('Andorre', '+376', 0),
('Angleterre', '+44', 0),
('Angola', '+244', 0),
('Anguilla', '+1264', 0),
('Antigua et Barbuda', '+1268', 0),
('Arabie Saoudite', '+966', 0),
('Argentine', '+54', 0),
('Armenie', '+374', 0),
('Aruba', '+297', 0),
('Australie', '+61', 0),
('Autriche', '+43', 0),
('Azerbaidjan', '+994', 0),
('Bahamas', '+1242', 0),
('Bahrein', '+973', 0),
('Bangladesh', '+880', 0),
('Barbade', '+1246', 0),
('Belgique', '+32', 0),
('Benin', '+229', 0),
('Bermudes', '+1441', 0),
('Bhoutan', '+975', 0),
('Bielorussie', '+375', 0),
('Birmanie', '+95', 0),
('Bolivie', '+591', 0),
('Bonaire', '+599', 0),
('Bosnie', '+387', 0),
('Botswana', '+267', 0),
('Bresil', '+55', 0),
('Brunei', '+673', 0),
('Bulgarie', '+359', 0),
('Burkina Faso', '+226', 0),
('Burundi', '+257', 0),
('Cambodge', '+855', 0),
('Cameroun', '+237', 0),
('Canada', '+1', 0),
('Cap Vert', '+238', 0),
('Chili', '+56', 0),
('Chine', '+86', 0),
('Chypre', '+357', 0),
('Colombie', '+57', 0),
('Comores', '+269', 0),
('Congo RDC', '+243', 0),
('Congo RPC', '+242', 0),
('Coree du Nord', '+850', 0),
('Coree du Sud', '+82', 0),
('Costa Rica 1', '+501', 0),
('Costa Rica 2', '+506', 0),
('Cote d Ivoire', '+225', 0),
('Croatie', '+385', 0),
('Cuba', '+53', 0),
('Curacao', '+599', 0),
('Danemark', '+45', 0),
('Djibouti', '+253', 0),
('Dominique', '+1767', 0),
('Egypte', '+20', 0),
('El Salvador', '+503', 0),
('Emirats Arabes Unis', '+971', 0),
('Equateur', '+593', 0),
('Erythree', '+291', 0),
('Espagne', '+34', 0),
('Estonie', '+372', 0),
('Etats-Unis', '+1', 0),
('Ethiopie', '+251', 0),
('Falklands Malouines', '+500', 0),
('Finlande', '+358', 0),
('France', '+33', 1),
('Gabon', '+241', 0),
('Gambie', '+220', 0),
('Georgie', '+995', 0),
('Ghana', '+233', 0),
('Gibraltar', '+350', 0),
('Grece', '+30', 0),
('Grenade', '+1473', 0),
('Groenland', '+299', 0),
('Guadeloupe', '+590', 0),
('Guatemala', '+502', 0),
('Guernesey', '+441481', 0),
('Guinee', '+224', 0),
('Guinee Bissau', '+245', 0),
('Guinee Equatoriale', '+240', 0),
('Guyana', '+5921', 0),
('Guyane France', '+594', 0),
('Haiti', '+509', 0),
('Herm', '+441481', 0),
('Honduras', '+504', 0),
('Hong Kong', '+852', 0),
('Hongrie', '+36', 0),
('Ile de Ascension', '+247', 0),
('Ile Maurice', '+230', 0),
('Iles Cayman', '+1345', 0),
('Iles Christmas', '+61', 0),
('Iles Coco', '+61', 0),
('Iles Cook', '+682', 0),
('Iles Fidji', '+679', 0),
('Iles Mariannes', '+1670', 0),
('Iles Marshall', '+692', 0),
('Iles Salomon', '+677', 0),
('Iles Vierges GB', '+1284', 0),
('Iles Vierges USA', '+1340', 0),
('Inde', '+91', 0),
('Indonesie', '+62', 0),
('Irak', '+964', 0),
('Iran', '+98', 0),
('Irlande', '+353', 0),
('Islande', '+354', 0),
('Israel', '+972', 0),
('Italie', '+39', 0),
('Jamaique', '+1876', 0),
('Japon', '+81', 0),
('Jersey', '+441534', 0),
('Jordanie', '+962', 0),
('Kazakhstan', '+7', 0),
('Kenya', '+254', 0),
('Kirghizistan', '+996', 0),
('Kiribati', '+686', 0),
('Koweit', '+965', 0),
('Laos', '+856', 0),
('Lesotho', '+266', 0),
('Lettonie', '+371', 0),
('Liban', '+961', 0),
('Libye', '+218', 0),
('Liechtenstein', '+423', 0),
('Lituanie', '+370', 0),
('Luxembourg', '+352', 0),
('Macao', '+853', 0),
('Macedoine', '+389', 0),
('Madagascar', '+261', 0),
('Malaisie', '+60', 0),
('Malawi', '+265', 0),
('Maldives', '+960', 0),
('Mali', '+223', 0),
('Malte', '+356', 0),
('Maroc', '+212', 0),
('Martinique', '+596', 0),
('Mauritanie', '+222', 0),
('Mayotte', '+269', 0),
('Mexique', '+52', 0),
('Micronesie', '+691', 0),
('Moldavie', '+373', 0),
('Monaco', '+377', 0),
('Mongolie', '+9761', 0),
('Montserrat', '+1664', 0),
('Mozambique', '+258', 0),
('Namibie', '+264', 0),
('Nauru', '+674', 0),
('Nepal', '+977', 0),
('Nicaragua', '+505', 0),
('Niger', '+227', 0),
('Nigeria', '+2349', 0),
('Norvege', '+47', 0),
('Nouvelle Caledonie', '+687', 0),
('Nouvelle Zelande', '+64', 0),
('Oman', '+968', 0),
('Ouganda', '+2560', 0),
('Ouzbekistan', '+998', 0),
('Pakistan', '+92', 0),
('Palau', '+680', 0),
('Palestine', '+970', 0),
('Panama', '+507', 0),
('Papouasie Nouvelle Guinee', '+675', 0),
('Paraguay', '+595', 0),
('Pays-Bas', '+31', 0),
('Perou', '+51', 0),
('Philippines', '+63', 0),
('Pologne', '+48', 0),
('Polynesie France', '+689', 0),
('Porto Rico', '+1787', 0),
('Portugal', '+351', 0),
('Qatar', '+974', 0),
('Republique Centrafricaine', '+236', 0),
('Republique Dominicaine', '+1809', 0),
('Republique Tcheque', '+420', 0),
('Reunion', '+262', 0),
('Roumanie', '+40', 0),
('Royaume Uni', '+44', 0),
('Russie', '+7', 0),
('Rwanda', '+250', 0),
('Saint Marin (Rep.)', '+378', 0),
('Sainte Lucie', '+1758', 0),
('Samoa occidental', '+685', 0),
('Sao Tome et Principe', '+239', 0),
('Senegal', '+221', 0),
('Serbie', '+381', 0),
('Sercq', '+441481', 0),
('Seychelles', '+248', 0),
('Sierra Leone', '+232', 0),
('Singapour', '+65', 0),
('Slovaquie', '+421', 0),
('Slovenie', '+386', 0),
('Somalie', '+252', 0),
('Soudan', '+249', 0),
('Sri Lanka', '+94', 0),
('St Kitts', '+1869', 0),
('St Pierre et Miquelon', '+508', 0),
('St Vincent et les Grenadines', '+1784', 0),
('Suede', '+46', 0),
('Suisse', '+41', 0),
('Surinam', '+597', 0),
('Swaziland', '+268', 0),
('Syrie', '+963', 0),
('Tadjikistan', '+992', 0),
('Taiwan', '+886', 0),
('Tanzanie', '+255', 0),
('Tchad', '+235', 0),
('Thailande', '+661', 0),
('Togo', '+228', 0),
('Tonga', '+676', 0),
('Trinidad et Tobago', '+1868', 0),
('Tunisie', '+216', 0),
('Turkmenistan', '+993', 0),
('Turks et Caicos', '+1649', 0),
('Turquie', '+90', 0),
('Tuvalu', '+688', 0),
('Ukraine', '+380', 0),
('Uruguay', '+598', 0),
('Vanuatu', '+678', 0),
('Vatican', '+379', 0),
('Venezuela', '+58', 0),
('Vietnam', '+84', 0),
('Wallis et Futuna', '+681', 0),
('Yemen', '+967', 0),
('Zambie', '+260', 0),
('Zimbabwe', '+263', 0),
('FILTRAGE', 'fr', 0);
 
 
 
 
 

Rev 2063	Rev 2540
1	`-- MySQL dump 10.15 Distrib 10.0.23-MariaDB, for Linux (x86_64)`	-
2	`--`	1	`--`
3	`-- Host: localhost Database: gammu`	-
4	`-- ------------------------------------------------------`	-
5	`-- Server version 10.0.23-MariaDB`	2	`-- Database for Gammu SMSD`
6		-
7	`/!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT /;`	-
8	`/!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS /;`	-
9	`/!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION /;`	-
10	`/!40101 SET NAMES utf8 /;`	-
11	`/!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE /;`	-
12	`/!40103 SET TIME_ZONE='+00:00' /;`	-
13	`/!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 /;`	-
14	`/!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 /;`	-
15	`/!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' /;`	-
16	`/!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 /;`	-
17		-
18	`--`	3	`--`
19	-- Table structure for table `daemons`	4	`-- In case you get errors about not supported charset, please`
20	`--`	5	`-- replace utf8mb4 with utf8.`
21		6
22	CREATE TABLE `daemons` (	-
23	`Start` text NOT NULL,	-
24	`Info` text NOT NULL	-
25	`) ENGINE=MyISAM DEFAULT CHARSET=utf8;`	7	`-- --------------------------------------------------------`
26		8
27	`--`	9	`--`
28	-- Table structure for table `gammu`	10	-- Table structure for table `gammu`
29	`--`	11	`--`
30		12
31	CREATE TABLE `gammu` (	13	CREATE TABLE `gammu` (
32	`Version` integer NOT NULL default '0'	14	`Version` integer NOT NULL default '0' PRIMARY KEY
33	`) ENGINE=MyISAM DEFAULT CHARSET=utf8;`	15	`) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;`
34		16
35	`--`	17	`--`
36	-- Dumping data for table `gammu`	18	-- Dumping data for table `gammu`
37	`--`	19	`--`
38		20
39	INSERT INTO `gammu` (`Version`) VALUES (14);	21	INSERT INTO `gammu` (`Version`) VALUES (17);
-		22
-		23	`-- --------------------------------------------------------`
40		24
41	`--`	25	`--`
42	-- Table structure for table `inbox`	26	-- Table structure for table `inbox`
43	`--`	27	`--`
44		28
45	CREATE TABLE `inbox` (	29	CREATE TABLE `inbox` (
46	`UpdatedInDB` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,	30	`UpdatedInDB` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
47	`ReceivingDateTime` timestamp NOT NULL default '0000-00-00 00:00:00',	31	`ReceivingDateTime` timestamp NOT NULL default '0000-00-00 00:00:00',
48	`Text` text NOT NULL,	32	`Text` text NOT NULL,
49	`SenderNumber` varchar(20) NOT NULL default '',	33	`SenderNumber` varchar(20) NOT NULL default '',
50	`Coding` enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression') NOT NULL default 'Default_No_Compression',	34	`Coding` enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression') NOT NULL default 'Default_No_Compression',
51	`UDH` text NOT NULL,	35	`UDH` text NOT NULL,
52	`SMSCNumber` varchar(20) NOT NULL default '',	36	`SMSCNumber` varchar(20) NOT NULL default '',
53	`Class` integer NOT NULL default '-1',	37	`Class` integer NOT NULL default '-1',
54	`TextDecoded` text NOT NULL default '',	38	`TextDecoded` text NOT NULL,
55	`ID` integer unsigned NOT NULL auto_increment,	39	`ID` integer unsigned NOT NULL auto_increment,
56	`RecipientID` text NOT NULL,	40	`RecipientID` text NOT NULL,
57	`Processed` enum('false','true') NOT NULL default 'false',	41	`Processed` enum('false','true') NOT NULL default 'false',
-		42	`Status` integer NOT NULL default '-1',
58	PRIMARY KEY `ID` (`ID`)	43	PRIMARY KEY `ID` (`ID`)
59	`) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;`	44	`) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;`
-		45
-		46	`-- --------------------------------------------------------`
60		47
61	`--`	48	`--`
62	-- Table structure for table `outbox`	49	-- Table structure for table `outbox`
63	`--`	50	`--`
64		51
65	CREATE TABLE `outbox` (	52	CREATE TABLE `outbox` (
66	`UpdatedInDB` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,	53	`UpdatedInDB` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
67	`InsertIntoDB` timestamp NOT NULL default '0000-00-00 00:00:00',	54	`InsertIntoDB` timestamp NOT NULL default '0000-00-00 00:00:00',
68	`SendingDateTime` timestamp NOT NULL default '0000-00-00 00:00:00',	55	`SendingDateTime` timestamp NOT NULL default '0000-00-00 00:00:00',
69	`SendBefore` time NOT NULL DEFAULT '23:59:59',	56	`SendBefore` time NOT NULL DEFAULT '23:59:59',
70	`SendAfter` time NOT NULL DEFAULT '00:00:00',	57	`SendAfter` time NOT NULL DEFAULT '00:00:00',
71	`Text` text,	58	`Text` text,
72	`DestinationNumber` varchar(20) NOT NULL default '',	59	`DestinationNumber` varchar(20) NOT NULL default '',
73	`Coding` enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression') NOT NULL default 'Default_No_Compression',	60	`Coding` enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression') NOT NULL default 'Default_No_Compression',
74	`UDH` text,	61	`UDH` text,
75	`Class` integer default '-1',	62	`Class` integer default '-1',
76	`TextDecoded` text NOT NULL default '',	63	`TextDecoded` text NOT NULL,
77	`ID` integer unsigned NOT NULL auto_increment,	64	`ID` integer unsigned NOT NULL auto_increment,
78	`MultiPart` enum('false','true') default 'false',	65	`MultiPart` enum('false','true') default 'false',
79	`RelativeValidity` integer default '-1',	66	`RelativeValidity` integer default '-1',
80	`SenderID` varchar(255),	67	`SenderID` varchar(255),
81	`SendingTimeOut` timestamp NULL default '0000-00-00 00:00:00',	68	`SendingTimeOut` timestamp NULL default '0000-00-00 00:00:00',
82	`DeliveryReport` enum('default','yes','no') default 'default',	69	`DeliveryReport` enum('default','yes','no') default 'default',
83	`CreatorID` text NOT NULL,	70	`CreatorID` text NOT NULL,
-		71	`Retries` int(3) default 0,
-		72	`Priority` integer default 0,
-		73	`Status` enum('SendingOK','SendingOKNoReport','SendingError','DeliveryOK','DeliveryFailed','DeliveryPending','DeliveryUnknown','Error','Reserved') NOT NULL default 'Reserved',
-		74	`StatusCode` integer NOT NULL default '-1',
84	PRIMARY KEY `ID` (`ID`)	75	PRIMARY KEY `ID` (`ID`)
85	`) ENGINE=MyISAM DEFAULT CHARSET=utf8;`	76	`) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;`
86		77
87	`CREATE INDEX outbox_date ON outbox(SendingDateTime, SendingTimeOut);`	78	`CREATE INDEX outbox_date ON outbox(SendingDateTime, SendingTimeOut);`
88	`CREATE INDEX outbox_sender ON outbox(SenderID);`	79	`CREATE INDEX outbox_sender ON outbox(SenderID(250));`
-		80
-		81	`-- --------------------------------------------------------`
89		82
90	`--`	83	`--`
91	-- Table structure for table `outbox_multipart`	84	-- Table structure for table `outbox_multipart`
92	`--`	85	`--`
93		86
94	CREATE TABLE `outbox_multipart` (	87	CREATE TABLE `outbox_multipart` (
95	`Text` text,	88	`Text` text,
96	`Coding` enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression') NOT NULL default 'Default_No_Compression',	89	`Coding` enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression') NOT NULL default 'Default_No_Compression',
97	`UDH` text,	90	`UDH` text,
98	`Class` integer default '-1',	91	`Class` integer default '-1',
99	`TextDecoded` text default NULL,	92	`TextDecoded` text,
100	`ID` integer unsigned NOT NULL default '0',	93	`ID` integer unsigned NOT NULL default '0',
101	`SequencePosition` integer NOT NULL default '1',	94	`SequencePosition` integer NOT NULL default '1',
-		95	`Status` enum('SendingOK','SendingOKNoReport','SendingError','DeliveryOK','DeliveryFailed','DeliveryPending','DeliveryUnknown','Error','Reserved') NOT NULL default 'Reserved',
-		96	`StatusCode` integer NOT NULL default '-1',
102	PRIMARY KEY (`ID`, `SequencePosition`)	97	PRIMARY KEY (`ID`, `SequencePosition`)
103	`) ENGINE=MyISAM DEFAULT CHARSET=utf8;`	98	`) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;`
104		-
105	`--`	-
106	-- Table structure for table `pbk`	-
107	`--`	-
108		-
109	CREATE TABLE `pbk` (	-
110	`ID` integer NOT NULL auto_increment,	-
111	`GroupID` integer NOT NULL default '-1',	-
112	`Name` text NOT NULL,	-
113	`Number` text NOT NULL,	-
114	PRIMARY KEY (`ID`)	-
115	`) ENGINE=MyISAM DEFAULT CHARSET=utf8;`	-
116		-
117	`--`	-
118	-- Table structure for table `pbk_groups`	-
119	`--`	-
120		99
121	CREATE TABLE `pbk_groups` (	-
122	`Name` text NOT NULL,	-
123	`ID` integer NOT NULL auto_increment,	-
124	PRIMARY KEY `ID` (`ID`)	-
125	`) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;`	100	`-- --------------------------------------------------------`
126		101
127	`--`	102	`--`
128	-- Table structure for table `phones`	103	-- Table structure for table `phones`
129	`--`	104	`--`
130		105
131	CREATE TABLE `phones` (	106	CREATE TABLE `phones` (
132	`ID` text NOT NULL,	107	`ID` text NOT NULL,
133	`UpdatedInDB` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,	108	`UpdatedInDB` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
134	`InsertIntoDB` timestamp NOT NULL default '0000-00-00 00:00:00',	109	`InsertIntoDB` timestamp NOT NULL default '0000-00-00 00:00:00',
135	`TimeOut` timestamp NOT NULL default '0000-00-00 00:00:00',	110	`TimeOut` timestamp NOT NULL default '0000-00-00 00:00:00',
136	`Send` enum('yes','no') NOT NULL default 'no',	111	`Send` enum('yes','no') NOT NULL default 'no',
137	`Receive` enum('yes','no') NOT NULL default 'no',	112	`Receive` enum('yes','no') NOT NULL default 'no',
138	`IMEI` varchar(35) NOT NULL,	113	`IMEI` varchar(35) NOT NULL,
-		114	`IMSI` varchar(35) NOT NULL,
139	`NetCode` varchar(10) default 'ERROR',	115	`NetCode` varchar(10) default 'ERROR',
140	`NetName` varchar(35) default 'ERROR',	116	`NetName` varchar(35) default 'ERROR',
141	`Client` text NOT NULL,	117	`Client` text NOT NULL,
142	`Battery` integer NOT NULL DEFAULT -1,	118	`Battery` integer NOT NULL DEFAULT -1,
143	`Signal` integer NOT NULL DEFAULT -1,	119	`Signal` integer NOT NULL DEFAULT -1,
144	`Sent` int NOT NULL DEFAULT 0,	120	`Sent` int NOT NULL DEFAULT 0,
145	`Received` int NOT NULL DEFAULT 0,	121	`Received` int NOT NULL DEFAULT 0,
146	PRIMARY KEY (`IMEI`)	122	PRIMARY KEY (`IMEI`)
147	`) ENGINE=MyISAM DEFAULT CHARSET=utf8;`	123	`) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;`
-		124
-		125	`-- --------------------------------------------------------`
148		126
149	`--`	127	`--`
150	-- Table structure for table `sentitems`	128	-- Table structure for table `sentitems`
151	`--`	129	`--`
152		130
153	CREATE TABLE `sentitems` (	131	CREATE TABLE `sentitems` (
154	`UpdatedInDB` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,	132	`UpdatedInDB` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
155	`InsertIntoDB` timestamp NOT NULL default '0000-00-00 00:00:00',	133	`InsertIntoDB` timestamp NOT NULL default '0000-00-00 00:00:00',
156	`SendingDateTime` timestamp NOT NULL default '0000-00-00 00:00:00',	134	`SendingDateTime` timestamp NOT NULL default '0000-00-00 00:00:00',
157	`DeliveryDateTime` timestamp NULL,	135	`DeliveryDateTime` timestamp NULL,
158	`Text` text NOT NULL,	136	`Text` text NOT NULL,
159	`DestinationNumber` varchar(20) NOT NULL default '',	137	`DestinationNumber` varchar(20) NOT NULL default '',
160	`Coding` enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression') NOT NULL default 'Default_No_Compression',	138	`Coding` enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression') NOT NULL default 'Default_No_Compression',
161	`UDH` text NOT NULL,	139	`UDH` text NOT NULL,
162	`SMSCNumber` varchar(20) NOT NULL default '',	140	`SMSCNumber` varchar(20) NOT NULL default '',
163	`Class` integer NOT NULL default '-1',	141	`Class` integer NOT NULL default '-1',
164	`TextDecoded` text NOT NULL default '',	142	`TextDecoded` text NOT NULL,
165	`ID` integer unsigned NOT NULL default '0',	143	`ID` integer unsigned NOT NULL default '0',
166	`SenderID` varchar(255) NOT NULL,	144	`SenderID` varchar(255) NOT NULL,
167	`SequencePosition` integer NOT NULL default '1',	145	`SequencePosition` integer NOT NULL default '1',
168	`Status` enum('SendingOK','SendingOKNoReport','SendingError','DeliveryOK','DeliveryFailed','DeliveryPending','DeliveryUnknown','Error') NOT NULL default 'SendingOK',	146	`Status` enum('SendingOK','SendingOKNoReport','SendingError','DeliveryOK','DeliveryFailed','DeliveryPending','DeliveryUnknown','Error') NOT NULL default 'SendingOK',
169	`StatusError` integer NOT NULL default '-1',	147	`StatusError` integer NOT NULL default '-1',
170	`TPMR` integer NOT NULL default '-1',	148	`TPMR` integer NOT NULL default '-1',
171	`RelativeValidity` integer NOT NULL default '-1',	149	`RelativeValidity` integer NOT NULL default '-1',
172	`CreatorID` text NOT NULL,	150	`CreatorID` text NOT NULL,
-		151	`StatusCode` integer NOT NULL default '-1',
173	PRIMARY KEY (`ID`, `SequencePosition`)	152	PRIMARY KEY (`ID`, `SequencePosition`)
174	`) ENGINE=MyISAM DEFAULT CHARSET=utf8;`	153	`) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;`
175		154
176	`CREATE INDEX sentitems_date ON sentitems(DeliveryDateTime);`	155	`CREATE INDEX sentitems_date ON sentitems(DeliveryDateTime);`
177	`CREATE INDEX sentitems_tpmr ON sentitems(TPMR);`	156	`CREATE INDEX sentitems_tpmr ON sentitems(TPMR);`
178	`CREATE INDEX sentitems_dest ON sentitems(DestinationNumber);`	157	`CREATE INDEX sentitems_dest ON sentitems(DestinationNumber);`
179	`CREATE INDEX sentitems_sender ON sentitems(SenderID);`	158	`CREATE INDEX sentitems_sender ON sentitems(SenderID(250));`
180		159
181	`--`	160	`--`
182	`-- Triggers for setting default timestamps`	161	`-- Triggers for setting default timestamps`
183	`--`	162	`--`
184		163
185	`DELIMITER //`	164	`DELIMITER //`
186		165
187	`CREATE TRIGGER inbox_timestamp BEFORE INSERT ON inbox`	166	`CREATE TRIGGER inbox_timestamp BEFORE INSERT ON inbox`
188	`FOR EACH ROW`	167	`FOR EACH ROW`
189	`BEGIN`	168	`BEGIN`
190	`IF NEW.ReceivingDateTime = '0000-00-00 00:00:00' THEN`	169	`IF NEW.ReceivingDateTime = '0000-00-00 00:00:00' THEN`
191	`SET NEW.ReceivingDateTime = CURRENT_TIMESTAMP();`	170	`SET NEW.ReceivingDateTime = CURRENT_TIMESTAMP();`
192	`END IF;`	171	`END IF;`
193	`END;//`	172	`END;//`
194		173
195	`CREATE TRIGGER outbox_timestamp BEFORE INSERT ON outbox`	174	`CREATE TRIGGER outbox_timestamp BEFORE INSERT ON outbox`
196	`FOR EACH ROW`	175	`FOR EACH ROW`
197	`BEGIN`	176	`BEGIN`
198	`IF NEW.InsertIntoDB = '0000-00-00 00:00:00' THEN`	177	`IF NEW.InsertIntoDB = '0000-00-00 00:00:00' THEN`
199	`SET NEW.InsertIntoDB = CURRENT_TIMESTAMP();`	178	`SET NEW.InsertIntoDB = CURRENT_TIMESTAMP();`
200	`END IF;`	179	`END IF;`
201	`IF NEW.SendingDateTime = '0000-00-00 00:00:00' THEN`	180	`IF NEW.SendingDateTime = '0000-00-00 00:00:00' THEN`
202	`SET NEW.SendingDateTime = CURRENT_TIMESTAMP();`	181	`SET NEW.SendingDateTime = CURRENT_TIMESTAMP();`
203	`END IF;`	182	`END IF;`
204	`IF NEW.SendingTimeOut = '0000-00-00 00:00:00' THEN`	183	`IF NEW.SendingTimeOut = '0000-00-00 00:00:00' THEN`
205	`SET NEW.SendingTimeOut = CURRENT_TIMESTAMP();`	184	`SET NEW.SendingTimeOut = CURRENT_TIMESTAMP();`
206	`END IF;`	185	`END IF;`
207	`END;//`	186	`END;//`
208		187
209	`CREATE TRIGGER phones_timestamp BEFORE INSERT ON phones`	188	`CREATE TRIGGER phones_timestamp BEFORE INSERT ON phones`
210	`FOR EACH ROW`	189	`FOR EACH ROW`
211	`BEGIN`	190	`BEGIN`
212	`IF NEW.InsertIntoDB = '0000-00-00 00:00:00' THEN`	191	`IF NEW.InsertIntoDB = '0000-00-00 00:00:00' THEN`
213	`SET NEW.InsertIntoDB = CURRENT_TIMESTAMP();`	192	`SET NEW.InsertIntoDB = CURRENT_TIMESTAMP();`
214	`END IF;`	193	`END IF;`
215	`IF NEW.TimeOut = '0000-00-00 00:00:00' THEN`	194	`IF NEW.TimeOut = '0000-00-00 00:00:00' THEN`
216	`SET NEW.TimeOut = CURRENT_TIMESTAMP();`	195	`SET NEW.TimeOut = CURRENT_TIMESTAMP();`
217	`END IF;`	196	`END IF;`
218	`END;//`	197	`END;//`
219		198
220	`CREATE TRIGGER sentitems_timestamp BEFORE INSERT ON sentitems`	199	`CREATE TRIGGER sentitems_timestamp BEFORE INSERT ON sentitems`
221	`FOR EACH ROW`	200	`FOR EACH ROW`
222	`BEGIN`	201	`BEGIN`
223	`IF NEW.InsertIntoDB = '0000-00-00 00:00:00' THEN`	202	`IF NEW.InsertIntoDB = '0000-00-00 00:00:00' THEN`
224	`SET NEW.InsertIntoDB = CURRENT_TIMESTAMP();`	203	`SET NEW.InsertIntoDB = CURRENT_TIMESTAMP();`
225	`END IF;`	204	`END IF;`
226	`IF NEW.SendingDateTime = '0000-00-00 00:00:00' THEN`	205	`IF NEW.SendingDateTime = '0000-00-00 00:00:00' THEN`
227	`SET NEW.SendingDateTime = CURRENT_TIMESTAMP();`	206	`SET NEW.SendingDateTime = CURRENT_TIMESTAMP();`
228	`END IF;`	207	`END IF;`
229	`END;//`	208	`END;//`
230		209
231	`DELIMITER ;`	210	`DELIMITER ;`
232		211
233		212
234	`----------------------------------------`	213	`----------------------------------------`
235	`----- ALCASAR specific table --------`	214	`----- ALCASAR specific table --------`
236	`----------------------------------------`	215	`----------------------------------------`
237	`--`	216	`--`
238	-- Table structure for table `SMS_ban_perm`	217	-- Table structure for table `SMS_ban_perm`
239	`--`	218	`--`
240		219
241	CREATE TABLE IF NOT EXISTS `SMS_ban_perm` (	220	CREATE TABLE IF NOT EXISTS `SMS_ban_perm` (
242	`SenderNumber` varchar(20) CHARACTER SET utf8 NOT NULL,	221	`SenderNumber` varchar(20) CHARACTER SET utf8 NOT NULL,
243	`Expiration` varchar(255) CHARACTER SET utf8 NOT NULL,	222	`Expiration` varchar(255) CHARACTER SET utf8 NOT NULL,
244	`Perm` int(11) NOT NULL,	223	`Perm` int(11) NOT NULL,
245	`date_add` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,	224	`date_add` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
246	PRIMARY KEY (`SenderNumber`)	225	PRIMARY KEY (`SenderNumber`)
247	`) ENGINE=MyISAM DEFAULT CHARSET=utf32;`	226	`) ENGINE=MyISAM DEFAULT CHARSET=utf32;`
248		227
249	`--`	228	`--`
250	-- Table structure for table `SMS_ban_temp`	229	-- Table structure for table `SMS_ban_temp`
251	`--`	230	`--`
252		231
253	CREATE TABLE IF NOT EXISTS `SMS_ban_temp` (	232	CREATE TABLE IF NOT EXISTS `SMS_ban_temp` (
254	`ID` int(11) NOT NULL AUTO_INCREMENT,	233	`ID` int(11) NOT NULL AUTO_INCREMENT,
255	`SenderNumber` varchar(20) NOT NULL,	234	`SenderNumber` varchar(20) NOT NULL,
256	PRIMARY KEY (`ID`)	235	PRIMARY KEY (`ID`)
257	`) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;`	236	`) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;`
258		237
259	`--`	238	`--`
260	-- Table structure for table `SMS_country`	239	-- Table structure for table `SMS_country`
261	`--`	240	`--`
262		241
263	CREATE TABLE IF NOT EXISTS `SMS_country` (	242	CREATE TABLE IF NOT EXISTS `SMS_country` (
264	`name` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,	243	`name` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
265	`id` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,	244	`id` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
266	`status` int(1) NOT NULL DEFAULT '0',	245	`status` int(1) NOT NULL DEFAULT '0',
267	PRIMARY KEY (`name`)	246	PRIMARY KEY (`name`)
268	`) ENGINE=MyISAM DEFAULT CHARSET=utf8;`	247	`) ENGINE=MyISAM DEFAULT CHARSET=utf8;`
269		248
270	`--`	249	`--`
271	-- Dumping data for table `SMS_country`	250	-- Dumping data for table `SMS_country`
272	`--`	251	`--`
273		252
274	INSERT INTO `SMS_country` (`name`, `id`, `status`) VALUES	253	INSERT INTO `SMS_country` (`name`, `id`, `status`) VALUES
275	`('Afghanistan', '+93', 0),`	254	`('Afghanistan', '+93', 0),`
276	`('Afrique du Sud', '+27', 0),`	255	`('Afrique du Sud', '+27', 0),`
277	`('Albanie', '+355', 0),`	256	`('Albanie', '+355', 0),`
278	`('Algerie', '+213', 0),`	257	`('Algerie', '+213', 0),`
279	`('Allemagne', '+49', 0),`	258	`('Allemagne', '+49', 0),`
280	`('Andorre', '+376', 0),`	259	`('Andorre', '+376', 0),`
281	`('Angleterre', '+44', 0),`	260	`('Angleterre', '+44', 0),`
282	`('Angola', '+244', 0),`	261	`('Angola', '+244', 0),`
283	`('Anguilla', '+1264', 0),`	262	`('Anguilla', '+1264', 0),`
284	`('Antigua et Barbuda', '+1268', 0),`	263	`('Antigua et Barbuda', '+1268', 0),`
285	`('Arabie Saoudite', '+966', 0),`	264	`('Arabie Saoudite', '+966', 0),`
286	`('Argentine', '+54', 0),`	265	`('Argentine', '+54', 0),`
287	`('Armenie', '+374', 0),`	266	`('Armenie', '+374', 0),`
288	`('Aruba', '+297', 0),`	267	`('Aruba', '+297', 0),`
289	`('Australie', '+61', 0),`	268	`('Australie', '+61', 0),`
290	`('Autriche', '+43', 0),`	269	`('Autriche', '+43', 0),`
291	`('Azerbaidjan', '+994', 0),`	270	`('Azerbaidjan', '+994', 0),`
292	`('Bahamas', '+1242', 0),`	271	`('Bahamas', '+1242', 0),`
293	`('Bahrein', '+973', 0),`	272	`('Bahrein', '+973', 0),`
294	`('Bangladesh', '+880', 0),`	273	`('Bangladesh', '+880', 0),`
295	`('Barbade', '+1246', 0),`	274	`('Barbade', '+1246', 0),`
296	`('Belgique', '+32', 0),`	275	`('Belgique', '+32', 0),`
297	`('Benin', '+229', 0),`	276	`('Benin', '+229', 0),`
298	`('Bermudes', '+1441', 0),`	277	`('Bermudes', '+1441', 0),`
299	`('Bhoutan', '+975', 0),`	278	`('Bhoutan', '+975', 0),`
300	`('Bielorussie', '+375', 0),`	279	`('Bielorussie', '+375', 0),`
301	`('Birmanie', '+95', 0),`	280	`('Birmanie', '+95', 0),`
302	`('Bolivie', '+591', 0),`	281	`('Bolivie', '+591', 0),`
303	`('Bonaire', '+599', 0),`	282	`('Bonaire', '+599', 0),`
304	`('Bosnie', '+387', 0),`	283	`('Bosnie', '+387', 0),`
305	`('Botswana', '+267', 0),`	284	`('Botswana', '+267', 0),`
306	`('Bresil', '+55', 0),`	285	`('Bresil', '+55', 0),`
307	`('Brunei', '+673', 0),`	286	`('Brunei', '+673', 0),`
308	`('Bulgarie', '+359', 0),`	287	`('Bulgarie', '+359', 0),`
309	`('Burkina Faso', '+226', 0),`	288	`('Burkina Faso', '+226', 0),`
310	`('Burundi', '+257', 0),`	289	`('Burundi', '+257', 0),`
311	`('Cambodge', '+855', 0),`	290	`('Cambodge', '+855', 0),`
312	`('Cameroun', '+237', 0),`	291	`('Cameroun', '+237', 0),`
313	`('Canada', '+1', 0),`	292	`('Canada', '+1', 0),`
314	`('Cap Vert', '+238', 0),`	293	`('Cap Vert', '+238', 0),`
315	`('Chili', '+56', 0),`	294	`('Chili', '+56', 0),`
316	`('Chine', '+86', 0),`	295	`('Chine', '+86', 0),`
317	`('Chypre', '+357', 0),`	296	`('Chypre', '+357', 0),`
318	`('Colombie', '+57', 0),`	297	`('Colombie', '+57', 0),`
319	`('Comores', '+269', 0),`	298	`('Comores', '+269', 0),`
320	`('Congo RDC', '+243', 0),`	299	`('Congo RDC', '+243', 0),`
321	`('Congo RPC', '+242', 0),`	300	`('Congo RPC', '+242', 0),`
322	`('Coree du Nord', '+850', 0),`	301	`('Coree du Nord', '+850', 0),`
323	`('Coree du Sud', '+82', 0),`	302	`('Coree du Sud', '+82', 0),`
324	`('Costa Rica 1', '+501', 0),`	303	`('Costa Rica 1', '+501', 0),`
325	`('Costa Rica 2', '+506', 0),`	304	`('Costa Rica 2', '+506', 0),`
326	`('Cote d Ivoire', '+225', 0),`	305	`('Cote d Ivoire', '+225', 0),`
327	`('Croatie', '+385', 0),`	306	`('Croatie', '+385', 0),`
328	`('Cuba', '+53', 0),`	307	`('Cuba', '+53', 0),`
329	`('Curacao', '+599', 0),`	308	`('Curacao', '+599', 0),`
330	`('Danemark', '+45', 0),`	309	`('Danemark', '+45', 0),`
331	`('Djibouti', '+253', 0),`	310	`('Djibouti', '+253', 0),`
332	`('Dominique', '+1767', 0),`	311	`('Dominique', '+1767', 0),`
333	`('Egypte', '+20', 0),`	312	`('Egypte', '+20', 0),`
334	`('El Salvador', '+503', 0),`	313	`('El Salvador', '+503', 0),`
335	`('Emirats Arabes Unis', '+971', 0),`	314	`('Emirats Arabes Unis', '+971', 0),`
336	`('Equateur', '+593', 0),`	315	`('Equateur', '+593', 0),`
337	`('Erythree', '+291', 0),`	316	`('Erythree', '+291', 0),`
338	`('Espagne', '+34', 0),`	317	`('Espagne', '+34', 0),`
339	`('Estonie', '+372', 0),`	318	`('Estonie', '+372', 0),`
340	`('Etats-Unis', '+1', 0),`	319	`('Etats-Unis', '+1', 0),`
341	`('Ethiopie', '+251', 0),`	320	`('Ethiopie', '+251', 0),`
342	`('Falklands Malouines', '+500', 0),`	321	`('Falklands Malouines', '+500', 0),`
343	`('Finlande', '+358', 0),`	322	`('Finlande', '+358', 0),`
344	`('France', '+33', 1),`	323	`('France', '+33', 1),`
345	`('Gabon', '+241', 0),`	324	`('Gabon', '+241', 0),`
346	`('Gambie', '+220', 0),`	325	`('Gambie', '+220', 0),`
347	`('Georgie', '+995', 0),`	326	`('Georgie', '+995', 0),`
348	`('Ghana', '+233', 0),`	327	`('Ghana', '+233', 0),`
349	`('Gibraltar', '+350', 0),`	328	`('Gibraltar', '+350', 0),`
350	`('Grece', '+30', 0),`	329	`('Grece', '+30', 0),`
351	`('Grenade', '+1473', 0),`	330	`('Grenade', '+1473', 0),`
352	`('Groenland', '+299', 0),`	331	`('Groenland', '+299', 0),`
353	`('Guadeloupe', '+590', 0),`	332	`('Guadeloupe', '+590', 0),`
354	`('Guatemala', '+502', 0),`	333	`('Guatemala', '+502', 0),`
355	`('Guernesey', '+441481', 0),`	334	`('Guernesey', '+441481', 0),`
356	`('Guinee', '+224', 0),`	335	`('Guinee', '+224', 0),`
357	`('Guinee Bissau', '+245', 0),`	336	`('Guinee Bissau', '+245', 0),`
358	`('Guinee Equatoriale', '+240', 0),`	337	`('Guinee Equatoriale', '+240', 0),`
359	`('Guyana', '+5921', 0),`	338	`('Guyana', '+5921', 0),`
360	`('Guyane France', '+594', 0),`	339	`('Guyane France', '+594', 0),`
361	`('Haiti', '+509', 0),`	340	`('Haiti', '+509', 0),`
362	`('Herm', '+441481', 0),`	341	`('Herm', '+441481', 0),`
363	`('Honduras', '+504', 0),`	342	`('Honduras', '+504', 0),`
364	`('Hong Kong', '+852', 0),`	343	`('Hong Kong', '+852', 0),`
365	`('Hongrie', '+36', 0),`	344	`('Hongrie', '+36', 0),`
366	`('Ile de Ascension', '+247', 0),`	345	`('Ile de Ascension', '+247', 0),`
367	`('Ile Maurice', '+230', 0),`	346	`('Ile Maurice', '+230', 0),`
368	`('Iles Cayman', '+1345', 0),`	347	`('Iles Cayman', '+1345', 0),`
369	`('Iles Christmas', '+61', 0),`	348	`('Iles Christmas', '+61', 0),`
370	`('Iles Coco', '+61', 0),`	349	`('Iles Coco', '+61', 0),`
371	`('Iles Cook', '+682', 0),`	350	`('Iles Cook', '+682', 0),`
372	`('Iles Fidji', '+679', 0),`	351	`('Iles Fidji', '+679', 0),`
373	`('Iles Mariannes', '+1670', 0),`	352	`('Iles Mariannes', '+1670', 0),`
374	`('Iles Marshall', '+692', 0),`	353	`('Iles Marshall', '+692', 0),`
375	`('Iles Salomon', '+677', 0),`	354	`('Iles Salomon', '+677', 0),`
376	`('Iles Vierges GB', '+1284', 0),`	355	`('Iles Vierges GB', '+1284', 0),`
377	`('Iles Vierges USA', '+1340', 0),`	356	`('Iles Vierges USA', '+1340', 0),`
378	`('Inde', '+91', 0),`	357	`('Inde', '+91', 0),`
379	`('Indonesie', '+62', 0),`	358	`('Indonesie', '+62', 0),`
380	`('Irak', '+964', 0),`	359	`('Irak', '+964', 0),`
381	`('Iran', '+98', 0),`	360	`('Iran', '+98', 0),`
382	`('Irlande', '+353', 0),`	361	`('Irlande', '+353', 0),`
383	`('Islande', '+354', 0),`	362	`('Islande', '+354', 0),`
384	`('Israel', '+972', 0),`	363	`('Israel', '+972', 0),`
385	`('Italie', '+39', 0),`	364	`('Italie', '+39', 0),`
386	`('Jamaique', '+1876', 0),`	365	`('Jamaique', '+1876', 0),`
387	`('Japon', '+81', 0),`	366	`('Japon', '+81', 0),`
388	`('Jersey', '+441534', 0),`	367	`('Jersey', '+441534', 0),`
389	`('Jordanie', '+962', 0),`	368	`('Jordanie', '+962', 0),`
390	`('Kazakhstan', '+7', 0),`	369	`('Kazakhstan', '+7', 0),`
391	`('Kenya', '+254', 0),`	370	`('Kenya', '+254', 0),`
392	`('Kirghizistan', '+996', 0),`	371	`('Kirghizistan', '+996', 0),`
393	`('Kiribati', '+686', 0),`	372	`('Kiribati', '+686', 0),`
394	`('Koweit', '+965', 0),`	373	`('Koweit', '+965', 0),`
395	`('Laos', '+856', 0),`	374	`('Laos', '+856', 0),`
396	`('Lesotho', '+266', 0),`	375	`('Lesotho', '+266', 0),`
397	`('Lettonie', '+371', 0),`	376	`('Lettonie', '+371', 0),`
398	`('Liban', '+961', 0),`	377	`('Liban', '+961', 0),`
399	`('Libye', '+218', 0),`	378	`('Libye', '+218', 0),`
400	`('Liechtenstein', '+423', 0),`	379	`('Liechtenstein', '+423', 0),`
401	`('Lituanie', '+370', 0),`	380	`('Lituanie', '+370', 0),`
402	`('Luxembourg', '+352', 0),`	381	`('Luxembourg', '+352', 0),`
403	`('Macao', '+853', 0),`	382	`('Macao', '+853', 0),`
404	`('Macedoine', '+389', 0),`	383	`('Macedoine', '+389', 0),`
405	`('Madagascar', '+261', 0),`	384	`('Madagascar', '+261', 0),`
406	`('Malaisie', '+60', 0),`	385	`('Malaisie', '+60', 0),`
407	`('Malawi', '+265', 0),`	386	`('Malawi', '+265', 0),`
408	`('Maldives', '+960', 0),`	387	`('Maldives', '+960', 0),`
409	`('Mali', '+223', 0),`	388	`('Mali', '+223', 0),`
410	`('Malte', '+356', 0),`	389	`('Malte', '+356', 0),`
411	`('Maroc', '+212', 0),`	390	`('Maroc', '+212', 0),`
412	`('Martinique', '+596', 0),`	391	`('Martinique', '+596', 0),`
413	`('Mauritanie', '+222', 0),`	392	`('Mauritanie', '+222', 0),`
414	`('Mayotte', '+269', 0),`	393	`('Mayotte', '+269', 0),`
415	`('Mexique', '+52', 0),`	394	`('Mexique', '+52', 0),`
416	`('Micronesie', '+691', 0),`	395	`('Micronesie', '+691', 0),`
417	`('Moldavie', '+373', 0),`	396	`('Moldavie', '+373', 0),`
418	`('Monaco', '+377', 0),`	397	`('Monaco', '+377', 0),`
419	`('Mongolie', '+9761', 0),`	398	`('Mongolie', '+9761', 0),`
420	`('Montserrat', '+1664', 0),`	399	`('Montserrat', '+1664', 0),`
421	`('Mozambique', '+258', 0),`	400	`('Mozambique', '+258', 0),`
422	`('Namibie', '+264', 0),`	401	`('Namibie', '+264', 0),`
423	`('Nauru', '+674', 0),`	402	`('Nauru', '+674', 0),`
424	`('Nepal', '+977', 0),`	403	`('Nepal', '+977', 0),`
425	`('Nicaragua', '+505', 0),`	404	`('Nicaragua', '+505', 0),`
426	`('Niger', '+227', 0),`	405	`('Niger', '+227', 0),`
427	`('Nigeria', '+2349', 0),`	406	`('Nigeria', '+2349', 0),`
428	`('Norvege', '+47', 0),`	407	`('Norvege', '+47', 0),`
429	`('Nouvelle Caledonie', '+687', 0),`	408	`('Nouvelle Caledonie', '+687', 0),`
430	`('Nouvelle Zelande', '+64', 0),`	409	`('Nouvelle Zelande', '+64', 0),`
431	`('Oman', '+968', 0),`	410	`('Oman', '+968', 0),`
432	`('Ouganda', '+2560', 0),`	411	`('Ouganda', '+2560', 0),`
433	`('Ouzbekistan', '+998', 0),`	412	`('Ouzbekistan', '+998', 0),`
434	`('Pakistan', '+92', 0),`	413	`('Pakistan', '+92', 0),`
435	`('Palau', '+680', 0),`	414	`('Palau', '+680', 0),`
436	`('Palestine', '+970', 0),`	415	`('Palestine', '+970', 0),`
437	`('Panama', '+507', 0),`	416	`('Panama', '+507', 0),`
438	`('Papouasie Nouvelle Guinee', '+675', 0),`	417	`('Papouasie Nouvelle Guinee', '+675', 0),`
439	`('Paraguay', '+595', 0),`	418	`('Paraguay', '+595', 0),`
440	`('Pays-Bas', '+31', 0),`	419	`('Pays-Bas', '+31', 0),`
441	`('Perou', '+51', 0),`	420	`('Perou', '+51', 0),`
442	`('Philippines', '+63', 0),`	421	`('Philippines', '+63', 0),`
443	`('Pologne', '+48', 0),`	422	`('Pologne', '+48', 0),`
444	`('Polynesie France', '+689', 0),`	423	`('Polynesie France', '+689', 0),`
445	`('Porto Rico', '+1787', 0),`	424	`('Porto Rico', '+1787', 0),`
446	`('Portugal', '+351', 0),`	425	`('Portugal', '+351', 0),`
447	`('Qatar', '+974', 0),`	426	`('Qatar', '+974', 0),`
448	`('Republique Centrafricaine', '+236', 0),`	427	`('Republique Centrafricaine', '+236', 0),`
449	`('Republique Dominicaine', '+1809', 0),`	428	`('Republique Dominicaine', '+1809', 0),`
450	`('Republique Tcheque', '+420', 0),`	429	`('Republique Tcheque', '+420', 0),`
451	`('Reunion', '+262', 0),`	430	`('Reunion', '+262', 0),`
452	`('Roumanie', '+40', 0),`	431	`('Roumanie', '+40', 0),`
453	`('Royaume Uni', '+44', 0),`	432	`('Royaume Uni', '+44', 0),`
454	`('Russie', '+7', 0),`	433	`('Russie', '+7', 0),`
455	`('Rwanda', '+250', 0),`	434	`('Rwanda', '+250', 0),`
456	`('Saint Marin (Rep.)', '+378', 0),`	435	`('Saint Marin (Rep.)', '+378', 0),`
457	`('Sainte Lucie', '+1758', 0),`	436	`('Sainte Lucie', '+1758', 0),`
458	`('Samoa occidental', '+685', 0),`	437	`('Samoa occidental', '+685', 0),`
459	`('Sao Tome et Principe', '+239', 0),`	438	`('Sao Tome et Principe', '+239', 0),`
460	`('Senegal', '+221', 0),`	439	`('Senegal', '+221', 0),`
461	`('Serbie', '+381', 0),`	440	`('Serbie', '+381', 0),`
462	`('Sercq', '+441481', 0),`	441	`('Sercq', '+441481', 0),`
463	`('Seychelles', '+248', 0),`	442	`('Seychelles', '+248', 0),`
464	`('Sierra Leone', '+232', 0),`	443	`('Sierra Leone', '+232', 0),`
465	`('Singapour', '+65', 0),`	444	`('Singapour', '+65', 0),`
466	`('Slovaquie', '+421', 0),`	445	`('Slovaquie', '+421', 0),`
467	`('Slovenie', '+386', 0),`	446	`('Slovenie', '+386', 0),`
468	`('Somalie', '+252', 0),`	447	`('Somalie', '+252', 0),`
469	`('Soudan', '+249', 0),`	448	`('Soudan', '+249', 0),`
470	`('Sri Lanka', '+94', 0),`	449	`('Sri Lanka', '+94', 0),`
471	`('St Kitts', '+1869', 0),`	450	`('St Kitts', '+1869', 0),`
472	`('St Pierre et Miquelon', '+508', 0),`	451	`('St Pierre et Miquelon', '+508', 0),`
473	`('St Vincent et les Grenadines', '+1784', 0),`	452	`('St Vincent et les Grenadines', '+1784', 0),`
474	`('Suede', '+46', 0),`	453	`('Suede', '+46', 0),`
475	`('Suisse', '+41', 0),`	454	`('Suisse', '+41', 0),`
476	`('Surinam', '+597', 0),`	455	`('Surinam', '+597', 0),`
477	`('Swaziland', '+268', 0),`	456	`('Swaziland', '+268', 0),`
478	`('Syrie', '+963', 0),`	457	`('Syrie', '+963', 0),`
479	`('Tadjikistan', '+992', 0),`	458	`('Tadjikistan', '+992', 0),`
480	`('Taiwan', '+886', 0),`	459	`('Taiwan', '+886', 0),`
481	`('Tanzanie', '+255', 0),`	460	`('Tanzanie', '+255', 0),`
482	`('Tchad', '+235', 0),`	461	`('Tchad', '+235', 0),`
483	`('Thailande', '+661', 0),`	462	`('Thailande', '+661', 0),`

Subversion Repositories ALCASAR

(root)/conf/empty-gammu-smsd-db.sql @ 3044 – Rev 2063 → 2540