SQLite format 3@ 9x- 9 h Mindexindex_dorsale_billing_machine_invoices_on_payment_term_iddorsale_billing_machine_invoices CREATE INDEX "index_dorsale_billing_machine_invoices_on_payment_term_id" ON "dorsale_billing_machine_invoices" ("payment_term_id")Y uM}indexindex_dorsale_billing_machine_invoices_on_id_card_iddorsale_billing_machine_invoices CREATE INDEX "index_dorsale_billing_machine_invoices_on_id_card_id" ON "dorsale_billing_machine_invoices" ("id_card_id")b {M indexindex_dorsale_billing_machine_invoices_on_customer_typedorsale_billing_machine_invoices CREATE INDEX "index_dorsale_billing_machine_invoices_on_customer_type" ON "dorsale_billing_machine_invoices" ("customer_type")\wMindexindex_dorsale_billing_machine_invoices_on_customer_iddorsale_billing_machine_invoices CREATE INDEX "index_dorsale_billing_machine_invoices_on_customer_id" ON "dorsale_billing_machine_invoices" ("customer_id")kMMItabledorsale_billing_machine_invoicesdorsale_billing_machine_invoicesCREATE TABLE "dorsale_billing_machine_invoices" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "customer_id" integer, "customer_type" varchar, "payment_term_id" integer, "id_card_id" integer, "date" date, "label" varchar, "total_excluding_taxes" decimal, "vat_amount" decimal, "total_including_taxes" decimal, "advance" decimal, "balance" decimal, "unique_index" integer, "paid" boolean, "due_date" date, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "tracking_id" varchar, "commercial_discount" decimal, "comments" text)mWindexindex_dorsale_billing_machine_invoice_lines_on_invoice_iddorsale_billing_machine_invoice_linesCREATE INDEX "index_dorsale_billing_machine_invoice_lines_on_invoice_id" ON "dorsale_billing_machine_invoice_lines" ("invoice_id")WW_tabledorsale_billing_machine_invoice_linesdorsale_billing_machine_invoice_linesCREATE TABLE "dorsale_billing_machine_invoice_lines" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "invoice_id" integer, "label" text, "quantity" decimal, "unit" varchar, "unit_price" decimal, "total" decimal, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "vat_rate" decimal)MMtabledorsale_billing_machine_id_cardsdorsale_billing_machine_id_cardsCREATE TABLE "dorsale_billing_machine_id_cards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "id_card_name" varchar, "entity_name" varchar, "siret" varchar, "legal_form" varchar, "capital" integer, "registration_number" varchar, "intracommunity_vat" varchar, "address1" varchar, "address2" varchar, "zip" varchar, "city" varchar, "phone" varchar, "contact_full_name" varchar, "contact_phone" varchar, "contact_address_1" varchar, "contact_address_2" varchar, "contact_zip" varchar, "contact_city" varchar, "iban" varchar, "bic_swift" varchar, "bank_name" varchar, "bank_address" varchar, "ape_naf" varchar, "custom_info_1" text, "custom_info_2" text, "custom_info_3" text, "contact_fax" varchar, "contact_email" varchar, "logo" varchar, "registration_city" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)VII'tabledorsale_alexandrie_attachmentsdorsale_alexandrie_attachmentsCREATE TABLE "dorsale_alexandrie_attachments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "attachable_id" integer, "attachable_type" varchar, "file" varchar, "sender_id" integer, "sender_type" varchar, "name" varchar, "created_at" datetime, "updated_at" datetime)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)Q//Qtabledorsale_addressesdorsale_addressesCREATE TABLE "dorsale_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "street" varchar, "street_bis" varchar, "city" varchar, "zip" varchar, "country" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "addressable_id" integer, "addres-W+J@6              {D f {{{{{{{{JJJZ$EE7tabledorsale_flyboy_task_commentsdorsale_flyboy_task_comments(CREATE TABLE "dorsale_flyboy_task_comments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "task_id" integer, "date" datetime, "description" text, "progress" integer, "created_at" datetime NOT NULL, "/tableusersusers4CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar DEFAULT '' NOT NULL, "encrypted_password" varchar DEFAULT '' NOT NULL, "reset_password_token" varchar, "reset_password_sent_at" datetime, "remember_created_at" datetime, "sign_in_count" integer DEFAULT 0 NOT NULL, "current_sign_in_at" datetime, "last_sign_in_at" datetime, "current_sign_in_ip" varchar, "last_sign_in_ip" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "is_active" boolean, "avatar" varchar)1indexindex_tags_on_nametags3CREATE UNIQUE INDEX "index_tags_on_name" ON "tags" ("name")tabletagstags2CREATE TABLE "tags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "taggings_count" integer DEFAULT 0)indexindex_taggings_on_taggable_id_and_taggable_type_and_contexttaggings1CREATE INDEX "index_taggings_on_taggable_id_and_taggable_type_and_context" ON "taggings" ("taggable_id", "taggable_type", "context")G%indextaggings_idxtaggings0CREATE UNIQUE INDEX "taggings_idx" ON "taggings" ("tag_id", "taggable_id", "taggable_type", "context", "tagger_id", "tagger_type")Ytabletaggingstaggings/CREATE TABLE "taggings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "tag_id" integer, "taggable_id" integer, "taggable_type" varchar, "tagger_id" integer, "tagger_type" varchar, "context" varchar(128), "created_at" datetime)%%Gtabledummy_modelsdummy_models.CREATE TABLE "dummy_models" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime6MMtabledorsale_billing_machine_id_cardsdorsale_billing_machine_id_cardsCREATE TABLE "dorsale_billing_machine_id_cards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "id_card_name" varchar, "entity_name" varchar, "siret" varchar, "legal_form" varchar, "capital" integer, "registration_number" varchar, "intracommunity_vat" varchar, "address1" varchar, "address2" varchar, "zip" varchar, "city" varchar, "phone" varchar, "contact_full_name" varchar, "contact_phone" varchar, "contact_address_1" varchar, "contact_address_2" varchar, "contact_zip" varchar, "contact_city" varchar, "iban" varchar, "bic_swift" varchar, "bank_name" varchar, "bank_address" varchar, "ape_naf" varchar, "custom_info_1" text, "custom_info_2" text, "custom_info_3" text, "contact_fax" varchar, "contact_email" varchar, "logo" varchar, "registration_city" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)V5II'tabledorsale_alexandrie_attachmentsdorsale_alexandrie_attachmentsCREATE TABLE "dorsale_alexandrie_attachments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "attachable_id" integer, "attachable_type" varchar, "file" varchar, "sender_id" integer, "sender_type" varchar, "name" varchar, "created_at" datetime, "updated_at" datetime)Q4//Qtabledorsale_addressesdorsale_addressesCREATE TABLE "dorsale_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "street" varchar, "street_bis" varchar, "city" varchar, "zip" varchar, "country" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "addressable_id" integer, "addressable_type" varchar)3=//indexunique_schema_migrationsschema_migrations8CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")l2//tableschema_migrationsschema_migrations7CREATE TABLE "schema_migrations" ("version" varchar NOT NULL)SGindexindex_users_on_reset_password_tokenusers6CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")g5 indexindex_users_on_emailusers5CREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)  (JZ ($9 ( E Led6EE tabledorsale_customer_vault_liY<uM}indexindex_dorsale_billing_machine_invoices_on_id_card_iddorsale_billing_machine_invoices CREATE INDEX "index_dorsale_billing_machine_invoices_on_id_card_id" ON "dorsale_billing_machine_invoices" ("id_card_id")b;{M indexindex_dorsale_billing_machine_invoices_on_customer_typedorsale_billing_machine_invoices CREATE INDEX "index_dorsale_billing_machine_invoices_on_customer_type" ON "dorsale_billing_machine_invoices" ("customer_type")\:wMindexindex_dorsale_billing_machine_invoices_on_customer_iddorsale_billing_machine_invoices CREATE INDEX "index_dorsale_billing_machine_invoices_on_customer_id" ON "dorsale_billing_machine_invoices" ("customer_id")k9MMItabledorsale_billing_machine_invoicesdorsale_billing_machine_invoicesCREATE TABLE "dorsale_billing_machine_invoices" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "customer_id" integer, "customer_type" varchar, "payment_term_id" integer, "id_card_id" integer, "date" date, "label" varchar, "total_excluding_taxes" decimal, "vat_amount" decimal, "total_including_taxes" decimal, "advance" decimal, "balance" decimal, "unique_index" integer, "paid" boolean, "due_date" date, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "tracking_id" varchar, "commercial_discount" decimal, "comments" text)m8Windexindex_dorsale_billing_machine_invoice_lines_on_invoice_iddorsale_billing_machine_invoice_linesCREATE INDEX "index_dorsale_billing_machine_invoice_lines_on_invoice_id" ON "dorsale_billing_machine_invoice_lines" ("invoice_id")7WW_tabledorsale_billing_machine_invoice_linesdorsale_billing_machine_invoice_linesCREATE TABLE "dorsale_billing_machine_invoice_lines" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "invoice_id" integer, "label" text, "quantity" decimal, "unit" varchar, "unit_price" decimal, "total" decimal, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "vat_rate" decimal)MMtabledorsale_billing_machine_id_cardsdorsale_billing_machine_id_cardsCREATE TABLE "dorsale_billing_machine_id_cards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "id_card_name" varchar, "entity_name" varchar, "siret" varchar, "legal_form" varchar, "capital" integer, "registration_number" varchar, "intracommunity_vat" varchar, "address1" varchar, "address2" varchar, "zip" varchar, "city" varchar, "phone" varchar, "contact_full_name" varchar, "contact_phone" varchar, "contact_address_1" varchar, "contact_address_2" varchar, "contact_zip" varchar, "contact_city" varchar, "iban" varchar, "bic_swift" varchar, "bank_name" varchar, "bank_address" varchar, "ape_naf" varchar, "custom_info_1" text, "custom|@[!indexindex_dorsale_billing_machine_quotation_lines_on_quotation_iddorsale_billing_machine_quotation_linesCREATE INDEX "index_dorsale_billing_machine_quotation_lines_on_quotation_id" ON "dorsale_billing_machine_quotation_lines" ("quotation_id")?[[gtabledorsale_billing_machine_quotation_linesdorsale_billing_machine_quotation_linesCREATE TABLE "dorsale_billing_machine_quotation_lines" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "quotation_id" integer, "label" text, "quantity" decimal, "unit" varchar, "unit_price" decimal, "total" decimal, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "vat_rate" decimal)>WW{tabledorsale_billing_machine_payment_termsdorsale_billing_machine_payment_terms CREATE TABLE "dorsale_billing_machine_payment_terms" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "label" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)h=Mindexindex_dorsale_billing_machine_invoices_on_payment_term_iddorsale_billing_machine_invoices CREATE INDEX "index_dorsale_billing_machine_invoices_on_payment_term_id" ON "dorsale_billing_machine_invoices" ("payment_term_id")Y<uM}indexindex_dorsale_billing_machine_invoices_on_id_card_iddorsale_billing_machine_invoices CREATE INDEX "index_dorsale_billing_machine_invoices_on_id_card_id" ON "dorsale_billing_machine_invoices" ("id_card_id")             ,+*JZ 2v" l2//tableschema_migrationsschema_migrations7CREATE TABLE "schema_migrations" ("version" varchar NOT NULL)1SGinm8Windexindex_dorsale_billing_machine_invoice_lines_on_invoice_iddorsale_billing_machine_invoice_linesCREATE INDEX "index_dorsale_billing_machine_invoice_lines_on_invoice_id" ON "dorsale_billing_machine_invoice_lines" ("invoice_id")/tableusersusers4CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar \:wMindexindex_dorsale_billing_machine_invoices_on_customer_iddorsale_billing_machine_invoices CREATE INDEX "index_dorsale_billing_machine_invoices_on_customer_id" ON "dorsale_billing_machine_invoices" ("customer_id")k9MMItabledorsale_billing_machine_invoicesdorsale_billing_machine_invoicesCREATE TABLE "dorsale_billing_machine_invoices" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "customer_id" integer, "customer_type" varchar, "payment_term_id" integer, "id_card_id" integer, "date" date, "label" varchar, "total_excluding_taxes" decimal, "vat_amount" decimal, "total_including_taxes" decimal, "advance" decimal, "balance" decimal, "unique_index" integer, "paid" boolean, "due_date" date, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "tracking_id" varchar, "commercial_discount" decimal, "comments" text)m8Windexindex_dorsale_billing_machine_invoice_lines_on_invoice_iddorsale_billing_machine_invoice_linesCREATE INDEX "index_dorsale_billing_machine_invoice_lines_on_invoice_id" ON "dorsale_billing_machine_invoice_lines" ("invoice_id")7WW_tabledorsale_billing_machine_invoice_linesdorsale_billing_machine_invoice_linesCREATE TABLE "dorsale_billing_machine_invoice_lines" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "invoice_id" integer, "label" text, "quantity" decimal, "unit" varchar, "unit_price" decimal, "total" decimal, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "vat_rate" decimal)6MMtabledorsale_billing_machine_id_cardsdorsale_billing_machine_id_cardsCREATE TABLE "dorsale_billing_machine_id_cards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "id_card_name" varchar, "entity_name" varchar, "siret" varchar, "legal_form" varchar, "capital" integer, "registration_number" varchar, "intracommunity_vat" varchar, "address1" varchar, "address2" varchar, "zip" varchar, "city" varchar, "phone" varchar, "contact_full_name" varchar, "contact_phone" varchar, "contact_address_1" varchar, "contact_address_2" varchar, "contact_zip" varchar, "contact_city" varchar, "iban" varchar, "bic_swift" varchar, "bank_name" varchar, "bank_address" varchar, "ape_naf" varchar, "custom_info_1" text, "custom_info_2" text, "custom_info_3" text, "contact_fax" varchar, "contact_email" varchar, "logo" varchar, "registration_city" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)V5II'tabledorsale_alexandrie_attachmentsdorsale_alexandrie_attachmentsCREATE TABLE "dorsale_alexandrie_attachments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "attachable_id" integer, "attachable_type" varchar, "file" varchar, "sender_id" integer, "sender_type" varchar, "name" varchar, "created_at" datetime, "updated_at" datetime)Q4//Qtabledorsale_addressesdorsale_addressesCREATE TABLE "dorsale_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "street" varchar, "street_bis" varchar, "city" varchar, "zip" varchar, "country" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "addressable_id" integer, "addressable_type" varchar)3=//indexunique_schema_migrationsschema_migrations8CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")l2//tableschema_migrationsschema_migrations7CREATE TABLE "schema_migrations" ("version" varchar NOT NULL)1SGindexindex_users_on_reset_password_tokenusers6CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")g5 indexindex_users_on_emailusers5CREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")       "!        z H )BUq}8H7 +}yY<uM}indexindex_dorsale_billing_machine_invoicFHQQwtabledorsale_customer_vault_individualsdorsale_customer_vault_individualsCREATE TABLE "dorsale_customer_vault_individuals" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "first_name" varchar, "last_name" varchar, "short_namY<uM}indexindex_dorsale_billing_machine_invoices_on_id_card_iddorsale_billing_machine_invoices CREATE INDEX "index_dorsale_billing_machine_invoices_on_id_card_id" ON "dorsale_billing_machine_invoices" ("id_card_id")mGSSAtabledorsale_customer_vault_corporationsdorsale_customer_vault_corporationsCREATE TABLE "dorsale_customer_vault_corporations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "short_name" varchar, "email" text, "phone" varchar, "fax" varchar, "www" text, "legal_form" varchar, "capital" integer, "immatriculation_number_1" varchar, "immatriculation_number_2" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "european_union_vat_number" varchar)BF--7tabledorsale_commentsdorsale_commentsCREATE TABLE "dorsale_comments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "author_id" integer, "user_type" varchar, "commentable_id" integer, "commentable_type" varchar, "text" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "author_type" varchar)qEQindexindex_dorsale_billing_machine_quotations_on_payment_term_iddorsale_billing_machine_quotationsCREATE INDEX "index_dorsale_billing_machine_quotations_on_payment_term_id" ON "dorsale_billing_machine_quotations" ("payment_term_id")aDyQindexindex_dorsale_billing_machine_quotations_on_id_card_iddorsale_billing_machine_quotationsCREATE INDEX "index_dorsale_billing_machine_quotations_on_id_card_id" ON "dorsale_billing_machine_quotations" ("id_card_id")jCQindexindex_dorsale_billing_machine_quotations_on_customer_typedorsale_billing_machine_quotationsCREATE INDEX "index_dorsale_billing_machine_quotations_on_customer_type" ON "dorsale_billing_machine_quotations" ("customer_type")dB{Q indexindex_dorsale_billing_machine_quotations_on_customer_iddorsale_billing_machine_quotationsCREATE INDEX "index_dorsale_billing_machine_quotations_on_customer_id" ON "dorsale_billing_machine_quotations" ("customer_id")NAQQtabledorsale_billing_machine_quotationsdorsale_billing_machine_quotationsCREATE TABLE "dorsale_billing_machine_quotations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "customer_id" integer, "customer_type" varchar, "id_card_id" integer, "payment_term_id" integer, "date" date, "label" varchar, "total_excluding_taxes" decimal, "vat_amount" decimal, "total_including_taxes" decimal, "unique_index" integer, "comments" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "expires_at" date, "tracking_id" varchar, "commercial_discount" decimal, "state" varchar)[!indexindex_dorsale_billing_machine_quotation_lines_on_quotation_iddorsale_billing_machine_quotation_linesCREATE INDEX "index_dorsale_billing_machine_quotation_lines_CJiEeindexindex_dorsale_customer_vault_links_on_alice_iddorsale_customer_vault_linksCREATE INDEX "index_dorsale_customer_vault_links_on_alice_id" ON "dorsale_customer_vault_links" ("alice_id")CIEE tabledorsale_customer_vault_linksdorsale_customer_vault_linksCREATE TABLE "dorsale_customer_vault_links" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar, "alice_id" integer, "alice_type" varchar, "bob_id" integer, "bob_type" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)FHQQwtabledorsale_customer_vault_individualsdorsale_customer_vault_individualsCREATE TABLE "dorsale_customer_vault_individuals" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "first_name" varchar, "last_name" varchar, "short_name" varchar, "email" text, "title" varchar, "twitter" varchar, "www" text, "context" text, "phone" varchar, "fax" varchar, "mobile" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "skype" varchar)  +  _ z u O=9ZVEE7tabledorsale_flyboy_task_commentsdorsale_flyboy_task_comments(CREATE TABLE "dorsale_flyboy_task_comments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "task_id" integer, "date" datetime, "description" text, "progress" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "author_type" varchar, "author_id" integer)@Uk9iindexindex_dorsale_flyboy_folders_on_folderable_typedorsale_flyboy_folders'CREATE INDEX "index_dorsale_flyboy_folders_on_folderable_type" ON "dorsale_flyboy_folders" ("folderable_type"):Tg9aindexindex_dorsale_flyboy_folders_on_folderable_iddorsale_flyboy_folders&CREATE INDEX "inde@WgEaindexindex_dorsale_flyboy_task_comments_on_task_iddorsale_flyboy_task_comments)CREATE INDEX "index_dorsale_flyboy_task_comments_on_task_id" ON "dorsale_flyboy_task_comments" ("task_id")ZVEE7tabledorsale_flyboy_task_commentsdorsale_flyboy_task_comments(CREATE TABLE "dorsale_flyboy_task_comments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "task_id" integer, "date" datetime, "description" text, "progress" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "author_type" varchar, "author_id" integer)@Uk9iindexindex_dorsale_flyboy_folders_on_folderable_typedorsale_flyboy_folders'CREATE INDEX "index_dorsale_flyboy_folders_on_folderable_type" ON "dorsale_flyboy_folders" ("folderable_type")]QwOindexindex_dorsale_expense_gun_expense_lines_on_expense_iddorsale_expense_gun_expense_lines#CREATE INDEX "index_dorsale_expense_gun_expense_lines_on_expense_id" ON "dorsale_expense_gun_expense_lines" ("expense_id")`PyOindexindex_dorsale_expense_gun_expense_lines_on_category_iddorsale_expense_gun_expense_lines"CREATE INDEX "index_dorsale_expense_gun_expense_lines_on_category_id" ON "dorsale_expense_gun_expense_lines" ("category_id")wOOO]tabledorsale_expense_gun_expense_linesdorsale_expense_gun_expense_lines!CREATE TABLE "dorsale_expense_gun_expense_lines" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "expense_id" integer, "category_id" integer, "name" varchar, "date" date, "total_all_taxes" float, "vat" float, "company_part" float, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)bNII?tabledorsale_expense_gun_categoriesdorsale_expense_gun_categories CREATE TABLE "dorsale_expense_gun_categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "code" varchar, "vat_deductible" boolean)CMiEeindexindex_dorsale_customer_vault_links_on_bob_typedorsale_customer_vault_linksCREATE INDEX "index_dorsale_customer_vault_links_on_bob_type" ON "dorsale_customer_vault_links" ("bob_type")=LeE]indexindex_dorsale_customer_vault_links_on_bob_iddorsale_customer_vault_linksCREATE INDEX "index_dorsale_customer_vault_links_on_bob_id" ON "dorsale_customer_vault_links" ("bob_id")IKmEmindexindex_dorsale_customer_vault_links_on_alice_typedorsale_customer_vault_linksCREATE INDEX "index_dorsale_customer_vault_links_on_alice_type" ON "dorsale_customer_vault_links" ("alice_type")iEeindexindex_dorsale_customer_vault_links_on_alice_iddorsale_customer_vault_linksCREATE INDEX "index_dorsale_customer_vault_links_on:Tg9aindexindex_dorsale_flyboy_folders_on_folderable_iddorsale_flyboy_folders&CREATE INDEX "index_dorsale_flyboy_folders_on_folderable_id" ON "dorsale_flyboy_folders" ("folderable_id")uS99tabledorsale_flyboy_foldersdorsale_flyboy_folders%CREATE TABLE "dorsale_flyboy_folders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "folderable_id" integer, "folderable_type" varchar, "name" varchar, "description" text, "progress" integer, "status" varchar, "tracking" varchar, "version" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)REE#tabledorsale_expense_gun_expensesdorsale_expense_gun_expenses$CREATE TABLE "dorsale_expense_gun_expenses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "state" varchar, "date" date, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)    0/  2   54 ! p^L:(tbP>, !)20160104105725 )20151230104012)20151216124705)20151216104428)20151126142254)20151126132304)20151120122613)20151116143024)20151103110115)20151023135421)20151019100134)20151012181412)20150805134318)20150805133509)20150803152643)20150625131155)20150625093326)20150623093218)20150622105217)20150622075038 )20150622075000 )20150616074852 )20150312083147 )20141014072756 )20141010140200)20150803160334)20150624081208)20150624081207)20150624081206)20150624081205)20150624081204)20150616082916)20160125201025 ! VC0 |ir_L9& )20160104105725!)20151230104012 )20151216124705)20151216104428)20151126142254)20151126132304)20151120122613)20151116143024)20151103110115)20151023135421)20151019100134)20151012181412)20150805134318)20150805133509)20150803152643)20150625131155)20150625093326)20150623093218)20150622105217)20150622075038)20150622075000 )20150616074852 )20150312083147 )20141014072756 )20141010140200 )20150803160334)20150624081208)20150624081207)20150624081206)20150624081205)20150624081204)20150616082916) 20160125201025 Hs atableusersusers4CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar DEFAULT '' NOT NULL, "encrypted_password" varchar DEFAULT '' NOT NULL, "reset_password_token" varchar, "reset_password_sent_at" datetime, "remember_created_at" datetime, "sign_in_count" integer DEFAULT 0 NOT NULL, "current_sign_in_at" datetime, "last_sign_in_at" datetime, "current_sign_in_ip" varchar, "last_sign_in_ip" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "is_active" boolean, "avatar" varchar)^`1indexindex_tags_on_nametags3CREATE UNIQUE INDEX "index_tags_on_name" ON "tags" ("name")_tabletagstags2CREATE TABLE "tags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "taggings_count" integer DEFAULT 0)U^indexindex_taggings_on_taggable_id_and_taggable_type_and_contexttaggings1CREATE INDEX "index_taggings_on_taggable_id_and_taggable_type_and_context" ON "taggings" ("taggable_id", "taggable_type", "context")#]%indextaggings_idxtaggings0CREATE UNIQUE INDEX "taggings_idx" ON "taggings" ("tag_id", "taggable_id", "taggable_type", "context", "tagger_id", "tagger_type")\Ytabletaggingstaggings/CREATE TABLE "taggings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "tag_id" integer, "taggable_id" integer, "taggable_type" varchar, "tagger_id" integer, "tagger_type" varchar, "context" varchar(128), "created_at" datetime)B[%%Gtabledummy_modelsdummy_models.CREATE TABLE "dummy_models" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)2Zc5Yindexindex_dorsale_flyboy_tasks_on_taskable_typedorsale_flyboy_tasksCREATE INDEX "index_dorsale_flyboy_tasks_on_taskable_type" ON "dorsale_flyboy_tasks" ("taskable_type"),Y_5Qindexindex_dorsale_flyboy_tasks_on_taskable_iddorsale_flyboy_tasks,CREATE INDEX "index_dorsale_flyboy_tasks_on_taskable_id" ON "dorsale_flyboy_tasks" ("taskable_id") X557tabledorsale_flyboy_tasksdorsale_flyboy_tasks*CREATE TABLE "dorsale_flyboy_tasks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "taskable_id" integer, "taskable_type" varchar, "name" varchar, "description" text, "progress" integer, "done" boolean, "term" date, "reminder" date, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "owner_type" varchar, "owner_id" integer)/gEaindexindex_dorsale_flyboy_task_comments_on_task_iddorsale_flyboy_task_comments)CREATE INDEX "index_dorsale_flyboy_task_comments_on_task_id" ON "dorsale_flyboy_task_comments" ("task_id")ZVEE7tabledorsale_flyboy_task_commentsdorsale_flyboy_task_comments(CREATE TABLE "dorsale_flyboy_task_comments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "task_id" integer, "date" datetime, "description" text, "progress" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "author_type" varchar, "author_id" integer)@Uk9iindexindex_dorsale_flyboy_folders_on_folderable_typedorsale_flyboy_folders'CREATE INDEX "index_dorsale_flyboy_folders_on_folderable_type" ON "dorsale_flyboy_folders" ("folderable_type"):Tg9aindexindex_dorsale_flyboy_folders_on_folderable_iddorsale_flyboy_folders&CREATE INDEX "index_dorsale_flyboy_folders_on_folderable_id" ON "dorsale_flyboy_folders" ("folderable_id")uS99tabledorsale_flyboy_foldersdorsale_flyboy_folders%CREATE TABLE "dorsale_flyboy_folders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "folderable_id" integer, "folderable_type" varchar, "name" varchar, "description" text, "progress" integer, "status" varchar, "tracking" varchar, "version" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)REE#tabledorsale_cSGindexindex_users_on_reset_password_tokenusers6CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")eb5 indexindex_users_on_emailusers5CREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")