From e6d7e091b7b6dde1c736e7baf01fad5fd5c1ce27 Mon Sep 17 00:00:00 2001
From: uvok cheetah
Date: Fri, 8 Dec 2023 17:05:40 +0000
Subject: Initial Commit

---
 persistence/sqlite/0001_Create_Initial_Tables.sql | 13 +++++++++++++
 1 file changed, 13 insertions(+)
 create mode 100644 persistence/sqlite/0001_Create_Initial_Tables.sql

(limited to 'persistence/sqlite/0001_Create_Initial_Tables.sql')

diff --git a/persistence/sqlite/0001_Create_Initial_Tables.sql b/persistence/sqlite/0001_Create_Initial_Tables.sql
new file mode 100644
index 0000000..d563e4a
--- /dev/null
+++ b/persistence/sqlite/0001_Create_Initial_Tables.sql
@@ -0,0 +1,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
-- 
cgit v1.2.3