summaryrefslogtreecommitdiff
path: root/framework/I18N/schema/postgresql.sql
blob: 938126aa26ad752d43e544e377d5a038cd818b7e (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40

-- Table structure for table catalogue

CREATE TABLE catalogue (
  cat_id serial NOT NULL primary key,
  name varchar(100) NOT NULL default '',
  source_lang varchar(100) NOT NULL default '',
  target_lang varchar(100) NOT NULL default '',
  date_created int NOT NULL default 0,
  date_modified int NOT NULL default 0,
  author varchar(255) NOT NULL default ''
);

-- Dumping data for table catalogue

INSERT INTO catalogue VALUES (nextval('catalogue_cat_id_seq'), 'messages', '', '', 0, 0, '');
INSERT INTO catalogue VALUES (nextval('catalogue_cat_id_seq'), 'messages.en', '', '', 0, 0, '');
INSERT INTO catalogue VALUES (nextval('catalogue_cat_id_seq'), 'messages.en_AU', '', '', 0, 0, '');

-- Table structure for table trans_unit

CREATE TABLE trans_unit (
  msg_id serial NOT NULL primary key,
  cat_id int NOT NULL default 1,
  id varchar(255) NOT NULL default '',
  source text NOT NULL,
  target text NOT NULL default '',
  comments text NOT NULL default '',
  date_added int NOT NULL default 0,
  date_modified int NOT NULL default 0,
  author varchar(255) NOT NULL default '',
  translated smallint NOT NULL default 0
);

INSERT INTO trans_unit VALUES (nextval('trans_unit_msg_id_seq'), 1, '1', 'Hello', 'Hello World', '', 0, 0, '', 1);
INSERT INTO trans_unit VALUES (nextval('trans_unit_msg_id_seq'), 2, '', 'Hello', 'Hello :)', '', 0, 0, '', 0);
INSERT INTO trans_unit VALUES (nextval('trans_unit_msg_id_seq'), 1, '1', 'Welcome', 'Welcome', '', 0, 0, '', 0);
INSERT INTO trans_unit VALUES (nextval('trans_unit_msg_id_seq'), 3, '', 'Hello', 'G''day Mate!', '', 0, 0, '', 0);
INSERT INTO trans_unit VALUES (nextval('trans_unit_msg_id_seq'), 3, '', 'Welcome', 'Welcome Mate!', '', 0, 0, '', 0);