3 files changed, 147 insertions, 0 deletions
diff --git a/lib/prado/framework/I18N/schema/mysql.sql b/lib/prado/framework/I18N/schema/mysql.sql
new file mode 100644
index 0000000..55b0fd2
--- /dev/null
+++ b/lib/prado/framework/I18N/schema/mysql.sql
@@ -0,0 +1,58 @@
+# 
+# Database : `messages` for I18N in PRADO
+# 
+
+# --------------------------------------------------------
+
+#
+# Table structure for table `catalogue`
+#
+
+CREATE TABLE `catalogue` (
+  `cat_id` int(11) NOT NULL auto_increment,
+  `name` varchar(100) NOT NULL default '',
+  `source_lang` varchar(100) NOT NULL default '',
+  `target_lang` varchar(100) NOT NULL default '',
+  `date_created` int(11) NOT NULL default '0',
+  `date_modified` int(11) NOT NULL default '0',
+  `author` varchar(255) NOT NULL default '',
+  PRIMARY KEY  (`cat_id`)
+) TYPE=MyISAM AUTO_INCREMENT=4 ;
+
+#
+# Dumping data for table `catalogue`
+#
+
+INSERT INTO `catalogue` VALUES (1, 'messages', '', '', 0, 0, '');
+INSERT INTO `catalogue` VALUES (2, 'messages.en', '', '', 0, 0, '');
+INSERT INTO `catalogue` VALUES (3, 'messages.en_AU', '', '', 0, 0, '');
+
+# --------------------------------------------------------
+
+#
+# Table structure for table `trans_unit`
+#
+
+CREATE TABLE `trans_unit` (
+  `msg_id` int(11) NOT NULL auto_increment,
+  `cat_id` int(11) NOT NULL default '1',
+  `id` varchar(255) NOT NULL default '',
+  `source` text NOT NULL,
+  `target` text NOT NULL,
+  `comments` text NOT NULL,
+  `date_added` int(11) NOT NULL default '0',
+  `date_modified` int(11) NOT NULL default '0',
+  `author` varchar(255) NOT NULL default '',
+  `translated` tinyint(1) NOT NULL default '0',
+  PRIMARY KEY  (`msg_id`)
+) TYPE=MyISAM AUTO_INCREMENT=6 ;
+
+#
+# Dumping data for table `trans_unit`
+#
+
+INSERT INTO `trans_unit` VALUES (1, 1, '1', 'Hello', 'Hello World', '', 0, 0, '', 1);
+INSERT INTO `trans_unit` VALUES (2, 2, '', 'Hello', 'Hello :)', '', 0, 0, '', 0);
+INSERT INTO `trans_unit` VALUES (3, 1, '1', 'Welcome', 'Welcome', '', 0, 0, '', 0);
+INSERT INTO `trans_unit` VALUES (4, 3, '', 'Hello', 'G\'day Mate!', '', 0, 0, '', 0);
+INSERT INTO `trans_unit` VALUES (5, 3, '', 'Welcome', 'Welcome Mate!', '', 0, 0, '', 0);    
+\ No newline at end of file
diff --git a/lib/prado/framework/I18N/schema/postgresql.sql b/lib/prado/framework/I18N/schema/postgresql.sql
new file mode 100644
index 0000000..938126a
--- /dev/null
+++ b/lib/prado/framework/I18N/schema/postgresql.sql
@@ -0,0 +1,40 @@
+
+-- Table structure for table catalogue
+
+CREATE TABLE catalogue (
+  cat_id serial NOT NULL primary key,
+  name varchar(100) NOT NULL default '',
+  source_lang varchar(100) NOT NULL default '',
+  target_lang varchar(100) NOT NULL default '',
+  date_created int NOT NULL default 0,
+  date_modified int NOT NULL default 0,
+  author varchar(255) NOT NULL default ''
+);
+
+-- Dumping data for table catalogue
+
+INSERT INTO catalogue VALUES (nextval('catalogue_cat_id_seq'), 'messages', '', '', 0, 0, '');
+INSERT INTO catalogue VALUES (nextval('catalogue_cat_id_seq'), 'messages.en', '', '', 0, 0, '');
+INSERT INTO catalogue VALUES (nextval('catalogue_cat_id_seq'), 'messages.en_AU', '', '', 0, 0, '');
+
+-- Table structure for table trans_unit
+
+CREATE TABLE trans_unit (
+  msg_id serial NOT NULL primary key,
+  cat_id int NOT NULL default 1,
+  id varchar(255) NOT NULL default '',
+  source text NOT NULL,
+  target text NOT NULL default '',
+  comments text NOT NULL default '',
+  date_added int NOT NULL default 0,
+  date_modified int NOT NULL default 0,
+  author varchar(255) NOT NULL default '',
+  translated smallint NOT NULL default 0
+);
+
+INSERT INTO trans_unit VALUES (nextval('trans_unit_msg_id_seq'), 1, '1', 'Hello', 'Hello World', '', 0, 0, '', 1);
+INSERT INTO trans_unit VALUES (nextval('trans_unit_msg_id_seq'), 2, '', 'Hello', 'Hello :)', '', 0, 0, '', 0);
+INSERT INTO trans_unit VALUES (nextval('trans_unit_msg_id_seq'), 1, '1', 'Welcome', 'Welcome', '', 0, 0, '', 0);
+INSERT INTO trans_unit VALUES (nextval('trans_unit_msg_id_seq'), 3, '', 'Hello', 'G''day Mate!', '', 0, 0, '', 0);
+INSERT INTO trans_unit VALUES (nextval('trans_unit_msg_id_seq'), 3, '', 'Welcome', 'Welcome Mate!', '', 0, 0, '', 0);    
+
diff --git a/lib/prado/framework/I18N/schema/sqlite.sql b/lib/prado/framework/I18N/schema/sqlite.sql
new file mode 100644
index 0000000..68d15d4
--- /dev/null
+++ b/lib/prado/framework/I18N/schema/sqlite.sql
@@ -0,0 +1,49 @@
+# Database: messages.db for I18N in PRADO
+# --------------------------------------------------------
+
+#
+# Table structure for table: catalogue
+#
+CREATE TABLE catalogue ( 
+  cat_id INTEGER PRIMARY KEY, 
+  name VARCHAR NOT NULL, 
+  source_lang VARCHAR , 
+  target_lang VARCHAR , 
+  date_created INT, 
+  date_modified INT, 
+  author VARCHAR );
+
+#
+# Dumping data for table: catalogue
+#
+INSERT INTO catalogue VALUES ('1', 'messages', '', '', '', '', '');
+INSERT INTO catalogue VALUES ('2', 'messages.en', '', '', '', '', '');
+INSERT INTO catalogue VALUES ('3', 'messages.en_AU', '', '', '', '', '');
+# --------------------------------------------------------
+
+
+#
+# Table structure for table: trans_unit
+#
+CREATE TABLE trans_unit ( 
+  msg_id INTEGER PRIMARY KEY, 
+  cat_id INTEGER NOT NULL DEFAULT '1', 
+  id VARCHAR, 
+  source TEXT, 
+  target TEXT, 
+  comments TEXT, 
+  date_added INT, 
+  date_modified INT, 
+  author VARCHAR, 
+  translated INT(1) NOT NULL DEFAULT '0' );
+
+#
+# Dumping data for table: trans_unit
+#
+INSERT INTO trans_unit VALUES ('1', '1', '1', 'Hello', 'Hello World', '', '', '', '', '1');
+INSERT INTO trans_unit VALUES ('2', '2', '', 'Hello', 'Hello :)', '', '', '', '', '0');
+INSERT INTO trans_unit VALUES ('3', '1', '1', 'Welcome', 'Welcome', '', '', '', '', '0');
+INSERT INTO trans_unit VALUES ('4', '3', '', 'Hello', 'G''day Mate!', '', '', '', '', '0');
+INSERT INTO trans_unit VALUES ('5', '3', '', 'Welcome', 'Welcome Mate!', '', '', '', '', '0');
+# --------------------------------------------------------
+