diff -r eac38214183d -r 49eb72a46208 src/main/resources/db/db-data.sql --- a/src/main/resources/db/db-data.sql Wed May 09 22:53:03 2012 +0200 +++ b/src/main/resources/db/db-data.sql Thu May 24 11:19:26 2012 +0200 @@ -137,3 +137,76 @@ VALUES ('company_status', nextval('code_list_item_id_seq'), true, 'company.status.inactive', 30, false, 0, 0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false); + +-- Service state +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 +('service_state', nextval('code_list_item_id_seq'), true, 'service.state.init', 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 +('service_state', nextval('code_list_item_id_seq'), true, 'service.state.active', 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 +('service_state', nextval('code_list_item_id_seq'), true, 'service.state.terminated', 30, false, 0, +0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false); + +-- Currency +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 +('currency', nextval('code_list_item_id_seq'), false, 'CZK', 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 +('currency', nextval('code_list_item_id_seq'), false, 'EUR', 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 +('currency', nextval('code_list_item_id_seq'), false, 'USD', 30, false, 0, +0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false); + +-- Payment period +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 +('payment_period', nextval('code_list_item_id_seq'), true, 'payment.period.initial', 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 +('payment_period', nextval('code_list_item_id_seq'), true, 'payment.period.monthly', 20, false, 12, +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 +('payment_period', nextval('code_list_item_id_seq'), true, 'payment.period.quarterly', 30, false, 4, +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 +('payment_period', nextval('code_list_item_id_seq'), true, 'payment.period.semiannually', 40, false, 2, +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 +('payment_period', nextval('code_list_item_id_seq'), true, 'payment.period.annually', 50, false, 1, +0, 0, 0, 0, 0, '', '', '', current_timestamp, current_timestamp, false); +