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