import type Database from 'better-sqlite3';

export const version = 2;

export function up(db: Database.Database): void {
  db.exec(`
    ALTER TABLE notes ADD COLUMN due_date TEXT;
    ALTER TABLE notes ADD COLUMN due_date_edited_by_user INTEGER NOT NULL DEFAULT 0
      CHECK (due_date_edited_by_user IN (0,1));
  `);
}
