| 1 |
lars |
1 |
# Database: messages.db for I18N in PRADO
|
|
|
2 |
# --------------------------------------------------------
|
|
|
3 |
|
|
|
4 |
#
|
|
|
5 |
# Table structure for table: catalogue
|
|
|
6 |
#
|
|
|
7 |
CREATE TABLE catalogue (
|
|
|
8 |
cat_id INTEGER PRIMARY KEY,
|
|
|
9 |
name VARCHAR NOT NULL,
|
|
|
10 |
source_lang VARCHAR ,
|
|
|
11 |
target_lang VARCHAR ,
|
|
|
12 |
date_created INT,
|
|
|
13 |
date_modified INT,
|
|
|
14 |
author VARCHAR );
|
|
|
15 |
|
|
|
16 |
#
|
|
|
17 |
# Dumping data for table: catalogue
|
|
|
18 |
#
|
|
|
19 |
INSERT INTO catalogue VALUES ('1', 'messages', '', '', '', '', '');
|
|
|
20 |
INSERT INTO catalogue VALUES ('2', 'messages.en', '', '', '', '', '');
|
|
|
21 |
INSERT INTO catalogue VALUES ('3', 'messages.en_AU', '', '', '', '', '');
|
|
|
22 |
# --------------------------------------------------------
|
|
|
23 |
|
|
|
24 |
|
|
|
25 |
#
|
|
|
26 |
# Table structure for table: trans_unit
|
|
|
27 |
#
|
|
|
28 |
CREATE TABLE trans_unit (
|
|
|
29 |
msg_id INTEGER PRIMARY KEY,
|
|
|
30 |
cat_id INTEGER NOT NULL DEFAULT '1',
|
|
|
31 |
id VARCHAR,
|
|
|
32 |
source TEXT,
|
|
|
33 |
target TEXT,
|
|
|
34 |
comments TEXT,
|
|
|
35 |
date_added INT,
|
|
|
36 |
date_modified INT,
|
|
|
37 |
author VARCHAR,
|
|
|
38 |
translated INT(1) NOT NULL DEFAULT '0' );
|
|
|
39 |
|
|
|
40 |
#
|
|
|
41 |
# Dumping data for table: trans_unit
|
|
|
42 |
#
|
|
|
43 |
INSERT INTO trans_unit VALUES ('1', '1', '1', 'Hello', 'Hello World', '', '', '', '', '1');
|
|
|
44 |
INSERT INTO trans_unit VALUES ('2', '2', '', 'Hello', 'Hello :)', '', '', '', '', '0');
|
|
|
45 |
INSERT INTO trans_unit VALUES ('3', '1', '1', 'Welcome', 'Welcome', '', '', '', '', '0');
|
|
|
46 |
INSERT INTO trans_unit VALUES ('4', '3', '', 'Hello', 'G''day Mate!', '', '', '', '', '0');
|
|
|
47 |
INSERT INTO trans_unit VALUES ('5', '3', '', 'Welcome', 'Welcome Mate!', '', '', '', '', '0');
|
|
|
48 |
# --------------------------------------------------------
|
|
|
49 |
|