💾 Archived View for iich.space › src › db › migrations › 1631591066.ts captured on 2022-01-08 at 14:18:08.

View Raw

More Information

⬅️ Previous capture (2021-12-03)

-=-=-=-=-=-=-

import { Migration } from '../migrate';

export const migration: Migration = {
  down: (db) => {
    db.exec(`
DROP INDEX id_boardId;
DROP INDEX id_threadId;
`);
  },
  up: (db) => {
    db.exec(`
CREATE UNIQUE INDEX id_boardId ON posts(id, boardId);
CREATE UNIQUE INDEX id_threadId ON posts(id, threadId);
`);
  },
  version: 1631591066,
};