summaryrefslogtreecommitdiff
path: root/sql/legacy/Pg-upgrade-2.3.8-2.3.9.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql/legacy/Pg-upgrade-2.3.8-2.3.9.sql')
-rwxr-xr-xsql/legacy/Pg-upgrade-2.3.8-2.3.9.sql15
1 files changed, 15 insertions, 0 deletions
diff --git a/sql/legacy/Pg-upgrade-2.3.8-2.3.9.sql b/sql/legacy/Pg-upgrade-2.3.8-2.3.9.sql
new file mode 100755
index 00000000..dc484cec
--- /dev/null
+++ b/sql/legacy/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';