SQLite format 3@ <$d.<34$ p‡&AA :lProfile2018-11-22 02:35:31.2683862018-11-22 02:35:31.268386USDUSDUSDUSDUSDUSD:llfAA :lProfile2018-11-22 02:35:31.2683862018-11-22 02:35:31.268386USDUSDUSDUSDUSDUSDpӲrAA :lProfile2018-11-22 02:35:31.2683862018-11-22 02:35:31.268386USDUSDUSDUSDUSDUSD:l lL4profiles:l 1billing_tax_groups:l /billing_operators:l -billing_profiles:l /billing_modifiers:l 3billing_departments:l+billing_charges:l;billing_receipt_configs:l/billing_resources:l'billing_bills:l-billing_payments:l%billing_plus:l+billing_origins:l7billing_payment_types:l Profile:l$pProfile:lʊfProfile:l:l $pʊf:l  :l$pʊf :l:l $pʊf:l QQRfAA:lUSD2018-11-22 02:35:31.2762502018-11-22 02:35:31.276250USDQӲrAA:ldUSD2018-11-22 02:35:31.2762502018-11-22 02:35:31.276250USD  :lʊf :l:l ʊf:l ʊf:l ʊf:l ʊf:l bbIf AAGroup2ʊf2018-11-22 02:35:31.2789062018-11-22 02:35:31.278906IӲr AAGroup1:l2018-11-22 02:35:31.2789062018-11-22 02:35:31.278906 ʊf:l  ʊfʊf :l:l eeJf AA:l:l2018-11-22 02:35:31.2806212018-11-22 02:35:31.280621dUSDEӲr  AA:l2018-11-22 02:35:31.2806212018-11-22 02:35:31.280621USD @<@ <<<<<<<<<<Mc}77e\++tablebilling_origi''?tablebilling_billsbilling_billsCREATE TABLE "billing_bills" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "billable_id" integer, "billable_type" varchar, "created_at" datetime, "updated_at" datetime, "charges_sum_cents" integer DEFAULT 0 NOT NULL, "charges_sum_currency" varchar DEFAULT 'USD' NOT NULL, "discounts_sum_cents" integer DEFAULT 0 NOT NULL, "discounts_sum_currency" varchar DEFAULT 'USD' NOT NULL, "payments_sum_cents" integer DEFAULT 0 NOT NULL, "payments_sum_currency" varchar DEFAULT 'USD' NOT NULL, "total_cents" integer DEFAULT 0 NOT NULL, "total_currency" varchar DEFAULT 'USD' NOT NULL, "balance_cents" integer DEFAULT 0 NOT NULL, "balance_currency" varchar DEFAULT 'USD' NOT NULL, "surcharges_sum_cents" integer DEFAULT 0 NOT NULL, "surcharges_sum_currency" varchar DEFAULT 'USD' NOT NULL, "origin_id" integer, "extface_job_id" integer, "report_id" integer, "autofin" boolean DEFAULT 1, "finalized_at" datetime, "name" varchar, "number" varchar, "deleted_at" datetime, "print_job_id" integer)ZGF[5indexsqlite_autoindex_ar_internal_metadata_1ar_internal_metadata;NE55?tablear_internal_metadataar_internal_metadataCREATE TABLE "ar_internal_metadata" ("key" varchar NOT NULL PRIMARY KEY, "value" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)4=//indexunique_schema_migrationsschema_migrations9CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")l3//tableschema_migrationsschema_migrations8CREATE TABLE "schema_migrations" ("version" varchar NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq) 7 ~ > >%vgO4$c9Yindexindex_billing_op_fp_mappings_on_operator_idbilling_op_fp_mappingsCREATE INDEX "index_billing_op_fp_mappings_on_operator_id" ON "billing_op_fp_mappings" ("operator_id")F#o9qindexindex_billing_op_fp_mappings_on_extface_driver_idbilling_op_fp_mappingsCREATE INDEX "index_billing_op_fp_mappings_on_extface_driver_id" ON "billing_op_fp_mappings" ("extface_driver_id")"99Ctablebilling_op_fp_mappingsbilling_op_fp_mappingsCREATE TABLE "billing_op_fp_mappings" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "operator_id" integer, "extface_driver_id" integer, "mapping" integer, "created_at" datetime, "updated_at" datetime, "pwd" varchar)!Q/5indexindex_billing_modifiers_on_bill_idbilling_modifiers:CREATE INDEX "index_billing_modifiers_on_bill_id" ON "billing_modifiers" ("bill_id")s //tablebilling_modifiersbilling_modifiersCREATE TABLE "billing_modifiers" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "bill_id" integer, "charge_id" integer, "percent_ratio" decimal(6,3), "created_at" datetime, "updated_at" datetime, "fixed_value_cents" integer DEFAULT 0 NOT NULL, "fixed_value_currency" varchar DEFAULT 'USD' NOT NULL, "deleted_at" datetime)+_3Qindexindex_billing_departments_on_tax_group_idbilling_departmentsCREATE INDEX "index_billing_departments_on_tax_group_id" ON "billing_departments" ("tax_group_id")%[3Iindexindex_billing_departments_on_deleted_atbilling_departmentsCREATE INDEX "index_billing_departments_on_deleted_at" ON "billing_departments" ("deleted_at")=33!tablebilling_departmentsbilling_departmentsCREATE TABLE "billing_departments" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "master_id" integer, "name" varchar, "tax_group_id" integer, "type" varchar, "created_at" datetime, "updated_at" datetime, "number" integer, "banned" boolean, "deleted_at" datetime)S+9indexindex_billing_charges_on_revenue_atbilling_charges CREATE INDEX "index_billing_charges_on_revenue_at" ON "billing_charges" ("revenue_at")Q+5indexindex_billing_charges_on_origin_idbilling_charges CREATE INDEX "index_billing_charges_on_origin_id" ON "billing_charges" ("origin_id")S+9indexindex_billing_charges_on_deleted_atbilling_charges CREATE INDEX "index_billing_charges_on_deleted_at" ON "billing_charges" ("deleted_at")S}+ indexindex_billing_charges_on_chargable_type_and_chargable_idbilling_charges CREATE INDEX "index_billing_charges_on_chargable_type_and_chargable_id" ON "billing_charges" ("chargable_type", "chargable_id") M+-indexindex_billing_charges_on_bill_idbilling_charges CREATE INDEX "index_billing_charges_on_bill_id" ON "billing_charges" ("bill_id")<++/tablebilling_chargesbilling_chargesCREATE TABLE "billing_charges" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "bill_id" integer, "chargable_id" integer, "chargable_type" varchar, "price_cents" integer DEFAULT 0 NOT NULL, "price_currency" varchar DEFAULT 'USD' NOT NULL, "created_at" datetime, "updated_at" datetime, "name" varchar, "description" varchar, "origin_id" integer, "value_cents" integer DEFAULT 0 NOT NULL, "value_currency" varchar DEFAULT 'USD' NOT NULL, "deleted_at" datetime, "revenue_at" datetime, "qty" decimal(6,3), "tax_ratio" decimal(6,3)) M'-indexindex_billing_bills_on_report_idbilling_billsCREATE INDEX "index_billing_bills_on_report_id" ON "billing_bills" ("report_id") M'-indexindex_billing_bills_on_origin_idbilling_billsCREATE INDEX "index_billing_bills_on_origin_id" ON "billing_bills" ("origin_id")W'Aindexindex_billing_bills_on_extface_job_idbilling_billsCREATE INDEX "index_billing_bills_on_extface_job_id" ON "billing_bills" ("extface_job_id")Eu'{indexindex_billing_bills_on_billable_type_and_billable_idbilling_billsCREATE INDEX "index_billing_bills_on_billable_type_and_billable_id" ON "billing_bills" ("billable_type", "billable_id") hhFf AAMyString2018-11-22 02:35:31.2832772018-11-22 02:35:31.283277FӲr AAMyString2018-11-22 02:35:31.2832772018-11-22 02:35:31.283277    ʊf:l H#AAenvironmenttest2018-11-15 00:46:01.2896782018-11-15 00:46:01.289678 ,,dfAA=MyString2018-11-22 02:35:31.2610182018-11-22 02:35:31.261018Billing::PaymentWithTypedӲrAA=MyString2018-11-22 02:35:31.2610182018-11-22 02:35:31.261018Billing::PaymentWithType ʊf:l ʊf:l ʊf:l ʊf:l bEұS  AACard2018-11-22 02:35:31.2598842018-11-22 02:35:31.259884GѪI  AAFiscal2018-11-22 02:35:31.2598842018-11-22 02:35:31.259884E9  AACash2018-11-22 02:35:31.2598842018-11-22 02:35:31.259884If AAMyString2018-11-22 02:35:31.2598842018-11-22 02:35:31.259884IӲr AAMyString2018-11-22 02:35:31.2598842018-11-22 02:35:31.259884 0UIʊf:l %%hfAA=:lUSD2018-11-22 02:35:31.2646892018-11-22 02:35:31.264689Billing::PaymentWithType:lgӲrAA=:ldUSD2018-11-22 02:35:31.2646892018-11-22 02:35:31.264689Billing::PaymentWithType:l  :lʊf :l:l ʊf:l751 XXNfAAMyString2018-11-22 02:35:31.2628922018-11-22 02:35:31.262892USDNӲrAAMyString2018-11-22 02:35:31.2628922018-11-22 02:35:31.262892USD ʊf:l ʊf:l rrAfAAMyString2018-11-22 02:35:31.2821552018-11-22 02:35:31.282155AӲrAAMyString2018-11-22 02:35:31.2821552018-11-22 02:35:31.282155    @@Zf AAMyStringMyStringMyString2018-11-22 02:35:31.2732142018-11-22 02:35:31.273214ZӲr AAMyStringMyStringMyString2018-11-22 02:35:31.2732142018-11-22 02:35:31.273214   \\Lf AAMyStringMyText2018-11-22 02:35:31.2714322018-11-22 02:35:31.271432LӲr AAMyStringMyText2018-11-22 02:35:31.2714322018-11-22 02:35:31.271432 ffGf AAMyString2018-11-22 02:35:31.2847392018-11-22 02:35:31.284739GӲr AAMyString2018-11-22 02:35:31.2847392018-11-22 02:35:31.284739    < S  a IA^ 4,1%%tablebilling_plusbilling_plus%CREATE TABLE "bi<4--+tablebilling_profilesbilling_profiles(CREATE TABLE "billing_profiles" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime, "updated_at" datetime)3Q%5indexindex_billing_plus_on_tax_group_idbilling_plus'CREATE INDEX "index_billing_plus_on_tax_group_id" ON "billing_plus" ("tax_group_id")2S%9indexindex_billing_plus_on_department_idbilling_plus&CREATE INDEX "index_billing_plus_on_department_id" ON "billing_plus" ("department_id"),1%%tablebilling_plusbilling_plus%CREATE TABLE "billing_plus" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime, "updated_at" datetime, "master_id" integer, "tax_group_id" integer, "department_id" integer, "number" integer, "price_cents" integer DEFAULT 0 NOT NULL, "price_currency" varchar DEFAULT 'USD' NOT NULL, "code" varchar, "type" varchar, "banned" boolean, "deleted_at" datetime)0U-=indexindex_billing_payments_on_deleted_atbilling_payments#CREATE INDEX "index_billing_payments_on_deleted_at" ON "billing_payments" ("deleted_at")/O-1indexindex_billing_payments_on_bill_idbilling_payments"CREATE INDEX "index_billing_payments_on_bill_id" ON "billing_payments" ("bill_id")?.--1tablebilling_paymentsbilling_payments!CREATE TABLE "billing_payments" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "bill_id" integer, "value_cents" integer DEFAULT 0 NOT NULL, "value_currency" varchar DEFAULT 'USD' NOT NULL, "created_at" datetime, "updated_at" datetime, "type" varchar, "payment_type_id" integer, "status" varchar, "name" varchar, "description" varchar, "external_token" varchar, "note" varchar, "deleted_at" datetime)--_7Qindexindex_billing_payment_types_on_deleted_atbilling_payment_types CREATE INDEX "index_billing_payment_types_on_deleted_at" ON "billing_payment_types" ("deleted_at")c,77etablebilling_payment_typesbilling_payment_typesCREATE TABLE "billing_payment_types" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "cash" boolean, "fiscal" boolean, "created_at" datetime, "updated_at" datetime, "type" varchar, "master_id" integer, "number" integer, "banned" boolean, "deleted_at" datetime, "print_copy" boolean)-+c+Yindexindex_billing_origins_on_transfer_device_idbilling_originsCREATE INDEX "index_billing_origins_on_transfer_device_id" ON "billing_origins" ("transfer_device_id")**a+Uindexindex_billing_origins_on_receipt_config_idbilling_originsCREATE INDEX "index_billing_origins_on_receipt_config_id" ON "billing_origins" ("receipt_config_id")')_+Qindexindex_billing_origins_on_fiscal_device_idbilling_originsCREATE INDEX "index_billing_origins_on_fiscal_device_id" ON "billing_origins" ("fiscal_device_id")(S+9indexindex_billing_origins_on_deleted_atbilling_originsCREATE INDEX "index_billing_origins_on_deleted_at" ON "billing_origins" ("deleted_at")e'++tablebilling_originsbilling_originsCREATE TABLE "billing_origins" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime, "updated_at" datetime, "master_id" integer, "fiscal_device_id" integer, "banned" boolean, "deleted_at" datetime, "type" varchar, "payment_model" varchar DEFAULT 'Billing::PaymentWithType', "transfer_device_id" integer, "print_device_id" integer, "print_header" varchar, "print_footer" varchar, "receipt_config_id" integer)&W/Aindexindex_billing_operators_on_deleted_atbilling_operatorsCREATE INDEX "index_billing_operators_on_deleted_at" ON "billing_operators" ("deleted_at")%//mtablebilling_operatorsbilling_operatorsCREATE TABLE "billing_operators" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "master_id" integer, "name" varchar, "type" varchar, "created_at" datetime, "updated_at" datetime, "number" integer, "banned" boolean, "deleted_at" datetime)    8ӲrAA2018-11-22 02:35:31.2862142018-11-22 02:35:31.286214 @ p^L:(tbP>, x f T B 0  | j X F 4 "  @)20141221201539?)20141027235427>)20160831231640=)20140728110230<)20150510235441;)20140718210349:)201407251229149)201407171831298)201407251532157)201607232342336)201505101422295)201407190944184)201407261657183)201407251503292)201408040657261)201407251536580)20140725145640/)20160828145106.)20140720110811-)20140722160902,)20150512040421+)20140725143734*)20140729182146))20140717181134()20140803073707')20140725145953&)20140721173106%)20140719094033$)20140729083408#)20150311013019")20140722162315!)20141221233912 )20140725152125)20140720132559)20160824235224)20140724173527)20140726170002)20140717180443)20140804070517)20140719103621)20140721172932)20140717202527)20140724173917)20160723160908)20140719094023)20141229234928)20140729083050)20140717181406)20140719110412)20140722160529)20140729180849 )20141001185321 )20160828145448 )20140725164847 )20140726163220 )20140725151522)20140725142525)20140722161743)20140722160258)20140718212116)20140718164841)20140722160242)20140718104656)20170329013520 @ A  L  B & 9 / | { _ i q  8V ^0C % z U K T A  h r  g)20141221201539@)20141027235427?)20160831231640>)20140728110230=)20150510235441<)20140718210349;)20140725122914:)201407171831299)201407251532158)201607232342337)201505101422296)201407190944185)201407261657184)201407251503293)201408040657262)201407251536581)201407251456400)20160828145106/)20140720110811.)20140722160902-)20150512040421,)20140725143734+)20140729182146*)20140717181134))20140803073707()20140725145953')20140721173106&)20140719094033%)20140729083408$)20150311013019#)20140722162315")20141221233912!)20140725152125 )20140720132559)20160824235224)20140724173527)20140726170002)20140717180443)20140804070517)20140719103621)20140721172932)20140717202527)20140724173917)20160723160908)20140719094023)20141229234928)20140729083050)20140717181406)20140719110412)20140722160529)20140729180849)20141001185321 )20160828145448 )20140725164847 )20140726163220 )20140725151522 )20140725142525)20140722161743)20140722160258)20140718212116)20140718164841)20140722160242)20140718104656) 20170329013520  :lʊf :l:l # environment + V9;, q +B{tableprofilesprofiles7CREATE TABLE "profiles" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime, "updated_at" datetime)t@--tablebilling_versionsbilling_versions5CREATE TABLE "billing_versions" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "item_type" varchar NOT NULL, "item_id" integer NOT NULL, "event" varchar NOT NULL, "whodunnit" varchar, "object" text, "created_at" datetime, "ip" varchar, "user_agent" varchar, "object_changes" text, "master_id" integer, "master_type" varchar)@<11+tablebilling_tax_groupsbilling_tax_groups0CREATE TABLE "billing_tax_groups" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime, "updated_at" datetime, "master_id" integer, "number" integer, "percent_ratio" decimal(6,3), "banned" boolean, "type" varchar, "deleted_at" datetime) ;//otablebilling_resourcesbilling_resources/CREATE TABLE "billing_resources" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "master_id" integer, "name" varchar, "properties" text, "banned" boolean, "type" varchar, "created_at" datetime, "updated_at" datetime, "deleted_at" datetime):Q+5indexindex_billing_reports_on_origin_idbilling_reports.CREATE INDEX "index_billing_reports_on_origin_id" ON "billing_reports" ("origin_id")9++itablebilling_reportsbilling_reports-CREATE TABLE "billing_reports" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "master_id" integer, "origin_id" integer, "payments_sum_cents" integer DEFAULT 0 NOT NULL, "payments_sum_currency" varchar DEFAULT 'USD' NOT NULL, "payments_cash_cents" integer DEFAULT 0 NOT NULL, "payments_cash_currency" varchar DEFAULT 'USD' NOT NULL, "payments_fiscal_cents" integer DEFAULT 0 NOT NULL, "payments_fiscal_currency" varchar DEFAULT 'USD' NOT NULL, "note" text, "type" varchar, "created_at" datetime, "updated_at" datetime, "extface_job_id" integer, "f_period_from" date, "f_period_to" date, "zeroing" boolean, "f_operation" varchar, "f_amount_cents" integer DEFAULT 0 NOT NULL, "f_amount_currency" varchar DEFAULT 'USD' NOT NULL, "deleted_at" datetime)?8;;tablebilling_receipt_configsbilling_receipt_configs,CREATE TABLE "billing_receipt_configs" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "master_id" integer, "type" varchar, "name" varchar, "discount_text" varchar, "surcharge_text" varchar, "sound_signal" boolean, "open_cash_drawer" boolean, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "paper_cut" boolean, "custom_commands" boolean, "custom_commands_text" varchar)@7k9iindexindex_billing_pt_fp_mappings_on_payment_type_idbilling_pt_fp_mappings+CREATE INDEX "index_billing_pt_fp_mappings_on_payment_type_id" ON "billing_pt_fp_mappings" ("payment_type_id")F6o9qindexindex_billing_pt_fp_mappings_on_extface_driver_idbilling_pt_fp_mappings*CREATE INDEX "index_billing_pt_fp_mappings_on_extface_driver_id" ON "billing_pt_fp_mappings" ("extface_driver_id") 599-tablebilling_pt_fp_mappingsbilling_pt_fp_mappings)CREATE TABLE "billing_pt_fp_mappings" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "payment_type_id" integer, "extface_driver_id" integer, "mapping" integer, "created_at" datetime, "updated_at" datetime)9Ak-gindexindex_billing_versions_on_item_type_and_item_idbilling_versions6CREATE INDEX "index_billing_versions_on_item_type_and_item_id" ON "billing_versions" ("item_type", "item_id")7?e9]indexindex_billing_tg_fp_mappings_on_tax_group_idbilling_tg_fp_mappings4CREATE INDEX "index_billing_tg_fp_mappings_on_tax_group_id" ON "billing_tg_fp_mappings" ("tax_group_id")F>o9qindexindex_billing_tg_fp_mappings_on_extface_driver_idbilling_tg_fp_mappings2CREATE INDEX "index_billing_tg_fp_mappings_on_extface_driver_id" ON "billing_tg_fp_mappings" ("extface_driver_id")=99'tablebilling_tg_fp_mappingsbilling_tg_fp_mappings1CREATE TABLE "billing_tg_fp_mappings" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "tax_group_id" integer, "extface_driver_id" integer, "mapping" integer, "created_at" datetime, "updated_at" datetime)