/************************************************************************/
/************************************************************************/
/* DME 3.5 Database install script                                      */
/************************************************************************/
/* This script install the database structure for DME 3.5 SP7           */  
/************************************************************************/

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].[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__1273C1CD] 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].[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__14270015] 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__145C0A3F] 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] [tinyint] NULL,
		[belongsTo] [nvarchar](50) NULL,
		[sortBy] [int] NULL,
		[useInterval] [tinyint] NULL,
	CONSTRAINT [PK__settingsType__160F4887] 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__164452B1] 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__17F790F9] 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].[ThirdPartyEvent]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[ThirdPartyEvent](
		[syncID] [nvarchar](50) NOT NULL,
		[status] [int] NOT NULL,
		[userID] [int] NOT NULL,
		[eventValue] [ntext]  NOT NULL,
		[thirdPartyID] [nvarchar](50) NULL,
	CONSTRAINT [PK__ThirdPartyEvent__182C9B23] PRIMARY KEY CLUSTERED (	
		[syncID] 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__19DFD96B] 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].[ThirdPartyResponse]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[ThirdPartyResponse](
		[ThirdPartyResponsePK] [int] IDENTITY(1,1) NOT NULL,
		[value] [ntext]  NOT NULL,
		[type] [nvarchar](25) NOT NULL,
		[syncID] [nvarchar](50) NOT NULL,
	 CONSTRAINT [PK__ThirdPartyRespon__1A14E395] PRIMARY KEY CLUSTERED (
		[ThirdPartyResponsePK] 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].[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__syncAttachmentTa__1BC821DD] 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].[ThirdPartyStatus]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[ThirdPartyStatus](
		[ThirdPartyStatusPK] [int] IDENTITY(1,1) NOT NULL,
		[message] [ntext]  NOT NULL,
		[date] [datetime] NOT NULL,
		[status] [nvarchar](25) NOT NULL,
	CONSTRAINT [PK__ThirdPartyStatus__1BFD2C07] PRIMARY KEY CLUSTERED (
		[ThirdPartyStatusPK] 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].[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__1DB06A4F] 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].[ThirdPartyUserIdentifier]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[ThirdPartyUserIdentifier](
		[ThirdPartyUserIdentifierPK] [int] IDENTITY(1,1) NOT NULL,
		[value] [nvarchar](50) NOT NULL,
		[type] [nvarchar](25) NOT NULL,
		[dmeUserID] [nvarchar](50) NOT NULL,
	CONSTRAINT [PK__ThirdPartyUserId__1DE57479] PRIMARY KEY CLUSTERED (
		[ThirdPartyUserIdentifierPK] 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].[tempData]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[tempData](
		[keyField] [nvarchar](255) NOT NULL,
		[dataField] [image] NULL,
	CONSTRAINT [PK__tempData__1F98B2C1] 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,
		[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__1FCDBCEB] 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__20C1E124] 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__2180FB33] 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__22AA2996] 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__060DEAE8] PRIMARY KEY CLUSTERED (
		[domainName] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF),
	CONSTRAINT [UQ__DMEDomain__07020F21] UNIQUE NONCLUSTERED (
		[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__preferredMobileN__06CD04F7] 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__08B54D69] PRIMARY KEY CLUSTERED (
		[roleID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF),
	CONSTRAINT [UQ__role__09A971A2] UNIQUE NONCLUSTERED (
		[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__08EA5793] 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__0AD2A005] 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__0B91BA14] 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_ServerConfig__0CBAE877] 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__0D7A0286] 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__0EA330E9] 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__0F624AF8] 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 NOT NULL,	
		[data] [image] NULL,
	 CONSTRAINT [PK__DME_UpdateFile__108B795B] 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__defaultApplicati__24927208] 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](
		[terminalID] [nvarchar](50) NOT NULL,
		[localGroupID] [int] NULL,
		[groupType] [nvarchar](255) NULL,
	 CONSTRAINT [PK__terminalGroupMem__25518C17] 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_terminalGroupMembership_localGroupID] ON [dbo].[terminalGroupMembership] (
		[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].[defaultSettings]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[defaultSettings](
		[defaultSettingID] [int] IDENTITY(1,1) NOT NULL,
		[name] [nvarchar](250) NOT NULL,
		[value] [nvarchar](2048) NOT NULL,
		[lockOnTerminal] [smallint] NULL,
		[intervalSetting] [nvarchar](250) NULL,
		[changedDate] [datetime] NULL,
		[lockOnSuperuser] [smallint] NULL,
		[lockInterval] [smallint] NULL,
	 CONSTRAINT [PK__defaultSettings__267ABA7A] PRIMARY KEY CLUSTERED (
		[defaultSettingID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF)
	)

	CREATE NONCLUSTERED INDEX [IX_defaultSettings_name] ON [dbo].[defaultSettings] (
		[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].[terminalGroupMembership_tmp]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[terminalGroupMembership_tmp](
		[terminalID] [nvarchar](50) NOT NULL,
		[localGroupID] [int] NULL,
		[groupType] [nvarchar](255) NULL,
	 CONSTRAINT [PK__terminalGroupMem__2739D489] 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_terminalGroupMembershipTMP_localGroupID] ON [dbo].[terminalGroupMembership_tmp] (
		[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].[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__286302EC] 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__29221CFB] 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__2A4B4B5E] 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__terminalOwnerHis__2B0A656D] 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__2C3393D0] 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__2E1BDC42] 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__2F10007B] 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,
		[lastNotificationTimes] [varbinary](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__terminalRessourc__2EDAF651] 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].[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_syncAttachmen__30C33EC3] 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__30F848ED] 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__32AB8735] 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__32E0915F] 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].[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__3493CFA7] 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__02084FDA] 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__pendingNotificat__03F0984C] 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__pendingNotificat__04E4BC85] 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__3864608B] 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__38996AB5] 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__398D8EEE] 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].[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__367C1819] 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__3B75D760] 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,
		[deviceID] [nvarchar](255) NULL,
		[groupID]  [nvarchar](255) NULL,
		[phoneNumber] [nvarchar](255) NULL,
		[createdDate] [datetime] NULL,
		[jobRequest] [image] NULL,
		[requestType] [int] NULL,
		[status] [image] NULL,
		[nodeJobs] [image] NULL,
		[notifications] [image] NULL,
		[waitForJobID] [nvarchar](100) NULL,
		[waitSendIf] [nvarchar](50) NULL
	 CONSTRAINT [PK__dm_dme_jobs__4222D4EF] 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_error_devices]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[dm_error_devices](
		[errorDeviceID] [int] IDENTITY(1,1) NOT NULL,
		[errorState] [nvarchar](255) NULL,
		[phoneNumber] [nvarchar](250) NULL,
		[deviceID] [nvarchar](250) NULL,
		[createdDate] [datetime] NULL,
		[dmJobID] [nvarchar](255) NULL,
	 CONSTRAINT [PK__dm_error_devices__440B1D61] PRIMARY KEY CLUSTERED (
		[errorDeviceID] 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__49C3F6B7] 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__571DF1D5] 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_cer__59063A47] 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__5AEE82B9] 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_crl__5CD6CB2B] 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_ema__5EBF139D] 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_key__60A75C0F] 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] [ntext] NULL,
		[reportName] [nvarchar](250) NULL,
		[reportCategory] [nvarchar](250) NULL,
		[isRunnable] [tinyint] NULL,
	 CONSTRAINT [PK__dme_report__628FA481] 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_servicemonit__6477ECF3] 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](15) NULL,
		[trafficType] [nvarchar](250) NULL,
		[started] [datetime] NULL,
		[isRoaming] [tinyint] NOT NULL,
		[intMcc] [smallint] NULL,
		[intMnc] [smallint] NULL,
		[extMcc] [smallint] NULL,
		[callType] [tinyint] NULL,
		[duration_in] [int] NULL,
		[duration_out] [int] NULL,
		[registrated] [datetime] NULL,
	 CONSTRAINT [PK__dme_traffic__66603565] 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,
		[countryname] [nvarchar](50) NULL,
		[cc] [nvarchar](3) NULL,
		[idd] [nvarchar](50) NULL,
	 CONSTRAINT [PK__dme_voice_locato__68487DD7] 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_locato__6A30C649] 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] [smallint] NOT NULL,
		[mnc] [smallint] NOT NULL,
		[name] [nvarchar](50) NULL,
	 CONSTRAINT [PK__dme_voice_locato__6C190EBB] 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,
		[expires] [tinyint] NULL,
		[messageID] [nvarchar](255) NULL,
		[terminalID] [nvarchar](50) NULL,
		[created] [datetime] NULL,
		[phoneNr] [nvarchar](50) NULL,
		[updatefileID] [nvarchar](250) NULL,
		[downloaded] [tinyint] NULL,
	 CONSTRAINT [PK__downloadLinks__6E01572D] 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__6FE99F9F] 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__71D1E811] 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].[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__homeMobileNetwor__73BA3083] 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].[localGroup]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[localGroup](
		[groupID] [int] IDENTITY(1,1) NOT NULL,
		[name] [nvarchar](250) NOT NULL,
		[priority] [int] NULL,
		[ldapGroup] [nvarchar](250) NULL,
		[changedDate] [datetime] NULL,
		[licenseID] [nvarchar](100) NULL,
		[ldapServer] [nvarchar](250) NULL,
	 CONSTRAINT [PK__localGroup__75A278F5] 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__76969D2E] UNIQUE NONCLUSTERED (
		[priority] 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__localGroupRessou__787EE5A0] 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__7A672E12] 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,
		[dlr] [smallint] NULL,
	 CONSTRAINT [PK__message__7C4F7684] 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_software_install]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[dm_software_install](
		[softwareInstallID] [int] IDENTITY(1,1) NOT NULL,
		[requestedJobID] [nvarchar](255) NULL,
		[defaultVersion] [tinyint] NULL,
		[defaultVersionGroup] [nvarchar](255) NULL,
		[updateFileID] [nvarchar](255) NULL,
		[fallBackMethod] [nvarchar](255) NULL,
		[serviceSMS] [nvarchar](255) NULL,
		[serverPath] [tinyint] NULL,
		[gprsSetting] [nvarchar](255) NULL,
		[status] [nvarchar](255) NULL,
		[fileType] [nvarchar](255) NULL,
	 CONSTRAINT [PK__dm_software_inst__4F7CD00D] PRIMARY KEY CLUSTERED (
		[softwareInstallID] 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__5165187F] 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__notificationRess__7E37BEF6] 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__notificationSche__00200768] 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] NOT 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__7D78A4E7] PRIMARY KEY CLUSTERED	(
		[connectorId] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF),
	 CONSTRAINT [UQ__Connector__7E6CC920] UNIQUE NONCLUSTERED (
		[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__41EDCAC5] 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__3A4CA8FD] 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__40058253] 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,
	 CONSTRAINT [PK__terminalProperty__2CF2ADDF] 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](
		[settingID] [int] IDENTITY(1,1) NOT NULL,
		[name] [nvarchar](250) NOT NULL,
		[value] [nvarchar](2048) NOT NULL,
		[localGroupID] [nvarchar](5) NULL,
		[lockOnTerminal] [smallint] NULL,
		[intervalSetting] [nvarchar](250) NULL,
		[changedDate] [datetime] NULL,
		[inUse] [smallint] NULL,
		[noLicense] [tinyint] NULL,
		[terminalID] [nvarchar](50) NULL,
	 CONSTRAINT [PK__settings__114A936A] PRIMARY KEY CLUSTERED (
		[settingID] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF),
	 CONSTRAINT [UQ__settings__123EB7A3] UNIQUE NONCLUSTERED (
		[terminalID] ASC,
		[name] ASC,
		[localGroupID] 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__terminalAssetMgm__236943A5] 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__47DBAE45] 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__34C8D9D1] 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_action_dm_action]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[dm_action_dm_action](
		[dm_action_actionID] [int] NOT NULL,
		[children_actionID] [int] NOT NULL,
	 CONSTRAINT [UQ__dm_action_dm_act__36B12243] UNIQUE NONCLUSTERED (
		[children_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__3F466844] 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__403A8C7D] 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,
		[exploreJob] [tinyint] NULL,
		[responseOnStatus] [tinyint] NULL,
		[nextResend] [datetime] NULL,
		[resetCount] [int] NULL,
		[blockDevice] [tinyint] NULL,
		[device] [int] NULL,
	 CONSTRAINT [PK__dm_job__45F365D3] 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_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__5535A963] 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_hi__3D5E1FD2] 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) NOT NULL,
		[fileName] [nvarchar](255) NULL,
		[description] [nvarchar](max) NULL,
		[xml] [nvarchar](max) NULL,
		[groupName] [nvarchar](100) NULL,
		[changeDate] [datetime] NOT NULL,
	CONSTRAINT [PK__df_dff__ddfID] 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) NOT NULL,
		[description] [nvarchar](max) NULL,
		[groupName] [nvarchar](100) NULL,
		[changeDate] [datetime] NOT NULL,
		[ddfID] [int] 
	CONSTRAINT [PK__df_dff_conf__ddfConfID] 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,
		[priority] [int] NOT NULL,
		[type] [nvarchar](255) NULL, /* Max. MIME Type */
		[path] [nvarchar](1024) NOT NULL, /* Path into XML */
		[format] [nvarchar](50) NULL,
		[operation] [nvarchar](50) NULL,
		[ddfConfID] [int] NOT NULL,
	CONSTRAINT [PK__df_dff_values__ddfValueID] 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__3E1D39E1] 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__3C34F16F] 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](
		[function] [nvarchar](128) NOT NULL,
		[userID] [nvarchar](50) NOT NULL,
		[connectorId] [nvarchar](50) NOT NULL,
		[supported] [tinyint] NULL,
		[success] [int] NULL,
		[error] [int] NULL,
	 CONSTRAINT [PK__ConnectorUser__0425A276] PRIMARY KEY CLUSTERED (
		[function] ASC,
		[userID] ASC,
		[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].[dm_operation]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[dm_operation](
		[operationID] [int] IDENTITY(1,1) NOT NULL,
		[parent_operationID] [int] 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__4BAC3F29] 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__534D60F1] 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__ConnectorPropert__023D5A04] 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].[SuspectedConnectors]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[SuspectedConnectors](
		[connectorId] [nvarchar](50) NOT NULL,
		[serverId] [nvarchar](128) NOT NULL,
		[serverName] [nvarchar](100) NULL,
		[suspectedTime] [datetime] NULL,
	 CONSTRAINT [PK__SuspectedConnectors] PRIMARY KEY CLUSTERED (
		[connectorId] ASC,
		[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].[ConnectorFunction]') AND type in (N'U'))
BEGIN
	CREATE TABLE [dbo].[ConnectorFunction](
		[function] [nvarchar](128) NOT NULL,
		[connectorId] [nvarchar](50) NOT NULL,
		[functionState] [nvarchar](25) NULL,
		[acceptPoll] [tinyint] NULL,
	 CONSTRAINT [PK__ConnectorFunctio__00551192] PRIMARY KEY CLUSTERED (
		[function] ASC,
		[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].[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_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,
		[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_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,
		[responseObject] [image] NULL,
		[requestType] [nvarchar] (50) NULL,
		[requestUUID] [nvarchar] (60) NULL,
		[status] [image] NULL,
		[enrollment] [nvarchar] (40) 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;


PRINT '* Creating database constraints';

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]);
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]);
ALTER TABLE [dbo].[ConnectorProperty] CHECK CONSTRAINT [FKDA47D9225D6CA4BC];

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

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].[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].[FKC5D878D986039CC2]') AND parent_object_id = OBJECT_ID(N'[dbo].[dm_action_dm_action]'))
  ALTER TABLE [dbo].[dm_action_dm_action]  WITH CHECK ADD  CONSTRAINT [FKC5D878D986039CC2] FOREIGN KEY([dm_action_actionID]) REFERENCES [dbo].[dm_action] ([actionID]);
ALTER TABLE [dbo].[dm_action_dm_action] CHECK CONSTRAINT [FKC5D878D986039CC2];

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

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]);
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].[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].[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].[FK71208531F592B5C2]') AND parent_object_id = OBJECT_ID(N'[dbo].[dm_operation]'))
  ALTER TABLE [dbo].[dm_operation]  WITH CHECK ADD  CONSTRAINT [FK71208531F592B5C2] FOREIGN KEY([resultNode_id]) REFERENCES [dbo].[dm_node] ([id]);
ALTER TABLE [dbo].[dm_operation] CHECK CONSTRAINT [FK71208531F592B5C2];

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

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].[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].[FK5582BC23490769CC]') AND parent_object_id = OBJECT_ID(N'[dbo].[settings]'))
  ALTER TABLE [dbo].[settings]  WITH CHECK ADD  CONSTRAINT [FK5582BC23490769CC] FOREIGN KEY([terminalID]) REFERENCES [dbo].[terminal] ([terminalID]);
ALTER TABLE [dbo].[settings] CHECK CONSTRAINT [FK5582BC23490769CC];

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]);
ALTER TABLE [dbo].[terminalAssetMgmt] CHECK CONSTRAINT [FK1C341CB5490769CC];

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]);
ALTER TABLE [dbo].[terminalProperty] CHECK CONSTRAINT [FKD3B39871490769CC];

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]);
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];

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].[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];

PRINT '* Setting the database version ';

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

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