- New locale module thanks to Gerhard, Goba, Marco, Kristjan and others.

  The new locale module provides every functionality on the web interface, so you don't need to edit the configuration files or add columns, when you add a new language. This module is an integration of the old locale and localegettext modules, plus a bunch of logic to parse Gettext Portable Object files (opposed to Machine Object files, as supported by localegettext).

  Note: I made some minor changes to the context-sensitive help texts and to some of the status messages.

1 files changed, 38 insertions, 13 deletions

diff --git a/database/database.pgsql b/database/database.pgsql
index 669889f7f..8092f0d87 100644
--- a/database/database.pgsql
+++ b/database/database.pgsql
@@ -242,25 +242,49 @@ CREATE TABLE history (
 );
 
 --
--- Table structure for locales
+-- Table structure for locales_meta
 --
 
-CREATE TABLE locales (
-  lid SERIAL,
+CREATE TABLE locales_meta (
+  locale varchar(12) NOT NULL default '',
+  name varchar(64) NOT NULL default '',
+  enabled int4 NOT NULL default '0',
+  isdefault int4 NOT NULL default '0',
+  plurals int4 NOT NULL default '0',
+  formula varchar(128) NOT NULL default '',
+  PRIMARY KEY  (locale)
+);
+
+--
+-- Table structure for locales_source
+--
+
+CREATE sequence locales_source_lid_seq;
+
+CREATE TABLE locales_source (
+lid integer DEFAULT nextval('locales_source_lid_seq'::text) NOT NULL,
   location varchar(128) NOT NULL default '',
-  string text NOT NULL default '',
-  da text NOT NULL default '',
-  fi text NOT NULL default '',
-  fr text NOT NULL default '',
-  en text NOT NULL default '',
-  es text NOT NULL default '',
-  nl text NOT NULL default '',
-  no text NOT NULL default '',
-  sw text NOT NULL default '',
+  source text NOT NULL,
   PRIMARY KEY  (lid)
 );
 
 --
+-- Table structure for locales_target
+--
+
+CREATE TABLE locales_target (
+  lid int4 NOT NULL default '0',
+  translation text NOT NULL,
+  locale varchar(12) NOT NULL default '',
+  plid int4 NOT NULL default '0',
+  plural int4 NOT NULL default '0',
+    UNIQUE  (lid),
+    UNIQUE  (locale),
+    UNIQUE  (plid),
+    UNIQUE  (plural)
+);
+
+--
 -- Table structure for table 'menu'
 --
 
@@ -601,7 +625,7 @@ CREATE TABLE users (
   changed integer NOT NULL default '0',
   status smallint NOT NULL default '0',
   timezone varchar(8) default NULL,
-  language char(2) NOT NULL default '',
+  language varchar(12) NOT NULL default '',
   picture varchar(255) NOT NULL DEFAULT '',
   init varchar(64) default '',
   data text default '',
@@ -703,6 +727,7 @@ INSERT INTO filters VALUES (2,'filter',1,0);
 INSERT INTO filters VALUES (3,'filter',3,0);
 INSERT INTO variable (name,value) VALUES ('filter_html_1','i:1;');
 
+INSERT INTO locales_meta(locale, name, enabled, isdefault) VALUES('en', 'English', '1', '1');
 
 ---
 --- Functions