UNPKG

litejs/app/db/0001-migration-schema.sql

Version:

311 Bapplication/x-sqlView Raw

1
2CREATE TABLE db_schema (
3	id   INTEGER PRIMARY KEY,
4	ver  INTEGER,
5	up   TEXT,
6	down TEXT
7);
8
9CREATE TABLE db_schema_log (
10	id   INTEGER PRIMARY KEY,
11	time INTEGER default (CAST(((julianday('now') - 2440587.5)*86400000) as INTEGER)),
12	ver  INTEGER
13);
14
15-- Down
16
17DROP TABLE db_schema;
18DROP TABLE db_schema_log;
19

1
2	`CREATE TABLE db_schema (`
3	`id INTEGER PRIMARY KEY,`
4	`ver INTEGER,`
5	`up TEXT,`
6	`down TEXT`
7	`);`
8
9	`CREATE TABLE db_schema_log (`
10	`id INTEGER PRIMARY KEY,`
11	`time INTEGER default (CAST(((julianday('now') - 2440587.5)*86400000) as INTEGER)),`
12	`ver INTEGER`
13	`);`
14
15	`-- Down`
16
17	`DROP TABLE db_schema;`
18	`DROP TABLE db_schema_log;`
19