💾 Archived View for iich.space › src › db › migrations › 1632691671.ts captured on 2021-12-03 at 14:04:38.

View Raw

More Information

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

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

export const migration: Migration = {
  down: (db) => {
    db.exec(`
DROP TABLE bans;

ALTER TABLE posts DROP COLUMN origin;
`);
  },
  up: (db) => {
    db.exec(`
ALTER TABLE posts ADD origin VARCHAR(64);

CREATE TABLE bans (
  origin VARCHAR(64) PRIMARY KEY,
  createdAt DATETIME DEFAULT (DATETIME('now', 'localtime'))
);
`);
  },
  version: 1632691671,
};