mirror of
https://github.com/Sendouc/sendou.ink.git
synced 2026-03-21 18:04:39 -05:00
17 lines
455 B
JavaScript
17 lines
455 B
JavaScript
export function up(db) {
|
|
db.transaction(() => {
|
|
db.prepare(
|
|
/* sql */ `alter table "User" add "favoriteBadgeIds" text`,
|
|
).run();
|
|
db.prepare(/* sql */ `update "User"
|
|
set "favoriteBadgeIds" =
|
|
case
|
|
when "favoriteBadgeId" is not null then '[' || "favoriteBadgeId" || ']'
|
|
else null
|
|
end;`).run();
|
|
db.prepare(
|
|
/* sql */ `alter table "User" drop column "favoriteBadgeId"`,
|
|
).run();
|
|
})();
|
|
}
|