aboutsummaryrefslogtreecommitdiff
path: root/migrations/auth
diff options
context:
space:
mode:
authorFrederick Muriuki Muriithi2022-12-19 13:50:10 +0300
committerFrederick Muriuki Muriithi2022-12-21 06:13:41 +0300
commit2a5d5ef7c0feab84cc3cd5d78f40e70050a49c00 (patch)
treeaa03fb1a3031dbc9a61bf3b9877912904e879eb9 /migrations/auth
parentd6f699bb0d2a9edca539733a16f786a1b7e957ae (diff)
downloadgenenetwork3-2a5d5ef7c0feab84cc3cd5d78f40e70050a49c00.tar.gz
migrations: create the authorisation_code table
* migrations/auth/20221219_03_PcTrb-create-authorisation-code-table.py: new migration * tests/unit/auth/test_migrations_create_tables.py: test new migration
Diffstat (limited to 'migrations/auth')
-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")
+]