test/dummy/db/development.sqlite3 in rails_adserver-1.0.0 vs test/dummy/db/development.sqlite3 in rails_adserver-1.0.1
- old
+ new
@@ -1,10 +1,10 @@
-SQLite format 3 @ D 2 D -
&
+SQLite format 3 @ F 2 F -
&
([ *GGStablerails_adserver_advertisementsrails_adserver_advertisementsCREATE TABLE "rails_adserver_advertisements" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "content" text, "width" integer, "height" integer, "is_active" boolean, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "param_restriction" varchar(255), "param_restriction_name" varchar(255), "adspace_id" integer, "ad_type" varchar(255), "parameter_restriction_boolean" boolean, "ad_text" text, "url" varchar(255), "geolocation_boolean" boolean, "image" varchar(255), "max_clicks" integer, "click_count" integer, "geolocation_location" varchar(255), "city_name" varchar(255), "state_name" varchar(255), "country_name" varchar(255), "backup" boolean, "max_impressions" integer, "impressions_count" integer)SsGyindexindex_rails_adserver_advertisements_on_country_namerails_adserver_advertisementsCREATE INDEX "index_rails_adserver_advertisements_on_country_name" ON "rails_adserver_advertisements" ("country_name")MoGqindexindex_rails_adserver_advertisements_on_state_namerails_adserver_advertisementsCREATE INDEX "index_rails_adserver_advertisements_on_state_name" ON "rails_adserver_advertisements" ("state_name")JmGmindexindex_rails_adserver_advertisements_on_city_namerails_adserver_advertisementsCREATE INDEX "index_rails_adserver_advertisements_on_city_name" ON "rails_adserver_advertisements" ("city_name")b}G
indexindex_rails_adserver_advertisements_on_param_restrictionrails_adserver_advertisements CREATE INDEX "index_rails_adserver_advertisements_on_param_restriction" ON "rails_adserver_advertisements" ("param_restriction")MoGqindexindex_rails_adserver_advertisements_on_adspace_idrails_adserver_advertisements CREATE INDEX "index_rails_adserver_advertisements_on_adspace_id" ON "rails_adserver_advertisements" ("adspace_id")?k7iindexindex_rails_adserver_clicks_on_advertisement_idrails_adserver_clicks
CREATE INDEX "index_rails_adserver_clicks_on_advertisement_id" ON "rails_adserver_clicks" ("advertisement_id") 77'tablerails_adserver_clicksrails_adserver_clicksCREATE TABLE "rails_adserver_clicks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "ip_address" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "advertisement_id" integer)h ;;gtablerails_adserver_adspacesrails_adserver_adspaces
CREATE TABLE "rails_adserver_adspaces" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "name" varchar(255))SGindexindex_users_on_reset_password_tokenusers CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")e5 indexindex_users_on_emailusersCREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")!!tableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar(255) DEFAULT '' NOT NULL, "encrypted_password" varchar(255) DEFAULT '' NOT NULL, "reset_password_token" varchar(255), "reset_password_sent_at" datetime, "remember_created_at" datetime, "sign_in_count" integer DEFAULT 0, "current_sign_in_at" datetime, "last_sign_in_at" datetime, "current_sign_in_ip" varchar(255), "last_sign_in_ip" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "can_manage_ads" boolean)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)
b p^L:(tb )20120328043651)20120328043354)20120323174313)20120307204255)20120306065447)20120306052705)20120306023105)20120305214753)20120305212451)20120305203049
)20120305195421 )20120305054319 )20120305044238
)20120305040026 )20120305034458)20120228043946)20120228010315)20120228010151)20120228000647)20120228000410)20120227204751)20120227014945)20120227014859
K {hUB/ q^K )20120328043651)20120328043354)20120323174313)20120307204255)20120306065447)20120306052705)20120306023105)20120305214753)20120305212451)20120305203049)20120305195421
)20120305054319 )20120305044238 )20120305040026
-)20120305034458 )20120228043946)20120228010315)20120228010151)20120228000647)20120228000410)20120227204751)20120227014945)20120227014859
m m AA
!
A
Test Ad,,t2012-03-28 05:07:07.8312392012-03-28 19:54:58.562004idimage_linkfhttp://www.campusbazar.comfuszgP.jpg f
!Grails_adserver_advertisements;rails_adserver_adspaces users
% % X - AA AAtmuntan1@slu.edu$2a$10$NgsOLC9u/ZvgCDbQAMLNhu3Qd4Ugksbo.B.W7R0qGI7aPVnpxEUMu2012-03-28 04:52:24.3229342012-03-28 04:52:24.322934127.0.0.1127.0.0.12012-03-28 04:52:24.3159382012-03-28 04:54:55.598111t
+)20120305034458 )20120228043946)20120228010315)20120228010151)20120228000647)20120228000410)20120227204751)20120227014945)20120227014859
m m AA
!
A
Test Ad,,t2012-03-28 05:07:07.8312392012-03-28 20:27:28.598237idimage_linkfhttp://www.campusbazar.comfuszgP.jpg f
!Grails_adserver_advertisements;rails_adserver_adspaces users
% % X - AA AAtmuntan1@slu.edu$2a$10$NgsOLC9u/ZvgCDbQAMLNhu3Qd4Ugksbo.B.W7R0qGI7aPVnpxEUMu2012-03-28 04:52:24.3229342012-03-28 04:52:24.322934127.0.0.1127.0.0.12012-03-28 04:52:24.3159382012-03-28 04:54:55.598111t
-tmuntan1@slu.edu
E AA%2012-03-28 04:55:17.7122862012-03-28 04:55:17.712286Test Adspace
\ No newline at end of file