SQLite format 3@ 53-5- / 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, "addressable!             Z  oh 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, "addressable_type" varchar) j d e  -@\h#3j$CEE 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)FQQwtabledorsale_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)mSSAtabledorsale_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)B--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)qQindexindex_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")ayQindexindex_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")jQindexindex_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")d{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")NQQtabledorsale_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_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 * mM(Po ('U'indexindex_taggings_on_taggable_id_and_taggable_type_and_contexttaggings+CREATE INDEX "index_taggings_on_taggable_id_and_taggable_type_and_context" ON "taggings" ("taggable_id", "taggable_type", "context")#&%indextaggings_idxtaggings*CREATE 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)2#c5Yindexindex_dorsale_flyboy_tasks_on_taskable_typedorsale_flyboy_tasks'CREATE INDEX "index_dorsale_flyboy_tasks_on_taskable_type" ON "dorsale_flyboy_tasks" ("taskable_type"),"_5Qindexindex_dorsale_flyboy_tasks_on_taskable_iddorsale_flyboy_tasks&CREATE INDEX "index_dorsale_flyboy_tasks_on_taskable_id" ON "dorsale_flyboy_tasks" ("taskable_id") !557tabledorsale_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")ZEE7tabledorsale_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)@k9iindexindex_dorsale_flyboy_folders_on_folderable_typedorsale_flyboy_folders"CREATE INDEX "index_dorsale_flyboy_folders_on_folderable_type" ON "dorsale_flyboy_folders" ("folderable_type"):g9aindexindex_dorsale_flyboy_folders_on_folderable_iddorsale_flyboy_folders!CREATE INDEX "index_dorsale_flyboy_folders_on_folderable_id" ON "dorsale_flyboy_folders" ("folderable_id")u99tabledorsale_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)CiEeindexindex_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")=eE]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")ImEmindexindex_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")CiEeindexindex_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")CEE 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)                   MQ + S bAEM.=//indexunique_schema_migrationsschema_migrations3CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")l-//tableschema_migrationsschema_migrations2CREATE TABLE "schema_migrations" ("version" varchar NOT NULL),SGindexindex_users_on_reset_password_tokenusers1CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")e+5 indexindex_users_on_emailusers0CREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")*tableusersusers.CREATE 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_nametags-CREATE UNIQUE INDEX "index_tags_on_name" ON "tags" ("name")(tabletagstags,CREATE 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_contexttaggings+CREATE INDEX "index_taggings_on_taggable_id_and_taggable_type_and_context" ON "taggings" ("taggable_id", "taggable_type", "context")#&%indextaggings_idxtaggings*CREATE 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)2#c5Yindexindex_dorsale_flyboy_tasks_on_taskable_typedorsale_flyboy_tasks'CREATE INDEX "index_dorsale_flyboy_tasks_on_taskable_type" ON "dorsale_flyboy_tasks" ("taskable_type"),"_5Qindexindex_dorsale_flyboy_tasks_on_taskable_iddorsale_flyboy_tasks&CREATE INDEX "index_dorsale_flyboy_tasks_on_taskable_id" ON "dorsale_flyboy_tasks" ("taskable_id")   pp)20150803160334)20150624081208)20150624081207)20150624081206)20150624081205)20150624081204)20150616082916)20160104105725 i|i)20150803160334)20150624081208)20150624081207)20150624081206)20150624081205)20150624081204)20150616082916) 20160104105725