summaryrefslogtreecommitdiff
path: root/persistence/sqlite/0001_Create_Initial_Tables.sql
blob: d563e4a8d263640e6a9fce7a0ae3adcfeb277d11 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
CREATE TABLE IF NOT EXISTS registrations (
    reg_id TEXT PRIMARY KEY NOT NULL,
    first_name TEXT NOT NULL,
    last_name TEXT NOT NULL,
    email TEXT NOT NULL,
    company TEXT,
    training_code TEXT,
    date TEXT NOT NULL,
    privacy_policy_accepted INTEGER NOT NULL,
    confirmed INTEGER NOT NULL
);

PRAGMA user_version = 1