--# thanks to George Papastamatopoulos for submitting this ... and Marko Lahma for
--# updating it.
--#
--# In your Quartz properties file, you'll need to set 
--# org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.MSSQLDelegate
--#
--# you shouse enter your DB instance's name on the next line in place of "enter_db_name_here"
--#
--#
--# From a helpful (but anonymous) Quartz user:
--#
--# Regarding this error message:  
--#
--#     [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a cloned connection while in manual transaction mode.
--#
--#
--#     I added "SelectMethod=cursor;" to my Connection URL in the config file. 
--#     It Seems to work, hopefully no side effects.
--#
--#		example:
--#		"jdbc:microsoft:sqlserver://dbmachine:1433;SelectMethod=cursor"; 
--#
--# Another user has pointed out that you will probably need to use the 
--# JTDS driver
--#

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[QRTZ_FIRED_TRIGGERS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[QRTZ_FIRED_TRIGGERS]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[QRTZ_PAUSED_TRIGGER_GRPS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[QRTZ_PAUSED_TRIGGER_GRPS]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[QRTZ_SCHEDULER_STATE]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[QRTZ_SCHEDULER_STATE]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[QRTZ_LOCKS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[QRTZ_LOCKS]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[QRTZ_SIMPLE_TRIGGERS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[QRTZ_SIMPLE_TRIGGERS]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[QRTZ_SIMPROP_TRIGGERS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[QRTZ_SIMPROP_TRIGGERS]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[QRTZ_CRON_TRIGGERS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[QRTZ_CRON_TRIGGERS]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[QRTZ_BLOB_TRIGGERS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[QRTZ_BLOB_TRIGGERS]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[QRTZ_TRIGGERS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[QRTZ_TRIGGERS]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[QRTZ_JOB_DETAILS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[QRTZ_JOB_DETAILS]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[QRTZ_CALENDARS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[QRTZ_CALENDARS]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_QRTZ_TRIGGERS_QRTZ_JOB_DETAILS]') AND OBJECTPROPERTY(id, N'ISFOREIGNKEY') = 1)
ALTER TABLE [dbo].[QRTZ_TRIGGERS] DROP CONSTRAINT FK_QRTZ_TRIGGERS_QRTZ_JOB_DETAILS
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_QRTZ_CRON_TRIGGERS_QRTZ_TRIGGERS]') AND OBJECTPROPERTY(id, N'ISFOREIGNKEY') = 1)
ALTER TABLE [dbo].[QRTZ_CRON_TRIGGERS] DROP CONSTRAINT FK_QRTZ_CRON_TRIGGERS_QRTZ_TRIGGERS
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_QRTZ_SIMPLE_TRIGGERS_QRTZ_TRIGGERS]') AND OBJECTPROPERTY(id, N'ISFOREIGNKEY') = 1)
ALTER TABLE [dbo].[QRTZ_SIMPLE_TRIGGERS] DROP CONSTRAINT FK_QRTZ_SIMPLE_TRIGGERS_QRTZ_TRIGGERS
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_QRTZ_SIMPROP_TRIGGERS_QRTZ_TRIGGERS]') AND OBJECTPROPERTY(id, N'ISFOREIGNKEY') = 1)
ALTER TABLE [dbo].[QRTZ_SIMPROP_TRIGGERS] DROP CONSTRAINT FK_QRTZ_SIMPROP_TRIGGERS_QRTZ_TRIGGERS
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[CNTR_FARMS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[CNTR_FARMS]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[CNTR_TEMPLATES]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[CNTR_ANNOUNCEMENT]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[CNTR_ANNOUNCEMENT]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[CNTR_ANNOUNCEMENT]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[CNTR_SERVER_CACHES]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[CNTR_SERVER_CACHES]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[CNTR_CACHE_ERRORS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[CNTR_CACHE_ERRORS]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[CNTR_LICENSE]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[CNTR_LICENSE]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[CNTR_APPLICATIONS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[CNTR_APPLICATIONS]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[CNTR_FUNCTIONS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[CNTR_FUNCTIONS]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[CNTR_QUERIES]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[CNTR_QUERIES]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[CNTR_REPORTS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[CNTR_REPORTS]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[CNTR_EXTENSIONS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[CNTR_EXTENSIONS]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[CNTR_ROUTES]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[CNTR_ROUTES]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[CNTR_ROUTE_MAP]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[CNTR_ROUTE_MAP]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[CNTR_FUNCTION_APPLICATIONS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[CNTR_FUNCTION_APPLICATIONS]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[CNTR_QUERY_APPLICATIONS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[CNTR_QUERY_APPLICATIONS]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[CNTR_REPORT_APPLICATIONS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[CNTR_REPORT_APPLICATIONS]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[CNTR_EXTENSION_APPLICATIONS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[CNTR_EXTENSION_APPLICATIONS]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[CNTR_ROUTE_APPLICATIONS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[CNTR_ROUTE_APPLICATIONS]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[CNTR_FUNCTION_TAGS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[CNTR_FUNCTION_TAGS]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[CNTR_QUERY_TAGS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[CNTR_QUERY_TAGS]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[CNTR_REPORT_TAGS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[CNTR_REPORT_TAGS]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[CNTR_EXTENSION_TAGS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[CNTR_EXTENSION_TAGS]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[CNTR_ROUTE_TAGS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[CNTR_ROUTE_TAGS]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[CNTR_TAGS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[CNTR_TAGS]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[CNTR_TOKENS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[CNTR_TOKENS]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[CNTR_UNIQUE_ID]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[CNTR_UNIQUE_ID]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[CNTR_SERVICE_ROLES]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[CNTR_SERVICE_ROLES]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[CNTR_PUSH_NOTIFICATIONS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[CNTR_PUSH_NOTIFICATIONS]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[CNTR_PUSH_NOTIFICATION_TAGS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[CNTR_PUSH_NOTIFICATION_TAGS]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[CNTR_PROXY_USERS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[CNTR_PROXY_USERS]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[CNTR_ACCOUNTS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[CNTR_ACCOUNTS]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[CNTR_TENANTS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[CNTR_TENANTS]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[CNTR_ENVIRONMENTS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[CNTR_ENVIRONMENTS]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[CNTR_AGENTS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[CNTR_AGENTS]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[SCHD_REQUESTS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[SCHD_REQUESTS]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[SCHD_ENTITIES]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[SCHD_ENTITIES]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[SCHD_ENTITY_REQUESTS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[SCHD_ENTITY_REQUESTS]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[SCHD_ENTITY_DEPENDENCIES]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[SCHD_ENTITY_DEPENDENCIES]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[SCHD_VARIABLES]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[SCHD_VARIABLES]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[SCHD_REQUEST_LEDGER]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[SCHD_REQUEST_LEDGER]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[SCHD_ENTITY_LEDGER]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[SCHD_ENTITY_LEDGER]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[SCHD_NOTIFICATIONS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[SCHD_NOTIFICATIONS]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[SCHD_CHANGE_LEDGER]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[SCHD_CHANGE_LEDGER]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[SCHD_CALENDARS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[SCHD_CALENDARS]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[SCHD_CALENDAR_SLOTS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[SCHD_CALENDAR_SLOTS]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[SCHD_CALENDAR_TAGS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[SCHD_CALENDAR_TAGS]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[SCHD_ENTITY_TAGS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[SCHD_ENTITY_TAGS]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[SCHD_REQUEST_TAGS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
DROP TABLE [dbo].[SCHD_REQUEST_TAGS]
GO

CREATE TABLE [dbo].[QRTZ_JOB_DETAILS] (
  [SCHED_NAME] [VARCHAR] (120)  NOT NULL ,
  [JOB_NAME] [VARCHAR] (200)  NOT NULL ,
  [JOB_GROUP] [VARCHAR] (200)  NOT NULL ,
  [DESCRIPTION] [VARCHAR] (250) NULL ,
  [JOB_CLASS_NAME] [VARCHAR] (250)  NOT NULL ,
  [IS_DURABLE] [VARCHAR] (1)  NOT NULL ,
  [IS_NONCONCURRENT] [VARCHAR] (1)  NOT NULL ,
  [IS_UPDATE_DATA] [VARCHAR] (1)  NOT NULL ,
  [REQUESTS_RECOVERY] [VARCHAR] (1)  NOT NULL ,
  [JOB_DATA] [IMAGE] NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[QRTZ_TRIGGERS] (
  [SCHED_NAME] [VARCHAR] (120)  NOT NULL ,
  [TRIGGER_NAME] [VARCHAR] (200)  NOT NULL ,
  [TRIGGER_GROUP] [VARCHAR] (200)  NOT NULL ,
  [JOB_NAME] [VARCHAR] (200)  NOT NULL ,
  [JOB_GROUP] [VARCHAR] (200)  NOT NULL ,
  [DESCRIPTION] [VARCHAR] (250) NULL ,
  [NEXT_FIRE_TIME] [BIGINT] NULL ,
  [PREV_FIRE_TIME] [BIGINT] NULL ,
  [PRIORITY] [INTEGER] NULL ,
  [TRIGGER_STATE] [VARCHAR] (16)  NOT NULL ,
  [TRIGGER_TYPE] [VARCHAR] (8)  NOT NULL ,
  [START_TIME] [BIGINT] NOT NULL ,
  [END_TIME] [BIGINT] NULL ,
  [CALENDAR_NAME] [VARCHAR] (200)  NULL ,
  [MISFIRE_INSTR] [SMALLINT] NULL ,
  [JOB_DATA] [IMAGE] NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[QRTZ_SIMPLE_TRIGGERS] (
  [SCHED_NAME] [VARCHAR] (120)  NOT NULL ,
  [TRIGGER_NAME] [VARCHAR] (200)  NOT NULL ,
  [TRIGGER_GROUP] [VARCHAR] (200)  NOT NULL ,
  [REPEAT_COUNT] [BIGINT] NOT NULL ,
  [REPEAT_INTERVAL] [BIGINT] NOT NULL ,
  [TIMES_TRIGGERED] [BIGINT] NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[QRTZ_CRON_TRIGGERS] (
  [SCHED_NAME] [VARCHAR] (120)  NOT NULL ,
  [TRIGGER_NAME] [VARCHAR] (200)  NOT NULL ,
  [TRIGGER_GROUP] [VARCHAR] (200)  NOT NULL ,
  [CRON_EXPRESSION] [VARCHAR] (120)  NOT NULL ,
  [TIME_ZONE_ID] [VARCHAR] (80) 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[QRTZ_SIMPROP_TRIGGERS] (
  [SCHED_NAME] [VARCHAR] (120)  NOT NULL ,
  [TRIGGER_NAME] [VARCHAR] (200)  NOT NULL ,
  [TRIGGER_GROUP] [VARCHAR] (200)  NOT NULL ,
  [STR_PROP_1] [VARCHAR] (512) NULL,
  [STR_PROP_2] [VARCHAR] (512) NULL,
  [STR_PROP_3] [VARCHAR] (512) NULL,
  [INT_PROP_1] [INT] NULL,
  [INT_PROP_2] [INT] NULL,
  [LONG_PROP_1] [BIGINT] NULL,
  [LONG_PROP_2] [BIGINT] NULL,
  [DEC_PROP_1] [NUMERIC] (13,4) NULL,
  [DEC_PROP_2] [NUMERIC] (13,4) NULL,
  [BOOL_PROP_1] [VARCHAR] (1) NULL,
  [BOOL_PROP_2] [VARCHAR] (1) NULL,
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[QRTZ_BLOB_TRIGGERS] (
  [SCHED_NAME] [VARCHAR] (120)  NOT NULL ,
  [TRIGGER_NAME] [VARCHAR] (200)  NOT NULL ,
  [TRIGGER_GROUP] [VARCHAR] (200)  NOT NULL ,
  [BLOB_DATA] [IMAGE] NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[QRTZ_CALENDARS] (
  [SCHED_NAME] [VARCHAR] (120)  NOT NULL ,
  [CALENDAR_NAME] [VARCHAR] (200)  NOT NULL ,
  [CALENDAR] [IMAGE] NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[QRTZ_PAUSED_TRIGGER_GRPS] (
  [SCHED_NAME] [VARCHAR] (120)  NOT NULL ,
  [TRIGGER_GROUP] [VARCHAR] (200)  NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[QRTZ_FIRED_TRIGGERS] (
  [SCHED_NAME] [VARCHAR] (120)  NOT NULL ,
  [ENTRY_ID] [VARCHAR] (95)  NOT NULL ,
  [TRIGGER_NAME] [VARCHAR] (200)  NOT NULL ,
  [TRIGGER_GROUP] [VARCHAR] (200)  NOT NULL ,
  [INSTANCE_NAME] [VARCHAR] (200)  NOT NULL ,
  [FIRED_TIME] [BIGINT] NOT NULL ,
  [SCHED_TIME] [BIGINT] NOT NULL,
  [PRIORITY] [INT] NOT NULL ,
  [STATE] [VARCHAR] (16)  NOT NULL,
  [JOB_NAME] [VARCHAR] (200)  NULL ,
  [JOB_GROUP] [VARCHAR] (200)  NULL ,
  [IS_NONCONCURRENT] [VARCHAR] (1)  NULL ,
  [REQUESTS_RECOVERY] [VARCHAR] (1)  NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[QRTZ_SCHEDULER_STATE] (
  [SCHED_NAME] [VARCHAR] (120)  NOT NULL ,
  [INSTANCE_NAME] [VARCHAR] (200)  NOT NULL ,
  [LAST_CHECKIN_TIME] [BIGINT] NOT NULL ,
  [CHECKIN_INTERVAL] [BIGINT] NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[QRTZ_LOCKS] (
  [SCHED_NAME] [VARCHAR] (120)  NOT NULL ,
  [LOCK_NAME] [VARCHAR] (40)  NOT NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[QRTZ_CALENDARS] WITH NOCHECK ADD
  CONSTRAINT [PK_QRTZ_CALENDARS] PRIMARY KEY  CLUSTERED
  (
    [SCHED_NAME],
    [CALENDAR_NAME]
  )  ON [PRIMARY]
GO

ALTER TABLE [dbo].[QRTZ_CRON_TRIGGERS] WITH NOCHECK ADD
  CONSTRAINT [PK_QRTZ_CRON_TRIGGERS] PRIMARY KEY  CLUSTERED
  (
    [SCHED_NAME],
    [TRIGGER_NAME],
    [TRIGGER_GROUP]
  )  ON [PRIMARY]
GO

ALTER TABLE [dbo].[QRTZ_FIRED_TRIGGERS] WITH NOCHECK ADD
  CONSTRAINT [PK_QRTZ_FIRED_TRIGGERS] PRIMARY KEY  CLUSTERED
  (
    [SCHED_NAME],
    [ENTRY_ID]
  )  ON [PRIMARY]
GO

ALTER TABLE [dbo].[QRTZ_PAUSED_TRIGGER_GRPS] WITH NOCHECK ADD
  CONSTRAINT [PK_QRTZ_PAUSED_TRIGGER_GRPS] PRIMARY KEY  CLUSTERED
  (
    [SCHED_NAME],
    [TRIGGER_GROUP]
  )  ON [PRIMARY]
GO

ALTER TABLE [dbo].[QRTZ_SCHEDULER_STATE] WITH NOCHECK ADD
  CONSTRAINT [PK_QRTZ_SCHEDULER_STATE] PRIMARY KEY  CLUSTERED
  (
    [SCHED_NAME],
    [INSTANCE_NAME]
  )  ON [PRIMARY]
GO

ALTER TABLE [dbo].[QRTZ_LOCKS] WITH NOCHECK ADD
  CONSTRAINT [PK_QRTZ_LOCKS] PRIMARY KEY  CLUSTERED
  (
    [SCHED_NAME],
    [LOCK_NAME]
  )  ON [PRIMARY]
GO

ALTER TABLE [dbo].[QRTZ_JOB_DETAILS] WITH NOCHECK ADD
  CONSTRAINT [PK_QRTZ_JOB_DETAILS] PRIMARY KEY  CLUSTERED
  (
    [SCHED_NAME],
    [JOB_NAME],
    [JOB_GROUP]
  )  ON [PRIMARY]
GO

ALTER TABLE [dbo].[QRTZ_SIMPLE_TRIGGERS] WITH NOCHECK ADD
  CONSTRAINT [PK_QRTZ_SIMPLE_TRIGGERS] PRIMARY KEY  CLUSTERED
  (
    [SCHED_NAME],
    [TRIGGER_NAME],
    [TRIGGER_GROUP]
  )  ON [PRIMARY]
GO

ALTER TABLE [dbo].[QRTZ_SIMPROP_TRIGGERS] WITH NOCHECK ADD
  CONSTRAINT [PK_QRTZ_SIMPROP_TRIGGERS] PRIMARY KEY  CLUSTERED
  (
    [SCHED_NAME],
    [TRIGGER_NAME],
    [TRIGGER_GROUP]
  )  ON [PRIMARY]
GO

ALTER TABLE [dbo].[QRTZ_TRIGGERS] WITH NOCHECK ADD
  CONSTRAINT [PK_QRTZ_TRIGGERS] PRIMARY KEY  CLUSTERED
  (
    [SCHED_NAME],
    [TRIGGER_NAME],
    [TRIGGER_GROUP]
  )  ON [PRIMARY]
GO

ALTER TABLE [dbo].[QRTZ_CRON_TRIGGERS] ADD
  CONSTRAINT [FK_QRTZ_CRON_TRIGGERS_QRTZ_TRIGGERS] FOREIGN KEY
  (
    [SCHED_NAME],
    [TRIGGER_NAME],
    [TRIGGER_GROUP]
  ) REFERENCES [dbo].[QRTZ_TRIGGERS] (
    [SCHED_NAME],
    [TRIGGER_NAME],
    [TRIGGER_GROUP]
  ) ON DELETE CASCADE
GO

ALTER TABLE [dbo].[QRTZ_SIMPLE_TRIGGERS] ADD
  CONSTRAINT [FK_QRTZ_SIMPLE_TRIGGERS_QRTZ_TRIGGERS] FOREIGN KEY
  (
    [SCHED_NAME],
    [TRIGGER_NAME],
    [TRIGGER_GROUP]
  ) REFERENCES [dbo].[QRTZ_TRIGGERS] (
    [SCHED_NAME],
    [TRIGGER_NAME],
    [TRIGGER_GROUP]
  ) ON DELETE CASCADE
GO

ALTER TABLE [dbo].[QRTZ_SIMPROP_TRIGGERS] ADD
  CONSTRAINT [FK_QRTZ_SIMPROP_TRIGGERS_QRTZ_TRIGGERS] FOREIGN KEY
  (
    [SCHED_NAME],
    [TRIGGER_NAME],
    [TRIGGER_GROUP]
  ) REFERENCES [dbo].[QRTZ_TRIGGERS] (
    [SCHED_NAME],
    [TRIGGER_NAME],
    [TRIGGER_GROUP]
  ) ON DELETE CASCADE
GO

ALTER TABLE [dbo].[QRTZ_TRIGGERS] ADD
  CONSTRAINT [FK_QRTZ_TRIGGERS_QRTZ_JOB_DETAILS] FOREIGN KEY
  (
    [SCHED_NAME],
    [JOB_NAME],
    [JOB_GROUP]
  ) REFERENCES [dbo].[QRTZ_JOB_DETAILS] (
    [SCHED_NAME],
    [JOB_NAME],
    [JOB_GROUP]
  )
GO

CREATE TABLE [dbo].[CNTR_FARMS](
        [FARM_ID] BIGINT NOT NULL,
	[FARM_NAME] [varchar](255) NOT NULL,
	[FARM_DEFINITION] [varchar](max) NOT NULL,
 CONSTRAINT [PK_CNTR_FARMS] PRIMARY KEY CLUSTERED 
(
	[FARM_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CNTR_TEMPLATES](
        [TEMPLATE_ID] [varchar](40) NOT NULL,	
	[TEMPLATE_DEFINITION] [varchar](max) NOT NULL,
 CONSTRAINT [PK_CNTR_TEMPLATES] PRIMARY KEY CLUSTERED 
(
	[TEMPLATE_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CNTR_ANNOUNCEMENT](
        [ANNOUNCEMENT_ID] BIGINT NOT NULL,
	[BODY] [varchar](255) NOT NULL,
        [STATUS] [varchar](20) NOT NULL,
        [POSITION] [INTEGER] NOT NULL,
        [PRIORITY] [INTEGER] NOT NULL,
	[HEX_COLOR] [varchar](20) NOT NULL,
        [ICON_CLASS] [varchar](50) NOT NULL,
 CONSTRAINT [PK_CNTR_ANNOUNCEMENT] PRIMARY KEY CLUSTERED 
(
	[ANNOUNCEMENT_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CNTR_LICENSE](
        [LICENSE_ID] BIGINT NOT NULL,
	[LICENSE_DEFINITION] [varchar](max) NOT NULL,
 CONSTRAINT [PK_CNTR_LICENSE] PRIMARY KEY CLUSTERED 
(
	[LICENSE_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CNTR_ACCOUNTS](
        [ID] BIGINT NOT NULL,
	[TENANT_ID] BIGINT NOT NULL,
        [USERNAME] [varchar](255) NOT NULL,
        [DISPLAY_NAME] [varchar](255) NOT NULL,
        [EMAIL] [varchar](255) NOT NULL,
        [CONSOLE_ROLE] [varchar](30) NOT NULL,
 CONSTRAINT [PK_CNTR_ACCOUNTS] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CNTR_TENANTS](
        [TENANT_ID] BIGINT NOT NULL,	
	[DEFINITION] [varchar](max) NOT NULL,
 CONSTRAINT [PK_CNTR_TENANTS] PRIMARY KEY CLUSTERED 
(
	[TENANT_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CNTR_ENVIRONMENTS](
        [ENVIRONMENT_ID] BIGINT NOT NULL,
        [TENANT_ID] BIGINT NOT NULL,		
        [ENVIRONMENT_NAME] [varchar](255) NOT NULL,
	[DEFINITION] [varchar](max) NOT NULL,
 CONSTRAINT [PK_CNTR_ENVIRONMENTS] PRIMARY KEY CLUSTERED 
(
	[ENVIRONMENT_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CNTR_AGENTS](
        [AGENT_ID] BIGINT NOT NULL,
        [TENANT_ID] BIGINT NOT NULL,		
        [AGENT_KEY] [varchar](255) NOT NULL,
	[DEFINITION] [varchar](max) NOT NULL,
 CONSTRAINT [PK_CNTR_AGENTS] PRIMARY KEY CLUSTERED 
(
	[AGENT_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CNTR_APPLICATIONS](
        [APPLICATION_ID] BIGINT NOT NULL,
        [TENANT_ID] BIGINT NOT NULL,		
        [APPLICATION_NAME] [varchar](255) NOT NULL,
	[DEFINITION] [varchar](max) NOT NULL,
        [ICON_64] [varchar](max) NULL,
 CONSTRAINT [PK_CNTR_APPLICATIONS] PRIMARY KEY CLUSTERED 
(
	[APPLICATION_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CNTR_SERVER_CACHES](
        [SERVER_CACHE_ID] BIGINT NOT NULL,
        [TENANT_ID] BIGINT NOT NULL,		
        [SERVER_CACHE_NAME] [varchar](255) NOT NULL,	
 CONSTRAINT [PK_CNTR_SERVER_CACHES] PRIMARY KEY CLUSTERED 
(
	[SERVER_CACHE_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CNTR_CACHE_ERRORS](
        [CACHE_ERROR_ID] BIGINT NOT NULL,
        [SERVER_CACHE_ID] BIGINT NOT NULL,		
        [ERROR] [varchar](max) NOT NULL,
 CONSTRAINT [PK_CNTR_CACHE_ERRORS] PRIMARY KEY CLUSTERED 
(
	[CACHE_ERROR_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CNTR_PROXY_USERS](
        [PROXY_USER_ID] BIGINT NOT NULL,
        [PROXY_USER_NAME] [varchar](255) NOT NULL,        
        [TENANT_ID] BIGINT NOT NULL,		
        [DESCRIPTION] [varchar](255) NOT NULL,        
        [PASSWORD] [varchar](255) NULL,        
        [JDE_USERNAME] [varchar](255) NULL,        
        [JDE_PASSWORD] [varchar](255) NULL,        
        [JDE_ROLE] [varchar](255) NULL,        
        [ACTIVE] [INTEGER] NOT NULL,        
        [ADDRESS_NO] [INTEGER] NULL,        
        [BRANCH] [varchar](12) NULL,        
        [APPROVAL_ROUTE_CODE] [varchar](12) NULL,
        [DATE_CREATED] [DATETIME] NOT NULL,        
        [DATE_UPDATED] [DATETIME] NOT NULL,
        [IS_GROUP] [INTEGER] NOT NULL,
        [GROUP_NAME] [varchar](255) NULL,
 CONSTRAINT [PK_CNTR_PROXY_USERS] PRIMARY KEY CLUSTERED 
(
	[PROXY_USER_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO


CREATE TABLE [dbo].[CNTR_FUNCTIONS](
        [FUNCTION_ID] BIGINT NOT NULL,
        [TENANT_ID] BIGINT NOT NULL,
	[FUNCTION_NAME] [varchar](255) NOT NULL,
	[DEFINITION] [varchar](max) NOT NULL,
 CONSTRAINT [PK_CNTR_FUNCTIONS] PRIMARY KEY CLUSTERED 
(
	[FUNCTION_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CNTR_QUERIES](
        [QUERY_ID] BIGINT NOT NULL,
        [TENANT_ID] BIGINT NOT NULL,
	[QUERY_NAME] [varchar](255) NOT NULL,
	[DEFINITION] [varchar](max) NOT NULL,
 CONSTRAINT [PK_CNTR_QUERIES] PRIMARY KEY CLUSTERED 
(
	[QUERY_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CNTR_REPORTS](
        [REPORT_ID] BIGINT NOT NULL,
        [TENANT_ID] BIGINT NOT NULL,
	[REPORT_NAME] [varchar](255) NOT NULL,
	[DEFINITION] [varchar](max) NOT NULL,
 CONSTRAINT [PK_CNTR_REPORTS] PRIMARY KEY CLUSTERED 
(
	[REPORT_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CNTR_EXTENSIONS](
        [EXTENSION_ID] BIGINT NOT NULL,
        [TENANT_ID] BIGINT NOT NULL,
	[EXTENSION_NAME] [varchar](255) NOT NULL,
	[DEFINITION] [varchar](max) NOT NULL,
 CONSTRAINT [PK_CNTR_EXTENSIONS] PRIMARY KEY CLUSTERED 
(
	[EXTENSION_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CNTR_ROUTES](
        [ROUTE_ID] BIGINT NOT NULL,
        [TENANT_ID] BIGINT NOT NULL,
	[ROUTE_NAME] [varchar](255) NOT NULL,
	[DEFINITION] [varchar](max) NOT NULL,
 CONSTRAINT [PK_CNTR_ROUTES] PRIMARY KEY CLUSTERED 
(
	[ROUTE_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CNTR_ROUTE_MAP](
        [TENANT_ID] BIGINT NOT NULL,
	[MAP_NAME] [varchar](255) NOT NULL,
	[MAP_KEY] [varchar](255) NOT NULL,
	[MAP_VALUE] [varchar](255) NOT NULL,
 CONSTRAINT [PK_CNTR_ROUTE_MAP] PRIMARY KEY CLUSTERED 
(
        [TENANT_ID] ASC,
	[MAP_NAME] ASC,
        [MAP_KEY] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CNTR_TOKENS](
        [TENANT_ID] BIGINT NOT NULL,
	[USERNAME] [VARCHAR](255) NOT NULL,
	[APPLICATION] [VARCHAR](255) NOT NULL,
	[ENVIRONMENT] [VARCHAR](255) NOT NULL,
	[TOKEN] [VARCHAR](255) NOT NULL,
        [FCM_REGISTRATION_ID] [VARBINARY](4096),
	[PASSWORD] [VARCHAR](255) NOT NULL,
	[DATE_CREATED] [DATETIME] NOT NULL,
CONSTRAINT [PK_CNTR_TOKENS] PRIMARY KEY CLUSTERED 
(
        [TENANT_ID] ASC,
	[USERNAME] ASC,
	[APPLICATION] ASC,
	[ENVIRONMENT] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CNTR_TAGS](
        [TENANT_ID] BIGINT NOT NULL,
	[TAG_ID] BIGINT NOT NULL,
        [TAG_TYPE] [VARCHAR](30) NOT NULL,
	[TAG_LABEL] [VARCHAR](255) NOT NULL,
 CONSTRAINT [PK_CNTR_TAGS] PRIMARY KEY CLUSTERED 
(
	[TAG_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CNTR_FUNCTION_APPLICATIONS](
	[APPLICATION_ID] BIGINT NOT NULL,
	[FUNCTION_ID] BIGINT NOT NULL,
 CONSTRAINT [PK_CNTR_FUNCTION_APPLICATIONS] PRIMARY KEY CLUSTERED 
(
	[APPLICATION_ID] ASC,
	[FUNCTION_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CNTR_QUERY_APPLICATIONS](
	[APPLICATION_ID] BIGINT NOT NULL,
	[QUERY_ID] BIGINT NOT NULL,
 CONSTRAINT [PK_CNTR_QUERY_APPLICATIONS] PRIMARY KEY CLUSTERED 
(
	[APPLICATION_ID] ASC,
	[QUERY_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CNTR_REPORT_APPLICATIONS](
	[APPLICATION_ID] BIGINT NOT NULL,
	[REPORT_ID] BIGINT NOT NULL,
 CONSTRAINT [PK_CNTR_REPORT_APPLICATIONS] PRIMARY KEY CLUSTERED 
(
	[APPLICATION_ID] ASC,
	[REPORT_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CNTR_EXTENSION_APPLICATIONS](
	[APPLICATION_ID] BIGINT NOT NULL,
	[EXTENSION_ID] BIGINT NOT NULL,
 CONSTRAINT [PK_CNTR_EXTENSION_APPLICATIONS] PRIMARY KEY CLUSTERED 
(
	[APPLICATION_ID] ASC,
	[EXTENSION_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CNTR_ROUTE_APPLICATIONS](
	[APPLICATION_ID] BIGINT NOT NULL,
	[ROUTE_ID] BIGINT NOT NULL,
 CONSTRAINT [PK_CNTR_ROUTE_APPLICATIONS] PRIMARY KEY CLUSTERED 
(
	[APPLICATION_ID] ASC,
	[ROUTE_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CNTR_FUNCTION_TAGS](
	[TAG_ID] BIGINT NOT NULL,
	[FUNCTION_ID] BIGINT NOT NULL,
 CONSTRAINT [PK_CNTR_FUNCTION_TAGS] PRIMARY KEY CLUSTERED 
(
	[TAG_ID] ASC,
	[FUNCTION_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CNTR_QUERY_TAGS](
	[TAG_ID] BIGINT NOT NULL,
	[QUERY_ID] BIGINT NOT NULL,
 CONSTRAINT [PK_CNTR_QUERY_TAGS] PRIMARY KEY CLUSTERED 
(
	[TAG_ID] ASC,
	[QUERY_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CNTR_REPORT_TAGS](
	[TAG_ID] BIGINT NOT NULL,
	[REPORT_ID] BIGINT NOT NULL,
 CONSTRAINT [PK_CNTR_REPORT_TAGS] PRIMARY KEY CLUSTERED 
(
	[TAG_ID] ASC,
	[REPORT_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CNTR_EXTENSION_TAGS](
	[TAG_ID] BIGINT NOT NULL,
	[EXTENSION_ID] BIGINT NOT NULL,
 CONSTRAINT [PK_CNTR_EXTENSION_TAGS] PRIMARY KEY CLUSTERED 
(
	[TAG_ID] ASC,
	[EXTENSION_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CNTR_ROUTE_TAGS](
	[TAG_ID] BIGINT NOT NULL,
	[ROUTE_ID] BIGINT NOT NULL,
 CONSTRAINT [PK_CNTR_ROUTE_TAGS] PRIMARY KEY CLUSTERED 
(
	[TAG_ID] ASC,
	[ROUTE_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CNTR_SERVICE_ROLES](
    [TENANT_ID] BIGINT NOT NULL,
    [COMPONENT_TYPE] [VARCHAR](30) NOT NULL,
    [COMPONENT_NAME] [VARCHAR](255) NOT NULL,
    [ROLE_NAME] [VARCHAR](30) NOT NULL,
    CONSTRAINT [PK_CNTR_SERVICE_ROLES] PRIMARY KEY CLUSTERED 
    (
        [TENANT_ID] ASC,
	[COMPONENT_TYPE] ASC,
	[COMPONENT_NAME] ASC,
        [ROLE_NAME] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CNTR_PUSH_NOTIFICATIONS](
    [PUSH_NOTIFICATION_ID] BIGINT NOT NULL,
    [TENANT_ID] BIGINT NOT NULL,
    [APPLICATION_ID] BIGINT NOT NULL,
    [NOTIFICATION_NAME] [VARCHAR](255) NOT NULL,
    [API_KEY] [VARBINARY](4096),    
    CONSTRAINT [PK_CNTR_PUSH_NOTIFICATIONS] PRIMARY KEY CLUSTERED 
    (
	[PUSH_NOTIFICATION_ID] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CNTR_PUSH_NOTIFICATION_TAGS](
	[TAG_ID] BIGINT NOT NULL,
	[APPLICATION_ID] [VARCHAR](255) NOT NULL,
 CONSTRAINT [PK_CNTR_PUSH_NOTIFICATION_TAGS] PRIMARY KEY CLUSTERED 
(
	[TAG_ID] ASC,
	[APPLICATION_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[SCHD_REQUESTS](
        [REQUEST_ID] BIGINT NOT NULL,
        [TENANT_ID] BIGINT NOT NULL,
	[REQUEST_NAME] [VARCHAR](255) NOT NULL,
	[REQUEST_TYPE] [VARCHAR](30) NOT NULL,
	[DEFINITION_NAME] [VARCHAR](255) NOT NULL,
	[REQUEST] [VARCHAR](MAX) NOT NULL,
        [SEND_OUTPUT] [BIT] NOT NULL,
        [OUTPUT_EMAIL] [VARCHAR](MAX),
        [OUTPUT_REPORT] [VARCHAR](MAX),
 CONSTRAINT [PK_SCHD_REQUESTS] PRIMARY KEY CLUSTERED 
(
	[REQUEST_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[SCHD_ENTITIES](
        [ENTITY_ID] BIGINT NOT NULL,
        [TENANT_ID] BIGINT NOT NULL,
	[ENTITY_NAME] [VARCHAR](255) NOT NULL,
	[ENTITY_SEQUENCE_TYPE] [VARCHAR](30) NOT NULL,
	[DURATION_MINIMUM] [NUMERIC](10,2) NOT NULL,
	[DURATION_TARGET] [NUMERIC](10,2) NOT NULL,
	[DURATION_MAXIMUM] [NUMERIC](10,2) NOT NULL,
        [WARN_ON_DURATION] [BIT] NOT NULL,
	[NOTIFICATION_EMAIL] [VARCHAR](MAX),
	[ENTITY_STATUS] [VARCHAR](30) NOT NULL,
	[TRIGGER_ON_MISFIRE] [BIT] NOT NULL,
	[FIRE_MULTIPLE] [BIT] NOT NULL,
	[NOTIFY_ON_SUCCESS] [BIT] NOT NULL,
	[TRIGGER_DESCRIPTION] [VARCHAR](255) NOT NULL,
	[TRIGGER_TYPE] [VARCHAR](30) NOT NULL,
	[TRIGGER_DEFINITION] [VARCHAR](MAX) NOT NULL,
        [CALENDAR_NAME] [VARCHAR](255),
	[STREAM_NAME] [VARCHAR](255) NOT NULL,
        [ENTITY_ENVIRONMENT] [VARCHAR](30) NOT NULL,
        [USERNAME] [VARCHAR](30),
        [PASSWORD] [VARCHAR](255),
 CONSTRAINT [PK_SCHD_ENTITIES] PRIMARY KEY CLUSTERED 
(
	[ENTITY_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[SCHD_ENTITY_REQUESTS](
	[ENTITY_REQUEST_ID] BIGINT NOT NULL,
	[ENTITY_ID] BIGINT NOT NULL,
        [REQUEST_ID] BIGINT NOT NULL,
	[SEQUENCE_NO] [INT],
 CONSTRAINT [PK_SCHD_ENTITY_REQUESTS] PRIMARY KEY CLUSTERED 
(
	[ENTITY_REQUEST_ID] ASC	
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[SCHD_ENTITY_DEPENDENCIES](
	[ENTITY_DEPENDENCY_ID] BIGINT NOT NULL,
	[ENTITY_ID] BIGINT NOT NULL,
        [DEPENDENCY_ID] BIGINT NOT NULL,
	[DEPENDENCY_TYPE] [VARCHAR](30),
 CONSTRAINT [PK_SCHD_ENTITY_DEPENDENCIES] PRIMARY KEY CLUSTERED 
(
	[ENTITY_DEPENDENCY_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[SCHD_VARIABLES](
        [VARIABLE_ID] BIGINT NOT NULL,
        [TENANT_ID] BIGINT NOT NULL,
	[VARIABLE_NAME] [VARCHAR](255) NOT NULL,
	[VARIABLE_VALUE] [VARCHAR](MAX) NOT NULL,
 CONSTRAINT [PK_SCHD_VARIABLES] PRIMARY KEY CLUSTERED 
(
	[VARIABLE_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[SCHD_CALENDARS](
    [CALENDAR_ID] BIGINT NOT NULL,
    [TENANT_ID] BIGINT NOT NULL,
    [CALENDAR_NAME] [VARCHAR](255) NOT NULL,
    [TIMEZONE_ID] [VARCHAR](255) NOT NULL,
    [CALENDAR_DESCRIPTION] [VARCHAR](255),
    [CALENDAR_STATUS] [VARCHAR](30) NOT NULL,
    CONSTRAINT [PK_SCHD_CALENDARS] PRIMARY KEY CLUSTERED
    (
        [CALENDAR_ID] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[SCHD_CALENDAR_SLOTS](    
    [SLOT_ID] [BIGINT] NOT NULL,
    [CALENDAR_ID] BIGINT NOT NULL,    
    [DATE_FROM] [DATETIME],
    [DATE_THRU] [DATETIME],
    [SLOT_ACTIVE] [BIT] NOT NULL,
    CONSTRAINT [PK_SCHD_CALENDAR_SLOTS] PRIMARY KEY CLUSTERED
    (
        [SLOT_ID] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[SCHD_CALENDAR_TAGS](
    [CALENDAR_ID] BIGINT NOT NULL, 
    [TAG_ID] BIGINT NOT NULL,
    CONSTRAINT [PK_SCHD_CALENDAR_TAGS] PRIMARY KEY CLUSTERED
    (
        [CALENDAR_ID] ASC,
        [TAG_ID] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[SCHD_REQUEST_LEDGER](
	[RECORD_ID] [BIGINT] NOT NULL,
	[REQUEST_NAME] [VARCHAR](255) NOT NULL,
        [ENTITY_NAME] [VARCHAR](255) NOT NULL,
	[ENTITY_ID] [BIGINT] NOT NULL,
        [TENANT_ID] [BIGINT] NOT NULL,
        [ENVIRONMENT_NAME] [VARCHAR](255) NOT NULL,
        [JDE_ENVIRONMENT] [VARCHAR](255) NOT NULL,
        [JDE_USERNAME] [VARCHAR](255) NOT NULL,
        [JOB_ID] [BIGINT] NOT NULL,
        [JDE_REPORT] [VARCHAR](255),
        [JDE_VERSION] [VARCHAR](255),
        [JDE_FILE_NAME] [VARCHAR](255),
	[DATE_START] [BIGINT],
	[DATE_END] [BIGINT],
	[REQUEST_SUCCESSFUL] [BIT] NOT NULL,
	[MESSAGE] [VARCHAR](MAX),
        [REQUEST_TYPE] [VARCHAR](255) NOT NULL,
        [EXTENSION_RESPONSE] [VARCHAR](MAX),
 CONSTRAINT [PK_SCHD_REQUEST_LEDGER] PRIMARY KEY CLUSTERED 
(
	[RECORD_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[SCHD_ENTITY_LEDGER](
	[RECORD_ID] [BIGINT] NOT NULL,
        [TENANT_ID] [BIGINT] NOT NULL,
        [ENTITY_NAME] [VARCHAR](255) NOT NULL,
	[STREAM_NAME] [VARCHAR](255) NULL,
        [ENTITY_SCHEDULER_ID] [VARCHAR](255) NOT NULL,
        [FIRE_INSTANCE_ID] [VARCHAR](255) NOT NULL,
	[DATE_START] [BIGINT],
	[DATE_END] [BIGINT],
	[ENTITY_STATE] [VARCHAR](30) NOT NULL,
	[MESSAGE] [VARCHAR](MAX),
 CONSTRAINT [PK_SCHD_ENTITY_LEDGER] PRIMARY KEY CLUSTERED 
(
	[RECORD_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[SCHD_NOTIFICATIONS](
	[RECORD_ID] [BIGINT] NOT NULL,
	[DATE_CREATED] [DATETIME],
	[ENTITY_ID] [BIGINT],
	[REQUEST_ID] [BIGINT],
	[MESSAGE] [VARCHAR](MAX),
	[ACKNOWLEDGED] [BIT] NOT NULL,
 CONSTRAINT [PK_SCHD_NOTIFICATIONS] PRIMARY KEY CLUSTERED 
(
	[RECORD_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[SCHD_CHANGE_LEDGER](
	[RECORD_ID] [BIGINT] NOT NULL,
	[DATE_UPDATED] [DATETIME],
	[USERNAME] [VARCHAR](255),
	[CHANGE_TYPE] [VARCHAR](12),
	[ELEMENT_NAME] [VARCHAR](255),
	[ELEMENT_TYPE] [VARCHAR](50),
 CONSTRAINT [PK_SCHD_CHANGE_LEDGER] PRIMARY KEY CLUSTERED 
(
	[RECORD_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[SCHD_REQUEST_TAGS](
	[REQUEST_ID] [BIGINT] NOT NULL,
	[TAG_ID] [BIGINT] NOT NULL,
 CONSTRAINT [PK_SCHD_REQUEST_TAGS] PRIMARY KEY CLUSTERED 
(
	[REQUEST_ID] ASC,
	[TAG_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[SCHD_ENTITY_TAGS](
	[ENTITY_ID] [BIGINT] NOT NULL,
	[TAG_ID] [BIGINT] NOT NULL,
 CONSTRAINT [PK_SCHD_ENTITY_TAGS] PRIMARY KEY CLUSTERED 
(
	[ENTITY_ID] ASC,
	[TAG_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CNTR_UNIQUE_ID](
	[CANTARA_TABLE] [VARCHAR](255) NOT NULL,
	[RECORD_ID] [BIGINT] NOT NULL,
 CONSTRAINT [PK_CNTR_UNIQUE_ID] PRIMARY KEY CLUSTERED 
(
	[CANTARA_TABLE] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IDX_QRTZ_J_REQ_RECOVERY] ON [dbo].[QRTZ_JOB_DETAILS]
(
        [SCHED_NAME] ASC,
	[REQUESTS_RECOVERY] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
GO

CREATE NONCLUSTERED INDEX [IDX_QRTZ_J_GRP] ON [dbo].[QRTZ_JOB_DETAILS]
(
        [SCHED_NAME] ASC,
	[JOB_GROUP] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
GO

CREATE NONCLUSTERED INDEX [IDX_QRTZ_T_J] ON [dbo].[QRTZ_TRIGGERS]
(
        [SCHED_NAME] ASC,
        [JOB_NAME] ASC,
	[JOB_GROUP] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
GO

CREATE NONCLUSTERED INDEX [IDX_QRTZ_T_JG] ON [dbo].[QRTZ_TRIGGERS]
(
        [SCHED_NAME] ASC,
	[JOB_GROUP] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
GO

CREATE NONCLUSTERED INDEX [IDX_QRTZ_T_C] ON [dbo].[QRTZ_TRIGGERS]
(
        [SCHED_NAME] ASC,
	[CALENDAR_NAME] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
GO

CREATE NONCLUSTERED INDEX [IDX_QRTZ_T_G] ON [dbo].[QRTZ_TRIGGERS]
(
        [SCHED_NAME] ASC,
	[TRIGGER_GROUP] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
GO

CREATE NONCLUSTERED INDEX [IDX_QRTZ_T_STATE] ON [dbo].[QRTZ_TRIGGERS]
(
        [SCHED_NAME] ASC,
	[TRIGGER_STATE] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
GO

CREATE NONCLUSTERED INDEX [IDX_QRTZ_T_N_STATE] ON [dbo].[QRTZ_TRIGGERS]
(
        [SCHED_NAME] ASC,
        [TRIGGER_NAME] ASC,
        [TRIGGER_GROUP] ASC,
	[TRIGGER_STATE] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
GO

CREATE NONCLUSTERED INDEX [IDX_QRTZ_T_N_G_STATE] ON [dbo].[QRTZ_TRIGGERS]
(
        [SCHED_NAME] ASC,
        [TRIGGER_GROUP] ASC,
	[TRIGGER_STATE] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
GO

CREATE NONCLUSTERED INDEX [IDX_QRTZ_T_NEXT_FIRE_TIME] ON [dbo].[QRTZ_TRIGGERS]
(
        [SCHED_NAME] ASC,
	[NEXT_FIRE_TIME] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
GO

CREATE NONCLUSTERED INDEX [IDX_QRTZ_T_NFT_ST] ON [dbo].[QRTZ_TRIGGERS]
(
        [SCHED_NAME] ASC,
	[TRIGGER_STATE] ASC,
        [NEXT_FIRE_TIME] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
GO

CREATE NONCLUSTERED INDEX [IDX_QRTZ_T_NFT_MISFIRE] ON [dbo].[QRTZ_TRIGGERS]
(
        [SCHED_NAME] ASC,
	[MISFIRE_INSTR] ASC,
        [NEXT_FIRE_TIME] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
GO

CREATE NONCLUSTERED INDEX [IDX_QRTZ_T_NFT_ST_MISFIRE] ON [dbo].[QRTZ_TRIGGERS]
(
        [SCHED_NAME] ASC,
	[MISFIRE_INSTR] ASC,
        [NEXT_FIRE_TIME] ASC,        
        [TRIGGER_STATE] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
GO

CREATE NONCLUSTERED INDEX [IDX_QRTZ_T_NFT_ST_MISFIRE_GRP] ON [dbo].[QRTZ_TRIGGERS]
(
        [SCHED_NAME] ASC,
	[MISFIRE_INSTR] ASC,
        [NEXT_FIRE_TIME] ASC,
        [TRIGGER_GROUP] ASC,
        [TRIGGER_STATE] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
GO


CREATE UNIQUE NONCLUSTERED INDEX [IX_CNTR_TAG_LABEL] ON [dbo].[CNTR_TAGS]
(
        [TENANT_ID] ASC,
        [TAG_TYPE] ASC,
	[TAG_LABEL] 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 = ON)
GO


CREATE UNIQUE NONCLUSTERED INDEX [IDX_CNTR_PUSH_NOTIFICATION_TNT] ON [dbo].[CNTR_PUSH_NOTIFICATIONS]
(
        [TENANT_ID] ASC,
        [PUSH_NOTIFICATION_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 = ON)
GO

CREATE UNIQUE NONCLUSTERED INDEX [IDX_CNTR_ROUTE_TNT] ON [dbo].[CNTR_ROUTES]
(
        [TENANT_ID] ASC,
        [ROUTE_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 = ON)
GO

CREATE UNIQUE NONCLUSTERED INDEX [IDX_CNTR_EXTENSION_TNT] ON [dbo].[CNTR_EXTENSIONS]
(
        [TENANT_ID] ASC,
        [EXTENSION_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 = ON)
GO

CREATE UNIQUE NONCLUSTERED INDEX [IDX_CNTR_REPORT_TNT] ON [dbo].[CNTR_REPORTS]
(
        [TENANT_ID] ASC,
        [REPORT_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 = ON)
GO

CREATE UNIQUE NONCLUSTERED INDEX [IDX_CNTR_QUERY_TNT] ON [dbo].[CNTR_QUERIES]
(
        [TENANT_ID] ASC,
        [QUERY_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 = ON)
GO

CREATE UNIQUE NONCLUSTERED INDEX [IDX_CNTR_FUNCTION_TNT] ON [dbo].[CNTR_FUNCTIONS]
(
        [TENANT_ID] ASC,
        [FUNCTION_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 = ON)
GO

CREATE UNIQUE NONCLUSTERED INDEX [IDX_CNTR_APPLICATION_TNT] ON [dbo].[CNTR_APPLICATIONS]
(
        [TENANT_ID] ASC,
        [APPLICATION_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 = ON)
GO

CREATE UNIQUE NONCLUSTERED INDEX [IDX_CNTR_ENVIRONMENTS_TNT] ON [dbo].[CNTR_ENVIRONMENTS]
(
        [TENANT_ID] ASC,
        [ENVIRONMENT_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 = ON)
GO

CREATE UNIQUE NONCLUSTERED INDEX [IDX_CNTR_AGENT_TNT] ON [dbo].[CNTR_AGENTS]
(
        [TENANT_ID] ASC,
        [AGENT_KEY] 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 = ON)
GO

CREATE UNIQUE NONCLUSTERED INDEX [IDX_CNTR_FARM_NAME] ON [dbo].[CNTR_FARMS]
(
        [FARM_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 = ON)
GO

CREATE UNIQUE NONCLUSTERED INDEX [IDX_CNTR_SERVER_CACHES_TNT] ON [dbo].[CNTR_SERVER_CACHES]
(
        [TENANT_ID] ASC,
        [SERVER_CACHE_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 = ON)
GO

CREATE UNIQUE NONCLUSTERED INDEX [IDX_CNTR_SERVER_CACHES_ERRORS_SERVER_ID] ON [dbo].[CNTR_CACHE_ERRORS]
(
        [SERVER_CACHE_ID] ASC,
        [CACHE_ERROR_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 = ON)
GO

CREATE UNIQUE NONCLUSTERED INDEX [IDX_CNTR_PROXY_USER_TNT] ON [dbo].[CNTR_PROXY_USERS]
(
        [TENANT_ID] ASC,
        [PROXY_USER_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 = ON)
GO

CREATE UNIQUE NONCLUSTERED INDEX [IDX_SCHD_CALENDAR_TNT] ON [dbo].[SCHD_CALENDARS]
(
    [TENANT_ID] ASC,
    [CALENDAR_NAME] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
GO

CREATE UNIQUE NONCLUSTERED INDEX [IDX_SCHD_VARIABLE_TNT] ON [dbo].[SCHD_VARIABLES]
(
    [TENANT_ID] ASC,
    [VARIABLE_NAME] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
GO

CREATE UNIQUE NONCLUSTERED INDEX [IDX_SCHD_ENTITIES_TNT] ON [dbo].[SCHD_ENTITIES]
(
    [TENANT_ID] ASC,
    [ENTITY_NAME] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
GO

CREATE UNIQUE NONCLUSTERED INDEX [IDX_SCHD_REQUESTS_TNT] ON [dbo].[SCHD_REQUESTS]
(
    [TENANT_ID] ASC,
    [REQUEST_NAME] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
GO

CREATE NONCLUSTERED INDEX [IDX_SCHD_SLT_NME] ON [dbo].[SCHD_CALENDAR_SLOTS]
(
    [CALENDAR_ID] ASC,
    [DATE_FROM] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
GO

CREATE NONCLUSTERED INDEX [IX_SCHD_RQ_LDG] ON [dbo].[SCHD_REQUEST_LEDGER]
(
	[ENTITY_NAME] ASC,
	[REQUEST_NAME] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
GO

CREATE NONCLUSTERED INDEX [IX_SCHD_EN_LDG] ON [dbo].[SCHD_ENTITY_LEDGER]
(
        [TENANT_ID] ASC,
	[ENTITY_NAME] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
GO

CREATE NONCLUSTERED INDEX [IX_SCHD_EN_LDG_ID] ON [dbo].[SCHD_ENTITY_LEDGER]
(
	[FIRE_INSTANCE_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
GO

CREATE NONCLUSTERED INDEX [IX_SCHD_CH_LDG] ON [dbo].[SCHD_CHANGE_LEDGER]
(
	[ELEMENT_TYPE] ASC,
	[ELEMENT_NAME] ASC,
	[DATE_UPDATED] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
GO

CREATE NONCLUSTERED INDEX [IX_SCHD_EN_STR] ON [dbo].[SCHD_ENTITIES]
(
	[STREAM_NAME] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
GO