src/main/resources/db/db-data.sql
changeset 99 49eb72a46208
parent 92 eb207b189332
child 104 ef29ecada49d
equal deleted inserted replaced
98:eac38214183d 99:49eb72a46208
   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