1 -- Project states |
1 -- Project states |
2 INSERT INTO code_list_item |
2 INSERT INTO code_list_item |
3 (code_list, id, i18n, name, rank, dflt, i1, |
3 (code_list, id, i18n, name, rank, dflt, i1, |
4 i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted) |
4 i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted) |
5 VALUES |
5 VALUES |
6 ('project_state', nextval('code_list_item_id_seq'), true, 'project.state.assigned', 10, true, 0, |
6 ('project_state', nextval('code_list_item_id_seq'), true, 'project.state.new', 1, true, 0, |
7 0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false); |
7 0, 0, 0, 0, 0, 'new', '', '', current_timestamp, current_timestamp, false); |
|
8 INSERT INTO code_list_item |
|
9 (code_list, id, i18n, name, rank, dflt, i1, |
|
10 i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted) |
|
11 VALUES |
|
12 ('project_state', nextval('code_list_item_id_seq'), true, 'project.state.assigned', 10, false, 0, |
|
13 0, 0, 0, 0, 0, 'assigned', '', '', current_timestamp, current_timestamp, false); |
8 INSERT INTO code_list_item |
14 INSERT INTO code_list_item |
9 (code_list, id, i18n, name, rank, dflt, i1, |
15 (code_list, id, i18n, name, rank, dflt, i1, |
10 i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted) |
16 i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted) |
11 VALUES |
17 VALUES |
12 ('project_state', nextval('code_list_item_id_seq'), true, 'project.state.paused', 45, false, 0, |
18 ('project_state', nextval('code_list_item_id_seq'), true, 'project.state.paused', 45, false, 0, |
26 INSERT INTO code_list_item |
32 INSERT INTO code_list_item |
27 (code_list, id, i18n, name, rank, dflt, i1, |
33 (code_list, id, i18n, name, rank, dflt, i1, |
28 i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted) |
34 i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted) |
29 VALUES |
35 VALUES |
30 ('project_state', nextval('code_list_item_id_seq'), true, 'project.state.cancelled', 50, false, 1, |
36 ('project_state', nextval('code_list_item_id_seq'), true, 'project.state.cancelled', 50, false, 1, |
31 0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false); |
37 0, 0, 0, 0, 0, 'closed', '', '', current_timestamp, current_timestamp, false); |
32 INSERT INTO code_list_item |
38 INSERT INTO code_list_item |
33 (code_list, id, i18n, name, rank, dflt, i1, |
39 (code_list, id, i18n, name, rank, dflt, i1, |
34 i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted) |
40 i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted) |
35 VALUES |
41 VALUES |
36 ('project_state', nextval('code_list_item_id_seq'), true, 'project.state.realized', 40, false, 1, |
42 ('project_state', nextval('code_list_item_id_seq'), true, 'project.state.realized', 40, false, 1, |
37 0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false); |
43 0, 0, 0, 0, 0, 'closed', '', '', current_timestamp, current_timestamp, false); |
38 |
44 -- Project phases |
|
45 INSERT INTO code_list_item |
|
46 (code_list, id, i18n, name, rank, dflt, i1, |
|
47 i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted) |
|
48 VALUES |
|
49 ('project_phase', nextval('code_list_item_id_seq'), true, 'project.phase.offer', 10, true, 0, |
|
50 0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false); |
|
51 INSERT INTO code_list_item |
|
52 (code_list, id, i18n, name, rank, dflt, i1, |
|
53 i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted) |
|
54 VALUES |
|
55 ('project_phase', nextval('code_list_item_id_seq'), true, 'project.phase.realization', 20, false, 0, |
|
56 0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false); |
39 -- Task states |
57 -- Task states |
40 INSERT INTO code_list_item |
58 INSERT INTO code_list_item |
41 (code_list, id, i18n, name, rank, dflt, i1, |
59 (code_list, id, i18n, name, rank, dflt, i1, |
42 i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted) |
60 i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted) |
43 VALUES |
61 VALUES |