db/db-data.sql
author Tomas Zeman <tzeman@volny.cz>
Tue, 24 Apr 2012 20:36:06 +0200
changeset 80 196896cc3f58
parent 79 25392159b6ca
child 81 c7d21399c726
permissions -rw-r--r--
Code list item should localize itself if i18n is on

-- Project states
INSERT INTO code_list_item
(code_list, id, i18n, name, rank, dflt, i1,
i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted)
VALUES
('project_state', nextval('code_list_item_id_seq'), true, 'project.state.assigned', 10, true, 0,
0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false);
INSERT INTO code_list_item
(code_list, id, i18n, name, rank, dflt, i1,
i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted)
VALUES
('project_state', nextval('code_list_item_id_seq'), true, 'project.state.paused', 45, false, 0,
0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false);
INSERT INTO code_list_item
(code_list, id, i18n, name, rank, dflt, i1,
i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted)
VALUES
('project_state', nextval('code_list_item_id_seq'), true, 'project.state.in_preparation', 20, false, 0,
0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false);
INSERT INTO code_list_item
(code_list, id, i18n, name, rank, dflt, i1,
i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted)
VALUES
('project_state', nextval('code_list_item_id_seq'), true, 'project.state.in_realization', 30, false, 0,
0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false);
INSERT INTO code_list_item
(code_list, id, i18n, name, rank, dflt, i1,
i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted)
VALUES
('project_state', nextval('code_list_item_id_seq'), true, 'project.state.cancelled', 50, false, 1,
0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false);
INSERT INTO code_list_item
(code_list, id, i18n, name, rank, dflt, i1,
i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted)
VALUES
('project_state', nextval('code_list_item_id_seq'), true, 'project.state.realized', 40, false, 1,
0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false);