summaryrefslogtreecommitdiff
path: root/src/db/migrations/0003.sql
diff options
context:
space:
mode:
authorFreya Murphy <freya@freyacat.org>2026-02-23 22:57:27 -0500
committerFreya Murphy <freya@freyacat.org>2026-02-23 22:57:27 -0500
commitf373ead95fb5beb962c376b5b7b46dfde8ac4e57 (patch)
treec99df23521ff2a5e5e2e4627c525a5e99dc2e3ae /src/db/migrations/0003.sql
parentadd 96x96 logo (diff)
downloadwebsite-f373ead95fb5beb962c376b5b7b46dfde8ac4e57.tar.gz
website-f373ead95fb5beb962c376b5b7b46dfde8ac4e57.tar.bz2
website-f373ead95fb5beb962c376b5b7b46dfde8ac4e57.zip
update website to work with crimson framework
Diffstat (limited to '')
-rw-r--r--src/db/migrations/0003.sql11
1 files changed, 11 insertions, 0 deletions
diff --git a/src/db/migrations/0003.sql b/src/db/migrations/0003.sql
new file mode 100644
index 0000000..1e47e73
--- /dev/null
+++ b/src/db/migrations/0003.sql
@@ -0,0 +1,11 @@
+BEGIN TRANSACTION;
+SET search_path = public;
+
+-- Migration Start
+ALTER SCHEMA admin RENAME TO website;
+-- Migration End;
+
+-- Set Current Revision
+UPDATE sys.database_info SET curr_revision = 4 WHERE name = current_database();
+
+COMMIT TRANSACTION;