SQLite format 3 @ 5 7 5 -!
0,[9Bt: {
Z`p
0,Z7i/
{9Bt7
!Aadvert_selector_placements<-#Eadvert_selector_helper_items9Bt< ;advert_selector_banners0,[
3 3w >S # 33Leaderboardparade2012-09-28 11:54:202012-09-28 11:54:209柴- 33Videotparade2012-09-28 11:54:202012-09-28 11:54:20Dm /33Paradeleaderboard,video2012-09-28 11:54:202012-09-28 11:54:20
[ 5AA
AAparade_banner (copy)2012-09-28 00:00:00.0000002012-10-08 00:00:00.000000 tt* 2012-09-30 12:10:23.5851012012-09-30 12:11:05.016315{p '33
3Aparade_banner2012-09-28 00:00:002012-10-08 00:00:00 tf* 2012-09-28 11:54:202012-09-30 12:04:35.495375w{ 33%33Pepsi2012-09-28 00:00:002012-10-08 00:00:00d tPepsi bannert.RS2012-09-28 11:54:202012-09-28 11:54:20uZ 33#33Coke2012-09-23 00:00:002012-10-03 00:00:002d fCoke bannert.RS2012-09-28 11:54:202012-09-28 11:54:20
n n3 P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)=//indexunique_schema_migrationsschema_migrations CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")@AA tableadvert_selector_placementsadvert_selector_placementsCREATE 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)
,;;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)
)20120928114161)20120928114160)20120928114159
)20120928114161)20120928114160)20120928114159
!A2012-10-08 00:00:00.0000000,[32012-10-08 00:00:00 Z`p32012-10-08 00:00:00{32012-10-03 00:00:000,Z
x5 I kʉ: 'CAA0,[banner_paradet
2012-09-30 12:10:23.5892162012-09-30 12:10:23.589216UϾe ;!33{request_params_include?fpepsi=true2012-09-28 11:54:202012-09-28 11:54:20\ 'A33 Z`pbanner_paradet
2012-09-28 11:54:202012-09-28 11:54:20_8 1=330,Zbanner_leaderboardt
2012-09-28 11:54:202012-09-28 11:54:20`ʉ7 1?33{banner_leaderboardt
2012-09-28 11:54:202012-09-28 11:54:20
c c 7EMindexindex_banner_positionadvert_selector_helper_itemsCREATE INDEX "index_banner_position" ON "advert_selector_helper_items" ("banner_id", "position")/ _;Qindexindex_advert_selector_banners_on_end_timeadvert_selector_banners
CREATE INDEX "index_advert_selector_banners_on_end_time" ON "advert_selector_banners" ("end_time")G
EEtableadvert_selector_helper_itemsadvert_selector_helper_items CREATE 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)