CREATE TYPE JUDGE AS ENUM ('Absolute', 'Points');
CREATE TABLE users (
- id TEXT PRIMARY KEY,
+ id TEXT PRIMARY KEY,
+ passphrase TEXT NOT NULL,
+ admin BOOLEAN NOT NULL DEFAULT FALSE,
name TEXT, -- NOT NULL,
email TEXT, -- NOT NULL,
phone TEXT, -- NOT NULL,
CREATE TABLE problems (
id TEXT PRIMARY KEY,
author TEXT,
+ writer TEXT,
generator GENERATOR NOT NULL,
judge JUDGE NOT NULL,
level PLEVEL NOT NULL,