summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorNeil Drumm <drumm@3064.no-reply.drupal.org>2006-11-14 06:20:40 +0000
committerNeil Drumm <drumm@3064.no-reply.drupal.org>2006-11-14 06:20:40 +0000
commite7ca0fe512f9b884246d9879ec81878d9fd1c502 (patch)
tree94f241148134142ea98d80af497371e596902a42
parent83f4d88618d6b42c7ee7fb6e19ceed5f71406f73 (diff)
downloadbrdo-e7ca0fe512f9b884246d9879ec81878d9fd1c502.tar.gz
brdo-e7ca0fe512f9b884246d9879ec81878d9fd1c502.tar.bz2
#93506 by sammys. Postgres needs a different column type for source and target.
-rw-r--r--modules/locale/locale.install8
1 files changed, 6 insertions, 2 deletions
diff --git a/modules/locale/locale.install b/modules/locale/locale.install
index e61449cd1..ecba85916 100644
--- a/modules/locale/locale.install
+++ b/modules/locale/locale.install
@@ -5,6 +5,9 @@
* Implementation of hook_install().
*/
function locale_install() {
+ // locales_source.source and locales_target.target are not used as binary
+ // fields; non-MySQL database servers need to ensure the field type is text
+ // and that LIKE produces a case-sensitive comparison.
switch ($GLOBALS['db_type']) {
case 'mysql':
case 'mysqli':
@@ -38,6 +41,7 @@ function locale_install() {
KEY plural (plural)
) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
break;
+
case 'pgsql':
db_query("CREATE TABLE {locales_meta} (
locale varchar(12) NOT NULL default '',
@@ -52,13 +56,13 @@ function locale_install() {
db_query("CREATE TABLE {locales_source} (
lid serial,
location varchar(255) NOT NULL default '',
- source bytea NOT NULL,
+ source text NOT NULL,
PRIMARY KEY (lid)
)");
db_query("CREATE TABLE {locales_target} (
lid int NOT NULL default '0',
- translation bytea NOT NULL,
+ translation text NOT NULL,
locale varchar(12) NOT NULL default '',
plid int NOT NULL default '0',
plural int NOT NULL default '0'