IF(EXISTS(SELECT * 
FROM sys.indexes 
WHERE name='IX01_PL_REQUEST_DOC' AND object_id = OBJECT_ID('PL_REQUEST_DOC')))
BEGIN
DROP INDEX IX01_PL_REQUEST_DOC ON PL_REQUEST_DOC
END
ELSE
BEGIN
CREATE NONCLUSTERED INDEX [IX01_PL_REQUEST_DOC] ON [dbo].[PL_REQUEST_DOC] ([REQ_ID])
END

IF(EXISTS(SELECT * 
FROM sys.indexes 
WHERE name='IX01_PL_REQUEST_DOC_DT' AND object_id = OBJECT_ID('PL_REQUEST_DOC_DT')))
BEGIN
DROP INDEX IX01_PL_REQUEST_DOC_DT ON PL_REQUEST_DOC_DT
END
ELSE
BEGIN
CREATE NONCLUSTERED INDEX [IX01_PL_REQUEST_DOC_DT] ON [dbo].[PL_REQUEST_DOC_DT] ([REQ_ID])
END

IF(EXISTS(SELECT * 
FROM sys.indexes 
WHERE name='IDX_PL_REQUEST_PROCESS_PROCESS_ID' AND object_id = OBJECT_ID('PL_REQUEST_PROCESS')))
BEGIN
DROP INDEX IDX_PL_REQUEST_PROCESS_PROCESS_ID ON PL_REQUEST_PROCESS
END
ELSE
BEGIN
CREATE NONCLUSTERED INDEX [IDX_PL_REQUEST_PROCESS_PROCESS_ID] ON [dbo].[PL_REQUEST_PROCESS] ([REQ_ID])
END

IF(EXISTS(SELECT * 
FROM sys.indexes 
WHERE name='IX01_PL_REQUEST_PROCESS' AND object_id = OBJECT_ID('PL_REQUEST_PROCESS')))
BEGIN
DROP INDEX IX01_PL_REQUEST_PROCESS ON PL_REQUEST_PROCESS
END
ELSE
BEGIN
CREATE NONCLUSTERED INDEX [IX01_PL_REQUEST_PROCESS] ON [dbo].[PL_REQUEST_PROCESS] ([REQ_ID])
END

IF(EXISTS(SELECT * 
FROM sys.indexes 
WHERE name='IX01_PL_REQUEST_PROCESS_CHILD' AND object_id = OBJECT_ID('PL_REQUEST_PROCESS_CHILD')))
BEGIN
DROP INDEX IX01_PL_REQUEST_PROCESS_CHILD ON PL_REQUEST_PROCESS_CHILD
END
ELSE
BEGIN
CREATE NONCLUSTERED INDEX [IX01_PL_REQUEST_PROCESS_CHILD] ON [dbo].[PL_REQUEST_PROCESS_CHILD] ([PROCESS_ID])
END

IF(EXISTS(SELECT * 
FROM sys.indexes 
WHERE name='IDX_PL_REQUEST_PROCESS_CHILD_REQ_ID' AND object_id = OBJECT_ID('PL_REQUEST_PROCESS_CHILD')))
BEGIN
DROP INDEX IDX_PL_REQUEST_PROCESS_CHILD_REQ_ID ON PL_REQUEST_PROCESS_CHILD
END
ELSE
BEGIN
CREATE NONCLUSTERED INDEX [IDX_PL_REQUEST_PROCESS_CHILD_REQ_ID] ON [dbo].[PL_REQUEST_PROCESS_CHILD] ([REQ_ID])
END

IF(EXISTS(SELECT * 
FROM sys.indexes 
WHERE name='IDX_TL_USER_TLNANME' AND object_id = OBJECT_ID('TL_USER')))
BEGIN
DROP INDEX IDX_TL_USER_TLNANME ON TL_USER
END
ELSE
BEGIN
CREATE NONCLUSTERED INDEX [IDX_TL_USER_TLNANME] ON [dbo].[TL_USER] ([TLNANME])
END