diff options
author | Michal Čihař <nijel@debian.org> | 2017-10-18 10:25:21 +0200 |
---|---|---|
committer | Michal Čihař <nijel@debian.org> | 2017-10-18 10:25:21 +0200 |
commit | aad5c0f31b8583d1de28434597fb81a2079434a0 (patch) | |
tree | c388746fbd08c052c58aa732b4193f1149880fa5 /docs/sql/mysql-strict.sql | |
parent | ab91c30e54a279ee9f8f7c5a63a597860c99a705 (diff) |
New upstream version 1.38.5
Diffstat (limited to 'docs/sql/mysql-strict.sql')
-rw-r--r-- | docs/sql/mysql-strict.sql | 8 |
1 files changed, 7 insertions, 1 deletions
diff --git a/docs/sql/mysql-strict.sql b/docs/sql/mysql-strict.sql index b8770ee..10efe1f 100644 --- a/docs/sql/mysql-strict.sql +++ b/docs/sql/mysql-strict.sql @@ -18,7 +18,7 @@ CREATE TABLE `gammu` ( -- Dumping data for table `gammu` -- -INSERT INTO `gammu` (`Version`) VALUES (16); +INSERT INTO `gammu` (`Version`) VALUES (17); -- -------------------------------------------------------- @@ -39,6 +39,7 @@ CREATE TABLE `inbox` ( `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 ; @@ -74,6 +75,8 @@ CREATE TABLE `outbox` ( `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; @@ -99,6 +102,8 @@ CREATE TABLE `outbox_multipart` ( `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; @@ -161,6 +166,7 @@ CREATE TABLE `sentitems` ( `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; |