summaryrefslogtreecommitdiff
path: root/sql-ledger/sql/Pg-upgrade-2.3.8-2.3.9.sql
diff options
context:
space:
mode:
authorivan <ivan>2004-11-15 10:35:56 +0000
committerivan <ivan>2004-11-15 10:35:56 +0000
commit32306b5f8ffe4ce594409aa6e89626740b225a39 (patch)
tree8dba82e8424ebe8d089b4e0ef579d87db06742a3 /sql-ledger/sql/Pg-upgrade-2.3.8-2.3.9.sql
parent52072fcd26f2faf57923f598c358e7f47c4e2643 (diff)
import sql-ledger 2.4.4SQL_LEDGER
Diffstat (limited to 'sql-ledger/sql/Pg-upgrade-2.3.8-2.3.9.sql')
-rw-r--r--sql-ledger/sql/Pg-upgrade-2.3.8-2.3.9.sql15
1 files changed, 15 insertions, 0 deletions
diff --git a/sql-ledger/sql/Pg-upgrade-2.3.8-2.3.9.sql b/sql-ledger/sql/Pg-upgrade-2.3.8-2.3.9.sql
new file mode 100644
index 000000000..dc484cec0
--- /dev/null
+++ b/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';