CREATE TABLE dbo.CM_ATTACH_FILE_LOG_V2 (
  ATTACH_ID varchar(15) NOT NULL,
  TYPE varchar(50) NULL,
  REF_ID varchar(15) NULL,
  FILE_NAME_OLD nvarchar(200) NULL,
  PATH_OLD nvarchar(1000) NULL,
  FILE_NAME_NEW nvarchar(200) NULL,
  PATH_NEW nvarchar(1000) NULL,
  FILE_SIZE decimal NULL,
  FILE_TYPE varchar(50) NULL,
  ATTACH_DT date NULL,
  EMP_ID varchar(15) NULL,
  [INDEX] varchar(50) NULL,
  NOTES nvarchar(1000) NULL,
  STATUS varchar(1) NULL,
  REF_MASTER varchar(15) NULL,
  CONSTRAINT PK_CM_ATTACH_FILE_LOG PRIMARY KEY CLUSTERED (ATTACH_ID)
)
GO

INSERT INTO CM_ATTACH_FILE_LOG_V2 (ATTACH_ID, TYPE, REF_ID, FILE_NAME_OLD, PATH_OLD, FILE_NAME_NEW, PATH_NEW, FILE_SIZE, FILE_TYPE, ATTACH_DT, EMP_ID, [INDEX], NOTES, STATUS, REF_MASTER)
SELECT * FROM CM_ATTACH_FILE_LOG
GO

DROP TABLE CM_ATTACH_FILE_LOG
GO

CREATE TABLE dbo.CM_ATTACH_FILE_LOG (
  Id int IDENTITY,
  PATH nvarchar(max) NULL,
  ACTION nvarchar(100) NULL,
  FILE_SIZE decimal NULL,
  FILE_TYPE varchar(50) NULL,
  ACTION_DT datetime NULL,
  USER_NAME varchar(15) NULL,
  NOTES nvarchar(1000) NULL,
  OLD_PATH nvarchar(max) NULL,
  CONSTRAINT PK__CM_ATTAC__3214EC07C34CF466 PRIMARY KEY CLUSTERED (Id)
)
GO