-- Table structure 
CREATE TABLE [dbo].[C_REPOS_APPLIED_LOCK](
	[ROWID_LOCK] [nchar](14) NOT NULL,
	[CREATE_DATE] [datetime2](7) NOT NULL,
	[CREATOR] [nvarchar](50) NOT NULL,
	[LAST_UPDATE_DATE] [datetime2](7) NULL,
	[UPDATED_BY] [nvarchar](50) NULL,
	[ROWID_TABLE] [nchar](14) NOT NULL,
	[LOCK_GROUP_STR] [nvarchar](100) NOT NULL,
	[LOCK_EXCLUSIVE_IND] [bigint] NOT NULL,
	[JOB_TYPE_STR] [nchar](1) NOT NULL,
	[LOCK_QUERY_SQL] [nvarchar](2000) NULL,
	[MODULE_NAME] [nvarchar](100) NULL,
	[INTERACTION_ID] [nvarchar](100) NULL,
 CONSTRAINT [PK_APPLIED_LOCK] PRIMARY KEY NONCLUSTERED 
(
	[ROWID_LOCK] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 70) ON [CMX_DATA]
) ON [CMX_DATA]
GO

ALTER TABLE [dbo].[C_REPOS_APPLIED_LOCK] ADD  CONSTRAINT [DF_C_REPOS_APPLIED_LOCK_CREATE_DATE]  DEFAULT (getdate()) FOR [CREATE_DATE]
GO

ALTER TABLE [dbo].[C_REPOS_APPLIED_LOCK] ADD  CONSTRAINT [DF_C_REPOS_APPLIED_LOCK_LOCK_EXCLUSIVE_IND]  DEFAULT ((0)) FOR [LOCK_EXCLUSIVE_IND]
GO

ALTER TABLE [dbo].[C_REPOS_APPLIED_LOCK] ADD  CONSTRAINT [DF_C_REPOS_APPLIED_LOCK_JOB_TYPE_STR]  DEFAULT ('A') FOR [JOB_TYPE_STR]
GO

ALTER TABLE [dbo].[C_REPOS_APPLIED_LOCK]  WITH CHECK ADD  CONSTRAINT [FK_APPLIED_LOCK_EWGPS3] FOREIGN KEY([ROWID_TABLE])
REFERENCES [dbo].[C_REPOS_TABLE] ([ROWID_TABLE])
GO

ALTER TABLE [dbo].[C_REPOS_APPLIED_LOCK] CHECK CONSTRAINT [FK_APPLIED_LOCK_EWGPS3]
GO

-----------------------------------

--- indexes definitions on the table 

/****** Object:  Index [SVR1_13NC4ZI]    Script Date: 6/14/2023 11:13:52 PM ******/
CREATE CLUSTERED INDEX [SVR1_13NC4ZI] ON [dbo].[C_REPOS_APPLIED_LOCK]
(
	[ROWID_TABLE] ASC,
	[JOB_TYPE_STR] ASC,
	[ROWID_LOCK] 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, FILLFACTOR = 70) ON [CMX_DATA]
GO

-------------------------------------------
/****** Object:  Index [PK_APPLIED_LOCK]    Script Date: 6/14/2023 11:11:02 PM ******/
ALTER TABLE [dbo].[C_REPOS_APPLIED_LOCK] ADD  CONSTRAINT [PK_APPLIED_LOCK] PRIMARY KEY NONCLUSTERED 
(
	[ROWID_LOCK] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 70) ON [CMX_DATA]
GO


-------------------------

/****** Object:  Index [NI_APPLIED_LOCK_SBL3R8]    Script Date: 6/14/2023 11:11:26 PM ******/
CREATE NONCLUSTERED INDEX [NI_APPLIED_LOCK_SBL3R8] ON [dbo].[C_REPOS_APPLIED_LOCK]
(
	[LOCK_GROUP_STR] 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, FILLFACTOR = 70) ON [CMX_INDX]
GO

------------------------------

/****** Object:  Index [NI_APPLIED_LOCK_EWGPS3]    Script Date: 6/14/2023 11:12:59 PM ******/
CREATE NONCLUSTERED INDEX [NI_APPLIED_LOCK_EWGPS3] ON [dbo].[C_REPOS_APPLIED_LOCK]
(
	[ROWID_TABLE] 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, FILLFACTOR = 70) ON [CMX_INDX]
GO
------------------------------
/****** Object:  Index [C_REPOS_ROWID_JOBTYPE_IND]    Script Date: 6/14/2023 11:13:27 PM ******/
CREATE NONCLUSTERED INDEX [C_REPOS_ROWID_JOBTYPE_IND] ON [dbo].[C_REPOS_APPLIED_LOCK]
(
	[ROWID_TABLE] ASC,
	[JOB_TYPE_STR] 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) ON [CMX_DATA]
GO

ALTER INDEX [C_REPOS_ROWID_JOBTYPE_IND] ON [dbo].[C_REPOS_APPLIED_LOCK] DISABLE
GO

-------------------------------------------------------------------------------------