/*!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 `AppBoxApplication`
--

DROP TABLE IF EXISTS `AppBoxApplication`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `AppBoxApplication` (
  `applicationId` varchar(250) NOT NULL,
  `created` datetime NOT NULL,
  `locked` bit(1) NOT NULL,
  `name` varchar(250) NOT NULL,
  `accessLdapGroup` varchar(250) default NULL,
  PRIMARY KEY  (`applicationId`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `AppBoxApplicationInfo`
--

DROP TABLE IF EXISTS `AppBoxApplicationInfo`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `AppBoxApplicationInfo` (
  `DTYPE` varchar(31) NOT NULL,
  `applicationId` varchar(250) NOT NULL,
  `infoKey` varchar(45) NOT NULL,
  `modified` datetime default NULL,
  `value` varchar(255) default NULL,
  `valueClass` varchar(255) default NULL,
  `valueConstraints` varchar(255) default NULL,
  PRIMARY KEY  (`applicationId`,`infoKey`),
  KEY `FK6208E0B4FBA83726` (`applicationId`),
  CONSTRAINT `FK6208E0B4FBA83726` FOREIGN KEY (`applicationId`) REFERENCES `AppBoxApplication` (`applicationId`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `AppBoxDatastore`
--

DROP TABLE IF EXISTS `AppBoxDatastore`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `AppBoxDatastore` (
  `applicationId` varchar(250) NOT NULL,
  `deviceId` varchar(50) NOT NULL,
  `resourceId` varchar(45) NOT NULL,
  `created` datetime NOT NULL,
  `data` mediumtext,
  `modified` datetime NOT NULL,
  PRIMARY KEY  (`applicationId`,`deviceId`,`resourceId`),
  KEY `FK6B57968D60EC6AC0` (`applicationId`,`deviceId`),
  CONSTRAINT `FK6B57968D60EC6AC0` FOREIGN KEY (`applicationId`, `deviceId`) REFERENCES `AppBoxInstalledOn` (`applicationId`, `deviceId`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `AppBoxDeploymentInfo`
--

DROP TABLE IF EXISTS `AppBoxDeploymentInfo`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `AppBoxDeploymentInfo` (
  `lineNumber` int(11) NOT NULL auto_increment,
  `created` datetime NOT NULL,
  `message` varchar(255) NOT NULL,
  `applicationId` varchar(250) NOT NULL,
  PRIMARY KEY  (`lineNumber`),
  KEY `FKA648D3BDFBA83726` (`applicationId`),
  CONSTRAINT `FKA648D3BDFBA83726` FOREIGN KEY (`applicationId`) REFERENCES `AppBoxApplication` (`applicationId`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `AppBoxFilestore`
--

DROP TABLE IF EXISTS `AppBoxFilestore`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `AppBoxFilestore` (
  `applicationId` varchar(250) NOT NULL,
  `fileName` varchar(150) NOT NULL,
  `created` datetime NOT NULL,
  `data` mediumblob,
  `fingerprint` varchar(32) default NULL,
  `modified` datetime NOT NULL,
  `size` bigint(20) default NULL,
  PRIMARY KEY  (`applicationId`,`fileName`),
  KEY `FK328B63FBFBA83726` (`applicationId`),
  CONSTRAINT `FK328B63FBFBA83726` FOREIGN KEY (`applicationId`) REFERENCES `AppBoxApplication` (`applicationId`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `AppBoxInstalledOn`
--

DROP TABLE IF EXISTS `AppBoxInstalledOn`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `AppBoxInstalledOn` (
  `applicationId` varchar(250) NOT NULL,
  `deviceId` varchar(50) NOT NULL,
  `created` datetime NOT NULL,
  PRIMARY KEY  (`applicationId`,`deviceId`),
  KEY `FK9F69308FFBA83726` (`applicationId`),
  KEY `FK9F69308FD9276726` (`deviceId`),
  CONSTRAINT `FK9F69308FD9276726` FOREIGN KEY (`deviceId`) REFERENCES `terminal` (`terminalID`) ON DELETE CASCADE,
  CONSTRAINT `FK9F69308FFBA83726` FOREIGN KEY (`applicationId`) REFERENCES `AppBoxApplication` (`applicationId`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `AppBoxRequestFunction`
--

DROP TABLE IF EXISTS `AppBoxRequestFunction`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `AppBoxRequestFunction` (
  `applicationId` varchar(250) NOT NULL,
  `functionName` varchar(45) NOT NULL,
  `requestHandler` varchar(45) NOT NULL,
  `displayName` varchar(150) default NULL,
  `referencedByForm` bit(1) default NULL,
  PRIMARY KEY  (`applicationId`,`functionName`,`requestHandler`),
  KEY `FK9905F61DBE6492B6` (`applicationId`,`requestHandler`),
  CONSTRAINT `FK9905F61DBE6492B6` FOREIGN KEY (`applicationId`, `requestHandler`) REFERENCES `AppBoxRequestHandler` (`applicationId`, `requestHandler`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `AppBoxRequestHandler`
--

DROP TABLE IF EXISTS `AppBoxRequestHandler`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `AppBoxRequestHandler` (
  `applicationId` varchar(250) NOT NULL,
  `requestHandler` varchar(45) NOT NULL,
  `displayName` varchar(150) default NULL,
  PRIMARY KEY  (`applicationId`,`requestHandler`),
  KEY `FK248F865FBA83726` (`applicationId`),
  CONSTRAINT `FK248F865FBA83726` FOREIGN KEY (`applicationId`) REFERENCES `AppBoxApplication` (`applicationId`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `Connector`
--

DROP TABLE IF EXISTS `Connector`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `Connector` (
  `connectorId` varchar(50) NOT NULL,
  `location` varchar(255) default NULL,
  `displayName` varchar(255) default NULL,
  `connectorState` varchar(255) default NULL,
  `locked` bit(1) NOT NULL,
  `collaborationSystem` varchar(255) default NULL,
  `userMode` varchar(255) default NULL,
  `supportedUsersExp` varchar(255) default NULL,
  `supportedGroup` varchar(255) default NULL,
  `nodeMode` varchar(255) default NULL,
  `serviceVersion` varchar(255) default NULL,
  `dmeDomainName` varchar(255) default NULL,
  `revision` int(11) default NULL,
  PRIMARY KEY  (`connectorId`),
  KEY `FK54EC142DB47D0252` (`dmeDomainName`),
  CONSTRAINT `FK54EC142DB47D0252` FOREIGN KEY (`dmeDomainName`) REFERENCES `DMEDomain` (`domainName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `ConnectorFunction`
--

DROP TABLE IF EXISTS `ConnectorFunction`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `ConnectorFunction` (
  `functionName` varchar(128) NOT NULL,
  `connectorId` varchar(50) NOT NULL,
  `functionState` varchar(25) default NULL,
  `acceptPoll` bit(1) default NULL,
  `applicationId` varchar(250) default NULL,
  PRIMARY KEY  (`functionName`,`connectorId`),
  KEY `FK67C96F255D6CA4BC` (`connectorId`),
  KEY `FK67C96F25FBA83726` (`applicationId`),
  CONSTRAINT `FK67C96F255D6CA4BC` FOREIGN KEY (`connectorId`) REFERENCES `Connector` (`connectorId`) ON DELETE CASCADE,
  CONSTRAINT `FK67C96F25FBA83726` FOREIGN KEY (`applicationId`) REFERENCES `AppBoxApplication` (`applicationId`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `ConnectorProperty`
--

DROP TABLE IF EXISTS `ConnectorProperty`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `ConnectorProperty` (
  `connectorId` varchar(50) NOT NULL,
  `keyName` varchar(128) NOT NULL,
  `propertyValue` varchar(2048) default NULL,
  PRIMARY KEY  (`connectorId`,`keyName`),
  KEY `FKDA47D9225D6CA4BC` (`connectorId`),
  CONSTRAINT `FKDA47D9225D6CA4BC` FOREIGN KEY (`connectorId`) REFERENCES `Connector` (`connectorId`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `ConnectorUser`
--

DROP TABLE IF EXISTS `ConnectorUser`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `ConnectorUser` (
  `functionName` varchar(128) NOT NULL,
  `userID` varchar(50) NOT NULL,
  `connectorId` varchar(50) NOT NULL,
  `supported` bit(1) default NULL,
  `success` int(11) default NULL,
  `error` int(11) default NULL,
  PRIMARY KEY  (`connectorId`,`functionName`,`userID`),
  KEY `FK1B6495985D6CA4BC` (`connectorId`),
  KEY `FK1B6495988159F4BB` (`userID`),
  CONSTRAINT `FK1B649598A0F9EB17` FOREIGN KEY (`connectorId`, `functionName`) REFERENCES `ConnectorFunction` (`connectorId`, `functionName`) ON DELETE CASCADE,
  CONSTRAINT `FK1B6495988159F4BB` FOREIGN KEY (`userID`) REFERENCES `usr` (`userID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `DMEDomain`
--

DROP TABLE IF EXISTS `DMEDomain`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `DMEDomain` (
  `domainName` varchar(255) NOT NULL,
  PRIMARY KEY  (`domainName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `DME_Attachments`
--

DROP TABLE IF EXISTS `DME_Attachments`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `DME_Attachments` (
  `attachmentLinkID` varchar(50) NOT NULL,
  `fileName` varchar(250) NOT NULL,
  `data` longblob NOT NULL,
  `created` datetime default NULL,
  `fingerPrint` varchar(50) NOT NULL,
  `fileSize` bigint(20) NOT NULL,
  PRIMARY KEY  (`attachmentLinkID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `DME_License`
--

DROP TABLE IF EXISTS `DME_License`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `DME_License` (
  `licenseID` varchar(100) NOT NULL,
  `license` blob NOT NULL,
  `numberOfLicenses` int(11) NOT NULL,
  `defaultLicense` tinyint(4) default NULL,
  PRIMARY KEY  (`licenseID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `DME_ServerConfiguration`
--

DROP TABLE IF EXISTS `DME_ServerConfiguration`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `DME_ServerConfiguration` (
  `propertyKey` varchar(250) NOT NULL,
  `propertyValue` varchar(2048) default NULL,
  PRIMARY KEY  (`propertyKey`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `DME_System`
--

DROP TABLE IF EXISTS `DME_System`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `DME_System` (
  `name` varchar(250) NOT NULL,
  `value` varchar(250) default NULL,
  PRIMARY KEY  (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `DME_UI_Preference`
--

DROP TABLE IF EXISTS `DME_UI_Preference`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `DME_UI_Preference` (
  `ClassName` varchar(30) NOT NULL,
  `Preference` tinyblob,
  `PreferenceName` varchar(255) NOT NULL,
  `UserId` varchar(50) NOT NULL,
  PRIMARY KEY  (`ClassName`),
  UNIQUE KEY `UserId` (`UserId`,`ClassName`,`PreferenceName`),
  KEY `FK134669638159F4BB` (`UserId`),
  CONSTRAINT `FK134669638159F4BB` FOREIGN KEY (`UserId`) REFERENCES `usr` (`userID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `DME_UpdateFile`
--

DROP TABLE IF EXISTS `DME_UpdateFile`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `DME_UpdateFile` (
  `updateFileID` varchar(250) NOT NULL,
  `name` varchar(250) default NULL,
  `fileType` varchar(255) NOT NULL,
  `major` int(11) NOT NULL,
  `minor` int(11) NOT NULL,
  `micro` varchar(250) default NULL,
  `sortVersion` varchar(250) default NULL,
  `releaseDate` datetime default NULL,
  `description` text,
  `fileName` varchar(250) default NULL,
  `fileSize` bigint(20) NOT NULL,
  `archive` bit(1) NOT NULL,
  `listed` bit(1) NOT NULL default b'1',
  `extraDescription` text,
  `orgFileName` varchar(50) default NULL,
  `category` varchar(100) NOT NULL,
  `smsCode` varchar(50) default NULL,
  `smsCodeType` varchar(250) default NULL,
  `installFileType` varchar(255) default NULL,
  `defaultVersion` bit(1) NOT NULL,
  `testVersion` bit(1) NOT NULL,
  `data` longblob,
  PRIMARY KEY  (`updateFileID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `IphoneProfile`
--

DROP TABLE IF EXISTS `IphoneProfile`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `IphoneProfile` (
  `profileID` varchar(255) NOT NULL,
  `category` varchar(255) default NULL,
  `changeDate` datetime default NULL,
  `content` longblob,
  `description` varchar(255) default NULL,
  `fileName` varchar(255) default NULL,
  `hash` varchar(255) default NULL,
  `identifier` varchar(255) default NULL,
  `name` varchar(255) default NULL,
  `smsCode` varchar(255) default NULL,
  `uuid` varchar(255) default NULL,
  PRIMARY KEY  (`profileID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `NetworkStatistic`
--

DROP TABLE IF EXISTS `NetworkStatistic`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `NetworkStatistic` (
  `statisticID` int(11) NOT NULL auto_increment,
  `size` bigint(20) NOT NULL,
  `date` datetime default NULL,
  `month` int(11) NOT NULL,
  `year` int(11) NOT NULL,
  `category` varchar(255) default NULL,
  `duration` bigint(20) NOT NULL,
  `terminalID` varchar(50) default NULL,
  `userID` varchar(50) default NULL,
  `quarter` int(11) NOT NULL,
  `week` int(11) NOT NULL,
  `inSize` bigint(20) NOT NULL,
  `outSize` bigint(20) NOT NULL,
  PRIMARY KEY  (`statisticID`),
  KEY `IX_NetworkStatistic_terminalID_category` (`terminalID`,`category`),
  KEY `IX_NetworkStatistic_userID_category` (`userID`,`category`),
  KEY `IX_NetworkStatistic_date_category` (`date`,`category`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `OTA`
--

DROP TABLE IF EXISTS `OTA`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `OTA` (
  `name` varchar(250) NOT NULL,
  `category` varchar(250) default NULL,
  `messageType` varchar(50) default NULL,
  `xml` text,
  `smsCode` varchar(50) default NULL,
  PRIMARY KEY  (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `RrdEntry`
--

DROP TABLE IF EXISTS `RrdEntry`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `RrdEntry` (
  `rrdEntryId` int(11) NOT NULL auto_increment,
  `data` blob,
  `statisticKey` varchar(45) NOT NULL,
  `connectorId` varchar(50) default NULL,
  `serverId` varchar(128) default NULL,
  PRIMARY KEY  (`rrdEntryId`),
  KEY `IX_RrdEntry_serverId` (`serverId`),
  KEY `IX_RrdEntry_connectorId` (`connectorId`),
  CONSTRAINT `IX_RrdEntry_serverId` FOREIGN KEY (`serverId`) REFERENCES `Server` (`serverId`),
  CONSTRAINT `IX_RrdEntry_connectorId` FOREIGN KEY (`connectorId`) REFERENCES `Connector` (`connectorId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `Server`
--

DROP TABLE IF EXISTS `Server`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `Server` (
  `serverId` varchar(128) NOT NULL,
  `name` varchar(128) default NULL,
  PRIMARY KEY  (`serverId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `ServerSMS`
--

DROP TABLE IF EXISTS `ServerSMS`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `ServerSMS` (
  `serverSMSID` int(11) NOT NULL auto_increment,
  `message` text,
  `created` datetime default NULL,
  `phoneNr` varchar(50) default NULL,
  `sentdate` datetime default NULL,
  `currentsms` int(11) default NULL,
  `smscount` int(11) default NULL,
  PRIMARY KEY  (`serverSMSID`),
  KEY `IX_ServerSMS_phoneNr` USING BTREE (`phoneNr`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `apn`
--

DROP TABLE IF EXISTS `apn`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `apn` (
  `apnID` int(11) NOT NULL auto_increment,
  `name` varchar(100) default NULL,
  `type` varchar(50) NOT NULL,
  `aph` longblob,
  `lastChanged` datetime default NULL,
  PRIMARY KEY  (`apnID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `applicationBlock`
--

DROP TABLE IF EXISTS `applicationBlock`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `applicationBlock` (
  `applicationBlockID` int(11) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL,
  `type` varchar(50) NOT NULL,
  `uid` varchar(100) NOT NULL,
  `terminalID` varchar(50) default NULL,
  `localGroupID` varchar(5) default NULL,
  `block` smallint(6) default NULL,
  `installed` bit(1) default NULL,
  `groupBy` varchar(250) default NULL,
  `changedDate` datetime default NULL,
  `inUse` bit(1) default NULL,
  `owner` varchar(255) default NULL,
  PRIMARY KEY  (`applicationBlockID`),
  UNIQUE KEY `IX_applicationBlock_terminalID_uid` (`terminalID`,`localGroupID`,`uid`),
  KEY `IX_applicationBlock_localGroupID_uid` USING BTREE (`localGroupID`,`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `countryRates`
--

DROP TABLE IF EXISTS `countryRates`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `countryRates` (
  `countryRatesID` int(11) NOT NULL auto_increment,
  `internationalRate` decimal(10,4) default NULL,
  `mmsRate` decimal(10,4) default NULL,
  `smsRate` decimal(10,4) default NULL,
  `trafficMB` decimal(10,4) default NULL,
  `type` varchar(255) default NULL,
  `mcc` int(11) default NULL,
  `subscription` int(11) NOT NULL,
  PRIMARY KEY  (`countryRatesID`),
  KEY `FK578F559DE20A5EA5` (`subscription`),
  KEY `FK578F559D8E5C98B4` (`mcc`),
  CONSTRAINT `FK578F559D8E5C98B4` FOREIGN KEY (`mcc`) REFERENCES `dme_voice_locator` (`mcc`),
  CONSTRAINT `FK578F559DE20A5EA5` FOREIGN KEY (`subscription`) REFERENCES `subscriptions` (`subscriptionId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `dayScheme`
--

DROP TABLE IF EXISTS `dayScheme`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dayScheme` (
  `daySchemeID` int(11) NOT NULL auto_increment,
  `startTime` time NOT NULL,
  `dayOfWeek` int(11) NOT NULL,
  `endTime` time default NULL,
  `schemeID` int(11) NOT NULL,
  `syncInterval` int(11) NOT NULL,
  `fullSyncInterval` int(11) NOT NULL,
  `subscribed` bit(1) NOT NULL default b'0',
  PRIMARY KEY  (`daySchemeID`),
  KEY `IX_dayScheme_schemeID` (`schemeID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `defaultApplicationBlock`
--

DROP TABLE IF EXISTS `defaultApplicationBlock`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `defaultApplicationBlock` (
  `defaultApplicationBlockID` int(11) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL,
  `type` varchar(50) NOT NULL,
  `uid` varchar(100) NOT NULL,
  `block` tinyint(4) default NULL,
  `groupBy` varchar(250) default NULL,
  `changedDate` datetime default NULL,
  PRIMARY KEY  (`defaultApplicationBlockID`),
  KEY `IX_defaultApplicationBlock_groupBy` (`groupBy`),
  KEY `IX_defaultApplicationBlock_uid` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `deviceInfo`
--

DROP TABLE IF EXISTS `deviceInfo`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `deviceInfo` (
  `deviceInfoID` int(11) NOT NULL auto_increment,
  `locked` bit(1) NOT NULL,
  `dmeVersionType` varchar(255) default NULL,
  `dmManufacturer` varchar(250) default NULL,
  `dmModel` varchar(250) default NULL,
  `phoneModel` varchar(250) default NULL,
  `pictureData` longblob,
  `picturePath` varchar(250) default NULL,
  `pictureDimensions` varchar(15) default NULL,
  `os` varchar(255) default NULL,
  `platform` varchar(255) default NULL,
  PRIMARY KEY  (`deviceInfoID`),
  KEY `IX_deviceInfo_deviceInfoID_locked` USING BTREE (`deviceInfoID`,`locked`)
) ENGINE=InnoDB AUTO_INCREMENT=287 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `deviceSignature`
--

DROP TABLE IF EXISTS `deviceSignature`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `deviceSignature` (
  `deviceID` varchar(50) NOT NULL,
  `status` int(11) default NULL,
  `errorCount` int(11) default NULL,
  `created` datetime default NULL,
  `creator` varchar(50) default NULL,
  `encodedKey` text,
  PRIMARY KEY  (`deviceID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `distinctValues`
--

DROP TABLE IF EXISTS `distinctValues`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `distinctValues` (
  `value` varchar(50) NOT NULL,
  `created` datetime default NULL,
  PRIMARY KEY  (`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `dmFileStore`
--

DROP TABLE IF EXISTS `dmFileStore`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dmFileStore` (
  `fileID` int(11) NOT NULL auto_increment,
  `name` varchar(195) default NULL,
  `size` int(11) default NULL,
  `path` varchar(255) default NULL,
  `data` longblob,
  `access` varchar(3) default NULL,
  `fingerprint` varchar(32) default NULL,
  `modified` datetime NOT NULL,
  PRIMARY KEY  (`fileID`),
  UNIQUE KEY `IX_dmfilestore_path_name` (`path`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `dmRules`
--

DROP TABLE IF EXISTS `dmRules`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dmRules` (
  `ruleID` int(11) NOT NULL auto_increment,
  `name` varchar(150) default NULL,
  `domain` varchar(100) default NULL,
  `server` varchar(100) default NULL,
  `terminalID` varchar(50) default NULL,
  `syncMode` int(11) NOT NULL,
  `clientRoot` varchar(50) NOT NULL,
  `clientDestination` varchar(255) default NULL,
  `groupID` int(11) default NULL,
  `deviceType` varchar(150) default NULL,
  `isMonitor` int(11) NOT NULL,
  `linkFolder` varchar(255) default NULL,
  `linkFile` varchar(255) default NULL,
  `authUser` varchar(50) default NULL,
  `authCredentials` varchar(50) default NULL,
  PRIMARY KEY  (`ruleID`),
  KEY `IX_dmrules_groupID` USING BTREE (`groupID`),
  KEY `IX_dmrules_terminalID` USING BTREE (`terminalID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `dmWorkQueue`
--

DROP TABLE IF EXISTS `dmWorkQueue`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dmWorkQueue` (
  `ID` int(11) NOT NULL auto_increment,
  `fingerprint` varchar(32) NOT NULL,
  `syncID` varchar(50) NOT NULL,
  PRIMARY KEY  (`ID`),
  KEY `IX_dmworkqueue_syncID` USING BTREE (`syncID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `dm_action`
--

DROP TABLE IF EXISTS `dm_action`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dm_action` (
  `actionID` int(11) NOT NULL auto_increment,
  `command` varchar(255) default NULL,
  `actionPlan` int(11) default NULL,
  `node_id` int(11) default NULL,
  PRIMARY KEY  (`actionID`),
  KEY `FK723AF2AC8EEF687F` (`node_id`),
  KEY `FK723AF2ACA76DE723` (`actionPlan`),
  CONSTRAINT `FK723AF2AC8EEF687F` FOREIGN KEY (`node_id`) REFERENCES `dm_node` (`id`),
  CONSTRAINT `FK723AF2ACA76DE723` FOREIGN KEY (`actionPlan`) REFERENCES `dm_action_plan` (`actionPlanPK`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `dm_action_plan`
--

DROP TABLE IF EXISTS `dm_action_plan`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dm_action_plan` (
  `actionPlanPK` int(11) NOT NULL auto_increment,
  `type` varchar(128) NOT NULL,
  `model` varchar(128) NOT NULL,
  PRIMARY KEY  (`actionPlanPK`),
  UNIQUE KEY `IX_Unique_dm_action_plan_type_model` (`type`,`model`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `dm_bootstrapMessages`
--

DROP TABLE IF EXISTS `dm_bootstrapMessages`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dm_bootstrapMessages` (
  `bootstrapMessageID` int(11) NOT NULL auto_increment,
  `bootstrapMessage` varchar(2000) default NULL,
  `initiateMessageID` int(11) default NULL,
  PRIMARY KEY  (`bootstrapMessageID`),
  KEY `FK42152BA45D3EB49F` (`initiateMessageID`),
  CONSTRAINT `FK42152BA45D3EB49F` FOREIGN KEY (`initiateMessageID`) REFERENCES `dm_initiateMessages` (`initiateMessageID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `dm_config_server`
--

DROP TABLE IF EXISTS `dm_config_server`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dm_config_server` (
  `name` varchar(255) NOT NULL,
  `value` varchar(255) default NULL,
  PRIMARY KEY  (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `dm_connection_history`
--

DROP TABLE IF EXISTS `dm_connection_history`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dm_connection_history` (
  `ID` int(11) NOT NULL auto_increment,
  `created` datetime default NULL,
  `state` varchar(255) default NULL,
  `device` int(11) NOT NULL,
  PRIMARY KEY  (`ID`),
  KEY `FKB170BFA913CE9D71` (`device`),
  CONSTRAINT `FKB170BFA913CE9D71` FOREIGN KEY (`device`) REFERENCES `dm_devices` (`devicePK`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `dm_ddf`
--

DROP TABLE IF EXISTS `dm_ddf`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dm_ddf` (
  `ddfID` int(11) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL,
  `fileName` varchar(255) default NULL,
  `description` text,
  `xml` longtext,
  `groupName` varchar(100) default NULL,
  `changeDate` datetime NOT NULL,
  PRIMARY KEY  (`ddfID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `dm_ddf_conf`
--

DROP TABLE IF EXISTS `dm_ddf_conf`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dm_ddf_conf` (
  `ddfConfID` int(11) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL,
  `description` text,
  `groupName` varchar(100) default NULL,
  `changeDate` datetime NOT NULL,
  `ddfID` int(11) default NULL,
  PRIMARY KEY  (`ddfConfID`),
  KEY `FK235C92D32CDC2353` (`ddfID`),
  CONSTRAINT `FK235C92D32CDC2353` FOREIGN KEY (`ddfID`) REFERENCES `dm_ddf` (`ddfID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `dm_ddf_values`
--

DROP TABLE IF EXISTS `dm_ddf_values`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dm_ddf_values` (
  `ddfValueID` int(11) NOT NULL auto_increment,
  `value` longblob,
  `priority` int(11) NOT NULL,
  `type` varchar(255) default NULL,
  `path` varchar(1024) NOT NULL,
  `format` varchar(50) default NULL,
  `operation` varchar(50) default NULL,
  `ddfConfID` int(11) NOT NULL,
  `valueName` varchar(255) default NULL,
  PRIMARY KEY  (`ddfValueID`),
  KEY `FKDE2951114755E0BB` (`ddfConfID`),
  CONSTRAINT `FKDE2951114755E0BB` FOREIGN KEY (`ddfConfID`) REFERENCES `dm_ddf_conf` (`ddfConfID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `dm_device_tree`
--

DROP TABLE IF EXISTS `dm_device_tree`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dm_device_tree` (
  `deviceID` varchar(50) NOT NULL,
  `nodeTree` longblob,
  `createdDate` datetime default NULL,
  PRIMARY KEY  (`deviceID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `dm_devices`
--

DROP TABLE IF EXISTS `dm_devices`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dm_devices` (
  `devicePK` int(11) NOT NULL auto_increment,
  `deviceID` varchar(255) default NULL,
  `manufacturer` varchar(255) default NULL,
  `model` varchar(255) default NULL,
  `dmVersion` varchar(255) default NULL,
  `language` varchar(255) default NULL,
  `digest` varchar(255) default NULL,
  `client_nonce` tinyblob,
  `server_nonce` tinyblob,
  `deleted` bit(1) default NULL,
  `phoneNumber` varchar(255) default NULL,
  `bootID` varchar(255) default NULL,
  `connectionState` varchar(255) default NULL,
  `user` int(11) default NULL,
  PRIMARY KEY  (`devicePK`),
  UNIQUE KEY `IX_Unique_dm_devices_bootID` (`bootID`),
  KEY `FK775BC72763FC4C84` (`user`),
  CONSTRAINT `FK775BC72763FC4C84` FOREIGN KEY (`user`) REFERENCES `dm_users` (`userPK`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `dm_dme_jobs`
--

DROP TABLE IF EXISTS `dm_dme_jobs`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dm_dme_jobs` (
  `jobID` varchar(255) NOT NULL,
  `deviceID` varchar(255) default NULL,
  `phoneNumber` varchar(255) default NULL,
  `createdDate` datetime default NULL,
  `jobRequest` longblob,
  `requestType` int(11) default NULL,
  `status` longblob,
  `nodeJobs` longblob,
  `waitForJobID` varchar(100) default NULL,
  `waitSendIf` varchar(50) default NULL,
  `state` varchar(255) default NULL,
  `meta` varchar(255) default NULL,
  `nodeStatus` longblob,
  `waitPath` varchar(255) default NULL,
  `jobGroup` varchar(255) default NULL,
  PRIMARY KEY  (`jobID`),
  KEY `IX_dm_dme_jobs_deviceID` (`deviceID`),
  KEY `FKFDC2FCAF166BE886` (`jobGroup`),
  CONSTRAINT `FKFDC2FCAF166BE886` FOREIGN KEY (`jobGroup`) REFERENCES `prov_job_group` (`groupID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `dm_initiateMessages`
--

DROP TABLE IF EXISTS `dm_initiateMessages`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dm_initiateMessages` (
  `initiateMessageID` int(11) NOT NULL auto_increment,
  `created` datetime NOT NULL,
  `status` varchar(255) NOT NULL,
  `devicePK` int(11) NOT NULL,
  `jobID` varchar(255) NOT NULL,
  PRIMARY KEY  (`initiateMessageID`),
  UNIQUE KEY `jobID` (`jobID`),
  KEY `FK7B4227FBA5806DEC` (`devicePK`),
  KEY `FK7B4227FBFE5326B0` (`jobID`),
  CONSTRAINT `FK7B4227FBFE5326B0` FOREIGN KEY (`jobID`) REFERENCES `dm_job` (`jobID`),
  CONSTRAINT `FK7B4227FBA5806DEC` FOREIGN KEY (`devicePK`) REFERENCES `dm_devices` (`devicePK`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `dm_job`
--

DROP TABLE IF EXISTS `dm_job`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dm_job` (
  `jobID` varchar(255) NOT NULL,
  `status` varchar(255) default NULL,
  `created` datetime default NULL,
  `exploreJob` bit(1) default NULL,
  `responseOnStatus` bit(1) default NULL,
  `nextResend` datetime default NULL,
  `resetCount` int(11) default NULL,
  `blockDevice` bit(1) default NULL,
  `device` int(11) default NULL,
  `deleted` bit(1) default NULL,
  `runAfter` datetime default NULL,
  PRIMARY KEY  (`jobID`),
  KEY `FKB0D16B0713CE9D71` (`device`),
  CONSTRAINT `FKB0D16B0713CE9D71` FOREIGN KEY (`device`) REFERENCES `dm_devices` (`devicePK`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `dm_node`
--

DROP TABLE IF EXISTS `dm_node`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dm_node` (
  `id` int(11) NOT NULL auto_increment,
  `target` varchar(512) default NULL,
  `format` varchar(255) default NULL,
  `type` varchar(255) default NULL,
  `nodeData` int(11) default NULL,
  PRIMARY KEY  (`id`),
  KEY `FK695DC7F85C4450FD` (`nodeData`),
  CONSTRAINT `FK695DC7F85C4450FD` FOREIGN KEY (`nodeData`) REFERENCES `dm_nodeData` (`pk`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `dm_nodeData`
--

DROP TABLE IF EXISTS `dm_nodeData`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dm_nodeData` (
  `pk` int(11) NOT NULL auto_increment,
  `data` longblob,
  `checksum` tinyblob,
  PRIMARY KEY  (`pk`),
  KEY `IX_dm_nodeData_checksum` (`checksum`(255))
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `dm_node_result`
--

DROP TABLE IF EXISTS `dm_node_result`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dm_node_result` (
  `id` int(11) NOT NULL auto_increment,
  `format` varchar(255) default NULL,
  `target` varchar(255) default NULL,
  `type` varchar(255) default NULL,
  `nodeData` int(11) default NULL,
  PRIMARY KEY  (`id`),
  KEY `FKD9C596445C4450FD` (`nodeData`),
  CONSTRAINT `FKD9C596445C4450FD` FOREIGN KEY (`nodeData`) REFERENCES `dm_nodeData` (`pk`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `dm_operation`
--

DROP TABLE IF EXISTS `dm_operation`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dm_operation` (
  `operationID` int(11) NOT NULL auto_increment,
  `command` varchar(255) default NULL,
  `statusCode` varchar(255) default NULL,
  `jobNodeID` varchar(255) default NULL,
  `task` int(11) default NULL,
  `node_id` int(11) default NULL,
  `resultNode_id` int(11) default NULL,
  PRIMARY KEY  (`operationID`),
  KEY `FK712085318EEF687F` (`node_id`),
  KEY `FK712085311120390F` (`task`),
  KEY `FK71208531F592B5C2` (`resultNode_id`),
  CONSTRAINT `FK71208531F50408BF` FOREIGN KEY (`resultNode_id`) REFERENCES `dm_node_result` (`id`),
  CONSTRAINT `FK712085311120390F` FOREIGN KEY (`task`) REFERENCES `dm_task` (`id`),
  CONSTRAINT `FK712085318EEF687F` FOREIGN KEY (`node_id`) REFERENCES `dm_node` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `dm_path_exclusions`
--

DROP TABLE IF EXISTS `dm_path_exclusions`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dm_path_exclusions` (
  `pathExclusionID` int(11) NOT NULL auto_increment,
  `path` varchar(255) NOT NULL,
  PRIMARY KEY  (`pathExclusionID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `dm_persisted_tree_structure`
--

DROP TABLE IF EXISTS `dm_persisted_tree_structure`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dm_persisted_tree_structure` (
  `jobID` varchar(255) NOT NULL,
  `updatedDate` datetime NOT NULL,
  `treeStructure` longblob NOT NULL,
  PRIMARY KEY  (`jobID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `dm_support`
--

DROP TABLE IF EXISTS `dm_support`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dm_support` (
  `supportID` int(11) NOT NULL auto_increment,
  `deviceID` varchar(255) default NULL,
  `supportType` varchar(255) default NULL,
  `support` int(11) default NULL,
  PRIMARY KEY  (`supportID`),
  KEY `IX_dm_support_deviceID` USING BTREE (`deviceID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `dm_support_param`
--

DROP TABLE IF EXISTS `dm_support_param`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dm_support_param` (
  `paramID` int(11) NOT NULL auto_increment,
  `paramName` varchar(255) default NULL,
  `paramValue` varchar(255) default NULL,
  `support` int(11) default NULL,
  PRIMARY KEY  (`paramID`),
  KEY `FKAAA5EE74E3A3FE9` (`support`),
  CONSTRAINT `FKAAA5EE74E3A3FE9` FOREIGN KEY (`support`) REFERENCES `dm_support` (`supportID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `dm_task`
--

DROP TABLE IF EXISTS `dm_task`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dm_task` (
  `id` int(11) NOT NULL auto_increment,
  `state` varchar(255) default NULL,
  `actionPlan` int(11) NOT NULL,
  `job` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `FK69604F7BA76DE723` (`actionPlan`),
  KEY `FK69604F7BF84B14D5` (`job`),
  CONSTRAINT `FK69604F7BA76DE723` FOREIGN KEY (`actionPlan`) REFERENCES `dm_action_plan` (`actionPlanPK`),
  CONSTRAINT `FK69604F7BF84B14D5` FOREIGN KEY (`job`) REFERENCES `dm_job` (`jobID`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `dm_users`
--

DROP TABLE IF EXISTS `dm_users`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dm_users` (
  `userPK` int(11) NOT NULL auto_increment,
  `userID` varchar(255) default NULL,
  `password` varchar(255) default NULL,
  PRIMARY KEY  (`userPK`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `dme_keystore_certs`
--

DROP TABLE IF EXISTS `dme_keystore_certs`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dme_keystore_certs` (
  `alias` varchar(255) NOT NULL,
  `object` blob NOT NULL,
  `id` varchar(50) default NULL,
  `created` datetime NOT NULL,
  `subjectdn` varchar(450) NOT NULL,
  `isCA` bit(1) default NULL,
  `displaySubject` varchar(100) default NULL,
  `displayIssuer` varchar(100) default NULL,
  `expirationDate` datetime default NULL,
  PRIMARY KEY  (`alias`),
  KEY `IX_dme_keystore_certs_id` (`id`),
  KEY `IX_dme_keystore_certs_subjectdn` (`subjectdn`(255))
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `dme_keystore_crl_ap`
--

DROP TABLE IF EXISTS `dme_keystore_crl_ap`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dme_keystore_crl_ap` (
  `issuer` varchar(255) NOT NULL,
  `ap` varchar(255) NOT NULL,
  PRIMARY KEY  (`issuer`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `dme_keystore_crls`
--

DROP TABLE IF EXISTS `dme_keystore_crls`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dme_keystore_crls` (
  `issuer` varchar(255) NOT NULL,
  `source` varchar(255) NOT NULL,
  `local` varchar(255) NOT NULL,
  `accesstype` int(11) NOT NULL,
  `nextUpdate` varchar(250) NOT NULL,
  PRIMARY KEY  (`issuer`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `dme_keystore_emails`
--

DROP TABLE IF EXISTS `dme_keystore_emails`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dme_keystore_emails` (
  `alias` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  PRIMARY KEY  (`alias`,`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `dme_keystore_keys`
--

DROP TABLE IF EXISTS `dme_keystore_keys`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dme_keystore_keys` (
  `alias` varchar(255) NOT NULL,
  `object` blob,
  `type` int(11) NOT NULL,
  `created` datetime NOT NULL,
  PRIMARY KEY  (`alias`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `dme_report`
--

DROP TABLE IF EXISTS `dme_report`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dme_report` (
  `reportID` int(11) NOT NULL auto_increment,
  `reportFile` varchar(250) default NULL,
  `reportName` varchar(250) default NULL,
  `reportCategory` varchar(250) default NULL,
  `isRunnable` bit(1) default NULL,
  `isHidden` bit(1) default NULL,
  PRIMARY KEY  (`reportID`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `dme_servicemonitor_failures`
--

DROP TABLE IF EXISTS `dme_servicemonitor_failures`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dme_servicemonitor_failures` (
  `failureID` int(11) NOT NULL auto_increment,
  `message` text,
  `host` varchar(250) default NULL,
  `port` int(11) default NULL,
  `time` datetime default NULL,
  `serviceType` varchar(250) default NULL,
  `duration_seconds` int(11) default NULL,
  PRIMARY KEY  (`failureID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `dme_traffic`
--

DROP TABLE IF EXISTS `dme_traffic`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dme_traffic` (
  `terminalID` varchar(50) NOT NULL,
  `callID` varchar(32) NOT NULL,
  `timeZone` tinyint(4) default NULL,
  `bytesSent` bigint(20) default NULL,
  `bytesReceived` bigint(20) default NULL,
  `userID` varchar(50) default NULL,
  `phoneNumber` varchar(35) default NULL,
  `imsi` varchar(40) default NULL,
  `trafficType` varchar(250) default NULL,
  `started` datetime default NULL,
  `isRoaming` bit(1) NOT NULL,
  `intMcc` int(11) default NULL,
  `intMnc` int(11) default NULL,
  `extMcc` int(11) default NULL,
  `callType` tinyint(4) default NULL,
  `duration_in` int(11) default NULL,
  `duration_out` int(11) default NULL,
  `registrated` datetime default NULL,
  PRIMARY KEY  (`terminalID`,`callID`),
  KEY `IX_dme_traffic_userId_trafficType` (`userID`,`trafficType`),
  KEY `IX_dme_traffic_terminalID_trafficType` (`terminalID`,`trafficType`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `dme_voice_locator`
--

DROP TABLE IF EXISTS `dme_voice_locator`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dme_voice_locator` (
  `mcc` int(11) NOT NULL,
  `countryCode` varchar(80) default NULL,
  `cc` varchar(3) default NULL,
  `idd` varchar(50) default NULL,
  PRIMARY KEY  (`mcc`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `dme_voice_locator_area`
--

DROP TABLE IF EXISTS `dme_voice_locator_area`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dme_voice_locator_area` (
  `areacode` int(11) NOT NULL,
  `mcc` int(11) default NULL,
  `cc` int(11) default NULL,
  `areaname` varchar(50) default NULL,
  PRIMARY KEY  (`areacode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `dme_voice_locator_name`
--

DROP TABLE IF EXISTS `dme_voice_locator_name`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dme_voice_locator_name` (
  `mcc` int(11) NOT NULL,
  `mnc` int(11) NOT NULL,
  `name` varchar(50) default NULL,
  PRIMARY KEY  (`mcc`,`mnc`),
  CONSTRAINT `FK556796A48E5C98B4` FOREIGN KEY (`mcc`) REFERENCES `dme_voice_locator` (`mcc`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `domain`
--

DROP TABLE IF EXISTS `domain`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `domain` (
  `id` int(11) NOT NULL auto_increment,
  `modBy` varchar(45) default NULL,
  `modDate` datetime default NULL,
  `name` varchar(128) NOT NULL,
  `url` varchar(128) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`),
  UNIQUE KEY `url` (`url`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `downloadLinks`
--

DROP TABLE IF EXISTS `downloadLinks`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `downloadLinks` (
  `id` varchar(250) NOT NULL,
  `messageID` varchar(255) default NULL,
  `terminalID` varchar(50) default NULL,
  `created` datetime default NULL,
  `phoneNr` varchar(50) default NULL,
  `updatefileID` varchar(250) default NULL,
  `downloaded` bit(1) default NULL,
  `distributionType` varchar(255) default NULL,
  `downloadType` varchar(255) default NULL,
  `provisioningType` varchar(255) default NULL,
  `queued` datetime default NULL,
  `status` mediumblob,
  `jobGroup` varchar(255) default NULL,
  PRIMARY KEY  (`id`),
  KEY `IX_downloadlinks_created` USING BTREE (`created`),
  KEY `FKD5AC11166BE886` (`jobGroup`),
  CONSTRAINT `FKD5AC11166BE886` FOREIGN KEY (`jobGroup`) REFERENCES `prov_job_group` (`groupID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `folderSettings`
--

DROP TABLE IF EXISTS `folderSettings`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `folderSettings` (
  `folderID` varchar(50) NOT NULL,
  `link` varchar(250) NOT NULL,
  `terminalID` varchar(50) NOT NULL,
  `daysBack` int(11) default NULL,
  `includeInSync` tinyint(4) default NULL,
  `includeInScan` tinyint(4) default NULL,
  `isPseudoFolder` tinyint(4) default NULL,
  `headersOnly` tinyint(4) default NULL,
  `useDefaultSettings` tinyint(4) default NULL,
  PRIMARY KEY  (`folderID`),
  KEY `IX_folderSettings_terminalID_link` USING BTREE (`terminalID`,`link`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `groupGraph`
--

DROP TABLE IF EXISTS `groupGraph`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `groupGraph` (
  `groupID` int(11) NOT NULL auto_increment,
  `ldapGroup` varchar(250) NOT NULL,
  `ldapServer` varchar(250) NOT NULL,
  `lft` int(11) default NULL,
  `rgt` int(11) default NULL,
  PRIMARY KEY  (`groupID`),
  KEY `IX_groupGraph_ldapGroup` (`ldapGroup`),
  KEY `IX_groupGraph_lft_rgt` USING BTREE (`lft`,`rgt`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `groupsupportedsettings`
--

DROP TABLE IF EXISTS `groupsupportedsettings`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `groupsupportedsettings` (
  `localGroupId` int(11) NOT NULL,
  `settingsName` varchar(250) NOT NULL,
  `settingsId` int(11) NOT NULL,
  PRIMARY KEY  (`localGroupId`,`settingsName`),
  KEY `FK8F8CFA32B0BBAE7C` (`localGroupId`),
  KEY `FK8F8CFA3212E5A3D9` (`settingsId`),
  CONSTRAINT `FK8F8CFA3212E5A3D9` FOREIGN KEY (`settingsId`) REFERENCES `settings` (`id`),
  CONSTRAINT `FK8F8CFA32B0BBAE7C` FOREIGN KEY (`localGroupId`) REFERENCES `localGroup` (`groupID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `homeMobileNetworks`
--

DROP TABLE IF EXISTS `homeMobileNetworks`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `homeMobileNetworks` (
  `networkID` varchar(150) NOT NULL,
  `name` varchar(50) default NULL,
  `country` varchar(50) NOT NULL,
  `mcc` int(11) NOT NULL,
  `mnc` int(11) NOT NULL,
  PRIMARY KEY  (`networkID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `homeRates`
--

DROP TABLE IF EXISTS `homeRates`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `homeRates` (
  `homeRatesID` int(11) NOT NULL auto_increment,
  `domesticMms` decimal(10,4) default NULL,
  `domesticRate` decimal(10,4) default NULL,
  `domesticSms` decimal(10,4) default NULL,
  `includedMms` int(11) NOT NULL,
  `includedSms` int(11) NOT NULL,
  `includedTrafficMB` int(11) NOT NULL,
  `includedVoice` int(11) NOT NULL,
  `internationalMms` decimal(10,4) default NULL,
  `internationalRate` decimal(10,4) default NULL,
  `internationalSms` decimal(10,4) default NULL,
  `receiving` decimal(10,4) default NULL,
  `trafficMB` decimal(10,4) default NULL,
  PRIMARY KEY  (`homeRatesID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `localGroup`
--

DROP TABLE IF EXISTS `localGroup`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `localGroup` (
  `groupID` int(11) NOT NULL auto_increment,
  `changedDate` datetime default NULL,
  `description` varchar(250) default NULL,
  `hierarchyLocation` float NOT NULL,
  `ldapGroup` varchar(250) default NULL,
  `ldapServer` varchar(250) default NULL,
  `licenseID` varchar(100) default NULL,
  `name` varchar(250) NOT NULL,
  `priority` int(11) default NULL,
  `type` varchar(128) NOT NULL,
  `domainId` int(11) NOT NULL,
  PRIMARY KEY  (`groupID`),
  UNIQUE KEY `domainId` (`domainId`,`name`,`type`),
  KEY `FK4C6211D4302204BC` (`domainId`),
  CONSTRAINT `FK4C6211D4302204BC` FOREIGN KEY (`domainId`) REFERENCES `domain` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `localGroupRessourceNotification`
--

DROP TABLE IF EXISTS `localGroupRessourceNotification`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `localGroupRessourceNotification` (
  `localGroupID` int(11) NOT NULL,
  `ressourceID` int(11) NOT NULL,
  `schemeID` int(11) default NULL,
  PRIMARY KEY  (`localGroupID`,`ressourceID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `logTable`
--

DROP TABLE IF EXISTS `logTable`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `logTable` (
  `lineNo` int(11) NOT NULL auto_increment,
  `message` text,
  `category` varchar(50) default NULL,
  `level` int(11) NOT NULL,
  `NDC` varchar(100) default NULL,
  `terminalID` varchar(50) default NULL,
  `userID` varchar(50) default NULL,
  `created` datetime default NULL,
  `simpleMessage` varchar(250) default NULL,
  `functionCategory` varchar(255) default NULL,
  `exceptionId` varchar(32) default NULL,
  `originatingId` varchar(128) default NULL,
  PRIMARY KEY  (`lineNo`),
  KEY `IX_logTable_category` (`category`),
  KEY `IX_logTable_exceptionId` (`exceptionId`),
  KEY `IX_logTable_userID_terminalID_created` USING BTREE (`userID`,`terminalID`,`created`)
) ENGINE=InnoDB AUTO_INCREMENT=117 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `message`
--

DROP TABLE IF EXISTS `message`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `message` (
  `id` varchar(250) NOT NULL,
  `type` varchar(50) default NULL,
  `obj` blob,
  `status` int(11) default NULL,
  `lastUpdate` datetime default NULL,
  `created` datetime default NULL,
  `sentTo` varchar(40) default NULL,
  `statusText` varchar(50) default NULL,
  `notificationType` varchar(250) default NULL,
  `dlr` smallint(6) default NULL,
  `queued` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `notificationRessource`
--

DROP TABLE IF EXISTS `notificationRessource`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `notificationRessource` (
  `ressourceID` int(11) NOT NULL,
  `name` varchar(100) default NULL,
  `type` varchar(100) default NULL,
  `defaultSchemeID` int(11) default NULL,
  PRIMARY KEY  (`ressourceID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `notificationScheme`
--

DROP TABLE IF EXISTS `notificationScheme`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `notificationScheme` (
  `schemeID` int(11) NOT NULL auto_increment,
  `priority` int(11) default NULL,
  `enabled` bit(1) NOT NULL,
  `maxNotifications` int(11) default NULL,
  `notificationCenter` varchar(100) default NULL,
  PRIMARY KEY  (`schemeID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `notificationSubscription`
--

DROP TABLE IF EXISTS `notificationSubscription`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `notificationSubscription` (
  `subscriptionID` varchar(100) NOT NULL,
  `terminalID` varchar(50) NOT NULL,
  `userID` varchar(50) NOT NULL,
  `resourceID` int(11) NOT NULL,
  `connectorID` varchar(50) NOT NULL,
  `keepaliveTimestamp` datetime NOT NULL,
  `daySchemeID` int(11) NOT NULL,
  PRIMARY KEY  (`subscriptionID`),
  KEY `IX_notificationSubscription__terminalID__resourceID` (`terminalID`,`resourceID`),
  KEY `IX_notificationSubscription__created` (`keepaliveTimestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `onlineDevices`
--

DROP TABLE IF EXISTS `onlineDevices`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `onlineDevices` (
  `deviceID` varchar(50) NOT NULL,
  `serverName` varchar(100) NOT NULL,
  PRIMARY KEY  (`deviceID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `pendingNotifications`
--

DROP TABLE IF EXISTS `pendingNotifications`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `pendingNotifications` (
  `terminalID` varchar(50) NOT NULL,
  `ressourceID` int(11) NOT NULL,
  `status` int(11) default NULL,
  `created` datetime default NULL,
  `extras` int(11) default NULL,
  `SMSmessageID` varchar(250) default NULL,
  PRIMARY KEY  (`terminalID`,`ressourceID`),
  UNIQUE KEY `IX_Unique_pendingNotifications_SMSmessageID` (`SMSmessageID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `pre_cache_connector`
--

DROP TABLE IF EXISTS `pre_cache_connector`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `pre_cache_connector` (
  `terminalID` varchar(50) NOT NULL,
  `function` varchar(128) NOT NULL,
  `preCacheState` varchar(50) NOT NULL,
  `connectorId` varchar(50) NOT NULL,
  PRIMARY KEY  (`terminalID`,`function`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `preferredMobileNetworks`
--

DROP TABLE IF EXISTS `preferredMobileNetworks`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `preferredMobileNetworks` (
  `mcc` int(11) NOT NULL,
  `mnc` int(11) NOT NULL,
  `homenetworkID` varchar(150) NOT NULL,
  `name` varchar(50) default NULL,
  PRIMARY KEY  (`mcc`,`mnc`,`homenetworkID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `prov_iphone_cacertificate`
--

DROP TABLE IF EXISTS `prov_iphone_cacertificate`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `prov_iphone_cacertificate` (
  `certificateID` int(11) NOT NULL auto_increment,
  `certificate` blob,
  `defaultCA` bit(1) default NULL,
  `encryptedkeyPair` blob,
  `subjectdn` varchar(450) default NULL,
  PRIMARY KEY  (`certificateID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `prov_iphone_configuration_profile`
--

DROP TABLE IF EXISTS `prov_iphone_configuration_profile`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `prov_iphone_configuration_profile` (
  `profileID` varchar(255) NOT NULL,
  `category` varchar(255) default NULL,
  `changeDate` datetime default NULL,
  `content` longblob,
  `description` varchar(255) default NULL,
  `fileName` varchar(255) default NULL,
  `hash` varchar(255) default NULL,
  `identifier` varchar(255) default NULL,
  `name` varchar(255) default NULL,
  `smsCode` varchar(255) default NULL,
  `uuid` varchar(255) default NULL,
  `encrypted` bit(1) default NULL,
  `organization` varchar(255) default NULL,
  `signed` bit(1) default NULL,
  PRIMARY KEY  (`profileID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `prov_iphone_enrollment`
--

DROP TABLE IF EXISTS `prov_iphone_enrollment`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `prov_iphone_enrollment` (
  `enrollmentID` varchar(40) NOT NULL,
  `apnInfo` blob,
  `apnToken` varchar(255) default NULL,
  `certificate` blob,
  `challenge` varchar(100) default NULL,
  `created` datetime default NULL,
  `deviceID` varchar(50) default NULL,
  `lastState` varchar(60) default NULL,
  `lastStatusDate` datetime default NULL,
  `phoneNumber` varchar(50) default NULL,
  `status` blob,
  `subject` varchar(255) default NULL,
  `caCertificate` int(11) default NULL,
  `userID` varchar(255) default NULL,
  PRIMARY KEY  (`enrollmentID`),
  KEY `IX_pie_subject` (`subject`),
  KEY `IX_pie_apnToken` (`apnToken`),
  KEY `IX_pie_deviceID` (`deviceID`),
  KEY `IX_pie_lastStatusDate` (`lastStatusDate`),
  KEY `FK1C594B47DF152` (`caCertificate`),
  CONSTRAINT `FK1C594B47DF152` FOREIGN KEY (`caCertificate`) REFERENCES `prov_iphone_cacertificate` (`certificateID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `prov_iphone_installed_certificates`
--

DROP TABLE IF EXISTS `prov_iphone_installed_certificates`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `prov_iphone_installed_certificates` (
  `installedCertificateID` int(11) NOT NULL auto_increment,
  `certificate` mediumblob,
  `name` varchar(255) default NULL,
  `updateDate` datetime default NULL,
  `enrollment` varchar(255) default NULL,
  PRIMARY KEY  (`installedCertificateID`),
  KEY `FKA7BBEEE51D155C49` (`enrollment`),
  CONSTRAINT `FKA7BBEEE51D155C49` FOREIGN KEY (`enrollment`) REFERENCES `prov_iphone_enrollment` (`enrollmentID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `prov_iphone_installed_profiles`
--

DROP TABLE IF EXISTS `prov_iphone_installed_profiles`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `prov_iphone_installed_profiles` (
  `installedProfileID` int(11) NOT NULL auto_increment,
  `created` datetime default NULL,
  `groupInstall` int(11) default NULL,
  `hash` varchar(255) default NULL,
  `identifier` varchar(255) default NULL,
  `markForRemove` bit(1) default NULL,
  `profile` blob,
  `profileType` varchar(255) default NULL,
  `uuid` varchar(255) default NULL,
  `enrollment` varchar(255) default NULL,
  `iphoneProfile` varchar(255) default NULL,
  PRIMARY KEY  (`installedProfileID`),
  KEY `FK2CCA5931D155C49` (`enrollment`),
  CONSTRAINT `FK2CCA5931D155C49` FOREIGN KEY (`enrollment`) REFERENCES `prov_iphone_enrollment` (`enrollmentID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `prov_iphone_installed_restrictions`
--

DROP TABLE IF EXISTS `prov_iphone_installed_restrictions`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `prov_iphone_installed_restrictions` (
  `installedRestrictionID` int(11) NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `restrictions` blob,
  `updateDate` datetime default NULL,
  `enrollment` varchar(255) default NULL,
  PRIMARY KEY  (`installedRestrictionID`),
  KEY `FK4BC163501D155C49` (`enrollment`),
  CONSTRAINT `FK4BC163501D155C49` FOREIGN KEY (`enrollment`) REFERENCES `prov_iphone_enrollment` (`enrollmentID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `prov_iphone_operations`
--

DROP TABLE IF EXISTS `prov_iphone_operations`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `prov_iphone_operations` (
  `operationID` int(11) NOT NULL auto_increment,
  `createdDate` datetime default NULL,
  `lastStatus` varchar(50) default NULL,
  `lastStatusDate` datetime default NULL,
  `mdmRequest` longblob,
  `meta` varchar(100) default NULL,
  `requestType` varchar(50) default NULL,
  `requestUUID` varchar(60) default NULL,
  `status` mediumblob,
  `enrollment` varchar(40) default NULL,
  `queueDate` datetime default NULL,
  `waitForOperationID` int(11) default NULL,
  `waitPath` varchar(255) default NULL,
  `waitSendIf` varchar(255) default NULL,
  `jobGroup` varchar(255) default NULL,
  PRIMARY KEY  (`operationID`),
  KEY `IX_pio_lastStatusDate` (`lastStatusDate`),
  KEY `FK3837383939383` (`enrollment`),
  KEY `FKA0C2D270166BE886` (`jobGroup`),
  CONSTRAINT `FKA0C2D270166BE886` FOREIGN KEY (`jobGroup`) REFERENCES `prov_job_group` (`groupID`),
  CONSTRAINT `FK3837383939383` FOREIGN KEY (`enrollment`) REFERENCES `prov_iphone_enrollment` (`enrollmentID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `prov_iphone_profile_group`
--

DROP TABLE IF EXISTS `prov_iphone_profile_group`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `prov_iphone_profile_group` (
  `groupId` int(11) NOT NULL,
  `profileID` varchar(100) NOT NULL,
  PRIMARY KEY  (`groupId`,`profileID`),
  KEY `FKBEDD0765694CAC47` (`groupId`),
  CONSTRAINT `FKBEDD0765694CAC47` FOREIGN KEY (`groupId`) REFERENCES `localGroup` (`groupID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `prov_iphone_provisioning_profile`
--

DROP TABLE IF EXISTS `prov_iphone_provisioning_profile`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `prov_iphone_provisioning_profile` (
  `profileID` varchar(255) NOT NULL,
  `category` varchar(255) default NULL,
  `changeDate` datetime default NULL,
  `content` longblob,
  `description` varchar(255) default NULL,
  `fileName` varchar(255) default NULL,
  `hash` varchar(255) default NULL,
  `identifier` varchar(255) default NULL,
  `name` varchar(255) default NULL,
  `smsCode` varchar(255) default NULL,
  `uuid` varchar(255) default NULL,
  `expirationDate` datetime default NULL,
  PRIMARY KEY  (`profileID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `prov_job_group`
--

DROP TABLE IF EXISTS `prov_job_group`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `prov_job_group` (
  `groupID` varchar(255) NOT NULL,
  `createdDate` datetime default NULL,
  `description` varchar(255) default NULL,
  `groupType` varchar(255) default NULL,
  `operation` varchar(255) default NULL,
  `scheduled` mediumblob,
  PRIMARY KEY  (`groupID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `roamingRates`
--

DROP TABLE IF EXISTS `roamingRates`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `roamingRates` (
  `roamingRatesID` int(11) NOT NULL auto_increment,
  `internationalRate` decimal(10,4) default NULL,
  `mmsRate` decimal(10,4) default NULL,
  `smsRate` decimal(10,4) default NULL,
  `trafficMB` decimal(10,4) default NULL,
  PRIMARY KEY  (`roamingRatesID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `role`
--

DROP TABLE IF EXISTS `role`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `role` (
  `roleID` varchar(100) NOT NULL,
  `description` varchar(255) default NULL,
  `webRole` smallint(6) default NULL,
  `loginRoleID` varchar(50) default NULL,
  PRIMARY KEY  (`roleID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `roleFunction`
--

DROP TABLE IF EXISTS `roleFunction`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `roleFunction` (
  `roleID` varchar(100) NOT NULL,
  `functionID` varchar(30) NOT NULL,
  `allowed` int(11) NOT NULL,
  PRIMARY KEY  (`roleID`,`functionID`,`allowed`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `rssfeeds`
--

DROP TABLE IF EXISTS `rssfeeds`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `rssfeeds` (
  `feedID` int(11) NOT NULL auto_increment,
  `authentificationType` tinyint(4) default NULL,
  `eTag` varchar(255) default NULL,
  `lastModified` datetime default NULL,
  `link` varchar(2048) default NULL,
  `linkHash` varchar(32) default NULL,
  `localGroupID` varchar(5) default NULL,
  `userID` varchar(50) default NULL,
  PRIMARY KEY  (`feedID`),
  UNIQUE KEY `userID` (`userID`,`localGroupID`,`linkHash`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `scanTable`
--

DROP TABLE IF EXISTS `scanTable`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `scanTable` (
  `id` int(11) NOT NULL auto_increment,
  `link` varchar(4000) NOT NULL,
  `folder` varchar(250) NOT NULL,
  `terminalID` varchar(50) NOT NULL,
  `md5sum` varchar(32) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `IX_scantable_terminalID_folder` USING BTREE (`terminalID`,`folder`),
  KEY `IX_scantable_terminalID_link` (`terminalID`,`link`(255))
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sequence`
--

DROP TABLE IF EXISTS `sequence`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sequence` (
  `name` varchar(64) NOT NULL,
  `last_val` int(11) NOT NULL,
  PRIMARY KEY  (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `settings`
--

DROP TABLE IF EXISTS `settings`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `settings` (
  `id` int(11) NOT NULL auto_increment,
  `changedBy` varchar(50) default NULL,
  `changedDate` datetime default NULL,
  `intervalSetting` varchar(250) default NULL,
  `lockInterval` int(11) default NULL,
  `lockOnSuperUser` int(11) default NULL,
  `lockOnTerminal` int(11) default NULL,
  `name` varchar(250) default NULL,
  `noLicense` int(11) default NULL,
  `value` varchar(2048) NOT NULL,
  `localGroupId` int(11) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `localGroupId` (`localGroupId`,`name`),
  KEY `FK5582BC23B0BBAE7C` (`localGroupId`),
  CONSTRAINT `FK5582BC23B0BBAE7C` FOREIGN KEY (`localGroupId`) REFERENCES `localGroup` (`groupID`)
) ENGINE=InnoDB AUTO_INCREMENT=378 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `settingsHistory`
--

DROP TABLE IF EXISTS `settingsHistory`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `settingsHistory` (
  `settingID` int(11) NOT NULL auto_increment,
  `name` varchar(250) NOT NULL,
  `value` varchar(2048) NOT NULL,
  `terminalID` varchar(50) default NULL,
  `localGroupID` varchar(5) default NULL,
  `userID` varchar(50) default NULL,
  `lockOnTerminal` int(11) default NULL,
  `intervalSetting` varchar(250) default NULL,
  `changedDate` datetime default NULL,
  `inUse` int(11) default NULL,
  PRIMARY KEY  (`settingID`),
  KEY `IX_settingsHistory_localGroupID` USING BTREE (`localGroupID`),
  KEY `IX_settingsHistory_terminalID_name` USING BTREE (`terminalID`,`name`),
  KEY `IX_settingsHistory_userID_terminalID_name` (`userID`,`terminalID`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `settingsType`
--

DROP TABLE IF EXISTS `settingsType`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `settingsType` (
  `name` varchar(250) NOT NULL,
  `resource` varchar(250) default NULL,
  `type` varchar(30) NOT NULL,
  `options` varchar(1024) default NULL,
  `groupBy` varchar(100) default NULL,
  `maxInterval` varchar(250) default NULL,
  `cdata` int(11) default NULL,
  `belongsTo` varchar(50) default NULL,
  `sortBy` int(11) default NULL,
  `useInterval` int(11) default NULL,
  PRIMARY KEY  (`name`),
  KEY `IX_settingsType_type` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `sim`
--

DROP TABLE IF EXISTS `sim`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sim` (
  `simID` varchar(250) NOT NULL,
  `terminalID` varchar(50) default NULL,
  `pin1` varchar(250) default NULL,
  `pin2` varchar(250) default NULL,
  `puk1` varchar(250) default NULL,
  `puk2` varchar(250) default NULL,
  PRIMARY KEY  (`simID`),
  KEY `IX_sim_terminalID` (`terminalID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `subscriptions`
--

DROP TABLE IF EXISTS `subscriptions`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `subscriptions` (
  `subscriptionId` int(11) NOT NULL auto_increment,
  `currency` varchar(255) NOT NULL,
  `edited` datetime NOT NULL,
  `lastIntervalReset` datetime default NULL,
  `name` varchar(255) NOT NULL,
  `resetInterval` varchar(255) default NULL,
  `storedToSettings` bit(1) NOT NULL,
  `homeRates` int(11) default NULL,
  `mcc` int(11) NOT NULL,
  `mnc` int(11) NOT NULL,
  `roamingRates` int(11) default NULL,
  PRIMARY KEY  (`subscriptionId`),
  UNIQUE KEY `name` (`name`),
  KEY `FK7674CAF62B13F27F` (`roamingRates`),
  KEY `FK7674CAF6895906C8` (`mcc`,`mnc`),
  KEY `FK7674CAF667B6CF7D` (`homeRates`),
  CONSTRAINT `FK7674CAF667B6CF7D` FOREIGN KEY (`homeRates`) REFERENCES `homeRates` (`homeRatesID`),
  CONSTRAINT `FK7674CAF62B13F27F` FOREIGN KEY (`roamingRates`) REFERENCES `roamingRates` (`roamingRatesID`),
  CONSTRAINT `FK7674CAF6895906C8` FOREIGN KEY (`mcc`, `mnc`) REFERENCES `dme_voice_locator_name` (`mcc`, `mnc`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `supportedFields`
--

DROP TABLE IF EXISTS `supportedFields`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `supportedFields` (
  `supportedFieldID` int(11) NOT NULL auto_increment,
  `field` varchar(50) NOT NULL,
  `method` varchar(30) NOT NULL,
  `type` varchar(30) NOT NULL,
  `terminalID` varchar(50) NOT NULL,
  PRIMARY KEY  (`supportedFieldID`),
  KEY `IX_supportedFields_terminalID_type` USING BTREE (`terminalID`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `syncAttachmentTable`
--

DROP TABLE IF EXISTS `syncAttachmentTable`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `syncAttachmentTable` (
  `syncID` varchar(50) NOT NULL,
  `attachmentID` varchar(32) NOT NULL,
  `folder` varchar(100) default NULL,
  `link` varchar(4000) NOT NULL,
  `tx` varchar(38) default NULL,
  `modyfied` datetime default NULL,
  PRIMARY KEY  (`syncID`,`attachmentID`),
  KEY `IX_syncAttachmentTable_tx` (`tx`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `syncTable`
--

DROP TABLE IF EXISTS `syncTable`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `syncTable` (
  `syncID` varchar(50) NOT NULL,
  `link` varchar(4000) NOT NULL,
  `metadata` blob,
  `folder` varchar(100) default NULL,
  `terminalID` varchar(50) NOT NULL,
  `tx` varchar(38) default NULL,
  `md5sum` varchar(32) NOT NULL,
  `modyfied` datetime default NULL,
  PRIMARY KEY  (`syncID`),
  KEY `IX_syncTable_terminalID_folder` (`terminalID`,`folder`),
  KEY `IX_syncTable_terminalID_link` USING BTREE (`terminalID`,`link`(255)),
  KEY `IX_syncTable_tx` USING BTREE (`tx`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `tempData`
--

DROP TABLE IF EXISTS `tempData`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tempData` (
  `keyField` varchar(255) NOT NULL,
  `dataField` blob,
  PRIMARY KEY  (`keyField`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `terminal`
--

DROP TABLE IF EXISTS `terminal`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `terminal` (
  `terminalID` varchar(50) NOT NULL,
  `locked` bit(1) NOT NULL,
  `inUse` bit(1) NOT NULL,
  `localGroup` varchar(5) default NULL,
  `created` datetime default NULL,
  `licenseID` varchar(100) default NULL,
  `licenseChanged` datetime default NULL,
  `lockedChanged` datetime default NULL,
  PRIMARY KEY  (`terminalID`),
  KEY `IX_terminal_localGroup` (`localGroup`),
  KEY `IX_terminal_terminalID_locked` (`terminalID`,`locked`),
  KEY `IX_terminal_licenseID_inUse` (`licenseID`,`inUse`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `terminalAssetMgmt`
--

DROP TABLE IF EXISTS `terminalAssetMgmt`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `terminalAssetMgmt` (
  `terminalId` varchar(50) NOT NULL,
  `purchaseDate` datetime default NULL,
  `warrantyExpirationDate` datetime default NULL,
  `supplier` varchar(100) default NULL,
  `invoiceNo` varchar(100) default NULL,
  `purchaseOrder` varchar(100) default NULL,
  `requisition` varchar(100) default NULL,
  `purchasePrice` varchar(100) default NULL,
  `serviceLog` longtext,
  `text1` longtext,
  `text2` longtext,
  `text3` longtext,
  `date1` datetime default NULL,
  `date2` datetime default NULL,
  `date3` datetime default NULL,
  `shortText1` varchar(100) default NULL,
  `shortText2` varchar(100) default NULL,
  `shortText3` varchar(100) default NULL,
  PRIMARY KEY  (`terminalId`),
  CONSTRAINT `FK1C341CB5490769CC` FOREIGN KEY (`terminalId`) REFERENCES `terminal` (`terminalID`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `terminalGroupMembership`
--

DROP TABLE IF EXISTS `terminalGroupMembership`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `terminalGroupMembership` (
  `localGroupID` int(11) NOT NULL,
  `terminalID` varchar(50) NOT NULL,
  `groupType` varchar(255) default NULL,
  PRIMARY KEY  (`terminalID`,`localGroupID`),
  KEY `IX_terminalGroupMembership_localGroupID` (`localGroupID`),
  CONSTRAINT `FK3355E599B0BBAE7C` FOREIGN KEY (`localGroupID`) REFERENCES `localGroup` (`groupID`),
  CONSTRAINT `FK3355E599490769CC` FOREIGN KEY (`terminalID`) REFERENCES `terminal` (`terminalID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `terminalGroupMembership_tmp`
--

DROP TABLE IF EXISTS `terminalGroupMembership_tmp`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `terminalGroupMembership_tmp` (
  `terminalID` varchar(50) NOT NULL,
  `localGroupID` int(11) NOT NULL,
  `groupType` varchar(255) default NULL,
  PRIMARY KEY  (`terminalID`,`localGroupID`),
  KEY `IX_terminalGroupMembershipTMP_localGroupID` (`localGroupID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `terminalOwner`
--

DROP TABLE IF EXISTS `terminalOwner`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `terminalOwner` (
  `terminalID` varchar(50) NOT NULL,
  `userID` varchar(50) default NULL,
  PRIMARY KEY  (`terminalID`),
  KEY `IX_terminalOwner_userID_terminalID` USING BTREE (`userID`,`terminalID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `terminalOwnerHistory`
--

DROP TABLE IF EXISTS `terminalOwnerHistory`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `terminalOwnerHistory` (
  `id` int(11) NOT NULL auto_increment,
  `terminalID` varchar(50) NOT NULL,
  `userID` varchar(50) NOT NULL,
  `firstUsed` datetime NOT NULL,
  `lastUsed` datetime NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `IX_terminalOwnerHistory_terminalID_userID` USING BTREE (`terminalID`,`userID`),
  KEY `IX_terminalOwnerHistory_userID_terminalID` USING BTREE (`userID`,`terminalID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `terminalProperty`
--

DROP TABLE IF EXISTS `terminalProperty`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `terminalProperty` (
  `property` varchar(150) NOT NULL,
  `terminalID` varchar(50) NOT NULL,
  `value` varchar(250) default NULL,
  `type` varchar(250) default NULL,
  `changed` datetime default NULL,
  `owner` varchar(255) default NULL,
  PRIMARY KEY  (`property`,`terminalID`),
  KEY `IX_terminalProperty_terminalID` USING BTREE (`terminalID`),
  CONSTRAINT `FKD3B39871490769CC` FOREIGN KEY (`terminalID`) REFERENCES `terminal` (`terminalID`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `terminalRessourceNotification`
--

DROP TABLE IF EXISTS `terminalRessourceNotification`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `terminalRessourceNotification` (
  `terminalID` varchar(50) NOT NULL,
  `ressourceID` int(11) NOT NULL,
  `schemeID` int(11) default NULL,
  `calculatedNextPoll` datetime default NULL,
  `lastPoll` datetime default NULL,
  `lastSync` datetime default NULL,
  `lastNotifications` varchar(255) default NULL,
  `lastNotification` datetime default NULL,
  `lastFullPoll` datetime default NULL,
  `lastSubscriptionWatermark` varchar(60) default NULL,
  `calculatedGroupSchemeID` int(11) default NULL,
  `retries` int(11) NOT NULL default '0',
  `outstanding` int(11) NOT NULL default '0',
  `nextScanServer` varchar(200) default NULL,
  `errorMessage` varchar(1024) default NULL,
  `checkSubscriptionEvent` bit(1) NOT NULL default b'0',
  PRIMARY KEY  (`terminalID`,`ressourceID`),
  KEY `IX_terminalRessourceNotification_schemeID` (`schemeID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `tinyCDR`
--

DROP TABLE IF EXISTS `tinyCDR`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tinyCDR` (
  `tinyCDRID` int(11) NOT NULL auto_increment,
  `dispatchStatus` varchar(255) default NULL,
  `traffic_callID` varchar(32) default NULL,
  `traffic_terminalID` varchar(50) default NULL,
  PRIMARY KEY  (`tinyCDRID`),
  KEY `FKB1C5D1112061D4A7` (`traffic_terminalID`,`traffic_callID`),
  CONSTRAINT `FKB1C5D1112061D4A7` FOREIGN KEY (`traffic_terminalID`, `traffic_callID`) REFERENCES `dme_traffic` (`terminalID`, `callID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `tx_syncAttachmentTable`
--

DROP TABLE IF EXISTS `tx_syncAttachmentTable`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tx_syncAttachmentTable` (
  `syncID` varchar(50) NOT NULL,
  `attachmentID` varchar(32) NOT NULL,
  `link` varchar(4000) NOT NULL,
  `folder` varchar(100) default NULL,
  `tx` varchar(38) default NULL,
  `modyfied` datetime default NULL,
  PRIMARY KEY  (`syncID`,`attachmentID`),
  KEY `IX_tx_syncAttachmentTable_tx` (`tx`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `tx_syncTable`
--

DROP TABLE IF EXISTS `tx_syncTable`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tx_syncTable` (
  `syncID` varchar(50) NOT NULL,
  `link` varchar(4000) NOT NULL,
  `metadata` blob,
  `folder` varchar(100) default NULL,
  `terminalID` varchar(50) NOT NULL,
  `tx` varchar(38) default NULL,
  `md5sum` varchar(32) NOT NULL,
  `modyfied` datetime default NULL,
  PRIMARY KEY  (`syncID`),
  KEY `IX_tx_syncTable_terminalID_folder` (`terminalID`,`folder`),
  KEY `IX_tx_syncTable_terminalID_tx` USING BTREE (`terminalID`,`tx`),
  KEY `IX_tx_synctable_terminalID_link` (`terminalID`,`link`(255))
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `uniqueKey`
--

DROP TABLE IF EXISTS `uniqueKey`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `uniqueKey` (
  `keyValue` varchar(250) NOT NULL,
  `terminalID` varchar(50) default NULL,
  `phoneNumber` varchar(50) default NULL,
  PRIMARY KEY  (`keyValue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `updateProperty`
--

DROP TABLE IF EXISTS `updateProperty`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `updateProperty` (
  `updatePropertyID` int(11) NOT NULL auto_increment,
  `name` varchar(250) default NULL,
  `value` varchar(250) default NULL,
  `terminalID` varchar(50) default NULL,
  `userID` varchar(50) default NULL,
  `created` datetime default NULL,
  PRIMARY KEY  (`updatePropertyID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `userFilterGroup`
--

DROP TABLE IF EXISTS `userFilterGroup`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `userFilterGroup` (
  `userID` varchar(50) NOT NULL,
  `groupID` varchar(250) NOT NULL,
  PRIMARY KEY  (`userID`,`groupID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `userGroup`
--

DROP TABLE IF EXISTS `userGroup`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `userGroup` (
  `userID` varchar(50) NOT NULL,
  `roleID` varchar(100) NOT NULL,
  PRIMARY KEY  (`userID`,`roleID`),
  KEY `FK12E9C174D33C29E0` (`roleID`),
  CONSTRAINT `FK12E9C1748159F4BB` FOREIGN KEY (`userID`) REFERENCES `usr` (`userID`),
  CONSTRAINT `FK12E9C174D33C29E0` FOREIGN KEY (`roleID`) REFERENCES `role` (`roleID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `userLdapGroup`
--

DROP TABLE IF EXISTS `userLdapGroup`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `userLdapGroup` (
  `userID` varchar(50) NOT NULL,
  `ldapGroup` varchar(250) NOT NULL,
  `ldapServer` varchar(250) NOT NULL,
  PRIMARY KEY  (`userID`,`ldapGroup`),
  KEY `IX_userLdapGroup_ldapServer` (`ldapServer`),
  CONSTRAINT `FK645DE38D8159F4BB` FOREIGN KEY (`userID`) REFERENCES `usr` (`userID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `userProperty`
--

DROP TABLE IF EXISTS `userProperty`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `userProperty` (
  `property` varchar(150) NOT NULL,
  `userID` varchar(50) NOT NULL,
  `value` varchar(250) default NULL,
  `type` varchar(250) default NULL,
  `changed` datetime default NULL,
  PRIMARY KEY  (`property`,`userID`),
  KEY `FK970832C08159F4BB` (`userID`),
  CONSTRAINT `FK970832C08159F4BB` FOREIGN KEY (`userID`) REFERENCES `usr` (`userID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `userTerminal`
--

DROP TABLE IF EXISTS `userTerminal`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `userTerminal` (
  `terminalID` varchar(50) NOT NULL,
  `userID` varchar(50) NOT NULL,
  `lastUsed` datetime NOT NULL,
  `phoneNumber` varchar(255) default NULL,
  PRIMARY KEY  (`terminalID`,`userID`,`lastUsed`),
  KEY `FK8BD1E7678159F4BB` (`userID`),
  CONSTRAINT `FK8BD1E767490769CC` FOREIGN KEY (`terminalID`) REFERENCES `terminal` (`terminalID`) ON DELETE CASCADE,
  CONSTRAINT `FK8BD1E7678159F4BB` FOREIGN KEY (`userID`) REFERENCES `usr` (`userID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `usr`
--

DROP TABLE IF EXISTS `usr`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `usr` (
  `userID` varchar(50) NOT NULL,
  `locked` bit(1) NOT NULL,
  `password` varchar(250) default NULL,
  `userName` varchar(250) default NULL,
  `created` datetime default NULL,
  `loginFailures` int(11) default NULL,
  `occupation` varchar(250) default NULL,
  `collabPassword` varchar(250) default NULL,
  `dmeDomainName` varchar(255) default NULL,
  `userType` varchar(100) default NULL,
  PRIMARY KEY  (`userID`),
  KEY `FK1C594B47D0252` (`dmeDomainName`),
  KEY `IX_usr_userID_locked` USING BTREE (`userID`,`locked`),
  CONSTRAINT `FK1C594B47D0252` FOREIGN KEY (`dmeDomainName`) REFERENCES `DMEDomain` (`domainName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;


INSERT INTO `DME_System` (name,value) VALUES ('DATABASE_STRUCTURE_VERSION','21');

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;