Differential D7183 Diff 24372 web/database/queries/db-queries.js

Changeset View

Standalone View

Show All 21 Lines	CREATE TABLE IF NOT EXISTS drafts (
key TEXT UNIQUE PRIMARY KEY NOT NULL,		key TEXT UNIQUE PRIMARY KEY NOT NULL,
text TEXT NOT NULL		text TEXT NOT NULL
);		);

CREATE TABLE IF NOT EXISTS metadata (		CREATE TABLE IF NOT EXISTS metadata (
name TEXT UNIQUE PRIMARY KEY NOT NULL,		name TEXT UNIQUE PRIMARY KEY NOT NULL,
data TEXT NOT NULL		data TEXT NOT NULL
);		);

		CREATE TABLE IF NOT EXISTS persist_storage (
		key TEXT UNIQUE PRIMARY KEY NOT NULL,
		item TEXT NOT NULL
		);
`);		`);
}		}

export { getSQLiteDBVersion, setupSQLiteDB };		export { getSQLiteDBVersion, setupSQLiteDB };