SQLite format 3@ --- O f q . kAKud--{tablechaskiq_settingschaskiq_settingsCREATE TABLE "chaskiq_settings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "config" text, "campaign_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)U+=indexindex_chaskiq_metrics_on_campaign_idchaskiq_metricsCREATE INDEX "index_chaskiq_metrics_on_campaign_id" ON "chaskiq_metrics" ("campaign_id")S}+ indexindex_chaskiq_metrics_on_trackable_type_and_trackable_idchaskiq_metricsCREATE INDEX "index_chaskiq_metrics_on_trackable_type_and_trackable_id" ON "chaskiq_metrics" ("trackable_type", "trackable_id")H++Gtablechaskiq_metricschaskiq_metricsCREATE TABLE "chaskiq_metrics" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "trackable_id" integer NOT NULL, "trackable_type" varchar NOT NULL, "campaign_id" integer, "action" varchar, "host" varchar, "data" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)( ]3Mindexindex_chaskiq_attachments_on_campaign_idchaskiq_attachmentsCREATE INDEX "index_chaskiq_attachments_on_campaign_id" ON "chaskiq_attachments" ("campaign_id")' 33utablechaskiq_attachmentschaskiq_attachments CREATE TABLE "chaskiq_attachments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "image" varchar, "content_type" varchar, "size" integer, "name" varchar, "campaign_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) U3=indexindex_chaskiq_subscribers_on_list_idchaskiq_subscribers CREATE INDEX "index_chaskiq_subscribers_on_list_id" ON "chaskiq_subscribers" ("list_id")! 33itablechaskiq_subscriberschaskiq_subscribers CREATE TABLE "chaskiq_subscribers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "email" varchar, "state" varchar, "last_name" varchar, "list_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) ''{tablechaskiq_listschaskiq_lists CREATE TABLE "chaskiq_lists" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "state" varchar, "unsubscribe_count" integer, "bounced" integer, "active_count" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)w//tablechaskiq_campaignschaskiq_campaignsCREATE TABLE "chaskiq_campaigns" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "subject" varchar, "from_name" varchar, "from_email" varchar, "reply_email" varchar, "plain_content" text, "html_content" text, "premailer" text, "description" text, "logo" varchar, "name" varchar, "query_string" varchar, "scheduled_at" datetime, "timezone" varchar, "state" varchar, "recipients_count" integer, "sent" boolean, "opens_count" integer, "clicks_count" integer, "parent_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "list_id" integer, "template_id" integer)U/=indexindex_chaskiq_campaigns_on_parent_idchaskiq_campaignsCREATE INDEX "index_chaskiq_campaigns_on_parent_id" ON "chaskiq_campaigns" ("parent_id")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq) / //Atablechaskiq_templateschaskiq_templates CREATE TABLE "chaskiq_templates" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "body" text, "html_content" text, "screenshot" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) Y/Eindexindex_chaskiq_campaigns_on_template_idchaskiq_campaignsCREATE INDEX "index_chaskiq_campaigns_on_template_id" ON "chaskiq_campaigns" ("template_id")Q/5indexindex_chaskiq_campaigns_on_list_idchaskiq_campaignsCREATE INDEX "index_chaskiq_campaigns_on_list_id" ON "chaskiq_campaigns" ("list_id")=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")l//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL) )20150321205815)20150320031404)20150318023136)20150318022506)20150318021424)20150318021239)20150318021006 ||)20150321205815)20150320031404)20150318023136)20150318022506)20150318021424)20150318021239) 20150318021006 ((/-??S? 1AA test from chaskiqmiguel michelsonmiguelmichelson@gmail.commiguelmichelson@gmail.com
Drop Content Blocks Here
This is a Text Block. Use this to provide text...hello
Drop Content Blocks Here
Drop Content Blocks Here
Drop Content Blocks Here
Drop Content Blocks Here
Drop Content Blocks Here
Drop Content Blocks Here
© {{campaign_description}}

Our mailing address is:
{{campaign_url}}

unsubscribe from this list    update subscription preferences 
2015-03-24 02:19:36.7269512015-03-24 02:19:36.726951 D AADefault2015-03-24 02:18:35.7578742015-03-24 02:18:35.757874  k!L kq [ AAsupsuppressionlist@simulator.amazonses.compassiveses2015-03-24 02:18:35.7876902015-03-24 02:18:35.787690l O AAspamcomplaint@simulator.amazonses.compassiveses2015-03-24 02:18:35.7861602015-03-24 02:18:35.786160f E AAotoooto@simulator.amazonses.compassiveses2015-03-24 02:18:35.7847802015-03-24 02:18:35.784780k I AAbouncebounce@simulator.amazonses.compassiveses2015-03-24 02:18:35.7831692015-03-24 02:18:35.783169m K AAsuccesssuccess@simulator.amazonses.compassiveses2015-03-24 02:18:35.7809942015-03-24 02:18:35.780994n ? AAmichelsonmiguelmichelson@gmail.compassivemartinez2015-03-24 02:18:35.7774432015-03-24 02:18:35.777443         |K: * t  d S C2|Y 3 AAChaskiq::Subscriberdeliver2015-03-24 02:34:12.6463942015-03-24 02:34:12.646394Y 3 AAChaskiq::Subscriberdeliver2015-03-24 02:34:08.6650622015-03-24 02:34:08.665062Y 3 AAChaskiq::Subscriberdeliver2015-03-24 02:34:04.7599502015-03-24 02:34:04.759950Y 3 AAChaskiq::Subscriberdeliver2015-03-24 02:34:00.9803672015-03-24 02:34:00.980367Y 3 AAChaskiq::Subscriberdeliver2015-03-24 02:33:56.6992502015-03-24 02:33:56.699250X 3 AAChaskiq::Subscriberdeliver2015-03-24 02:33:51.5284552015-03-24 02:33:51.528455Y 3 AAChaskiq::Subscriberdeliver2015-03-24 02:27:54.9716452015-03-24 02:27:54.971645Y 3 AAChaskiq::Subscriberdeliver2015-03-24 02:27:54.9320542015-03-24 02:27:54.932054Y 3 AAChaskiq::Subscriberdeliver2015-03-24 02:27:54.8885682015-03-24 02:27:54.888568Y 3 AAChaskiq::Subscriberdeliver2015-03-24 02:27:54.8458662015-03-24 02:27:54.845866Y 3 AAChaskiq::Subscriberdeliver2015-03-24 02:27:54.8060902015-03-24 02:27:54.806090X 3 AAChaskiq::Subscriberdeliver2015-03-24 02:27:54.4795612015-03-24 02:27:54.479561Y 3 AAChaskiq::Subscriberdeliver2015-03-24 02:25:06.8109292015-03-24 02:25:06.810929Y 3 AAChaskiq::Subscriberdeliver2015-03-24 02:25:06.7813702015-03-24 02:25:06.781370Y 3 AAChaskiq::Subscriberdeliver2015-03-24 02:25:06.7518112015-03-24 02:25:06.751811Y 3 AAChaskiq::Subscriberdeliver2015-03-24 02:25:06.7230302015-03-24 02:25:06.723030Y 3 AAChaskiq::Subscriberdeliver2015-03-24 02:25:06.6885692015-03-24 02:25:06.688569X 3 AAChaskiq::Subscriberdeliver2015-03-24 02:25:06.4529912015-03-24 02:25:06.452991Y 3 AAChaskiq::Subscriberdeliver2015-03-24 02:23:38.9972072015-03-24 02:23:38.997207Y 3 AAChaskiq::Subscriberdeliver2015-03-24 02:23:38.9684962015-03-24 02:23:38.968496Y 3 AAChaskiq::Subscriberdeliver2015-03-24 02:23:38.9376022015-03-24 02:23:38.937602Y 3 AAChaskiq::Subscriberdeliver2015-03-24 02:23:38.9093152015-03-24 02:23:38.909315Y 3 AAChaskiq::Subscriberdeliver2015-03-24 02:23:38.8793222015-03-24 02:23:38.879322X 3 AAChaskiq::Subscriberdeliver2015-03-24 02:23:38.4854552015-03-24 02:23:38.485455  M3 ~ d J f0 3Chaskiq::Subscriber3Chaskiq::Subscriber3Chaskiq::Subscriber3Chaskiq::Subscriber3Chaskiq::Subscriber3 Chaskiq::Subscriber3Chaskiq::Subscriber3Chaskiq::Subscriber3Chaskiq::Subscriber3Chaskiq::Subscriber3Chaskiq::Subscriber3 Chaskiq::Subscriber 3Chaskiq::Subscriber 3Chaskiq::Subscriber 3Chaskiq::Subscriber 3Chaskiq::Subscriber 3Chaskiq::Subscriber3 Chaskiq::Subscriber3Chaskiq::Subscriber3Chaskiq::Subscriber3Chaskiq::Subscriber3Chaskiq::Subscriber3Chaskiq::Subscriber3 Chaskiq::Subscriber                                ^^V"V& J  zal//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")w//tablechaskiq_campaignschaskiq_campaignsCREATE TABLE "chaskiq_campaigns" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "subject" varchar, "from_name" varchar, "from_email" varchar, "reply_email" varchar, "plain_content" text, "html_content" text, "premailer" text, "description" text, "logo" varchar, "name" varchar, "query_string" varchar, "scheduled_at" datetime, "timezone" varchar, "state" varchar, "recipients_count" integer, "sent" boolean, "opens_count" integer, "clicks_count" integer, "parent_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "list_id" integer, "template_id" integer)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)U/=indexindex_chaskiq_campaigns_on_parent_idchaskiq_campaignsCREATE INDEX "index_chaskiq_campaigns_on_parent_id" ON "chaskiq_campaigns" ("parent_id")Q/5indexindex_chaskiq_campaigns_on_list_idchaskiq_campaignsCREATE INDEX "index_chaskiq_campaigns_on_list_id" ON "chaskiq_campaigns" ("list_id") Y/Eindexindex_chaskiq_campaigns_on_template_idchaskiq_campaignsCREATE INDEX "index_chaskiq_campaigns_on_template_id" ON "chaskiq_campaigns" ("template_id") //Atablechaskiq_templateschaskiq_templates CREATE TABLE "chaskiq_templates" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "body" text, "html_content" text, "screenshot" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) ''{tablechaskiq_listschaskiq_lists CREATE TABLE "chaskiq_lists" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "state" varchar, "unsubscribe_count" integer, "bounced" integer, "active_count" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)! 33itablechaskiq_subscriberschaskiq_subscribers CREATE TABLE "chaskiq_subscribers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "email" varchar, "state" varchar, "last_name" varchar, "list_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) U3=indexindex_chaskiq_subscribers_on_list_idchaskiq_subscribers CREATE INDEX "index_chaskiq_subscribers_on_list_id" ON "chaskiq_subscribers" ("list_id")' 33utablechaskiq_attachmentschaskiq_attachments CREATE TABLE "chaskiq_attachments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "image" varchar, "content_type" varchar, "size" integer, "name" varchar, "campaign_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)( ]3Mindexindex_chaskiq_attachments_on_campaign_idchaskiq_attachmentsCREATE INDEX "index_chaskiq_attachments_on_campaign_id" ON "chaskiq_attachments" ("campaign_id")H++Gtablechaskiq_metricschaskiq_metricsCREATE TABLE "chaskiq_metrics" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "trackable_id" integer NOT NULL, "trackable_type" varchar NOT NULL, "campaign_id" integer, "action" varchar, "host" varchar, "data" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)S}+ indexindex_chaskiq_metrics_on_trackable_type_and_trackable_idchaskiq_metricsCREATE INDEX "index_chaskiq_metrics_on_trackable_type_and_trackable_id" ON "chaskiq_metrics" ("trackable_type", "trackable_id")U+=indexindex_chaskiq_metrics_on_campaign_idchaskiq_metricsCREATE INDEX "index_chaskiq_metrics_on_campaign_id" ON "chaskiq_metrics" ("campaign_id")d--{tablechaskiq_settingschaskiq_settingsCREATE TABLE "chaskiq_settings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "config" text, "campaign_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)W-Aindexindex_chaskiq_settings_on_campaign_idchaskiq_settingsCREATE INDEX "index_chaskiq_settings_on_campaign_id" ON "chaskiq_settings" ("campaign_id")d>
Drop Content Blocks Here
© {{campaign_description}}

Our mailing address is:
{{campaign_url}}

unsubscribe from this list    update subscription preferences 
Chaskiq
This is a Text Block. Use this to provide text...hello
Drop Content Blocks Here
© {{campaign_description}}

Our mailing address is:
{{campaign_url}}

unsubscribe from this list    update subscription preferences 
Chaskiq
This is a Text Block. Use this to provide text...hello
Drop Content Blocks Here
Drop Content Blocks Here
Drop Content Blocks Here
© {{campaign_description}}

Our mailing address is:
{{campaign_url}}

unsubscribe from this list    update subscription preferences 
this is the ckaskiq test newsletterlogo_artenlinea-icono.pngtest(GMT-10:00) Hawaii2015-03-24 02:19:45.2274292015-03-24 02:20:51.513174class="fa fa-edit">
Drop Content Blocks Here
Drop Content Blocks Here
Drop Content Blocks Here
© {{campaign_description}}

Our mailing address is:
{{campaign_url}}

unsubscribe from this list    update subscription preferences 
this is the ckaskiq test newsletterlogo_artenlinea-icono.pngtest(GMT-10:00) Hawaii2015-03-24 02:19:45.2274292015-03-24 02:20:51.513174