diff options
author | Frederick Muriuki Muriithi | 2022-11-08 13:51:45 +0300 |
---|---|---|
committer | Frederick Muriuki Muriithi | 2022-11-08 13:51:45 +0300 |
commit | dbd3b240811cb095bc87136501ee846f7b0cb42b (patch) | |
tree | 2ac59e561f7ba8517157f0d8aa78e47d770e7de5 /migrations | |
parent | 11e1ec3f5aaa2489b2e0b2f9f69f6a13c6aaa7ff (diff) | |
download | genenetwork3-dbd3b240811cb095bc87136501ee846f7b0cb42b.tar.gz |
Add migration to create the groups table.
Diffstat (limited to 'migrations')
-rw-r--r-- | migrations/auth/20221108_01_CoxYh-create-the-groups-table.py | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/migrations/auth/20221108_01_CoxYh-create-the-groups-table.py b/migrations/auth/20221108_01_CoxYh-create-the-groups-table.py new file mode 100644 index 0000000..06491dd --- /dev/null +++ b/migrations/auth/20221108_01_CoxYh-create-the-groups-table.py @@ -0,0 +1,18 @@ +""" +Create the groups table +""" + +from yoyo import step + +__depends__ = {'20221103_02_sGrIs-create-user-credentials-table'} + +steps = [ + step( + """ + CREATE TABLE IF NOT EXISTS groups( + group_id TEXT PRIMARY KEY NOT NULL, + group_name TEXT NOT NULL + ) WITHOUT ROWID + """, + "DROP TABLE IF EXISTS groups") +] |