Merlin Comments - Answer Overflow



CREATE TABLE [FFA].[MARKET_COMMENT] (
    [ID] INT NOT NULL IDENTITY(1,1),
    [COMMENT] TEXT,
    [PUBLISHED] TINYINT NOT NULL CONSTRAINT [DF__MARKET_CO__PUBLI__4AB81AF0] DEFAULT 0,
    [TIMESTAMP] DATETIME NOT NULL CONSTRAINT [DF__MARKET_CO__TIMES__4BAC3F29] DEFAULT getutcdate(),
    [BY_USER] INT NOT NULL,
    [SYS_START_TIME] DATETIME2 NOT NULL CONSTRAINT [SYS_START_TIME_FFA_MARKET_COMMENT] DEFAULT sysutcdatetime(),
    [SYS_END_TIME] DATETIME2 NOT NULL CONSTRAINT [SYS_END_TIME_FFA_MARKET_COMMENT] DEFAULT CONVERT([datetime2](0),'9999-12-31 23:59:59',(0)),
    CONSTRAINT [PK_MARKET_COMMENT] PRIMARY KEY CLUSTERED ([ID])
);

-- CreateTable
CREATE TABLE [BUNKER].[MARKET_COMMENT] (
    [ID] INT NOT NULL IDENTITY(1,1),
    [COMMENT] VARCHAR(max),
    [PUBLISHED] TINYINT NOT NULL CONSTRAINT [DF__MARKET_CO__PUBLI__731B1205] DEFAULT 0,
    [SAVED_TIMESTAMP] DATETIME NOT NULL CONSTRAINT [DF__MARKET_CO__SAVED__7226EDCC] DEFAULT getutcdate(),
    [PUBLISHED_TIMESTAMP] DATETIME,
    [BY_USER] INT NOT NULL,
    [OLD_COMMENT] NVARCHAR(max),
    [SYS_START_TIME] DATETIME2 NOT NULL CONSTRAINT [SYS_START_TIME_BUNKER_MARKET_COMMENT] DEFAULT sysutcdatetime(),
    [SYS_END_TIME] DATETIME2 NOT NULL CONSTRAINT [SYS_END_TIME_BUNKER_MARKET_COMMENT] DEFAULT CONVERT([datetime2](0),'9999-12-31 23:59:59'),
    CONSTRAINT [PK__MARKET_C__3214EC27C0865E1A] PRIMARY KEY CLUSTERED ([ID])
);

14 replies

PPrisma

•Created by Merlin on 4/27/2025 in #help-and-questions

Drift detected after generation the schema and init migration script on mssql


model FfaMarketComment {
  id           Int      @id(map: "PK_MARKET_COMMENT") @default(autoincrement()) @map("ID")
  comment      String?  @map("COMMENT") @db.Text
  published    Int      @default(0, map: "DF__MARKET_CO__PUBLI__4AB81AF0") @map("PUBLISHED") @db.TinyInt
  timestamp    DateTime @default(dbgenerated("getutcdate()"), map: "DF__MARKET_CO__TIMES__4BAC3F29") @map("TIMESTAMP") @db.DateTime
  byUser       Int      @map("BY_USER")
  sysStartTime DateTime @default(dbgenerated("sysutcdatetime()"), map: "SYS_START_TIME_FFA_MARKET_COMMENT") @map("SYS_START_TIME")
  sysEndTime   DateTime @default(dbgenerated("CONVERT([datetime2](0),'9999-12-31 23:59:59',(0))"), map: "SYS_END_TIME_FFA_MARKET_COMMENT") @map("SYS_END_TIME")

  @@map("MARKET_COMMENT")
  @@schema("FFA")
}

model BunkerMarketComment {
  id                 Int       @id(map: "PK__MARKET_C__3214EC27C0865E1A") @default(autoincrement()) @map("ID")
  comment            String?   @map("COMMENT") @db.VarChar(Max)
  published          Int       @default(0, map: "DF__MARKET_CO__PUBLI__731B1205") @map("PUBLISHED") @db.TinyInt
  savedTimestamp     DateTime  @default(dbgenerated("getutcdate()"), map: "DF__MARKET_CO__SAVED__7226EDCC") @map("SAVED_TIMESTAMP") @db.DateTime
  publishedTimestamp DateTime? @map("PUBLISHED_TIMESTAMP") @db.DateTime
  byUser             Int       @map("BY_USER")
  oldComment         String?   @map("OLD_COMMENT") @db.NVarChar(Max)
  sysStartTime       DateTime  @default(dbgenerated("sysutcdatetime()"), map: "SYS_START_TIME_BUNKER_MARKET_COMMENT") @map("SYS_START_TIME")
  sysEndTime         DateTime  @default(dbgenerated("CONVERT([datetime2](0),'9999-12-31 23:59:59')"), map: "SYS_END_TIME_BUNKER_MARKET_COMMENT") @map("SYS_END_TIME")

  @@map("MARKET_COMMENT")
  @@schema("BUNKER")
}

14 replies

Gaming

Programming