SQLite format 3@ #G~#-FBD8B/.=(+# ;#2@8@1-  !p^L:(tbP>,!)20160125201025 )20160104105725)20151230104012)20151216124705)20151216104428)20151126142254)20151126132304)20151120122613)20151116143024)20151103110115)20151023135421)20151019100134)20151012181412)20150805134318)20150805133509)20150803160334)20150803152643)20150625131155)20150625093326)20150624081208 )20150624081207 )20150624081206 )20150624081205 )20150624081204 )20150623093218)20150622105217)20150622075038)20150622075000)20150616082916)20150616074852)20150312083147)20141014072756)20141010140200 !|iVC0 r_L9&)20160125201025!)20160104105725 )20151230104012)20151216124705)20151216104428)20151126142254)20151126132304)20151120122613)20151116143024)20151103110115)20151023135421)20151019100134)20151012181412)20150805134318)20150805133509)20150803160334)20150803152643)20150625131155)20150625093326)20150624081208)20150624081207 )20150624081206 )20150624081205 )20150624081204 )20150623093218 )20150622105217)20150622075038)20150622075000)20150616082916)20150616074852)20150312083147)20141014072756) 20141010140200    bbZl//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")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)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)  jjVII'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)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)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)     ``=: g9aindexindex_dorsale_flyboy_folders_on_folderable_iddorsale_flyboy_folders CREATE INDEX "index_dorsale_flyboy_folders_on_folderable_id" ON "dorsale_flyboy_folders" ("folderable_id")@ k9iindexindex_dorsale_flyboy_folders_on_folderable_typedorsale_flyboy_folders CREATE INDEX "index_dorsale_flyboy_folders_on_folderable_type" ON "dorsale_flyboy_folders" ("folderable_type")Z EE7tabledorsale_flyboy_task_commentsdorsale_flyboy_task_commentsCREATE 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)@ gEaindexindex_dorsale_flyboy_task_comments_on_task_iddorsale_flyboy_task_commentsCREATE INDEX "index_dorsale_flyboy_task_comments_on_task_id" ON "dorsale_flyboy_task_comments" ("task_id")    K 557tabledorsale_flyboy_tasksdorsale_flyboy_tasksCREATE 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),_5Qindexindex_dorsale_flyboy_tasks_on_taskable_iddorsale_flyboy_tasksCREATE INDEX "index_dorsale_flyboy_tasks_on_taskable_id" ON "dorsale_flyboy_tasks" ("taskable_id")2c5Yindexindex_dorsale_flyboy_tasks_on_taskable_typedorsale_flyboy_tasksCREATE INDEX "index_dorsale_flyboy_tasks_on_taskable_type" ON "dorsale_flyboy_tasks" ("taskable_type")    nnMMtabledorsale_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)  ||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)mWindexindex_dorsale_billing_machine_invoice_lines_on_invoice_iddorsale_billing_machine_invoice_lines!CREATE INDEX "index_dorsale_billing_machine_invoice_lines_on_invoice_id" ON "dorsale_billing_machine_invoice_lines" ("invoice_id")WW{tabledorsale_billing_machine_payment_termsdorsale_billing_machine_payment_termsCREATE 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)   iI$mEmindexindex_dorsale_customer_vault_links_on_alice_typedorsale_customer_vault_links1CREATE INDEX "index_dorsale_customer_vault_links_on_alice_type" ON "dorsale_customer_vault_links" ("alice_type")=%eE]indexindex_dorsale_customer_vault_links_on_bob_iddorsale_customer_vault_links3CREATE INDEX "index_dorsale_customer_vault_links_on_bob_id" ON "dorsale_customer_vault_links" ("bob_id")C&iEeindexindex_dorsale_customer_vault_links_on_bob_typedorsale_customer_vault_links4CREATE INDEX "index_dorsale_customer_vault_links_on_bob_type" ON "dorsale_customer_vault_links" ("bob_type")'tabletagstags5CREATE TABLE "tags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "taggings_count" integer DEFAULT 0)(Ytabletaggingstaggings6CREATE 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) ""(^+1indexindex_tags_on_nametags:CREATE UNIQUE INDEX "index_tags_on_name" ON "tags" ("name")#,%indextaggings_idxtaggings9CREATE UNIQUE INDEX "taggings_idx" ON "taggings" ("tag_id", "taggable_id", "taggable_type", "context", "tagger_id", "tagger_type")U-indexindex_taggings_on_taggable_id_and_taggable_type_and_contexttaggings7CREATE INDEX "index_taggings_on_taggable_id_and_taggable_type_and_context" ON "taggings" ("taggable_id", "taggable_type", "context") xx.tableusersusers{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")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")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")      GG7mASSAtabledorsale_customer_vault_corporationsdorsale_customer_vault_corporations,CREATE 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)FBQQwtabledorsale_customer_vault_individualsdorsale_customer_vault_individuals-CREATE 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)        &&0SGindexindex_users_on_reset_password_tokenusers?CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")B1--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)  ssCEE#tabledorsale_expense_gun_expensesdorsale_expense_gun_expensesACREATE 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)wDOO]tabledorsale_expense_gun_expense_linesdorsale_expense_gun_expense_linesCCREATE 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)    X; X`GyOindexindex_dorsale_expense_gun_expense_lines_on_category_iddorsale_expense_gun_expense_linesGCREATE INDEX "index_dorsale_expense_gun_expense_lines_on_category_id" ON "dorsale_expense_gun_expense_lines" ("category_id")bEII?tabledorsale_expense_gun_categoriesdorsale_expense_gun_categoriesDCREATE TABLE "dorsale_expense_gun_categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "code" varchar, "vat_deductible" boolean)]FwOindexindex_dorsale_expense_gun_expense_lines_on_expense_iddorsale_expense_gun_expense_linesECREATE INDEX "index_dorsale_expense_gun_expense_lines_on_expense_id" ON "dorsale_expense_gun_expense_lines" ("expense_id")