MARKUS

GRANT VIEW ANY COLUMN ENCRYPTION KEY DEFINITION TO PUBLIC;

GO

GRANT VIEW ANY COLUMN MASTER KEY DEFINITION TO PUBLIC;

GO

GRANT CONNECT TO [doftech];

ALTER ROLE [db_owner] ADD MEMBER [doftech];

CREATE SCHEMA [SignalR]

    AUTHORIZATION [dbo];

CREATE USER [doftech] FOR LOGIN [doftech];

CREATE LOGIN [doftech]

    WITH PASSWORD = N'dee|mhxhFNps$Mhv^hkcheJxmsFT7_&#$!~<hcrqf2j^^&wd', SID = 0x07CACCF523928E4B8868D22F92F805D3, DEFAULT_DATABASE = [markus], DEFAULT_LANGUAGE = [한국어];

CREATE CONTRACT [dbo_CONVERTER_DOC_944aae62-592d-4ec5-8bf1-f77ab027309c]

    AUTHORIZATION [dbo]

    ([dbo_CONVERTER_DOC_944aae62-592d-4ec5-8bf1-f77ab027309c/StartMessage/Insert] SENT BY INITIATOR, [dbo_CONVERTER_DOC_944aae62-592d-4ec5-8bf1-f77ab027309c/StartMessage/Update] SENT BY INITIATOR, [dbo_CONVERTER_DOC_944aae62-592d-4ec5-8bf1-f77ab027309c/StartMessage/Delete] SENT BY INITIATOR, [dbo_CONVERTER_DOC_944aae62-592d-4ec5-8bf1-f77ab027309c/ID] SENT BY INITIATOR, [dbo_CONVERTER_DOC_944aae62-592d-4ec5-8bf1-f77ab027309c/PROJECT_NO] SENT BY INITIATOR, [dbo_CONVERTER_DOC_944aae62-592d-4ec5-8bf1-f77ab027309c/DOCUMENT_URL] SENT BY INITIATOR, [dbo_CONVERTER_DOC_944aae62-592d-4ec5-8bf1-f77ab027309c/DOCUMENT_ID] SENT BY INITIATOR, [dbo_CONVERTER_DOC_944aae62-592d-4ec5-8bf1-f77ab027309c/CREATE_DATETIME] SENT BY INITIATOR, [dbo_CONVERTER_DOC_944aae62-592d-4ec5-8bf1-f77ab027309c/STATUS] SENT BY INITIATOR, [dbo_CONVERTER_DOC_944aae62-592d-4ec5-8bf1-f77ab027309c/TOTAL_PAGE] SENT BY INITIATOR, [dbo_CONVERTER_DOC_944aae62-592d-4ec5-8bf1-f77ab027309c/CURRENT_PAGE] SENT BY INITIATOR, [dbo_CONVERTER_DOC_944aae62-592d-4ec5-8bf1-f77ab027309c/EXCEPTION] SENT BY INITIATOR, [dbo_CONVERTER_DOC_944aae62-592d-4ec5-8bf1-f77ab027309c/END_DATETIME] SENT BY INITIATOR, [dbo_CONVERTER_DOC_944aae62-592d-4ec5-8bf1-f77ab027309c/START_DATETIME] SENT BY INITIATOR, [dbo_CONVERTER_DOC_944aae62-592d-4ec5-8bf1-f77ab027309c/SERVICE_ID] SENT BY INITIATOR, [dbo_CONVERTER_DOC_944aae62-592d-4ec5-8bf1-f77ab027309c/RECONVERTER] SENT BY INITIATOR, [dbo_CONVERTER_DOC_944aae62-592d-4ec5-8bf1-f77ab027309c/EndMessage] SENT BY INITIATOR);

CREATE MESSAGE TYPE [dbo_CONVERTER_DOC_944aae62-592d-4ec5-8bf1-f77ab027309c/CREATE_DATETIME]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_CONVERTER_DOC_944aae62-592d-4ec5-8bf1-f77ab027309c/CURRENT_PAGE]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_CONVERTER_DOC_944aae62-592d-4ec5-8bf1-f77ab027309c/DOCUMENT_ID]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_CONVERTER_DOC_944aae62-592d-4ec5-8bf1-f77ab027309c/DOCUMENT_URL]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_CONVERTER_DOC_944aae62-592d-4ec5-8bf1-f77ab027309c/END_DATETIME]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_CONVERTER_DOC_944aae62-592d-4ec5-8bf1-f77ab027309c/EXCEPTION]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_CONVERTER_DOC_944aae62-592d-4ec5-8bf1-f77ab027309c/EndMessage]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_CONVERTER_DOC_944aae62-592d-4ec5-8bf1-f77ab027309c/ID]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_CONVERTER_DOC_944aae62-592d-4ec5-8bf1-f77ab027309c/PROJECT_NO]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_CONVERTER_DOC_944aae62-592d-4ec5-8bf1-f77ab027309c/RECONVERTER]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE QUEUE [dbo].[dbo_CONVERTER_DOC_944aae62-592d-4ec5-8bf1-f77ab027309c_Receiver]

    WITH POISON_MESSAGE_HANDLING(STATUS = OFF);

CREATE SERVICE [dbo_CONVERTER_DOC_944aae62-592d-4ec5-8bf1-f77ab027309c_Receiver]

    AUTHORIZATION [dbo]

    ON QUEUE [dbo].[dbo_CONVERTER_DOC_944aae62-592d-4ec5-8bf1-f77ab027309c_Receiver]

    ([dbo_CONVERTER_DOC_944aae62-592d-4ec5-8bf1-f77ab027309c]);

CREATE MESSAGE TYPE [dbo_CONVERTER_DOC_944aae62-592d-4ec5-8bf1-f77ab027309c/SERVICE_ID]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_CONVERTER_DOC_944aae62-592d-4ec5-8bf1-f77ab027309c/START_DATETIME]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_CONVERTER_DOC_944aae62-592d-4ec5-8bf1-f77ab027309c/STATUS]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE QUEUE [dbo].[dbo_CONVERTER_DOC_944aae62-592d-4ec5-8bf1-f77ab027309c_Sender]

    WITH POISON_MESSAGE_HANDLING(STATUS = OFF), ACTIVATION (STATUS = ON, PROCEDURE_NAME = [dbo].[dbo_CONVERTER_DOC_944aae62-592d-4ec5-8bf1-f77ab027309c_QueueActivationSender], MAX_QUEUE_READERS = 1, EXECUTE AS N'dbo');

CREATE SERVICE [dbo_CONVERTER_DOC_944aae62-592d-4ec5-8bf1-f77ab027309c_Sender]

    AUTHORIZATION [dbo]

    ON QUEUE [dbo].[dbo_CONVERTER_DOC_944aae62-592d-4ec5-8bf1-f77ab027309c_Sender];

CREATE MESSAGE TYPE [dbo_CONVERTER_DOC_944aae62-592d-4ec5-8bf1-f77ab027309c/StartMessage/Delete]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_CONVERTER_DOC_944aae62-592d-4ec5-8bf1-f77ab027309c/StartMessage/Insert]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_CONVERTER_DOC_944aae62-592d-4ec5-8bf1-f77ab027309c/StartMessage/Update]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_CONVERTER_DOC_944aae62-592d-4ec5-8bf1-f77ab027309c/TOTAL_PAGE]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE CONTRACT [dbo_CONVERTER_DOC_e5bc3c55-e96e-4df5-a35d-e4f77131e6b9]

    AUTHORIZATION [dbo]

    ([dbo_CONVERTER_DOC_e5bc3c55-e96e-4df5-a35d-e4f77131e6b9/StartMessage/Insert] SENT BY INITIATOR, [dbo_CONVERTER_DOC_e5bc3c55-e96e-4df5-a35d-e4f77131e6b9/StartMessage/Update] SENT BY INITIATOR, [dbo_CONVERTER_DOC_e5bc3c55-e96e-4df5-a35d-e4f77131e6b9/StartMessage/Delete] SENT BY INITIATOR, [dbo_CONVERTER_DOC_e5bc3c55-e96e-4df5-a35d-e4f77131e6b9/ID] SENT BY INITIATOR, [dbo_CONVERTER_DOC_e5bc3c55-e96e-4df5-a35d-e4f77131e6b9/PROJECT_NO] SENT BY INITIATOR, [dbo_CONVERTER_DOC_e5bc3c55-e96e-4df5-a35d-e4f77131e6b9/DOCUMENT_URL] SENT BY INITIATOR, [dbo_CONVERTER_DOC_e5bc3c55-e96e-4df5-a35d-e4f77131e6b9/DOCUMENT_ID] SENT BY INITIATOR, [dbo_CONVERTER_DOC_e5bc3c55-e96e-4df5-a35d-e4f77131e6b9/CREATE_DATETIME] SENT BY INITIATOR, [dbo_CONVERTER_DOC_e5bc3c55-e96e-4df5-a35d-e4f77131e6b9/STATUS] SENT BY INITIATOR, [dbo_CONVERTER_DOC_e5bc3c55-e96e-4df5-a35d-e4f77131e6b9/TOTAL_PAGE] SENT BY INITIATOR, [dbo_CONVERTER_DOC_e5bc3c55-e96e-4df5-a35d-e4f77131e6b9/CURRENT_PAGE] SENT BY INITIATOR, [dbo_CONVERTER_DOC_e5bc3c55-e96e-4df5-a35d-e4f77131e6b9/EXCEPTION] SENT BY INITIATOR, [dbo_CONVERTER_DOC_e5bc3c55-e96e-4df5-a35d-e4f77131e6b9/END_DATETIME] SENT BY INITIATOR, [dbo_CONVERTER_DOC_e5bc3c55-e96e-4df5-a35d-e4f77131e6b9/START_DATETIME] SENT BY INITIATOR, [dbo_CONVERTER_DOC_e5bc3c55-e96e-4df5-a35d-e4f77131e6b9/SERVICE_ID] SENT BY INITIATOR, [dbo_CONVERTER_DOC_e5bc3c55-e96e-4df5-a35d-e4f77131e6b9/RECONVERTER] SENT BY INITIATOR, [dbo_CONVERTER_DOC_e5bc3c55-e96e-4df5-a35d-e4f77131e6b9/EndMessage] SENT BY INITIATOR);

CREATE MESSAGE TYPE [dbo_CONVERTER_DOC_e5bc3c55-e96e-4df5-a35d-e4f77131e6b9/CREATE_DATETIME]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_CONVERTER_DOC_e5bc3c55-e96e-4df5-a35d-e4f77131e6b9/CURRENT_PAGE]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_CONVERTER_DOC_e5bc3c55-e96e-4df5-a35d-e4f77131e6b9/DOCUMENT_ID]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_CONVERTER_DOC_e5bc3c55-e96e-4df5-a35d-e4f77131e6b9/DOCUMENT_URL]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_CONVERTER_DOC_e5bc3c55-e96e-4df5-a35d-e4f77131e6b9/END_DATETIME]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_CONVERTER_DOC_e5bc3c55-e96e-4df5-a35d-e4f77131e6b9/EXCEPTION]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_CONVERTER_DOC_e5bc3c55-e96e-4df5-a35d-e4f77131e6b9/EndMessage]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_CONVERTER_DOC_e5bc3c55-e96e-4df5-a35d-e4f77131e6b9/ID]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_CONVERTER_DOC_e5bc3c55-e96e-4df5-a35d-e4f77131e6b9/PROJECT_NO]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_CONVERTER_DOC_e5bc3c55-e96e-4df5-a35d-e4f77131e6b9/RECONVERTER]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE QUEUE [dbo].[dbo_CONVERTER_DOC_e5bc3c55-e96e-4df5-a35d-e4f77131e6b9_Receiver]

    WITH POISON_MESSAGE_HANDLING(STATUS = OFF);

CREATE SERVICE [dbo_CONVERTER_DOC_e5bc3c55-e96e-4df5-a35d-e4f77131e6b9_Receiver]

    AUTHORIZATION [dbo]

    ON QUEUE [dbo].[dbo_CONVERTER_DOC_e5bc3c55-e96e-4df5-a35d-e4f77131e6b9_Receiver]

    ([dbo_CONVERTER_DOC_e5bc3c55-e96e-4df5-a35d-e4f77131e6b9]);

CREATE MESSAGE TYPE [dbo_CONVERTER_DOC_e5bc3c55-e96e-4df5-a35d-e4f77131e6b9/SERVICE_ID]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_CONVERTER_DOC_e5bc3c55-e96e-4df5-a35d-e4f77131e6b9/START_DATETIME]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_CONVERTER_DOC_e5bc3c55-e96e-4df5-a35d-e4f77131e6b9/STATUS]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE QUEUE [dbo].[dbo_CONVERTER_DOC_e5bc3c55-e96e-4df5-a35d-e4f77131e6b9_Sender]

    WITH POISON_MESSAGE_HANDLING(STATUS = OFF), ACTIVATION (STATUS = ON, PROCEDURE_NAME = [dbo].[dbo_CONVERTER_DOC_e5bc3c55-e96e-4df5-a35d-e4f77131e6b9_QueueActivationSender], MAX_QUEUE_READERS = 1, EXECUTE AS N'dbo');

CREATE SERVICE [dbo_CONVERTER_DOC_e5bc3c55-e96e-4df5-a35d-e4f77131e6b9_Sender]

    AUTHORIZATION [dbo]

    ON QUEUE [dbo].[dbo_CONVERTER_DOC_e5bc3c55-e96e-4df5-a35d-e4f77131e6b9_Sender];

CREATE MESSAGE TYPE [dbo_CONVERTER_DOC_e5bc3c55-e96e-4df5-a35d-e4f77131e6b9/StartMessage/Delete]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_CONVERTER_DOC_e5bc3c55-e96e-4df5-a35d-e4f77131e6b9/StartMessage/Insert]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_CONVERTER_DOC_e5bc3c55-e96e-4df5-a35d-e4f77131e6b9/StartMessage/Update]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_CONVERTER_DOC_e5bc3c55-e96e-4df5-a35d-e4f77131e6b9/TOTAL_PAGE]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE CONTRACT [dbo_FINAL_PDF_1e5156c4-b351-4a22-90a9-739f535798be]

    AUTHORIZATION [dbo]

    ([dbo_FINAL_PDF_1e5156c4-b351-4a22-90a9-739f535798be/StartDialog/Insert] SENT BY INITIATOR, [dbo_FINAL_PDF_1e5156c4-b351-4a22-90a9-739f535798be/StartDialog/Update] SENT BY INITIATOR, [dbo_FINAL_PDF_1e5156c4-b351-4a22-90a9-739f535798be/StartDialog/Delete] SENT BY INITIATOR, [dbo_FINAL_PDF_1e5156c4-b351-4a22-90a9-739f535798be/ID] SENT BY INITIATOR, [dbo_FINAL_PDF_1e5156c4-b351-4a22-90a9-739f535798be/PROJECT_NO] SENT BY INITIATOR, [dbo_FINAL_PDF_1e5156c4-b351-4a22-90a9-739f535798be/DOCINFO_ID] SENT BY INITIATOR, [dbo_FINAL_PDF_1e5156c4-b351-4a22-90a9-739f535798be/MARKUPINFO_ID] SENT BY INITIATOR, [dbo_FINAL_PDF_1e5156c4-b351-4a22-90a9-739f535798be/CREATE_USER_ID] SENT BY INITIATOR, [dbo_FINAL_PDF_1e5156c4-b351-4a22-90a9-739f535798be/CREATE_DATETIME] SENT BY INITIATOR, [dbo_FINAL_PDF_1e5156c4-b351-4a22-90a9-739f535798be/STATUS] SENT BY INITIATOR, [dbo_FINAL_PDF_1e5156c4-b351-4a22-90a9-739f535798be/TOTAL_PAGE] SENT BY INITIATOR, [dbo_FINAL_PDF_1e5156c4-b351-4a22-90a9-739f535798be/CURRENT_PAGE] SENT BY INITIATOR, [dbo_FINAL_PDF_1e5156c4-b351-4a22-90a9-739f535798be/EXCEPTION] SENT BY INITIATOR, [dbo_FINAL_PDF_1e5156c4-b351-4a22-90a9-739f535798be/END_DATETIME] SENT BY INITIATOR, [dbo_FINAL_PDF_1e5156c4-b351-4a22-90a9-739f535798be/START_DATETIME] SENT BY INITIATOR, [dbo_FINAL_PDF_1e5156c4-b351-4a22-90a9-739f535798be/DOCUMENT_ID] SENT BY INITIATOR);

CREATE MESSAGE TYPE [dbo_FINAL_PDF_1e5156c4-b351-4a22-90a9-739f535798be/CREATE_DATETIME]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_FINAL_PDF_1e5156c4-b351-4a22-90a9-739f535798be/CREATE_USER_ID]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_FINAL_PDF_1e5156c4-b351-4a22-90a9-739f535798be/CURRENT_PAGE]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_FINAL_PDF_1e5156c4-b351-4a22-90a9-739f535798be/DOCINFO_ID]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_FINAL_PDF_1e5156c4-b351-4a22-90a9-739f535798be/DOCUMENT_ID]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_FINAL_PDF_1e5156c4-b351-4a22-90a9-739f535798be/END_DATETIME]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_FINAL_PDF_1e5156c4-b351-4a22-90a9-739f535798be/EXCEPTION]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_FINAL_PDF_1e5156c4-b351-4a22-90a9-739f535798be/ID]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_FINAL_PDF_1e5156c4-b351-4a22-90a9-739f535798be/MARKUPINFO_ID]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_FINAL_PDF_1e5156c4-b351-4a22-90a9-739f535798be/PROJECT_NO]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE QUEUE [dbo].[dbo_FINAL_PDF_1e5156c4-b351-4a22-90a9-739f535798be_Receiver]

    WITH POISON_MESSAGE_HANDLING(STATUS = OFF);

CREATE SERVICE [dbo_FINAL_PDF_1e5156c4-b351-4a22-90a9-739f535798be_Receiver]

    AUTHORIZATION [dbo]

    ON QUEUE [dbo].[dbo_FINAL_PDF_1e5156c4-b351-4a22-90a9-739f535798be_Receiver]

    ([dbo_FINAL_PDF_1e5156c4-b351-4a22-90a9-739f535798be]);

CREATE MESSAGE TYPE [dbo_FINAL_PDF_1e5156c4-b351-4a22-90a9-739f535798be/START_DATETIME]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_FINAL_PDF_1e5156c4-b351-4a22-90a9-739f535798be/STATUS]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE QUEUE [dbo].[dbo_FINAL_PDF_1e5156c4-b351-4a22-90a9-739f535798be_Sender]

    WITH POISON_MESSAGE_HANDLING(STATUS = OFF), ACTIVATION (STATUS = ON, PROCEDURE_NAME = [dbo].[dbo_FINAL_PDF_1e5156c4-b351-4a22-90a9-739f535798be_QueueActivationSender], MAX_QUEUE_READERS = 1, EXECUTE AS N'dbo');

CREATE SERVICE [dbo_FINAL_PDF_1e5156c4-b351-4a22-90a9-739f535798be_Sender]

    AUTHORIZATION [dbo]

    ON QUEUE [dbo].[dbo_FINAL_PDF_1e5156c4-b351-4a22-90a9-739f535798be_Sender];

CREATE MESSAGE TYPE [dbo_FINAL_PDF_1e5156c4-b351-4a22-90a9-739f535798be/StartDialog/Delete]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_FINAL_PDF_1e5156c4-b351-4a22-90a9-739f535798be/StartDialog/Insert]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_FINAL_PDF_1e5156c4-b351-4a22-90a9-739f535798be/StartDialog/Update]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_FINAL_PDF_1e5156c4-b351-4a22-90a9-739f535798be/TOTAL_PAGE]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE CONTRACT [dbo_FINAL_PDF_5cad5287-96c3-4d18-8568-c6d961728970]

    AUTHORIZATION [dbo]

    ([dbo_FINAL_PDF_5cad5287-96c3-4d18-8568-c6d961728970/StartDialog/Insert] SENT BY INITIATOR, [dbo_FINAL_PDF_5cad5287-96c3-4d18-8568-c6d961728970/StartDialog/Update] SENT BY INITIATOR, [dbo_FINAL_PDF_5cad5287-96c3-4d18-8568-c6d961728970/StartDialog/Delete] SENT BY INITIATOR, [dbo_FINAL_PDF_5cad5287-96c3-4d18-8568-c6d961728970/ID] SENT BY INITIATOR, [dbo_FINAL_PDF_5cad5287-96c3-4d18-8568-c6d961728970/PROJECT_NO] SENT BY INITIATOR, [dbo_FINAL_PDF_5cad5287-96c3-4d18-8568-c6d961728970/DOCINFO_ID] SENT BY INITIATOR, [dbo_FINAL_PDF_5cad5287-96c3-4d18-8568-c6d961728970/MARKUPINFO_ID] SENT BY INITIATOR, [dbo_FINAL_PDF_5cad5287-96c3-4d18-8568-c6d961728970/CREATE_USER_ID] SENT BY INITIATOR, [dbo_FINAL_PDF_5cad5287-96c3-4d18-8568-c6d961728970/CREATE_DATETIME] SENT BY INITIATOR, [dbo_FINAL_PDF_5cad5287-96c3-4d18-8568-c6d961728970/STATUS] SENT BY INITIATOR, [dbo_FINAL_PDF_5cad5287-96c3-4d18-8568-c6d961728970/TOTAL_PAGE] SENT BY INITIATOR, [dbo_FINAL_PDF_5cad5287-96c3-4d18-8568-c6d961728970/CURRENT_PAGE] SENT BY INITIATOR, [dbo_FINAL_PDF_5cad5287-96c3-4d18-8568-c6d961728970/EXCEPTION] SENT BY INITIATOR, [dbo_FINAL_PDF_5cad5287-96c3-4d18-8568-c6d961728970/END_DATETIME] SENT BY INITIATOR, [dbo_FINAL_PDF_5cad5287-96c3-4d18-8568-c6d961728970/START_DATETIME] SENT BY INITIATOR, [dbo_FINAL_PDF_5cad5287-96c3-4d18-8568-c6d961728970/DOCUMENT_ID] SENT BY INITIATOR);

CREATE MESSAGE TYPE [dbo_FINAL_PDF_5cad5287-96c3-4d18-8568-c6d961728970/CREATE_DATETIME]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_FINAL_PDF_5cad5287-96c3-4d18-8568-c6d961728970/CREATE_USER_ID]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_FINAL_PDF_5cad5287-96c3-4d18-8568-c6d961728970/CURRENT_PAGE]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_FINAL_PDF_5cad5287-96c3-4d18-8568-c6d961728970/DOCINFO_ID]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_FINAL_PDF_5cad5287-96c3-4d18-8568-c6d961728970/DOCUMENT_ID]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_FINAL_PDF_5cad5287-96c3-4d18-8568-c6d961728970/END_DATETIME]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_FINAL_PDF_5cad5287-96c3-4d18-8568-c6d961728970/EXCEPTION]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_FINAL_PDF_5cad5287-96c3-4d18-8568-c6d961728970/ID]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_FINAL_PDF_5cad5287-96c3-4d18-8568-c6d961728970/MARKUPINFO_ID]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_FINAL_PDF_5cad5287-96c3-4d18-8568-c6d961728970/PROJECT_NO]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE QUEUE [dbo].[dbo_FINAL_PDF_5cad5287-96c3-4d18-8568-c6d961728970_Receiver]

    WITH POISON_MESSAGE_HANDLING(STATUS = OFF);

CREATE SERVICE [dbo_FINAL_PDF_5cad5287-96c3-4d18-8568-c6d961728970_Receiver]

    AUTHORIZATION [dbo]

    ON QUEUE [dbo].[dbo_FINAL_PDF_5cad5287-96c3-4d18-8568-c6d961728970_Receiver]

    ([dbo_FINAL_PDF_5cad5287-96c3-4d18-8568-c6d961728970]);

CREATE MESSAGE TYPE [dbo_FINAL_PDF_5cad5287-96c3-4d18-8568-c6d961728970/START_DATETIME]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_FINAL_PDF_5cad5287-96c3-4d18-8568-c6d961728970/STATUS]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE QUEUE [dbo].[dbo_FINAL_PDF_5cad5287-96c3-4d18-8568-c6d961728970_Sender]

    WITH POISON_MESSAGE_HANDLING(STATUS = OFF), ACTIVATION (STATUS = ON, PROCEDURE_NAME = [dbo].[dbo_FINAL_PDF_5cad5287-96c3-4d18-8568-c6d961728970_QueueActivationSender], MAX_QUEUE_READERS = 1, EXECUTE AS N'dbo');

CREATE SERVICE [dbo_FINAL_PDF_5cad5287-96c3-4d18-8568-c6d961728970_Sender]

    AUTHORIZATION [dbo]

    ON QUEUE [dbo].[dbo_FINAL_PDF_5cad5287-96c3-4d18-8568-c6d961728970_Sender];

CREATE MESSAGE TYPE [dbo_FINAL_PDF_5cad5287-96c3-4d18-8568-c6d961728970/StartDialog/Delete]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_FINAL_PDF_5cad5287-96c3-4d18-8568-c6d961728970/StartDialog/Insert]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_FINAL_PDF_5cad5287-96c3-4d18-8568-c6d961728970/StartDialog/Update]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_FINAL_PDF_5cad5287-96c3-4d18-8568-c6d961728970/TOTAL_PAGE]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE CONTRACT [dbo_FINAL_PDF_65c60513-a23d-4976-8ab7-e63b5d9c643d]

    AUTHORIZATION [dbo]

    ([dbo_FINAL_PDF_65c60513-a23d-4976-8ab7-e63b5d9c643d/StartMessage/Insert] SENT BY INITIATOR, [dbo_FINAL_PDF_65c60513-a23d-4976-8ab7-e63b5d9c643d/StartMessage/Update] SENT BY INITIATOR, [dbo_FINAL_PDF_65c60513-a23d-4976-8ab7-e63b5d9c643d/StartMessage/Delete] SENT BY INITIATOR, [dbo_FINAL_PDF_65c60513-a23d-4976-8ab7-e63b5d9c643d/ID] SENT BY INITIATOR, [dbo_FINAL_PDF_65c60513-a23d-4976-8ab7-e63b5d9c643d/PROJECT_NO] SENT BY INITIATOR, [dbo_FINAL_PDF_65c60513-a23d-4976-8ab7-e63b5d9c643d/DOCINFO_ID] SENT BY INITIATOR, [dbo_FINAL_PDF_65c60513-a23d-4976-8ab7-e63b5d9c643d/MARKUPINFO_ID] SENT BY INITIATOR, [dbo_FINAL_PDF_65c60513-a23d-4976-8ab7-e63b5d9c643d/CREATE_USER_ID] SENT BY INITIATOR, [dbo_FINAL_PDF_65c60513-a23d-4976-8ab7-e63b5d9c643d/CREATE_DATETIME] SENT BY INITIATOR, [dbo_FINAL_PDF_65c60513-a23d-4976-8ab7-e63b5d9c643d/STATUS] SENT BY INITIATOR, [dbo_FINAL_PDF_65c60513-a23d-4976-8ab7-e63b5d9c643d/TOTAL_PAGE] SENT BY INITIATOR, [dbo_FINAL_PDF_65c60513-a23d-4976-8ab7-e63b5d9c643d/CURRENT_PAGE] SENT BY INITIATOR, [dbo_FINAL_PDF_65c60513-a23d-4976-8ab7-e63b5d9c643d/EXCEPTION] SENT BY INITIATOR, [dbo_FINAL_PDF_65c60513-a23d-4976-8ab7-e63b5d9c643d/END_DATETIME] SENT BY INITIATOR, [dbo_FINAL_PDF_65c60513-a23d-4976-8ab7-e63b5d9c643d/START_DATETIME] SENT BY INITIATOR, [dbo_FINAL_PDF_65c60513-a23d-4976-8ab7-e63b5d9c643d/DOCUMENT_ID] SENT BY INITIATOR, [dbo_FINAL_PDF_65c60513-a23d-4976-8ab7-e63b5d9c643d/EndMessage] SENT BY INITIATOR);

CREATE MESSAGE TYPE [dbo_FINAL_PDF_65c60513-a23d-4976-8ab7-e63b5d9c643d/CREATE_DATETIME]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_FINAL_PDF_65c60513-a23d-4976-8ab7-e63b5d9c643d/CREATE_USER_ID]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_FINAL_PDF_65c60513-a23d-4976-8ab7-e63b5d9c643d/CURRENT_PAGE]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_FINAL_PDF_65c60513-a23d-4976-8ab7-e63b5d9c643d/DOCINFO_ID]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_FINAL_PDF_65c60513-a23d-4976-8ab7-e63b5d9c643d/DOCUMENT_ID]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_FINAL_PDF_65c60513-a23d-4976-8ab7-e63b5d9c643d/END_DATETIME]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_FINAL_PDF_65c60513-a23d-4976-8ab7-e63b5d9c643d/EXCEPTION]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_FINAL_PDF_65c60513-a23d-4976-8ab7-e63b5d9c643d/EndMessage]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_FINAL_PDF_65c60513-a23d-4976-8ab7-e63b5d9c643d/ID]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_FINAL_PDF_65c60513-a23d-4976-8ab7-e63b5d9c643d/MARKUPINFO_ID]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_FINAL_PDF_65c60513-a23d-4976-8ab7-e63b5d9c643d/PROJECT_NO]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE QUEUE [dbo].[dbo_FINAL_PDF_65c60513-a23d-4976-8ab7-e63b5d9c643d_Receiver]

    WITH POISON_MESSAGE_HANDLING(STATUS = OFF);

CREATE SERVICE [dbo_FINAL_PDF_65c60513-a23d-4976-8ab7-e63b5d9c643d_Receiver]

    AUTHORIZATION [dbo]

    ON QUEUE [dbo].[dbo_FINAL_PDF_65c60513-a23d-4976-8ab7-e63b5d9c643d_Receiver]

    ([dbo_FINAL_PDF_65c60513-a23d-4976-8ab7-e63b5d9c643d]);

CREATE MESSAGE TYPE [dbo_FINAL_PDF_65c60513-a23d-4976-8ab7-e63b5d9c643d/START_DATETIME]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_FINAL_PDF_65c60513-a23d-4976-8ab7-e63b5d9c643d/STATUS]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE QUEUE [dbo].[dbo_FINAL_PDF_65c60513-a23d-4976-8ab7-e63b5d9c643d_Sender]

    WITH POISON_MESSAGE_HANDLING(STATUS = OFF), ACTIVATION (STATUS = ON, PROCEDURE_NAME = [dbo].[dbo_FINAL_PDF_65c60513-a23d-4976-8ab7-e63b5d9c643d_QueueActivationSender], MAX_QUEUE_READERS = 1, EXECUTE AS N'dbo');

CREATE SERVICE [dbo_FINAL_PDF_65c60513-a23d-4976-8ab7-e63b5d9c643d_Sender]

    AUTHORIZATION [dbo]

    ON QUEUE [dbo].[dbo_FINAL_PDF_65c60513-a23d-4976-8ab7-e63b5d9c643d_Sender];

CREATE MESSAGE TYPE [dbo_FINAL_PDF_65c60513-a23d-4976-8ab7-e63b5d9c643d/StartMessage/Delete]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_FINAL_PDF_65c60513-a23d-4976-8ab7-e63b5d9c643d/StartMessage/Insert]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_FINAL_PDF_65c60513-a23d-4976-8ab7-e63b5d9c643d/StartMessage/Update]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE MESSAGE TYPE [dbo_FINAL_PDF_65c60513-a23d-4976-8ab7-e63b5d9c643d/TOTAL_PAGE]

    AUTHORIZATION [dbo]

    VALIDATION = NONE;

CREATE TABLE [SignalR].[Messages_0] (

    [PayloadId]  BIGINT          NOT NULL,

    [Payload]    VARBINARY (MAX) NOT NULL,

    [InsertedOn] DATETIME        NOT NULL,

    PRIMARY KEY CLUSTERED ([PayloadId] ASC)

);

CREATE TABLE [SignalR].[Messages_0_Id] (

    [PayloadId] BIGINT NOT NULL,

    PRIMARY KEY CLUSTERED ([PayloadId] ASC)

);

CREATE TABLE [SignalR].[Schema] (

    [SchemaVersion] INT NOT NULL,

    PRIMARY KEY CLUSTERED ([SchemaVersion] ASC)

);

<?xml version="1.0" encoding="utf-8"?>

<Project DefaultTargets="Build" xmlns="http://schemas.microsoft.com/developer/msbuild/2003" ToolsVersion="4.0">

  <Import Project="$(MSBuildExtensionsPath)\$(MSBuildToolsVersion)\Microsoft.Common.props" Condition="Exists('$(MSBuildExtensionsPath)\$(MSBuildToolsVersion)\Microsoft.Common.props')" />

  <PropertyGroup>

    <Configuration Condition=" '$(Configuration)' == '' ">Debug</Configuration>

    <Platform Condition=" '$(Platform)' == '' ">AnyCPU</Platform>

    <Name>StationControllerSQL</Name>

    <SchemaVersion>2.0</SchemaVersion>

    <ProjectVersion>4.1</ProjectVersion>

    <ProjectGuid>{58c58ddf-311d-4108-a12b-1090c39e718b}</ProjectGuid>

    <DSP>Microsoft.Data.Tools.Schema.Sql.Sql140DatabaseSchemaProvider</DSP>

    <OutputType>Database</OutputType>

    <RootPath>

    </RootPath>

    <RootNamespace>StationControllerSQL</RootNamespace>

    <AssemblyName>StationControllerSQL</AssemblyName>

    <ModelCollation>1042,CI</ModelCollation>

    <DefaultFileStructure>BySchemaAndSchemaType</DefaultFileStructure>

    <DeployToDatabase>True</DeployToDatabase>

    <TargetFrameworkVersion>v4.5</TargetFrameworkVersion>

    <TargetLanguage>CS</TargetLanguage>

    <AppDesignerFolder>Properties</AppDesignerFolder>

    <SqlServerVerification>False</SqlServerVerification>

    <IncludeCompositeObjects>True</IncludeCompositeObjects>

    <TargetDatabaseSet>True</TargetDatabaseSet>

    <DefaultCollation>Korean_Wansung_CI_AS</DefaultCollation>

  </PropertyGroup>

  <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Release|AnyCPU' ">

    <OutputPath>bin\Release\</OutputPath>

    <BuildScriptName>$(MSBuildProjectName).sql</BuildScriptName>

    <TreatWarningsAsErrors>False</TreatWarningsAsErrors>

    <DebugType>pdbonly</DebugType>

    <Optimize>true</Optimize>

    <DefineDebug>false</DefineDebug>

    <DefineTrace>true</DefineTrace>

    <ErrorReport>prompt</ErrorReport>

    <WarningLevel>4</WarningLevel>

  </PropertyGroup>

  <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Debug|AnyCPU' ">

    <OutputPath>bin\Debug\</OutputPath>

    <BuildScriptName>$(MSBuildProjectName).sql</BuildScriptName>

    <TreatWarningsAsErrors>false</TreatWarningsAsErrors>

    <DebugSymbols>true</DebugSymbols>

    <DebugType>full</DebugType>

    <Optimize>false</Optimize>

    <DefineDebug>true</DefineDebug>

    <DefineTrace>true</DefineTrace>

    <ErrorReport>prompt</ErrorReport>

    <WarningLevel>4</WarningLevel>

  </PropertyGroup>

  <PropertyGroup>

    <VisualStudioVersion Condition="'$(VisualStudioVersion)' == ''">11.0</VisualStudioVersion>

    <!-- Default to the v11.0 targets path if the targets file for the current VS version is not found -->

    <SSDTExists Condition="Exists('$(MSBuildExtensionsPath)\Microsoft\VisualStudio\v$(VisualStudioVersion)\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets')">True</SSDTExists>

    <VisualStudioVersion Condition="'$(SSDTExists)' == ''">11.0</VisualStudioVersion>

  </PropertyGroup>

  <Import Condition="'$(SQLDBExtensionsRefPath)' != ''" Project="$(SQLDBExtensionsRefPath)\Microsoft.Data.Tools.Schema.SqlTasks.targets" />

  <Import Condition="'$(SQLDBExtensionsRefPath)' == ''" Project="$(MSBuildExtensionsPath)\Microsoft\VisualStudio\v$(VisualStudioVersion)\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets" />

  <ItemGroup>

    <Folder Include="Properties" />

  </ItemGroup>

</Project>

-- =============================================

-- Author:		<Author,,Name>

-- Create date: <Create Date,,>

-- Description:	<Description,,>

-- =============================================

CREATE PROCEDURE [dbo].[SELECT_CONVERT_DELETE]  

(

    @P_ID NVARCHAR(50)          --ID 

 --   @P_PROJECT_NO NVARCHAR(10),   --PROJECT NO 

	--@P_DOCUMENT_URL NVARCHAR(500),--DOCUMENT ID

	--@P_DOCUMENT_ID NVARCHAR(50)  --DOCUMENT ID

	--@P_CREATE_DATETIME DATETIME,  --CREATE DATETIME

    --@P_STATUS INT null,           --STATUS

	--@P_TOTAL_PAGE int null,       --TOTAL_PAGE

	--@P_CURRENT_PAGE int null,     --CURRENT_PAGE

	--@P_EXCEPTION NVARCHAR(max) null, --EXCEPTION

    --@P_END_DATETIME DATETIME null,   --END DATETIME

	--@P_START_DATETIME DATETIME null, --START DATETIME

	--@P_SERVICE_ID NVARCHAR(50) null, --SERVICE ID

	--@P_RECONVERTER int null          --RECONVERTER

)

AS

BEGIN

SET FMTONLY OFF;

SET NOCOUNT ON 

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;

	Begin

	DELETE CONVERTER_DOC WHERE ID = @P_ID

	End

RETURN

SET FMTONLY ON;

SET NOCOUNT OFF

RETURN

END;

-- =============================================

-- Author:		<Author,,Name>

-- Create date: <Create Date,,>

-- Description:	<Description,,>

-- =============================================

CREATE PROCEDURE [dbo].[SELECT_CONVERT_INSERT]  

(

    @P_ID NVARCHAR(50),          --ID 

    @P_PROJECT_NO NVARCHAR(10),   --PROJECT NO 

	@P_DOCUMENT_URL NVARCHAR(500),--DOCUMENT ID

	@P_DOCUMENT_ID NVARCHAR(50)  --DOCUMENT ID

	--@P_CREATE_DATETIME DATETIME,  --CREATE DATETIME

    --@P_STATUS INT null,           --STATUS

	--@P_TOTAL_PAGE int null,       --TOTAL_PAGE

	--@P_CURRENT_PAGE int null,     --CURRENT_PAGE

	--@P_EXCEPTION NVARCHAR(max) null, --EXCEPTION

    --@P_END_DATETIME DATETIME null,   --END DATETIME

	--@P_START_DATETIME DATETIME null, --START DATETIME

	--@P_SERVICE_ID NVARCHAR(50) null, --SERVICE ID

	--@P_RECONVERTER int null          --RECONVERTER

)

AS

BEGIN

SET FMTONLY OFF;

SET NOCOUNT ON 

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;

	Begin

	INSERT INTO CONVERTER_DOC VALUES (@P_ID, @P_PROJECT_NO, @P_DOCUMENT_URL, @P_DOCUMENT_ID, GETDATE(), 0, 0, 0, null, null, null, null, 0, 0)

	End

RETURN

SET FMTONLY ON;

SET NOCOUNT OFF

RETURN

END;

CREATE PROCEDURE [dbo].[SELECT_CONVERT_ITEM]

(

    @P_ID NVARCHAR(50),

    @P_PROJECT_NO NVARCHAR(10),--PROJECT NO

	@P_DOCUMENT_ID NVARCHAR(10),--DOCUMENT ID

    @P_STATUS INT  = NULL,              --STATUS

	@P_TAKE_COUNT INT = NULL,          --Select Item Count

	@P_BEGIN_CREATE_DATETIME DATETIME = NULL,--CREATE DATETIME

	@P_FINISH_CREATE_DATETIME DATETIME = NULL,--CREATE DATETIME  

	@P_BEGIN_START_DATETIE DATETIME  = NULL, --START DATETIME

	@P_FINISH_START_DATETIME DATETIME = NULL, --START DATETIME

	@P_BEGIN_END_DATETIME DATETIME = NULL, -- END DATETIME

	@P_FINISH_END_DATETIME DATETIME = NULL, --END DATETIME

	@P_GROUP_NO NVARCHAR(10),   --GROUP NO

	@P_DOCUMENT_NAME NVARCHAR(500),--DOCUMENT NAME

	@P_DOCUMENT_NO NVARCHAR(50),--DOCUMENT NO

	@P_REVISION NVARCHAR(10),    --REVISON

	@P_SERVICE_ID NVARCHAR(50),

	@P_RECONVERTER int,

	@P_DOCUMENT_URL NVARCHAR(500)

	--@P_PROPERTIES_TYPE NVARCHAR(50),

	--@P_PROPERTIES_PROPERTY NVARCHAR(100)

	--@P_PROPERTIES_VALUE NVARCHAR(max)

)

/* test

USE [markus]

GO

DECLARE	@return_value int

EXEC	@return_value = [dbo].[SELECT_CONVERT_ITEM]

		@P_PROJECT_NO = N'000000',

		@P_STATUS = 1,

		@P_TAKE_COUNT = 12

SELECT	'Return Value' = @return_value

GO

*/

AS

BEGIN

SET FMTONLY OFF;

SET NOCOUNT ON 

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;

	DECLARE @sqlCommand NVARCHAR(MAX)

	DECLARE @WhereCommand NVARCHAR(MAX)

	create table #temp

	(

		ID nvarchar(50) not null,

		PROJECT_NO nvarchar(10) not null,

		DOCUMENT_URL nvarchar(500) not null,

		DOCUMENT_ID nvarchar(50) not null,

		CREATE_DATETIME datetime not null,

		STATUS int not null,

		TOTAL_PAGE int not null,

		CURRENT_PAGE int not null,

		EXCEPTION nvarchar(max) null,

		END_DATETIME datetime null,

		START_DATETIME datetime null,

		SERVICE_ID varchar(50) null,

		RECONVERTER int null,

		REVISION nvarchar(50) null,

		DOCUMENT_NO nvarchar(50) null,

		DOCUMENT_NAME nvarchar(500) null,

		GROUP_NO nvarchar(50) null,

		RESULT_FILE nvarchar(500) null,

		RESULT nvarchar(50) null,

		PROPERTIES_VALUE NVARCHAR(max),

		CONVERT_PATH  NVARCHAR(max),

		CONVERT_COUNT INT

	)

	SET @sqlCommand =''

	SET @WhereCommand = ''

	-- TAKE COUNT

	IF @P_TAKE_COUNT > 0

		BEGIN

			SET @sqlCommand = 'SELECT TOP(' + CAST(@P_TAKE_COUNT AS varchar(10)) + ')'

		END

	ELSE

		BEGIN

			SET @sqlCommand = 'SELECT '

		END

		/*

		SELECT  TOP (200) CONVERTER_DOC.*, DOCUMENT_ITEM.REVISION, DOCUMENT_ITEM.DOCUMENT_NO, DOCUMENT_ITEM.DOCUMENT_NAME, DOCUMENT_ITEM.GROUP_NO, 

               DOCUMENT_ITEM.RESULT_FILE, DOCUMENT_ITEM.RESULT

         FROM     CONVERTER_DOC LEFT OUTER JOIN

     DOCUMENT_ITEM ON CONVERTER_DOC.DOCUMENT_ID = DOCUMENT_ITEM.DOCUMENT_ID AND CONVERTER_DOC.PROJECT_NO = DOCUMENT_ITEM.PROJECT_NO

	 -- 필터 조건

	 [CONVERTER_DOC].[PROJECT_NO]

	 [CONVERTER_DOC].[DOCUMENT_ID]

	 [CONVERTER_DOC].[STATUS]

	 [CONVERTER_DOC].[CREATE_DATETIME]

	 [DOCUMENT_ITEM].[GROUP_NO]

	 [DOCUMENT_ITEM].[DOCUMENT_NAME]

	 [DOCUMENT_ITEM].[DOCUMENT_NO]

	 [DOCUMENT_ITEM].[REVISION]

 */

	-- 기본 쿼리

	SET @sqlCommand =  @sqlCommand +

	            '[CONVERTER_DOC].[ID] as ID

				,[CONVERTER_DOC].[PROJECT_NO] as PROJECT_NO

				,[CONVERTER_DOC].[DOCUMENT_URL] as DOCUMENT_URL

				,[CONVERTER_DOC].[DOCUMENT_ID] as DOCUMENT_ID

				,[CONVERTER_DOC].[CREATE_DATETIME] as CREATE_DATETIME

				,[CONVERTER_DOC].[STATUS] as STATUS

				,[CONVERTER_DOC].[TOTAL_PAGE] as TOTAL_PAGE

				,[CONVERTER_DOC].[CURRENT_PAGE] as CURRENT_PAGE

				,[CONVERTER_DOC].[EXCEPTION] as EXCEPTION

				,[CONVERTER_DOC].[END_DATETIME] as END_DATETIME

				,[CONVERTER_DOC].[START_DATETIME] as START_DATETIME

				,[CONVERTER_DOC].[SERVICE_ID] as SERVICE_ID

				,[CONVERTER_DOC].[RECONVERTER] as RECONVERTER

				,[DOCUMENT_ITEM].[REVISION] as REVISION

				,[DOCUMENT_ITEM].[DOCUMENT_NO] as DOCUMENT_NO

				,[DOCUMENT_ITEM].[DOCUMENT_NAME] as DOCUMENT_NAME

				,[DOCUMENT_ITEM].[GROUP_NO] as GROUP_NO

				,[DOCUMENT_ITEM].[RESULT_FILE] as RESULT_FILE

				,[DOCUMENT_ITEM].[RESULT] as RESULT

				,[PROPERTIES].[VALUE] as PROPERTIES_VALUE

				,([PROPERTIES].[VALUE] + ''\'' + [CONVERTER_DOC].[PROJECT_NO] + ''_Tile\'' + CAST([CONVERTER_DOC].[DOCUMENT_ID] / 100 AS nvarchar(50)) + ''\'' + [CONVERTER_DOC].[DOCUMENT_ID]) as CONVERT_PATH

				,[CONVERTER_DOC].[CONVERT_COUNT] as CONVERT_COUNT

				FROM [CONVERTER_DOC] 

				LEFT OUTER JOIN [DOCUMENT_ITEM] ON [CONVERTER_DOC].[DOCUMENT_ID] = [DOCUMENT_ITEM].[DOCUMENT_ID] AND [CONVERTER_DOC].[PROJECT_NO] = [DOCUMENT_ITEM].[PROJECT_NO]

				LEFT OUTER JOIN [PROPERTIES] ON [CONVERTER_DOC].[PROJECT_NO] = [PROPERTIES].[PROPERTY] AND [PROPERTIES].[TYPE]  =  ''FinalPDFStorageRemote''

				WHERE '

				--G:\TileSource\OL1_Tile\198\19833

PRINT @sqlCommand;

     -- PROJECT NO

		IF @P_ID IS not NULL

		BEGIN

		  SET @WhereCommand = @WhereCommand + '[CONVERTER_DOC].[ID] = ''' + @P_ID +''''

		END

		-- id

	IF @P_PROJECT_NO IS NOT NULL

		BEGIN

			IF @WhereCommand != ''

			BEGIN

			 SET @WhereCommand = @WhereCommand + ' AND '

			end

		SET @WhereCommand = @WhereCommand + '[CONVERTER_DOC].[PROJECT_NO] = ''' + @P_PROJECT_NO + ''''

		END

	-- document id

	IF @P_DOCUMENT_ID IS NOT NULL