1,28 → 1,10 |
-- MySQL dump 10.15 Distrib 10.0.23-MariaDB, for Linux (x86_64) |
-- |
-- Host: localhost Database: gammu |
-- ------------------------------------------------------ |
-- Server version 10.0.23-MariaDB |
|
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; |
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; |
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; |
/*!40101 SET NAMES utf8 */; |
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; |
/*!40103 SET TIME_ZONE='+00:00' */; |
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; |
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; |
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; |
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; |
|
-- |
-- Table structure for table `daemons` |
-- Database for Gammu SMSD |
-- |
-- In case you get errors about not supported charset, please |
-- replace utf8mb4 with utf8. |
|
CREATE TABLE `daemons` ( |
`Start` text NOT NULL, |
`Info` text NOT NULL |
) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
-- -------------------------------------------------------- |
|
-- |
-- Table structure for table `gammu` |
29,15 → 11,17 |
-- |
|
CREATE TABLE `gammu` ( |
`Version` integer NOT NULL default '0' |
) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
`Version` integer NOT NULL default '0' PRIMARY KEY |
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4; |
|
-- |
-- Dumping data for table `gammu` |
-- |
|
INSERT INTO `gammu` (`Version`) VALUES (14); |
INSERT INTO `gammu` (`Version`) VALUES (17); |
|
-- -------------------------------------------------------- |
|
-- |
-- Table structure for table `inbox` |
-- |
51,13 → 35,16 |
`UDH` text NOT NULL, |
`SMSCNumber` varchar(20) NOT NULL default '', |
`Class` integer NOT NULL default '-1', |
`TextDecoded` text NOT NULL default '', |
`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=utf8 AUTO_INCREMENT=1 ; |
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ; |
|
-- -------------------------------------------------------- |
|
-- |
-- Table structure for table `outbox` |
-- |
73,7 → 60,7 |
`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 default '', |
`TextDecoded` text NOT NULL, |
`ID` integer unsigned NOT NULL auto_increment, |
`MultiPart` enum('false','true') default 'false', |
`RelativeValidity` integer default '-1', |
81,12 → 68,18 |
`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=utf8; |
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4; |
|
CREATE INDEX outbox_date ON outbox(SendingDateTime, SendingTimeOut); |
CREATE INDEX outbox_sender ON outbox(SenderID); |
CREATE INDEX outbox_sender ON outbox(SenderID(250)); |
|
-- -------------------------------------------------------- |
|
-- |
-- Table structure for table `outbox_multipart` |
-- |
96,35 → 89,17 |
`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 default NULL, |
`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=utf8; |
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4; |
|
-- |
-- Table structure for table `pbk` |
-- |
-- -------------------------------------------------------- |
|
CREATE TABLE `pbk` ( |
`ID` integer NOT NULL auto_increment, |
`GroupID` integer NOT NULL default '-1', |
`Name` text NOT NULL, |
`Number` text NOT NULL, |
PRIMARY KEY (`ID`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
|
-- |
-- Table structure for table `pbk_groups` |
-- |
|
CREATE TABLE `pbk_groups` ( |
`Name` text NOT NULL, |
`ID` integer NOT NULL auto_increment, |
PRIMARY KEY `ID` (`ID`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; |
|
-- |
-- Table structure for table `phones` |
-- |
|
136,6 → 111,7 |
`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, |
144,8 → 120,10 |
`Sent` int NOT NULL DEFAULT 0, |
`Received` int NOT NULL DEFAULT 0, |
PRIMARY KEY (`IMEI`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4; |
|
-- -------------------------------------------------------- |
|
-- |
-- Table structure for table `sentitems` |
-- |
161,7 → 139,7 |
`UDH` text NOT NULL, |
`SMSCNumber` varchar(20) NOT NULL default '', |
`Class` integer NOT NULL default '-1', |
`TextDecoded` text NOT NULL default '', |
`TextDecoded` text NOT NULL, |
`ID` integer unsigned NOT NULL default '0', |
`SenderID` varchar(255) NOT NULL, |
`SequencePosition` integer NOT NULL default '1', |
170,13 → 148,14 |
`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=utf8; |
) 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); |
CREATE INDEX sentitems_sender ON sentitems(SenderID(250)); |
|
-- |
-- Triggers for setting default timestamps |
501,6 → 480,3 |
('Zimbabwe', '+263', 0), |
('FILTRAGE', 'fr', 0); |
|
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; |
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; |
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |