Initial Commit

1 files changed, 13 insertions, 0 deletions

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