spec/dummy/db/test.sqlite3 in bookkeeper-0.0.4 vs spec/dummy/db/test.sqlite3 in bookkeeper-0.0.5
- old
+ new
@@ -1,3 +1,10 @@
-SQLite format 3 @ -$
o S59indexindex_bookkeeper_purchases_on_titlebookkeeper_purchasesCREATE INDEX "index_bookkeeper_purchases_on_title" ON "bookkeeper_purchases" ("title")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)?55!tablebookkeeper_purchasesbookkeeper_purchasesCREATE TABLE "bookkeeper_purchases" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "description" text, "purchase_date" date, "warranty_duration" integer, "receipt" varchar(255), "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 NULL)
)20130215165240
- ) 20130215165240
-
+SQLite format 3 @
-$
b b
o
+ )
u55
tablebookkeeper_purchasesbookkeeper_purchasesCREATE TABLE "bookkeeper_purchases" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "description" text, "purchase_date" date, "warranty_duration" integer, "receipt" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "invoice" boolean DEFAULT 'f', "amount" decimal(8,2)),_5Qindexindex_bookkeeper_movements_on_descriptionbookkeeper_movementsCREATE INDEX "index_bookkeeper_movements_on_description" ON "bookkeeper_movements" ("description")
+U5=indexindex_bookkeeper_movements_on_amountbookkeeper_movementsCREATE INDEX "index_bookkeeper_movements_on_amount" ON "bookkeeper_movements" ("amount")) ]5Mindexindex_bookkeeper_movements_on_account_idbookkeeper_movements
+CREATE INDEX "index_bookkeeper_movements_on_account_id" ON "bookkeeper_movements" ("account_id")55Itablebookkeeper_movementsbookkeeper_movements CREATE TABLE "bookkeeper_movements" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "account_id" integer, "amount" decimal(8,2), "description" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)Q35indexindex_bookkeeper_accounts_on_titlebookkeeper_accountsCREATE INDEX "index_bookkeeper_accounts_on_title" ON "bookkeeper_accounts" ("title")K33=tablebookkeeper_accountsbookkeeper_accountsCREATE TABLE "bookkeeper_accounts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "initial_balance" decimal(8,2) DEFAULT 0, "balance" decimal(8,2), "start_date" datetime, "end_date" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)S59indexindex_bookkeeper_purchases_on_titlebookkeeper_purchasesCREATE INDEX "index_bookkeeper_purchases_on_title" ON "bookkeeper_purchases" ("title")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq) 55!tablebookkeeper_purc!77atablebookkeeper_categoriesbookkeeper_categories
CREATE TABLE "bookkeeper_categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "categorizable_id" integer, "categorizable_type" varchar(255), "name" varchar(255), "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 NULL)
)20130308231918)20130308231159)20130228234703)20130228234536)20130215165240
+ )20130308231918)20130308231159)20130228234703)20130228234536) 20130215165240
+
+
+
+
+
\ No newline at end of file