135 (code_list, id, i18n, name, rank, dflt, i1, |
135 (code_list, id, i18n, name, rank, dflt, i1, |
136 i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted) |
136 i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted) |
137 VALUES |
137 VALUES |
138 ('company_status', nextval('code_list_item_id_seq'), true, 'company.status.inactive', 30, false, 0, |
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); |
139 0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false); |
|
140 |
|
141 -- Service state |
|
142 INSERT INTO code_list_item |
|
143 (code_list, id, i18n, name, rank, dflt, i1, |
|
144 i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted) |
|
145 VALUES |
|
146 ('service_state', nextval('code_list_item_id_seq'), true, 'service.state.init', 10, true, 0, |
|
147 0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false); |
|
148 INSERT INTO code_list_item |
|
149 (code_list, id, i18n, name, rank, dflt, i1, |
|
150 i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted) |
|
151 VALUES |
|
152 ('service_state', nextval('code_list_item_id_seq'), true, 'service.state.active', 20, false, 0, |
|
153 0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false); |
|
154 INSERT INTO code_list_item |
|
155 (code_list, id, i18n, name, rank, dflt, i1, |
|
156 i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted) |
|
157 VALUES |
|
158 ('service_state', nextval('code_list_item_id_seq'), true, 'service.state.terminated', 30, false, 0, |
|
159 0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false); |
|
160 |
|
161 -- Currency |
|
162 INSERT INTO code_list_item |
|
163 (code_list, id, i18n, name, rank, dflt, i1, |
|
164 i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted) |
|
165 VALUES |
|
166 ('currency', nextval('code_list_item_id_seq'), false, 'CZK', 10, true, 0, |
|
167 0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false); |
|
168 INSERT INTO code_list_item |
|
169 (code_list, id, i18n, name, rank, dflt, i1, |
|
170 i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted) |
|
171 VALUES |
|
172 ('currency', nextval('code_list_item_id_seq'), false, 'EUR', 20, false, 0, |
|
173 0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false); |
|
174 INSERT INTO code_list_item |
|
175 (code_list, id, i18n, name, rank, dflt, i1, |
|
176 i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted) |
|
177 VALUES |
|
178 ('currency', nextval('code_list_item_id_seq'), false, 'USD', 30, false, 0, |
|
179 0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false); |
|
180 |
|
181 -- Payment period |
|
182 INSERT INTO code_list_item |
|
183 (code_list, id, i18n, name, rank, dflt, i1, |
|
184 i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted) |
|
185 VALUES |
|
186 ('payment_period', nextval('code_list_item_id_seq'), true, 'payment.period.initial', 10, true, 0, |
|
187 0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false); |
|
188 INSERT INTO code_list_item |
|
189 (code_list, id, i18n, name, rank, dflt, i1, |
|
190 i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted) |
|
191 VALUES |
|
192 ('payment_period', nextval('code_list_item_id_seq'), true, 'payment.period.monthly', 20, false, 12, |
|
193 0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false); |
|
194 INSERT INTO code_list_item |
|
195 (code_list, id, i18n, name, rank, dflt, i1, |
|
196 i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted) |
|
197 VALUES |
|
198 ('payment_period', nextval('code_list_item_id_seq'), true, 'payment.period.quarterly', 30, false, 4, |
|
199 0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false); |
|
200 INSERT INTO code_list_item |
|
201 (code_list, id, i18n, name, rank, dflt, i1, |
|
202 i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted) |
|
203 VALUES |
|
204 ('payment_period', nextval('code_list_item_id_seq'), true, 'payment.period.semiannually', 40, false, 2, |
|
205 0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false); |
|
206 INSERT INTO code_list_item |
|
207 (code_list, id, i18n, name, rank, dflt, i1, |
|
208 i2, i3, l1, l2, l3, s1, s2, s3, created_at, updated_at, deleted) |
|
209 VALUES |
|
210 ('payment_period', nextval('code_list_item_id_seq'), true, 'payment.period.annually', 50, false, 1, |
|
211 0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false); |
|
212 |