test/dummy/db/test.sqlite3 in extface-0.5.6 vs test/dummy/db/test.sqlite3 in extface-0.5.7
- old
+ new
@@ -1,9 +1,12 @@
-SQLite format 3 @
- M
^ S %%33daisy_fx1200Daisy Fx1200:lShopm2015-12-20 19:45:302015-12-20 19:45:30Sв7 %%33datecs_fp550Datect FP550:lShop
72015-12-20 19:45:302015-12-20 19:45:30Kf 33MyUUID2MyString2:lShop# 2015-12-20 19:45:302015-12-20 19:45:30KӲr 33MyUUID1MyString1:lShopd2015-12-20 19:45:302015-12-20 19:45:30
shops:l%extface_jobs:l+extface_drivers# +extface_devices:l 9extface_serial_configs:l
~ ~g H E 33Extface::Driver::DaisyFx12002015-12-20 19:45:302015-12-20 19:45:30Jв7 I 33Extface::Driver::Datecs::Fp5502015-12-20 19:45:302015-12-20 19:45:30GԻ
C 33Extface::Driver::StarScp7002015-12-20 19:45:302015-12-20 19:45:30G] C 33Extface::Driver::StarTsp2002015-12-20 19:45:302015-12-20 19:45:30GN C 33Extface::Driver::GenericPos2015-12-20 19:45:302015-12-20 19:45:30
0f
- 33 2015-12-20 19:45:302015-12-20 19:45:300Ӳr
- 33 2015-12-20 19:45:302015-12-20 19:45:30
- ʊf :l
" ( ; ( ( OM++Utableextface_driversextface_driversCREATE TABLE "extface_drivers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar(255), "settings" text, "created_at" datetime, "updated_at" datetime)#L++}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) =//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)
L C L H Qutableshopsshops
-CREATE TABLE "shops" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime, "updated_at" datetime)dP99ctableextface_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)OK%)indexindex_extface_jobs_on_device_idextface_jobsCREATE INDEX "index_extface_jobs_on_device_id" ON "extface_jobs" ("device_id")/N%%!tableextface_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)
4f
- 33# 2015-12-20 19:45:302015-12-20 19:45:304Ӳr
- 33d2015-12-20 19:45:302015-12-20 19:45:30
*f 332015-12-20 19:45:302015-12-20 19:45:30*Ӳr 332015-12-20 19:45:302015-12-20 19:45:30
)20140303122506)20140219091811)20140219175006)20140215192111)20140303112124)20140216110608)20140303123022
- | | )20140303122506)20140219091811)20140219175006)20140215192111)20140303112124)20140216110608) 20140303123022
-
+SQLite format 3 @ f
+y f -
8 6
J \J ZE
+ ++33 posiflex_aura80Posiflex Aura80:lShop==E2016-08-31 00:42:292016-08-31 00:42:29T
+ %%33 daisy_fx1200Daisy Fx1200:lShopm2016-08-31 00:42:292016-08-31 00:42:29Tв7
+ %%33 datecs_fp550Datect FP550:lShop
72016-08-31 00:42:292016-08-31 00:42:29Lf
+ 33 MyUUID2MyString2:lShop# 2016-08-31 00:42:292016-08-31 00:42:29LӲr
+ 33 MyUUID1MyString1:lShopd2016-08-31 00:42:292016-08-31 00:42:29
shops:l%extface_jobs:l+extface_drivers==E+extface_devices==E 9extface_serial_configs:l
+ ~g+ ME O 33Extface::Driver::Posiflex::Aura802016-08-31 00:42:292016-08-31 00:42:29H E 33Extface::Driver::DaisyFx12002016-08-31 00:42:292016-08-31 00:42:29Jв7 I 33Extface::Driver::Datecs::Fp5502016-08-31 00:42:292016-08-31 00:42:29GԻ
C 33Extface::Driver::StarScp7002016-08-31 00:42:292016-08-31 00:42:29G] C 33Extface::Driver::StarTsp2002016-08-31 00:42:292016-08-31 00:42:29GN C 33Extface::Driver::GenericPos2016-08-31 00:42:292016-08-31 00:42:29
1f 33 2016-08-31 00:42:292016-08-31 00:42:291Ӳr 33 2016-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)
- C F8%%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
*f 332016-08-31 00:42:292016-08-31 00:42:29*Ӳr 332016-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
Y Y P 9K%)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)
\ No newline at end of file