| 1 |
lars |
1 |
#
|
|
|
2 |
# Database : `messages` for I18N in PRADO
|
|
|
3 |
#
|
|
|
4 |
|
|
|
5 |
# --------------------------------------------------------
|
|
|
6 |
|
|
|
7 |
#
|
|
|
8 |
# Table structure for table `catalogue`
|
|
|
9 |
#
|
|
|
10 |
|
|
|
11 |
CREATE TABLE `catalogue` (
|
|
|
12 |
`cat_id` int(11) NOT NULL auto_increment,
|
|
|
13 |
`name` varchar(100) NOT NULL default '',
|
|
|
14 |
`source_lang` varchar(100) NOT NULL default '',
|
|
|
15 |
`target_lang` varchar(100) NOT NULL default '',
|
|
|
16 |
`date_created` int(11) NOT NULL default '0',
|
|
|
17 |
`date_modified` int(11) NOT NULL default '0',
|
|
|
18 |
`author` varchar(255) NOT NULL default '',
|
|
|
19 |
PRIMARY KEY (`cat_id`)
|
|
|
20 |
) TYPE=MyISAM AUTO_INCREMENT=4 ;
|
|
|
21 |
|
|
|
22 |
#
|
|
|
23 |
# Dumping data for table `catalogue`
|
|
|
24 |
#
|
|
|
25 |
|
|
|
26 |
INSERT INTO `catalogue` VALUES (1, 'messages', '', '', 0, 0, '');
|
|
|
27 |
INSERT INTO `catalogue` VALUES (2, 'messages.en', '', '', 0, 0, '');
|
|
|
28 |
INSERT INTO `catalogue` VALUES (3, 'messages.en_AU', '', '', 0, 0, '');
|
|
|
29 |
|
|
|
30 |
# --------------------------------------------------------
|
|
|
31 |
|
|
|
32 |
#
|
|
|
33 |
# Table structure for table `trans_unit`
|
|
|
34 |
#
|
|
|
35 |
|
|
|
36 |
CREATE TABLE `trans_unit` (
|
|
|
37 |
`msg_id` int(11) NOT NULL auto_increment,
|
|
|
38 |
`cat_id` int(11) NOT NULL default '1',
|
|
|
39 |
`id` varchar(255) NOT NULL default '',
|
|
|
40 |
`source` text NOT NULL,
|
|
|
41 |
`target` text NOT NULL,
|
|
|
42 |
`comments` text NOT NULL,
|
|
|
43 |
`date_added` int(11) NOT NULL default '0',
|
|
|
44 |
`date_modified` int(11) NOT NULL default '0',
|
|
|
45 |
`author` varchar(255) NOT NULL default '',
|
|
|
46 |
`translated` tinyint(1) NOT NULL default '0',
|
|
|
47 |
PRIMARY KEY (`msg_id`)
|
|
|
48 |
) TYPE=MyISAM AUTO_INCREMENT=6 ;
|
|
|
49 |
|
|
|
50 |
#
|
|
|
51 |
# Dumping data for table `trans_unit`
|
|
|
52 |
#
|
|
|
53 |
|
|
|
54 |
INSERT INTO `trans_unit` VALUES (1, 1, '1', 'Hello', 'Hello World', '', 0, 0, '', 1);
|
|
|
55 |
INSERT INTO `trans_unit` VALUES (2, 2, '', 'Hello', 'Hello :)', '', 0, 0, '', 0);
|
|
|
56 |
INSERT INTO `trans_unit` VALUES (3, 1, '1', 'Welcome', 'Welcome', '', 0, 0, '', 0);
|
|
|
57 |
INSERT INTO `trans_unit` VALUES (4, 3, '', 'Hello', 'G\'day Mate!', '', 0, 0, '', 0);
|
|
|
58 |
INSERT INTO `trans_unit` VALUES (5, 3, '', 'Welcome', 'Welcome Mate!', '', 0, 0, '', 0);
|