aboutsummaryrefslogtreecommitdiff
path: root/migrations/auth/20221219_03_PcTrb-create-authorisation-code-table.py
diff options
context:
space:
mode:
Diffstat (limited to 'migrations/auth/20221219_03_PcTrb-create-authorisation-code-table.py')
-rw-r--r--migrations/auth/20221219_03_PcTrb-create-authorisation-code-table.py29
1 files changed, 29 insertions, 0 deletions
diff --git a/migrations/auth/20221219_03_PcTrb-create-authorisation-code-table.py b/migrations/auth/20221219_03_PcTrb-create-authorisation-code-table.py
new file mode 100644
index 0000000..495916f
--- /dev/null
+++ b/migrations/auth/20221219_03_PcTrb-create-authorisation-code-table.py
@@ -0,0 +1,29 @@
+"""
+create authorisation_code table
+"""
+
+from yoyo import step
+
+__depends__ = {'20221219_02_buSEU-create-oauth2-tokens-table'}
+
+steps = [
+ step(
+ """
+ CREATE TABLE authorisation_code (
+ code_id TEXT NOT NULL,
+ code TEXT UNIQUE NOT NULL,
+ client_id NOT NULL,
+ redirect_uri TEXT,
+ scope TEXT,
+ nonce TEXT,
+ auth_time INTEGER NOT NULL,
+ code_challenge TEXT,
+ code_challenge_method TEXT,
+ user_id TEXT NOT NULL,
+ PRIMARY KEY (code_id),
+ FOREIGN KEY (client_id) REFERENCES oauth2_clients(client_id),
+ FOREIGN KEY (user_id) REFERENCES users(user_id)
+ ) WITHOUT ROWID
+ """,
+ "DROP TABLE IF EXISTS authorisation_code")
+]