Subversion Repositories ALCASAR

Rev

Rev 2063 | Show entire file | Ignore 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
 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 */;
 -