(2.9ms) CREATE 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)   (1.3ms) CREATE TABLE "dorsale_alexandrie_attachments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "attachable_id" integer, "attachable_type" varchar, "file" varchar)  (1.1ms) CREATE 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)   (1.0ms) CREATE 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)  (0.1ms) select sqlite_version(*)  (0.9ms) CREATE INDEX "index_dorsale_billing_machine_invoice_lines_on_invoice_id" ON "dorsale_billing_machine_invoice_lines" ("invoice_id")  (1.1ms) CREATE 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_duty" decimal, "vat_amount" decimal, "total_all_taxes" decimal, "advance" decimal, "balance" decimal, "unique_index" integer, "vat_rate" decimal, "paid" boolean, "due_date" date, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "tracking_id" varchar)   (1.0ms) CREATE INDEX "index_dorsale_billing_machine_invoices_on_customer_id" ON "dorsale_billing_machine_invoices" ("customer_id")  (0.2ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_id' AND type='index'   (0.9ms) CREATE INDEX "index_dorsale_billing_machine_invoices_on_customer_type" ON "dorsale_billing_machine_invoices" ("customer_type")  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_type' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_type' AND type='index'   (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_id' AND type='index'  (0.9ms) CREATE INDEX "index_dorsale_billing_machine_invoices_on_id_card_id" ON "dorsale_billing_machine_invoices" ("id_card_id")  (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_invoices_on_id_card_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_invoices_on_id_card_id' AND type='index'  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_type' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_type' AND type='index'   (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_id' AND type='index'  (0.9ms) CREATE INDEX "index_dorsale_billing_machine_invoices_on_payment_term_id" ON "dorsale_billing_machine_invoices" ("payment_term_id")  (1.1ms) 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)  (1.1ms) 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)   (1.0ms) CREATE INDEX "index_dorsale_billing_machine_quotation_lines_on_quotation_id" ON "dorsale_billing_machine_quotation_lines" ("quotation_id")  (1.0ms) 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_duty" decimal, "vat_amount" decimal, "total_all_taxes" decimal, "unique_index" integer, "vat_rate" decimal, "comments" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "expires_at" date, "tracking_id" varchar)   (0.9ms) CREATE INDEX "index_dorsale_billing_machine_quotations_on_customer_id" ON "dorsale_billing_machine_quotations" ("customer_id")  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_id' AND type='index'   (1.0ms) CREATE INDEX "index_dorsale_billing_machine_quotations_on_customer_type" ON "dorsale_billing_machine_quotations" ("customer_type")  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_type' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_type' AND type='index'   (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_id' AND type='index'  (1.0ms) CREATE INDEX "index_dorsale_billing_machine_quotations_on_id_card_id" ON "dorsale_billing_machine_quotations" ("id_card_id")  (0.2ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_quotations_on_id_card_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_quotations_on_id_card_id' AND type='index'  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_type' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_type' AND type='index'   (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_id' AND type='index'  (1.1ms) CREATE INDEX "index_dorsale_billing_machine_quotations_on_payment_term_id" ON "dorsale_billing_machine_quotations" ("payment_term_id")  (1.1ms) CREATE 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)  (1.0ms) CREATE TABLE "dorsale_customer_vault_corporations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "short_name" varchar, "email" varchar, "phone" varchar, "fax" varchar, "www" varchar, "legal_form" varchar, "capital" integer, "immatriculation_number_1" varchar, "immatriculation_number_2" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)   (1.0ms) CREATE TABLE "dorsale_customer_vault_individuals" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "first_name" varchar, "last_name" varchar, "short_name" varchar, "email" varchar, "title" varchar, "twitter" varchar, "www" varchar, "context" text, "phone" varchar, "fax" varchar, "mobile" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)  (1.0ms) 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)   (1.3ms) CREATE INDEX "index_dorsale_customer_vault_links_on_alice_id" ON "dorsale_customer_vault_links" ("alice_id")  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_customer_vault_links_on_alice_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_customer_vault_links_on_alice_id' AND type='index'   (1.1ms) CREATE INDEX "index_dorsale_customer_vault_links_on_alice_type" ON "dorsale_customer_vault_links" ("alice_type")  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_customer_vault_links_on_alice_type' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_customer_vault_links_on_alice_type' AND type='index'   (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_customer_vault_links_on_alice_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_customer_vault_links_on_alice_id' AND type='index'  (1.1ms) CREATE INDEX "index_dorsale_customer_vault_links_on_bob_id" ON "dorsale_customer_vault_links" ("bob_id")  (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_customer_vault_links_on_bob_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_customer_vault_links_on_bob_id' AND type='index'  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_customer_vault_links_on_alice_type' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_customer_vault_links_on_alice_type' AND type='index'   (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_customer_vault_links_on_alice_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_customer_vault_links_on_alice_id' AND type='index'  (1.0ms) CREATE INDEX "index_dorsale_customer_vault_links_on_bob_type" ON "dorsale_customer_vault_links" ("bob_type")  (1.0ms) 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)  (0.9ms) CREATE INDEX "index_dorsale_flyboy_folders_on_folderable_id" ON "dorsale_flyboy_folders" ("folderable_id")  (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_flyboy_folders_on_folderable_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_flyboy_folders_on_folderable_id' AND type='index'  (1.1ms) CREATE INDEX "index_dorsale_flyboy_folders_on_folderable_type" ON "dorsale_flyboy_folders" ("folderable_type")  (1.1ms) 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)  (0.9ms) CREATE INDEX "index_dorsale_flyboy_task_comments_on_task_id" ON "dorsale_flyboy_task_comments" ("task_id")  (1.0ms) 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_id" integer, "owner_type" varchar)  (1.0ms) CREATE INDEX "index_dorsale_flyboy_tasks_on_taskable_id" ON "dorsale_flyboy_tasks" ("taskable_id")  (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_flyboy_tasks_on_taskable_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_flyboy_tasks_on_taskable_id' AND type='index'  (1.0ms) CREATE INDEX "index_dorsale_flyboy_tasks_on_taskable_type" ON "dorsale_flyboy_tasks" ("taskable_type")  (1.0ms) CREATE TABLE "dummy_models" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)  (1.1ms) 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)   (1.0ms) CREATE UNIQUE INDEX "taggings_idx" ON "taggings" ("tag_id", "taggable_id", "taggable_type", "context", "tagger_id", "tagger_type")  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='taggings_idx' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='taggings_idx' AND type='index'   (1.0ms) CREATE INDEX "index_taggings_on_taggable_id_and_taggable_type_and_context" ON "taggings" ("taggable_id", "taggable_type", "context")  (1.4ms) CREATE TABLE "tags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "taggings_count" integer DEFAULT 0)   (1.1ms) CREATE UNIQUE INDEX "index_tags_on_name" ON "tags" ("name")  (1.3ms) 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)   (1.1ms) CREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_users_on_email' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_users_on_email' AND type='index'   (1.0ms) CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")  (1.1ms) CREATE TABLE "schema_migrations" ("version" varchar NOT NULL)   (1.0ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")  (0.1ms) SELECT version FROM "schema_migrations"  (1.1ms) INSERT INTO "schema_migrations" (version) VALUES ('20150805134318')  (1.0ms) INSERT INTO "schema_migrations" (version) VALUES ('20150616082916')  (0.9ms) INSERT INTO "schema_migrations" (version) VALUES ('20150624081204')  (0.8ms) INSERT INTO "schema_migrations" (version) VALUES ('20150624081205')  (0.8ms) INSERT INTO "schema_migrations" (version) VALUES ('20150624081206')  (0.9ms) INSERT INTO "schema_migrations" (version) VALUES ('20150624081207')  (0.9ms) INSERT INTO "schema_migrations" (version) VALUES ('20150624081208')  (0.9ms) INSERT INTO "schema_migrations" (version) VALUES ('20150803160334')  (0.8ms) INSERT INTO "schema_migrations" (version) VALUES ('20141010140200')  (0.8ms) INSERT INTO "schema_migrations" (version) VALUES ('20141014072756')  (0.9ms) INSERT INTO "schema_migrations" (version) VALUES ('20150312083147')  (0.9ms) INSERT INTO "schema_migrations" (version) VALUES ('20150616074852')  (0.9ms) INSERT INTO "schema_migrations" (version) VALUES ('20150622075000')  (0.8ms) INSERT INTO "schema_migrations" (version) VALUES ('20150622075038')  (0.8ms) INSERT INTO "schema_migrations" (version) VALUES ('20150622105217')  (0.8ms) INSERT INTO "schema_migrations" (version) VALUES ('20150623093218')  (0.9ms) INSERT INTO "schema_migrations" (version) VALUES ('20150625093326')  (0.9ms) INSERT INTO "schema_migrations" (version) VALUES ('20150625131155')  (0.8ms) INSERT INTO "schema_migrations" (version) VALUES ('20150803152643')  (0.8ms) INSERT INTO "schema_migrations" (version) VALUES ('20150805133509')  (3.1ms) CREATE 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)   (1.0ms) CREATE TABLE "dorsale_alexandrie_attachments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "attachable_id" integer, "attachable_type" varchar, "file" varchar)  (1.0ms) CREATE 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)   (1.0ms) CREATE 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)  (0.1ms) select sqlite_version(*)  (1.1ms) CREATE INDEX "index_dorsale_billing_machine_invoice_lines_on_invoice_id" ON "dorsale_billing_machine_invoice_lines" ("invoice_id")  (1.2ms) CREATE 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_duty" decimal, "vat_amount" decimal, "total_all_taxes" decimal, "advance" decimal, "balance" decimal, "unique_index" integer, "vat_rate" decimal, "paid" boolean, "due_date" date, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "tracking_id" varchar)   (0.9ms) CREATE INDEX "index_dorsale_billing_machine_invoices_on_customer_id" ON "dorsale_billing_machine_invoices" ("customer_id")  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_id' AND type='index'   (1.0ms) CREATE INDEX "index_dorsale_billing_machine_invoices_on_customer_type" ON "dorsale_billing_machine_invoices" ("customer_type")  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_type' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_type' AND type='index'   (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_id' AND type='index'  (1.0ms) CREATE INDEX "index_dorsale_billing_machine_invoices_on_id_card_id" ON "dorsale_billing_machine_invoices" ("id_card_id")  (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_invoices_on_id_card_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_invoices_on_id_card_id' AND type='index'  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_type' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_type' AND type='index'   (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_id' AND type='index'  (1.0ms) CREATE INDEX "index_dorsale_billing_machine_invoices_on_payment_term_id" ON "dorsale_billing_machine_invoices" ("payment_term_id")  (1.0ms) 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)  (1.0ms) 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)   (1.0ms) CREATE INDEX "index_dorsale_billing_machine_quotation_lines_on_quotation_id" ON "dorsale_billing_machine_quotation_lines" ("quotation_id")  (1.0ms) 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_duty" decimal, "vat_amount" decimal, "total_all_taxes" decimal, "unique_index" integer, "vat_rate" decimal, "comments" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "expires_at" date, "tracking_id" varchar)   (1.1ms) CREATE INDEX "index_dorsale_billing_machine_quotations_on_customer_id" ON "dorsale_billing_machine_quotations" ("customer_id")  (0.2ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_id' AND type='index'   (1.2ms) CREATE INDEX "index_dorsale_billing_machine_quotations_on_customer_type" ON "dorsale_billing_machine_quotations" ("customer_type")  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_type' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_type' AND type='index'   (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_id' AND type='index'  (1.1ms) CREATE INDEX "index_dorsale_billing_machine_quotations_on_id_card_id" ON "dorsale_billing_machine_quotations" ("id_card_id")  (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_quotations_on_id_card_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_quotations_on_id_card_id' AND type='index'  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_type' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_type' AND type='index'   (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_id' AND type='index'  (1.0ms) CREATE INDEX "index_dorsale_billing_machine_quotations_on_payment_term_id" ON "dorsale_billing_machine_quotations" ("payment_term_id")  (1.2ms) CREATE 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)  (1.4ms) CREATE TABLE "dorsale_customer_vault_corporations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "short_name" varchar, "email" varchar, "phone" varchar, "fax" varchar, "www" varchar, "legal_form" varchar, "capital" integer, "immatriculation_number_1" varchar, "immatriculation_number_2" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)   (1.6ms) CREATE TABLE "dorsale_customer_vault_individuals" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "first_name" varchar, "last_name" varchar, "short_name" varchar, "email" varchar, "title" varchar, "twitter" varchar, "www" varchar, "context" text, "phone" varchar, "fax" varchar, "mobile" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)  (1.2ms) 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)   (1.4ms) CREATE INDEX "index_dorsale_customer_vault_links_on_alice_id" ON "dorsale_customer_vault_links" ("alice_id")  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_customer_vault_links_on_alice_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_customer_vault_links_on_alice_id' AND type='index'   (1.4ms) CREATE INDEX "index_dorsale_customer_vault_links_on_alice_type" ON "dorsale_customer_vault_links" ("alice_type")  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_customer_vault_links_on_alice_type' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_customer_vault_links_on_alice_type' AND type='index'   (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_customer_vault_links_on_alice_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_customer_vault_links_on_alice_id' AND type='index'  (1.1ms) CREATE INDEX "index_dorsale_customer_vault_links_on_bob_id" ON "dorsale_customer_vault_links" ("bob_id")  (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_customer_vault_links_on_bob_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_customer_vault_links_on_bob_id' AND type='index'  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_customer_vault_links_on_alice_type' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_customer_vault_links_on_alice_type' AND type='index'   (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_customer_vault_links_on_alice_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_customer_vault_links_on_alice_id' AND type='index'  (1.0ms) CREATE INDEX "index_dorsale_customer_vault_links_on_bob_type" ON "dorsale_customer_vault_links" ("bob_type")  (1.1ms) 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)  (1.1ms) CREATE INDEX "index_dorsale_flyboy_folders_on_folderable_id" ON "dorsale_flyboy_folders" ("folderable_id")  (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_flyboy_folders_on_folderable_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_flyboy_folders_on_folderable_id' AND type='index'  (1.0ms) CREATE INDEX "index_dorsale_flyboy_folders_on_folderable_type" ON "dorsale_flyboy_folders" ("folderable_type")  (1.1ms) 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)  (1.1ms) CREATE INDEX "index_dorsale_flyboy_task_comments_on_task_id" ON "dorsale_flyboy_task_comments" ("task_id")  (1.1ms) 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_id" integer, "owner_type" varchar)  (1.0ms) CREATE INDEX "index_dorsale_flyboy_tasks_on_taskable_id" ON "dorsale_flyboy_tasks" ("taskable_id")  (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_flyboy_tasks_on_taskable_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_flyboy_tasks_on_taskable_id' AND type='index'  (1.0ms) CREATE INDEX "index_dorsale_flyboy_tasks_on_taskable_type" ON "dorsale_flyboy_tasks" ("taskable_type")  (1.1ms) CREATE TABLE "dummy_models" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)  (1.3ms) 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)   (1.2ms) CREATE UNIQUE INDEX "taggings_idx" ON "taggings" ("tag_id", "taggable_id", "taggable_type", "context", "tagger_id", "tagger_type")  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='taggings_idx' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='taggings_idx' AND type='index'   (1.2ms) CREATE INDEX "index_taggings_on_taggable_id_and_taggable_type_and_context" ON "taggings" ("taggable_id", "taggable_type", "context")  (1.3ms) CREATE TABLE "tags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "taggings_count" integer DEFAULT 0)   (1.1ms) CREATE UNIQUE INDEX "index_tags_on_name" ON "tags" ("name")  (1.6ms) 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)   (1.5ms) CREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")  (0.2ms)  SELECT sql FROM sqlite_master WHERE name='index_users_on_email' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_users_on_email' AND type='index'   (1.4ms) CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")  (1.4ms) CREATE TABLE "schema_migrations" ("version" varchar NOT NULL)   (1.1ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")  (0.2ms) SELECT version FROM "schema_migrations"  (1.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20150805134318')  (0.8ms) INSERT INTO "schema_migrations" (version) VALUES ('20150616082916')  (0.8ms) INSERT INTO "schema_migrations" (version) VALUES ('20150624081204')  (0.8ms) INSERT INTO "schema_migrations" (version) VALUES ('20150624081205')  (0.9ms) INSERT INTO "schema_migrations" (version) VALUES ('20150624081206')  (0.8ms) INSERT INTO "schema_migrations" (version) VALUES ('20150624081207')  (0.9ms) INSERT INTO "schema_migrations" (version) VALUES ('20150624081208')  (1.0ms) INSERT INTO "schema_migrations" (version) VALUES ('20150803160334')  (0.8ms) INSERT INTO "schema_migrations" (version) VALUES ('20141010140200')  (0.8ms) INSERT INTO "schema_migrations" (version) VALUES ('20141014072756')  (0.8ms) INSERT INTO "schema_migrations" (version) VALUES ('20150312083147')  (0.8ms) INSERT INTO "schema_migrations" (version) VALUES ('20150616074852')  (0.9ms) INSERT INTO "schema_migrations" (version) VALUES ('20150622075000')  (0.9ms) INSERT INTO "schema_migrations" (version) VALUES ('20150622075038')  (0.8ms) INSERT INTO "schema_migrations" (version) VALUES ('20150622105217')  (0.8ms) INSERT INTO "schema_migrations" (version) VALUES ('20150623093218')  (0.8ms) INSERT INTO "schema_migrations" (version) VALUES ('20150625093326')  (0.9ms) INSERT INTO "schema_migrations" (version) VALUES ('20150625131155')  (0.9ms) INSERT INTO "schema_migrations" (version) VALUES ('20150803152643')  (0.9ms) INSERT INTO "schema_migrations" (version) VALUES ('20150805133509')  (1.2ms) DROP TABLE "dorsale_addresses"  (1.2ms) CREATE 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)   (1.2ms) DROP TABLE "dorsale_alexandrie_attachments"  (1.1ms) CREATE TABLE "dorsale_alexandrie_attachments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "attachable_id" integer, "attachable_type" varchar, "file" varchar)   (1.0ms) DROP TABLE "dorsale_billing_machine_id_cards"  (1.1ms) CREATE 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)   (1.1ms) DROP TABLE "dorsale_billing_machine_invoice_lines"  (1.5ms) CREATE 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)   (0.2ms) select sqlite_version(*)  (1.2ms) CREATE INDEX "index_dorsale_billing_machine_invoice_lines_on_invoice_id" ON "dorsale_billing_machine_invoice_lines" ("invoice_id")  (1.6ms) DROP TABLE "dorsale_billing_machine_invoices"  (1.5ms) CREATE 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_duty" decimal, "vat_amount" decimal, "total_all_taxes" decimal, "advance" decimal, "balance" decimal, "unique_index" integer, "vat_rate" decimal, "paid" boolean, "due_date" date, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "tracking_id" varchar)   (1.2ms) CREATE INDEX "index_dorsale_billing_machine_invoices_on_customer_id" ON "dorsale_billing_machine_invoices" ("customer_id")  (0.2ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_id' AND type='index'   (1.3ms) CREATE INDEX "index_dorsale_billing_machine_invoices_on_customer_type" ON "dorsale_billing_machine_invoices" ("customer_type")  (0.2ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_type' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_type' AND type='index'   (0.2ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_id' AND type='index'  (1.4ms) CREATE INDEX "index_dorsale_billing_machine_invoices_on_id_card_id" ON "dorsale_billing_machine_invoices" ("id_card_id")  (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_invoices_on_id_card_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_invoices_on_id_card_id' AND type='index'  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_type' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_type' AND type='index'   (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_id' AND type='index'  (1.0ms) CREATE INDEX "index_dorsale_billing_machine_invoices_on_payment_term_id" ON "dorsale_billing_machine_invoices" ("payment_term_id")  (1.0ms) DROP TABLE "dorsale_billing_machine_payment_terms"  (1.0ms) 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)   (1.0ms) DROP TABLE "dorsale_billing_machine_quotation_lines"  (1.2ms) 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)   (1.1ms) CREATE INDEX "index_dorsale_billing_machine_quotation_lines_on_quotation_id" ON "dorsale_billing_machine_quotation_lines" ("quotation_id")  (1.2ms) DROP TABLE "dorsale_billing_machine_quotations"  (1.0ms) 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_duty" decimal, "vat_amount" decimal, "total_all_taxes" decimal, "unique_index" integer, "vat_rate" decimal, "comments" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "expires_at" date, "tracking_id" varchar)  (1.0ms) CREATE INDEX "index_dorsale_billing_machine_quotations_on_customer_id" ON "dorsale_billing_machine_quotations" ("customer_id")  (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_id' AND type='index'  (1.0ms) CREATE INDEX "index_dorsale_billing_machine_quotations_on_customer_type" ON "dorsale_billing_machine_quotations" ("customer_type")  (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_type' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_type' AND type='index'  (0.2ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_id' AND type='index'   (1.2ms) CREATE INDEX "index_dorsale_billing_machine_quotations_on_id_card_id" ON "dorsale_billing_machine_quotations" ("id_card_id")  (0.2ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_quotations_on_id_card_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_quotations_on_id_card_id' AND type='index'   (0.2ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_type' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_type' AND type='index'  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_id' AND type='index'   (1.3ms) CREATE INDEX "index_dorsale_billing_machine_quotations_on_payment_term_id" ON "dorsale_billing_machine_quotations" ("payment_term_id")  (1.3ms) DROP TABLE "dorsale_comments"  (1.1ms) CREATE 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)  (1.0ms) DROP TABLE "dorsale_customer_vault_corporations"  (1.1ms) CREATE TABLE "dorsale_customer_vault_corporations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "short_name" varchar, "email" varchar, "phone" varchar, "fax" varchar, "www" varchar, "legal_form" varchar, "capital" integer, "immatriculation_number_1" varchar, "immatriculation_number_2" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)  (1.0ms) DROP TABLE "dorsale_customer_vault_individuals"  (1.2ms) CREATE TABLE "dorsale_customer_vault_individuals" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "first_name" varchar, "last_name" varchar, "short_name" varchar, "email" varchar, "title" varchar, "twitter" varchar, "www" varchar, "context" text, "phone" varchar, "fax" varchar, "mobile" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)  (1.6ms) DROP TABLE "dorsale_customer_vault_links"  (1.4ms) 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)  (1.2ms) CREATE INDEX "index_dorsale_customer_vault_links_on_alice_id" ON "dorsale_customer_vault_links" ("alice_id")  (0.2ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_customer_vault_links_on_alice_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_customer_vault_links_on_alice_id' AND type='index'  (6.3ms) CREATE INDEX "index_dorsale_customer_vault_links_on_alice_type" ON "dorsale_customer_vault_links" ("alice_type")  (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_customer_vault_links_on_alice_type' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_customer_vault_links_on_alice_type' AND type='index'  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_customer_vault_links_on_alice_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_customer_vault_links_on_alice_id' AND type='index'   (1.3ms) CREATE INDEX "index_dorsale_customer_vault_links_on_bob_id" ON "dorsale_customer_vault_links" ("bob_id")  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_customer_vault_links_on_bob_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_customer_vault_links_on_bob_id' AND type='index'   (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_customer_vault_links_on_alice_type' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_customer_vault_links_on_alice_type' AND type='index'  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_customer_vault_links_on_alice_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_customer_vault_links_on_alice_id' AND type='index'   (1.1ms) CREATE INDEX "index_dorsale_customer_vault_links_on_bob_type" ON "dorsale_customer_vault_links" ("bob_type")  (1.3ms) DROP TABLE "dorsale_flyboy_folders"  (1.1ms) 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)  (1.1ms) CREATE INDEX "index_dorsale_flyboy_folders_on_folderable_id" ON "dorsale_flyboy_folders" ("folderable_id")  (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_flyboy_folders_on_folderable_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_flyboy_folders_on_folderable_id' AND type='index'  (1.1ms) CREATE INDEX "index_dorsale_flyboy_folders_on_folderable_type" ON "dorsale_flyboy_folders" ("folderable_type")  (1.0ms) DROP TABLE "dorsale_flyboy_task_comments"  (1.1ms) 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)   (0.9ms) CREATE INDEX "index_dorsale_flyboy_task_comments_on_task_id" ON "dorsale_flyboy_task_comments" ("task_id")  (1.1ms) DROP TABLE "dorsale_flyboy_tasks"  (1.2ms) 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_id" integer, "owner_type" varchar)  (1.0ms) CREATE INDEX "index_dorsale_flyboy_tasks_on_taskable_id" ON "dorsale_flyboy_tasks" ("taskable_id")  (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_flyboy_tasks_on_taskable_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_flyboy_tasks_on_taskable_id' AND type='index'  (1.3ms) CREATE INDEX "index_dorsale_flyboy_tasks_on_taskable_type" ON "dorsale_flyboy_tasks" ("taskable_type")  (1.1ms) DROP TABLE "dummy_models"  (1.1ms) CREATE TABLE "dummy_models" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)   (1.4ms) DROP TABLE "taggings"  (1.2ms) 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)   (1.1ms) CREATE UNIQUE INDEX "taggings_idx" ON "taggings" ("tag_id", "taggable_id", "taggable_type", "context", "tagger_id", "tagger_type")  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='taggings_idx' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='taggings_idx' AND type='index'   (1.0ms) CREATE INDEX "index_taggings_on_taggable_id_and_taggable_type_and_context" ON "taggings" ("taggable_id", "taggable_type", "context")  (1.1ms) DROP TABLE "tags"  (1.5ms) CREATE TABLE "tags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "taggings_count" integer DEFAULT 0)  (1.4ms) CREATE UNIQUE INDEX "index_tags_on_name" ON "tags" ("name")  (1.3ms) DROP TABLE "users"  (1.4ms) 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)   (1.4ms) CREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_users_on_email' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_users_on_email' AND type='index'   (1.3ms) CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")  (0.2ms) SELECT version FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations"  (1.1ms) DELETE FROM "dorsale_addresses";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'dorsale_addresses';  (0.8ms) DELETE FROM "dorsale_alexandrie_attachments";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'dorsale_alexandrie_attachments';  (0.8ms) DELETE FROM "dorsale_billing_machine_id_cards";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'dorsale_billing_machine_id_cards';  (0.8ms) DELETE FROM "dorsale_billing_machine_invoice_lines";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'dorsale_billing_machine_invoice_lines';  (0.9ms) DELETE FROM "dorsale_billing_machine_invoices";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'dorsale_billing_machine_invoices';  (0.9ms) DELETE FROM "dorsale_billing_machine_payment_terms";  (0.3ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'dorsale_billing_machine_payment_terms';  (1.1ms) DELETE FROM "dorsale_billing_machine_quotation_lines";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'dorsale_billing_machine_quotation_lines';  (1.1ms) DELETE FROM "dorsale_billing_machine_quotations";  (0.2ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'dorsale_billing_machine_quotations';  (0.9ms) DELETE FROM "dorsale_comments";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'dorsale_comments';  (0.8ms) DELETE FROM "dorsale_customer_vault_corporations";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'dorsale_customer_vault_corporations';  (0.8ms) DELETE FROM "dorsale_customer_vault_individuals";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'dorsale_customer_vault_individuals';  (1.0ms) DELETE FROM "dorsale_customer_vault_links";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'dorsale_customer_vault_links';  (0.9ms) DELETE FROM "dorsale_flyboy_folders";  (0.2ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'dorsale_flyboy_folders';  (1.0ms) DELETE FROM "dorsale_flyboy_task_comments";  (0.2ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'dorsale_flyboy_task_comments';  (1.1ms) DELETE FROM "dorsale_flyboy_tasks";  (0.2ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'dorsale_flyboy_tasks';  (0.9ms) DELETE FROM "dummy_models";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'dummy_models';  (0.9ms) DELETE FROM "taggings";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'taggings';  (0.8ms) DELETE FROM "tags";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'tags';  (0.9ms) DELETE FROM "users";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'users';  (0.1ms) begin transaction User Exists (0.2ms) SELECT 1 AS one FROM "users" WHERE "users"."email" = 'demo@agilidee.com' LIMIT 1  (0.1ms) rollback transaction  (0.1ms) begin transaction SQL (0.4ms) INSERT INTO "dorsale_billing_machine_id_cards" ("id_card_name", "entity_name", "created_at", "updated_at") VALUES (?, ?, ?, ?) [["id_card_name", "Bidule Corp"], ["entity_name", "Bidule Corp"], ["created_at", "2015-09-10 14:09:25.649438"], ["updated_at", "2015-09-10 14:09:25.649438"]]  (0.9ms) commit transaction  (0.1ms) begin transaction SQL (0.3ms) INSERT INTO "dorsale_billing_machine_payment_terms" ("label", "created_at", "updated_at") VALUES (?, ?, ?) [["label", "A réception"], ["created_at", "2015-09-10 14:09:25.657244"], ["updated_at", "2015-09-10 14:09:25.657244"]]  (0.9ms) commit transaction  (0.1ms) begin transaction SQL (0.4ms) INSERT INTO "dorsale_customer_vault_corporations" ("name", "email", "www", "phone", "fax", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?) [["name", "agilidée"], ["email", "contact@agilidee.com"], ["www", "http://www.agilidee.com/"], ["phone", "04 91 xx xx xx"], ["fax", "04 91 xx xx xx"], ["created_at", "2015-09-10 14:09:25.760965"], ["updated_at", "2015-09-10 14:09:25.760965"]] SQL (0.1ms) INSERT INTO "dorsale_addresses" ("city", "country", "addressable_type", "addressable_id", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?) [["city", "Marseille"], ["country", "France"], ["addressable_type", "Dorsale::CustomerVault::Corporation"], ["addressable_id", 1], ["created_at", "2015-09-10 14:09:25.762991"], ["updated_at", "2015-09-10 14:09:25.762991"]] ActsAsTaggableOn::Tag Load (0.1ms) SELECT "tags".* FROM "tags" WHERE (LOWER(name) = LOWER('client')) ActsAsTaggableOn::Tag Exists (0.1ms) SELECT 1 AS one FROM "tags" WHERE "tags"."name" = 'client' LIMIT 1 SQL (0.2ms) INSERT INTO "tags" ("name") VALUES (?) [["name", "client"]] ActsAsTaggableOn::Tag Load (0.2ms) SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = ? AND "taggings"."taggable_type" = ? AND (taggings.context = 'tags' AND taggings.tagger_id IS NULL) ORDER BY "tags"."name" ASC [["taggable_id", 1], ["taggable_type", "Dorsale::CustomerVault::Corporation"]] ActsAsTaggableOn::Tagging Exists (0.1ms) SELECT 1 AS one FROM "taggings" WHERE ("taggings"."tag_id" = 1 AND "taggings"."taggable_type" = 'Dorsale::CustomerVault::Corporation' AND "taggings"."taggable_id" = 1 AND "taggings"."context" = 'tags' AND "taggings"."tagger_id" IS NULL AND "taggings"."tagger_type" IS NULL) LIMIT 1 SQL (0.2ms) INSERT INTO "taggings" ("tag_id", "context", "taggable_id", "taggable_type", "created_at") VALUES (?, ?, ?, ?, ?) [["tag_id", 1], ["context", "tags"], ["taggable_id", 1], ["taggable_type", "Dorsale::CustomerVault::Corporation"], ["created_at", "2015-09-10 14:09:25.869703"]] ActsAsTaggableOn::Tag Load (0.1ms) SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1 [["id", 1]] SQL (0.1ms) UPDATE "tags" SET "taggings_count" = COALESCE("taggings_count", 0) + 1 WHERE "tags"."id" = ? [["id", 1]]  (1.1ms) commit transaction  (0.1ms) begin transaction  (0.2ms) SELECT "dorsale_billing_machine_invoices"."unique_index" FROM "dorsale_billing_machine_invoices" SQL (0.4ms) INSERT INTO "dorsale_billing_machine_invoices" ("label", "id_card_id", "customer_id", "customer_type", "payment_term_id", "date", "due_date", "vat_rate", "advance", "paid", "total_duty", "vat_amount", "total_all_taxes", "balance", "created_at", "updated_at", "unique_index", "tracking_id") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [["label", "Commande de bombons"], ["id_card_id", 1], ["customer_id", 1], ["customer_type", "Dorsale::CustomerVault::Corporation"], ["payment_term_id", 1], ["date", "2015-09-10"], ["due_date", "2015-10-10"], ["vat_rate", 20.0], ["advance", 0.0], ["paid", "f"], ["total_duty", 0.0], ["vat_amount", 0.0], ["total_all_taxes", 0.0], ["balance", 0.0], ["created_at", "2015-09-10 14:09:25.937918"], ["updated_at", "2015-09-10 14:09:25.937918"], ["unique_index", 1], ["tracking_id", "2015-01"]] SQL (0.2ms) INSERT INTO "dorsale_billing_machine_invoice_lines" ("label", "quantity", "unit_price", "invoice_id", "total", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?) [["label", "Bombons en sucre"], ["quantity", 3.2], ["unit_price", 14.0], ["invoice_id", 1], ["total", 44.8], ["created_at", "2015-09-10 14:09:25.941141"], ["updated_at", "2015-09-10 14:09:25.941141"]] Dorsale::BillingMachine::Invoice Load (0.1ms) SELECT "dorsale_billing_machine_invoices".* FROM "dorsale_billing_machine_invoices" WHERE "dorsale_billing_machine_invoices"."id" = ? LIMIT 1 [["id", 1]] Dorsale::BillingMachine::IdCard Load (0.1ms) SELECT "dorsale_billing_machine_id_cards".* FROM "dorsale_billing_machine_id_cards" WHERE "dorsale_billing_machine_id_cards"."id" = ? LIMIT 1 [["id", 1]]  (0.1ms) SELECT "dorsale_billing_machine_invoice_lines"."total" FROM "dorsale_billing_machine_invoice_lines" WHERE "dorsale_billing_machine_invoice_lines"."invoice_id" = ? ORDER BY "dorsale_billing_machine_invoice_lines"."created_at" ASC [["invoice_id", 1]] SQL (0.4ms) UPDATE "dorsale_billing_machine_invoices" SET "total_duty" = ?, "vat_amount" = ?, "total_all_taxes" = ?, "balance" = ?, "updated_at" = ? WHERE "dorsale_billing_machine_invoices"."id" = ? [["total_duty", 44.8], ["vat_amount", 8.96], ["total_all_taxes", 53.76], ["balance", 53.76], ["updated_at", "2015-09-10 14:09:25.946197"], ["id", 1]]  (1.3ms) commit transaction  (0.1ms) begin transaction SQL (0.3ms) INSERT INTO "dorsale_customer_vault_corporations" ("name", "email", "phone", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?) [["name", "Truc Bidule SARL"], ["email", "truc@bidule.com"], ["phone", "04 91 xx xx xx"], ["created_at", "2015-09-10 14:09:25.954468"], ["updated_at", "2015-09-10 14:09:25.954468"]] SQL (0.1ms) INSERT INTO "dorsale_addresses" ("city", "country", "addressable_type", "addressable_id", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?) [["city", "Marseille"], ["country", "France"], ["addressable_type", "Dorsale::CustomerVault::Corporation"], ["addressable_id", 2], ["created_at", "2015-09-10 14:09:25.956223"], ["updated_at", "2015-09-10 14:09:25.956223"]] ActsAsTaggableOn::Tag Load (0.1ms) SELECT "tags".* FROM "tags" WHERE (LOWER(name) = LOWER('prospect') OR LOWER(name) = LOWER('certain')) ActsAsTaggableOn::Tag Exists (0.1ms) SELECT 1 AS one FROM "tags" WHERE "tags"."name" = 'prospect' LIMIT 1 SQL (0.1ms) INSERT INTO "tags" ("name") VALUES (?) [["name", "prospect"]] ActsAsTaggableOn::Tag Exists (0.1ms) SELECT 1 AS one FROM "tags" WHERE "tags"."name" = 'certain' LIMIT 1 SQL (0.0ms) INSERT INTO "tags" ("name") VALUES (?) [["name", "certain"]] ActsAsTaggableOn::Tag Load (0.0ms) SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = ? AND "taggings"."taggable_type" = ? AND (taggings.context = 'tags' AND taggings.tagger_id IS NULL) ORDER BY "tags"."name" ASC [["taggable_id", 2], ["taggable_type", "Dorsale::CustomerVault::Corporation"]] ActsAsTaggableOn::Tagging Exists (0.1ms) SELECT 1 AS one FROM "taggings" WHERE ("taggings"."tag_id" = 2 AND "taggings"."taggable_type" = 'Dorsale::CustomerVault::Corporation' AND "taggings"."taggable_id" = 2 AND "taggings"."context" = 'tags' AND "taggings"."tagger_id" IS NULL AND "taggings"."tagger_type" IS NULL) LIMIT 1 SQL (0.1ms) INSERT INTO "taggings" ("tag_id", "context", "taggable_id", "taggable_type", "created_at") VALUES (?, ?, ?, ?, ?) [["tag_id", 2], ["context", "tags"], ["taggable_id", 2], ["taggable_type", "Dorsale::CustomerVault::Corporation"], ["created_at", "2015-09-10 14:09:25.964172"]] ActsAsTaggableOn::Tag Load (0.0ms) SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1 [["id", 2]] SQL (0.0ms) UPDATE "tags" SET "taggings_count" = COALESCE("taggings_count", 0) + 1 WHERE "tags"."id" = ? [["id", 2]] ActsAsTaggableOn::Tagging Exists (0.2ms) SELECT 1 AS one FROM "taggings" WHERE ("taggings"."tag_id" = 3 AND "taggings"."taggable_type" = 'Dorsale::CustomerVault::Corporation' AND "taggings"."taggable_id" = 2 AND "taggings"."context" = 'tags' AND "taggings"."tagger_id" IS NULL AND "taggings"."tagger_type" IS NULL) LIMIT 1 SQL (0.1ms) INSERT INTO "taggings" ("tag_id", "context", "taggable_id", "taggable_type", "created_at") VALUES (?, ?, ?, ?, ?) [["tag_id", 3], ["context", "tags"], ["taggable_id", 2], ["taggable_type", "Dorsale::CustomerVault::Corporation"], ["created_at", "2015-09-10 14:09:25.969235"]] ActsAsTaggableOn::Tag Load (0.1ms) SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1 [["id", 3]] SQL (0.0ms) UPDATE "tags" SET "taggings_count" = COALESCE("taggings_count", 0) + 1 WHERE "tags"."id" = ? [["id", 3]]  (1.2ms) commit transaction  (0.1ms) begin transaction Dorsale::CustomerVault::Corporation Load (0.2ms) SELECT "dorsale_customer_vault_corporations".* FROM "dorsale_customer_vault_corporations" WHERE "dorsale_customer_vault_corporations"."id" = ? LIMIT 1 [["id", 2]] User Exists (0.1ms) SELECT 1 AS one FROM "users" WHERE "users"."email" = 'demo@agilidee.com' LIMIT 1 SQL (0.3ms) INSERT INTO "dorsale_comments" ("text", "author_type", "commentable_id", "commentable_type", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?) [["text", "Je viens d'avoir cette boite au téléphone, il faut leur faire un devis."], ["author_type", "User"], ["commentable_id", 2], ["commentable_type", "Dorsale::CustomerVault::Corporation"], ["created_at", "2015-09-10 14:09:25.989759"], ["updated_at", "2015-09-10 14:09:25.989759"]]  (1.0ms) commit transaction  (0.1ms) begin transaction  (0.2ms) SELECT "dorsale_billing_machine_quotations"."unique_index" FROM "dorsale_billing_machine_quotations" SQL (0.4ms) INSERT INTO "dorsale_billing_machine_quotations" ("label", "id_card_id", "customer_id", "customer_type", "payment_term_id", "date", "expires_at", "vat_rate", "total_duty", "vat_amount", "total_all_taxes", "created_at", "updated_at", "unique_index", "tracking_id") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [["label", "Application sur mesure"], ["id_card_id", 1], ["customer_id", 2], ["customer_type", "Dorsale::CustomerVault::Corporation"], ["payment_term_id", 1], ["date", "2015-09-10"], ["expires_at", "2015-10-10"], ["vat_rate", 20.0], ["total_duty", 0.0], ["vat_amount", 0.0], ["total_all_taxes", 0.0], ["created_at", "2015-09-10 14:09:26.033844"], ["updated_at", "2015-09-10 14:09:26.033844"], ["unique_index", 1], ["tracking_id", "2015-01"]] SQL (0.2ms) INSERT INTO "dorsale_billing_machine_quotation_lines" ("label", "quantity", "unit_price", "quotation_id", "total", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?) [["label", "Développement"], ["quantity", 14.0], ["unit_price", 750.0], ["quotation_id", 1], ["total", 10500.0], ["created_at", "2015-09-10 14:09:26.038572"], ["updated_at", "2015-09-10 14:09:26.038572"]] Dorsale::BillingMachine::Quotation Load (0.1ms) SELECT "dorsale_billing_machine_quotations".* FROM "dorsale_billing_machine_quotations" WHERE "dorsale_billing_machine_quotations"."id" = ? LIMIT 1 [["id", 1]] Dorsale::BillingMachine::IdCard Load (0.1ms) SELECT "dorsale_billing_machine_id_cards".* FROM "dorsale_billing_machine_id_cards" WHERE "dorsale_billing_machine_id_cards"."id" = ? LIMIT 1 [["id", 1]]  (0.1ms) SELECT "dorsale_billing_machine_quotation_lines"."total" FROM "dorsale_billing_machine_quotation_lines" WHERE "dorsale_billing_machine_quotation_lines"."quotation_id" = ? ORDER BY "dorsale_billing_machine_quotation_lines"."created_at" ASC [["quotation_id", 1]] SQL (0.4ms) UPDATE "dorsale_billing_machine_quotations" SET "total_duty" = ?, "vat_amount" = ?, "total_all_taxes" = ?, "updated_at" = ? WHERE "dorsale_billing_machine_quotations"."id" = ? [["total_duty", 10500.0], ["vat_amount", 2100.0], ["total_all_taxes", 12600.0], ["updated_at", "2015-09-10 14:09:26.045963"], ["id", 1]] SQL (0.1ms) INSERT INTO "dorsale_billing_machine_quotation_lines" ("label", "quantity", "unit_price", "quotation_id", "total", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?) [["label", "Gestion de projet"], ["quantity", 5.0], ["unit_price", 1200.0], ["quotation_id", 1], ["total", 6000.0], ["created_at", "2015-09-10 14:09:26.049605"], ["updated_at", "2015-09-10 14:09:26.049605"]] Dorsale::BillingMachine::Quotation Load (0.1ms) SELECT "dorsale_billing_machine_quotations".* FROM "dorsale_billing_machine_quotations" WHERE "dorsale_billing_machine_quotations"."id" = ? LIMIT 1 [["id", 1]] Dorsale::BillingMachine::IdCard Load (0.0ms) SELECT "dorsale_billing_machine_id_cards".* FROM "dorsale_billing_machine_id_cards" WHERE "dorsale_billing_machine_id_cards"."id" = ? LIMIT 1 [["id", 1]]  (0.1ms) SELECT "dorsale_billing_machine_quotation_lines"."total" FROM "dorsale_billing_machine_quotation_lines" WHERE "dorsale_billing_machine_quotation_lines"."quotation_id" = ? ORDER BY "dorsale_billing_machine_quotation_lines"."created_at" ASC [["quotation_id", 1]] SQL (0.1ms) UPDATE "dorsale_billing_machine_quotations" SET "total_duty" = ?, "vat_amount" = ?, "total_all_taxes" = ?, "updated_at" = ? WHERE "dorsale_billing_machine_quotations"."id" = ? [["total_duty", 16500.0], ["vat_amount", 3300.0], ["total_all_taxes", 19800.0], ["updated_at", "2015-09-10 14:09:26.055005"], ["id", 1]]  (1.5ms) commit transaction  (0.1ms) begin transaction SQL (0.4ms) INSERT INTO "dorsale_customer_vault_individuals" ("first_name", "last_name", "email", "phone", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?) [["first_name", "Henri"], ["last_name", "MARTIN"], ["email", "henri.martin@example.com"], ["phone", "04 91 xx xx xx"], ["created_at", "2015-09-10 14:09:26.081338"], ["updated_at", "2015-09-10 14:09:26.081338"]] SQL (0.1ms) INSERT INTO "dorsale_addresses" ("city", "country", "addressable_type", "addressable_id", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?) [["city", "Marseille"], ["country", "France"], ["addressable_type", "Dorsale::CustomerVault::Individual"], ["addressable_id", 1], ["created_at", "2015-09-10 14:09:26.083761"], ["updated_at", "2015-09-10 14:09:26.083761"]] ActsAsTaggableOn::Tag Load (0.1ms) SELECT "tags".* FROM "tags" WHERE (LOWER(name) = LOWER('prospect') OR LOWER(name) = LOWER('potentiel')) ActsAsTaggableOn::Tag Exists (0.1ms) SELECT 1 AS one FROM "tags" WHERE "tags"."name" = 'potentiel' LIMIT 1 SQL (0.1ms) INSERT INTO "tags" ("name") VALUES (?) [["name", "potentiel"]] ActsAsTaggableOn::Tag Load (0.1ms) SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = ? AND "taggings"."taggable_type" = ? AND (taggings.context = 'tags' AND taggings.tagger_id IS NULL) ORDER BY "tags"."name" ASC [["taggable_id", 1], ["taggable_type", "Dorsale::CustomerVault::Individual"]] ActsAsTaggableOn::Tagging Exists (0.1ms) SELECT 1 AS one FROM "taggings" WHERE ("taggings"."tag_id" = 2 AND "taggings"."taggable_type" = 'Dorsale::CustomerVault::Individual' AND "taggings"."taggable_id" = 1 AND "taggings"."context" = 'tags' AND "taggings"."tagger_id" IS NULL AND "taggings"."tagger_type" IS NULL) LIMIT 1 SQL (0.1ms) INSERT INTO "taggings" ("tag_id", "context", "taggable_id", "taggable_type", "created_at") VALUES (?, ?, ?, ?, ?) [["tag_id", 2], ["context", "tags"], ["taggable_id", 1], ["taggable_type", "Dorsale::CustomerVault::Individual"], ["created_at", "2015-09-10 14:09:26.093005"]] ActsAsTaggableOn::Tag Load (0.1ms) SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1 [["id", 2]] SQL (0.6ms) UPDATE "tags" SET "taggings_count" = COALESCE("taggings_count", 0) + 1 WHERE "tags"."id" = ? [["id", 2]] ActsAsTaggableOn::Tagging Exists (0.1ms) SELECT 1 AS one FROM "taggings" WHERE ("taggings"."tag_id" = 4 AND "taggings"."taggable_type" = 'Dorsale::CustomerVault::Individual' AND "taggings"."taggable_id" = 1 AND "taggings"."context" = 'tags' AND "taggings"."tagger_id" IS NULL AND "taggings"."tagger_type" IS NULL) LIMIT 1 SQL (0.1ms) INSERT INTO "taggings" ("tag_id", "context", "taggable_id", "taggable_type", "created_at") VALUES (?, ?, ?, ?, ?) [["tag_id", 4], ["context", "tags"], ["taggable_id", 1], ["taggable_type", "Dorsale::CustomerVault::Individual"], ["created_at", "2015-09-10 14:09:26.099848"]] ActsAsTaggableOn::Tag Load (0.1ms) SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1 [["id", 4]] SQL (0.0ms) UPDATE "tags" SET "taggings_count" = COALESCE("taggings_count", 0) + 1 WHERE "tags"."id" = ? [["id", 4]]  (1.3ms) commit transaction  (0.1ms) begin transaction SQL (0.3ms) INSERT INTO "dorsale_customer_vault_individuals" ("first_name", "last_name", "email", "phone", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?) [["first_name", "Jean"], ["last_name", "DUPONT"], ["email", "jean.dupon@example.com"], ["phone", "04 91 xx xx xx"], ["created_at", "2015-09-10 14:09:26.110912"], ["updated_at", "2015-09-10 14:09:26.110912"]] SQL (0.1ms) INSERT INTO "dorsale_addresses" ("city", "country", "addressable_type", "addressable_id", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?) [["city", "Marseille"], ["country", "France"], ["addressable_type", "Dorsale::CustomerVault::Individual"], ["addressable_id", 2], ["created_at", "2015-09-10 14:09:26.113320"], ["updated_at", "2015-09-10 14:09:26.113320"]] ActsAsTaggableOn::Tag Load (6.4ms) SELECT "tags".* FROM "tags" WHERE (LOWER(name) = LOWER('développeur') OR LOWER(name) = LOWER('rails') OR LOWER(name) = LOWER('freelance')) ActsAsTaggableOn::Tag Exists (0.1ms) SELECT 1 AS one FROM "tags" WHERE "tags"."name" = 'développeur' LIMIT 1 SQL (0.1ms) INSERT INTO "tags" ("name") VALUES (?) [["name", "développeur"]] ActsAsTaggableOn::Tag Exists (0.1ms) SELECT 1 AS one FROM "tags" WHERE "tags"."name" = 'rails' LIMIT 1 SQL (0.1ms) INSERT INTO "tags" ("name") VALUES (?) [["name", "rails"]] ActsAsTaggableOn::Tag Exists (0.1ms) SELECT 1 AS one FROM "tags" WHERE "tags"."name" = 'freelance' LIMIT 1 SQL (0.1ms) INSERT INTO "tags" ("name") VALUES (?) [["name", "freelance"]] ActsAsTaggableOn::Tag Load (0.1ms) SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = ? AND "taggings"."taggable_type" = ? AND (taggings.context = 'tags' AND taggings.tagger_id IS NULL) ORDER BY "tags"."name" ASC [["taggable_id", 2], ["taggable_type", "Dorsale::CustomerVault::Individual"]] ActsAsTaggableOn::Tagging Exists (0.1ms) SELECT 1 AS one FROM "taggings" WHERE ("taggings"."tag_id" = 5 AND "taggings"."taggable_type" = 'Dorsale::CustomerVault::Individual' AND "taggings"."taggable_id" = 2 AND "taggings"."context" = 'tags' AND "taggings"."tagger_id" IS NULL AND "taggings"."tagger_type" IS NULL) LIMIT 1 SQL (0.2ms) INSERT INTO "taggings" ("tag_id", "context", "taggable_id", "taggable_type", "created_at") VALUES (?, ?, ?, ?, ?) [["tag_id", 5], ["context", "tags"], ["taggable_id", 2], ["taggable_type", "Dorsale::CustomerVault::Individual"], ["created_at", "2015-09-10 14:09:26.135724"]] ActsAsTaggableOn::Tag Load (0.0ms) SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1 [["id", 5]] SQL (0.0ms) UPDATE "tags" SET "taggings_count" = COALESCE("taggings_count", 0) + 1 WHERE "tags"."id" = ? [["id", 5]] ActsAsTaggableOn::Tagging Exists (0.1ms) SELECT 1 AS one FROM "taggings" WHERE ("taggings"."tag_id" = 6 AND "taggings"."taggable_type" = 'Dorsale::CustomerVault::Individual' AND "taggings"."taggable_id" = 2 AND "taggings"."context" = 'tags' AND "taggings"."tagger_id" IS NULL AND "taggings"."tagger_type" IS NULL) LIMIT 1 SQL (0.1ms) INSERT INTO "taggings" ("tag_id", "context", "taggable_id", "taggable_type", "created_at") VALUES (?, ?, ?, ?, ?) [["tag_id", 6], ["context", "tags"], ["taggable_id", 2], ["taggable_type", "Dorsale::CustomerVault::Individual"], ["created_at", "2015-09-10 14:09:26.142608"]] ActsAsTaggableOn::Tag Load (0.1ms) SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1 [["id", 6]] SQL (0.0ms) UPDATE "tags" SET "taggings_count" = COALESCE("taggings_count", 0) + 1 WHERE "tags"."id" = ? [["id", 6]] ActsAsTaggableOn::Tagging Exists (0.1ms) SELECT 1 AS one FROM "taggings" WHERE ("taggings"."tag_id" = 7 AND "taggings"."taggable_type" = 'Dorsale::CustomerVault::Individual' AND "taggings"."taggable_id" = 2 AND "taggings"."context" = 'tags' AND "taggings"."tagger_id" IS NULL AND "taggings"."tagger_type" IS NULL) LIMIT 1 SQL (0.1ms) INSERT INTO "taggings" ("tag_id", "context", "taggable_id", "taggable_type", "created_at") VALUES (?, ?, ?, ?, ?) [["tag_id", 7], ["context", "tags"], ["taggable_id", 2], ["taggable_type", "Dorsale::CustomerVault::Individual"], ["created_at", "2015-09-10 14:09:26.148813"]] ActsAsTaggableOn::Tag Load (0.0ms) SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1 [["id", 7]] SQL (0.0ms) UPDATE "tags" SET "taggings_count" = COALESCE("taggings_count", 0) + 1 WHERE "tags"."id" = ? [["id", 7]]  (1.7ms) commit transaction  (0.1ms) begin transaction Dorsale::CustomerVault::Individual Load (0.3ms) SELECT "dorsale_customer_vault_individuals".* FROM "dorsale_customer_vault_individuals" WHERE "dorsale_customer_vault_individuals"."id" = ? LIMIT 1 [["id", 2]] User Exists (0.1ms) SELECT 1 AS one FROM "users" WHERE "users"."email" = 'demo@agilidee.com' LIMIT 1 SQL (0.6ms) INSERT INTO "dorsale_comments" ("text", "author_type", "commentable_id", "commentable_type", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?) [["text", "Développeur, premier contact pour mutualiser un projet."], ["author_type", "User"], ["commentable_id", 2], ["commentable_type", "Dorsale::CustomerVault::Individual"], ["created_at", "2015-09-10 14:09:26.165036"], ["updated_at", "2015-09-10 14:09:26.165036"]]  (0.9ms) commit transaction  (0.1ms) begin transaction  (0.2ms) SELECT COUNT(*) FROM "dorsale_flyboy_folders" WHERE (DATE(created_at) = '2015-09-10') SQL (0.3ms) INSERT INTO "dorsale_flyboy_folders" ("name", "description", "status", "progress", "version", "created_at", "updated_at", "tracking") VALUES (?, ?, ?, ?, ?, ?, ?, ?) [["name", "Dorsale v2"], ["description", "Tâches pour la version 2 de Dorsale"], ["status", "open"], ["progress", 0], ["version", 1], ["created_at", "2015-09-10 14:09:26.203725"], ["updated_at", "2015-09-10 14:09:26.203725"], ["tracking", "150910-1"]]  (0.9ms) commit transaction  (0.1ms) begin transaction Dorsale::Flyboy::Folder Load (0.8ms) SELECT "dorsale_flyboy_folders".* FROM "dorsale_flyboy_folders" WHERE "dorsale_flyboy_folders"."id" = ? LIMIT 1 [["id", 1]] SQL (0.4ms) INSERT INTO "dorsale_flyboy_tasks" ("name", "description", "taskable_id", "taskable_type", "done", "reminder", "term", "progress", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [["name", "Traduction"], ["description", "Traduire en français et en anglais"], ["taskable_id", 1], ["taskable_type", "Dorsale::Flyboy::Folder"], ["done", "f"], ["reminder", "2015-09-17"], ["term", "2015-10-10"], ["progress", 0], ["created_at", "2015-09-10 14:09:26.231796"], ["updated_at", "2015-09-10 14:09:26.231796"]]  (0.1ms) SELECT COUNT(*) FROM "dorsale_flyboy_tasks" WHERE "dorsale_flyboy_tasks"."taskable_id" = ? AND "dorsale_flyboy_tasks"."taskable_type" = ? [["taskable_id", 1], ["taskable_type", "Dorsale::Flyboy::Folder"]]  (0.1ms) SELECT SUM("dorsale_flyboy_tasks"."progress") FROM "dorsale_flyboy_tasks" WHERE "dorsale_flyboy_tasks"."taskable_id" = ? AND "dorsale_flyboy_tasks"."taskable_type" = ? [["taskable_id", 1], ["taskable_type", "Dorsale::Flyboy::Folder"]]  (0.1ms) SELECT COUNT(*) FROM "dorsale_flyboy_tasks" WHERE "dorsale_flyboy_tasks"."taskable_id" = ? AND "dorsale_flyboy_tasks"."taskable_type" = ? [["taskable_id", 1], ["taskable_type", "Dorsale::Flyboy::Folder"]] SQL (0.2ms) UPDATE "dorsale_flyboy_folders" SET "version" = ?, "updated_at" = ? WHERE "dorsale_flyboy_folders"."id" = ? [["version", 2], ["updated_at", "2015-09-10 14:09:26.238886"], ["id", 1]]  (1.0ms) commit transaction  (0.1ms) begin transaction User Exists (0.1ms) SELECT 1 AS one FROM "users" WHERE "users"."email" = 'demo@agilidee.com' LIMIT 1 SQL (0.3ms) INSERT INTO "dorsale_flyboy_task_comments" ("description", "progress", "author_type", "task_id", "date", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?) [["description", "Traduction française terminée"], ["progress", 50], ["author_type", "User"], ["task_id", 1], ["date", "2015-09-10 14:09:26.268226"], ["created_at", "2015-09-10 14:09:26.270744"], ["updated_at", "2015-09-10 14:09:26.270744"]] SQL (0.1ms) UPDATE "dorsale_flyboy_tasks" SET "progress" = ?, "updated_at" = ? WHERE "dorsale_flyboy_tasks"."id" = ? [["progress", 50], ["updated_at", "2015-09-10 14:09:26.272454"], ["id", 1]]  (0.0ms) SELECT COUNT(*) FROM "dorsale_flyboy_tasks" WHERE "dorsale_flyboy_tasks"."taskable_id" = ? AND "dorsale_flyboy_tasks"."taskable_type" = ? [["taskable_id", 1], ["taskable_type", "Dorsale::Flyboy::Folder"]]  (0.0ms) SELECT SUM("dorsale_flyboy_tasks"."progress") FROM "dorsale_flyboy_tasks" WHERE "dorsale_flyboy_tasks"."taskable_id" = ? AND "dorsale_flyboy_tasks"."taskable_type" = ? [["taskable_id", 1], ["taskable_type", "Dorsale::Flyboy::Folder"]]  (0.0ms) SELECT COUNT(*) FROM "dorsale_flyboy_tasks" WHERE "dorsale_flyboy_tasks"."taskable_id" = ? AND "dorsale_flyboy_tasks"."taskable_type" = ? [["taskable_id", 1], ["taskable_type", "Dorsale::Flyboy::Folder"]] SQL (0.1ms) UPDATE "dorsale_flyboy_folders" SET "progress" = ?, "version" = ?, "updated_at" = ? WHERE "dorsale_flyboy_folders"."id" = ? [["progress", 50], ["version", 3], ["updated_at", "2015-09-10 14:09:26.275122"], ["id", 1]]  (1.1ms) commit transaction  (0.1ms) begin transaction Dorsale::Flyboy::Folder Load (0.1ms) SELECT "dorsale_flyboy_folders".* FROM "dorsale_flyboy_folders" WHERE "dorsale_flyboy_folders"."id" = ? LIMIT 1 [["id", 1]] SQL (0.3ms) INSERT INTO "dorsale_flyboy_tasks" ("name", "description", "taskable_id", "taskable_type", "done", "reminder", "term", "progress", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [["name", "Rediger les documentations"], ["description", "Dorsale, CustomerVault, Flyboy, ..."], ["taskable_id", 1], ["taskable_type", "Dorsale::Flyboy::Folder"], ["done", "f"], ["reminder", "2015-09-17"], ["term", "2015-10-10"], ["progress", 0], ["created_at", "2015-09-10 14:09:26.279831"], ["updated_at", "2015-09-10 14:09:26.279831"]]  (0.1ms) SELECT COUNT(*) FROM "dorsale_flyboy_tasks" WHERE "dorsale_flyboy_tasks"."taskable_id" = ? AND "dorsale_flyboy_tasks"."taskable_type" = ? [["taskable_id", 1], ["taskable_type", "Dorsale::Flyboy::Folder"]]  (0.1ms) SELECT SUM("dorsale_flyboy_tasks"."progress") FROM "dorsale_flyboy_tasks" WHERE "dorsale_flyboy_tasks"."taskable_id" = ? AND "dorsale_flyboy_tasks"."taskable_type" = ? [["taskable_id", 1], ["taskable_type", "Dorsale::Flyboy::Folder"]]  (0.1ms) SELECT COUNT(*) FROM "dorsale_flyboy_tasks" WHERE "dorsale_flyboy_tasks"."taskable_id" = ? AND "dorsale_flyboy_tasks"."taskable_type" = ? [["taskable_id", 1], ["taskable_type", "Dorsale::Flyboy::Folder"]] SQL (0.1ms) UPDATE "dorsale_flyboy_folders" SET "progress" = ?, "version" = ?, "updated_at" = ? WHERE "dorsale_flyboy_folders"."id" = ? [["progress", 25], ["version", 4], ["updated_at", "2015-09-10 14:09:26.283800"], ["id", 1]]  (1.1ms) commit transaction  (0.1ms) begin transaction SQL (0.4ms) INSERT INTO "dorsale_flyboy_tasks" ("taskable_id", "taskable_type", "name", "done", "reminder", "term", "progress", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) [["taskable_id", 2], ["taskable_type", "Dorsale::CustomerVault::Corporation"], ["name", "Relancer et se faire payer"], ["done", "f"], ["reminder", "2015-09-17"], ["term", "2015-10-10"], ["progress", 0], ["created_at", "2015-09-10 14:09:26.287494"], ["updated_at", "2015-09-10 14:09:26.287494"]]  (0.9ms) commit transaction  (0.1ms) begin transaction User Exists (0.2ms) SELECT 1 AS one FROM "users" WHERE "users"."email" = 'demo@agilidee.com' LIMIT 1 SQL (0.3ms) INSERT INTO "dorsale_flyboy_task_comments" ("description", "progress", "author_type", "task_id", "date", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?) [["description", "Relance faire aujourd'hui. Paiement d'ici la fin de la semaine."], ["progress", 50], ["author_type", "User"], ["task_id", 3], ["date", "2015-09-10 14:09:26.291459"], ["created_at", "2015-09-10 14:09:26.293636"], ["updated_at", "2015-09-10 14:09:26.293636"]] SQL (0.1ms) UPDATE "dorsale_flyboy_tasks" SET "progress" = ?, "updated_at" = ? WHERE "dorsale_flyboy_tasks"."id" = ? [["progress", 50], ["updated_at", "2015-09-10 14:09:26.295243"], ["id", 3]]  (1.1ms) commit transaction  (1.3ms) DROP TABLE "dorsale_addresses"  (1.1ms) CREATE 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)  (1.1ms) DROP TABLE "dorsale_alexandrie_attachments"  (1.0ms) CREATE TABLE "dorsale_alexandrie_attachments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "attachable_id" integer, "attachable_type" varchar, "file" varchar)  (1.0ms) DROP TABLE "dorsale_billing_machine_id_cards"  (1.0ms) CREATE 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)  (1.1ms) DROP TABLE "dorsale_billing_machine_invoice_lines"  (1.3ms) CREATE 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)  (0.1ms) select sqlite_version(*)  (1.1ms) CREATE INDEX "index_dorsale_billing_machine_invoice_lines_on_invoice_id" ON "dorsale_billing_machine_invoice_lines" ("invoice_id")  (1.3ms) DROP TABLE "dorsale_billing_machine_invoices"  (1.1ms) CREATE 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_duty" decimal, "vat_amount" decimal, "total_all_taxes" decimal, "advance" decimal, "balance" decimal, "unique_index" integer, "vat_rate" decimal, "paid" boolean, "due_date" date, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "tracking_id" varchar)  (1.0ms) CREATE INDEX "index_dorsale_billing_machine_invoices_on_customer_id" ON "dorsale_billing_machine_invoices" ("customer_id")  (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_id' AND type='index'  (1.1ms) CREATE INDEX "index_dorsale_billing_machine_invoices_on_customer_type" ON "dorsale_billing_machine_invoices" ("customer_type")  (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_type' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_type' AND type='index'  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_id' AND type='index'   (1.1ms) CREATE INDEX "index_dorsale_billing_machine_invoices_on_id_card_id" ON "dorsale_billing_machine_invoices" ("id_card_id")  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_invoices_on_id_card_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_invoices_on_id_card_id' AND type='index'   (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_type' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_type' AND type='index'  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_id' AND type='index'   (1.1ms) CREATE INDEX "index_dorsale_billing_machine_invoices_on_payment_term_id" ON "dorsale_billing_machine_invoices" ("payment_term_id")  (1.0ms) DROP TABLE "dorsale_billing_machine_payment_terms"  (0.9ms) 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)  (1.1ms) DROP TABLE "dorsale_billing_machine_quotation_lines"  (1.0ms) 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)  (1.3ms) CREATE INDEX "index_dorsale_billing_machine_quotation_lines_on_quotation_id" ON "dorsale_billing_machine_quotation_lines" ("quotation_id")  (1.3ms) DROP TABLE "dorsale_billing_machine_quotations"  (1.2ms) 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_duty" decimal, "vat_amount" decimal, "total_all_taxes" decimal, "unique_index" integer, "vat_rate" decimal, "comments" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "expires_at" date, "tracking_id" varchar)   (1.2ms) CREATE INDEX "index_dorsale_billing_machine_quotations_on_customer_id" ON "dorsale_billing_machine_quotations" ("customer_id")  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_id' AND type='index'   (1.0ms) CREATE INDEX "index_dorsale_billing_machine_quotations_on_customer_type" ON "dorsale_billing_machine_quotations" ("customer_type")  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_type' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_type' AND type='index'   (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_id' AND type='index'  (1.0ms) CREATE INDEX "index_dorsale_billing_machine_quotations_on_id_card_id" ON "dorsale_billing_machine_quotations" ("id_card_id")  (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_quotations_on_id_card_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_quotations_on_id_card_id' AND type='index'  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_type' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_type' AND type='index'   (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_id' AND type='index'  (1.2ms) CREATE INDEX "index_dorsale_billing_machine_quotations_on_payment_term_id" ON "dorsale_billing_machine_quotations" ("payment_term_id")  (1.4ms) DROP TABLE "dorsale_comments"  (1.4ms) CREATE 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)   (1.4ms) DROP TABLE "dorsale_customer_vault_corporations"  (1.4ms) CREATE TABLE "dorsale_customer_vault_corporations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "short_name" varchar, "email" varchar, "phone" varchar, "fax" varchar, "www" varchar, "legal_form" varchar, "capital" integer, "immatriculation_number_1" varchar, "immatriculation_number_2" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)   (1.7ms) DROP TABLE "dorsale_customer_vault_individuals"  (1.4ms) CREATE TABLE "dorsale_customer_vault_individuals" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "first_name" varchar, "last_name" varchar, "short_name" varchar, "email" varchar, "title" varchar, "twitter" varchar, "www" varchar, "context" text, "phone" varchar, "fax" varchar, "mobile" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)   (1.4ms) DROP TABLE "dorsale_customer_vault_links"  (1.3ms) 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)   (1.1ms) CREATE INDEX "index_dorsale_customer_vault_links_on_alice_id" ON "dorsale_customer_vault_links" ("alice_id")  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_customer_vault_links_on_alice_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_customer_vault_links_on_alice_id' AND type='index'   (1.2ms) CREATE INDEX "index_dorsale_customer_vault_links_on_alice_type" ON "dorsale_customer_vault_links" ("alice_type")  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_customer_vault_links_on_alice_type' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_customer_vault_links_on_alice_type' AND type='index'   (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_customer_vault_links_on_alice_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_customer_vault_links_on_alice_id' AND type='index'  (1.1ms) CREATE INDEX "index_dorsale_customer_vault_links_on_bob_id" ON "dorsale_customer_vault_links" ("bob_id")  (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_customer_vault_links_on_bob_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_customer_vault_links_on_bob_id' AND type='index'  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_customer_vault_links_on_alice_type' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_customer_vault_links_on_alice_type' AND type='index'   (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_customer_vault_links_on_alice_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_customer_vault_links_on_alice_id' AND type='index'  (1.1ms) CREATE INDEX "index_dorsale_customer_vault_links_on_bob_type" ON "dorsale_customer_vault_links" ("bob_type")  (1.2ms) DROP TABLE "dorsale_flyboy_folders"  (1.1ms) 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)   (1.1ms) CREATE INDEX "index_dorsale_flyboy_folders_on_folderable_id" ON "dorsale_flyboy_folders" ("folderable_id")  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_flyboy_folders_on_folderable_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_flyboy_folders_on_folderable_id' AND type='index'   (1.1ms) CREATE INDEX "index_dorsale_flyboy_folders_on_folderable_type" ON "dorsale_flyboy_folders" ("folderable_type")  (1.1ms) DROP TABLE "dorsale_flyboy_task_comments"  (1.0ms) 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)  (1.2ms) CREATE INDEX "index_dorsale_flyboy_task_comments_on_task_id" ON "dorsale_flyboy_task_comments" ("task_id")  (1.5ms) DROP TABLE "dorsale_flyboy_tasks"  (1.5ms) 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_id" integer, "owner_type" varchar)   (1.2ms) CREATE INDEX "index_dorsale_flyboy_tasks_on_taskable_id" ON "dorsale_flyboy_tasks" ("taskable_id")  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_flyboy_tasks_on_taskable_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_flyboy_tasks_on_taskable_id' AND type='index'   (1.1ms) CREATE INDEX "index_dorsale_flyboy_tasks_on_taskable_type" ON "dorsale_flyboy_tasks" ("taskable_type")  (1.0ms) DROP TABLE "dummy_models"  (1.0ms) CREATE TABLE "dummy_models" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)  (1.4ms) DROP TABLE "taggings"  (1.6ms) 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)  (1.4ms) CREATE UNIQUE INDEX "taggings_idx" ON "taggings" ("tag_id", "taggable_id", "taggable_type", "context", "tagger_id", "tagger_type")  (0.2ms) SELECT sql FROM sqlite_master WHERE name='taggings_idx' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='taggings_idx' AND type='index'  (1.4ms) CREATE INDEX "index_taggings_on_taggable_id_and_taggable_type_and_context" ON "taggings" ("taggable_id", "taggable_type", "context")  (1.4ms) DROP TABLE "tags"  (1.5ms) CREATE TABLE "tags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "taggings_count" integer DEFAULT 0)   (1.4ms) CREATE UNIQUE INDEX "index_tags_on_name" ON "tags" ("name")  (1.2ms) DROP TABLE "users"  (1.2ms) 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)  (1.0ms) CREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")  (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_users_on_email' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_users_on_email' AND type='index'  (1.2ms) CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")  (0.2ms) SELECT version FROM "schema_migrations"  (20.1ms) DROP TABLE "dorsale_addresses"  (3.3ms) CREATE 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)  (1.9ms) DROP TABLE "dorsale_alexandrie_attachments"  (1.2ms) CREATE TABLE "dorsale_alexandrie_attachments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "attachable_id" integer, "attachable_type" varchar, "file" varchar)  (1.6ms) DROP TABLE "dorsale_billing_machine_id_cards"  (1.6ms) CREATE 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)  (1.4ms) DROP TABLE "dorsale_billing_machine_invoice_lines"  (1.3ms) CREATE 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)  (0.1ms) select sqlite_version(*)  (1.1ms) CREATE INDEX "index_dorsale_billing_machine_invoice_lines_on_invoice_id" ON "dorsale_billing_machine_invoice_lines" ("invoice_id")  (1.5ms) DROP TABLE "dorsale_billing_machine_invoices"  (1.2ms) CREATE 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_duty" decimal, "vat_amount" decimal, "total_all_taxes" decimal, "advance" decimal, "balance" decimal, "unique_index" integer, "vat_rate" decimal, "paid" boolean, "due_date" date, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "tracking_id" varchar)  (1.0ms) CREATE INDEX "index_dorsale_billing_machine_invoices_on_customer_id" ON "dorsale_billing_machine_invoices" ("customer_id")  (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_id' AND type='index'  (1.1ms) CREATE INDEX "index_dorsale_billing_machine_invoices_on_customer_type" ON "dorsale_billing_machine_invoices" ("customer_type")  (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_type' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_type' AND type='index'  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_id' AND type='index'   (1.1ms) CREATE INDEX "index_dorsale_billing_machine_invoices_on_id_card_id" ON "dorsale_billing_machine_invoices" ("id_card_id")  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_invoices_on_id_card_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_invoices_on_id_card_id' AND type='index'   (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_type' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_type' AND type='index'  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_id' AND type='index'   (1.1ms) CREATE INDEX "index_dorsale_billing_machine_invoices_on_payment_term_id" ON "dorsale_billing_machine_invoices" ("payment_term_id")  (1.0ms) DROP TABLE "dorsale_billing_machine_payment_terms"  (1.0ms) 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)  (1.0ms) DROP TABLE "dorsale_billing_machine_quotation_lines"  (1.0ms) 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)  (1.0ms) CREATE INDEX "index_dorsale_billing_machine_quotation_lines_on_quotation_id" ON "dorsale_billing_machine_quotation_lines" ("quotation_id")  (1.4ms) DROP TABLE "dorsale_billing_machine_quotations"  (1.4ms) 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_duty" decimal, "vat_amount" decimal, "total_all_taxes" decimal, "unique_index" integer, "vat_rate" decimal, "comments" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "expires_at" date, "tracking_id" varchar)   (1.1ms) CREATE INDEX "index_dorsale_billing_machine_quotations_on_customer_id" ON "dorsale_billing_machine_quotations" ("customer_id")  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_id' AND type='index'   (1.2ms) CREATE INDEX "index_dorsale_billing_machine_quotations_on_customer_type" ON "dorsale_billing_machine_quotations" ("customer_type")  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_type' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_type' AND type='index'   (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_id' AND type='index'  (1.1ms) CREATE INDEX "index_dorsale_billing_machine_quotations_on_id_card_id" ON "dorsale_billing_machine_quotations" ("id_card_id")  (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_quotations_on_id_card_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_quotations_on_id_card_id' AND type='index'  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_type' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_type' AND type='index'   (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_id' AND type='index'  (1.0ms) CREATE INDEX "index_dorsale_billing_machine_quotations_on_payment_term_id" ON "dorsale_billing_machine_quotations" ("payment_term_id")  (5.4ms) DROP TABLE "dorsale_comments"  (1.6ms) CREATE 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)   (1.3ms) DROP TABLE "dorsale_customer_vault_corporations"  (1.4ms) CREATE TABLE "dorsale_customer_vault_corporations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "short_name" varchar, "email" varchar, "phone" varchar, "fax" varchar, "www" varchar, "legal_form" varchar, "capital" integer, "immatriculation_number_1" varchar, "immatriculation_number_2" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)   (1.4ms) DROP TABLE "dorsale_customer_vault_individuals"  (1.3ms) CREATE TABLE "dorsale_customer_vault_individuals" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "first_name" varchar, "last_name" varchar, "short_name" varchar, "email" varchar, "title" varchar, "twitter" varchar, "www" varchar, "context" text, "phone" varchar, "fax" varchar, "mobile" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)   (1.4ms) DROP TABLE "dorsale_customer_vault_links"  (1.0ms) 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)   (1.0ms) CREATE INDEX "index_dorsale_customer_vault_links_on_alice_id" ON "dorsale_customer_vault_links" ("alice_id")  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_customer_vault_links_on_alice_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_customer_vault_links_on_alice_id' AND type='index'   (1.1ms) CREATE INDEX "index_dorsale_customer_vault_links_on_alice_type" ON "dorsale_customer_vault_links" ("alice_type")  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_customer_vault_links_on_alice_type' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_customer_vault_links_on_alice_type' AND type='index'   (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_customer_vault_links_on_alice_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_customer_vault_links_on_alice_id' AND type='index'  (1.0ms) CREATE INDEX "index_dorsale_customer_vault_links_on_bob_id" ON "dorsale_customer_vault_links" ("bob_id")  (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_customer_vault_links_on_bob_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_customer_vault_links_on_bob_id' AND type='index'  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_customer_vault_links_on_alice_type' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_customer_vault_links_on_alice_type' AND type='index'   (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_customer_vault_links_on_alice_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_customer_vault_links_on_alice_id' AND type='index'  (1.1ms) CREATE INDEX "index_dorsale_customer_vault_links_on_bob_type" ON "dorsale_customer_vault_links" ("bob_type")  (1.2ms) DROP TABLE "dorsale_flyboy_folders"  (1.1ms) 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)   (1.0ms) CREATE INDEX "index_dorsale_flyboy_folders_on_folderable_id" ON "dorsale_flyboy_folders" ("folderable_id")  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_flyboy_folders_on_folderable_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_flyboy_folders_on_folderable_id' AND type='index'   (1.0ms) CREATE INDEX "index_dorsale_flyboy_folders_on_folderable_type" ON "dorsale_flyboy_folders" ("folderable_type")  (1.1ms) DROP TABLE "dorsale_flyboy_task_comments"  (1.6ms) 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)  (2.4ms) CREATE INDEX "index_dorsale_flyboy_task_comments_on_task_id" ON "dorsale_flyboy_task_comments" ("task_id")  (1.3ms) DROP TABLE "dorsale_flyboy_tasks"  (1.2ms) 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_id" integer, "owner_type" varchar)   (1.0ms) CREATE INDEX "index_dorsale_flyboy_tasks_on_taskable_id" ON "dorsale_flyboy_tasks" ("taskable_id")  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_flyboy_tasks_on_taskable_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_flyboy_tasks_on_taskable_id' AND type='index'   (1.2ms) CREATE INDEX "index_dorsale_flyboy_tasks_on_taskable_type" ON "dorsale_flyboy_tasks" ("taskable_type")  (1.5ms) DROP TABLE "dummy_models"  (1.4ms) CREATE TABLE "dummy_models" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)  (1.5ms) DROP TABLE "taggings"  (1.3ms) 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)  (1.7ms) CREATE UNIQUE INDEX "taggings_idx" ON "taggings" ("tag_id", "taggable_id", "taggable_type", "context", "tagger_id", "tagger_type")  (0.2ms) SELECT sql FROM sqlite_master WHERE name='taggings_idx' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='taggings_idx' AND type='index'  (1.4ms) CREATE INDEX "index_taggings_on_taggable_id_and_taggable_type_and_context" ON "taggings" ("taggable_id", "taggable_type", "context")  (1.3ms) DROP TABLE "tags"  (1.2ms) CREATE TABLE "tags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "taggings_count" integer DEFAULT 0)   (1.0ms) CREATE UNIQUE INDEX "index_tags_on_name" ON "tags" ("name")  (1.2ms) DROP TABLE "users"  (1.1ms) 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)  (1.0ms) CREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")  (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_users_on_email' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_users_on_email' AND type='index'  (1.0ms) CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")  (0.1ms) SELECT version FROM "schema_migrations"  (3.3ms) DROP TABLE "dorsale_addresses"  (1.1ms) CREATE 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)  (1.1ms) DROP TABLE "dorsale_alexandrie_attachments"  (1.0ms) CREATE TABLE "dorsale_alexandrie_attachments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "attachable_id" integer, "attachable_type" varchar, "file" varchar)  (1.1ms) DROP TABLE "dorsale_billing_machine_id_cards"  (1.2ms) CREATE 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)  (1.1ms) DROP TABLE "dorsale_billing_machine_invoice_lines"  (1.1ms) CREATE 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)  (0.1ms) select sqlite_version(*)  (1.0ms) CREATE INDEX "index_dorsale_billing_machine_invoice_lines_on_invoice_id" ON "dorsale_billing_machine_invoice_lines" ("invoice_id")  (1.3ms) DROP TABLE "dorsale_billing_machine_invoices"  (1.1ms) CREATE 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_duty" decimal, "vat_amount" decimal, "total_all_taxes" decimal, "advance" decimal, "balance" decimal, "unique_index" integer, "vat_rate" decimal, "paid" boolean, "due_date" date, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "tracking_id" varchar)  (1.2ms) CREATE INDEX "index_dorsale_billing_machine_invoices_on_customer_id" ON "dorsale_billing_machine_invoices" ("customer_id")  (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_id' AND type='index'  (1.2ms) CREATE INDEX "index_dorsale_billing_machine_invoices_on_customer_type" ON "dorsale_billing_machine_invoices" ("customer_type")  (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_type' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_type' AND type='index'  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_id' AND type='index'   (1.0ms) CREATE INDEX "index_dorsale_billing_machine_invoices_on_id_card_id" ON "dorsale_billing_machine_invoices" ("id_card_id")  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_invoices_on_id_card_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_invoices_on_id_card_id' AND type='index'   (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_type' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_type' AND type='index'  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_id' AND type='index'   (0.9ms) CREATE INDEX "index_dorsale_billing_machine_invoices_on_payment_term_id" ON "dorsale_billing_machine_invoices" ("payment_term_id")  (1.2ms) DROP TABLE "dorsale_billing_machine_payment_terms"  (1.3ms) 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)  (1.1ms) DROP TABLE "dorsale_billing_machine_quotation_lines"  (1.5ms) 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)  (1.6ms) CREATE INDEX "index_dorsale_billing_machine_quotation_lines_on_quotation_id" ON "dorsale_billing_machine_quotation_lines" ("quotation_id")  (1.7ms) DROP TABLE "dorsale_billing_machine_quotations"  (2.1ms) 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_duty" decimal, "vat_amount" decimal, "total_all_taxes" decimal, "unique_index" integer, "vat_rate" decimal, "comments" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "expires_at" date, "tracking_id" varchar)   (1.2ms) CREATE INDEX "index_dorsale_billing_machine_quotations_on_customer_id" ON "dorsale_billing_machine_quotations" ("customer_id")  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_id' AND type='index'   (1.1ms) CREATE INDEX "index_dorsale_billing_machine_quotations_on_customer_type" ON "dorsale_billing_machine_quotations" ("customer_type")  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_type' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_type' AND type='index'   (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_id' AND type='index'  (1.1ms) CREATE INDEX "index_dorsale_billing_machine_quotations_on_id_card_id" ON "dorsale_billing_machine_quotations" ("id_card_id")  (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_quotations_on_id_card_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_quotations_on_id_card_id' AND type='index'  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_type' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_type' AND type='index'   (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_id' AND type='index'  (1.1ms) CREATE INDEX "index_dorsale_billing_machine_quotations_on_payment_term_id" ON "dorsale_billing_machine_quotations" ("payment_term_id")  (1.2ms) DROP TABLE "dorsale_comments"  (1.0ms) CREATE 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)   (1.0ms) DROP TABLE "dorsale_customer_vault_corporations"  (1.0ms) CREATE TABLE "dorsale_customer_vault_corporations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "short_name" varchar, "email" varchar, "phone" varchar, "fax" varchar, "www" varchar, "legal_form" varchar, "capital" integer, "immatriculation_number_1" varchar, "immatriculation_number_2" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)   (1.1ms) DROP TABLE "dorsale_customer_vault_individuals"  (1.1ms) CREATE TABLE "dorsale_customer_vault_individuals" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "first_name" varchar, "last_name" varchar, "short_name" varchar, "email" varchar, "title" varchar, "twitter" varchar, "www" varchar, "context" text, "phone" varchar, "fax" varchar, "mobile" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)   (1.3ms) DROP TABLE "dorsale_customer_vault_links"  (1.0ms) 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)   (1.0ms) CREATE INDEX "index_dorsale_customer_vault_links_on_alice_id" ON "dorsale_customer_vault_links" ("alice_id")  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_customer_vault_links_on_alice_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_customer_vault_links_on_alice_id' AND type='index'   (1.1ms) CREATE INDEX "index_dorsale_customer_vault_links_on_alice_type" ON "dorsale_customer_vault_links" ("alice_type")  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_customer_vault_links_on_alice_type' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_customer_vault_links_on_alice_type' AND type='index'   (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_customer_vault_links_on_alice_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_customer_vault_links_on_alice_id' AND type='index'  (1.1ms) CREATE INDEX "index_dorsale_customer_vault_links_on_bob_id" ON "dorsale_customer_vault_links" ("bob_id")  (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_customer_vault_links_on_bob_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_customer_vault_links_on_bob_id' AND type='index'  (0.2ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_customer_vault_links_on_alice_type' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_customer_vault_links_on_alice_type' AND type='index'   (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_customer_vault_links_on_alice_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_customer_vault_links_on_alice_id' AND type='index'  (1.4ms) CREATE INDEX "index_dorsale_customer_vault_links_on_bob_type" ON "dorsale_customer_vault_links" ("bob_type")  (1.3ms) DROP TABLE "dorsale_flyboy_folders"  (1.4ms) 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)   (1.1ms) CREATE INDEX "index_dorsale_flyboy_folders_on_folderable_id" ON "dorsale_flyboy_folders" ("folderable_id")  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_flyboy_folders_on_folderable_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_flyboy_folders_on_folderable_id' AND type='index'   (1.0ms) CREATE INDEX "index_dorsale_flyboy_folders_on_folderable_type" ON "dorsale_flyboy_folders" ("folderable_type")  (1.2ms) DROP TABLE "dorsale_flyboy_task_comments"  (1.5ms) 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)  (1.4ms) CREATE INDEX "index_dorsale_flyboy_task_comments_on_task_id" ON "dorsale_flyboy_task_comments" ("task_id")  (1.5ms) DROP TABLE "dorsale_flyboy_tasks"  (1.6ms) 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_id" integer, "owner_type" varchar)   (1.4ms) CREATE INDEX "index_dorsale_flyboy_tasks_on_taskable_id" ON "dorsale_flyboy_tasks" ("taskable_id")  (0.4ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_flyboy_tasks_on_taskable_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_flyboy_tasks_on_taskable_id' AND type='index'   (1.6ms) CREATE INDEX "index_dorsale_flyboy_tasks_on_taskable_type" ON "dorsale_flyboy_tasks" ("taskable_type")  (1.3ms) DROP TABLE "dummy_models"  (1.6ms) CREATE TABLE "dummy_models" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)  (1.5ms) DROP TABLE "taggings"  (1.5ms) 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)  (1.6ms) CREATE UNIQUE INDEX "taggings_idx" ON "taggings" ("tag_id", "taggable_id", "taggable_type", "context", "tagger_id", "tagger_type")  (0.1ms) SELECT sql FROM sqlite_master WHERE name='taggings_idx' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='taggings_idx' AND type='index'  (1.0ms) CREATE INDEX "index_taggings_on_taggable_id_and_taggable_type_and_context" ON "taggings" ("taggable_id", "taggable_type", "context")  (1.1ms) DROP TABLE "tags"  (1.3ms) CREATE TABLE "tags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "taggings_count" integer DEFAULT 0)   (1.1ms) CREATE UNIQUE INDEX "index_tags_on_name" ON "tags" ("name")  (1.1ms) DROP TABLE "users"  (1.2ms) 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)  (1.2ms) CREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")  (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_users_on_email' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_users_on_email' AND type='index'  (1.2ms) CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")  (0.1ms) SELECT version FROM "schema_migrations"  (1.2ms) DROP TABLE "dorsale_addresses"  (1.5ms) CREATE 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)  (1.5ms) DROP TABLE "dorsale_alexandrie_attachments"  (1.9ms) CREATE TABLE "dorsale_alexandrie_attachments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "attachable_id" integer, "attachable_type" varchar, "file" varchar)  (1.7ms) DROP TABLE "dorsale_billing_machine_id_cards"  (1.8ms) CREATE 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)  (1.4ms) DROP TABLE "dorsale_billing_machine_invoice_lines"  (1.5ms) CREATE 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)  (0.1ms) select sqlite_version(*)  (1.5ms) CREATE INDEX "index_dorsale_billing_machine_invoice_lines_on_invoice_id" ON "dorsale_billing_machine_invoice_lines" ("invoice_id")  (1.7ms) DROP TABLE "dorsale_billing_machine_invoices"  (1.1ms) CREATE 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_duty" decimal, "vat_amount" decimal, "total_all_taxes" decimal, "advance" decimal, "balance" decimal, "unique_index" integer, "vat_rate" decimal, "paid" boolean, "due_date" date, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "tracking_id" varchar)  (1.0ms) CREATE INDEX "index_dorsale_billing_machine_invoices_on_customer_id" ON "dorsale_billing_machine_invoices" ("customer_id")  (0.2ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_id' AND type='index'  (1.2ms) CREATE INDEX "index_dorsale_billing_machine_invoices_on_customer_type" ON "dorsale_billing_machine_invoices" ("customer_type")  (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_type' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_type' AND type='index'  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_id' AND type='index'   (1.0ms) CREATE INDEX "index_dorsale_billing_machine_invoices_on_id_card_id" ON "dorsale_billing_machine_invoices" ("id_card_id")  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_invoices_on_id_card_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_invoices_on_id_card_id' AND type='index'   (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_type' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_type' AND type='index'  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_id' AND type='index'   (1.1ms) CREATE INDEX "index_dorsale_billing_machine_invoices_on_payment_term_id" ON "dorsale_billing_machine_invoices" ("payment_term_id")  (1.0ms) DROP TABLE "dorsale_billing_machine_payment_terms"  (3.6ms) 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)  (1.3ms) DROP TABLE "dorsale_billing_machine_quotation_lines"  (1.3ms) 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)  (1.2ms) CREATE INDEX "index_dorsale_billing_machine_quotation_lines_on_quotation_id" ON "dorsale_billing_machine_quotation_lines" ("quotation_id")  (1.3ms) DROP TABLE "dorsale_billing_machine_quotations"  (1.2ms) 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_duty" decimal, "vat_amount" decimal, "total_all_taxes" decimal, "unique_index" integer, "vat_rate" decimal, "comments" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "expires_at" date, "tracking_id" varchar)   (1.1ms) CREATE INDEX "index_dorsale_billing_machine_quotations_on_customer_id" ON "dorsale_billing_machine_quotations" ("customer_id")  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_id' AND type='index'   (1.2ms) CREATE INDEX "index_dorsale_billing_machine_quotations_on_customer_type" ON "dorsale_billing_machine_quotations" ("customer_type")  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_type' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_type' AND type='index'   (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_id' AND type='index'  (1.1ms) CREATE INDEX "index_dorsale_billing_machine_quotations_on_id_card_id" ON "dorsale_billing_machine_quotations" ("id_card_id")  (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_quotations_on_id_card_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_quotations_on_id_card_id' AND type='index'  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_type' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_type' AND type='index'   (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_id' AND type='index'  (1.2ms) CREATE INDEX "index_dorsale_billing_machine_quotations_on_payment_term_id" ON "dorsale_billing_machine_quotations" ("payment_term_id")  (1.4ms) DROP TABLE "dorsale_comments"  (1.7ms) CREATE 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)   (1.5ms) DROP TABLE "dorsale_customer_vault_corporations"  (2.2ms) CREATE TABLE "dorsale_customer_vault_corporations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "short_name" varchar, "email" varchar, "phone" varchar, "fax" varchar, "www" varchar, "legal_form" varchar, "capital" integer, "immatriculation_number_1" varchar, "immatriculation_number_2" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)   (1.5ms) DROP TABLE "dorsale_customer_vault_individuals"  (1.5ms) CREATE TABLE "dorsale_customer_vault_individuals" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "first_name" varchar, "last_name" varchar, "short_name" varchar, "email" varchar, "title" varchar, "twitter" varchar, "www" varchar, "context" text, "phone" varchar, "fax" varchar, "mobile" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)   (1.8ms) DROP TABLE "dorsale_customer_vault_links"  (1.5ms) 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)   (1.0ms) CREATE INDEX "index_dorsale_customer_vault_links_on_alice_id" ON "dorsale_customer_vault_links" ("alice_id")  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_customer_vault_links_on_alice_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_customer_vault_links_on_alice_id' AND type='index'   (1.1ms) CREATE INDEX "index_dorsale_customer_vault_links_on_alice_type" ON "dorsale_customer_vault_links" ("alice_type")  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_customer_vault_links_on_alice_type' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_customer_vault_links_on_alice_type' AND type='index'   (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_customer_vault_links_on_alice_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_customer_vault_links_on_alice_id' AND type='index'  (1.0ms) CREATE INDEX "index_dorsale_customer_vault_links_on_bob_id" ON "dorsale_customer_vault_links" ("bob_id")  (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_customer_vault_links_on_bob_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_customer_vault_links_on_bob_id' AND type='index'  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_customer_vault_links_on_alice_type' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_customer_vault_links_on_alice_type' AND type='index'   (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_customer_vault_links_on_alice_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_customer_vault_links_on_alice_id' AND type='index'  (1.1ms) CREATE INDEX "index_dorsale_customer_vault_links_on_bob_type" ON "dorsale_customer_vault_links" ("bob_type")  (1.2ms) DROP TABLE "dorsale_flyboy_folders"  (4.7ms) 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)   (1.1ms) CREATE INDEX "index_dorsale_flyboy_folders_on_folderable_id" ON "dorsale_flyboy_folders" ("folderable_id")  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_flyboy_folders_on_folderable_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_flyboy_folders_on_folderable_id' AND type='index'   (1.1ms) CREATE INDEX "index_dorsale_flyboy_folders_on_folderable_type" ON "dorsale_flyboy_folders" ("folderable_type")  (1.2ms) DROP TABLE "dorsale_flyboy_task_comments"  (1.2ms) 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)  (1.2ms) CREATE INDEX "index_dorsale_flyboy_task_comments_on_task_id" ON "dorsale_flyboy_task_comments" ("task_id")  (1.2ms) DROP TABLE "dorsale_flyboy_tasks"  (1.5ms) 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_id" integer, "owner_type" varchar)   (1.2ms) CREATE INDEX "index_dorsale_flyboy_tasks_on_taskable_id" ON "dorsale_flyboy_tasks" ("taskable_id")  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_flyboy_tasks_on_taskable_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_flyboy_tasks_on_taskable_id' AND type='index'   (1.1ms) CREATE INDEX "index_dorsale_flyboy_tasks_on_taskable_type" ON "dorsale_flyboy_tasks" ("taskable_type")  (1.0ms) DROP TABLE "dummy_models"  (1.0ms) CREATE TABLE "dummy_models" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)  (1.2ms) DROP TABLE "taggings"  (1.2ms) 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)  (1.6ms) CREATE UNIQUE INDEX "taggings_idx" ON "taggings" ("tag_id", "taggable_id", "taggable_type", "context", "tagger_id", "tagger_type")  (0.2ms) SELECT sql FROM sqlite_master WHERE name='taggings_idx' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='taggings_idx' AND type='index'  (1.4ms) CREATE INDEX "index_taggings_on_taggable_id_and_taggable_type_and_context" ON "taggings" ("taggable_id", "taggable_type", "context")  (1.5ms) DROP TABLE "tags"  (4.2ms) CREATE TABLE "tags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "taggings_count" integer DEFAULT 0)   (1.6ms) CREATE UNIQUE INDEX "index_tags_on_name" ON "tags" ("name")  (1.4ms) DROP TABLE "users"  (1.6ms) 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)  (1.4ms) CREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")  (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_users_on_email' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_users_on_email' AND type='index'  (1.2ms) CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")  (0.2ms) SELECT version FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations"  (2.7ms) DELETE FROM "dorsale_addresses";  (0.2ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'dorsale_addresses';  (0.9ms) DELETE FROM "dorsale_alexandrie_attachments";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'dorsale_alexandrie_attachments';  (0.8ms) DELETE FROM "dorsale_billing_machine_id_cards";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'dorsale_billing_machine_id_cards';  (0.8ms) DELETE FROM "dorsale_billing_machine_invoice_lines";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'dorsale_billing_machine_invoice_lines';  (1.0ms) DELETE FROM "dorsale_billing_machine_invoices";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'dorsale_billing_machine_invoices';  (0.9ms) DELETE FROM "dorsale_billing_machine_payment_terms";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'dorsale_billing_machine_payment_terms';  (1.0ms) DELETE FROM "dorsale_billing_machine_quotation_lines";  (0.2ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'dorsale_billing_machine_quotation_lines';  (1.1ms) DELETE FROM "dorsale_billing_machine_quotations";  (0.2ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'dorsale_billing_machine_quotations';  (0.8ms) DELETE FROM "dorsale_comments";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'dorsale_comments';  (0.8ms) DELETE FROM "dorsale_customer_vault_corporations";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'dorsale_customer_vault_corporations';  (0.8ms) DELETE FROM "dorsale_customer_vault_individuals";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'dorsale_customer_vault_individuals';  (1.1ms) DELETE FROM "dorsale_customer_vault_links";  (0.2ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'dorsale_customer_vault_links';  (1.0ms) DELETE FROM "dorsale_flyboy_folders";  (0.2ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'dorsale_flyboy_folders';  (0.9ms) DELETE FROM "dorsale_flyboy_task_comments";  (0.2ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'dorsale_flyboy_task_comments';  (1.0ms) DELETE FROM "dorsale_flyboy_tasks";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'dorsale_flyboy_tasks';  (0.8ms) DELETE FROM "dummy_models";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'dummy_models';  (0.9ms) DELETE FROM "taggings";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'taggings';  (0.8ms) DELETE FROM "tags";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'tags';  (0.9ms) DELETE FROM "users";  (0.2ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'users';  (0.1ms) begin transaction User Exists (0.2ms) SELECT 1 AS one FROM "users" WHERE "users"."email" = 'demo@agilidee.com' LIMIT 1  (0.1ms) rollback transaction  (0.1ms) begin transaction SQL (0.4ms) INSERT INTO "dorsale_billing_machine_id_cards" ("id_card_name", "entity_name", "created_at", "updated_at") VALUES (?, ?, ?, ?) [["id_card_name", "Bidule Corp"], ["entity_name", "Bidule Corp"], ["created_at", "2015-09-10 14:10:49.799224"], ["updated_at", "2015-09-10 14:10:49.799224"]]  (2.5ms) commit transaction  (0.1ms) begin transaction SQL (0.3ms) INSERT INTO "dorsale_billing_machine_payment_terms" ("label", "created_at", "updated_at") VALUES (?, ?, ?) [["label", "A réception"], ["created_at", "2015-09-10 14:10:49.808425"], ["updated_at", "2015-09-10 14:10:49.808425"]]  (1.0ms) commit transaction  (0.1ms) begin transaction SQL (0.4ms) INSERT INTO "dorsale_customer_vault_corporations" ("name", "email", "www", "phone", "fax", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?) [["name", "agilidée"], ["email", "contact@agilidee.com"], ["www", "http://www.agilidee.com/"], ["phone", "04 91 xx xx xx"], ["fax", "04 91 xx xx xx"], ["created_at", "2015-09-10 14:10:49.896868"], ["updated_at", "2015-09-10 14:10:49.896868"]] SQL (0.1ms) INSERT INTO "dorsale_addresses" ("city", "country", "addressable_type", "addressable_id", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?) [["city", "Marseille"], ["country", "France"], ["addressable_type", "Dorsale::CustomerVault::Corporation"], ["addressable_id", 1], ["created_at", "2015-09-10 14:10:49.898714"], ["updated_at", "2015-09-10 14:10:49.898714"]] ActsAsTaggableOn::Tag Load (0.1ms) SELECT "tags".* FROM "tags" WHERE (LOWER(name) = LOWER('client')) ActsAsTaggableOn::Tag Exists (0.2ms) SELECT 1 AS one FROM "tags" WHERE "tags"."name" = 'client' LIMIT 1 SQL (0.2ms) INSERT INTO "tags" ("name") VALUES (?) [["name", "client"]] ActsAsTaggableOn::Tag Load (0.2ms) SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = ? AND "taggings"."taggable_type" = ? AND (taggings.context = 'tags' AND taggings.tagger_id IS NULL) ORDER BY "tags"."name" ASC [["taggable_id", 1], ["taggable_type", "Dorsale::CustomerVault::Corporation"]] ActsAsTaggableOn::Tagging Exists (0.1ms) SELECT 1 AS one FROM "taggings" WHERE ("taggings"."tag_id" = 1 AND "taggings"."taggable_type" = 'Dorsale::CustomerVault::Corporation' AND "taggings"."taggable_id" = 1 AND "taggings"."context" = 'tags' AND "taggings"."tagger_id" IS NULL AND "taggings"."tagger_type" IS NULL) LIMIT 1 SQL (0.2ms) INSERT INTO "taggings" ("tag_id", "context", "taggable_id", "taggable_type", "created_at") VALUES (?, ?, ?, ?, ?) [["tag_id", 1], ["context", "tags"], ["taggable_id", 1], ["taggable_type", "Dorsale::CustomerVault::Corporation"], ["created_at", "2015-09-10 14:10:50.016037"]] ActsAsTaggableOn::Tag Load (0.1ms) SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1 [["id", 1]] SQL (0.1ms) UPDATE "tags" SET "taggings_count" = COALESCE("taggings_count", 0) + 1 WHERE "tags"."id" = ? [["id", 1]]  (2.7ms) commit transaction  (0.1ms) begin transaction  (0.2ms) SELECT "dorsale_billing_machine_invoices"."unique_index" FROM "dorsale_billing_machine_invoices" SQL (0.4ms) INSERT INTO "dorsale_billing_machine_invoices" ("label", "id_card_id", "customer_id", "customer_type", "payment_term_id", "date", "due_date", "vat_rate", "advance", "paid", "total_duty", "vat_amount", "total_all_taxes", "balance", "created_at", "updated_at", "unique_index", "tracking_id") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [["label", "Commande de bombons"], ["id_card_id", 1], ["customer_id", 1], ["customer_type", "Dorsale::CustomerVault::Corporation"], ["payment_term_id", 1], ["date", "2015-09-10"], ["due_date", "2015-10-10"], ["vat_rate", 20.0], ["advance", 0.0], ["paid", "f"], ["total_duty", 0.0], ["vat_amount", 0.0], ["total_all_taxes", 0.0], ["balance", 0.0], ["created_at", "2015-09-10 14:10:50.066277"], ["updated_at", "2015-09-10 14:10:50.066277"], ["unique_index", 1], ["tracking_id", "2015-01"]] SQL (0.2ms) INSERT INTO "dorsale_billing_machine_invoice_lines" ("label", "quantity", "unit_price", "invoice_id", "total", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?) [["label", "Bombons en sucre"], ["quantity", 3.2], ["unit_price", 14.0], ["invoice_id", 1], ["total", 44.8], ["created_at", "2015-09-10 14:10:50.069883"], ["updated_at", "2015-09-10 14:10:50.069883"]] Dorsale::BillingMachine::Invoice Load (0.1ms) SELECT "dorsale_billing_machine_invoices".* FROM "dorsale_billing_machine_invoices" WHERE "dorsale_billing_machine_invoices"."id" = ? LIMIT 1 [["id", 1]] Dorsale::BillingMachine::IdCard Load (0.1ms) SELECT "dorsale_billing_machine_id_cards".* FROM "dorsale_billing_machine_id_cards" WHERE "dorsale_billing_machine_id_cards"."id" = ? LIMIT 1 [["id", 1]]  (0.2ms) SELECT "dorsale_billing_machine_invoice_lines"."total" FROM "dorsale_billing_machine_invoice_lines" WHERE "dorsale_billing_machine_invoice_lines"."invoice_id" = ? ORDER BY "dorsale_billing_machine_invoice_lines"."created_at" ASC [["invoice_id", 1]] SQL (0.4ms) UPDATE "dorsale_billing_machine_invoices" SET "total_duty" = ?, "vat_amount" = ?, "total_all_taxes" = ?, "balance" = ?, "updated_at" = ? WHERE "dorsale_billing_machine_invoices"."id" = ? [["total_duty", 44.8], ["vat_amount", 8.96], ["total_all_taxes", 53.76], ["balance", 53.76], ["updated_at", "2015-09-10 14:10:50.089267"], ["id", 1]]  (2.1ms) commit transaction  (0.1ms) begin transaction SQL (0.4ms) INSERT INTO "dorsale_customer_vault_corporations" ("name", "email", "phone", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?) [["name", "Truc Bidule SARL"], ["email", "truc@bidule.com"], ["phone", "04 91 xx xx xx"], ["created_at", "2015-09-10 14:10:50.097884"], ["updated_at", "2015-09-10 14:10:50.097884"]] SQL (0.1ms) INSERT INTO "dorsale_addresses" ("city", "country", "addressable_type", "addressable_id", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?) [["city", "Marseille"], ["country", "France"], ["addressable_type", "Dorsale::CustomerVault::Corporation"], ["addressable_id", 2], ["created_at", "2015-09-10 14:10:50.099687"], ["updated_at", "2015-09-10 14:10:50.099687"]] ActsAsTaggableOn::Tag Load (0.1ms) SELECT "tags".* FROM "tags" WHERE (LOWER(name) = LOWER('prospect') OR LOWER(name) = LOWER('certain')) ActsAsTaggableOn::Tag Exists (0.1ms) SELECT 1 AS one FROM "tags" WHERE "tags"."name" = 'prospect' LIMIT 1 SQL (0.2ms) INSERT INTO "tags" ("name") VALUES (?) [["name", "prospect"]] ActsAsTaggableOn::Tag Exists (0.1ms) SELECT 1 AS one FROM "tags" WHERE "tags"."name" = 'certain' LIMIT 1 SQL (0.0ms) INSERT INTO "tags" ("name") VALUES (?) [["name", "certain"]] ActsAsTaggableOn::Tag Load (0.0ms) SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = ? AND "taggings"."taggable_type" = ? AND (taggings.context = 'tags' AND taggings.tagger_id IS NULL) ORDER BY "tags"."name" ASC [["taggable_id", 2], ["taggable_type", "Dorsale::CustomerVault::Corporation"]] ActsAsTaggableOn::Tagging Exists (0.1ms) SELECT 1 AS one FROM "taggings" WHERE ("taggings"."tag_id" = 2 AND "taggings"."taggable_type" = 'Dorsale::CustomerVault::Corporation' AND "taggings"."taggable_id" = 2 AND "taggings"."context" = 'tags' AND "taggings"."tagger_id" IS NULL AND "taggings"."tagger_type" IS NULL) LIMIT 1 SQL (0.1ms) INSERT INTO "taggings" ("tag_id", "context", "taggable_id", "taggable_type", "created_at") VALUES (?, ?, ?, ?, ?) [["tag_id", 2], ["context", "tags"], ["taggable_id", 2], ["taggable_type", "Dorsale::CustomerVault::Corporation"], ["created_at", "2015-09-10 14:10:50.109030"]] ActsAsTaggableOn::Tag Load (0.0ms) SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1 [["id", 2]] SQL (0.0ms) UPDATE "tags" SET "taggings_count" = COALESCE("taggings_count", 0) + 1 WHERE "tags"."id" = ? [["id", 2]] ActsAsTaggableOn::Tagging Exists (0.1ms) SELECT 1 AS one FROM "taggings" WHERE ("taggings"."tag_id" = 3 AND "taggings"."taggable_type" = 'Dorsale::CustomerVault::Corporation' AND "taggings"."taggable_id" = 2 AND "taggings"."context" = 'tags' AND "taggings"."tagger_id" IS NULL AND "taggings"."tagger_type" IS NULL) LIMIT 1 SQL (0.1ms) INSERT INTO "taggings" ("tag_id", "context", "taggable_id", "taggable_type", "created_at") VALUES (?, ?, ?, ?, ?) [["tag_id", 3], ["context", "tags"], ["taggable_id", 2], ["taggable_type", "Dorsale::CustomerVault::Corporation"], ["created_at", "2015-09-10 14:10:50.113146"]] ActsAsTaggableOn::Tag Load (0.0ms) SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1 [["id", 3]] SQL (0.0ms) UPDATE "tags" SET "taggings_count" = COALESCE("taggings_count", 0) + 1 WHERE "tags"."id" = ? [["id", 3]]  (1.2ms) commit transaction  (0.0ms) begin transaction Dorsale::CustomerVault::Corporation Load (0.2ms) SELECT "dorsale_customer_vault_corporations".* FROM "dorsale_customer_vault_corporations" WHERE "dorsale_customer_vault_corporations"."id" = ? LIMIT 1 [["id", 2]] User Exists (0.1ms) SELECT 1 AS one FROM "users" WHERE "users"."email" = 'demo@agilidee.com' LIMIT 1 SQL (0.4ms) INSERT INTO "dorsale_comments" ("text", "author_type", "commentable_id", "commentable_type", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?) [["text", "Je viens d'avoir cette boite au téléphone, il faut leur faire un devis."], ["author_type", "User"], ["commentable_id", 2], ["commentable_type", "Dorsale::CustomerVault::Corporation"], ["created_at", "2015-09-10 14:10:50.133365"], ["updated_at", "2015-09-10 14:10:50.133365"]]  (1.0ms) commit transaction  (0.1ms) begin transaction  (0.1ms) SELECT "dorsale_billing_machine_quotations"."unique_index" FROM "dorsale_billing_machine_quotations" SQL (0.4ms) INSERT INTO "dorsale_billing_machine_quotations" ("label", "id_card_id", "customer_id", "customer_type", "payment_term_id", "date", "expires_at", "vat_rate", "total_duty", "vat_amount", "total_all_taxes", "created_at", "updated_at", "unique_index", "tracking_id") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [["label", "Application sur mesure"], ["id_card_id", 1], ["customer_id", 2], ["customer_type", "Dorsale::CustomerVault::Corporation"], ["payment_term_id", 1], ["date", "2015-09-10"], ["expires_at", "2015-10-10"], ["vat_rate", 20.0], ["total_duty", 0.0], ["vat_amount", 0.0], ["total_all_taxes", 0.0], ["created_at", "2015-09-10 14:10:50.176697"], ["updated_at", "2015-09-10 14:10:50.176697"], ["unique_index", 1], ["tracking_id", "2015-01"]] SQL (0.2ms) INSERT INTO "dorsale_billing_machine_quotation_lines" ("label", "quantity", "unit_price", "quotation_id", "total", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?) [["label", "Développement"], ["quantity", 14.0], ["unit_price", 750.0], ["quotation_id", 1], ["total", 10500.0], ["created_at", "2015-09-10 14:10:50.179511"], ["updated_at", "2015-09-10 14:10:50.179511"]] Dorsale::BillingMachine::Quotation Load (0.2ms) SELECT "dorsale_billing_machine_quotations".* FROM "dorsale_billing_machine_quotations" WHERE "dorsale_billing_machine_quotations"."id" = ? LIMIT 1 [["id", 1]] Dorsale::BillingMachine::IdCard Load (0.0ms) SELECT "dorsale_billing_machine_id_cards".* FROM "dorsale_billing_machine_id_cards" WHERE "dorsale_billing_machine_id_cards"."id" = ? LIMIT 1 [["id", 1]]  (0.1ms) SELECT "dorsale_billing_machine_quotation_lines"."total" FROM "dorsale_billing_machine_quotation_lines" WHERE "dorsale_billing_machine_quotation_lines"."quotation_id" = ? ORDER BY "dorsale_billing_machine_quotation_lines"."created_at" ASC [["quotation_id", 1]] SQL (0.4ms) UPDATE "dorsale_billing_machine_quotations" SET "total_duty" = ?, "vat_amount" = ?, "total_all_taxes" = ?, "updated_at" = ? WHERE "dorsale_billing_machine_quotations"."id" = ? [["total_duty", 10500.0], ["vat_amount", 2100.0], ["total_all_taxes", 12600.0], ["updated_at", "2015-09-10 14:10:50.184563"], ["id", 1]] SQL (0.1ms) INSERT INTO "dorsale_billing_machine_quotation_lines" ("label", "quantity", "unit_price", "quotation_id", "total", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?) [["label", "Gestion de projet"], ["quantity", 5.0], ["unit_price", 1200.0], ["quotation_id", 1], ["total", 6000.0], ["created_at", "2015-09-10 14:10:50.186735"], ["updated_at", "2015-09-10 14:10:50.186735"]] Dorsale::BillingMachine::Quotation Load (0.0ms) SELECT "dorsale_billing_machine_quotations".* FROM "dorsale_billing_machine_quotations" WHERE "dorsale_billing_machine_quotations"."id" = ? LIMIT 1 [["id", 1]] Dorsale::BillingMachine::IdCard Load (0.0ms) SELECT "dorsale_billing_machine_id_cards".* FROM "dorsale_billing_machine_id_cards" WHERE "dorsale_billing_machine_id_cards"."id" = ? LIMIT 1 [["id", 1]]  (0.1ms) SELECT "dorsale_billing_machine_quotation_lines"."total" FROM "dorsale_billing_machine_quotation_lines" WHERE "dorsale_billing_machine_quotation_lines"."quotation_id" = ? ORDER BY "dorsale_billing_machine_quotation_lines"."created_at" ASC [["quotation_id", 1]] SQL (0.1ms) UPDATE "dorsale_billing_machine_quotations" SET "total_duty" = ?, "vat_amount" = ?, "total_all_taxes" = ?, "updated_at" = ? WHERE "dorsale_billing_machine_quotations"."id" = ? [["total_duty", 16500.0], ["vat_amount", 3300.0], ["total_all_taxes", 19800.0], ["updated_at", "2015-09-10 14:10:50.191109"], ["id", 1]]  (1.5ms) commit transaction  (0.1ms) begin transaction SQL (0.4ms) INSERT INTO "dorsale_customer_vault_individuals" ("first_name", "last_name", "email", "phone", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?) [["first_name", "Henri"], ["last_name", "MARTIN"], ["email", "henri.martin@example.com"], ["phone", "04 91 xx xx xx"], ["created_at", "2015-09-10 14:10:50.211979"], ["updated_at", "2015-09-10 14:10:50.211979"]] SQL (0.1ms) INSERT INTO "dorsale_addresses" ("city", "country", "addressable_type", "addressable_id", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?) [["city", "Marseille"], ["country", "France"], ["addressable_type", "Dorsale::CustomerVault::Individual"], ["addressable_id", 1], ["created_at", "2015-09-10 14:10:50.214630"], ["updated_at", "2015-09-10 14:10:50.214630"]] ActsAsTaggableOn::Tag Load (0.2ms) SELECT "tags".* FROM "tags" WHERE (LOWER(name) = LOWER('prospect') OR LOWER(name) = LOWER('potentiel')) ActsAsTaggableOn::Tag Exists (0.1ms) SELECT 1 AS one FROM "tags" WHERE "tags"."name" = 'potentiel' LIMIT 1 SQL (0.1ms) INSERT INTO "tags" ("name") VALUES (?) [["name", "potentiel"]] ActsAsTaggableOn::Tag Load (0.1ms) SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = ? AND "taggings"."taggable_type" = ? AND (taggings.context = 'tags' AND taggings.tagger_id IS NULL) ORDER BY "tags"."name" ASC [["taggable_id", 1], ["taggable_type", "Dorsale::CustomerVault::Individual"]] ActsAsTaggableOn::Tagging Exists (0.1ms) SELECT 1 AS one FROM "taggings" WHERE ("taggings"."tag_id" = 2 AND "taggings"."taggable_type" = 'Dorsale::CustomerVault::Individual' AND "taggings"."taggable_id" = 1 AND "taggings"."context" = 'tags' AND "taggings"."tagger_id" IS NULL AND "taggings"."tagger_type" IS NULL) LIMIT 1 SQL (0.1ms) INSERT INTO "taggings" ("tag_id", "context", "taggable_id", "taggable_type", "created_at") VALUES (?, ?, ?, ?, ?) [["tag_id", 2], ["context", "tags"], ["taggable_id", 1], ["taggable_type", "Dorsale::CustomerVault::Individual"], ["created_at", "2015-09-10 14:10:50.223053"]] ActsAsTaggableOn::Tag Load (0.0ms) SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1 [["id", 2]] SQL (0.1ms) UPDATE "tags" SET "taggings_count" = COALESCE("taggings_count", 0) + 1 WHERE "tags"."id" = ? [["id", 2]] ActsAsTaggableOn::Tagging Exists (0.1ms) SELECT 1 AS one FROM "taggings" WHERE ("taggings"."tag_id" = 4 AND "taggings"."taggable_type" = 'Dorsale::CustomerVault::Individual' AND "taggings"."taggable_id" = 1 AND "taggings"."context" = 'tags' AND "taggings"."tagger_id" IS NULL AND "taggings"."tagger_type" IS NULL) LIMIT 1 SQL (0.1ms) INSERT INTO "taggings" ("tag_id", "context", "taggable_id", "taggable_type", "created_at") VALUES (?, ?, ?, ?, ?) [["tag_id", 4], ["context", "tags"], ["taggable_id", 1], ["taggable_type", "Dorsale::CustomerVault::Individual"], ["created_at", "2015-09-10 14:10:50.227607"]] ActsAsTaggableOn::Tag Load (0.1ms) SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1 [["id", 4]] SQL (0.0ms) UPDATE "tags" SET "taggings_count" = COALESCE("taggings_count", 0) + 1 WHERE "tags"."id" = ? [["id", 4]]  (1.3ms) commit transaction  (0.1ms) begin transaction SQL (0.3ms) INSERT INTO "dorsale_customer_vault_individuals" ("first_name", "last_name", "email", "phone", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?) [["first_name", "Jean"], ["last_name", "DUPONT"], ["email", "jean.dupon@example.com"], ["phone", "04 91 xx xx xx"], ["created_at", "2015-09-10 14:10:50.239163"], ["updated_at", "2015-09-10 14:10:50.239163"]] SQL (0.1ms) INSERT INTO "dorsale_addresses" ("city", "country", "addressable_type", "addressable_id", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?) [["city", "Marseille"], ["country", "France"], ["addressable_type", "Dorsale::CustomerVault::Individual"], ["addressable_id", 2], ["created_at", "2015-09-10 14:10:50.241318"], ["updated_at", "2015-09-10 14:10:50.241318"]] ActsAsTaggableOn::Tag Load (4.0ms) SELECT "tags".* FROM "tags" WHERE (LOWER(name) = LOWER('développeur') OR LOWER(name) = LOWER('rails') OR LOWER(name) = LOWER('freelance')) ActsAsTaggableOn::Tag Exists (0.1ms) SELECT 1 AS one FROM "tags" WHERE "tags"."name" = 'développeur' LIMIT 1 SQL (0.2ms) INSERT INTO "tags" ("name") VALUES (?) [["name", "développeur"]] ActsAsTaggableOn::Tag Exists (0.1ms) SELECT 1 AS one FROM "tags" WHERE "tags"."name" = 'rails' LIMIT 1 SQL (0.1ms) INSERT INTO "tags" ("name") VALUES (?) [["name", "rails"]] ActsAsTaggableOn::Tag Exists (0.1ms) SELECT 1 AS one FROM "tags" WHERE "tags"."name" = 'freelance' LIMIT 1 SQL (0.1ms) INSERT INTO "tags" ("name") VALUES (?) [["name", "freelance"]] ActsAsTaggableOn::Tag Load (0.1ms) SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = ? AND "taggings"."taggable_type" = ? AND (taggings.context = 'tags' AND taggings.tagger_id IS NULL) ORDER BY "tags"."name" ASC [["taggable_id", 2], ["taggable_type", "Dorsale::CustomerVault::Individual"]] ActsAsTaggableOn::Tagging Exists (0.2ms) SELECT 1 AS one FROM "taggings" WHERE ("taggings"."tag_id" = 5 AND "taggings"."taggable_type" = 'Dorsale::CustomerVault::Individual' AND "taggings"."taggable_id" = 2 AND "taggings"."context" = 'tags' AND "taggings"."tagger_id" IS NULL AND "taggings"."tagger_type" IS NULL) LIMIT 1 SQL (0.2ms) INSERT INTO "taggings" ("tag_id", "context", "taggable_id", "taggable_type", "created_at") VALUES (?, ?, ?, ?, ?) [["tag_id", 5], ["context", "tags"], ["taggable_id", 2], ["taggable_type", "Dorsale::CustomerVault::Individual"], ["created_at", "2015-09-10 14:10:50.263426"]] ActsAsTaggableOn::Tag Load (0.1ms) SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1 [["id", 5]] SQL (0.1ms) UPDATE "tags" SET "taggings_count" = COALESCE("taggings_count", 0) + 1 WHERE "tags"."id" = ? [["id", 5]] ActsAsTaggableOn::Tagging Exists (0.1ms) SELECT 1 AS one FROM "taggings" WHERE ("taggings"."tag_id" = 6 AND "taggings"."taggable_type" = 'Dorsale::CustomerVault::Individual' AND "taggings"."taggable_id" = 2 AND "taggings"."context" = 'tags' AND "taggings"."tagger_id" IS NULL AND "taggings"."tagger_type" IS NULL) LIMIT 1 SQL (0.1ms) INSERT INTO "taggings" ("tag_id", "context", "taggable_id", "taggable_type", "created_at") VALUES (?, ?, ?, ?, ?) [["tag_id", 6], ["context", "tags"], ["taggable_id", 2], ["taggable_type", "Dorsale::CustomerVault::Individual"], ["created_at", "2015-09-10 14:10:50.272494"]] ActsAsTaggableOn::Tag Load (0.1ms) SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1 [["id", 6]] SQL (0.1ms) UPDATE "tags" SET "taggings_count" = COALESCE("taggings_count", 0) + 1 WHERE "tags"."id" = ? [["id", 6]] ActsAsTaggableOn::Tagging Exists (0.1ms) SELECT 1 AS one FROM "taggings" WHERE ("taggings"."tag_id" = 7 AND "taggings"."taggable_type" = 'Dorsale::CustomerVault::Individual' AND "taggings"."taggable_id" = 2 AND "taggings"."context" = 'tags' AND "taggings"."tagger_id" IS NULL AND "taggings"."tagger_type" IS NULL) LIMIT 1 SQL (0.1ms) INSERT INTO "taggings" ("tag_id", "context", "taggable_id", "taggable_type", "created_at") VALUES (?, ?, ?, ?, ?) [["tag_id", 7], ["context", "tags"], ["taggable_id", 2], ["taggable_type", "Dorsale::CustomerVault::Individual"], ["created_at", "2015-09-10 14:10:50.279338"]] ActsAsTaggableOn::Tag Load (0.0ms) SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1 [["id", 7]] SQL (0.0ms) UPDATE "tags" SET "taggings_count" = COALESCE("taggings_count", 0) + 1 WHERE "tags"."id" = ? [["id", 7]]  (1.2ms) commit transaction  (0.1ms) begin transaction Dorsale::CustomerVault::Individual Load (0.2ms) SELECT "dorsale_customer_vault_individuals".* FROM "dorsale_customer_vault_individuals" WHERE "dorsale_customer_vault_individuals"."id" = ? LIMIT 1 [["id", 2]] User Exists (0.1ms) SELECT 1 AS one FROM "users" WHERE "users"."email" = 'demo@agilidee.com' LIMIT 1 SQL (0.3ms) INSERT INTO "dorsale_comments" ("text", "author_type", "commentable_id", "commentable_type", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?) [["text", "Développeur, premier contact pour mutualiser un projet."], ["author_type", "User"], ["commentable_id", 2], ["commentable_type", "Dorsale::CustomerVault::Individual"], ["created_at", "2015-09-10 14:10:50.291501"], ["updated_at", "2015-09-10 14:10:50.291501"]]  (1.0ms) commit transaction  (0.1ms) begin transaction  (0.2ms) SELECT COUNT(*) FROM "dorsale_flyboy_folders" WHERE (DATE(created_at) = '2015-09-10') SQL (0.3ms) INSERT INTO "dorsale_flyboy_folders" ("name", "description", "status", "progress", "version", "created_at", "updated_at", "tracking") VALUES (?, ?, ?, ?, ?, ?, ?, ?) [["name", "Dorsale v2"], ["description", "Tâches pour la version 2 de Dorsale"], ["status", "open"], ["progress", 0], ["version", 1], ["created_at", "2015-09-10 14:10:50.323996"], ["updated_at", "2015-09-10 14:10:50.323996"], ["tracking", "150910-1"]]  (1.0ms) commit transaction  (0.1ms) begin transaction Dorsale::Flyboy::Folder Load (0.2ms) SELECT "dorsale_flyboy_folders".* FROM "dorsale_flyboy_folders" WHERE "dorsale_flyboy_folders"."id" = ? LIMIT 1 [["id", 1]] SQL (0.4ms) INSERT INTO "dorsale_flyboy_tasks" ("name", "description", "taskable_id", "taskable_type", "done", "reminder", "term", "progress", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [["name", "Traduction"], ["description", "Traduire en français et en anglais"], ["taskable_id", 1], ["taskable_type", "Dorsale::Flyboy::Folder"], ["done", "f"], ["reminder", "2015-09-17"], ["term", "2015-10-10"], ["progress", 0], ["created_at", "2015-09-10 14:10:50.354967"], ["updated_at", "2015-09-10 14:10:50.354967"]]  (0.2ms) SELECT COUNT(*) FROM "dorsale_flyboy_tasks" WHERE "dorsale_flyboy_tasks"."taskable_id" = ? AND "dorsale_flyboy_tasks"."taskable_type" = ? [["taskable_id", 1], ["taskable_type", "Dorsale::Flyboy::Folder"]]  (0.2ms) SELECT SUM("dorsale_flyboy_tasks"."progress") FROM "dorsale_flyboy_tasks" WHERE "dorsale_flyboy_tasks"."taskable_id" = ? AND "dorsale_flyboy_tasks"."taskable_type" = ? [["taskable_id", 1], ["taskable_type", "Dorsale::Flyboy::Folder"]]  (0.1ms) SELECT COUNT(*) FROM "dorsale_flyboy_tasks" WHERE "dorsale_flyboy_tasks"."taskable_id" = ? AND "dorsale_flyboy_tasks"."taskable_type" = ? [["taskable_id", 1], ["taskable_type", "Dorsale::Flyboy::Folder"]] SQL (0.2ms) UPDATE "dorsale_flyboy_folders" SET "version" = ?, "updated_at" = ? WHERE "dorsale_flyboy_folders"."id" = ? [["version", 2], ["updated_at", "2015-09-10 14:10:50.364191"], ["id", 1]]  (1.1ms) commit transaction  (0.3ms) begin transaction User Exists (0.1ms) SELECT 1 AS one FROM "users" WHERE "users"."email" = 'demo@agilidee.com' LIMIT 1 SQL (0.4ms) INSERT INTO "dorsale_flyboy_task_comments" ("description", "progress", "author_type", "task_id", "date", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?) [["description", "Traduction française terminée"], ["progress", 50], ["author_type", "User"], ["task_id", 1], ["date", "2015-09-10 14:10:50.386932"], ["created_at", "2015-09-10 14:10:50.391431"], ["updated_at", "2015-09-10 14:10:50.391431"]] SQL (0.2ms) UPDATE "dorsale_flyboy_tasks" SET "progress" = ?, "updated_at" = ? WHERE "dorsale_flyboy_tasks"."id" = ? [["progress", 50], ["updated_at", "2015-09-10 14:10:50.393691"], ["id", 1]]  (0.1ms) SELECT COUNT(*) FROM "dorsale_flyboy_tasks" WHERE "dorsale_flyboy_tasks"."taskable_id" = ? AND "dorsale_flyboy_tasks"."taskable_type" = ? [["taskable_id", 1], ["taskable_type", "Dorsale::Flyboy::Folder"]]  (0.0ms) SELECT SUM("dorsale_flyboy_tasks"."progress") FROM "dorsale_flyboy_tasks" WHERE "dorsale_flyboy_tasks"."taskable_id" = ? AND "dorsale_flyboy_tasks"."taskable_type" = ? [["taskable_id", 1], ["taskable_type", "Dorsale::Flyboy::Folder"]]  (0.0ms) SELECT COUNT(*) FROM "dorsale_flyboy_tasks" WHERE "dorsale_flyboy_tasks"."taskable_id" = ? AND "dorsale_flyboy_tasks"."taskable_type" = ? [["taskable_id", 1], ["taskable_type", "Dorsale::Flyboy::Folder"]] SQL (0.2ms) UPDATE "dorsale_flyboy_folders" SET "progress" = ?, "version" = ?, "updated_at" = ? WHERE "dorsale_flyboy_folders"."id" = ? [["progress", 50], ["version", 3], ["updated_at", "2015-09-10 14:10:50.397720"], ["id", 1]]  (1.2ms) commit transaction  (0.1ms) begin transaction Dorsale::Flyboy::Folder Load (0.1ms) SELECT "dorsale_flyboy_folders".* FROM "dorsale_flyboy_folders" WHERE "dorsale_flyboy_folders"."id" = ? LIMIT 1 [["id", 1]] SQL (0.4ms) INSERT INTO "dorsale_flyboy_tasks" ("name", "description", "taskable_id", "taskable_type", "done", "reminder", "term", "progress", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [["name", "Rediger les documentations"], ["description", "Dorsale, CustomerVault, Flyboy, ..."], ["taskable_id", 1], ["taskable_type", "Dorsale::Flyboy::Folder"], ["done", "f"], ["reminder", "2015-09-17"], ["term", "2015-10-10"], ["progress", 0], ["created_at", "2015-09-10 14:10:50.403466"], ["updated_at", "2015-09-10 14:10:50.403466"]]  (0.1ms) SELECT COUNT(*) FROM "dorsale_flyboy_tasks" WHERE "dorsale_flyboy_tasks"."taskable_id" = ? AND "dorsale_flyboy_tasks"."taskable_type" = ? [["taskable_id", 1], ["taskable_type", "Dorsale::Flyboy::Folder"]]  (0.1ms) SELECT SUM("dorsale_flyboy_tasks"."progress") FROM "dorsale_flyboy_tasks" WHERE "dorsale_flyboy_tasks"."taskable_id" = ? AND "dorsale_flyboy_tasks"."taskable_type" = ? [["taskable_id", 1], ["taskable_type", "Dorsale::Flyboy::Folder"]]  (0.1ms) SELECT COUNT(*) FROM "dorsale_flyboy_tasks" WHERE "dorsale_flyboy_tasks"."taskable_id" = ? AND "dorsale_flyboy_tasks"."taskable_type" = ? [["taskable_id", 1], ["taskable_type", "Dorsale::Flyboy::Folder"]] SQL (0.1ms) UPDATE "dorsale_flyboy_folders" SET "progress" = ?, "version" = ?, "updated_at" = ? WHERE "dorsale_flyboy_folders"."id" = ? [["progress", 25], ["version", 4], ["updated_at", "2015-09-10 14:10:50.409166"], ["id", 1]]  (1.2ms) commit transaction  (0.1ms) begin transaction SQL (0.4ms) INSERT INTO "dorsale_flyboy_tasks" ("taskable_id", "taskable_type", "name", "done", "reminder", "term", "progress", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) [["taskable_id", 2], ["taskable_type", "Dorsale::CustomerVault::Corporation"], ["name", "Relancer et se faire payer"], ["done", "f"], ["reminder", "2015-09-17"], ["term", "2015-10-10"], ["progress", 0], ["created_at", "2015-09-10 14:10:50.414017"], ["updated_at", "2015-09-10 14:10:50.414017"]]  (1.1ms) commit transaction  (0.1ms) begin transaction User Exists (0.2ms) SELECT 1 AS one FROM "users" WHERE "users"."email" = 'demo@agilidee.com' LIMIT 1 SQL (0.3ms) INSERT INTO "dorsale_flyboy_task_comments" ("description", "progress", "author_type", "task_id", "date", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?) [["description", "Relance faire aujourd'hui. Paiement d'ici la fin de la semaine."], ["progress", 50], ["author_type", "User"], ["task_id", 3], ["date", "2015-09-10 14:10:50.420529"], ["created_at", "2015-09-10 14:10:50.424426"], ["updated_at", "2015-09-10 14:10:50.424426"]] SQL (0.2ms) UPDATE "dorsale_flyboy_tasks" SET "progress" = ?, "updated_at" = ? WHERE "dorsale_flyboy_tasks"."id" = ? [["progress", 50], ["updated_at", "2015-09-10 14:10:50.427604"], ["id", 3]]  (1.0ms) commit transaction  (3.2ms) CREATE 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)   (1.0ms) CREATE TABLE "dorsale_alexandrie_attachments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "attachable_id" integer, "attachable_type" varchar, "file" varchar)  (0.9ms) CREATE 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)   (1.0ms) CREATE 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)  (0.1ms) select sqlite_version(*)  (1.0ms) CREATE INDEX "index_dorsale_billing_machine_invoice_lines_on_invoice_id" ON "dorsale_billing_machine_invoice_lines" ("invoice_id")  (1.1ms) CREATE 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_duty" decimal, "vat_amount" decimal, "total_all_taxes" decimal, "advance" decimal, "balance" decimal, "unique_index" integer, "vat_rate" decimal, "paid" boolean, "due_date" date, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "tracking_id" varchar)   (1.1ms) CREATE INDEX "index_dorsale_billing_machine_invoices_on_customer_id" ON "dorsale_billing_machine_invoices" ("customer_id")  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_id' AND type='index'   (1.0ms) CREATE INDEX "index_dorsale_billing_machine_invoices_on_customer_type" ON "dorsale_billing_machine_invoices" ("customer_type")  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_type' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_type' AND type='index'   (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_id' AND type='index'  (0.9ms) CREATE INDEX "index_dorsale_billing_machine_invoices_on_id_card_id" ON "dorsale_billing_machine_invoices" ("id_card_id")  (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_invoices_on_id_card_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_invoices_on_id_card_id' AND type='index'  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_type' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_type' AND type='index'   (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_invoices_on_customer_id' AND type='index'  (0.9ms) CREATE INDEX "index_dorsale_billing_machine_invoices_on_payment_term_id" ON "dorsale_billing_machine_invoices" ("payment_term_id")  (1.0ms) 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)  (1.0ms) 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)   (1.2ms) CREATE INDEX "index_dorsale_billing_machine_quotation_lines_on_quotation_id" ON "dorsale_billing_machine_quotation_lines" ("quotation_id")  (1.1ms) 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_duty" decimal, "vat_amount" decimal, "total_all_taxes" decimal, "unique_index" integer, "vat_rate" decimal, "comments" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "expires_at" date, "tracking_id" varchar)   (0.9ms) CREATE INDEX "index_dorsale_billing_machine_quotations_on_customer_id" ON "dorsale_billing_machine_quotations" ("customer_id")  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_id' AND type='index'   (1.0ms) CREATE INDEX "index_dorsale_billing_machine_quotations_on_customer_type" ON "dorsale_billing_machine_quotations" ("customer_type")  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_type' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_type' AND type='index'   (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_id' AND type='index'  (1.0ms) CREATE INDEX "index_dorsale_billing_machine_quotations_on_id_card_id" ON "dorsale_billing_machine_quotations" ("id_card_id")  (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_quotations_on_id_card_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_quotations_on_id_card_id' AND type='index'  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_type' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_type' AND type='index'   (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_billing_machine_quotations_on_customer_id' AND type='index'  (1.1ms) CREATE INDEX "index_dorsale_billing_machine_quotations_on_payment_term_id" ON "dorsale_billing_machine_quotations" ("payment_term_id")  (1.2ms) CREATE 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)  (1.1ms) CREATE TABLE "dorsale_customer_vault_corporations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "short_name" varchar, "email" varchar, "phone" varchar, "fax" varchar, "www" varchar, "legal_form" varchar, "capital" integer, "immatriculation_number_1" varchar, "immatriculation_number_2" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)   (1.2ms) CREATE TABLE "dorsale_customer_vault_individuals" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "first_name" varchar, "last_name" varchar, "short_name" varchar, "email" varchar, "title" varchar, "twitter" varchar, "www" varchar, "context" text, "phone" varchar, "fax" varchar, "mobile" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)  (1.0ms) 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)   (1.1ms) CREATE INDEX "index_dorsale_customer_vault_links_on_alice_id" ON "dorsale_customer_vault_links" ("alice_id")  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_customer_vault_links_on_alice_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_customer_vault_links_on_alice_id' AND type='index'   (1.3ms) CREATE INDEX "index_dorsale_customer_vault_links_on_alice_type" ON "dorsale_customer_vault_links" ("alice_type")  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_customer_vault_links_on_alice_type' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_customer_vault_links_on_alice_type' AND type='index'   (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_customer_vault_links_on_alice_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_customer_vault_links_on_alice_id' AND type='index'  (1.0ms) CREATE INDEX "index_dorsale_customer_vault_links_on_bob_id" ON "dorsale_customer_vault_links" ("bob_id")  (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_customer_vault_links_on_bob_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_customer_vault_links_on_bob_id' AND type='index'  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_dorsale_customer_vault_links_on_alice_type' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_customer_vault_links_on_alice_type' AND type='index'   (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_customer_vault_links_on_alice_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_customer_vault_links_on_alice_id' AND type='index'  (1.0ms) CREATE INDEX "index_dorsale_customer_vault_links_on_bob_type" ON "dorsale_customer_vault_links" ("bob_type")  (1.1ms) 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)  (0.9ms) CREATE INDEX "index_dorsale_flyboy_folders_on_folderable_id" ON "dorsale_flyboy_folders" ("folderable_id")  (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_flyboy_folders_on_folderable_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_flyboy_folders_on_folderable_id' AND type='index'  (1.1ms) CREATE INDEX "index_dorsale_flyboy_folders_on_folderable_type" ON "dorsale_flyboy_folders" ("folderable_type")  (1.1ms) 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)  (1.0ms) CREATE INDEX "index_dorsale_flyboy_task_comments_on_task_id" ON "dorsale_flyboy_task_comments" ("task_id")  (1.0ms) 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_id" integer, "owner_type" varchar)  (1.0ms) CREATE INDEX "index_dorsale_flyboy_tasks_on_taskable_id" ON "dorsale_flyboy_tasks" ("taskable_id")  (0.1ms) SELECT sql FROM sqlite_master WHERE name='index_dorsale_flyboy_tasks_on_taskable_id' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_dorsale_flyboy_tasks_on_taskable_id' AND type='index'  (1.0ms) CREATE INDEX "index_dorsale_flyboy_tasks_on_taskable_type" ON "dorsale_flyboy_tasks" ("taskable_type")  (1.1ms) CREATE TABLE "dummy_models" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)  (1.2ms) 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)   (1.1ms) CREATE UNIQUE INDEX "taggings_idx" ON "taggings" ("tag_id", "taggable_id", "taggable_type", "context", "tagger_id", "tagger_type")  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='taggings_idx' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='taggings_idx' AND type='index'   (1.0ms) CREATE INDEX "index_taggings_on_taggable_id_and_taggable_type_and_context" ON "taggings" ("taggable_id", "taggable_type", "context")  (1.3ms) CREATE TABLE "tags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "taggings_count" integer DEFAULT 0)   (1.0ms) CREATE UNIQUE INDEX "index_tags_on_name" ON "tags" ("name")  (1.3ms) 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)   (1.0ms) CREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_users_on_email' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_users_on_email' AND type='index'   (1.0ms) CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")  (1.1ms) CREATE TABLE "schema_migrations" ("version" varchar NOT NULL)   (0.9ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")  (0.1ms) SELECT version FROM "schema_migrations"  (1.0ms) INSERT INTO "schema_migrations" (version) VALUES ('20150805134318')  (0.9ms) INSERT INTO "schema_migrations" (version) VALUES ('20150616082916')  (0.9ms) INSERT INTO "schema_migrations" (version) VALUES ('20150624081204')  (0.8ms) INSERT INTO "schema_migrations" (version) VALUES ('20150624081205')  (0.8ms) INSERT INTO "schema_migrations" (version) VALUES ('20150624081206')  (0.8ms) INSERT INTO "schema_migrations" (version) VALUES ('20150624081207')  (0.9ms) INSERT INTO "schema_migrations" (version) VALUES ('20150624081208')  (0.9ms) INSERT INTO "schema_migrations" (version) VALUES ('20150803160334')