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

export const migration: Migration = {
  down: (db) => {
    db.exec(`
ALTER TABLE boards DROP COLUMN type;
ALTER TABLE posts DROP COLUMN image;
`);
  },
  up: (db) => {
    db.exec(`
ALTER TABLE boards ADD type INTEGER DEFAULT 0;
ALTER TABLE posts ADD image VARCHAR(32);
`);
  },
  version: 1632450406,
};