|
1 -- Project states |
|
2 INSERT INTO code_list_item |
|
3 (code_list, id, i18n, name, rank, dflt, i1, |
|
4 i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted) |
|
5 VALUES |
|
6 ('project_state', nextval('code_list_item_id_seq'), true, 'project.state.assigned', 10, true, 0, |
|
7 0, 0, 0, 0, 0, '', '', '', 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.paused', 45, false, 0, |
|
13 0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false); |
|
14 INSERT INTO code_list_item |
|
15 (code_list, id, i18n, name, rank, dflt, i1, |
|
16 i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted) |
|
17 VALUES |
|
18 ('project_state', nextval('code_list_item_id_seq'), true, 'project.state.in_preparation', 20, false, 0, |
|
19 0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false); |
|
20 INSERT INTO code_list_item |
|
21 (code_list, id, i18n, name, rank, dflt, i1, |
|
22 i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted) |
|
23 VALUES |
|
24 ('project_state', nextval('code_list_item_id_seq'), true, 'project.state.in_realization', 30, false, 0, |
|
25 0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false); |
|
26 INSERT INTO code_list_item |
|
27 (code_list, id, i18n, name, rank, dflt, i1, |
|
28 i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted) |
|
29 VALUES |
|
30 ('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); |
|
32 INSERT INTO code_list_item |
|
33 (code_list, id, i18n, name, rank, dflt, i1, |
|
34 i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted) |
|
35 VALUES |
|
36 ('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); |
|
38 |
|
39 -- Task states |
|
40 INSERT INTO code_list_item |
|
41 (code_list, id, i18n, name, rank, dflt, i1, |
|
42 i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted) |
|
43 VALUES |
|
44 ('task_state', nextval('code_list_item_id_seq'), false, '', 0, false, 0, |
|
45 0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false); |
|
46 INSERT INTO code_list_item |
|
47 (code_list, id, i18n, name, rank, dflt, i1, |
|
48 i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted) |
|
49 VALUES |
|
50 ('task_state', nextval('code_list_item_id_seq'), false, '', 10, false, 10, |
|
51 0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false); |
|
52 INSERT INTO code_list_item |
|
53 (code_list, id, i18n, name, rank, dflt, i1, |
|
54 i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted) |
|
55 VALUES |
|
56 ('task_state', nextval('code_list_item_id_seq'), false, '', 20, false, 20, |
|
57 0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false); |
|
58 INSERT INTO code_list_item |
|
59 (code_list, id, i18n, name, rank, dflt, i1, |
|
60 i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted) |
|
61 VALUES |
|
62 ('task_state', nextval('code_list_item_id_seq'), false, '', 30, false, 30, |
|
63 0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false); |
|
64 INSERT INTO code_list_item |
|
65 (code_list, id, i18n, name, rank, dflt, i1, |
|
66 i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted) |
|
67 VALUES |
|
68 ('task_state', nextval('code_list_item_id_seq'), false, '', 40, false, 40, |
|
69 0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false); |
|
70 INSERT INTO code_list_item |
|
71 (code_list, id, i18n, name, rank, dflt, i1, |
|
72 i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted) |
|
73 VALUES |
|
74 ('task_state', nextval('code_list_item_id_seq'), false, '', 50, false, 50, |
|
75 0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false); |
|
76 INSERT INTO code_list_item |
|
77 (code_list, id, i18n, name, rank, dflt, i1, |
|
78 i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted) |
|
79 VALUES |
|
80 ('task_state', nextval('code_list_item_id_seq'), false, '', 60, false, 60, |
|
81 0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false); |
|
82 INSERT INTO code_list_item |
|
83 (code_list, id, i18n, name, rank, dflt, i1, |
|
84 i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted) |
|
85 VALUES |
|
86 ('task_state', nextval('code_list_item_id_seq'), false, '', 70, false, 70, |
|
87 0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false); |
|
88 INSERT INTO code_list_item |
|
89 (code_list, id, i18n, name, rank, dflt, i1, |
|
90 i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted) |
|
91 VALUES |
|
92 ('task_state', nextval('code_list_item_id_seq'), false, '', 80, false, 80, |
|
93 0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false); |
|
94 INSERT INTO code_list_item |
|
95 (code_list, id, i18n, name, rank, dflt, i1, |
|
96 i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted) |
|
97 VALUES |
|
98 ('task_state', nextval('code_list_item_id_seq'), false, '', 90, false, 90, |
|
99 0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false); |
|
100 INSERT INTO code_list_item |
|
101 (code_list, id, i18n, name, rank, dflt, i1, |
|
102 i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted) |
|
103 VALUES |
|
104 ('task_state', nextval('code_list_item_id_seq'), false, '', 100, false, 100, |
|
105 0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false); |
|
106 |
|
107 -- Task types |
|
108 INSERT INTO code_list_item |
|
109 (code_list, id, i18n, name, rank, dflt, i1, |
|
110 i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted) |
|
111 VALUES |
|
112 ('task_type', nextval('code_list_item_id_seq'), true, 'Task type 1', 1, false, 0, |
|
113 0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false); |
|
114 INSERT INTO code_list_item |
|
115 (code_list, id, i18n, name, rank, dflt, i1, |
|
116 i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted) |
|
117 VALUES |
|
118 ('task_type', nextval('code_list_item_id_seq'), true, 'Task type 2', 2, false, 0, |
|
119 0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false); |
|
120 |
|
121 -- Company status |
|
122 INSERT INTO code_list_item |
|
123 (code_list, id, i18n, name, rank, dflt, i1, |
|
124 i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted) |
|
125 VALUES |
|
126 ('company_status', nextval('code_list_item_id_seq'), true, 'company.status.active', 10, true, 0, |
|
127 0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false); |
|
128 INSERT INTO code_list_item |
|
129 (code_list, id, i18n, name, rank, dflt, i1, |
|
130 i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted) |
|
131 VALUES |
|
132 ('company_status', nextval('code_list_item_id_seq'), true, 'company.status.potencial', 20, false, 0, |
|
133 0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false); |
|
134 INSERT INTO code_list_item |
|
135 (code_list, id, i18n, name, rank, dflt, i1, |
|
136 i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted) |
|
137 VALUES |
|
138 ('company_status', nextval('code_list_item_id_seq'), true, 'company.status.inactive', 30, false, 0, |
|
139 0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false); |