spec/dummy/db/test.sqlite3 in intro-0.4.0 vs spec/dummy/db/test.sqlite3 in intro-0.4.1
- old
+ new
@@ -1,76 +1,153 @@
+SQLite format 3 @ W W .K
+ * y
4
+
+ J * T
+55Ktablear_internal_metadataar_internal_metadataCREATE TABLE "ar_internal_metadata" ("key" varchar NOT NULL PRIMARY KEY, "value" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)G[5 indexsqlite_autoindex_ar_internal_metadata_1ar_internal_metadatax//tableschema_migrationsschema_migrations CREATE TABLE "schema_migrations" ("version" varchar NOT NULL PRIMARY KEY)A U/ indexsqlite_autoindex_schema_migrations_1schema_migrations
+ #%tableusersusersCREATE TABLE "users" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)}A##indexindex_intro_tours_on_identintro_toursCREATE UNIQUE INDEX "index_intro_tours_on_ident" ON "intro_tours" ("ident")X}#indexindex_intro_tours_on_controller_and_action_and_publishedintro_toursCREATE INDEX "index_intro_tours_on_controller_and_action_and_published" ON "intro_tours" ("controller_path", "action_name", "published")}##Atableintro_toursintro_toursCREATE TABLE "intro_tours" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "ident" varchar NOT NULL, "controller_path" varchar DEFAULT '' NOT NULL, "action_name" varchar DEFAULT '' NOT NULL, "route" text, "options" text, "published" boolean DEFAULT 0, "expired_at" datetime, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)g5!indexindex_intro_tour_histories_on_user_and_tour_and_touch_countintro_tour_historiesCREATE INDEX "index_intro_tour_histories_on_user_and_tour_and_touch_count" ON "intro_tour_histories" ("user_id", "tour_id", "touch_count")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)255tableintro_tour_historiesintro_tour_historiesCREATE TABLE "intro_tour_histories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "tour_id" integer NOT NULL, "user_id" integer NOT NULL, "touch_count" integer DEFAULT 0 NOT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)
>> AAJ2020-12-31 14:12:28.7815242020-12-31 14:12:28.781524== AAI2020-12-31 14:12:28.7460752020-12-31 14:12:28.746075
users5intro_tour_histories>