spec/dummy/db/test.sqlite3 in dorsale-2.3.1 vs spec/dummy/db/test.sqlite3 in dorsale-2.3.2

- old
+ new

@@ -1,34 +1,39 @@ -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<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)e/5 indexindex_users_on_emailusers=CREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email") N7QQtabledorsale_billing_machine_quotationsdorsale_billing_machine_quotations"CREATE 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)d8{Q indexindex_dorsale_billing_machine_quotations_on_customer_iddorsale_billing_machine_quotations&CREATE INDEX "index_dorsale_billing_machine_quotations_on_customer_id" ON "dorsale_billing_machine_quotations" ("customer_id")  ;;( j9Qindexindex_dorsale_billing_machine_quotations_on_customer_typedorsale_billing_machine_quotations'CREATE INDEX "index_dorsale_billing_machine_quotations_on_customer_type" ON "dorsale_billing_machine_quotations" ("customer_type")a:yQindexindex_dorsale_billing_machine_quotations_on_id_card_iddorsale_billing_machine_quotations;CREATE INDEX "index_dorsale_billing_machine_quotations_on_id_card_id" ON "dorsale_billing_machine_quotations" ("id_card_id")q;Qindexindex_dorsale_billing_machine_quotations_on_payment_term_iddorsale_billing_machine_quotations(CREATE INDEX "index_dorsale_billing_machine_quotations_on_payment_term_id" ON "dorsale_billing_machine_quotations" ("payment_term_id") -  vv[[gtabledorsale_billing_machine_quotation_linesdorsale_billing_machine_quotation_lines)CREATE 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)|[!indexindex_dorsale_billing_machine_quotation_lines_on_quotation_iddorsale_billing_machine_quotation_lines*CREATE INDEX "index_dorsale_billing_machine_quotation_lines_on_quotation_id" ON "dorsale_billing_machine_quotation_lines" ("quotation_id") - - - - -  - ::C"EE tabledorsale_customer_vault_linksdorsale_customer_vault_links/CREATE 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)C#iEeindexindex_dorsale_customer_vault_links_on_alice_iddorsale_customer_vault_links0CREATE INDEX "index_dorsale_customer_vault_links_on_alice_id" ON "dorsale_customer_vault_links" ("alice_id")   !k<MMItabledorsale_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)\=wMindexindex_dorsale_billing_machine_invoices_on_customer_iddorsale_billing_machine_invoicesCREATE INDEX "index_dorsale_billing_machine_invoices_on_customer_id" ON "dorsale_billing_machine_invoices" ("customer_id")  - - TT9b>{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") - +SQLite format 3@ 3c- +/ 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, "addui^  5 dorsale_flyboy_tasks dorsale_flyboy_folders users    +  + + + + +   >@ c v>>>>@Lk9iindexindex_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_fo^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) 8tableusersusers.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)#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")J%indextaggings_idxtaggings*CREATE UNIQUE INDEX "taggings_idx" ON]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)V\II'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)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)SGindexindex_users_on_reset_password_tokenusers1CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")h5 indexindex_users_on_emailusers0CREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email").=//indexunique_schema_migrationsschema_migrations3CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")l-//tableschema_migrationsschema_migrations2CREATE TABLE "schema_migrations" ("version" varchar NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq) < MK9M b b + (E inininE tabe+5 indexindex_users_onhdMindexindex_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")YcuM}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")bb{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")\awMindexindex_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")k`MMItabledorsale_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)m_Windexindex_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_bdi{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")NhQQtabledorsale_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)|g[!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")f[[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)eWW{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)  +   +  %<uhg|g[!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")f[[gtabledorsale_billing_machine_quotation_linesdorsale_billing_machine_quotation_linesCREATE TABLE "dorsale_billing_machine_quotation_lines" ("id" INTEuu99tabledorsale_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)CtiEeindexindex_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")=seE]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")FoQQwtabledorsale_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)mnSSAtabledorsale_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)Bm--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)qlQindexindex_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")akyQindexindex_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")jjQindexindex_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")_{Q indexindex_dorsale_billing_machine_quotations_on_customer_iddorsale_billing_machine_IrmEmindexindex_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")CqiEeindexindex_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")CpEE 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) + "=<|<[!indexindex_dorsale_billing_machine_quotation_lines_on_ZMEE7tabledorsale_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) {99tabledorsale_flyboy_foldersdorsale_flyboy_folders CREATE TABLE "dorsale_flyboy_folders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "folderable_id" integer, "folderable_type" varchar, "naV\II'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)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)#T%indextaggings_idxtaggings*CREATE UNIQUE INDEX "taggings_idx" ON "taggings" ("tag_id", "taggable_id", "taggable_type", "context", "tagger_id", "tagger_type")SYtabletaggingstaggings)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)BR%%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)2Qc5Yindexindex_dorsale_flyboy_tasks_on_taskable_typedorsale_flyboy_tasks'CREATE INDEX "index_dorsale_flyboy_tasks_on_taskable_type" ON "dorsale_flyboy_tasks" ("taskable_type"),P_5Qindexindex_dorsale_flyboy_tasks_on_taskable_iddorsale_flyboy_tasks&CREATE INDEX "index_dorsale_flyboy_tasks_on_taskable_id" ON "dorsale_flyboy_tasks" ("taskable_id") +O557tabledorsale_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)5gEaindexindex_dorsale_flyboy_task_comments_onZSGindexindex_users_on_reset_password_tokenusers1CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")eY5 indexindex_users_on_emailusers0CREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")Xtableusersusers.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)^W1indexindex_tags_on_nametags-CREATE UNIQUE INDEX "index_tags_on_name" ON "tags" ("name")Vtabletagstags,CREATE TABLE "tags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "taggings_count" integer DEFAULT 0)UUindexindex_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") + +     + + + + +  + +!   +#  + +&%; Dorsale::Flyboy::Folder   + +*)  +,  +$? fDB?n ;Uindexindex_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") +z557tabledorsale_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)@ygEaindexindex_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")ZxEE7tabledorsale_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)@wk9iindexindex_dorsale_flyboy_folders_on_folderable_typedorsale_flyboy_folders"CREATE INDEX "index_dorsale_flyboy_folders_on_folderable_type" ON "dorsale_flyboy_folders" ("folderable_type"):vg9aindexindex_dorsale_flyboy_folders_on_folderable_iddorsale_flyboy_folders!CREATE INDEX "index_dorsale_flyboy_folders_on_folderable_id" ON "dorsale_flyboy_folders" ("folderable_id")99tabledorsale_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)CtiEeindexindex_dorsale_customer_vault_links_on_bob_typedorsale_customer_vSGindexindex_users_on_reset_password_tokenusers1CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")e5 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) + +0. p^L:(tbP>,  )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)20160104105725 + VC0 +|ir_L9& )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) 20160104105725 \ No newline at end of file