💾 Archived View for iich.space › src › db › migrations › 1631855432.ts captured on 2021-12-04 at 18:04:22.

View Raw

More Information

⬅️ Previous capture (2021-12-03)

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

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

export const migration: Migration = {
  down: (db) => {
    db.exec(`
DROP TABLE identities;
`);
  },
  up: (db) => {
    db.exec(`
CREATE TABLE identities (
  fingerprint VARCHAR(255) PRIMARY KEY,
  name VARCHAR(16),
  createdAt DATETIME DEFAULT (DATETIME('now', 'localtime')),
  updatedAt DATETIME DEFAULT (DATETIME('now', 'localtime'))
);
`);
  },
  version: 1631855432,
};