test/dummy/db/test.sqlite3 in extface-0.5.9 vs test/dummy/db/test.sqlite3 in extface-0.6.0

- old
+ new

@@ -1,12 +1,13 @@ -SQLite format 3@ f -y f- 86 J\JZE -++33posiflex_aura80Posiflex Aura80:lShop==E2016-08-31 00:42:292016-08-31 00:42:29T -%%33daisy_fx1200Daisy Fx1200:lShopm2016-08-31 00:42:292016-08-31 00:42:29Tв7 -%%33datecs_fp550Datect FP550:lShop 72016-08-31 00:42:292016-08-31 00:42:29Lf -33MyUUID2MyString2:lShop#2016-08-31 00:42:292016-08-31 00:42:29LӲr -33MyUUID1MyString1:lShopd2016-08-31 00:42:292016-08-31 00:42:29  shops:l%extface_jobs:l+extface_drivers==E+extface_devices==E9extface_serial_configs:l +~g+MEO33Extface::Driver::Posiflex::Aura802016-08-31 00:42:292016-08-31 00:42:29HE33Extface::Driver::DaisyFx12002016-08-31 00:42:292016-08-31 00:42:29Jв7I33Extface::Driver::Datecs::Fp5502016-08-31 00:42:292016-08-31 00:42:29GԻ C33Extface::Driver::StarScp7002016-08-31 00:42:292016-08-31 00:42:29G]C33Extface::Driver::StarTsp2002016-08-31 00:42:292016-08-31 00:42:29GNC33Extface::Driver::GenericPos2016-08-31 00:42:292016-08-31 00:42:29 1f 332016-08-31 00:42:292016-08-31 00:42:291Ӳr 332016-08-31 00:42:292016-08-31 00:42:29 -ʊf:l ";!<6++/tableextface_devicesextface_devicesCREATE TABLE "extface_devices" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "uuid" varchar(255), "name" varchar(255), "extfaceable_id" integer, "extfaceable_type" varchar(255), "driver_id" integer, "created_at" datetime, "updated_at" datetime, "encoding" varchar(255)) =//indexunique_schema_migrationsschema_migrations CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrations CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq) -CF8%%Otableextface_jobsextface_jobsCREATE TABLE "extface_jobs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "device_id" integer, "created_at" datetime, "updated_at" datetime, "description" varchar(255), "error" varchar(255), "failed_at" datetime, "completed_at" datetime, "connected_at" datetime, "started_at" datetime)O7++Utableextface_driversextface_driversCREATE TABLE "extface_drivers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar(255), "settings" text, "created_at" datetime, "updated_at" datetime) 4f - 33#2016-08-31 00:42:292016-08-31 00:42:294Ӳr - 33d2016-08-31 00:42:292016-08-31 00:42:29 *f332016-08-31 00:42:292016-08-31 00:42:29*Ӳr332016-08-31 00:42:292016-08-31 00:42:29 ^p^ )20160103154233)20160828052036)20140303122506)20140219091811)20140219175006)20140215192111)20140303112124)20140216110608)20140303123022 - V|Vi)20160103154233 )20160828052036)20140303122506)20140219091811)20140219175006)20140215192111)20140303112124)20140216110608) 20140303123022 YY P9K%)indexindex_extface_jobs_on_device_idextface_jobsCREATE INDEX "index_extface_jobs_on_device_id" ON "extface_jobs" ("device_id")& ;utableshopsshops -CREATE TABLE "shops" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime, "updated_at" datetime)d:99ctableextface_serial_configsextface_serial_configs CREATE TABLE "extface_serial_configs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "driver_id" integer, "serial_boud_rate" integer, "serial_data_length" integer, "serial_parity_check" integer, "serial_stop_bits" integer, "serial_handshake" integer, "created_at" datetime, "updated_at" datetime) +SQLite format 3@ ~ + ~-r DB R\ZE +++33posiflex_aura80Posiflex Aura80:lShop==E2017-03-29 00:51:032017-03-29 00:51:03T +%%33daisy_fx1200Daisy Fx1200:lShopm2017-03-29 00:51:032017-03-29 00:51:03RF +##33datecs_dp25Datect DP25:lShop6F2017-03-29 00:51:032017-03-29 00:51:03Tв7 +%%33datecs_fp550Datect FP550:lShop 72017-03-29 00:51:032017-03-29 00:51:03Lf +33MyUUID2MyString2:lShop#2017-03-29 00:51:032017-03-29 00:51:03LӲr +33MyUUID1MyString1:lShopd2017-03-29 00:51:032017-03-29 00:51:03  shops:l%extface_jobs:l+extface_drivers==E+extface_devices==E9extface_serial_configs:l /|gMEO33Extface::Driver::Posiflex::Aura802017-03-29 00:51:032017-03-29 00:51:03HE33Extface::Driver::DaisyFx12002017-03-29 00:51:032017-03-29 00:51:03IFG33Extface::Driver::Datecs::Dp252017-03-29 00:51:032017-03-29 00:51:03Jв7I33Extface::Driver::Datecs::Fp5502017-03-29 00:51:032017-03-29 00:51:03GԻ C33Extface::Driver::StarScp7002017-03-29 00:51:032017-03-29 00:51:03G]C33Extface::Driver::StarTsp2002017-03-29 00:51:032017-03-29 00:51:03GNC33Extface::Driver::GenericPos2017-03-29 00:51:032017-03-29 00:51:03 1f 332017-03-29 00:51:032017-03-29 00:51:031Ӳr 332017-03-29 00:51:032017-03-29 00:51:03 +ʊf:l ";!<B++/tableextface_devicesextface_devicesCREATE TABLE "extface_devices" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "uuid" varchar(255), "name" varchar(255), "extfaceable_id" integer, "extfaceable_type" varchar(255), "driver_id" integer, "created_at" datetime, "updated_at" datetime, "encoding" varchar(255)) =//indexunique_schema_migrationsschema_migrations CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrations CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq) -CFD%%Otableextface_jobsextface_jobsCREATE TABLE "extface_jobs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "device_id" integer, "created_at" datetime, "updated_at" datetime, "description" varchar(255), "error" varchar(255), "failed_at" datetime, "completed_at" datetime, "connected_at" datetime, "started_at" datetime)OC++Utableextface_driversextface_driversCREATE TABLE "extface_drivers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar(255), "settings" text, "created_at" datetime, "updated_at" datetime) 4f + 33#2017-03-29 00:51:032017-03-29 00:51:034Ӳr + 33d2017-03-29 00:51:032017-03-29 00:51:03 *f332017-03-29 00:51:032017-03-29 00:51:03*Ӳr332017-03-29 00:51:032017-03-29 00:51:03 ^p^ )20160103154233)20160828052036)20140303122506)20140219091811)20140219175006)20140215192111)20140303112124)20140216110608)20140303123022 + V|Vi)20160103154233 )20160828052036)20140303122506)20140219091811)20140219175006)20140215192111)20140303112124)20140216110608) 20140303123022 YY PEK%)indexindex_extface_jobs_on_device_idextface_jobsCREATE INDEX "index_extface_jobs_on_device_id" ON "extface_jobs" ("device_id")& Gutableshopsshops +CREATE TABLE "shops" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime, "updated_at" datetime)dF99ctableextface_serial_configsextface_serial_configs CREATE TABLE "extface_serial_configs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "driver_id" integer, "serial_boud_rate" integer, "serial_data_length" integer, "serial_parity_check" integer, "serial_stop_bits" integer, "serial_handshake" integer, "created_at" datetime, "updated_at" datetime) \ No newline at end of file