File size: 456 Bytes
88c4c60 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 | // Initial schema bootstrap. For fresh DB this creates all tables/indexes.
// For existing DB at version 0 (legacy unstamped), it's idempotent (IF NOT EXISTS).
import { TABLES, buildCreateTableSql } from "../schema.js";
export default {
version: 1,
name: "initial",
up(db) {
for (const [name, def] of Object.entries(TABLES)) {
db.exec(buildCreateTableSql(name, def));
for (const idx of def.indexes || []) db.exec(idx);
}
},
};
|