summaryrefslogtreecommitdiff
path: root/src/db/migrations
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--src/db/migrations/0003.sql2
-rw-r--r--src/db/migrations/0004.sql16
2 files changed, 17 insertions, 1 deletions
diff --git a/src/db/migrations/0003.sql b/src/db/migrations/0003.sql
index 285a8f5..b9734ee 100644
--- a/src/db/migrations/0003.sql
+++ b/src/db/migrations/0003.sql
@@ -6,6 +6,6 @@ ALTER SCHEMA admin RENAME TO xssbook;
-- Migration End;
-- Set Current Revision
-UPDATE sys.database_info SET curr_revision = 3 WHERE name = current_database();
+UPDATE sys.database_info SET curr_revision = 4 WHERE name = current_database();
COMMIT TRANSACTION;
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;