| 1 |
lars |
1 |
|
|
|
2 |
-- Table structure for table catalogue
|
|
|
3 |
|
|
|
4 |
CREATE TABLE catalogue (
|
|
|
5 |
cat_id serial NOT NULL primary key,
|
|
|
6 |
name varchar(100) NOT NULL default '',
|
|
|
7 |
source_lang varchar(100) NOT NULL default '',
|
|
|
8 |
target_lang varchar(100) NOT NULL default '',
|
|
|
9 |
date_created int NOT NULL default 0,
|
|
|
10 |
date_modified int NOT NULL default 0,
|
|
|
11 |
author varchar(255) NOT NULL default ''
|
|
|
12 |
);
|
|
|
13 |
|
|
|
14 |
-- Dumping data for table catalogue
|
|
|
15 |
|
|
|
16 |
INSERT INTO catalogue VALUES (nextval('catalogue_cat_id_seq'), 'messages', '', '', 0, 0, '');
|
|
|
17 |
INSERT INTO catalogue VALUES (nextval('catalogue_cat_id_seq'), 'messages.en', '', '', 0, 0, '');
|
|
|
18 |
INSERT INTO catalogue VALUES (nextval('catalogue_cat_id_seq'), 'messages.en_AU', '', '', 0, 0, '');
|
|
|
19 |
|
|
|
20 |
-- Table structure for table trans_unit
|
|
|
21 |
|
|
|
22 |
CREATE TABLE trans_unit (
|
|
|
23 |
msg_id serial NOT NULL primary key,
|
|
|
24 |
cat_id int NOT NULL default 1,
|
|
|
25 |
id varchar(255) NOT NULL default '',
|
|
|
26 |
source text NOT NULL,
|
|
|
27 |
target text NOT NULL default '',
|
|
|
28 |
comments text NOT NULL default '',
|
|
|
29 |
date_added int NOT NULL default 0,
|
|
|
30 |
date_modified int NOT NULL default 0,
|
|
|
31 |
author varchar(255) NOT NULL default '',
|
|
|
32 |
translated smallint NOT NULL default 0
|
|
|
33 |
);
|
|
|
34 |
|
|
|
35 |
INSERT INTO trans_unit VALUES (nextval('trans_unit_msg_id_seq'), 1, '1', 'Hello', 'Hello World', '', 0, 0, '', 1);
|
|
|
36 |
INSERT INTO trans_unit VALUES (nextval('trans_unit_msg_id_seq'), 2, '', 'Hello', 'Hello :)', '', 0, 0, '', 0);
|
|
|
37 |
INSERT INTO trans_unit VALUES (nextval('trans_unit_msg_id_seq'), 1, '1', 'Welcome', 'Welcome', '', 0, 0, '', 0);
|
|
|
38 |
INSERT INTO trans_unit VALUES (nextval('trans_unit_msg_id_seq'), 3, '', 'Hello', 'G''day Mate!', '', 0, 0, '', 0);
|
|
|
39 |
INSERT INTO trans_unit VALUES (nextval('trans_unit_msg_id_seq'), 3, '', 'Welcome', 'Welcome Mate!', '', 0, 0, '', 0);
|
|
|
40 |
|