Page History

if object_id('PAT_DMS_OCR_SCAN') is Null
CREATE TABLE PAT_DMS_OCR_SCAN(
       OCR_EMAIL_ADDRESS nvarchar(200) NOT NULL,
       SAVE_CATEGORY_ID int NULL,
       PRIMARY KEY CLUSTERED (OCR_EMAIL_ADDRESS ASC))
GO
 
if object_id('PAT_DMS_SETTINGS') is Null
CREATE TABLE PAT_DMS_SETTINGS(
       DMS_SETTING_KEY nvarchar(200) NOT NULL,
       DMS_SETTING_VALUE nvarchar(500) NULL,
       PRIMARY KEY CLUSTERED (DMS_SETTING_KEY ASC))
GO
 
if object_id('PAT_DMS_TOKEN') is Null
CREATE TABLE PAT_DMS_TOKEN(
       USERNAME nvarchar(255) NOT NULL,
       TOKEN nvarchar(255) NOT NULL,
       CREATION_TIME datetime NULL,
       PRIMARY KEY CLUSTERED (TOKEN ASC))
GO


if object_id('EMAIL_DRAFTS') is Null
CREATE TABLE EMAIL_DRAFTS( 
	   ID int IDENTITY(1,1) NOT NULL,
	   FROM_ADDRESS nvarchar(255) NOT NULL,
	   TO_ADDRESSES nvarchar(1000) NOT NULL,
	   CC_ADDRESSES nvarchar(1000) NULL,
	   BCC_ADDRESSES nvarchar(1000) NULL,
	   EMAIL_SUBJECT nvarchar(255) NOT NULL,
	   EMAIL_BODY ntext NULL,
	   ATTACHMENT_IDS nvarchar(max) NULL,
	   CREATOR_NAME nvarchar(255) NULL,
	   CASE_REF nvarchar(255) NULL,
	   CREATION_TIME datetime2 NULL,
	   LAST_UPDATE_TIME datetime2 NULL,
	   SELECTED_EMAIL_DOC_ID nvarchar(255) NULL,
	   ATTACHMENT_NAMES nvarchar(max) NULL,
	   PRIMARY KEY CLUSTERED(ID))
GO