test/dummy/db/development.sqlite3 in invoice_bar-0.0.3 vs test/dummy/db/development.sqlite3 in invoice_bar-0.0.4

- old
+ new

@@ -1,17 +1,17 @@ -SQLite format 3@ ++- +SQLite format 3@ 00- 5b+ //3tableinvoice_bar_itemsinvoice_bar_itemsCREATE TABLE "invoice_bar_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "price" integer NOT NULL, "unit" varchar(255), "number" integer, "amount" integer NOT NULL, "itemable_id" integer NOT NULL, "itemable_type" varchar(255) NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) Q55indexindex_invoice_bar_accounts_on_nameinvoice_bar_accountsCREATE INDEX "index_invoice_bar_accounts_on_name" ON "invoice_bar_accounts" ("name")" 55gtableinvoice_bar_accountsinvoice_bar_accounts CREATE TABLE "invoice_bar_accounts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "user_id" integer NOT NULL, "bank_account_number" varchar(255), "iban" varchar(255), "swift" varchar(255), "amount" integer DEFAULT 0 NOT NULL, "currency_id" integer DEFAULT 1 NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)c 5indexindex_invoice_bar_invoices_on_payment_identification_numberinvoice_bar_invoices CREATE INDEX "index_invoice_bar_invoices_on_payment_identification_number" ON "invoice_bar_invoices" ("payment_identification_number")) ]5Mindexindex_invoice_bar_invoices_on_contact_icinvoice_bar_invoices CREATE INDEX "index_invoice_bar_invoices_on_contact_ic" ON "invoice_bar_invoices" ("contact_ic")/ a5Uindexindex_invoice_bar_invoices_on_contact_nameinvoice_bar_invoices CREATE INDEX "index_invoice_bar_invoices_on_contact_name" ON "invoice_bar_invoices" ("contact_name")U5=indexindex_invoice_bar_invoices_on_numberinvoice_bar_invoices CREATE INDEX "index_invoice_bar_invoices_on_number" ON "invoice_bar_invoices" ("number")~55tableinvoice_bar_invoicesinvoice_bar_invoicesCREATE TABLE "invoice_bar_invoices" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(255) NOT NULL, "issue_date" date NOT NULL, "due_date" date NOT NULL, "contact_name" varchar(255) NOT NULL, "contact_ic" integer, "contact_dic" varchar(255), "user_id" integer NOT NULL, "payment_identification_number" integer, "account_id" integer NOT NULL, "amount" integer NOT NULL, "sent" boolean DEFAULT 'f' NOT NULL, "paid" boolean DEFAULT 'f' NOT NULL, "issuer" boolean DEFAULT 't' NOT NULL, "receipt_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL);cGYindexindex_invoice_bar_invoice_templates_on_nameinvoice_bar_invoice_templatesCREATE INDEX "index_invoice_bar_invoice_templates_on_name" ON "invoice_bar_invoice_templates" ("name")ZGG3tableinvoice_bar_invoice_templatesinvoice_bar_invoice_templatesCREATE TABLE "invoice_bar_invoice_templates" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "issue_date" date, "due_date" date, "contact_name" varchar(255), "contact_ic" integer, "contact_dic" varchar(255), "user_id" integer, "payment_identification_number" integer, "account_id" integer, "amount" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)^77[tableinvoice_bar_addressesinvoice_bar_addressesCREATE TABLE "invoice_bar_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "street" varchar(255) NOT NULL, "street_number" varchar(255) NOT NULL, "city" varchar(255) NOT NULL, "city_part" varchar(255), "postcode" varchar(255) NOT NULL, "extra_address_line" varchar(255), "addressable_id" integer NOT NULL, "addressable_type" varchar(255) NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT  Lp^L )20121229162039 )20121229162038)20121229162037)20121229162036)20121229162035)20121229162034)20121229162033)20121229162032)20121229162031)20121229162030 B{hUB)20121229162039 -)20121229162038 )20121229162037)20121229162036)20121229162035)20121229162034)20121229162033)20121229162032)20121229162031)20121229162030  7u c   3AAhfghf44gfhfgh45InvoiceBar::Receipt2012-12-30 18:37:17.4690292012-12-30 18:37:17.469029k '  -AAulice356koberice2333374727InvoiceBar::User2012-12-29 16:47:11.3626052012-12-29 19:14:41.656770^   -AAsfdsdsfdsf456InvoiceBar::User2012-12-29 18:17:15.8427602012-12-29 18:17:15.842760b  3AAdfs56dfs4566InvoiceBar::Receipt2012-12-29 16:48:26.1251872012-12-29 16:48:26.125187`   3AAdfs56dfs4566InvoiceBar::Invoice2012-12-29 16:48:14.2005162012-12-29 16:48:14.200516b   3AAsdfgs456fgdg56InvoiceBar::Contact2012-12-29 19:42:44.1513832012-12-29 19:42:44.151383 +)20121229162038 )20121229162037)20121229162036)20121229162035)20121229162034)20121229162033)20121229162032)20121229162031)20121229162030  7u ? a   -AAfdfs3443dfs43434InvoiceBar::User2013-01-02 18:57:59.0867732013-01-02 18:57:59.086773b   -AAfggdfg44fgdg43444InvoiceBar::User2013-01-02 18:57:02.2020442013-01-02 18:57:02.202044c   3AAhfghf44gfhfgh45InvoiceBar::Receipt2012-12-30 18:37:17.4690292012-12-30 18:37:17.469029k '  -AAulice356koberice2333374727InvoiceBar::User2012-12-29 16:47:11.3626052012-12-29 19:14:41.656770^   -AAsfdsdsfdsf456InvoiceBar::User2012-12-29 18:17:15.8427602012-12-29 18:17:15.842760b  3AAdfs56dfs4566InvoiceBar::Receipt2012-12-29 16:48:26.1251872012-12-29 16:48:26.125187`   3AAdfs56dfs4566InvoiceBar::Invoice2012-12-29 16:48:14.2005162012-12-29 16:48:14.200516b   3AAsdfgs456fgdg56InvoiceBar::Contact2012-12-29 19:42:44.1513832012-12-29 19:42:44.151383 ~gM3! -Ginvoice_bar_invoice_templates! Ginvoice_bar_receipt_templates5invoice_bar_contacts5invoice_bar_receipts/invoice_bar_items5invoice_bar_invoices5invoice_bar_accounts9invoice_bar_currencies7invoice_bar_addresses/invoice_bar_users H AAhgh2012-12-30 16:37:22.4456092012-12-30 16:37:22.445609 +Ginvoice_bar_invoice_templates! Ginvoice_bar_receipt_templates5invoice_bar_contacts5invoice_bar_receipts/invoice_bar_items5invoice_bar_invoices5invoice_bar_accounts9invoice_bar_currencies7invoice_bar_addresses/invoice_bar_users H AAhgh2012-12-30 16:37:22.4456092012-12-30 16:37:22.445609 hgh t%!! AAPF20121200012012-12-292013-01-12dsffsttf2012-12-29 16:48:14.1976832012-12-30 18:06:39.205276 %PF2012120001  dsffs   F  AAdfsf2012-12-29 16:47:53.0545822012-12-30 18:14:14.563588 @@ -20,12 +20,12 @@ V < {rzq//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)=//indexunique_schemq//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")^77[tableinvoice_bar_addressesinvoice_bar_addressesCREATE TABLE "invoice_bar_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "street" varchar(255) NOT NULL, "street_number" varchar(255) NOT NULL, "city" varchar(255) NOT NULL, "city_part" varchar(255), "postcode" varchar(255) NOT NULL, "extra_address_line" varchar(255), "addressable_id" integer NOT NULL, "addressable_type" varchar(255) NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)ZGG3tableinvoice_bar_invoice_templatesinvoice_bar_invoice_templatesCREATE TABLE "invoice_bar_invoice_templates" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "issue_date" date, "due_date" date, "contact_name" varchar(255), "contact_ic" integer, "contact_dic" varchar(255), "user_id" integer, "payment_identification_number" integer, "account_id" integer, "amount" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL);cGYindexindex_invoice_bar_invoice_templates_on_nameinvoice_bar_invoice_templatesCREATE INDEX "index_invoice_bar_invoice_templates_on_name" ON "invoice_bar_invoice_templates" ("name")~55tableinvoice_bar_invoicesinvoice_bar_invoicesCREATE TABLE "invoice_bar_invoices" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(255) NOT NULL, "issue_date" date NOT NULL, "due_date" date NOT NULL, "contact_name" varchar(255) NOT NULL, "contact_ic" integer, "contact_dic" varchar(255), "user_id" integer NOT NULL, "payment_identification_number" integer, "account_id" integer NOT NULL, "amount" integer NOT NULL, "sent" boolean DEFAULT 'f' NOT NULL, "paid" boolean DEFAULT 'f' NOT NULL, "issuer" boolean DEFAULT 't' NOT NULL, "receipt_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)U5=indexindex_invoice_bar_invoices_on_numberinvoice_bar_invoices CREATE INDEX "index_invoice_bar_invoices_on_number" ON "invoice_bar_invoices" ("number")/ a5Uindexindex_invoice_bar_invoices_on_contact_nameinvoice_bar_invoices CREATE INDEX "index_invoice_bar_invoices_on_contact_name" ON "invoice_bar_invoices" ("contact_name")) ]5Mindexindex_invoice_bar_invoices_on_contact_icinvoice_bar_invoices CREATE INDEX "index_invoice_bar_invoices_on_contact_ic" ON "invoice_bar_invoices" ("contact_ic")c 5indexindex_invoice_bar_invoices_on_payment_identification_numberinvoice_bar_invoices CREATE INDEX "index_invoice_bar_invoices_on_payment_identification_number" ON "invoice_bar_invoices" ("payment_identification_number")" 55gtableinvoice_bar_accountsinvoice_bar_accounts CREATE TABLE "invoice_bar_accounts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "user_id" integer NOT NULL, "bank_account_number" varchar(255), "iban" varchar(255), "swift" varchar(255), "amount" integer DEFAULT 0 NOT NULL, "currency_id" integer DEFAULT 1 NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) Q55indexindex_invoice_bar_accounts_on_nameinvoice_bar_accountsCREATE INDEX "index_invoice_bar_accounts_on_name" ON "invoice_bar_accounts" ("name")//3tableinvoice_bar_itemsinvoice_bar_itemsCREATE TABLE "invoice_bar_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "price" integer NOT NULL, "unit" varchar(255), "number" integer, "amount" integer NOT NULL, "itemable_id" integer NOT NULL, "itemable_type" varchar(255) NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)  dsfds ^(V  _ ]^;cGYindexindex_invoice_bar_receipt_templates_on_nameinvoice_bar_receipt_templatesCREATE INDEX "index_invoice_bar_receipt_templates_on_name" ON "invoice_bar_receipt_templates" ("name") K/)indexindex_invoice_bar_items_on_nameinvoice_bar_itemsCREATE INDEX "index_invoice_bar_items_on_name" ON "invoice_bar_items" ("name")u99tableinvoice_bar_currenciesinvoice_bar_currenciesCREATE TABLE "invoice_bar_currencies" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "symbol" varchar(255) NOT NULL, "priority" integer DEFAULT 1 NOT NULL)55)tableinvoice_bar_contactsinvoice_bar_contactsCREATE TABLE "invoice_bar_contacts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "email" varchar(255), "phone" varchar(255), "web" varchar(255), "bank_account" varchar(255), "ic" integer, "dic" varchar(255), "user_id" integer NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)Q55indexindex_invoice_bar_contacts_on_nameinvoice_bar_contactsCREATE INDEX "index_invoice_bar_contacts_on_name" ON "invoice_bar_contacts" ("name")M5-indexindex_invoice_bar_contacts_on_icinvoice_bar_contactsCREATE INDEX "index_invoice_bar_contacts_on_ic" ON "invoice_bar_contacts" ("ic")5//tableinvoice_bar_usersinvoice_bar_usersCREATE TABLE "invoice_bar_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar(255) NOT NULL, "crypted_password" varchar(255), "salt" varchar(255), "remember_me_token" varchar(255), "remember_me_token_expires_at" datetime, "reset_password_token" varchar(255), "reset_password_token_expires_at" datetime, "reset_password_email_sent_at" datetime, "name" varchar(255) NOT NULL, "phone" varchar(255), "web" varchar(255), "ic" integer NOT NULL, "next_invoice_number" integer DEFAULT 1 NOT NULL, "next_bill_number" integer DEFAULT 1 NOT NULL, "next_received_bill_number" integer DEFAULT 1 NOT NULL, "invoice_number_format" varchar(255) DEFAULT '%Y%m%d%2' NOT NULL, "bill_number_format" varchar(255) DEFAULT '%Y%m%d%2' NOT NULL, "received_bill_number_format" varchar(255) DEFAULT '%Y%m%d%2' NOT NULL, "administrator" boolean, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL);k/iindexindex_invoice_bar_users_on_reset_password_tokeninvoice_bar_usersCREATE INDEX "index_invoice_bar_users_on_reset_password_token" ON "invoice_bar_users" ("reset_password_token")2e/]indexindex_invoice_bar_users_on_remember_me_tokeninvoice_bar_usersCREATE INDEX "index_invoice_bar_users_on_remember_me_token" ON "invoice_bar_users" ("remember_me_token")[55Ytableinvoice_bar_receiptsinvoice_bar_receiptsCREATE TABLE "invoice_bar_receipts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(255) NOT NULL, "issue_date" date NOT NULL, "contact_name" varchar(255) NOT NULL, "contact_ic" integer, "contact_dic" varchar(255), "user_id" integer NOT NULL, "account_id" integer NOT NULL, "amount" integer NOT NULL, "issuer" boolean DEFAULT 't' NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)U5=indexindex_invoice_bar_receipts_on_numberinvoice_bar_receiptsCREATE INDEX "index_invoice_bar_receipts_on_number" ON "invoice_bar_receipts" ("number")/a5Uindexindex_invoice_bar_receipts_on_contact_nameinvoice_bar_receiptsCREATE INDEX "index_invoice_bar_receipts_on_contact_name" ON "invoice_bar_receipts" ("contact_name"))]5Mindexindex_invoice_bar_receipts_on_contact_icinvoice_bar_receiptsCREATE INDEX "index_invoice_bar_receipts_on_contact_ic" ON "invoice_bar_receipts" ("contact_ic") GG?tableinvoice_bar_receipt_templatesinvoice_bar_receipt_templatesCREATE TABLE "invoice_bar_receipt_templates" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "issue_date" date, "contact_name" varchar(255), "contact_ic" integer, "contact_dic" varchar(255), "user_id" integer, "account_id" integer, "amount" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) F   AAdfgN2012-12-29 19:42:44.1483292012-12-29 19:42:44.148329 dfg -N - Z-Q15AAstrzibny@gmail.com$2a$10$GMsWF53LIA7U6N6WySIAK.VRO30fwkbMUaTUjkrKI5/B35eoW4/dCvxhptvHqdKmCcc7Jcat1gfgdW%Y%m%d%2%Y%m%d%2%Y%m%d%2t2012-12-29 16:47:11.3009502012-12-29 19:38:11.240936P35AA2strzibny@gmail.com$2a$10$I6jkYwvnephbiFj5NSRFe.8hBoEhooR6mRSIjCqIHi9.XfQuQiTX6Z5VZsB6GjtFoSyh1Wg8Qdfsf%Y%m%d%2%Y%m%d%2%Y%m%d%22012-12-29 18:17:15.8397262012-12-29 18:17:15.83972615AAstrzibny@gmail.com$2a$10$GMsWF53LIA7U6N6WySIAK.VRO30fwkbMUaTUjkrKI5/B35eoW4/dCvxhptvHqdKmCcc7Jcat1gfgd%Y%m%d%2%Y%m%d%2%Y%m%d%2t2012-12-29 16:47:11.3009502012-12-29 16:47:11.300950 - -vXDQj7bxgM4 a %! AAPD20121200012012-12-30dfsfft2012-12-30 18:37:17.4661472012-12-30 18:37:17.466147 +N - Zx Q35AAstrzibny2@gmail.com$2a$10$KpXLdi2DvJ85LLWI9yZ0mOohcDBpKPvLoilL5uKdw8xcIPMb7kVXarGBwCizWNJ8ptxZ67yyKjmeno%Y%m%d%2%Y%m%d%2%Y%m%d%22013-01-02 18:57:59.0619642013-01-02 18:57:59.061964Q15AAstrzibny@gmail.com$2a$10$GMsWF53LIA7U6N6WySIAK.VRO30fwkbMUaTUjkrKI5/B35eoW4/dCvxhptvHqdKmCcc7Jcat1gfgdW%Y%m%d%2%Y%m%d%2%Y%m%d%2t2012-12-29 16:47:11.3009502012-12-29 19:38:11.240936P35AA2strzibny@gmail.com$2a$10$I6jkYwvnephbiFj5NSRFe.8hBoEhooR6mRSIjCqIHi9.XfQuQiTX6Z5VZsB6GjtFoSyh1Wg8Qdfsf%Y%m%d%2%Y%m%d%2%Y%m%d%22012-12-29 18:17:15.8397262012-12-29 18:17:15.839726K15AAstrzibny@gmail.com$2a$10$GMsWF53LIA7U6N6WySIAK.V9AAstrzibny@strzibny.namejmenosa%Y%m%d%2%Y%m%d%2%Y%m%d%22013-01-02 18:57:02.0465322013-01-02 18:57:02.046532 + +v a %! AAPD20121200012012-12-30dfsfft2012-12-30 18:37:17.4661472012-12-30 18:37:17.466147 %PD2012120001 dfsf f F  AAhhh2012-12-30 16:32:43.9612642012-12-30 16:32:43.961264 hhh \ No newline at end of file