test/dummy/db/test.sqlite3 in advert_selector-2.0.1 vs test/dummy/db/test.sqlite3 in advert_selector-3.0.0

- old
+ new

@@ -1,5 +1,5 @@ -SQLite format 3@ -  bbvp'AA33parade_banner2015-05-14 00:00:00.0000002015-05-24 00:00:00.000000tf*2015-05-14 18:22:362015-05-14 18:22:36{AA%33Pepsi2015-05-14 00:00:00.0000002015-05-24 00:00:00.000000dtPepsi bannert.RS2015-05-14 18:22:362015-05-14 18:22:36ZAA#33Coke2015-05-09 00:00:00.0000002015-05-19 00:00:00.0000002dfCoke bannert.RS2015-05-14 18:22:362015-05-14 18:22:36 !Aadvert_selector_placements<-#Eadvert_selector_helper_items9Bt7;advert_selector_banners0,Z -!A2015-05-24 00:00:00.000000 Z`p!A2015-05-24 00:00:00.000000{!A2015-05-19 00:00:00.0000000,Z xx@\ 'A33 Z`pbanner_paradet<img src='banner_parade'/>2015-05-14 18:22:362015-05-14 18:22:36`ʉ7 1?33{banner_leaderboardt<img src='pepsi_banner'/>2015-05-14 18:22:362015-05-14 18:22:36UϾe ;!33{request_params_include?fpepsi=true2015-05-14 18:22:362015-05-14 18:22:36_8 1=330,Zbanner_leaderboardt<img src='coke_banner'/>2015-05-14 18:22:362015-05-14 18:22:36 N,;;otableadvert_selector_bannersadvert_selector_bannersCREATE TABLE "advert_selector_banners" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "start_time" datetime, "end_time" datetime, "priority" integer DEFAULT 0 NOT NULL, "target_view_count" integer, "running_view_count" integer DEFAULT 0 NOT NULL, "frequency" integer, "fast_mode" boolean DEFAULT 'f' NOT NULL, "comment" text, "confirmed" boolean DEFAULT 'f' NOT NULL, "placement_id" integer NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)/_;Qindexindex_advert_selector_banners_on_end_timeadvert_selector_bannersCREATE INDEX "index_advert_selector_banners_on_end_time" ON "advert_selector_banners" ("end_time") GEEtableadvert_selector_helper_itemsadvert_selector_helper_itemsCREATE TABLE "advert_selector_helper_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "banner_id" integer, "position" integer, "name" varchar(255), "content_for" boolean, "content" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)7EMindexindex_banner_positionadvert_selector_helper_itemsCREATE INDEX "index_banner_position" ON "advert_selector_helper_items" ("banner_id", "position")@AA tableadvert_selector_placementsadvert_selector_placements CREATE TABLE "advert_selector_placements" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "only_once_per_session" boolean, "conflicting_placements_array" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) -  Z`p {9Bt7 { 0,Z7i/ 3r39柴-33Videotparade2015-05-14 18:22:362015-05-14 18:22:36>S#33Leaderboardparade2015-05-14 18:22:362015-05-14 18:22:36Dm/33Paradeleaderboard,video2015-05-14 18:22:362015-05-14 18:22:36 )20120924165938)20120925122858)20120926132649 +SQLite format 3@ .  bbvp'33AAparade_banner2018-03-22 00:00:002018-04-01 00:00:00tf*2018-03-22 14:31:12.3242932018-03-22 14:31:12.324293{33%AAPepsi2018-03-22 00:00:002018-04-01 00:00:00dtPepsi bannert.RS2018-03-22 14:31:12.3242932018-03-22 14:31:12.324293Z33#AACoke2018-03-17 00:00:002018-03-27 00:00:002dfCoke bannert.RS2018-03-22 14:31:12.3242932018-03-22 14:31:12.324293 !Aadvert_selector_placements<-#Eadvert_selector_helper_items9Bt7;advert_selector_banners0,Z +32018-04-01 00:00:00 Z`p32018-04-01 00:00:00{32018-03-27 00:00:000,Z @@$j 'AAA Z`pbanner_paradet<img src='banner_parade'/>2018-03-22 14:31:12.3223042018-03-22 14:31:12.322304nʉ7 1?AA{banner_leaderboardt<img src='pepsi_banner'/>2018-03-22 14:31:12.3223042018-03-22 14:31:12.322304cϾe ;!AA{request_params_include?fpepsi=true2018-03-22 14:31:12.3223042018-03-22 14:31:12.322304m8 1=AA0,Zbanner_leaderboardt<img src='coke_banner'/>2018-03-22 14:31:12.3223042018-03-22 14:31:12.322304 N,;;otableadvert_selector_bannersadvert_selector_bannersCREATE TABLE "advert_selector_banners" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "start_time" datetime, "end_time" datetime, "priority" integer DEFAULT 0 NOT NULL, "target_view_count" integer, "running_view_count" integer DEFAULT 0 NOT NULL, "frequency" integer, "fast_mode" boolean DEFAULT 'f' NOT NULL, "comment" text, "confirmed" boolean DEFAULT 'f' NOT NULL, "placement_id" integer NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)/_;Qindexindex_advert_selector_banners_on_end_timeadvert_selector_bannersCREATE INDEX "index_advert_selector_banners_on_end_time" ON "advert_selector_banners" ("end_time") GEEtableadvert_selector_helper_itemsadvert_selector_helper_itemsCREATE TABLE "advert_selector_helper_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "banner_id" integer, "position" integer, "name" varchar(255), "content_for" boolean, "content" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)7EMindexindex_banner_positionadvert_selector_helper_itemsCREATE INDEX "index_banner_position" ON "advert_selector_helper_items" ("banner_id", "position")@AA tableadvert_selector_placementsadvert_selector_placements CREATE TABLE "advert_selector_placements" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "only_once_per_session" boolean, "conflicting_placements_array" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) +  Z`p {9Bt7 { 0,Z7i/  V G柴-AAVideotparade2018-03-22 14:31:12.3263662018-03-22 14:31:12.326366LS#AALeaderboardparade2018-03-22 14:31:12.3263662018-03-22 14:31:12.326366Rm/AAParadeleaderboard,video2018-03-22 14:31:12.3263662018-03-22 14:31:12.326366 )20120924165938)20120925122858)20120926132649 )20120924165938)20120925122858)20120926132649 vq//tableschema_migrationsschema_migrations CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)=//indexunique_schema_migrationsschema_migrations CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version") \ No newline at end of file