spec/dummy/db/test.sqlite3 in dorsale-2.2.2 vs spec/dummy/db/test.sqlite3 in dorsale-2.2.3
- old
+ new
@@ -1,156 +1,38 @@
-SQLite format 3 @ a T 7 ! k a -
+SQLite format 3 @ 3 k -
/:=RN 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)II+tabledorsale_alexandrie_attachmentsdorsale_alexandrie_attachmentsCREATE TABLE "dorsale_alexandrie_attachments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "attachable_id" integer, "attachable_type" varchar, "file" varchar, "sender_id" integer, "sender_type" varchar)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 R
Y
-
-/ pF]3 t J /!AAS3 Rue Marx Dormoy1er étageMarseille13004France2015-11-23 15:14:48.4306792015-11-23 15:14:48.430679Dorsale::CustomerVault::Corporation /!AAS3 Rue Marx Dormoy1er étageMarseille13004France2015-11-23 15:14:48.4143012015-11-23 15:14:48.414301Dorsale::CustomerVault::Corporation /!AAS3 Rue Marx Dormoy1er étageMarseille13004France2015-11-23 15:14:48.3975382015-11-23 15:14:48.397538Dorsale::CustomerVault::Corporation /!AAS3 Rue Marx Dormoy1er étageMarseille13004France2015-11-23 15:14:48.3798402015-11-23 15:14:48.379840Dorsale::CustomerVault::Corporation /!AAS3 Rue Marx Dormoy1er étageMarseille13004France2015-11-23 15:14:48.3628122015-11-23 15:14:48.362812Dorsale::CustomerVault::Corporation /!AAS3 Rue Marx Dormoy1er étageMarseille13004France2015-11-23 15:14:48.3469592015-11-23 15:14:48.346959Dorsale::CustomerVault::Corporation /!AAS3 Rue Marx Dormoy1er étageMarseille13004France2015-11-23 15:14:48.3307512015-11-23 15:14:48.330751Dorsale::CustomerVault::Corporation /!AAS3 Rue Marx Dormoy1er étageMarseille13004France2015-11-23 15:14:48.3141662015-11-23 15:14:48.314166Dorsale::CustomerVault::Corporation /!AAS3 Rue Marx Dormoy1er étageMarseille13004France2015-11-23 15:14:48.2976112015-11-23 15:14:48.297611Dorsale::CustomerVault::Corporation /!AAS3 Rue Marx Dormoy1er étageMarseille13004France2015-11-23 15:14:48.2809162015-11-23 15:14:48.280916Dorsale::CustomerVault::Corporation /!AAS3 Rue Marx Dormoy1er étageMarseille13004France2015-11-23 15:14:48.2648702015-11-23 15:14:48.264870Dorsale::CustomerVault::Corporation /!AAS3 Rue Marx Dormoy1er étageMarseille13004France2015-11-23 15:14:48.2493072015-11-23 15:14:48.249307Dorsale::CustomerVault::Corporation /!AAS3 Rue Marx Dormoy1er étageMarseille13004France2015-11-23 15:14:48.2327112015-11-23 15:14:48.232711Dorsale::CustomerVault::Corporation /!AAS3 Rue Marx Dormoy1er étageMarseille13004France2015-11-23 15:14:48.2162862015-11-23 15:14:48.216286Dorsale::CustomerVault::Corporation
/!AAS3 Rue Marx Dormoy1er étageMarseille13004France2015-11-23 15:14:48.1995462015-11-23 15:14:48.199546
Dorsale::CustomerVault::Corporation /!AAS3 Rue Marx Dormoy1er étageMarseille13004France2015-11-23 15:14:48.1833622015-11-23 15:14:48.183362Dorsale::CustomerVault::Corporation /!AAS3 Rue Marx Dormoy1er étageMarseille13004France2015-11-23 15:14:48.1672442015-11-23 15:14:48.167244Dorsale::CustomerVault::Corporation
- /!AAS3 Rue Marx Dormoy1er étageMarseille13004France2015-11-23 15:14:48.1505612015-11-23 15:14:48.150561
-Dorsale::CustomerVault::Corporation /!AAS3 Rue Marx Dormoy1er étageMarseille13004France2015-11-23 15:14:48.1341592015-11-23 15:14:48.134159 Dorsale::CustomerVault::Corporation /!AAS3 Rue Marx Dormoy1er étageMarseille13004France2015-11-23 15:14:48.1183032015-11-23 15:14:48.118303Dorsale::CustomerVault::Corporation /!AAS3 Rue Marx Dormoy1er étageMarseille13004France2015-11-23 15:14:48.1019822015-11-23 15:14:48.101982Dorsale::CustomerVault::Corporation /!AAS3 Rue Marx Dormoy1er étageMarseille13004France2015-11-23 15:14:48.0860072015-11-23 15:14:48.086007Dorsale::CustomerVault::Corporation /!AAS3 Rue Marx Dormoy1er étageMarseille13004France2015-11-23 15:14:48.0576822015-11-23 15:14:48.057682Dorsale::CustomerVault::Corporation /!AAS3 Rue Marx Dormoy1er étageMarseille13004France2015-11-23 15:14:48.0254742015-11-23 15:14:48.025474Dorsale::CustomerVault::Corporation /!AAS3 Rue Marx Dormoy1er étageMarseille13004France2015-11-23 15:14:48.0089402015-11-23 15:14:48.008940Dorsale::CustomerVault::Corporation /!AAS3 Rue Marx Dormoy1er étageMarseille13004France2015-11-23 15:14:47.9921682015-11-23 15:14:47.992168Dorsale::CustomerVault::Corporation /!AA S3 Rue Marx Dormoy1er étageMarseille13004France2015-11-23 15:15:20.0089092015-11-23 15:15:20.008909Dorsale::CustomerVault::Corporation
TTT )Wdorsale_billing_machine_invoice_linesM dorsal(W dorsale_billing_machine_invoice_lines#M dorsale_billing_machine_invoices*[ dorsale_billing_machine_quotation_lines%Q dorsale_billing_machine_quotations O dorsale_billing_machine_payment_terms % dorsale_billing_machine_id_cards users
~ T
-# '%'