test/dummy/db/test.sqlite3 in advert_selector-1.0.3 vs test/dummy/db/test.sqlite3 in advert_selector-1.0.4
- old
+ new
@@ -1,5 +1,5 @@
-SQLite format 3 @ L L -!
tp '33 33parade_banner2012-11-04 00:00:002012-11-14 00:00:00 tf* 2012-11-04 16:07:222012-11-04 16:07:22w{ 33%33Pepsi2012-11-04 00:00:002012-11-14 00:00:00d tPepsi bannert.RS2012-11-04 16:07:222012-11-04 16:07:22uZ 33#33Coke2012-10-30 00:00:002012-11-09 00:00:002d fCoke bannert.RS2012-11-04 16:07:222012-11-04 16:07:22
!Aadvert_selector_placements<-#Eadvert_selector_helper_items9Bt7 ;advert_selector_banners0,Z
- 32012-11-14 00:00:00 Z`p32012-11-14 00:00:00{32012-11-09 00:00:000,Z
x x5 UϾe ;!33{request_params_include?fpepsi=true2012-11-04 16:07:222012-11-04 16:07:22\ 'A33 Z`pbanner_paradet<img src='banner_parade'/>2012-11-04 16:07:222012-11-04 16:07:22_8 1=330,Zbanner_leaderboardt<img src='coke_banner'/>2012-11-04 16:07:222012-11-04 16:07:22`ʉ7 1?33{banner_leaderboardt<img src='pepsi_banner'/>2012-11-04 16:07:222012-11-04 16:07:22
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
0,Z7i/
{9Bt7
3 3w >S # 33Leaderboardparade2012-11-04 16:07:222012-11-04 16:07:229柴- 33Videotparade2012-11-04 16:07:222012-11-04 16:07:22Dm /33Paradeleaderboard,video2012-11-04 16:07:222012-11-04 16:07:22
)20120924165938)20120925122858)20120926132649
+SQLite format 3 @ -!
tp '33 33parade_banner2012-12-02 00:00:002012-12-12 00:00:00 tf* 2012-12-02 13:30:072012-12-02 13:30:07w{ 33%33Pepsi2012-12-02 00:00:002012-12-12 00:00:00d tPepsi bannert.RS2012-12-02 13:30:072012-12-02 13:30:07uZ 33#33Coke2012-11-27 00:00:002012-12-07 00:00:002d fCoke bannert.RS2012-12-02 13:30:072012-12-02 13:30:07
!Aadvert_selector_placements<-#Eadvert_selector_helper_items9Bt7 ;advert_selector_banners0,Z
+ 32012-12-12 00:00:00 Z`p32012-12-12 00:00:00{32012-12-07 00:00:000,Z
x x5 UϾe ;!33{request_params_include?fpepsi=true2012-12-02 13:30:072012-12-02 13:30:07\ 'A33 Z`pbanner_paradet<img src='banner_parade'/>2012-12-02 13:30:072012-12-02 13:30:07_8 1=330,Zbanner_leaderboardt<img src='coke_banner'/>2012-12-02 13:30:072012-12-02 13:30:07`ʉ7 1?33{banner_leaderboardt<img src='pepsi_banner'/>2012-12-02 13:30:072012-12-02 13:30:07
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
0,Z7i/
{9Bt7
3 3w >S # 33Leaderboardparade2012-12-02 13:30:072012-12-02 13:30:079柴- 33Videotparade2012-12-02 13:30:072012-12-02 13:30:07Dm /33Paradeleaderboard,video2012-12-02 13:30:072012-12-02 13:30:07
)20120924165938)20120925122858)20120926132649
)20120924165938)20120925122858)20120926132649
v q//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