/************************************************************************/
/************************************************************************/
/* DME 3.6 Database install script                                      */
/************************************************************************/
/* This script install the database structure for DME 3.6               */  
/************************************************************************/

PRINT '==========================================================================='
PRINT '* Start creating the DME database structure';

DECLARE @sql VARCHAR(2000)
SELECT @sql = 'ALTER DATABASE [' + DB_NAME() + '] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
               ALTER DATABASE [' + DB_NAME() + '] SET READ_COMMITTED_SNAPSHOT ON;
               ALTER DATABASE [' + DB_NAME() + '] SET MULTI_USER;'
EXEC(@sql);

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Apn]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[Apn](
		[apnID] [int] IDENTITY(1,1) NOT NULL,
		[name] [nvarchar](100) NULL,
		[type] [nvarchar](50) NOT NULL,
		[aph] [image] NULL,
		[lastChanged] [datetime] NULL,
	CONSTRAINT [PK__Apn] PRIMARY KEY CLUSTERED (
		[apnID] ASC	
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;



IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AppBoxApplication]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[AppBoxApplication](
		[applicationId] [nvarchar](250) NOT NULL,
		[created] [datetime] NOT NULL,
		[locked] [tinyint] NOT NULL,
		[name] [nvarchar](100) NOT NULL,
		[accessLdapGroup] [nvarchar](250) NULL,
	CONSTRAINT [PK__AppBoxApplication] PRIMARY KEY CLUSTERED (
		[applicationId] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF),
	CONSTRAINT [UQ__AppBoxApplication__name] UNIQUE NONCLUSTERED  (
		[name] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;
	

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AppBoxApplicationInfo]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[AppBoxApplicationInfo](
		[DTYPE] [nvarchar](31) NOT NULL,
		[applicationId] [nvarchar](250) NOT NULL,
		[infoKey] [nvarchar](45) NOT NULL,
		[modified] [datetime] NULL,
		[value] [nvarchar](255) NULL,
	CONSTRAINT [PK__AppBoxApplicationInfo] PRIMARY KEY CLUSTERED (
		[applicationId] ASC,
		[infoKey] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	) 
END;


IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AppBoxDeploymentInfo]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[AppBoxDeploymentInfo](
		[lineNumber] [int] IDENTITY(1,1) NOT NULL,
		[created] [datetime] NOT NULL,
		[message] [nvarchar](255) NOT NULL,
		[applicationId] [nvarchar](250) NOT NULL,
	CONSTRAINT [PK__AppBoxDeploymentInfo] PRIMARY KEY CLUSTERED (
		[lineNumber] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;
	
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AppBoxDatastore]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[AppBoxDatastore](
		[applicationId] nvarchar(250) NOT NULL, 
		[deviceId] nvarchar(50) NOT NULL, 
		[resourceId] nvarchar(45) NOT NULL, 
		[created] datetime NOT NULL, 
		[data] [ntext] NULL,
		[modified] datetime NOT NULL, 
	CONSTRAINT [PK__AppBoxDatastore] PRIMARY KEY CLUSTERED (
		[applicationId] ASC,
		[deviceId] ASC,
		[resourceId] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;
	
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AppBoxFilestore]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[AppBoxFilestore](
		[applicationId] [nvarchar](250) NOT NULL,
		[fileName] [nvarchar](150) NOT NULL,
		[created] [datetime] NOT NULL,
		[data] [image] NULL,
		[fingerprint] [nvarchar](32) NULL,
		[modified] [datetime] NOT NULL,
		[size] [numeric](19, 0) NULL,
	CONSTRAINT [PK__AppBoxFilestore] PRIMARY KEY CLUSTERED (
		[applicationId] ASC,
		[fileName] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AppBoxRequestFunction]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[AppBoxRequestFunction](
		[applicationId] nvarchar(250) NOT NULL,
		[functionName] nvarchar(45) NOT NULL, 
		[requestHandler] nvarchar(45) NOT NULL, 
		[displayName] nvarchar(150) NULL, 
		[referencedByForm] tinyint NULL, 
	CONSTRAINT [PK__AppBoxRequestFunction] PRIMARY KEY CLUSTERED (
		[applicationId] ASC,
		[functionName] ASC,
		[requestHandler] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;


IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AppBoxInstalledOn]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[AppBoxInstalledOn](
		[applicationId] [nvarchar](250) NOT NULL,
		[deviceId] [nvarchar](50) NOT NULL,
		[created] [datetime] NOT NULL,
	CONSTRAINT [PK__AppBoxInstalledOn] PRIMARY KEY CLUSTERED (
		[applicationId] ASC,
		[deviceId] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;


IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AppBoxRequestHandler]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[AppBoxRequestHandler](
		[applicationId] [nvarchar](250) NOT NULL,
		[requestHandler] [nvarchar](45) NOT NULL,
		[displayName] [nvarchar](150) NULL,
	CONSTRAINT [PK__AppBoxRequestHandler] PRIMARY KEY CLUSTERED (
		[applicationId] ASC,
		[requestHandler] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;


IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[NetworkStatistic]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[NetworkStatistic](
		[statisticID] [int] IDENTITY(1,1) NOT NULL,
		[size] [numeric](19, 0) NOT NULL,
		[date] [datetime] NULL,
		[month] [int] NOT NULL,
		[year] [int] NOT NULL,
		[category] [nvarchar](255) NULL,
		[duration] [numeric](19, 0) NOT NULL,
		[terminalID] [nvarchar](50) NULL,
		[userID] [nvarchar](50) NULL,
		[quarter] [int] NOT NULL,
		[week] [int] NOT NULL,
		[inSize] [numeric](19, 0) NOT NULL,
		[outSize] [numeric](19, 0) NOT NULL,
	CONSTRAINT [PK__NetworkStatistic] PRIMARY KEY CLUSTERED (
		[statisticID] ASC 
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)

	CREATE NONCLUSTERED INDEX [IX_networkstatistic_date_category] ON [dbo].[NetworkStatistic] (	
		[date] ASC,	[category] ASC 
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)

	CREATE NONCLUSTERED INDEX [IX_NetworkStatistic_terminalID_category] ON [dbo].[NetworkStatistic] (	
		[terminalID] ASC,
		[category] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)

	CREATE NONCLUSTERED INDEX [IX_NetworkStatistic_userID_category] ON [dbo].[NetworkStatistic] (	
		[userID] ASC,
		[category] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
END;	


IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Server]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[Server](
		[serverId] [nvarchar](128) NOT NULL,
		[name] [nvarchar](128) NULL,
	CONSTRAINT [PK__Server] PRIMARY KEY CLUSTERED (
		[serverId] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;


IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[RrdEntry]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[RrdEntry](
		[rrdEntryId] [int] IDENTITY(1,1) NOT NULL,
		[data] [image] NOT NULL,
		[statisticKey] [nvarchar](45) NOT NULL,
		[connectorId] [nvarchar](50) NULL,
		[serverId] [nvarchar](128) NULL,
	CONSTRAINT [PK__RrdEntry] PRIMARY KEY CLUSTERED (
		[rrdEntryId] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[rssfeeds]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[rssfeeds](
		[feedID] [int] IDENTITY(1,1) NOT NULL,
		[authentificationType] [tinyint] NULL,
		[eTag] [nvarchar](255) NULL,
		[lastModified] [datetime] NULL,
		[link] [nvarchar](2048) NULL,
		[linkHash] [nvarchar](32) NULL,
		[localGroupID] [nvarchar](5) NULL,
		[userID] [nvarchar](50) NULL,
	CONSTRAINT [PK__rssfeeds] PRIMARY KEY CLUSTERED (
		[feedID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF),
	CONSTRAINT [UQ__rssfeeds__userID__localGroupID__linkHash] UNIQUE NONCLUSTERED (
		[userID] ASC,
		[localGroupID] ASC,
		[linkHash] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;


IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[settingsHistory]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[settingsHistory](
		[settingID] [int] IDENTITY(1,1) NOT NULL,
		[name] [nvarchar](250) NOT NULL,
		[value] [nvarchar](2048) NOT NULL,
		[terminalID] [nvarchar](50) NULL,
		[localGroupID] [nvarchar](5) NULL,
		[userID] [nvarchar](50) NULL,
		[lockOnTerminal] [int] NULL,
		[intervalSetting] [nvarchar](250) NULL,
		[changedDate] [datetime] NULL,
		[inUse] [int] NULL,
	CONSTRAINT [PK__settingsHistory] PRIMARY KEY CLUSTERED (
		[settingID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)

	CREATE NONCLUSTERED INDEX [IX_settingshistory_localGroupID] ON [dbo].[settingsHistory] (	
		[localGroupID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)

	CREATE NONCLUSTERED INDEX [IX_settingshistory_terminalID_name] ON [dbo].[settingsHistory] (	
		[terminalID] ASC,
		[name] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)

	CREATE NONCLUSTERED INDEX [IX_settingshistory_userID_terminalID_name] ON [dbo].[settingsHistory] (	
		[userID] ASC,
		[terminalID] ASC,
		[name] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[OTA]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[OTA](
		[name] [nvarchar](250) NOT NULL,
		[category] [nvarchar](250) NULL,
		[messageType] [nvarchar](50) NULL,
		[xml] [ntext] NULL,
		[smsCode] [nvarchar](50) NULL,
	CONSTRAINT [PK__OTA] PRIMARY KEY CLUSTERED (
		[name] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[settingsType]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[settingsType](
		[name] [nvarchar](250) NOT NULL,
		[resource] [nvarchar](250) NULL,
		[type] [nvarchar](30) NOT NULL,
		[options] [nvarchar](1024) NULL,
		[groupBy] [nvarchar](100) NULL,
		[maxInterval] [nvarchar](250) NULL,
		[cdata] [int] NULL,
		[belongsTo] [nvarchar](50) NULL,
		[sortBy] [int] NULL,
		[useInterval] [int] NULL,
	CONSTRAINT [PK__settingsType] PRIMARY KEY CLUSTERED (
		[name] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)

	CREATE NONCLUSTERED INDEX [IX_settingstype_type] ON [dbo].[settingsType] (	
		[type] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ServerSMS]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[ServerSMS](
		[serverSMSID] [int] IDENTITY(1,1) NOT NULL,
		[message] [ntext] NULL,
		[created] [datetime] NULL,
		[phoneNr] [nvarchar](50) NULL,
		[sentdate] [datetime] NULL,
		[currentsms] [int] NULL,
		[smscount] [int] NULL,
	CONSTRAINT [PK__ServerSMS] PRIMARY KEY CLUSTERED (	
		[serverSMSID] ASC 
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)

	CREATE NONCLUSTERED INDEX [IX_serversms_phoneNr] ON [dbo].[ServerSMS] (	
		[phoneNr] ASC 
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sim]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[sim](
		[simID] [nvarchar](250) NOT NULL,
		[terminalID] [nvarchar](50) NULL,
		[pin1] [nvarchar](250) NULL,
		[pin2] [nvarchar](250) NULL,
		[puk1] [nvarchar](250) NULL,
		[puk2] [nvarchar](250) NULL,
	CONSTRAINT [PK__sim] PRIMARY KEY CLUSTERED (	
		[simID] ASC	
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)

	CREATE NONCLUSTERED INDEX [IX_sim_terminalID] ON [dbo].[sim] (	
		[terminalID] ASC 
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[subscriptions]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[subscriptions](
		[subscriptionId] [int] IDENTITY(1,1) NOT NULL,
		[currency] [nvarchar](255) NOT NULL,
		[edited] [datetime] NOT NULL,
		[lastIntervalReset] [datetime] NULL,
		[name] [nvarchar](255) NOT NULL,
		[resetInterval] [nvarchar](255) NULL,
		[storedToSettings] [tinyint] NOT NULL,
		[homeRates] [int] NULL,
		[mcc] [int] NOT NULL,
		[mnc] [int] NOT NULL,
		[roamingRates] [int] NULL,
	CONSTRAINT [PK__subscriptions] PRIMARY KEY CLUSTERED (
		[subscriptionId] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF),
    CONSTRAINT [UQ__subscriptions__name] UNIQUE NONCLUSTERED(
		[name] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;
	
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[supportedFields]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[supportedFields](
		[supportedFieldID] [int] IDENTITY(1,1) NOT NULL,
		[field] [nvarchar](50) NOT NULL,
		[method] [nvarchar](30) NOT NULL,
		[type] [nvarchar](30) NOT NULL,
		[terminalID] [nvarchar](50) NOT NULL,
	CONSTRAINT [PK__supportedFields] PRIMARY KEY CLUSTERED (	
		[supportedFieldID] ASC 
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)

	CREATE NONCLUSTERED INDEX [IX_supportedfields_terminalID_type] ON [dbo].[supportedFields] (	
		[terminalID] ASC,
		[type] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
END;	

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[syncAttachmentTable]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[syncAttachmentTable](
		[syncID] [nvarchar](50) NOT NULL,
		[attachmentID] [nvarchar](32) NOT NULL,
		[link] [nvarchar](4000) NOT NULL,
		[tx] [nvarchar](38) NULL,
		[modyfied] [datetime] NULL,
		[folder] [nvarchar](100) NULL,	
	CONSTRAINT [PK__syncAttachmentTable] PRIMARY KEY CLUSTERED (	
		[syncID] ASC,
		[attachmentID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)

	CREATE NONCLUSTERED INDEX [IX_syncAttachmentTable_tx] ON [dbo].[syncAttachmentTable] (	
		[tx] ASC 
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[syncTable]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[syncTable](
		[syncID] [nvarchar](50) NOT NULL,
		[link] [nvarchar](4000) NOT NULL,
		[metadata] [image] NULL,
		[folder] [nvarchar](100) NULL,
		[terminalID] [nvarchar](50) NOT NULL,
		[tx] [nvarchar](38) NULL,
		[md5sum] [nvarchar](32) NOT NULL,
		[modyfied] [datetime] NULL,
	 CONSTRAINT [PK__syncTable] PRIMARY KEY CLUSTERED (
		[syncID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)

	CREATE NONCLUSTERED INDEX [IX_syncTable_terminalID_folder] ON [dbo].[syncTable] (
		[terminalID] ASC,
		[folder] ASC
	) INCLUDE ( 
		[link]	
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)


	CREATE NONCLUSTERED INDEX [IX_syncTable_folder] ON [dbo].[syncTable] (
		[folder] ASC
	) INCLUDE ( 
		[link]
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)

	CREATE NONCLUSTERED INDEX [IX_syncTable_tx] ON [dbo].[syncTable] (
		[tx] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tempData]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[tempData](
		[keyField] [nvarchar](255) NOT NULL,
		[dataField] [image] NULL,
	CONSTRAINT [PK__tempData] PRIMARY KEY CLUSTERED (
		[keyField] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[applicationBlock]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[applicationBlock](
		[applicationBlockID] [int] IDENTITY(1,1) NOT NULL,
		[name] [nvarchar](100) NOT NULL,
		[owner] [nvarchar](100) NULL,
		[type] [nvarchar](50) NOT NULL,
		[uid] [nvarchar](100) NOT NULL,
		[terminalID] [nvarchar](50) NULL,
		[localGroupID] [nvarchar](5) NULL,
		[block] [smallint] NULL,
		[installed] [tinyint] NULL,
		[groupBy] [nvarchar](250) NULL,
		[changedDate] [datetime] NULL,
		[inUse] [tinyint] NULL,
	 CONSTRAINT [PK__applicationBlock] PRIMARY KEY CLUSTERED (
		[applicationBlockID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF),
	 CONSTRAINT [UQ__applicationBlock] UNIQUE NONCLUSTERED (
		[terminalID] ASC,
		[localGroupID] ASC,	
		[uid] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)

	CREATE NONCLUSTERED INDEX [IX_applicationblock_localGroupID_uid] ON [dbo].[applicationBlock] (
		[localGroupID] ASC,
		[uid] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
END;


IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[terminal]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[terminal](
		[terminalID] [nvarchar](50) NOT NULL,
		[locked] [tinyint] NOT NULL,
		[inUse] [tinyint] NOT NULL,
		[localGroup] [nvarchar](5) NULL,
		[created] [datetime] NULL,
		[licenseID] [nvarchar](100) NULL,
	CONSTRAINT [PK__terminal] PRIMARY KEY CLUSTERED (
		[terminalID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)

	CREATE NONCLUSTERED INDEX [IX_terminal_licenseID_inUse] ON [dbo].[terminal] (
		[licenseID] ASC,
		[inUse] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	
	CREATE NONCLUSTERED INDEX [IX_terminal_localGroup] ON [dbo].[terminal] (
		[localGroup] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	
	CREATE NONCLUSTERED INDEX [IX_terminal_terminalID_locked] ON [dbo].[terminal] (
		[terminalID] ASC,
		[locked] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
END;


IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[dayScheme]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[dayScheme](
		[daySchemeID] [int] IDENTITY(1,1) NOT NULL,
		[startTime] [datetime] NOT NULL,
		[dayOfWeek] [int] NOT NULL,
		[endTime] [datetime] NULL,
		[schemeID] [int] NOT NULL,
		[syncInterval] [int] NOT NULL,
		[fullSyncInterval] [int] NOT NULL,
		[subscribed] [tinyint] DEFAULT 0 NOT NULL,
	CONSTRAINT [PK__dayScheme] PRIMARY KEY CLUSTERED (
		[daySchemeID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)

	CREATE NONCLUSTERED INDEX [IX_dayscheme_schemeID] ON [dbo].[dayScheme] (
		[schemeID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DMEDomain]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[DMEDomain](
		[domainName] [nvarchar](255) NOT NULL,
	CONSTRAINT [PK__DMEDomain] PRIMARY KEY CLUSTERED (
		[domainName] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[preferredMobileNetworks]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[preferredMobileNetworks](
		[mcc] [int] NOT NULL,
		[mnc] [int] NOT NULL,
		[homenetworkID] [nvarchar](150) NOT NULL,
		[name] [nvarchar](50) NULL,
	 CONSTRAINT [PK__preferredMobileNetworks] PRIMARY KEY CLUSTERED (
		[mcc] ASC,
		[mnc] ASC,
		[homenetworkID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[role]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[role](
		[roleID] [nvarchar](100) NOT NULL,
		[description] [nvarchar](255) NULL,
		[webRole] [smallint] NULL,
		[loginRoleID] [nvarchar](50) NULL,
	CONSTRAINT [PK__role] PRIMARY KEY CLUSTERED (
		[roleID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DME_Attachments]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[DME_Attachments](
		[attachmentLinkID] [nvarchar](50) NOT NULL,
		[fileName] [nvarchar](250) NOT NULL,
		[data] [image] NOT NULL,
		[created] [datetime] NULL,
		[fingerPrint] [nvarchar](50) NOT NULL,
		[fileSize] [numeric](19, 0) NOT NULL,
	 CONSTRAINT [PK__DME_Attachments] PRIMARY KEY CLUSTERED (
		[attachmentLinkID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DME_License]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[DME_License](
		[licenseID] [nvarchar](100) NOT NULL,
		[license] [image] NOT NULL,
		[numberOfLicenses] [int] NOT NULL,
		[defaultLicense] [tinyint] NULL,
	 CONSTRAINT [PK__DME_License] PRIMARY KEY CLUSTERED (
		[licenseID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[roleFunction]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[roleFunction](
		[roleID] [nvarchar](100) NOT NULL,
		[functionID] [nvarchar](30) NOT NULL,
		[allowed] [int] NOT NULL,
	 CONSTRAINT [PK__roleFunction] PRIMARY KEY CLUSTERED (
		[roleID] ASC,
		[functionID] ASC,
		[allowed] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DME_ServerConfiguration]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[DME_ServerConfiguration](
		[propertyKey] [nvarchar](250) NOT NULL,
		[propertyValue] [nvarchar](2048) NULL,
	 CONSTRAINT [PK__DME_ServerConfiguration] PRIMARY KEY CLUSTERED (
		[propertyKey] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[scanTable]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[scanTable](
		[id] [int] IDENTITY(1,1) NOT NULL,
		[link] [nvarchar](4000) NOT NULL,
		[folder] [nvarchar](250) NOT NULL,
		[terminalID] [nvarchar](50) NOT NULL,
		[md5sum] [nvarchar](32) NOT NULL,
	 CONSTRAINT [PK__scanTable] PRIMARY KEY CLUSTERED (
		[id] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)

	CREATE NONCLUSTERED INDEX [IX_scantable_terminalID_folder] ON [dbo].[scanTable] (
		[terminalID] ASC,
		[folder] ASC
	) INCLUDE ( 
		[link]
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DME_System]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[DME_System](
		[name] [nvarchar](250) NOT NULL,
		[value] [nvarchar](250) NULL,
	 CONSTRAINT [PK__DME_System] PRIMARY KEY CLUSTERED (
		[name] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sequence]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[sequence](
		[name] [nvarchar](64) NOT NULL,
		[last_val] [int] NOT NULL,
	 CONSTRAINT [PK__sequence] PRIMARY KEY CLUSTERED (
		[name] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DME_UpdateFile]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[DME_UpdateFile](
		[updateFileID] [nvarchar](250) NOT NULL,
		[name] [nvarchar](250) NULL,
		[fileType] [nvarchar](255) NOT NULL,
		[major] [int] NOT NULL,
		[minor] [int] NOT NULL,
		[micro] [nvarchar](250) NULL,
		[sortVersion] [nvarchar](250) NULL,
		[releaseDate] [datetime] NULL,
		[description] [ntext]  NULL,
		[fileName] [nvarchar](250) NULL,
		[fileSize] [numeric](19, 0) NOT NULL,
		[archive] [tinyint] NOT NULL,
		[extraDescription] [ntext]  NULL,
		[orgFileName] [nvarchar](50) NULL,
		[category] [nvarchar](100) NOT NULL,
		[smsCode] [nvarchar](50) NULL,
		[smsCodeType] [nvarchar](250) NULL,
		[installFileType] [nvarchar](255) NULL,
		[defaultVersion] [tinyint] NOT NULL,
		[testVersion] [tinyint] NOT NULL,
		[listed] [tinyint] DEFAULT 1 NULL,	
		[data] [image] NULL,
	 CONSTRAINT [PK__DME_UpdateFile] PRIMARY KEY CLUSTERED (
		[updateFileID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[defaultApplicationBlock]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[defaultApplicationBlock](
		[defaultApplicationBlockID] [int] IDENTITY(1,1) NOT NULL,
		[name] [nvarchar](100) NOT NULL,
		[type] [nvarchar](50) NOT NULL,
		[uid] [nvarchar](100) NOT NULL,
		[block] [tinyint] NULL,
		[groupBy] [nvarchar](250) NULL,
		[changedDate] [datetime] NULL,
	 CONSTRAINT [PK__defaultApplicationBlock] PRIMARY KEY CLUSTERED (
		[defaultApplicationBlockID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;


IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[terminalGroupMembership]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[terminalGroupMembership](
		[localGroupID] [int] NOT NULL,
		[terminalID] [nvarchar](50) NOT NULL,
		[groupType] [nvarchar](255) NULL,
	 CONSTRAINT [PK__terminalGroupMembership] PRIMARY KEY CLUSTERED (
		[localGroupID] ASC,
		[terminalID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;


IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[terminalGroupMembership_tmp]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[terminalGroupMembership_tmp](
		[terminalID] [nvarchar](50) NOT NULL,
		[localGroupID] [int] NOT NULL,
		[groupType] [nvarchar](255) NULL,
	 CONSTRAINT [PK__terminalGroupMembership_tmp] PRIMARY KEY CLUSTERED (
		[localGroupID] ASC,
		[terminalID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[deviceInfo]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[deviceInfo](
		[deviceInfoID] [int] IDENTITY(1,1) NOT NULL,
		[locked] [tinyint] NULL,
		[dmeVersionType] [nvarchar](255) NULL,
		[dmManufacturer] [nvarchar](250) NULL,
		[dmModel] [nvarchar](250) NULL,
		[phoneModel] [nvarchar](250) NULL,
		[pictureData] [image] NULL,
		[picturePath] [nvarchar](250) NULL,
		[pictureDimensions] [nvarchar](15) NULL,
		[os] [nvarchar](255) NULL,
		[platform] [nvarchar](255) NULL,
	 CONSTRAINT [PK__deviceInfo] PRIMARY KEY CLUSTERED (
		[deviceInfoID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[terminalOwner]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[terminalOwner](
		[terminalID] [nvarchar](50) NOT NULL,
		[userID] [nvarchar](50) NULL,
	 CONSTRAINT [PK__terminalOwner] PRIMARY KEY CLUSTERED (
		[terminalID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)

	CREATE NONCLUSTERED INDEX [IX_terminalowner_userID_terminalID] ON [dbo].[terminalOwner] (
		[userID] ASC,
		[terminalID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[deviceSignature]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[deviceSignature](
		[deviceID] [nvarchar](50) NOT NULL,
		[status] [int] NULL,
		[errorCount] [int] NULL,
		[created] [datetime] NULL,
		[creator] [nvarchar](50) NULL,
		[encodedKey] [ntext] NULL,
	 CONSTRAINT [PK__deviceSignature] PRIMARY KEY CLUSTERED (
		[deviceID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[terminalOwnerHistory]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[terminalOwnerHistory](
		[id] [int] IDENTITY(1,1) NOT NULL,
		[terminalID] [nvarchar](50) NOT NULL,
		[userID] [nvarchar](50) NOT NULL,
		[firstUsed] [datetime] NOT NULL,
		[lastUsed] [datetime] NOT NULL,
	 CONSTRAINT [PK__terminalOwnerHistory] PRIMARY KEY CLUSTERED (
		[id] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)

	CREATE NONCLUSTERED INDEX [IX_terminalownerhistory_terminalID_userID] ON [dbo].[terminalOwnerHistory] (
		[terminalID] ASC,
		[userID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)

	CREATE NONCLUSTERED INDEX [IX_terminalownerhistory_userID_terminalID] ON [dbo].[terminalOwnerHistory] (
		[userID] ASC,
		[terminalID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[distinctValues]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[distinctValues](
		[value] [nvarchar](50) NOT NULL,
		[created] [datetime] NULL,
	 CONSTRAINT [PK__distinctValues] PRIMARY KEY CLUSTERED (
		[value] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[dmFileStore]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[dmFileStore](
		[fileID] [int] IDENTITY(1,1) NOT NULL,
		[name] [nvarchar](195) NULL,
		[size] [int] NULL,
		[path] [nvarchar](255) NULL,
		[data] [image] NULL,
		[access] [nvarchar](3) NULL,
		[fingerprint] [nvarchar](32) NULL,
		[modified] [datetime] NOT NULL,
	 CONSTRAINT [PK__dmFileStore] PRIMARY KEY CLUSTERED (
		[fileID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF),
	 CONSTRAINT [UQ__dmFileStore__path__name] UNIQUE NONCLUSTERED (
		[path] ASC,
		[name] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[notificationSubscription]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[notificationSubscription](
		[subscriptionID] [nvarchar](100) NOT NULL,
		[terminalID] [nvarchar](50) NOT NULL,
		[userID] [nvarchar](50) NOT NULL,
		[resourceID] [int] NOT NULL,
		[connectorID] [nvarchar](50) NOT NULL,
		[keepaliveTimestamp] [datetime] NOT NULL,
		[daySchemeID] [int] NOT NULL,
	 CONSTRAINT [PK__notificationSubscription] PRIMARY KEY CLUSTERED (
		[subscriptionID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)

	CREATE NONCLUSTERED INDEX [IX_notificationSubscription__terminalID__resourceID] ON [dbo].[notificationSubscription] (
		[terminalID] ASC,
		[resourceID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)

	CREATE NONCLUSTERED INDEX [IX_notificationSubscription__keepaliveTimestamp] ON [dbo].[notificationSubscription] (
		[keepaliveTimestamp] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[terminalRessourceNotification]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[terminalRessourceNotification](
		[terminalID] [nvarchar](50) NOT NULL,
		[ressourceID] [int] NOT NULL,
		[schemeID] [int] NULL,
		[calculatedNextPoll] [datetime] NULL,
		[lastPoll] [datetime] NULL,
		[lastSync] [datetime] NULL,
		[lastNotifications] [nvarchar](255) NULL,
		[lastNotification] [datetime] NULL,
		[lastFullPoll] [datetime] NULL,
	    [lastSubscriptionWatermark] [nvarchar](60) NULL, 
		[calculatedGroupSchemeID] [int] NULL,
		[retries] [int] DEFAULT 0 NOT NULL,
		[outstanding] [int] DEFAULT 0 NOT NULL,
		[nextScanServer] [nvarchar](200) NULL,
		[errorMessage] [nvarchar](1024) NULL,
		[checkSubscriptionEvent] [tinyint] DEFAULT 0 NOT NULL,
	 CONSTRAINT [PK__terminalRessourceNotification] PRIMARY KEY CLUSTERED (
		[terminalID] ASC,
		[ressourceID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)

	CREATE NONCLUSTERED INDEX [IX_terminalressourcenotification_schemeID] ON [dbo].[terminalRessourceNotification] (
		[schemeID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
END;


IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tinyCDR]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[tinyCDR](
		[tinyCDRID] [int] IDENTITY(1,1) NOT NULL,
		[dispatchStatus] [nvarchar](255) NULL,
		[traffic_callID] [nvarchar](32) NULL,
		[traffic_terminalID] [nvarchar](50) NULL,
	CONSTRAINT [PK__tinyCDR] PRIMARY KEY CLUSTERED (
		[tinyCDRID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tx_syncAttachmentTable]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[tx_syncAttachmentTable](
		[syncID] [nvarchar](50) NOT NULL,
		[attachmentID] [nvarchar](32) NOT NULL,
		[link] [nvarchar](4000) NOT NULL,
		[tx] [nvarchar](38) NULL,
		[modyfied] [datetime] NULL,
		[folder] [nvarchar](100) NULL,
	 CONSTRAINT [PK__tx_syncAttachmentTable] PRIMARY KEY CLUSTERED (
		[syncID] ASC,
		[attachmentID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)

	CREATE NONCLUSTERED INDEX [IX_tx_syncAttachmentTable_tx] ON [dbo].[tx_syncAttachmentTable] (
		[tx] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[dmRules]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[dmRules](
		[ruleID] [int] IDENTITY(1,1) NOT NULL,
		[name] [nvarchar](150) NULL,
		[domain] [nvarchar](100) NULL,
		[server] [nvarchar](100) NULL,
		[terminalID] [nvarchar](50) NULL,
		[syncMode] [int] NOT NULL,
		[clientRoot] [nvarchar](50) NOT NULL,
		[clientDestination] [nvarchar](255) NULL,
		[groupID] [int] NULL,
		[deviceType] [nvarchar](150) NULL,
		[isMonitor] [int] NOT NULL,
		[linkFolder] [nvarchar](255) NULL,
		[linkFile] [nvarchar](255) NULL,
		[authUser] [nvarchar](50) NULL,
		[authCredentials] [nvarchar](50) NULL,
	 CONSTRAINT [PK__dmRules] PRIMARY KEY CLUSTERED (
		[ruleID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)

	CREATE NONCLUSTERED INDEX [IX_dmrules_groupID] ON [dbo].[dmRules] (
		[groupID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)

	CREATE NONCLUSTERED INDEX [IX_dmrules_terminalID] ON [dbo].[dmRules] (
		[terminalID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tx_syncTable]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[tx_syncTable](
		[syncID] [nvarchar](50) NOT NULL,
		[link] [nvarchar](4000) NOT NULL,
		[metadata] [image] NULL,
		[folder] [nvarchar](100) NULL,
		[terminalID] [nvarchar](50) NOT NULL,
		[tx] [nvarchar](38) NULL,
		[md5sum] [nvarchar](32) NOT NULL,
		[modyfied] [datetime] NULL,
	 CONSTRAINT [PK__tx_syncTable] PRIMARY KEY CLUSTERED (
		[syncID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)

	CREATE NONCLUSTERED INDEX [IX_tx_syncTable_terminalID_folder] ON [dbo].[tx_syncTable] (
		[terminalID] ASC,
		[folder] ASC
	) INCLUDE ( 
		[link]
	)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)

	CREATE NONCLUSTERED INDEX [IX_tx_syncTable_terminalID_tx] ON [dbo].[tx_syncTable] (
		[terminalID] ASC,
		[tx] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[dmWorkQueue]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[dmWorkQueue](
		[ID] [int] IDENTITY(1,1) NOT NULL,
		[fingerprint] [nvarchar](32) NOT NULL,
		[syncID] [nvarchar](50) NOT NULL,
	 CONSTRAINT [PK__dmWorkQueue] PRIMARY KEY CLUSTERED (
		[ID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)

	CREATE NONCLUSTERED INDEX [IX_dmworkqueue_syncID] ON [dbo].[dmWorkQueue] (
		[syncID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
END;


IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[domain]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[domain](
		[id] [int] IDENTITY(1,1) NOT NULL,
		[name] [nvarchar](128) NOT NULL,
		[url] [nvarchar](128) NOT NULL,
		[modBy] [nvarchar](45) NULL,
		[modDate] [datetime] NULL,
	CONSTRAINT [PK__domain] PRIMARY KEY CLUSTERED (
		[id] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF),
	CONSTRAINT [UQ__domain__name] UNIQUE NONCLUSTERED (
		[name] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF),
	CONSTRAINT [UQ__domain__url] UNIQUE NONCLUSTERED (
		[url] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF),
	)
END;


IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[uniqueKey]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[uniqueKey](
		[keyValue] [nvarchar](250) NOT NULL,
		[terminalID] [nvarchar](50) NULL,
		[phoneNumber] [nvarchar](50) NULL,
	 CONSTRAINT [PK__uniqueKey] PRIMARY KEY CLUSTERED (
		[keyValue] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[onlineDevices]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[onlineDevices](
		[deviceID] [nvarchar](50) NOT NULL,
		[serverName] [nvarchar](100) NOT NULL,
	 CONSTRAINT [PK__onlineDevices] PRIMARY KEY CLUSTERED (
		[deviceID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[pendingNotifications]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[pendingNotifications](
		[terminalID] [nvarchar](50) NOT NULL,
		[ressourceID] [int] NOT NULL,
		[status] [int] NULL,
		[created] [datetime] NULL,
		[extras] [int] NULL,
		[SMSmessageID] [nvarchar](250) NULL,
	 CONSTRAINT [PK__pendingNotifications] PRIMARY KEY CLUSTERED (
		[terminalID] ASC,
		[ressourceID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF),
	 CONSTRAINT [UQ__pendingNotifications__SMSmessageID] UNIQUE NONCLUSTERED (
		[SMSmessageID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[userFilterGroup]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[userFilterGroup](
		[userID] [nvarchar](50) NOT NULL,
		[groupID] [nvarchar](250) NOT NULL,
	 CONSTRAINT [PK__userFilterGroup] PRIMARY KEY CLUSTERED (
		[userID] ASC,
		[groupID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[dm_action_plan]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[dm_action_plan](
		[actionPlanPK] [int] IDENTITY(1,1) NOT NULL,
		[type] [nvarchar](128) NOT NULL,
		[model] [nvarchar](128) NOT NULL,
	 CONSTRAINT [PK__dm_action_plan] PRIMARY KEY CLUSTERED (
		[actionPlanPK] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF),
	 CONSTRAINT [UQ__dm_action_plan__type__model] UNIQUE NONCLUSTERED (
		[type] ASC,
		[model] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[dm_bootstrapMessages]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[dm_bootstrapMessages](
		[bootstrapMessageID] [int] IDENTITY(1,1) NOT NULL,
		[bootstrapMessage] [nvarchar](2000) NULL,
		[initiateMessageID] [int] NULL,
	CONSTRAINT [PK__bootstrapMessages] PRIMARY KEY CLUSTERED (
		[bootstrapMessageID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	) 
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[updateProperty]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[updateProperty](
		[updatePropertyID] [int] IDENTITY(1,1) NOT NULL,
		[name] [nvarchar](250) NULL,
		[value] [nvarchar](250) NULL,
		[terminalID] [nvarchar](50) NULL,
		[userID] [nvarchar](50) NULL,
		[created] [datetime] NULL,
	 CONSTRAINT [PK__updateProperty] PRIMARY KEY CLUSTERED (
		[updatePropertyID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;


IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[dm_config_server]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[dm_config_server](
		[name] [nvarchar](255) NOT NULL,
		[value] [nvarchar](255) NULL,
	 CONSTRAINT [PK__dm_config_server] PRIMARY KEY CLUSTERED (
		[name] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;


IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[dm_dme_jobs]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[dm_dme_jobs](
		[jobID] [nvarchar](255) NOT NULL,
		[createdDate] [datetime] NULL,
		[deviceID] [nvarchar](255) NULL,
		[nodeJobs] [image] NULL,
		[jobRequest] [image] NULL,
		[state] [nvarchar](255) NULL,
		[meta] [nvarchar](255) NULL,
		[nodeStatus] [image] NULL,
		[phoneNumber] [nvarchar](255) NULL,
		[requestType] [int] NULL,
		[status] [image] NULL,
		[waitForJobID] [nvarchar](100) NULL,
		[waitPath] [nvarchar](255) NULL,
		[waitSendIf] [nvarchar](50) NULL,
		[jobGroup] [nvarchar](255) NULL,
	 CONSTRAINT [PK__dm_dme_jobs] PRIMARY KEY CLUSTERED (
		[jobID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;


IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[dm_nodeData]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[dm_nodeData](
		[pk] [int] IDENTITY(1,1) NOT NULL,
		[data] [image] NULL,
		[checksum] [varbinary](255) NULL,
	 CONSTRAINT [PK__dm_nodeData] PRIMARY KEY CLUSTERED (
		[pk] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)

	CREATE NONCLUSTERED INDEX [IX_dm_nodeData_checksum] ON [dbo].[dm_nodeData] (
		[checksum] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[dm_users]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[dm_users](
		[userPK] [int] IDENTITY(1,1) NOT NULL,
		[userID] [nvarchar](255) NULL,
		[password] [nvarchar](255) NULL,
	 CONSTRAINT [PK__dm_users] PRIMARY KEY CLUSTERED (
		[userPK] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;


IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[dme_keystore_certs]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[dme_keystore_certs](
		[alias] [nvarchar](255) NOT NULL,
		[object] [image] NOT NULL,
		[id] [nvarchar](50) NULL,
		[created] [datetime] NOT NULL,
		[subjectdn] [nvarchar](450) NOT NULL,
		[isCA] [tinyint] NULL,
		[displaySubject] [nvarchar](100) NULL,
		[displayIssuer] [nvarchar](100) NULL,
		[expirationDate] [datetime] NULL,
	 CONSTRAINT [PK__dme_keystore_certs] PRIMARY KEY CLUSTERED (
		[alias] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)

	CREATE NONCLUSTERED INDEX [IX_dme_keystore_certs_id] ON [dbo].[dme_keystore_certs] (
		[id] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)

	CREATE NONCLUSTERED INDEX [IX_dme_keystore_certs_subjectdn] ON [dbo].[dme_keystore_certs] (
		[subjectdn] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
END;


IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[dme_keystore_crl_ap]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[dme_keystore_crl_ap](
		[issuer] [nvarchar](255) NOT NULL,
		[ap] [nvarchar](255) NOT NULL,
	 CONSTRAINT [PK__dme_keystore_crl_ap] PRIMARY KEY CLUSTERED (
		[issuer] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[dme_keystore_crls]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[dme_keystore_crls](
		[issuer] [nvarchar](255) NOT NULL,
		[source] [nvarchar](255) NOT NULL,
		[local] [nvarchar](255) NOT NULL,
		[accesstype] [int] NOT NULL,
		[nextUpdate] [nvarchar](250) NOT NULL,
	 CONSTRAINT [PK__dme_keystore_crls] PRIMARY KEY CLUSTERED (
		[issuer] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[dme_keystore_emails]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[dme_keystore_emails](
		[alias] [nvarchar](255) NOT NULL,
		[email] [nvarchar](190) NOT NULL,
	 CONSTRAINT [PK__dme_keystore_emails] PRIMARY KEY CLUSTERED (
		[alias] ASC,
		[email] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[dme_keystore_keys]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[dme_keystore_keys](
		[alias] [nvarchar](255) NOT NULL,
		[object] [image] NULL,
		[type] [int] NOT NULL,
		[created] [datetime] NOT NULL,
	 CONSTRAINT [PK__dme_keystore_keys] PRIMARY KEY CLUSTERED (
		[alias] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[dme_report]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[dme_report](
		[reportID] [int] IDENTITY(1,1) NOT NULL,
		[reportFile] [nvarchar] (250) NULL,
		[reportName] [nvarchar](250) NULL,
		[reportCategory] [nvarchar](250) NULL,
		[isRunnable] [tinyint] NULL,
		[isHidden] [tinyint] NULL,
	 CONSTRAINT [PK__dme_report] PRIMARY KEY CLUSTERED (
		[reportID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[dme_servicemonitor_failures]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[dme_servicemonitor_failures](
		[failureID] [int] IDENTITY(1,1) NOT NULL,
		[message] [ntext] NULL,
		[host] [nvarchar](250) NULL,
		[port] [int] NULL,
		[time] [datetime] NULL,
		[serviceType] [nvarchar](250) NULL,
		[duration_seconds] [int] NULL,
	 CONSTRAINT [PK__dme_servicemonitor_failures] PRIMARY KEY CLUSTERED (
		[failureID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[dme_traffic]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[dme_traffic](
		[terminalID] [nvarchar](50) NOT NULL,
		[callID] [nvarchar](32) NOT NULL,
		[timeZone] [tinyint] NULL,
		[bytesSent] [numeric](19, 0) NULL,
		[bytesReceived] [numeric](19, 0) NULL,
		[userID] [nvarchar](50) NULL,
		[phoneNumber] [nvarchar](35) NULL,
		[imsi] [nvarchar](40) NULL,
		[trafficType] [nvarchar](250) NULL,
		[started] [datetime] NULL,
		[isRoaming] [tinyint] NOT NULL,
		[intMcc] [int] NULL,
		[intMnc] [int] NULL,
		[extMcc] [int] NULL,
		[callType] [tinyint] NULL,
		[duration_in] [int] NULL,
		[duration_out] [int] NULL,
		[registrated] [datetime] NULL,
	 CONSTRAINT [PK__dme_traffic] PRIMARY KEY CLUSTERED (
		[terminalID] ASC,
		[callID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)

	CREATE NONCLUSTERED INDEX [IX_dme_traffic_terminalID_trafficType] ON [dbo].[dme_traffic] (
		[terminalID] ASC,
		[trafficType] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)

	CREATE NONCLUSTERED INDEX [IX_dme_traffic_userId_trafficType] ON [dbo].[dme_traffic] (
		[userID] ASC,
		[trafficType] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[dme_voice_locator]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[dme_voice_locator](
		[mcc] [int] NOT NULL,
		[cc] [nvarchar](3) NULL,
		[countryCode] [nvarchar] (80) NULL,
		[idd] [nvarchar](50) NULL,
	 CONSTRAINT [PK__dme_voice_locator] PRIMARY KEY CLUSTERED (
		[mcc] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[dme_voice_locator_area]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[dme_voice_locator_area](
		[areacode] [int] NOT NULL,
		[mcc] [int] NULL,
		[cc] [int] NULL,
		[areaname] [nvarchar](50) NULL,
	 CONSTRAINT [PK__dme_voice_locator_area] PRIMARY KEY CLUSTERED (
		[areacode] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[dme_voice_locator_name]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[dme_voice_locator_name](
		[mcc] [int] NOT NULL,
		[mnc] [int] NOT NULL,
		[name] [nvarchar](50) NULL,
	 CONSTRAINT [PK__dme_voice_locator_name] PRIMARY KEY CLUSTERED (
		[mcc] ASC,
		[mnc] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[downloadLinks]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[downloadLinks](
		[id] [nvarchar](250) NOT NULL,
		[messageID] [nvarchar](255) NULL,
		[terminalID] [nvarchar](50) NULL,
		[created] [datetime] NULL,
		[phoneNr] [nvarchar](50) NULL,
		[updatefileID] [nvarchar](250) NULL,
		[downloaded] [tinyint] NULL,
		[distributionType] [nvarchar](255) NULL,
		[downloadType] [nvarchar](255) NULL,
		[provisioningType] [nvarchar](255) NULL,
		[queued] [datetime] NULL,
		[status] [image] NULL,
		[jobGroup] [nvarchar](255) NULL,
	CONSTRAINT [PK__downloadLinks] PRIMARY KEY CLUSTERED (
		[id] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)

	CREATE NONCLUSTERED INDEX [IX_downloadlinks_created] ON [dbo].[downloadLinks] (
		[created] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[folderSettings]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[folderSettings](
		[folderID] [nvarchar](50) NOT NULL,
		[link] [nvarchar](250) NOT NULL,
		[terminalID] [nvarchar](50) NOT NULL,
		[daysBack] [int] NULL,
		[includeInSync] [tinyint] NULL,
		[includeInScan] [tinyint] NULL,
		[isPseudoFolder] [tinyint] NULL,
		[headersOnly] [tinyint] NULL,
		[useDefaultSettings] [tinyint] NULL,
	 CONSTRAINT [PK__folderSettings] PRIMARY KEY CLUSTERED (
		[folderID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)

	CREATE NONCLUSTERED INDEX [IX_folderSettings_terminalID_link] ON [dbo].[folderSettings] (
		[terminalID] ASC,
		[link] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[groupGraph]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[groupGraph](
		[groupID] [int] IDENTITY(1,1) NOT NULL,
		[ldapGroup] [nvarchar](250) NOT NULL,
		[ldapServer] [nvarchar](250) NOT NULL,
		[lft] [int] NULL,
		[rgt] [int] NULL,
	 CONSTRAINT [PK__groupGraph] PRIMARY KEY CLUSTERED (
		[groupID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)

	CREATE NONCLUSTERED INDEX [IX_groupGraph_ldapGroup] ON [dbo].[groupGraph] (
		[ldapGroup] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)

	CREATE NONCLUSTERED INDEX [IX_groupGraph_lft_rgt] ON [dbo].[groupGraph] (
		[lft] ASC,
		[rgt] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[groupsupportedsettings]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[groupsupportedsettings](
		[localGroupId] [int] NOT NULL,
		[settingsName] [nvarchar](250) NOT NULL,
		[settingsId] [int] NOT NULL,
	CONSTRAINT [PK__groupsupportedsettings] PRIMARY KEY CLUSTERED (
		[localGroupId] ASC,
		[settingsName] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF) 
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[homeMobileNetworks]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[homeMobileNetworks](
		[networkID] [nvarchar](150) NOT NULL,
		[name] [nvarchar](50) NULL,
		[country] [nvarchar](50) NOT NULL,
		[mcc] [int] NOT NULL,
		[mnc] [int] NOT NULL,
	 CONSTRAINT [PK__homeMobileNetworks] PRIMARY KEY CLUSTERED (
		[networkID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[homerates]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[HomeRates](
		[homeRatesID] [int] IDENTITY(1,1) NOT NULL,
		[domesticMms] [decimal](10, 4) NULL,
		[domesticRate] [decimal](10, 4) NULL,
		[domesticSms] [decimal](10, 4) NULL,
		[includedMms] [int] NOT NULL,
		[includedSms] [int] NOT NULL,
		[includedTrafficMB] [int] NOT NULL,
		[includedVoice] [int] NOT NULL,
		[internationalMms] [decimal](10, 4) NULL,
		[internationalRate] [decimal](10, 4) NULL,
		[internationalSms] [decimal](10, 4) NULL,
		[receiving] [decimal](10, 4) NULL,
		[trafficMB] [decimal](10, 4) NULL,	
	CONSTRAINT [PK__homerates] PRIMARY KEY CLUSTERED (
		[homeRatesId] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	) 
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[IphoneProfile]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[IphoneProfile](
		[profileID] [nvarchar](255) NOT NULL,
		[category] [nvarchar](255) NULL,
		[changeDate] [datetime] NULL,
		[content] [image] NULL,
		[description] [nvarchar](255) NULL,
		[fileName] [nvarchar](255) NULL,
		[hash] [nvarchar](255) NULL,
		[identifier] [nvarchar](255) NULL,
		[name] [nvarchar](255) NULL,
		[smsCode] [nvarchar](255) NULL,
		[uuid] [nvarchar](255) NULL,
	CONSTRAINT [PK__IphoneProfile] PRIMARY KEY CLUSTERED (
		[profileID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	) 
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[localGroup]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[localGroup](
		[groupID] [int] IDENTITY(1,1) NOT NULL,
		[name] [nvarchar](250) NOT NULL,
		[description] [nvarchar](250) NULL,
		[hierarchyLocation] [float] NOT NULL,
		[priority] [int] NULL,
		[ldapGroup] [nvarchar](250) NULL,
		[changedDate] [datetime] NULL,
		[licenseID] [nvarchar](100) NULL,
		[ldapServer] [nvarchar](250) NULL,
		[type] [nvarchar](128) NOT NULL,
		[domainId] [int] NOT NULL,
	 CONSTRAINT [PK__localGroup] PRIMARY KEY CLUSTERED (
		[groupID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF),
	 CONSTRAINT [UQ__localGroup__domainId__name__type] UNIQUE NONCLUSTERED (
		[domainId] ASC,
		[name] ASC,
		[type] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[localGroupRessourceNotification]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[localGroupRessourceNotification](
		[localGroupID] [int] NOT NULL,
		[ressourceID] [int] NOT NULL,
		[schemeID] [int] NULL,
	 CONSTRAINT [PK__localGroupRessourceNotification] PRIMARY KEY CLUSTERED (
		[localGroupID] ASC,
		[ressourceID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[logTable]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[logTable](
		[lineNo] [int] IDENTITY(1,1) NOT NULL,
		[message] [ntext] NULL,
		[category] [nvarchar](50) NULL,
		[level] [int] NOT NULL,
		[NDC] [nvarchar](100) NULL,
		[terminalID] [nvarchar](50) NULL,
		[userID] [nvarchar](50) NULL,
		[created] [datetime] NULL,
		[serverIdentity] [nvarchar](250) NULL,
		[simpleMessage] [nvarchar](250) NULL,
		[functionCategory] [nvarchar](255) NULL,
		[exceptionId] [nvarchar] (32) NULL,
		[originatingId] [nvarchar] (128) NULL,
	 CONSTRAINT [PK__logTable] PRIMARY KEY CLUSTERED (
		[lineNo] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)

	CREATE NONCLUSTERED INDEX [IX_logTable_category] ON [dbo].[logTable] (
		[category] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)

	CREATE NONCLUSTERED INDEX [IX_logTable_exceptionId] ON [dbo].[logTable] (
		[exceptionId] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)

	CREATE NONCLUSTERED INDEX [IX_logTable_userID_terminalID_created] ON [dbo].[logTable] (
		[userID] ASC,
		[terminalID] ASC,
		[created] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[message]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[message](
		[id] [nvarchar](250) NOT NULL,
		[type] [nvarchar](50) NULL,
		[obj] [image] NULL,
		[status] [int] NULL,
		[lastUpdate] [datetime] NULL,
		[created] [datetime] NULL,
		[sentTo] [nvarchar](40) NULL,
		[statusText] [nvarchar](50) NULL,
		[notificationType] [nvarchar](250) NULL,
		[queued] [datetime] NULL,
		[dlr] [smallint] NULL,
	 CONSTRAINT [PK__message] PRIMARY KEY CLUSTERED (
		[id] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[dm_support]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[dm_support](
		[supportID] [int] IDENTITY(1,1) NOT NULL,
		[deviceID] [nvarchar](255) NULL,
		[supportType] [nvarchar](255) NULL,
		[support] [int] NULL,
	 CONSTRAINT [PK__dm_support] PRIMARY KEY CLUSTERED (
		[supportID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)

	CREATE NONCLUSTERED INDEX [IX_dm_support_deviceID] ON [dbo].[dm_support] (
		[deviceID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[notificationRessource]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[notificationRessource](
		[ressourceID] [int] NOT NULL,
		[name] [nvarchar](100) NULL,
		[type] [nvarchar](100) NULL,
		[defaultSchemeID] [int] NULL,
	 CONSTRAINT [PK__notificationRessource] PRIMARY KEY CLUSTERED (
		[ressourceID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[notificationScheme]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[notificationScheme](
		[schemeID] [int] IDENTITY(1,1) NOT NULL,
		[priority] [int] NULL,
		[enabled] [tinyint] NOT NULL,
		[maxNotifications] [int] NULL,
		[notificationCenter] [nvarchar](100) NULL,
	 CONSTRAINT [PK__notificationScheme] PRIMARY KEY CLUSTERED (
		[schemeID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;


IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Connector]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[Connector](
		[connectorId] [nvarchar](50) NOT NULL,
		[location] [nvarchar](255) NULL,
		[displayName] [nvarchar](255) NULL,
		[connectorState] [nvarchar](255) NULL,
		[locked] [tinyint] NULL,
		[collaborationSystem] [nvarchar](255) NULL,
		[userMode] [nvarchar](255) NULL,
		[supportedUsersExp] [nvarchar](255) NULL,
		[supportedGroup] [nvarchar](255) NULL,
		[nodeMode] [nvarchar](255) NULL,
		[serviceVersion] [nvarchar](255) NULL,
		[dmeDomainName] [nvarchar](255) NULL,
		[revision] [int] NULL,
	 CONSTRAINT [PK__Connector] PRIMARY KEY CLUSTERED	(
		[connectorId] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[pre_cache_connector]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[pre_cache_connector] ( 
	  [terminalID] [nvarchar](50) NOT NULL,
	  [function] [nvarchar] (128) NOT NULL, 
	  [preCacheState] [nvarchar] (50) NOT NULL, 
	  [connectorId] [nvarchar] (50) NOT NULL, 
	CONSTRAINT [PK__pre_cache_connector] PRIMARY KEY CLUSTERED (
		[terminalID] ASC,
		[function] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;


IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[usr]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[usr](
		[userID] [nvarchar](50) NOT NULL,
		[locked] [tinyint] NOT NULL,
		[password] [nvarchar](250) NULL,
		[userName] [nvarchar](250) NULL,
		[created] [datetime] NULL,
		[loginFailures] [int] NULL,
		[occupation] [nvarchar](250) NULL,
		[collabPassword] [nvarchar](250) NULL,
		[dmeDomainName] [nvarchar](255) NULL,
		[userType] [nvarchar](100) NULL,
	 CONSTRAINT [PK__usr] PRIMARY KEY CLUSTERED (
		[userID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)

	CREATE NONCLUSTERED INDEX [IX_usr_userID_locked] ON [dbo].[usr] (
		[userID] ASC,
		[locked] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[userGroup]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[userGroup](
		[userID] [nvarchar](50) NOT NULL,
		[roleID] [nvarchar](100) NOT NULL,
	 CONSTRAINT [PK__userGroup] PRIMARY KEY CLUSTERED (
		[userID] ASC,
		[roleID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[userTerminal]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[userTerminal](
		[terminalID] [nvarchar](50) NOT NULL,
		[userID] [nvarchar](50) NOT NULL,
		[lastUsed] [datetime] NOT NULL,
		[phoneNumber] [nvarchar](255) NULL,
	 CONSTRAINT [PK__userTerminal] PRIMARY KEY CLUSTERED (
		[terminalID] ASC,
		[userID] ASC,
		[lastUsed] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[terminalProperty]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[terminalProperty](
		[property] [nvarchar](150) NOT NULL,
		[terminalID] [nvarchar](50) NOT NULL,
		[value] [nvarchar](250) NULL,
		[type] [nvarchar](250) NULL,
		[changed] [datetime] NULL,
		[owner] [nvarchar](100) NULL,
	 CONSTRAINT [PK__terminalProperty] PRIMARY KEY CLUSTERED (
		[property] ASC,
		[terminalID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)

	CREATE NONCLUSTERED INDEX [IX_terminalproperty_terminalID] ON [dbo].[terminalProperty] (
		[terminalID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
END;


IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[settings]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[settings](
		[id] [int] IDENTITY(1,1) NOT NULL,
		[name] [nvarchar](250) NULL,
		[value] [nvarchar](2048) NOT NULL,
		[localGroupId] [int] NOT NULL,	
		[lockOnTerminal] [int] NULL,	
		[intervalSetting] [nvarchar](250) NULL,
		[lockInterval] [int] NULL,
		[lockOnSuperUser] [int] NULL,
		[changedDate] [datetime] NULL,
		[changedBy] [nvarchar](50) NULL,
		[noLicense] [int] NULL,
	 CONSTRAINT [PK__settings] PRIMARY KEY CLUSTERED (
		[id] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF),
	 CONSTRAINT [UQ__settings__name__localGroupID] UNIQUE NONCLUSTERED (
		[localGroupID] ASC,
		[name] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)

	CREATE NONCLUSTERED INDEX [IX_settings_localGroupID] ON [dbo].[settings] (
		[localGroupID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[terminalAssetMgmt]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[terminalAssetMgmt](
		[terminalId] [nvarchar](50) NOT NULL,
		[purchaseDate] [datetime] NULL,
		[warrantyExpirationDate] [datetime] NULL,
		[supplier] [nvarchar](100) NULL,
		[invoiceNo] [nvarchar](100) NULL,
		[purchaseOrder] [nvarchar](100) NULL,
		[requisition] [nvarchar](100) NULL,
		[purchasePrice] [nvarchar](100) NULL,
		[serviceLog] [ntext] NULL,
		[text1] [ntext] NULL,
		[text2] [ntext] NULL,
		[text3] [ntext] NULL,
		[date1] [datetime] NULL,
		[date2] [datetime] NULL,
		[date3] [datetime] NULL,
		[shortText1] [nvarchar](100) NULL,
		[shortText2] [nvarchar](100) NULL,
		[shortText3] [nvarchar](100) NULL,
	 CONSTRAINT [PK__terminalAssetMgmt] PRIMARY KEY CLUSTERED (
		[terminalId] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[dm_node]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[dm_node](
		[id] [int] IDENTITY(1,1) NOT NULL,
		[target] [nvarchar](512) NULL,
		[format] [nvarchar](255) NULL,
		[type] [nvarchar](255) NULL,
		[nodeData] [int] NULL,
	 CONSTRAINT [PK__dm_node] PRIMARY KEY CLUSTERED (
		[id] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;


IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[dm_node_result]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[dm_node_result](
		[id] [int] IDENTITY(1,1) NOT NULL,
		[format] [nvarchar](255) NULL,
		[target] [nvarchar](255) NULL,
		[type] [nvarchar](255) NULL,
		[nodeData] [int] NULL,
	CONSTRAINT [PK__dm_node_result] PRIMARY KEY CLUSTERED (
		[id] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF) 
	)
END;


IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[dm_action]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[dm_action](
		[actionID] [int] IDENTITY(1,1) NOT NULL,
		[command] [nvarchar](255) NULL,
		[actionPlan] [int] NULL,
		[node_id] [int] NULL,
	 CONSTRAINT [PK__dm_action] PRIMARY KEY CLUSTERED (
		[actionID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[dm_devices]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[dm_devices](
		[devicePK] [int] IDENTITY(1,1) NOT NULL,
		[deviceID] [nvarchar](255) NULL,
		[manufacturer] [nvarchar](255) NULL,
		[model] [nvarchar](255) NULL,
		[dmVersion] [nvarchar](255) NULL,
		[language] [nvarchar](255) NULL,
		[digest] [nvarchar](255) NULL,
		[client_nonce] [varbinary](255) NULL,
		[server_nonce] [varbinary](255) NULL,
		[deleted] [tinyint] NULL,
		[phoneNumber] [nvarchar](255) NULL,
		[bootID] [nvarchar](255) NULL,
		[connectionState] [nvarchar](255) NULL,
		[user] [int] NULL,
	 CONSTRAINT [PK__dm_devices] PRIMARY KEY CLUSTERED (
		[devicePK] ASC
	)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF),
	 CONSTRAINT [UQ__dm_devices__bootID] UNIQUE NONCLUSTERED (
		[bootID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[dm_device_tree]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[dm_device_tree](
		[deviceID] [nvarchar](50) NOT NULL,
		[nodeTree] [image] NULL,
		[createdDate] [datetime] NULL,
	 CONSTRAINT [PK__dm_device_tree] PRIMARY KEY CLUSTERED (
		[deviceID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;


IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[dm_persisted_tree_structure]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[dm_persisted_tree_structure](
		[jobID] [nvarchar](255) NOT NULL,	
		[updatedDate] [datetime] NOT NULL,
		[treeStructure] [image] NOT NULL,
	 CONSTRAINT [PK__dm_persisted_tree_structure] PRIMARY KEY CLUSTERED (
		[jobID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[dm_path_exclusions]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[dm_path_exclusions](
		[pathExclusionID] [int] IDENTITY(1,1) NOT NULL,
		[path] [nvarchar](255) NOT NULL,
	CONSTRAINT [PK__dm_path_exclusions] PRIMARY KEY CLUSTERED (
		[pathExclusionID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[dm_job]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[dm_job](
		[jobID] [nvarchar](255) NOT NULL,
		[status] [nvarchar](255) NULL,
		[created] [datetime] NULL,
		[deleted] [tinyint] NULL,
		[exploreJob] [tinyint] NULL,
		[responseOnStatus] [tinyint] NULL,
		[nextResend] [datetime] NULL,
		[resetCount] [int] NULL,
		[runAfter] [datetime] NULL,
		[blockDevice] [tinyint] NULL,
		[device] [int] NULL,
	 CONSTRAINT [PK__dm_job] PRIMARY KEY CLUSTERED (
		[jobID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[dm_initiateMessages]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[dm_initiateMessages](
		[initiateMessageID] [int] IDENTITY(1,1) NOT NULL,
		[created] [datetime] NOT NULL,
		[status] [nvarchar](255) NOT NULL,
		[devicePK] [int] NOT NULL,
		[jobID] [nvarchar](255) NOT NULL,
	CONSTRAINT [PK__dm_initiateMessages] PRIMARY KEY CLUSTERED (
		[initiateMessageID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF),
	CONSTRAINT [UQ__dm_initiateMessages_jobID] UNIQUE NONCLUSTERED (
		[jobID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF) 
	)
END;


IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[dm_task]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[dm_task](
		[id] [int] IDENTITY(1,1) NOT NULL,
		[state] [nvarchar](255) NULL,
		[job] [nvarchar](255) NOT NULL,
		[actionPlan] [int] NOT NULL,
	 CONSTRAINT [PK__dm_task] PRIMARY KEY CLUSTERED (
		[id] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[dm_connection_history]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[dm_connection_history](
		[ID] [int] IDENTITY(1,1) NOT NULL,
		[created] [datetime] NULL,
		[state] [nvarchar](255) NULL,
		[device] [int] NOT NULL,
	 CONSTRAINT [PK__dm_connection_history] PRIMARY KEY CLUSTERED (
		[ID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[dm_ddf]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[dm_ddf](
		[ddfID] [int] IDENTITY(1,1) NOT NULL,
		[name] [nvarchar](100) NULL,
		[fileName] [nvarchar](255) NULL,
		[description] [nvarchar](max) NULL,
		[xml] [nvarchar](max) NULL,
		[groupName] [nvarchar](100) NULL,
		[changeDate] [datetime] NULL,
	CONSTRAINT [PK__dm_dff] PRIMARY KEY CLUSTERED 
	(
		[ddfID] ASC
	)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[dm_ddf_conf]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[dm_ddf_conf](
		[ddfConfID] [int] IDENTITY(1,1) NOT NULL,
		[name] [nvarchar](100) NULL,
		[description] [nvarchar](max) NULL,
		[groupName] [nvarchar](100) NULL,
		[changeDate] [datetime] NULL,
		[ddfID] [int] 
	CONSTRAINT [PK__dm_ddf_conf] PRIMARY KEY CLUSTERED (
		[ddfConfID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[dm_ddf_values]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[dm_ddf_values](
		[ddfValueID] [int] IDENTITY(1,1) NOT NULL,
		[value] [image] NULL,
		[valueName] [nvarchar](255) NULL,
		[priority] [int] NULL,
		[type] [nvarchar](255) NULL, 
		[path] [nvarchar](1024) NULL, 
		[format] [nvarchar](50) NULL,
		[operation] [nvarchar](50) NULL,
		[ddfConfID] [int] NOT NULL,
	CONSTRAINT [PK__dm_ddf_values] PRIMARY KEY CLUSTERED (
		[ddfValueID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[userProperty]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[userProperty](
		[property] [nvarchar](150) NOT NULL,
		[userID] [nvarchar](50) NOT NULL,
		[value] [nvarchar](250) NULL,
		[type] [nvarchar](250) NULL,
		[changed] [datetime] NULL,
	 CONSTRAINT [PK__userProperty] PRIMARY KEY CLUSTERED (
		[property] ASC,
		[userID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[userLdapGroup]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[userLdapGroup](
		[userID] [nvarchar](50) NOT NULL,
		[ldapGroup] [nvarchar](250) NOT NULL,
		[ldapServer] [nvarchar](250) NOT NULL,
	 CONSTRAINT [PK__userLdapGroup] PRIMARY KEY CLUSTERED (
		[userID] ASC,
		[ldapGroup] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)

	CREATE NONCLUSTERED INDEX [IX_userLdapGroup_ldapServer] ON [dbo].[userLdapGroup] (
		[ldapServer] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ConnectorUser]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[ConnectorUser](
		[connectorId] [nvarchar](50) NOT NULL,
		[functionName] [nvarchar](128) NOT NULL,
		[userID] [nvarchar](50) NOT NULL,
		[supported] [tinyint] NULL,
		[success] [int] NULL,
		[error] [int] NULL,
	CONSTRAINT [PK__ConnectorUser] PRIMARY KEY CLUSTERED (
		[connectorId] ASC,
		[functionName] ASC,
		[userID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[countryrates]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[CountryRates](
		[CountryRatesID] [int] IDENTITY(1,1) NOT NULL,
		[InternationalRate] [decimal](10, 4) NULL,
		[MMSRate] [decimal](10, 4) NULL,
		[SMSRate] [decimal](10, 4) NULL,
		[TrafficMB] [decimal](10, 4) NULL,
		[type] [nvarchar](255) NULL,
		[mcc] [int] NULL,
		[subscription] [int] NOT NULL,
	CONSTRAINT [PK_CountryRates] PRIMARY KEY CLUSTERED (
		[CountryRatesID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF) 
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[dm_operation]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[dm_operation](
		[operationID] [int] IDENTITY(1,1) NOT NULL,
		[command] [nvarchar](255) NULL,
		[statusCode] [nvarchar](255) NULL,
		[jobNodeID] [nvarchar](255) NULL,
		[resultNode_id] [int] NULL,
		[node_id] [int] NULL,
		[task] [int] NULL,
	 CONSTRAINT [PK__dm_operation] PRIMARY KEY CLUSTERED (
		[operationID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[dm_support_param]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[dm_support_param](
		[paramID] [int] IDENTITY(1,1) NOT NULL,
		[paramName] [nvarchar](255) NULL,
		[paramValue] [nvarchar](255) NULL,
		[support] [int] NULL,
	 CONSTRAINT [PK__dm_support_param] PRIMARY KEY CLUSTERED (
		[paramID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ConnectorProperty]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[ConnectorProperty](
		[connectorId] [nvarchar](50) NOT NULL,
		[keyName] [nvarchar](128) NOT NULL,
		[propertyValue] [nvarchar](2048) NULL,
	 CONSTRAINT [PK__ConnectorProperty] PRIMARY KEY CLUSTERED (
		[connectorId] ASC,
		[keyName] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;


IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ConnectorFunction]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[ConnectorFunction](
		[functionName] [nvarchar](128) NOT NULL,
		[connectorId] [nvarchar](50) NOT NULL,
		[functionState] [nvarchar](25) NULL,
		[acceptPoll] [tinyint] NULL,
		[applicationId] [nvarchar](250) NULL,
	 CONSTRAINT [PK__ConnectorFunction] PRIMARY KEY CLUSTERED (
		[connectorId] ASC,
		[functionName] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[prov_iphone_cacertificate]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[prov_iphone_cacertificate](
		[certificateID] [int] IDENTITY(1,1) NOT NULL,
		[certificate] [image] NULL,
		[defaultCA] [tinyint] NULL,
		[encryptedkeyPair] [image] NULL,
		[subjectDN] [nvarchar] (450) NULL,
	CONSTRAINT [PK__prov_iphone_cacertificate] PRIMARY KEY CLUSTERED (
		[certificateID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[prov_iphone_configuration_profile]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[prov_iphone_configuration_profile](
		[profileID] [nvarchar](255) NOT NULL,
		[category] [nvarchar](255) NULL,
		[changeDate] [datetime] NULL,
		[content] [image] NULL,
		[description] [nvarchar](255) NULL,
		[fileName] [nvarchar](255) NULL,
		[hash] [nvarchar](255) NULL,
		[identifier] [nvarchar](255) NULL,
		[name] [nvarchar](255) NULL,
		[smsCode] [nvarchar](255) NULL,
		[uuid] [nvarchar](255) NULL,
		[encrypted] [tinyint] NULL,
		[organization] [nvarchar](255) NULL,
		[signed] [tinyint] NULL,
	CONSTRAINT [PK__prov_iphone_configuration_profile] PRIMARY KEY CLUSTERED (
		[profileID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	) 
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[prov_iphone_enrollment]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[prov_iphone_enrollment](
		[enrollmentID] [nvarchar](40) NOT NULL,
		[apnInfo] [image] NULL,
		[apnToken] [nvarchar](255) NULL,
		[certificate] [image] NULL,
		[challenge] [nvarchar](100) NULL,
		[created] [datetime] NULL,
		[deviceID] [nvarchar](50) NULL,
		[lastState] [nvarchar](60) NULL,
		[lastStatusDate] [datetime] NULL,
		[phoneNumber] [nvarchar](50) NULL,
		[status] [image] NULL,
		[subject] [nvarchar](255) NULL,
		[userID] [nvarchar](255) NULL,
		[caCertificate] [int] NULL,
	CONSTRAINT [PK__prov_iphone_enrollment] PRIMARY KEY CLUSTERED (
		[enrollmentID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)

    CREATE NONCLUSTERED INDEX [IX__pie__subject] ON [dbo].[prov_iphone_enrollment] (
		[subject] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)

    CREATE NONCLUSTERED INDEX [IX__pie__apnToken] ON [dbo].[prov_iphone_enrollment] (
		[apnToken] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)

    CREATE NONCLUSTERED INDEX [IX__pie__deviceID] ON [dbo].[prov_iphone_enrollment] (
		[deviceID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)

    CREATE NONCLUSTERED INDEX [IX__pie__lastStatusDate] ON [dbo].[prov_iphone_enrollment] (
		[lastStatusDate] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[prov_iphone_installed_certificates]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[prov_iphone_installed_certificates](
		[installedCertificateID] [int] IDENTITY(1,1) NOT NULL,
		[certificate] [image] NULL,
		[name] [nvarchar](255) NULL,
		[updateDate] [datetime] NULL,
		[enrollment] [nvarchar](40) NULL,
	CONSTRAINT [PK__prov_iphone_installed_certificates] PRIMARY KEY CLUSTERED (
		[installedCertificateID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	) 
END;


IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[prov_iphone_installed_profiles]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[prov_iphone_installed_profiles](
		[installedProfileID] [int] IDENTITY(1,1) NOT NULL,
		[created] [datetime] NULL,
		[groupInstall] [int] NULL,
		[hash] [nvarchar](255) NULL,
		[identifier] [nvarchar](255) NULL,
		[markForRemove] [tinyint] NULL,
		[profile] [image] NULL,
		[profileType] [nvarchar](255) NULL,
		[uuid] [nvarchar](255) NULL,
		[enrollment] [nvarchar](40) NULL,
		[iphoneProfile] [nvarchar](255) NULL,
	CONSTRAINT [PK__prov_iphone_installed_profiles] PRIMARY KEY CLUSTERED (
		[installedProfileID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF) 
	) 
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[prov_iphone_installed_restrictions]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[prov_iphone_installed_restrictions](
		[installedRestrictionID] [int] IDENTITY(1,1) NOT NULL,
		[name] [nvarchar](255) NULL,
		[restrictions] [image] NULL,
		[updateDate] [datetime] NULL,
		[enrollment] [nvarchar](40) NULL,
	CONSTRAINT [PK__prov_iphone_installed_restrictions] PRIMARY KEY CLUSTERED (
		[installedRestrictionID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	) 
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[prov_iphone_operations]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[prov_iphone_operations](
		[operationID] [int]  IDENTITY(1,1) NOT NULL,
		[createdDate] [datetime] NULL,
		[lastStatus] [nvarchar] (50) NULL,
		[lastStatusDate] [datetime] NULL,
		[mdmRequest] [image] NULL,
		[meta] [nvarchar] (100) NULL,
		[queueDate] [datetime] NULL,
		[requestType] [nvarchar] (50) NULL,
		[requestUUID] [nvarchar] (60) NULL,
		[status] [image] NULL,
		[waitForOperationID] [int] NULL,
		[waitPath] [nvarchar](255) NULL,
		[waitSendIf] [nvarchar](255) NULL,
		[enrollment] [nvarchar] (40) NULL, 
		[jobGroup] [nvarchar](255) NULL,
	CONSTRAINT [PK__prov_iphone_operations] PRIMARY KEY CLUSTERED (
		[operationID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)

    CREATE NONCLUSTERED INDEX [IX__pio__lastStatusDate] ON [dbo].[prov_iphone_operations] (
		[lastStatusDate] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
END;


IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[prov_iphone_profile_group]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[prov_iphone_profile_group](
		[groupId] [int] NOT NULL,
		[profileID] [nvarchar](100) NOT NULL,
	CONSTRAINT [PK__prov_iphone_profile_group] PRIMARY KEY CLUSTERED (
		[groupId] ASC,
		[profileID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	) 
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[prov_iphone_provisioning_profile]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[prov_iphone_provisioning_profile](
		[profileID] [nvarchar](255) NOT NULL,
		[category] [nvarchar](255) NULL,
		[changeDate] [datetime] NULL,
		[content] [image] NULL,
		[description] [nvarchar](255) NULL,
		[fileName] [nvarchar](255) NULL,
		[hash] [nvarchar](255) NULL,
		[identifier] [nvarchar](255) NULL,
		[name] [nvarchar](255) NULL,
		[smsCode] [nvarchar](255) NULL,
		[uuid] [nvarchar](255) NULL,
		[expirationDate] [datetime] NULL,
	CONSTRAINT [PK__prov_iphone_provisioning_profile] PRIMARY KEY CLUSTERED (
		[profileID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	) 
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[prov_job_group]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[prov_job_group](
		[groupID] [nvarchar](255) NOT NULL,
		[createdDate] [datetime] NULL,
		[description] [nvarchar](255) NULL,
		[groupType] [nvarchar](255) NULL,
		[operation] [nvarchar](255) NULL,
		[scheduled] [image] NULL,
	CONSTRAINT [PK__prov_job_group] PRIMARY KEY CLUSTERED (
		[groupID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	) 
END;

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[roamingrates]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[roamingrates](
		[roamingRatesID] [int] IDENTITY(1,1) NOT NULL,
		[internationalRate] [decimal](10, 4) NULL,
		[mmsRate] [decimal](10, 4) NULL,
		[smsRate] [decimal](10, 4) NULL,
		[trafficMB] [decimal](10, 4) NULL,
	CONSTRAINT [PK__roamingrates] PRIMARY KEY CLUSTERED (
		[roamingRatesID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	) 
END;


IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DME_UI_Preference]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[DME_UI_Preference](
		[ClassName] [nvarchar](30) NOT NULL,
		[Preference] [varbinary](255) NULL,
		[PreferenceName] [nvarchar](255) NOT NULL,
		[UserId] [nvarchar](50) NOT NULL,
	CONSTRAINT [PK__DME_UI_Preference] PRIMARY KEY CLUSTERED (
		[ClassName] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF),
	CONSTRAINT [UQ__DME_UI_Preference__UserId__ClassName__PreferenceName]  UNIQUE NONCLUSTERED ( 
		[UserId] ASC,
		[ClassName] ASC,
		[PreferenceName] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)
END;


PRINT '* Creating database constraints';

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK6208E0B4FBA83726]') AND parent_object_id = OBJECT_ID(N'[dbo].[AppBoxApplicationInfo]'))
  ALTER TABLE [dbo].[AppBoxApplicationInfo]  WITH CHECK ADD  CONSTRAINT [FK6208E0B4FBA83726] FOREIGN KEY([applicationId]) REFERENCES [dbo].[AppBoxApplication] ([applicationId]) ON DELETE CASCADE;
ALTER TABLE [dbo].[AppBoxApplicationInfo] CHECK CONSTRAINT [FK6208E0B4FBA83726];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK6B57968D60EC6AC0]') AND parent_object_id = OBJECT_ID(N'[dbo].[AppBoxDataStore]'))
  ALTER TABLE [dbo].[AppBoxDataStore]  WITH CHECK ADD  CONSTRAINT [FK6B57968D60EC6AC0] FOREIGN KEY([applicationId],[deviceId]) REFERENCES [dbo].[AppBoxInstalledOn] ([applicationId],[deviceId]) ON DELETE CASCADE;
ALTER TABLE [dbo].[AppBoxDataStore] CHECK CONSTRAINT [FK6B57968D60EC6AC0];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FKA648D3BDFBA83726]') AND parent_object_id = OBJECT_ID(N'[dbo].[AppBoxDeploymentInfo]'))
  ALTER TABLE [dbo].[AppBoxDeploymentInfo]  WITH CHECK ADD  CONSTRAINT [FKA648D3BDFBA83726] FOREIGN KEY([applicationId]) REFERENCES [dbo].[AppBoxApplication] ([applicationId]) ON DELETE CASCADE;
ALTER TABLE [dbo].[AppBoxDeploymentInfo] CHECK CONSTRAINT [FKA648D3BDFBA83726];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK328B63FBFBA83726]') AND parent_object_id = OBJECT_ID(N'[dbo].[AppBoxFilestore]'))
  ALTER TABLE [dbo].[AppBoxFilestore]  WITH CHECK ADD  CONSTRAINT [FK328B63FBFBA83726] FOREIGN KEY([applicationId]) REFERENCES [dbo].[AppBoxApplication] ([applicationId]) ON DELETE CASCADE;
ALTER TABLE [dbo].[AppBoxFilestore] CHECK CONSTRAINT [FK328B63FBFBA83726];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK9F69308FD9276726]') AND parent_object_id = OBJECT_ID(N'[dbo].[AppBoxInstalledOn]'))
  ALTER TABLE [dbo].[AppBoxInstalledOn]  WITH CHECK ADD  CONSTRAINT [FK9F69308FD9276726] FOREIGN KEY([deviceId]) REFERENCES [dbo].[terminal] ([terminalID]) ON DELETE CASCADE;
ALTER TABLE [dbo].[AppBoxInstalledOn] CHECK CONSTRAINT [FK9F69308FD9276726];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK9F69308FFBA83726]') AND parent_object_id = OBJECT_ID(N'[dbo].[AppBoxInstalledOn]'))
  ALTER TABLE [dbo].[AppBoxInstalledOn]  WITH CHECK ADD  CONSTRAINT [FK9F69308FFBA83726] FOREIGN KEY([applicationId]) REFERENCES [dbo].[AppBoxApplication] ([applicationId]) ON DELETE CASCADE;
ALTER TABLE [dbo].[AppBoxInstalledOn] CHECK CONSTRAINT [FK9F69308FFBA83726];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK9905F61DBE6492B6]') AND parent_object_id = OBJECT_ID(N'[dbo].[AppBoxRequestFunction]'))
  ALTER TABLE [dbo].[AppBoxRequestFunction]  WITH CHECK ADD  CONSTRAINT [FK9905F61DBE6492B6] FOREIGN KEY([applicationId],[requestHandler]) REFERENCES [dbo].[AppBoxRequestHandler] ([applicationId],[requestHandler]);
ALTER TABLE [dbo].[AppBoxRequestFunction] CHECK CONSTRAINT [FK9905F61DBE6492B6];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK248F865FBA83726]') AND parent_object_id = OBJECT_ID(N'[dbo].[AppBoxRequestHandler]'))
  ALTER TABLE [dbo].[AppBoxRequestHandler]  WITH CHECK ADD  CONSTRAINT [FK248F865FBA83726] FOREIGN KEY([applicationId]) REFERENCES [dbo].[AppBoxApplication] ([applicationId]) ON DELETE CASCADE;
ALTER TABLE [dbo].[AppBoxRequestHandler] CHECK CONSTRAINT [FK248F865FBA83726];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK67C96F25FBA83726]') AND parent_object_id = OBJECT_ID(N'[dbo].[ConnectorFunction]'))
  ALTER TABLE [dbo].[ConnectorFunction]  WITH CHECK ADD  CONSTRAINT [FK67C96F25FBA83726] FOREIGN KEY([applicationId]) REFERENCES [dbo].[AppBoxApplication] ([applicationId]) ON DELETE CASCADE;
ALTER TABLE [dbo].[ConnectorFunction] CHECK CONSTRAINT [FK67C96F25FBA83726];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK54EC142DB47D0252]') AND parent_object_id = OBJECT_ID(N'[dbo].[Connector]'))
  ALTER TABLE [dbo].[Connector] WITH CHECK ADD CONSTRAINT [FK54EC142DB47D0252] FOREIGN KEY([dmeDomainName]) REFERENCES [dbo].[DMEDomain]([domainName]);
ALTER TABLE [dbo].[Connector] CHECK CONSTRAINT [FK54EC142DB47D0252];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK67C96F255D6CA4BC]') AND parent_object_id = OBJECT_ID(N'[dbo].[ConnectorFunction]'))
  ALTER TABLE [dbo].[ConnectorFunction]  WITH CHECK ADD  CONSTRAINT [FK67C96F255D6CA4BC] FOREIGN KEY([connectorId]) REFERENCES [dbo].[Connector]([connectorId]) ON DELETE CASCADE;
ALTER TABLE [dbo].[ConnectorFunction] CHECK CONSTRAINT [FK67C96F255D6CA4BC];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FKDA47D9225D6CA4BC]') AND parent_object_id = OBJECT_ID(N'[dbo].[ConnectorProperty]'))
  ALTER TABLE [dbo].[ConnectorProperty]  WITH CHECK ADD  CONSTRAINT [FKDA47D9225D6CA4BC] FOREIGN KEY([connectorId]) REFERENCES [dbo].[Connector]([connectorId]) ON DELETE CASCADE;
ALTER TABLE [dbo].[ConnectorProperty] CHECK CONSTRAINT [FKDA47D9225D6CA4BC];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK1B6495988159F4BB]') AND parent_object_id = OBJECT_ID(N'[dbo].[ConnectorUser]'))
  ALTER TABLE [dbo].[ConnectorUser]  WITH CHECK ADD  CONSTRAINT [FK1B6495988159F4BB] FOREIGN KEY([userID]) REFERENCES [dbo].[usr]([userID]);
ALTER TABLE [dbo].[ConnectorUser] CHECK CONSTRAINT [FK1B6495988159F4BB];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK1B649598A0F9EB17]') AND parent_object_id = OBJECT_ID(N'[dbo].[ConnectorUser]'))
  ALTER TABLE [dbo].[ConnectorUser]  WITH CHECK ADD  CONSTRAINT [FK1B649598A0F9EB17] FOREIGN KEY([connectorId], [functionName]) 
   REFERENCES [dbo].[ConnectorFunction] ([connectorId], [functionName]) ON DELETE CASCADE;
ALTER TABLE [dbo].[ConnectorUser] CHECK CONSTRAINT [FK1B649598A0F9EB17];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK578F559D8E5C98B4]') AND parent_object_id = OBJECT_ID(N'[dbo].[countryRates]'))
  ALTER TABLE [dbo].[countryRates]  WITH CHECK ADD  CONSTRAINT [FK578F559D8E5C98B4] FOREIGN KEY([mcc]) REFERENCES [dbo].[dme_voice_locator] ([mcc]);
ALTER TABLE [dbo].[countryRates] CHECK CONSTRAINT [FK578F559D8E5C98B4];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK578F559DE20A5EA5]') AND parent_object_id = OBJECT_ID(N'[dbo].[countryRates]'))
  ALTER TABLE [dbo].[countryRates]  WITH CHECK ADD  CONSTRAINT [FK578F559DE20A5EA5] FOREIGN KEY([subscription]) REFERENCES [dbo].[subscriptions] ([subscriptionId]);
ALTER TABLE [dbo].[countryRates] CHECK CONSTRAINT [FK578F559DE20A5EA5];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK723AF2AC8EEF687F]') AND parent_object_id = OBJECT_ID(N'[dbo].[dm_action]'))
  ALTER TABLE [dbo].[dm_action]  WITH CHECK ADD  CONSTRAINT [FK723AF2AC8EEF687F] FOREIGN KEY([node_id]) REFERENCES [dbo].[dm_node] ([id]);
ALTER TABLE [dbo].[dm_action] CHECK CONSTRAINT [FK723AF2AC8EEF687F];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK723AF2ACA76DE723]') AND parent_object_id = OBJECT_ID(N'[dbo].[dm_action]'))
  ALTER TABLE [dbo].[dm_action]  WITH CHECK ADD  CONSTRAINT [FK723AF2ACA76DE723] FOREIGN KEY([actionPlan]) REFERENCES [dbo].[dm_action_plan] ([actionPlanPK]);
ALTER TABLE [dbo].[dm_action] CHECK CONSTRAINT [FK723AF2ACA76DE723];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK42152BA45D3EB49F]') AND parent_object_id = OBJECT_ID(N'[dbo].[dm_bootstrapMessages]'))
  ALTER TABLE [dbo].[dm_bootstrapMessages]  WITH CHECK ADD  CONSTRAINT [FK42152BA45D3EB49F] FOREIGN KEY([initiateMessageID]) REFERENCES [dbo].[dm_initiateMessages] ([initiateMessageID]);
ALTER TABLE [dbo].[dm_bootstrapMessages] CHECK CONSTRAINT [FK42152BA45D3EB49F];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FKB170BFA913CE9D71]') AND parent_object_id = OBJECT_ID(N'[dbo].[dm_connection_history]'))
  ALTER TABLE [dbo].[dm_connection_history]  WITH CHECK ADD  CONSTRAINT [FKB170BFA913CE9D71] FOREIGN KEY([device]) REFERENCES [dbo].[dm_devices] ([devicePK]) ON DELETE CASCADE;
ALTER TABLE [dbo].[dm_connection_history] CHECK CONSTRAINT [FKB170BFA913CE9D71];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK235C92D32CDC2353]') AND parent_object_id = OBJECT_ID(N'[dbo].[dm_ddf_conf]'))
  ALTER TABLE [dbo].[dm_ddf_conf]  WITH CHECK ADD  CONSTRAINT [FK235C92D32CDC2353] FOREIGN KEY([ddfID]) REFERENCES [dbo].[dm_ddf] ([ddfID]);
ALTER TABLE [dbo].[dm_ddf_conf] CHECK CONSTRAINT [FK235C92D32CDC2353];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FKDE2951114755E0BB]') AND parent_object_id = OBJECT_ID(N'[dbo].[dm_ddf_values]'))
  ALTER TABLE [dbo].[dm_ddf_values]  WITH CHECK ADD  CONSTRAINT [FKDE2951114755E0BB] FOREIGN KEY([ddfConfID]) REFERENCES [dbo].[dm_ddf_conf] ([ddfConfID]);
ALTER TABLE [dbo].[dm_ddf_values] CHECK CONSTRAINT [FKDE2951114755E0BB];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK775BC72763FC4C84]') AND parent_object_id = OBJECT_ID(N'[dbo].[dm_devices]'))
  ALTER TABLE [dbo].[dm_devices]  WITH CHECK ADD  CONSTRAINT [FK775BC72763FC4C84] FOREIGN KEY([user]) REFERENCES [dbo].[dm_users] ([userPK]);
ALTER TABLE [dbo].[dm_devices] CHECK CONSTRAINT [FK775BC72763FC4C84];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FKFDC2FCAF166BE886]') AND parent_object_id = OBJECT_ID(N'[dbo].[dm_dme_jobs]'))
  ALTER TABLE [dbo].[dm_dme_jobs]  WITH CHECK ADD  CONSTRAINT [FKFDC2FCAF166BE886] FOREIGN KEY([jobGroup]) REFERENCES [dbo].[prov_job_group] ([groupID]);
ALTER TABLE [dbo].[dm_dme_jobs] CHECK CONSTRAINT [FKFDC2FCAF166BE886];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK7B4227FBA5806DEC]') AND parent_object_id = OBJECT_ID(N'[dbo].[dm_initiateMessages]'))
  ALTER TABLE [dbo].[dm_initiateMessages]  WITH CHECK ADD  CONSTRAINT [FK7B4227FBA5806DEC] FOREIGN KEY([devicePK]) REFERENCES [dbo].[dm_devices] ([devicePK]);
ALTER TABLE [dbo].[dm_initiateMessages] CHECK CONSTRAINT [FK7B4227FBA5806DEC];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK7B4227FBFE5326B0]') AND parent_object_id = OBJECT_ID(N'[dbo].[dm_initiateMessages]'))
  ALTER TABLE [dbo].[dm_initiateMessages]  WITH CHECK ADD  CONSTRAINT [FK7B4227FBFE5326B0] FOREIGN KEY([jobID]) REFERENCES [dbo].[dm_job] ([jobID]);
ALTER TABLE [dbo].[dm_initiateMessages] CHECK CONSTRAINT [FK7B4227FBFE5326B0];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FKB0D16B0713CE9D71]') AND parent_object_id = OBJECT_ID(N'[dbo].[dm_job]'))
  ALTER TABLE [dbo].[dm_job]  WITH CHECK ADD  CONSTRAINT [FKB0D16B0713CE9D71] FOREIGN KEY([device]) REFERENCES [dbo].[dm_devices] ([devicePK]);
ALTER TABLE [dbo].[dm_job] CHECK CONSTRAINT [FKB0D16B0713CE9D71];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK695DC7F85C4450FD]') AND parent_object_id = OBJECT_ID(N'[dbo].[dm_node]'))
  ALTER TABLE [dbo].[dm_node]  WITH CHECK ADD  CONSTRAINT [FK695DC7F85C4450FD] FOREIGN KEY([nodeData]) REFERENCES [dbo].[dm_nodeData] ([pk]);
ALTER TABLE [dbo].[dm_node] CHECK CONSTRAINT [FK695DC7F85C4450FD];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FKD9C596445C4450FD]') AND parent_object_id = OBJECT_ID(N'[dbo].[dm_node_result]'))
  ALTER TABLE [dbo].[dm_node_result]  WITH CHECK ADD  CONSTRAINT [FKD9C596445C4450FD] FOREIGN KEY([nodeData]) REFERENCES [dbo].[dm_nodeData] ([pk]);
ALTER TABLE [dbo].[dm_node_result] CHECK CONSTRAINT [FKD9C596445C4450FD];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK712085311120390F]') AND parent_object_id = OBJECT_ID(N'[dbo].[dm_operation]'))
  ALTER TABLE [dbo].[dm_operation]  WITH CHECK ADD  CONSTRAINT [FK712085311120390F] FOREIGN KEY([task]) REFERENCES [dbo].[dm_task] ([id]);
ALTER TABLE [dbo].[dm_operation] CHECK CONSTRAINT [FK712085311120390F];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK712085318EEF687F]') AND parent_object_id = OBJECT_ID(N'[dbo].[dm_operation]'))
  ALTER TABLE [dbo].[dm_operation]  WITH CHECK ADD  CONSTRAINT [FK712085318EEF687F] FOREIGN KEY([node_id]) REFERENCES [dbo].[dm_node] ([id]);
ALTER TABLE [dbo].[dm_operation] CHECK CONSTRAINT [FK712085318EEF687F];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK71208531F50408BF]') AND parent_object_id = OBJECT_ID(N'[dbo].[dm_operation]'))
  ALTER TABLE [dbo].[dm_operation]  WITH CHECK ADD  CONSTRAINT [FK71208531F50408BF] FOREIGN KEY([resultNode_id]) REFERENCES [dbo].[dm_node_result] ([id]);
ALTER TABLE [dbo].[dm_operation] CHECK CONSTRAINT [FK71208531F50408BF];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FKAAA5EE74E3A3FE9]') AND parent_object_id = OBJECT_ID(N'[dbo].[dm_support_param]'))
  ALTER TABLE [dbo].[dm_support_param]  WITH CHECK ADD  CONSTRAINT [FKAAA5EE74E3A3FE9] FOREIGN KEY([support]) REFERENCES [dbo].[dm_support] ([supportID]);
ALTER TABLE [dbo].[dm_support_param] CHECK CONSTRAINT [FKAAA5EE74E3A3FE9];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK69604F7BA76DE723]') AND parent_object_id = OBJECT_ID(N'[dbo].[dm_task]'))
  ALTER TABLE [dbo].[dm_task]  WITH CHECK ADD  CONSTRAINT [FK69604F7BA76DE723] FOREIGN KEY([actionPlan]) REFERENCES [dbo].[dm_action_plan] ([actionPlanPK]); 
ALTER TABLE [dbo].[dm_task] CHECK CONSTRAINT [FK69604F7BA76DE723];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK69604F7BF84B14D5]') AND parent_object_id = OBJECT_ID(N'[dbo].[dm_task]'))
  ALTER TABLE [dbo].[dm_task]  WITH CHECK ADD  CONSTRAINT [FK69604F7BF84B14D5] FOREIGN KEY([job]) REFERENCES [dbo].[dm_job] ([jobID]) ON DELETE CASCADE;
ALTER TABLE [dbo].[dm_task] CHECK CONSTRAINT [FK69604F7BF84B14D5];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK134669638159F4BB]') AND parent_object_id = OBJECT_ID(N'[dbo].[DME_UI_Preference]'))
  ALTER TABLE [dbo].[DME_UI_Preference]  WITH CHECK ADD  CONSTRAINT [FK134669638159F4BB] FOREIGN KEY([UserId]) REFERENCES [dbo].[usr] ([userID]);
ALTER TABLE [dbo].[DME_UI_Preference] CHECK CONSTRAINT [FK134669638159F4BB];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK556796A48E5C98B4]') AND parent_object_id = OBJECT_ID(N'[dbo].[dme_voice_locator_name]'))
  ALTER TABLE [dbo].[dme_voice_locator_name]  WITH CHECK ADD  CONSTRAINT [FK556796A48E5C98B4] FOREIGN KEY([mcc]) REFERENCES [dbo].[dme_voice_locator] ([mcc]);
ALTER TABLE [dbo].[dme_voice_locator_name] CHECK CONSTRAINT [FK556796A48E5C98B4];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FKD5AC11166BE886]') AND parent_object_id = OBJECT_ID(N'[dbo].[downloadLinks]'))
  ALTER TABLE [dbo].[downloadLinks]  WITH CHECK ADD  CONSTRAINT [FKD5AC11166BE886] FOREIGN KEY([jobGroup]) REFERENCES [dbo].[prov_job_group] ([groupID]);
ALTER TABLE [dbo].[downloadLinks] CHECK CONSTRAINT [FKD5AC11166BE886];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK8F8CFA3212E5A3D9]') AND parent_object_id = OBJECT_ID(N'[dbo].[groupsupportedsettings]'))
  ALTER TABLE [dbo].[groupsupportedsettings]  WITH CHECK ADD  CONSTRAINT [FK8F8CFA3212E5A3D9] FOREIGN KEY([settingsId]) REFERENCES [dbo].[settings] ([id]);
ALTER TABLE [dbo].[groupsupportedsettings] CHECK CONSTRAINT [FK8F8CFA3212E5A3D9];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK8F8CFA32B0BBAE7C]') AND parent_object_id = OBJECT_ID(N'[dbo].[groupsupportedsettings]'))
  ALTER TABLE [dbo].[groupsupportedsettings]  WITH CHECK ADD  CONSTRAINT [FK8F8CFA32B0BBAE7C] FOREIGN KEY([localGroupId]) REFERENCES [dbo].[localGroup] ([groupID]);
ALTER TABLE [dbo].[groupsupportedsettings] CHECK CONSTRAINT [FK8F8CFA32B0BBAE7C];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK4C6211D4302204BC]') AND parent_object_id = OBJECT_ID(N'[dbo].[localGroup]'))
  ALTER TABLE [dbo].[localGroup]  WITH CHECK ADD  CONSTRAINT [FK4C6211D4302204BC] FOREIGN KEY([domainId]) REFERENCES [dbo].[domain] ([id]);
ALTER TABLE [dbo].[localGroup] CHECK CONSTRAINT [FK4C6211D4302204BC];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK1C594B47D0112]') AND parent_object_id = OBJECT_ID(N'[dbo].[prov_iphone_enrollment]'))
  ALTER TABLE [dbo].[prov_iphone_enrollment]  WITH CHECK ADD  CONSTRAINT [FK1C594B47D0112] FOREIGN KEY([caCertificate]) REFERENCES [dbo].[prov_iphone_cacertificate] ([certificateID]);
ALTER TABLE [dbo].[prov_iphone_enrollment] CHECK CONSTRAINT [FK1C594B47D0112];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FKA7BBEEE51D155C49]') AND parent_object_id = OBJECT_ID(N'[dbo].[prov_iphone_installed_certificates]'))
  ALTER TABLE [dbo].[prov_iphone_installed_certificates]  WITH CHECK ADD  CONSTRAINT [FKA7BBEEE51D155C49] FOREIGN KEY([enrollment]) REFERENCES [dbo].[prov_iphone_enrollment] ([enrollmentID]);
ALTER TABLE [dbo].[prov_iphone_installed_certificates] CHECK CONSTRAINT [FKA7BBEEE51D155C49];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK2CCA5931D155C49]') AND parent_object_id = OBJECT_ID(N'[dbo].[prov_iphone_installed_profiles]'))
  ALTER TABLE [dbo].[prov_iphone_installed_profiles]  WITH CHECK ADD  CONSTRAINT [FK2CCA5931D155C49] FOREIGN KEY([enrollment]) REFERENCES [dbo].[prov_iphone_enrollment] ([enrollmentID]);
ALTER TABLE [dbo].[prov_iphone_installed_profiles] CHECK CONSTRAINT [FK2CCA5931D155C49];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK4BC163501D155C49]') AND parent_object_id = OBJECT_ID(N'[dbo].[prov_iphone_installed_restrictions]'))
  ALTER TABLE [dbo].[prov_iphone_installed_restrictions]  WITH CHECK ADD  CONSTRAINT [FK4BC163501D155C49] FOREIGN KEY([enrollment]) REFERENCES [dbo].[prov_iphone_enrollment] ([enrollmentID]);
ALTER TABLE [dbo].[prov_iphone_installed_restrictions] CHECK CONSTRAINT [FK4BC163501D155C49];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FKA0C2D270166BE886]') AND parent_object_id = OBJECT_ID(N'[dbo].[prov_iphone_operations]'))
  ALTER TABLE [dbo].[prov_iphone_operations]  WITH CHECK ADD  CONSTRAINT [FKA0C2D270166BE886] FOREIGN KEY([jobGroup]) REFERENCES [dbo].[prov_job_group] ([groupID]);
ALTER TABLE [dbo].[prov_iphone_operations] CHECK CONSTRAINT [FKA0C2D270166BE886];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK1C594B47D0115]') AND parent_object_id = OBJECT_ID(N'[dbo].[prov_iphone_operations]'))
  ALTER TABLE [dbo].[prov_iphone_operations]  WITH CHECK ADD  CONSTRAINT [FK1C594B47D0115] FOREIGN KEY([enrollment]) REFERENCES [dbo].[prov_iphone_enrollment] ([enrollmentID]);
ALTER TABLE [dbo].[prov_iphone_operations] CHECK CONSTRAINT [FK1C594B47D0115];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FKBEDD0765694CAC47]') AND parent_object_id = OBJECT_ID(N'[dbo].[prov_iphone_profile_group]'))
  ALTER TABLE [dbo].[prov_iphone_profile_group]  WITH CHECK ADD  CONSTRAINT [FKBEDD0765694CAC47] FOREIGN KEY([groupId]) REFERENCES [dbo].[localGroup] ([groupID]);
ALTER TABLE [dbo].[prov_iphone_profile_group] CHECK CONSTRAINT [FKBEDD0765694CAC47];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK834B78CE581215FA]') AND parent_object_id = OBJECT_ID(N'[dbo].[RrdEntry]'))
  ALTER TABLE [dbo].[RrdEntry]  WITH CHECK ADD  CONSTRAINT [FK834B78CE581215FA] FOREIGN KEY([serverId]) REFERENCES [dbo].[Server] ([serverId]);
ALTER TABLE [dbo].[RrdEntry] CHECK CONSTRAINT [FK834B78CE581215FA];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK834B78CE5D6CA4BC]') AND parent_object_id = OBJECT_ID(N'[dbo].[RrdEntry]'))
  ALTER TABLE [dbo].[RrdEntry]  WITH CHECK ADD  CONSTRAINT [FK834B78CE5D6CA4BC] FOREIGN KEY([connectorId]) REFERENCES [dbo].[Connector] ([connectorId]);
ALTER TABLE [dbo].[RrdEntry] CHECK CONSTRAINT [FK834B78CE5D6CA4BC];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK5582BC23B0BBAE7C]') AND parent_object_id = OBJECT_ID(N'[dbo].[settings]'))
  ALTER TABLE [dbo].[settings]  WITH CHECK ADD  CONSTRAINT [FK5582BC23B0BBAE7C] FOREIGN KEY([localGroupId]) REFERENCES [dbo].[localGroup] ([groupID])
ALTER TABLE [dbo].[settings] CHECK CONSTRAINT [FK5582BC23B0BBAE7C];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK7674CAF62B13F27F]') AND parent_object_id = OBJECT_ID(N'[dbo].[subscriptions]'))
  ALTER TABLE [dbo].[subscriptions]  WITH CHECK ADD  CONSTRAINT [FK7674CAF62B13F27F] FOREIGN KEY([roamingRates]) REFERENCES [dbo].[roamingRates] ([roamingRatesID]);
ALTER TABLE [dbo].[subscriptions] CHECK CONSTRAINT [FK7674CAF62B13F27F];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK7674CAF667B6CF7D]') AND parent_object_id = OBJECT_ID(N'[dbo].[subscriptions]'))
  ALTER TABLE [dbo].[subscriptions]  WITH CHECK ADD  CONSTRAINT [FK7674CAF667B6CF7D] FOREIGN KEY([homeRates]) REFERENCES [dbo].[homeRates] ([homeRatesID]);
ALTER TABLE [dbo].[subscriptions] CHECK CONSTRAINT [FK7674CAF667B6CF7D];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK7674CAF6895906C8]') AND parent_object_id = OBJECT_ID(N'[dbo].[subscriptions]'))
  ALTER TABLE [dbo].[subscriptions]  WITH CHECK ADD  CONSTRAINT [FK7674CAF6895906C8] FOREIGN KEY([mcc], [mnc]) REFERENCES [dbo].[dme_voice_locator_name] ([mcc], [mnc]);
ALTER TABLE [dbo].[subscriptions] CHECK CONSTRAINT [FK7674CAF6895906C8];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK1C341CB5490769CC]') AND parent_object_id = OBJECT_ID(N'[dbo].[terminalAssetMgmt]'))
  ALTER TABLE [dbo].[terminalAssetMgmt]  WITH CHECK ADD  CONSTRAINT [FK1C341CB5490769CC] FOREIGN KEY([terminalId]) REFERENCES [dbo].[terminal] ([terminalID]) ON DELETE CASCADE;
ALTER TABLE [dbo].[terminalAssetMgmt] CHECK CONSTRAINT [FK1C341CB5490769CC];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK3355E599490769CC]') AND parent_object_id = OBJECT_ID(N'[dbo].[terminalGroupMembership]'))
  ALTER TABLE [dbo].[terminalGroupMembership]  WITH CHECK ADD  CONSTRAINT [FK3355E599490769CC] FOREIGN KEY([terminalID]) REFERENCES [dbo].[terminal] ([terminalID]);
ALTER TABLE [dbo].[terminalGroupMembership] CHECK CONSTRAINT [FK3355E599490769CC];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK3355E599B0BBAE7C]') AND parent_object_id = OBJECT_ID(N'[dbo].[terminalGroupMembership]'))
  ALTER TABLE [dbo].[terminalGroupMembership]  WITH CHECK ADD  CONSTRAINT [FK3355E599B0BBAE7C] FOREIGN KEY([localGroupID]) REFERENCES [dbo].[localGroup] ([groupID]);
ALTER TABLE [dbo].[terminalGroupMembership] CHECK CONSTRAINT [FK3355E599B0BBAE7C];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FKD3B39871490769CC]') AND parent_object_id = OBJECT_ID(N'[dbo].[terminalProperty]'))
  ALTER TABLE [dbo].[terminalProperty]  WITH CHECK ADD  CONSTRAINT [FKD3B39871490769CC] FOREIGN KEY([terminalID]) REFERENCES [dbo].[terminal] ([terminalID]) ON DELETE CASCADE;
ALTER TABLE [dbo].[terminalProperty] CHECK CONSTRAINT [FKD3B39871490769CC];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FKB1C5D1112061D4A7]') AND parent_object_id = OBJECT_ID(N'[dbo].[tinyCDR]'))
  ALTER TABLE [dbo].[tinyCDR]  WITH CHECK ADD  CONSTRAINT [FKB1C5D1112061D4A7] FOREIGN KEY([traffic_terminalID],[traffic_callID]) REFERENCES [dbo].[dme_traffic] ([terminalID],[callID]);
ALTER TABLE [dbo].[tinyCDR] CHECK CONSTRAINT [FKB1C5D1112061D4A7];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK12E9C1748159F4BB]') AND parent_object_id = OBJECT_ID(N'[dbo].[userGroup]'))
  ALTER TABLE [dbo].[userGroup]  WITH CHECK ADD  CONSTRAINT [FK12E9C1748159F4BB] FOREIGN KEY([userID]) REFERENCES [dbo].[usr] ([userID]);
ALTER TABLE [dbo].[userGroup] CHECK CONSTRAINT [FK12E9C1748159F4BB];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK12E9C174D33C29E0]') AND parent_object_id = OBJECT_ID(N'[dbo].[userGroup]'))
  ALTER TABLE [dbo].[userGroup]  WITH CHECK ADD  CONSTRAINT [FK12E9C174D33C29E0] FOREIGN KEY([roleID]) REFERENCES [dbo].[role] ([roleID]);
ALTER TABLE [dbo].[userGroup] CHECK CONSTRAINT [FK12E9C174D33C29E0];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK645DE38D8159F4BB]') AND parent_object_id = OBJECT_ID(N'[dbo].[userLdapGroup]'))
  ALTER TABLE [dbo].[userLdapGroup]  WITH CHECK ADD  CONSTRAINT [FK645DE38D8159F4BB] FOREIGN KEY([userID]) REFERENCES [dbo].[usr] ([userID]);
ALTER TABLE [dbo].[userLdapGroup] CHECK CONSTRAINT [FK645DE38D8159F4BB];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK970832C08159F4BB]') AND parent_object_id = OBJECT_ID(N'[dbo].[userProperty]'))
  ALTER TABLE [dbo].[userProperty]  WITH CHECK ADD  CONSTRAINT [FK970832C08159F4BB] FOREIGN KEY([userID]) REFERENCES [dbo].[usr] ([userID]);
ALTER TABLE [dbo].[userProperty] CHECK CONSTRAINT [FK970832C08159F4BB];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK8BD1E767490769CC]') AND parent_object_id = OBJECT_ID(N'[dbo].[userTerminal]'))
  ALTER TABLE [dbo].[userTerminal]  WITH CHECK ADD  CONSTRAINT [FK8BD1E767490769CC] FOREIGN KEY([terminalID]) REFERENCES [dbo].[terminal] ([terminalID]) ON DELETE CASCADE;
ALTER TABLE [dbo].[userTerminal] CHECK CONSTRAINT [FK8BD1E767490769CC];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK8BD1E7678159F4BB]') AND parent_object_id = OBJECT_ID(N'[dbo].[userTerminal]'))
  ALTER TABLE [dbo].[userTerminal]  WITH CHECK ADD  CONSTRAINT [FK8BD1E7678159F4BB] FOREIGN KEY([userID]) REFERENCES [dbo].[usr] ([userID]);
ALTER TABLE [dbo].[userTerminal] CHECK CONSTRAINT [FK8BD1E7678159F4BB];

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK1C594B47D0252]') AND parent_object_id = OBJECT_ID(N'[dbo].[usr]'))
  ALTER TABLE [dbo].[usr]  WITH CHECK ADD  CONSTRAINT [FK1C594B47D0252] FOREIGN KEY([dmeDomainName]) REFERENCES [dbo].[DMEDomain] ([domainName]);
ALTER TABLE [dbo].[usr] CHECK CONSTRAINT [FK1C594B47D0252];

PRINT '* Setting the database version ';

/** Setting the DME database structure version **/ 
UPDATE DME_System SET value = '20' WHERE name = 'DATABASE_STRUCTURE_VERSION';
IF @@ROWCOUNT = 0
  INSERT INTO DME_System (name,value) VALUES ('DATABASE_STRUCTURE_VERSION','20');

PRINT '* End ';
PRINT '===========================================================================';