import sql-ledger 2.4.4

[freeside.git] / sql-ledger / sql-ledger / sql / Pg-upgrade-2.3.8-2.3.9.sql

diff --git a/sql-ledger/sql-ledger/sql/Pg-upgrade-2.3.8-2.3.9.sql b/sql-ledger/sql-ledger/sql/Pg-upgrade-2.3.8-2.3.9.sql
new file mode 100644 (file)
index 0000000..dc484ce
--- /dev/null
+++ b/sql-ledger/sql-ledger/sql/Pg-upgrade-2.3.8-2.3.9.sql
@@ -0,0 +1,15 @@
+--
+create table translation (
+  trans_id int,
+  language_code varchar(6),
+  description text
+);
+create index translation_trans_id_key on translation (trans_id);
+--
+alter table ar add language_code varchar(6);
+alter table ap add language_code varchar(6);
+alter table oe add language_code varchar(6);
+--
+create unique index language_code_key on language (code);
+--
+update defaults set version = '2.3.9';