Line 1... |
Line -... |
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 |
|
Line 49... |
Line 33... |
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 |
|
Line 71... |
Line 58... |
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 |
|
Line 134... |
Line 109... |
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 |
|
Line 159... |
Line 137... |
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 |
|
Line 499... |
Line 478... |
499 |
('Yemen', '+967', 0),
|
478 |
('Yemen', '+967', 0),
|
500 |
('Zambie', '+260', 0),
|
479 |
('Zambie', '+260', 0),
|
501 |
('Zimbabwe', '+263', 0),
|
480 |
('Zimbabwe', '+263', 0),
|
502 |
('FILTRAGE', 'fr', 0);
|
481 |
('FILTRAGE', 'fr', 0);
|
503 |
|
482 |
|
504 |
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
|
- |
|
505 |
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
|
- |
|
506 |
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
- |
|