SQLite format 3@ -  #>ng=//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) SGindexindex_users_on_reset_password_tokenusersCREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")e 5 indexindex_users_on_emailusers CREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")! !tableusersusers CREATE 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)? 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_clicks CREATE 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)MoGqindexindex_rails_adserver_advertisements_on_state_namerails_adserver_advertisements CREATE INDEX "index_rails_adserver_advertisements_on_state_name" ON "rails_adserver_advertisements" ("state_name")b}G indexindex_rails_adserver_advertisements_on_param_restrictionrails_adserver_advertisementsCREATE INDEX "index_rails_adserver_advertisements_on_param_restriction" ON "rails_adserver_advertisements" ("param_restriction")SsGyindexindex_rails_adserver_advertisements_on_country_namerails_adserver_advertisementsCREATE INDEX "index_rails_adserver_advertisements_on_country_name" ON "rails_adserver_advertisements" ("country_name")JmGmindexindex_rails_adserver_advertisements_on_city_namerails_adserver_advertisementsCREATE INDEX "index_rails_adserver_advertisements_on_city_name" ON "rails_adserver_advertisements" ("city_name")MoGqindexindex_rails_adserver_advertisements_on_adspace_idrails_adserver_advertisementsCREATE INDEX "index_rails_adserver_advertisements_on_adspace_id" ON "rails_adserver_advertisements" ("adspace_id")*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)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)h;;gtablerails_adserver_adspacesrails_adserver_adspacesCREATE TABLE "rails_adserver_adspaces" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "name" varchar(255)) @9AA2012-03-31 00:08:02.1563552012-03-31 00:08:02.156355foo bar users users!Grails_adserver_advertisements;rails_adserver_adspaces9 8AA ! Foo Barf2012-03-30 23:49:33.6123192012-03-30 23:49:33.612319inAA !  Foo Bart2012-03-31 00:08:15.6256732012-03-31 00:08:29.664085id9ad_servicefTextff  /9           nn%AAAAfoo5@bar.com$2a$04$E4GXjweUX.lxC/5MbBYjoOkPBv0GvpiuFKXoVqd9SF3RD33xNLjMS2012-03-31 00:08:29.7653052012-03-31 00:08:29.7653051TI%AAAAfoo8@bar.com$2a$04$tcV7NsSuZ5mLxqlnPoa3j.S9Ju2/aWuocrXIvQM54WWqCy23Iq7Xi2012-03-31 00:08:29.8043122012-03-31 00:08:29.804312127.0.0.1127.0.0.12012-03-31 00:08:29.7995042012-03-31 00:08:29.804807fH%AAfoo7@bar.com$2a$04$39Tv6pLKkOGXcL.gN/oB8.pBn5DEWfm/oM5pJbP74FfVpyIIu0MIK2012-03-31 00:08:29.7910372012-03-31 00:08:29.791037t %foo8@bar.com%foo7@bar.com  bp^L:(tb)20120330222255)20120330222254)20120330222253)20120330222252)20120330222251)20120330222250)20120330222249)20120330222248)20120330222247)20120330222246 )20120330222245 )20120330222244 )20120330222243 )20120330222242 )20120330222241)20120330222240)20120330222239)20120330222238)20120330222237)20120330222236)20120307204255)20120227204751)20120330222256 K{hUB/ q^K)20120330222255)20120330222254)20120330222253)20120330222252)20120330222251)20120330222250)20120330222249)20120330222248)20120330222247)20120330222246)20120330222245 )20120330222244 )20120330222243 )20120330222242 )20120330222241 )20120330222240)20120330222239)20120330222238)20120330222237)20120330222236)20120307204255)20120227204751)20120330222256