Subversion Repositories ALCASAR

Rev

Rev 2063 | Show entire file | Regard whitespace | Details | Blame | Last modification | View Log

Rev 2063 Rev 2540
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
-
 
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
-- 
-
 
19
-- Table structure for table `daemons`
2
-- Database for Gammu SMSD
20
-- 
3
-- 
-
 
4
-- In case you get errors about not supported charset, please
-
 
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
 
99
 
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
 
-
 
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 */;
-