spec/dummy/db/test.sqlite3 in mechanize_store-0.0.13 vs spec/dummy/db/test.sqlite3 in mechanize_store-0.0.14

- old
+ new

@@ -1,15 +1,14 @@ -SQLite format 3@ ,-% +SQLite format 3@ /-% 8a'Z| == tablemechanize_store_productsmechanize_store_products CREATE TABLE "mechanize_store_products" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "description" text, "short_description" varchar(255), "price" float, "weight" float, "length" float, "height" float, "product_category_id" integer, "created_at" datetime, "updated_at" datetime, "width" float)QQtablemechanize_store_product_categoriesmechanize_store_product_categoriesCREATE TABLE "mechanize_store_product_categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "product_category_id" integer, "created_at" datetime, "updated_at" datetime)+]9Mindexindex_mechanize_store_orders_on_store_idmechanize_store_ordersCREATE INDEX "index_mechanize_store_orders_on_store_id" ON "mechanize_store_orders" ("store_id")@k9iindexindex_mechanize_store_orders_on_order_status_idmechanize_store_ordersCREATE INDEX "index_mechanize_store_orders_on_order_status_id" ON "mechanize_store_orders" ("order_status_id")99)tablemechanize_store_ordersmechanize_store_ordersCREATE TABLE "mechanize_store_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_status_id" integer, "store_id" integer, "delivery_date" datetime, "created_at" datetime, "updated_at" datetime)Q qIuindexindex_mechanize_store_product_photos_on_product_idmechanize_store_product_photosCREATE INDEX "index_mechanize_store_product_photos_on_product_id" ON "mechanize_store_product_photos" ("product_id")c IIAtablemechanize_store_product_photosmechanize_store_product_photos CREATE TABLE "mechanize_store_product_photos" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "file_file_name" varchar(255), "file_content_type" varchar(255), "file_file_size" integer, "file_updated_at" datetime, "product_id" integer, "created_at" datetime, "updated_at" datetime)T w=indexindex_mechanize_store_products_on_product_category_idmechanize_store_products CREATE INDEX "index_mechanize_store_products_on_product_category_id" ON "mechanize_store_products" ("product_category_id")P 77?tablemechanize_store_flagsmechanize_store_flags CREATE TABLE "mechanize_store_flags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime, "updated_at" datetime)0_=Qindexindex_mechanize_store_payments_on_flag_idmechanize_store_payments CREATE INDEX "index_mechanize_store_payments_on_flag_id" ON "mechanize_store_payments" ("flag_id")Ns=yindexindex_mechanize_store_payments_on_payment_status_idmechanize_store_paymentsCREATE INDEX "index_mechanize_store_payments_on_payment_status_id" ON "mechanize_store_payments" ("payment_status_id")O==1tablemechanize_store_paymentsmechanize_store_paymentsCREATE TABLE "mechanize_store_payments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "payment_status_id" integer, "value" float, "paid_value" float, "paid_in" datetime, "plot" integer, "flag_id" integer, "created_at" datetime, "updated_at" datetime)3a=Uindexindex_mechanize_store_freights_on_order_idmechanize_store_freightsCREATE INDEX "index_mechanize_store_freights_on_order_id" ON "mechanize_store_freights" ("order_id")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)==Atablemechanize_store_freightsmechanize_store_freightsCREATE TABLE "mechanize_store_freights" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "value" float, "service" varchar(255), "order_id" integer, "zipcode" varchar(255), "created_at" datetime, "updated_at" datetime)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT  - p^L:( )20140605213358 )20140602124615 )20140417200520 + p^L:()20140606130912)20140606124916)20140606123953 )20140605213358 )20140602124615 )20140417200520 )20140416123100 )20140409191426)20140407193412)20140402192058)20140402153139)20140402140942)20140402140832)20140402140549)20140402140539)20140401203200 -  -|iVC0 -)20140605213358 )20140602124615 )20140417200520 )20140416123100 +|iVC0 +)20140606130912)20140606124916)20140606123953)20140605213358 )20140602124615 )20140417200520 )20140416123100 )20140409191426 )20140407193412)20140402192058)20140402153139)20140402140942)20140402140832)20140402140549)20140402140539) 20140401203200           @@ -19,11 +18,11 @@ " a'Z| == tablemechanize_store_productsmechanize_store_products CREATE TABLE "mechanize_store_products" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "description" text, "short_description" varchar(255), "price" float, "weight" float, "length" float, "height" float, "product_category_id" integer, "created_at" datetime, "updated_at" datetime, "width" float)QQtablemechanize_store_product_categoriesmechanize_store_product_categoriesCREATE TABLE "mechanize_store_product_categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "product_category_id" integer, "created_at" datetime, "updated_at" datetime)+]9Mindexindex_mechanize_store_orders_on_store_idmechanize_store_ordersCREATE INDEX "index_mechanize_store_orders_on_store_id" ON "mechanize_store_orders" ("store_id")@k9iindexindex_mechanize_store_orders_on_order_status_idmechanize_store_ordersCREATE INDEX "index_mechanize_store_orders_on_order_status_id" ON "mechanize_store_orders" ("order_status_id")99)tablemechanize_store_ordersmechanize_store_ordersCREATE TABLE "mechanize_store_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_status_id" integer, "store_id" integer, "delivery_date" datetime, "created_at" datetime, "updated_at" datetime)Q qIuindexindex_mechanize_store_m==gtablemechanize_store_paymentsmechanize_store_paymentsCREATE TABLE "mechanize_store_payments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "payment_status_id" integer, "value" float, "paid_value" float, "paid_in" datetime, "plot" integer, "flag_id" integer, "created_at" datetime, "updated_at" datetime, "payment_type_id" integer)q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version") ==Atablemechanize_store_freightsmechanize_store_freightsCREATE TABLE "mechanize_store_freights" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "value" float, "service" varchar(255), "order_id" integer, "zipcode" varchar(255), "created_at" datetime, "updated_at" datetime)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)3a=Uindexindex_mechanize_store_freights_on_order_idmechanize_store_freightsCREATE INDEX "index_mechanize_store_freights_on_order_id" ON "mechanize_store_freights" ("order_id") *==1tablemechanize_store_0==stablemechanize_store_freightsmechanize_store_freightsCREATE TABLE "mechanize_store_freights" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "value" float, "service" varchar(255), "order_id" integer, "zipcode" varchar(255), "created_at" datetime, "updated_at" datetime, "delivery_time" integer)s=yindexindex_mechanize_store_payments_on_payment_status_idmechanize_store_paymentsCREATE INDEX "index_mechanize_store_payments_on_payment_status_id" ON "mechanize_store_payments" ("payment_status_id")_=Qindexindex_mechanize_store_payments_on_flag_idmechanize_store_payments CREATE INDEX "index_mechanize_store_payments_on_flag_id" ON "mechanize_store_payments" ("flag_id")P 77?tablemechanize_store_flagsmechanize_store_flags CREATE TABLE "mechanize_store_flags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime, "updated_at" datetime)| -== tablemechanize_store_productsmechanize_store_products CREATE TABLE "mechanize_store_products" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "description" text, "short_description" varchar(255), "price" float, "weight" float, "length" float, "height" float, "product_category_id" integer, "created_at" datetime, "updated_at" datetime, "width" float) >  -{| U M -+QQAtablemechanize_store_product_categoriesmechanize_store_product_categoriesCREATE TABLE "mechanize_store_product_categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "product_category_id" integer, "created_at" datetime, "updated_at" datetime, "slug" varchar(255))?i=eindexindex_mechanize_store_payments_on_payment_typemechanize_store_paymentsCREATE INDEX "index_mechanize_store_payments_on_payment_type" ON "mechanize_store_payments" ("payment_type")0_=Qindexindex_mechanize_store_payments_on_flag_idmechanize_store_payments CREATE INDEX "index_mechanize_store_payments_on_flag_id" ON "mechanize_store_payments" ("flag_id") QsEm=mindexindex_mechanize_store_payments_on_payment_statusmechanize_store_paymentsCREATE INDEX "index_mechanize_store_payments_on_payment_status" ON "mechanize_store_payments" ("payment_status")d==[tablemechanize_store_paymentsmechanize_store_paymentsCREATE TABLE "mechanize_store_payments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "payment_status" integer, "value" float, "paid_value" float, "paid_in" datetime, "plot" integer, "flag_id" integer, "created_at" datetime, "updated_at" datetime, "payment_type" integer)EkCiindexindex_mechanize_store_order_items_on_product_idmechanize_store_order_itemsCREATE INDEX "index_mechanize_store_order_items_on_product_id" ON "mechanize_store_order_items" ("product_id")?gCaindexindex_mechanize_store_order_items_on_order_idmechanize_store_order_itemsCREATE INDEX "index_mechanize_store_order_items_on_order_id" ON "mechanize_store_order_items" ("order_id")T w=indexindex_mechanize_store_products_on_product_category_idmechanize_store_products CREATE INDEX "index_mechanize_store_products_on_product_category_id" ON "mechanize_store_products" ("product_category_id")c IIAtablemechanize_store_product_photosmechanize_store_product_photos CREATE TABLE "mechanize_store_product_photos" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "file_file_name" varchar(255), "file_content_type" varchar(255), "file_file_size" integer, "file_updated_at" datetime, "product_id" integer, "created_at" datetime, "updated_at" datetime)Q qIuindexindex_mechanize_store_product_photos_on_product_idmechanize_store_product_photosCREATE INDEX "index_mechanize_store_product_photos_on_product_id" ON "mechanize_store_product_photos" ("product_id")  +]9Mindexindex_mechanize_store_orders_on_store_idmechanize_store_ordersCREATE INDEX "index_mechanize_store_orders_on_store_id" ON "mechanize_store_orders" ("store_id") k7e9]indexindex_mechanize_store_orders_on_order_statusmechanize_store_ordersCREATE INDEX "index_mechanize_store_orders_on_order_status" ON "mechanize_store_orders" ("order_status")99#tablemechanize_store_ordersmechanize_store_ordersCREATE TABLE "mechanize_store_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_status" integer, "store_id" integer, "delivery_date" datetime, "created_at" datetime, "updated_at" datetime)QQtablemechanize_store_product_categoriesmechanize_store_product_categoriesCREATE TABLE "mechanize_store_product_categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "product_category_id" integer, "created_at" datetime, "updated_at" datetime)CC;tablemechanize_store_order_itemsmechanize_store_order_itemsCREATE TABLE "mechanize_store_order_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "quantity" integer, "price" float, "order_id" integer, "product_id" integer, "created_at" datetime, "updated_at" datetime) +== tablemechanize_store_productsmechanize_store_products CREATE TABLE "mechanize_store_products" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "description" text, "short_description" varchar(255), "price" float, "weight" float, "length" float, "height" float, "product_category_id" integer, "created_at" datetime, "updated_at" datetime, "width" float) >  +{| U M + IQQ}tablemechanize_store_product_categoriesmechanize_store_product_categoriesCREATE TABLE "mechanize_store_product_categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "product_category_id" integer, "created_at" datetime, "updated_at" datetime, "slug" varchar(255), "product_section_id" integer)?i=eindexindex_mechanize_store_payments_on_payment_typemechanize_store_paymentsCREATE INDEX "index_mechanize_store_payments_on_payment_type" ON "mechanize_store_payments" ("payment_type")0_=Qindexindex_mechanize_store_payments_on_flag_idmechanize_store_payments CREATE INDEX "index_mechanize_store_payments_on_flag_id" ON "mechanize_store_payments" ("flag_id") Q QEm=mindexindex_mechanize_store_payments_on_payment_statusmechanize_store_paymentsCREATE INDEX "index_mechanize_store_payments_on_payment_status" ON "mechanize_store_payments" ("payment_status")d==[tablemechanize_store_paymentsmechanize_store_paymentsCREATE TABLE "mechanize_store_payments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "payment_status" integer, "value" float, "paid_value" float, "paid_in" datetime, "plot" integer, "flag_id" integer, "created_at" datetime, "updated_at" datetime, "payment_type" integer)EkCiindexindex_mechanize_store_order_items_on_product_idmechanize_store_order_itemsCREATE INDEX "index_mechanize_store_order_items_on_product_id" ON "mechanize_store_order_items" ("product_id")?gCaindexindex_mechanize_store_order_items_on_order_idmechanize_store_order_itemsCREATE INDEX "index_mechanize_store_order_items_on_order_id" ON "mechanize_store_order_items" ("order_id")T w=indexindex_mechanize_store_products_on_product_category_idmechanize_store_products CREATE INDEX "index_mechanize_store_products_on_product_category_id" ON "mechanize_store_products" ("product_category_id")c IIAtablemechanize_store_product_photosmechanize_store_product_photos CREATE TABLE "mechanize_store_product_photos" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "file_file_name" varchar(255), "file_content_type" varchar(255), "file_file_size" integer, "file_updated_at" datetime, "product_id" integer, "created_at" datetime, "updated_at" datetime)Q qIuindexindex_mechanize_store_product_photos_on_product_idmechanize_store_product_photosCREATE INDEX "index_mechanize_store_product_photos_on_product_id" ON "mechanize_store_product_photos" ("product_id")  +]9Mindexindex_mechanize_store_orders_on_store_idmechanize_store_ordersCREATE INDEX "index_mechanize_store_orders_on_store_id" ON "mechanize_store_orders" ("store_id") k7e9]indexindex_mechanize_store_orders_on_order_statusmechanize_store_ordersCREATE INDEX "index_mechanize_store_orders_on_order_status" ON "mechanize_store_orders" ("order_status")99#tablemechanize_store_ordersmechanize_store_ordersCREATE TABLE "mechanize_store_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_status" integer, "store_id" integer, "delivery_date" datetime, "created_at" datetime, "updated_at" datetime)QQtablemMMtablemechanize_store_product_sectionsmechanize_store_product_sectionsCREATE TABLE "mechanize_store_product_sections" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime, "updated_at" datetime, "slug" varchar(255))CC;tablemechanize_store_order_itemsmechanize_store_order_itemsCREATE TABLE "mechanize_store_order_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "quantity" integer, "price" float, "order_id" integer, "product_id" integer, "created_at" datetime, "updated_at" datetime)   -  +   \ No newline at end of file