summaryrefslogtreecommitdiff
path: root/sql-ledger/sql/Pg-upgrade-2.4.3-2.4.4.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql-ledger/sql/Pg-upgrade-2.4.3-2.4.4.sql')
-rw-r--r--sql-ledger/sql/Pg-upgrade-2.4.3-2.4.4.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql-ledger/sql/Pg-upgrade-2.4.3-2.4.4.sql b/sql-ledger/sql/Pg-upgrade-2.4.3-2.4.4.sql
new file mode 100644
index 000000000..38e257514
--- /dev/null
+++ b/sql-ledger/sql/Pg-upgrade-2.4.3-2.4.4.sql
@@ -0,0 +1,5 @@
+--
+alter table employee add dob date;
+alter table employee rename sin to ssn;
+--
+update defaults set version = '2.4.4';