SQLite format 3@ .bA;,.b-A@ ? =<>7 :9645Y 66]f33:lProfile2014-07-29 08:45:202014-07-29 08:45:20USDUSDUSDUSDUSDUSDtaӲr33:lProfile2014-07-29 08:45:202014-07-29 08:45:20USDUSDUSDUSDUSDUSD:lt gK1profiles:l1billing_tax_groups:l-billing_accounts:l/billing_operators:l -billing_profiles:l /billing_modifiers:l 3billing_departments:l +billing_charges:l/billing_discounts:l -billing_payments:l%billing_plus:l+billing_origins:l7billing_payment_types:l GP++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)q //tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) =//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")/Z qqBf33:lUSD2014-07-29 08:45:202014-07-29 08:45:20USDAӲr33:ldUSD2014-07-29 08:45:202014-07-29 08:45:20USD 0ggd\//wtablebilling_discountsbilling_discountsCREATE TABLE "billing_discounts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "account_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(255) DEFAULT 'USD' NOT NULL)]W/Aindexindex_billing_discounts_on_account_idbilling_discounts CREATE INDEX "index_billing_discounts_on_account_id" ON "billing_discounts" ("account_id")/  :lʊf :l:l 6f 33:l2014-07-19 08:18:512014-07-19 08:18:51USD6Ӳr 33:l2014-07-19 08:18:512014-07-19 08:18:51USD AAZf33=:lUSD2014-07-29 08:45:202014-07-29 08:45:20Billing::PaymentWithType:lYӲr33=:ldUSD2014-07-29 08:45:202014-07-29 08:45:20Billing::PaymentWithType:l ;f 33:l:l2014-07-29 08:45:202014-07-29 08:45:20dUSD6Ӳr  33:l2014-07-29 08:45:202014-07-29 08:45:20USD f=---tablebilling_closuresbilling_closuresCREATE TABLE "billing_closures" ("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(255) DEFAULT 'USD' NOT NULL, "payments_cash_cents" integer DEFAULT 0 NOT NULL, "payments_cash_currency" varchar(255) DEFAULT 'USD' NOT NULL, "payments_fiscal_cents" integer DEFAULT 0 NOT NULL, "payments_fiscal_currency" varchar(255) DEFAULT 'USD' NOT NULL, "note" text, "type" varchar(255), "created_at" datetime, "updated_at" datetime, "extface_job_id" integer, "f_period_from" date, "f_period_to" date, "zeroing" boolean, "f_operation" varchar(255))S-9indexindex_billing_closures_on_origin_idbilling_closures*CREATE INDEX "index_billing_closures_on_origin_id" ON "billing_closures" ("origin_id")  :lʊf :l:l :lProfileʊf:lProfile:l tt@f33MyString2014-07-29 08:45:202014-07-29 08:45:20USD@Ӳr33MyString2014-07-29 08:45:202014-07-29 08:45:20USD +p^L:(tbP>,xfTB0 +)20140729083050*)20140729083408))20140728110230()20140726165718')20140726163220&)20140726170002%)20140725153215$)20140725150329#)20140725153658")20140725145640!)20140725143734 )20140725145953)20140725152125)20140725151522)20140725142525)20140725164847)20140725122914)20140722160902)20140722162315)20140724173527)20140722160529)20140722161743)20140722160258)20140722160242)20140724173917)20140721172932)20140721173106)20140720110811)20140720132559)20140719094418 )20140719094033 )20140719103621 )20140719094023 )20140719110412 )20140718210349)20140718212116)20140718164841)20140718104656)20140717202527)20140717181134)20140717180443)20140717181406)20140717183129 +|Vi0 CrL_&9{UBh /)20140729083050+)20140729083408*)20140728110230))20140726165718()20140726163220')20140726170002&)20140725153215%)20140725150329$)20140725153658#)20140725145640")20140725143734!)20140725145953 )20140725152125)20140725151522)20140725142525)20140725164847)20140725122914)20140722160902)20140722162315)20140724173527)20140722160529)20140722161743)20140722160258)20140722160242)20140724173917)20140721172932)20140721173106)20140720110811)20140720132559)20140719094418)20140719094033 )20140719103621 )20140719094023 )20140719110412 )20140718210349 )20140718212116)20140718164841)20140718104656)20140717202527)20140717181134)20140717180443)20140717181406) 20140717183129 RRQf 33=MyString2014-07-29 08:45:202014-07-29 08:45:20Billing::PaymentWithTypeQӲr 33=MyString2014-07-29 08:45:202014-07-29 08:45:20Billing::PaymentWithType *Ӳr332014-07-29 08:45:202014-07-29 08:45:20 ʊf:l ʊf:l <z9ұS 33Cardft2014-07-29 08:45:202014-07-29 08:45:20;ѪI 33Fiscaltt2014-07-29 08:45:202014-07-29 08:45:2099 33Cashtf2014-07-29 08:45:202014-07-29 08:45:20=f 33MyStringff2014-07-29 08:45:202014-07-29 08:45:20=Ӳr 33MyStringff2014-07-29 08:45:202014-07-29 08:45:20 ~~;f 33Group2ʊf2014-07-29 08:45:202014-07-29 08:45:20;Ӳr 33Group1:l2014-07-29 08:45:202014-07-29 08:45:20 9f 33MyString2014-07-29 08:45:202014-07-29 08:45:209Ӳr 33MyString2014-07-29 08:45:202014-07-29 08:45:20 ʊf:l  3f33MyString2014-07-29 08:45:202014-07-29 08:45:203Ӳr33MyString2014-07-29 08:45:202014-07-29 08:45:20 ʊf:l ʊf:l ʊf:l  8f 33MyString2014-07-29 08:45:202014-07-29 08:45:208Ӳr 33MyString2014-07-29 08:45:202014-07-29 08:45:20  ʊfʊf :l:l  ʊf:l    ʊf:l  :lʊf :l:l  0UIʊf:l   ʊf:l ʊf:l ʊf :l:l ʊf:l ʊf:lAUTOINCREMENT NOT NULL, "billable_id" integer, "billable_type" varchar(255), "created_at" datetime, "updated_at" datetime, "charges_sum_cents" integer DEFAULT 0 NOT NULL, "charges_sum_currency" varchar(255) DEFAULT 'USD' NOT NULL, "discounts_sum_cents" integer DEFAULT 0 NOT NULL, "discounts_sum_currency" varchar(255) DEFAULT 'USD' NOT NULL, "payments_sum_cents" integer DEFAULT 0 NOT NULL, "payments_sum_currency" varchar(255) DEFAULT 'USD' NOT NULL, "total_cents" integer DEFAULT 0 NOT NULL, "total_currency" varchar(255) DEFAULT 'USD' NOT NULL, "balance_cents" integer DEFAULT 0 NOT NULL, "balance_currency" varchar(255) DEFAULT 'USD' NOT NULL, "surcharges_sum_cents" integer DEFAULT 0 NOT NULL, "surcharges_sum_currency" varchar(255) DEFAULT 'USD' NOT NULL, "origin_id" integer, "extface_job_id" integer, "report_id" integer, "autofin" boolean DEFAULT 't', "finalized_at" datetime, "name" varchar(255), "number" varchar(255)) ʊf:l N#f |--Etablebilling_accountsbilling_accountsCREATE TABLE "billing_accounts" ("id" INTEGER PRIMARY KEY 1Q}{-indexindex_billing_accounts_on_billable_id_and_billable_typebilling_accounts CREATE INDEX "index_billing_accounts_on_billable_id_and_billable_type" ON "billing_accounts" ("billable_id", "billable_type")%~]-Mindexindex_billing_accounts_on_extface_job_idbilling_accounts"CREATE INDEX "index_billing_accounts_on_extface_job_id" ON "billing_accounts" ("extface_job_id")S-9indexindex_billing_accounts_on_origin_idbilling_accounts.CREATE INDEX "index_billing_accounts_on_origin_id" ON "billing_accounts" ("origin_id")S-9indexindex_billing_accounts_on_report_idbilling_accounts/CREATE INDEX "index_billing_accounts_on_report_id" ON "billing_accounts" ("report_id") NN;@%%Ctablebilling_plusbilling_plusCREATE TABLE "billing_plus" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "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(255) DEFAULT 'USD' NOT NULL, "code" varchar(255), "type" varchar(255), "banned" boolean, "deleted_at" datetime)S%9indexindex_billing_plus_on_department_idbilling_plusCREATE INDEX "index_billing_plus_on_department_id" ON "billing_plus" ("department_id")Q%5indexindex_billing_plus_on_tax_group_idbilling_plusCREATE INDEX "index_billing_plus_on_tax_group_id" ON "billing_plus" ("tax_group_id")A--5tablebilling_profilesbilling_profilesCREATE TABLE "billing_profiles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime, "updated_at" datetime) JU W/Aindexindex_billing_operators_on_deleted_atbilling_operators0CREATE INDEX "index_billing_operators_on_deleted_at" ON "billing_operators" ("deleted_at")n++tablebilling_originsbilling_originsCREATE TABLE "billing_origins" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime, "updated_at" datetime, "master_id" integer, "fiscal_device_id" integer, "banned" boolean, "deleted_at" datetime, "type" varchar(255), "payment_model" varchar(255) DEFAULT 'Billing::PaymentWithType')S+9indexindex_billing_origins_on_deleted_atbilling_origins&CREATE INDEX "index_billing_origins_on_deleted_at" ON "billing_origins" ("deleted_at")'_+Qindexindex_billing_origins_on_fiscal_device_idbilling_origins,CREATE INDEX "index_billing_origins_on_fiscal_device_id" ON "billing_origins" ("fiscal_device_id") 2+ _3Qindexindex_billing_departments_on_tax_group_idbilling_departments CREATE INDEX "index_billing_departments_on_tax_group_id" ON "billing_departments" ("tax_group_id")d //wtablebilling_modifiersbilling_modifiers CREATE TABLE "billing_modifiers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "account_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(255) DEFAULT 'USD' NOT NULL) W/Aindexindex_billing_modifiers_on_account_idbilling_modifiers8CREATE INDEX "index_billing_modifiers_on_account_id" ON "billing_modifiers" ("account_id")) //tablebilling_operatorsbilling_operatorsCREATE TABLE "billing_operators" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "master_id" integer, "name" varchar(255), "type" varchar(255), "created_at" datetime, "updated_at" datetime, "number" integer, "banned" boolean, "deleted_at" datetime)  :lʊf :l:l Om77ytablebilling_payment_typesbilling_payment_typesCREATE TABLE "billing_payment_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "cash" boolean, "fiscal" boolean, "created_at" datetime, "updated_at" datetime, "type" varchar(255), "master_id" integer, "number" integer, "banned" boolean, "deleted_at" datetime, "print_copy" boolean)-_7Qindexindex_billing_payment_types_on_deleted_atbilling_payment_types)CREATE INDEX "index_billing_payment_types_on_deleted_at" ON "billing_payment_types" ("deleted_at") eer< 99-tablebilling_pt_fp_mappingsbilling_pt_fp_mappingsCREATE 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)Fo9qindexindex_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")@k9iindexindex_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")2:%! bb)*++ tablebilling_chargesbilling_chargesCREATE TABLE "billing_charges" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "account_id" integer, "chargable_id" integer, "chargable_type" varchar(255), "price_cents" integer DEFAULT 0 NOT NULL, "price_currency" varchar(255) DEFAULT 'USD' NOT NULL, "created_at" datetime, "updated_at" datetime, "name" varchar(255), "description" varchar(255), "origin_id" integer, "value_cents" integer DEFAULT 0 NOT NULL, "value_currency" varchar(255) DEFAULT 'USD' NOT NULL, "deleted_at" datetime, "revenue_at" datetime)S+9indexindex_billing_charges_on_account_idbilling_chargesCREATE INDEX "index_billing_charges_on_account_id" ON "billing_charges" ("account_id")S}+ indexindex_billing_charges_on_chargable_id_and_chargable_typebilling_chargesCREATE INDEX "index_billing_charges_on_chargable_id_and_chargable_type" ON "billing_charges" ("chargable_id", "chargable_type") DDs WS+9indexindex_billing_charges_on_deleted_atbilling_chargesCREATE INDEX "index_billing_charges_on_deleted_at" ON "billing_charges" ("deleted_at")Q+5indexindex_billing_charges_on_origin_idbilling_chargesCREATE INDEX "index_billing_charges_on_origin_id" ON "billing_charges" ("origin_id")S+9indexindex_billing_charges_on_revenue_atbilling_charges3CREATE INDEX "index_billing_charges_on_revenue_at" ON "billing_charges" ("revenue_at")G335tablebilling_departmentsbilling_departmentsCREATE TABLE "billing_departments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "master_id" integer, "name" varchar(255), "tax_group_id" integer, "type" varchar(255), "created_at" datetime, "updated_at" datetime, "number" integer, "banned" boolean, "deleted_at" datetime)%[3Iindexindex_billing_departments_on_deleted_atbilling_departmentsCREATE INDEX "index_billing_departments_on_deleted_at" ON "billing_departments" ("deleted_at") ce--}tablebilling_paymentsbilling_payments CREATE TABLE "billing_payments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "account_id" integer, "value_cents" integer DEFAULT 0 NOT NULL, "value_currency" varchar(255) DEFAULT 'USD' NOT NULL, "created_at" datetime, "updated_at" datetime, "type" varchar(255), "payment_type_id" integer, "status" varchar(255), "name" varchar(255), "description" varchar(255), "external_token" varchar(255), "note" varchar(255), "deleted_at" datetime)U-=indexindex_billing_payments_on_account_idbilling_payments'CREATE INDEX "index_billing_payments_on_account_id" ON "billing_payments" ("account_id")U-=indexindex_billing_payments_on_deleted_atbilling_payments-CREATE INDEX "index_billing_payments_on_deleted_at" ON "billing_payments" ("deleted_at") j:+++tablebilling_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(255) DEFAULT 'USD' NOT NULL, "payments_cash_cents" integer DEFAULT 0 NOT NULL, "payments_cash_currency" varchar(255) DEFAULT 'USD' NOT NULL, "payments_fiscal_cents" integer DEFAULT 0 NOT NULL, "payments_fiscal_currency" varchar(255) DEFAULT 'USD' NOT NULL, "note" text, "type" varchar(255), "created_at" datetime, "updated_at" datetime, "extface_job_id" integer, "f_period_from" date, "f_period_to" date, "zeroing" boolean, "f_operation" varchar(255))Q+5indexindex_billing_reports_on_origin_idbilling_reports%CREATE INDEX "index_billing_reports_on_origin_id" ON "billing_reports" ("origin_id") ddJ11?tablebilling_tax_groupsbilling_tax_groupsCREATE TABLE "billing_tax_groups" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime, "updated_at" datetime, "master_id" integer, "number" integer, "percent_ratio" decimal(6,3), "banned" boolean, "type" varchar(255), "deleted_at" datetime)J --Gtablebilling_versionsbilling_versions$CREATE TABLE "billing_versions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "item_type" varchar(255) NOT NULL, "item_id" integer NOT NULL, "event" varchar(255) NOT NULL, "whodunnit" varchar(255), "object" text, "created_at" datetime, "ip" varchar(255), "user_agent" varchar(255)) h9!k-gindexindex_billing_versions_on_item_type_and_item_idbilling_versions(CREATE INDEX "index_billing_versions_on_item_type_and_item_id" ON "billing_versions" ("item_type", "item_id")"{tableprofilesprofilesCREATE TABLE "profiles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime, "updated_at" datetime)