diff options
| author | wei <> | 2006-01-06 04:42:44 +0000 |
|---|---|---|
| committer | wei <> | 2006-01-06 04:42:44 +0000 |
| commit | 4835704a04cf5aa5ec71a8aef902d54b9c6cae82 (patch) | |
| tree | 39623c082a78db1b3569a12ab54aa751d376af21 /framework/I18N/schema | |
| parent | 673d5c08a4d27906864659def27c7783fe45c04f (diff) | |
Adding I18N support.
Diffstat (limited to 'framework/I18N/schema')
| -rw-r--r-- | framework/I18N/schema/mysql.sql | 58 | ||||
| -rw-r--r-- | framework/I18N/schema/sqlite.sql | 49 |
2 files changed, 107 insertions, 0 deletions
diff --git a/framework/I18N/schema/mysql.sql b/framework/I18N/schema/mysql.sql new file mode 100644 index 00000000..55b0fd2b --- /dev/null +++ b/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/framework/I18N/schema/sqlite.sql b/framework/I18N/schema/sqlite.sql new file mode 100644 index 00000000..68d15d4d --- /dev/null +++ b/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');
+# --------------------------------------------------------
+
|