From 4a612d49e20543cdb1094134a0ddb7f804135594 Mon Sep 17 00:00:00 2001
From: Martin Fischer <martin@push-f.com>
Date: Sun, 9 Oct 2022 18:56:04 +0200
Subject: initial commit

---
 schema.sql | 8 ++++++++
 1 file changed, 8 insertions(+)
 create mode 100644 schema.sql

(limited to 'schema.sql')

diff --git a/schema.sql b/schema.sql
new file mode 100644
index 0000000..1720bfc
--- /dev/null
+++ b/schema.sql
@@ -0,0 +1,8 @@
+CREATE TABLE redirectauth_mappings (
+	local_id int NOT NULL UNIQUE,
+	external_id varchar(255) NOT NULL UNIQUE,
+	PRIMARY KEY (local_id, external_id)
+);
+-- We don't define a foreign key from local_id to the user table because doing so
+-- is difficult in a manner that works with both MySQL and PostgreSQL, so we'd
+-- have to maintain this schema in multiple dialects, which just isn't worth it.
-- 
cgit v1.3.1

