CONF_TABLE

DECLARE @ID BIGINT, @COUNT BIGINT

SELECT @ID = ID
FROM CONF_TABLE
WHERE NAME = 'Upload WR Tasks';

SELECT @COUNT = COUNT(*) FROM CONF_TABLE_COLUMN WHERE CONF_TABLE_ID = @ID
IF @COUNT = 0
BEGIN
  INSERT INTO dbo.CONF_TABLE_COLUMN(ID, CONF_TABLE_ID, NAME, DEFAULT_ORDER, DEFAULT_VISIBILITY_FLAG, MANDATORY_FLAG, A_CREATE_BY, A_CREATE_DATE, A_UPDATE_BY, A_UPDATE_DATE, A_PROGRAM, A_ACTION, A_SESSION, A_ESIG_BY, A_ESIG_DATE, A_REASON_FOR_CHANGE)
      VALUES(NEXT VALUE FOR CONF_TABLE_COLUMN_SEQ, @ID, N'accountCode', 1, N'Y', N'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
  INSERT INTO dbo.CONF_TABLE_COLUMN (ID, CONF_TABLE_ID, NAME, DEFAULT_ORDER, DEFAULT_VISIBILITY_FLAG, MANDATORY_FLAG, A_CREATE_BY, A_CREATE_DATE, A_UPDATE_BY, A_UPDATE_DATE, A_PROGRAM, A_ACTION, A_SESSION, A_ESIG_BY, A_ESIG_DATE, A_REASON_FOR_CHANGE)
    VALUES (NEXT VALUE FOR CONF_TABLE_COLUMN_SEQ, @ID, N'accountName', 2, N'Y', N'N', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
  INSERT INTO dbo.CONF_TABLE_COLUMN (ID, CONF_TABLE_ID, NAME, DEFAULT_ORDER, DEFAULT_VISIBILITY_FLAG, MANDATORY_FLAG, A_CREATE_BY, A_CREATE_DATE, A_UPDATE_BY, A_UPDATE_DATE, A_PROGRAM, A_ACTION, A_SESSION, A_ESIG_BY, A_ESIG_DATE, A_REASON_FOR_CHANGE)
    VALUES (NEXT VALUE FOR CONF_TABLE_COLUMN_SEQ, @ID, N'barcode', 3, N'Y', N'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
  INSERT INTO dbo.CONF_TABLE_COLUMN (ID, CONF_TABLE_ID, NAME, DEFAULT_ORDER, DEFAULT_VISIBILITY_FLAG, MANDATORY_FLAG, A_CREATE_BY, A_CREATE_DATE, A_UPDATE_BY, A_UPDATE_DATE, A_PROGRAM, A_ACTION, A_SESSION, A_ESIG_BY, A_ESIG_DATE, A_REASON_FOR_CHANGE)
    VALUES (NEXT VALUE FOR CONF_TABLE_COLUMN_SEQ, @ID, N'dateReceivedFormatted', 4, N'Y', N'N', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
  INSERT INTO dbo.CONF_TABLE_COLUMN (ID, CONF_TABLE_ID, NAME, DEFAULT_ORDER, DEFAULT_VISIBILITY_FLAG, MANDATORY_FLAG, A_CREATE_BY, A_CREATE_DATE, A_UPDATE_BY, A_UPDATE_DATE, A_PROGRAM, A_ACTION, A_SESSION, A_ESIG_BY, A_ESIG_DATE, A_REASON_FOR_CHANGE)
    VALUES (NEXT VALUE FOR CONF_TABLE_COLUMN_SEQ, @ID, N'receivedFrom', 5, N'Y', N'N', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
  INSERT INTO dbo.CONF_TABLE_COLUMN (ID, CONF_TABLE_ID, NAME, DEFAULT_ORDER, DEFAULT_VISIBILITY_FLAG, MANDATORY_FLAG, A_CREATE_BY, A_CREATE_DATE, A_UPDATE_BY, A_UPDATE_DATE, A_PROGRAM, A_ACTION, A_SESSION, A_ESIG_BY, A_ESIG_DATE, A_REASON_FOR_CHANGE)
    VALUES (NEXT VALUE FOR CONF_TABLE_COLUMN_SEQ, @ID, N'task', 6, N'Y', N'N', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
  INSERT INTO dbo.CONF_TABLE_COLUMN (ID, CONF_TABLE_ID, NAME, DEFAULT_ORDER, DEFAULT_VISIBILITY_FLAG, MANDATORY_FLAG, A_CREATE_BY, A_CREATE_DATE, A_UPDATE_BY, A_UPDATE_DATE, A_PROGRAM, A_ACTION, A_SESSION, A_ESIG_BY, A_ESIG_DATE, A_REASON_FOR_CHANGE)
    VALUES (NEXT VALUE FOR CONF_TABLE_COLUMN_SEQ, @ID, N'status', 7, N'Y', N'N', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
  INSERT INTO dbo.CONF_TABLE_COLUMN (ID, CONF_TABLE_ID, NAME, DEFAULT_ORDER, DEFAULT_VISIBILITY_FLAG, MANDATORY_FLAG, A_CREATE_BY, A_CREATE_DATE, A_UPDATE_BY, A_UPDATE_DATE, A_PROGRAM, A_ACTION, A_SESSION, A_ESIG_BY, A_ESIG_DATE, A_REASON_FOR_CHANGE)
    VALUES (NEXT VALUE FOR CONF_TABLE_COLUMN_SEQ, @ID, N'verifyNumber', 8, N'Y', N'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
  INSERT INTO dbo.CONF_TABLE_COLUMN (ID, CONF_TABLE_ID, NAME, DEFAULT_ORDER, DEFAULT_VISIBILITY_FLAG, MANDATORY_FLAG, A_CREATE_BY, A_CREATE_DATE, A_UPDATE_BY, A_UPDATE_DATE, A_PROGRAM, A_ACTION, A_SESSION, A_ESIG_BY, A_ESIG_DATE, A_REASON_FOR_CHANGE)
    VALUES (NEXT VALUE FOR CONF_TABLE_COLUMN_SEQ, @ID, N'verifyPercent', 9, N'Y', N'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
END ELSE
BEGIN
  UPDATE CONF_TABLE_COLUMN
    SET DEFAULT_ORDER=DEFAULT_ORDER +1
  WHERE CONF_TABLE_ID=@ID
    AND DEFAULT_ORDER > 1;

  INSERT INTO CONF_TABLE_COLUMN (ID, CONF_TABLE_ID, NAME, DEFAULT_ORDER, DEFAULT_VISIBILITY_FLAG, MANDATORY_FLAG)
    VALUES (NEXT VALUE FOR CONF_TABLE_COLUMN_SEQ, @ID, 'accountName', 2, 'Y', 'N');
END

INSERT INTO LOCALIZATION (ID, LOCALE, KEY_, VALUE)
  VALUES (NEXT VALUE FOR LOCALIZATION_SEQ, 'en_US', 'upload.data.upload.log.table.column.account.name', 'Account Name');