diff options
| author | emkael <emkael@tlen.pl> | 2016-02-24 23:18:07 +0100 |
|---|---|---|
| committer | emkael <emkael@tlen.pl> | 2016-02-24 23:18:07 +0100 |
| commit | 6f7fdef0f500cd4bb540affd3bc1482243f337c1 (patch) | |
| tree | 4853eecd0769a903e6130c1896e1d070848150dd /lib/prado/framework/I18N/schema/sqlite.sql | |
| parent | 61f2ea48a4e11cb5fb941b3783e19c9e9ef38a45 (diff) | |
* Prado 3.3.0
Diffstat (limited to 'lib/prado/framework/I18N/schema/sqlite.sql')
| -rw-r--r-- | lib/prado/framework/I18N/schema/sqlite.sql | 49 |
1 files changed, 49 insertions, 0 deletions
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');
+# --------------------------------------------------------
+
|