db/development.sqlite3 in daily-0.0.9 vs db/development.sqlite3 in daily-0.0.10
- old
+ new
@@ -1,13 +1,13 @@
-SQLite format 3 @ Y´ / Y´ -â
@ ±%²a
+SQLite format 3 @ Z / Z -â
@ ±%²a
¦
) ƒ
%%…atabledaily_tablesdaily_tablesCREATE TABLE "daily_tables" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "metric_data" text, "metric" varchar(255), "created_at" datetime, "updated_at" datetime, "name" varchar(255), "guid" varchar(255), "fetch_time_in_seconds" integer, "column_names" text, "transform" varchar(255), "transform_data" text, "archived" boolean DEFAULT 'f')q5#indexindex_users_on_emaildaily_usersCREATE UNIQUE INDEX "index_users_on_email" ON "daily_users" ("email")„##‡wtabledaily_usersdaily_usersCREATE TABLE "daily_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar(255) DEFAULT '' NOT NULL, "encrypted_password" varchar(128) 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, "updated_at" datetime, "admin" boolean),`…tabletablestablesCREATE TABLE "tables" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "metric_data" text, "metric" varchar(255), "created_at" datetime, "updated_at" datetime, "name" varchar(255), "guid" varchar(255), "fetch_time_in_seconds" integer, "column_names" text, "transform" varchar(255), "transform_data" text)K%)indexindex_delayed_jobs_on_report_iddelayed_jobsCREATE INDEX "index_delayed_jobs_on_report_id" ON "delayed_jobs" ("report_id"){7%'indexdelayed_jobs_prioritydelayed_jobsCREATE INDEX "delayed_jobs_priority" ON "delayed_jobs" ("priority", "run_at")ƒ
%%…Itabledelayed_jobsdelayed_jobs
CREATE TABLE "delayed_jobs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "priority" integer DEFAULT 0, "attempts" integer DEFAULT 0, "handler" text, "last_error" text, "run_at" datetime, "locked_at" datetime, "failed_at" datetime, "locked_by" varchar(255), "created_at" datetime, "updated_at" datetime, "report_id" integer, "queue" varchar(255)) 5…ctablereportsreports CREATE TABLE "reports" ƒ, ''†tabledaily_reportsdaily_reports CREATE TABLE "daily_reports" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "filename" varchar(255), "table_id" integer, "user_id" integer, "formatter" varchar(255), "created_at" datetime, "updated_at" datetime, "generate_started_at" datetime, "generate_ended_at" datetime, "transform" varchar(255), "transform_data" text, "formatter_data" text, "archived" boolean)S#Sindexindex_users_on_reset_password_tokendaily_usersCREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "daily_users" ("reset_password_token")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)
Î îÜʸ¦”‚p^L:(òàÎ )20120117020222)20120111081745)20120111054115)20120110075743
)20111214020029)20111203020425)20111127065357
)20111115014959 )20111114053016)20111114041729)20111113075747)20111113073326)20111113000026)20111112170802)20111112022333)20111111165640)20111109081414
½ íÚÇ´¡Ž{hUB/ öãн )20120117020222)20120111081745)20120111054115)20120110075743)20111214020029
)20111203020425)20111127065357)20111115014959
-)20111114053016 )20111114041729)20111113075747)20111113073326)20111113000026)20111112170802)20111112022333)20111111165640)20111109081414
w ë ëk
âÔ t 1 AAAAAbrian@bleonard.com$2a$10$97jdViSrTT7TL84BEAAb2.mJQZxGxloCLjPn/uQbWIm/t7UmHbeIK2011-12-12 18:27:51.0795022012-01-18 06:10:38.8522862012-01-18 02:00:29.732025127.0.0.1127.0.0.12011-11-09 08:18:42.8355892012-01-18 06:10:38.852996 1 AAjohww@bleoanrd.com$2a$10$WpZVsX/qlOEO8zSjVQk65Os.DUveNp5SzFB1weAeD2TG6W49KkyzG 2011-11-14 08:39:03.4331362011-11-14 08:39:03.433136 ] / AAjohn@bleoanrd.com$2a$10$9xz0TKTFWbwzQG1A/f/eKO0LIjBS.Iw55raHHyEPtS5PXJKavij 3 AA brian2@bleonard.com$2a$10$vaYI4LrgCR1YNr/GEflQuu47Dj9hYP6YEZo7L/eItVo9gRkfnSy82 2011-11-16 04:01:43.8363012011-11-16 04:01:43.836301 / AA john@bleonard.com$2a$10$9xz0TKTFWbwzQG1A/f/eKO0LIjBS.Iw55raHHyEPtS5PXJKavijYW 2011-11-14 08:34:01.8837152011-11-16 02:33:04.632962
É ¥ ¸¥íÛ 'daily_reports#daily_users daily_tables%daily_tables%delayed_jobs5
+)20111114053016 )20111114041729)20111113075747)20111113073326)20111113000026)20111112170802)20111112022333)20111111165640)20111109081414
w ë ëk
âÔ t 1 AAAAAbrian@bleonard.com$2a$10$97jdViSrTT7TL84BEAAb2.mJQZxGxloCLjPn/uQbWIm/t7UmHbeIK2011-12-12 18:27:51.0795022012-01-18 06:10:38.8522862012-01-18 02:00:29.732025127.0.0.1127.0.0.12011-11-09 08:18:42.8355892012-01-18 06:10:38.852996 1 AAjohww@bleoanrd.com$2a$10$WpZVsX/qlOEO8zSjVQk65Os.DUveNp5SzFB1weAeD2TG6W49KkyzG 2011-11-14 08:39:03.4331362011-11-14 08:39:03.433136 ] / AAjohn@bleoanrd.com$2a$10$9xz0TKTFWbwzQG1A/f/eKO0LIjBS.Iw55raHHyEPtS5PXJKavij 3 AA brian2@bleonard.com$2a$10$vaYI4LrgCR1YNr/GEflQuu47Dj9hYP6YEZo7L/eItVo9gRkfnSy82 2011-11-16 04:01:43.8363012011-11-16 04:01:43.836301 / AA john@bleonard.com$2a$10$9xz0TKTFWbwzQG1A/f/eKO0LIjBS.Iw55raHHyEPtS5PXJKavijYW 2011-11-14 08:34:01.8837152011-11-16 02:33:04.632962
É ¥ ¸¥íÛ 'daily_reports#daily_users daily_tables%daily_tables%delayed_jobsC
¤ ¤éÓ¼ 3brian2@bleonard.com1johww@bleoanrd.com/john@bleonard.com1brian@bleonard.com
ì ûöñì û û¿3
¸
5®‘» Ê AA%M
SELECT * FROM tasks WHERE created_at > '2011-10-01' AND state = 'closed'sql2011-12-12 18:37:04.3859182011-12-12 18:37:04.385918Tasks Closed6d241404eca2aff8ba774fdb9f3a8184--- []
@@ -266,61 +266,56 @@
2012-01-18 05:48:49.2469312012-01-18 04:48:49.2482042012-01-18 04:48:49.248204 ž
A AA
--- !ruby/struct:GenerateReportJob
report_id: 22
requeue: true
2012-01-18 05:48:49.2027402012-01-18 04:48:49.2047552012-01-18 04:4 ž ž
-
¼Î
z
X¬$
6Šh
œ
àÞð
¾FFÞ
6
6xx
X ¬ "
+ð
6 4šÎ
z
X¬$
6Šhx
œ
àV
¾FVÞ
6
6xx
X ¬ "
2012-01-18 05:47:32.480567F "
-2012-01-18 05:49:38.098960!A
+2012-01-18 05:49:38.098960 "
2012-01-18 08:52:23.993910+!A
-2012-01-18 08:51:08.919513'!A
-2012-01-18 08:51:08.743310$!A
-2012-01-18 08:51:08.689694#!A
-2012-01-18 08:52:24.048231,!A
-2012-01-18 09:10:13.291451 !A
-2012-01-18 08:52:24.102524-!A
-2012-01-18 08:51:08.976409(!A
-2012-01-18 08:51:08.855490&!A
-2012-01-18 09:12:13.393917!A
-2012-01-18 08:52:23.944491*!A
-2012-01-18 08:51:51.391264)!A
-2012-01-18 08:51:08.794893%!A
-2012-01-18 08:51:07.837193"!A
-2012-01-18 08:53:28.6289580 ª 2012-01-18 07:57:15.922667 ª 2012-01-18 07:52:45.757078.x "
-2012-01-18 07:49:19.646601 f
-2012-01-18 05:47:33.549332 " 2012-01-18 08:32:50.2387965!A 2012-01-18 09:09:38.244116 !A
+2012-01-18 09:51:12.020608<!A
+2012-01-18 09:51:11.8442749!A
+2012-01-18 09:51:11.7910638!A
+2012-01-18 09:53:05.688384A!A
+2012-01-18 10:18:38.495070 !A
+2012-01-18 09:53:36.273290B!A
+2012-01-18 09:52:33.576030=!A
+2012-01-18 09:51:11.965525;!A
+2012-01-18 10:20:38.750338!A
+2012-01-18 09:53:05.590120?!A
+2012-01-18 09:53:05.543903>!A
+2012-01-18 09:51:11.904058:!A
+2012-01-18 09:51:11.7380787¼ D
+2012-01-18 08:53:28.6289580Þ D 2012-01-18 07:57:15.922667 !A 2012-01-18 10:18:03.440472 !A
+2012-01-18 09:53:36.341146C!A
+2012-01-18 09:53:05.641849@!A
+2012-01-18 09:51:10.8173696 D 2012-01-18 09:09:38.244116 "
2012-01-18 08:52:54.897642/
-’ S}oh®aùòë§Z„ ™v‹SÈÈÈ„„„„„ » +'&%$#, » 50-)(á Ï
ÇÏ ! # # /*"
:
û
‚ãdáA
-š 7Û
_ ì‘“O—::::::: ( UAAAA Whatever22abf5424212a50be08d00693bb901509.csv
csv2011-11-14 05:49:48.3323082012-01-11 09:48:35.2320772012-01-11 09:48:35.2059572012-01-11 09:48:35.232077Ÿ ] #UAAAA
upgrade csv9885c88aacc250b651b6034e71510383.csvcsv2012-01-10 08:08:02.73235 #UAAAA
upgrade csv9885c88aacc250b651b6034e71510383.csvcsv2012-01-10 08:08:02.7323442012-01-18 07:52:23.9917222012-01-18 07:52:23.9636922012-01-18 07:52:23.991722---
+™ SÁvoah’§ ®äZ„Ý}‹SÈÈÈ„„„„„ » @<;:98A 6» 0B>=á Ï Ç7 ë #C? / * "
:
û
‚ãdáA
+š 7è
_:‘ AO—::::::: ( UAAAA Whatever22abf5424212a50be08d00693bb901509.csv
csv2011-11-14 05:49:48.3323082012-01-11 09:48:35.2320772012-01-11 09:48:35.2059572012-01-11 09:48:35.232077Ÿ ] #UAAAA
upgrade csv9885c88aacc250b651b6034e71510383.csvcsv2012-01-10 08:08:02.73235 #UAAAA
upgrade csv9885c88aacc250b651b6034e71510383.csvcsv2012-01-10 08:08:02.7323442012-01-18 08:53:05.5878562012-01-18 08:53:05.5608522012-01-18 08:53:05.587856---
---
-e UAAAA'u fine01584f26be3346d674852daa77bc246b.csvcsv2011-12-12 18:40:20.5251902012-01-18 07:51:51.3882282012-01-18 07:51:08.9942112012-01-18 07:51:51.388228MovingAverage---
+e UAAAA'u fine01584f26be3346d674852daa77bc246b.csvcsv2011-12-12 18:40:20.5251902012-01-18 08:52:33.5730312012-01-18 08:51:52.0640512012-01-18 08:52:33.573031MovingAverage---
days: 7
date: created_at
columns: charge_price
-) UAAAA Cites CSVa54de30523a25a26ada59cc244eb33a5.csvcsv2011-11-14 21:12:33.9611302012-01-18 07:51:08.7919592012-01-18 07:51:08.7594492012-01-18 07:51:08.791959+ #UAAAA dsfdsfdsass0f620fd24beb9c920789642f3c70a764.pdf
pdf2011-11-14 04:43:55.8499672012-01-18 07:51:08.6868622012-01-18 07:51:07.8573032012-01-18 07:51:08.686862K UAAAA%9 Test More46968c3e4a835f827367e9b6e0455d87.csvcsv2011-12-03 04:42:01.2949182012-01-18 07:51:07.8339472012-01-18 07:51:07.6143832012-01-18 07:51:07.833947ColumnFilter---
+) UAAAA Cites CSVa54de30523a25a26ada59cc244eb33a5.csvcsv2011-11-14 21:12:33.9611302012-01-18 08:51:11.8414722012-01-18 08:51:11.8099312012-01-18 08:51:11.841472+ #UAAAA dsfdsfdsass0f620fd24beb9c920789642f3c70a764.pdf
pdf2011-11-14 04:43:55.8499672012-01-18 08:51:11.7352912012-01-18 08:51:10.8338052012-01-18 08:51:11.735291K UAAAA%9 Test More46968c3e4a835f827367e9b6e0455d87.csvcsv2011-12-03 04:42:01.2949182012-01-18 08:51:10.8148992012-01-18 08:51:10.6683852012-01-18 08:51:10.814899ColumnFilter---
columns:
- name
-+ WAAAA HTML testa090a698694058bb426ee6c967f270e7.jsonjson2011-11-27 05:53:42.5249912012-01-18 07:51:08.9737272012-01-18 07:51:08.9357282012-01-18 07:51:08.973727 !UAAA Borken oneec33bd5ebe4c167b7729f1e1a54934b6.csvcsv2011-11-16 20:17:27.0930462011-12-19 20:15:35.4080352011-12-19 20:15:35.408035† <