summaryrefslogtreecommitdiff
path: root/modules/locale/locale.install
diff options
context:
space:
mode:
Diffstat (limited to 'modules/locale/locale.install')
-rw-r--r--modules/locale/locale.install31
1 files changed, 31 insertions, 0 deletions
diff --git a/modules/locale/locale.install b/modules/locale/locale.install
index 08bcbc5bc..99192be0d 100644
--- a/modules/locale/locale.install
+++ b/modules/locale/locale.install
@@ -33,6 +33,37 @@ function locale_install() {
KEY plid (plid),
KEY plural (plural)
) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
+ break;
+ case 'pgsql':
+ db_query("CREATE TABLE {locales_meta} (
+ locale varchar(12) NOT NULL default '',
+ name varchar(64) NOT NULL default '',
+ enabled int NOT NULL default '0',
+ isdefault int NOT NULL default '0',
+ plurals int NOT NULL default '0',
+ formula varchar(128) NOT NULL default '',
+ PRIMARY KEY (locale)
+ )");
+
+ db_query("CREATE TABLE {locales_source} (
+ lid serial,
+ location varchar(255) NOT NULL default '',
+ source bytea NOT NULL,
+ PRIMARY KEY (lid)
+ )");
+
+ db_query("CREATE TABLE {locales_target} (
+ lid int NOT NULL default '0',
+ translation bytea NOT NULL,
+ locale varchar(12) NOT NULL default '',
+ plid int NOT NULL default '0',
+ plural int NOT NULL default '0'
+ )");
+ db_query("CREATE INDEX {locales_target}_lid_idx ON {locales_target} (lid)");
+ db_query("CREATE INDEX {locales_target}_locale_idx ON {locales_target} (locale)");
+ db_query("CREATE INDEX {locales_target}_plid_idx ON {locales_target} (plid)");
+ db_query("CREATE INDEX {locales_target}_plural_idx ON {locales_target} (plural)");
+ break;
}
db_query("INSERT INTO {locales_meta} (locale, name, enabled, isdefault) VALUES ('en', 'English', '1', '1')");
}