persistence/sqlite/0001_Create_Initial_Tables.sql


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