sendou.ink/migrations/088-scrimpost-managed-by-anyone.js
Kalle 7901ee8cab
Scrim improvements (#2365)
* Initial

* wip

* wip

* Finish?

* remove comment
2025-06-07 17:21:29 +03:00

17 lines
518 B
JavaScript

export function up(db) {
db.transaction(() => {
db.prepare(
/* sql */ `alter table "ScrimPost" add column "managedByAnyone" integer default 0 not null`,
).run();
db.prepare(
/* sql */ `alter table "ScrimPost" add column "canceledAt" integer`,
).run();
db.prepare(
/* sql */ `alter table "ScrimPost" add column "canceledByUserId" integer references "User"("id") on delete restrict`,
).run();
db.prepare(
/* sql */ `alter table "ScrimPost" add column "cancelReason" text`,
).run();
})();
}