19 lines
610 B
SQL
19 lines
610 B
SQL
-- 2020-0002. Initial user table
|
|
-- SQLite doesn't support UUID/BOOLEAN so just use TEXT/INTEGER
|
|
|
|
CREATE TABLE user (
|
|
id TEXT PRIMARY KEY NOT NULL,
|
|
display_name TEXT NOT NULL,
|
|
email TEXT NOT NULL,
|
|
password_format INTEGER NOT NULL,
|
|
password_hash TEXT NOT NULL,
|
|
is_admin INTEGER NOT NULL
|
|
);
|
|
|
|
CREATE UNIQUE INDEX user_email ON user(email);
|
|
|
|
INSERT INTO user (id, display_name, email, password_format, password_hash, is_admin) VALUES
|
|
( "c3e6a5f2-3707-4799-a845-2dc9f51ebc31", "admin", "admin@example.com", 0, "admin", 1 );
|
|
|
|
INSERT INTO `schema` (id) VALUES (20200002);
|