diff options
| author | Frederick Muriuki Muriithi | 2023-08-04 10:10:28 +0300 |
|---|---|---|
| committer | Frederick Muriuki Muriithi | 2023-08-04 10:20:09 +0300 |
| commit | 8b7c598407a5fea9a3d78473e72df87606998cd4 (patch) | |
| tree | 8526433a17eca6b511feb082a0574f9b15cb9469 /migrations/auth/20221208_01_sSdHz-add-public-column-to-resources-table.py | |
| parent | f7fcbbcc014686ac597b783a8dcb38b43024b9d6 (diff) | |
| download | gn-auth-8b7c598407a5fea9a3d78473e72df87606998cd4.tar.gz | |
Copy over files from GN3 repository.
Diffstat (limited to 'migrations/auth/20221208_01_sSdHz-add-public-column-to-resources-table.py')
| -rw-r--r-- | migrations/auth/20221208_01_sSdHz-add-public-column-to-resources-table.py | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/migrations/auth/20221208_01_sSdHz-add-public-column-to-resources-table.py b/migrations/auth/20221208_01_sSdHz-add-public-column-to-resources-table.py new file mode 100644 index 0000000..2238069 --- /dev/null +++ b/migrations/auth/20221208_01_sSdHz-add-public-column-to-resources-table.py @@ -0,0 +1,16 @@ +""" +Add 'public' column to 'resources' table +""" + +from yoyo import step + +__depends__ = {'20221206_01_BbeF9-create-group-user-roles-on-resources-table'} + +steps = [ + step( + """ + ALTER TABLE resources ADD COLUMN + public INTEGER NOT NULL DEFAULT 0 CHECK (public=0 or public=1) + """, + "ALTER TABLE resources DROP COLUMN public") +] |