spec/dummy/db/test.sqlite3 in dorsale-2.2.8 vs spec/dummy/db/test.sqlite3 in dorsale-2.2.9
- old
+ new
@@ -1,9 +1,9 @@
-SQLite format 3 @ 3 k -
+SQLite format 3 @
; 6 k
-
/ hMindexindex_dorsale_billing_machine_invoices_on_payment_term_iddorsale_billing_machine_invoicesCREATE INDEX "index_dorsale_billing_machine_invoices_on_payment_term_id" ON "dorsale_billing_machine_invoices" ("payment_term_id")Y
uM}indexindex_dorsale_billing_machine_invoices_on_id_card_iddorsale_billing_machine_invoicesCREATE INDEX "index_dorsale_billing_machine_invoices_on_id_card_id" ON "dorsale_billing_machine_invoices" ("id_card_id")b {M indexindex_dorsale_billing_machine_invoices_on_customer_typedorsale_billing_machine_invoices
-CREATE INDEX "index_dorsale_billing_machine_invoices_on_customer_type" ON "dorsale_billing_machine_invoices" ("customer_type")\wMindexindex_dorsale_billing_machine_invoices_on_customer_iddorsale_billing_machine_invoices CREATE INDEX "index_dorsale_billing_machine_invoices_on_customer_id" ON "dorsale_billing_machine_invoices" ("customer_id")ZMM'tabledorsale_billing_machine_invoicesdorsale_billing_machine_invoicesCREATE TABLE "dorsale_billing_machine_invoices" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "customer_id" integer, "customer_type" varchar, "payment_term_id" integer, "id_card_id" integer, "date" date, "label" varchar, "total_excluding_taxes" decimal, "vat_amount" decimal, "total_including_taxes" decimal, "advance" decimal, "balance" decimal, "unique_index" integer, "paid" boolean, "due_date" date, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "tracking_id" varchar, "commercial_discount" decimal)mWindexindex_dorsale_billing_machine_invoice_lines_on_invoice_iddorsale_billing_machine_invoice_linesCREATE INDEX "index_dorsale_billing_machine_invoice_lines_on_invoice_id" ON "dorsale_billing_machine_invoice_lines" ("invoice_id") WW_tabledorsale_billing_machine_invoice_linesdorsale_billing_machine_invoice_linesCREATE TABLE "dorsale_billing_machine_invoice_lines" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "invoice_id" integer, "label" text, "quantity" decimal, "unit" varchar, "unit_price" decimal, "total" decimal, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "vat_rate" decimal)MMtabledorsale_billing_machine_id_cardsdorsale_billing_machine_id_cardsCREATE TABLE "dorsale_billing_machine_id_cards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "id_card_name" varchar, "entity_name" varchar, "siret" varchar, "legal_form" varchar, "capital" integer, "registration_number" varchar, "intracommunity_vat" varchar, "address1" varchar, "address2" varchar, "zip" varchar, "city" varchar, "phone" varchar, "contact_full_name" varchar, "contact_phone" varchar, "contact_address_1" varchar, "contact_address_2" varchar, "contact_zip" varchar, "contact_city" varchar, "iban" varchar, "bic_swift" varchar, "bank_name" varchar, "bank_address" varchar, "ape_naf" varchar, "custom_info_1" text, "custom_info_2" text, "custom_info_3" text, "contact_fax" varchar, "contact_email" varchar, "logo" varchar, "registration_city" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)VII'tabledorsale_alexandrie_attachmentsdorsale_alexandrie_attachmentsCREATE TABLE "dorsale_alexandrie_attachments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "attachable_id" integer, "attachable_type" varchar, "file" varchar, "sender_id" integer, "sender_type" varchar, "name" varchar, "created_at" datetime, "updated_at" datetime)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)Q//Qtabledorsale_addressesdorsale_addressesCREATE TABLE "dorsale_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "street" varchar, "street_bis" varchar, "city" varchar, "zip" varchar, "country" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "addressable_id" integer, "addressable L A 4
l /!AA S3 Rue Marx Dormoy1er étageMarseille13004France2015-12-16 14:22:36.5108412015-12-16 14:22:36.510841Dorsale::CustomerVault::Corporation
::$ / dorsale_addresses&S dorsale_customer_vault_corporations dorsale_billing_machine_invoice_lines#M dorsale_billing_machi9dorsale_flyboy_folders dorsale_flyboy_tasks 5dorsale_flyboy_tasks users
~ # '%'