From d80bff6898019ff8793044a3c9e1fb824b763800 Mon Sep 17 00:00:00 2001 From: Frederick Muriuki Muriithi Date: Wed, 9 Nov 2022 11:55:12 +0300 Subject: Migrations: Add `resource_meta` field to `resource_categories` table --- ...-resource-meta-field-to-resource-categories-field.py | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) create mode 100644 migrations/auth/20221109_01_HbD5F-add-resource-meta-field-to-resource-categories-field.py (limited to 'migrations') diff --git a/migrations/auth/20221109_01_HbD5F-add-resource-meta-field-to-resource-categories-field.py b/migrations/auth/20221109_01_HbD5F-add-resource-meta-field-to-resource-categories-field.py new file mode 100644 index 0000000..6c829b1 --- /dev/null +++ b/migrations/auth/20221109_01_HbD5F-add-resource-meta-field-to-resource-categories-field.py @@ -0,0 +1,17 @@ +""" +Add 'resource_meta' field to 'resource_categories' field. +""" + +from yoyo import step + +__depends__ = {'20221108_04_CKcSL-init-data-in-resource-categories-table'} + +steps = [ + step( + """ + ALTER TABLE resource_categories + ADD COLUMN + resource_meta TEXT NOT NULL DEFAULT '[]' + """, + "ALTER TABLE resource_categories DROP COLUMN resource_meta") +] -- cgit v1.2.3