diff options
Diffstat (limited to '')
-rw-r--r-- | src/db/migrations/0004.sql | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/src/db/migrations/0004.sql b/src/db/migrations/0004.sql new file mode 100644 index 0000000..addf0fc --- /dev/null +++ b/src/db/migrations/0004.sql @@ -0,0 +1,16 @@ +BEGIN TRANSACTION; +SET search_path = public; + +-- Migration Start +CREATE TYPE xssbook.lang_type AS ENUM ( + 'en_US' +); + +ALTER TABLE xssbook.user + ADD COLUMN lang xssbook.lang_type DEFAULT 'en_US' NOT NULL; +-- Migration End; + +-- Set Current Revision +UPDATE sys.database_info SET curr_revision = 5 WHERE name = current_database(); + +COMMIT TRANSACTION; |