SQLite format 3@ M*oX   g{}L)tn~Q{F|ZzUu?x:wdp5 /suviy_ 22<7 52 4xn`J<1& tfPD:0  tfRA+@!ship_parts ?birds >1mixed_case_monkeys<'legacy_things0'organizations?'|/sponsors/n@.#memberships -clubs)~,members y+%member_types*toys)+price_estimates F (ships&` 'treasures&pirates+e %movies $binaries #tasks"'subscriptions!!references jobspets owners-author_addresses entrants#funny_jokes mixins-warehouse-things'minimalistics Atopics readers =people computers companies accounts citations edges books items vertices -author_favorites taggings tags comments !categoriesg+categorizations6!developers projects authors posts customersparrots  #Bob David Mary   pNNNNNP++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)I))tablefk_test_has_pkfk_test_has_pkYCREATE TABLE 'fk_test_has_pk' ( 'id' INTEGER NOT NULL PRIMARY KEY )))]tablefk_test_has_fkfk_test_has_fkZCREATE TABLE 'fk_test_has_fk' ( 'id' INTEGER NOT NULL PRIMARY KEY, 'fk_id' INTEGER NOT NULL, FOREIGN KEY ('fk_id') REFERENCES 'fk_test_has_pk'('id') )t//tableschema_migrationsschema_migrations]CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)=//indexunique_schema_migrationsschema_migrations^CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")(utableaccountsaccountsCREATE TABLE "accounts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "firm_id" integer, "credit_limit" integer).)!!'tableaudit_logsaudit_logsCREATE TABLE "audit_logs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "message" varchar(255) NOT NULL, "developer_id" integer NOT NULL)  uu:puA*YtableauthorsauthorsCREATE TABLE "authors" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "author_address_id" integer, "author_address_extra_id" integer)~+--/tableauthor_addressesauthor_addressesCREATE TABLE "author_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL)1,--tableauthor_favoritesauthor_favoritesCREATE TABLE "author_favorites" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "author_id" integer, "favorite_author_id" integer) -''Utableauto_id_testsauto_id_tests CREATE TABLE "auto_id_tests" ("auto_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "value" integer)s.9tablebinariesbinaries CREATE TABLE "binaries" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "data" blob)/mtablebirdsbirds CREATE TABLE "birds" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "pirate_id" integer) ^A%00JFIF%00%00H%00H%00%00%00C%00    ! ''**''555556666e  kQ7wX>ii"birds_1+e birds_0+e birds_1+ebirds_0+e7Killer bandita Dionne+e-Posideons Killer+e7Killer bandita Dionne+e-Posideons Killer+e7Killer bandita Dionne+e-Posideons Killer+e7Killer bandita Dionne+e-Posideons Killer+e-Privateers Greed+e'Grace OMalley+ee7Killer bandita Dionne+e -Posideons Killer+e 7Killer bandita Dionne+e -Posideons Killer+e -Privateers Greed+e 'Grace OMalley+ee-Privateers Greed+e'Grace OMalley+ee +e +e+e+e7Killer bandita Dionne+e-Posideons Killer+e I%Getting Real%MAgile Web Development with Rails) Godfather  rD )Not AssociatedMf+A special category in an arbitrarily named subsubdir fileSpecialCategory,e=+Another special categorySpecialCategory7dS+A special category in a subdir fileSpecialCategory!TechnologyCategory$-+Special categorySpecialCategoryGeneralCategory    +Skull and bonesɧ0CBanana appreciation society%EQMoustache and Eyebrow Fancier Club  T*q test %)Special TypeSpecialComment#Normal typeComment&?Thank you for the welcomeComment)/1Very Special typeVerySpecialComment(5)Don't think too hardSpecialComment,KThank you again for the welcomeComment"))Special type 2SpecialComment %)Special typeSpecialComment )go crazySpecialComment #Normal typeComment Kr"' ClientClient37signalsSummit! ClientClientEx Nihilo' =ExclusivelyDependentFirmOdegy% 3FirmFirmFlamboyant Software !Jadedpixel FirmFirm37signals! ClientClientMicrosoft  'DependentFirmRailsCore Leetsoft  ==S%!!WDavid2Funny StreetScary TownLoony Land35.544623640962634x-105.9309951055148:'!''Barney GumbleQuiet RoadPeaceful TownTranquil Land0###Zaphod>Avenue RoadHamlet TownNation Land sR8833fixture_42009-04-16 17:24:492009-04-16 17:24:49433David82009-04-16 17:24:492009-04-16 17:24:49833fixture_32009-04-16 17:24:492009-04-16 17:24:499 !33fixture_102009-04-16 17:24:492009-04-16 17:24:49433JamisI2009-04-16 17:24:492009-04-16 17:24:498 33fixture_92009-04-16 17:24:492009-04-16 17:24:49833fixture_82009-04-16 17:24:492009-04-16 17:24:493 33Jamis#(2009-04-16 17:24:492009-04-16 17:24:49833fixture_72009-04-16 17:24:492009-04-16 17:24:49833fixture_62009-04-16 17:24:492009-04-16 17:24:49833fixture_52009-04-16 17:24:492009-04-16 17:24:49 !2004-10-10 !2004-10-10   )Ruby DeveloperRuby Guru!Java Lover  $OThe \n Aristocrats Ate the candy #Knock knock          9&+e 5Englebert Humperdink;%Groucho Marx  [[4צּf3/2009-03-19 17:24:19S yfCurrentMembership43/2009-03-26 17:24:19S fCurrentMembership-x3!2009-03-26 17:24:19E tMembership  Founding#Provisional  f f t  *+\[$  !Terminator Gladiator   #DiscordiansL)No Such Agency 3ashley2009-04-16 17:24:48"!3blackbeard2009-04-16 17:24:48  rmOgH_@ ~qdWJ=0# zz+e +e +e +e +e +e +e +e +e +e +e +e +e +e +e +e +e +e +e +e +e +e +e +e +e +e +e +e 9& ]9&   &f ] ]&fgJ 8gJ 8 MDavidFSusanMMichael  mochi chew parrotqhۖ nۖ~lۖqkۖefۖY &d|H7/7Welcome to the!+!SubStiPostSubStiPost bodySubStiPostA/A#So I was thinkingLike I hopefully always amSpecialPost6Qeager loading with OR'd conditionshelloPost<?5I don't have any commentsI just don't want toPoststi mehelloStiPost57/Welcome to the weblogSuch a lovely dayPost %sti commentshelloPost")habtm sti testhelloPost ؏JTreasureԚFTreasure /Active Controller'Active Record  jiɿ~ part 1 &_ &_ )~ yMember[E Member@S yMember #alterselfLuke Holden%!=webster132David Heinemeier Hansson  alterself!webster132 !webster132!webster132alterself *332005-03-29 23:30:002005-03-30 01:30:00 YPC3The Fourth Topic of the dayCarl2006-07-15 09:28:00Why not?tReplyy+933!+The First TopicDaviddavid@loudthinking.com2003-07-16 09:28:112005-01-30 08:28:002004-04-15Have a nice dayfWC3+The Second Topic of the dayMary2004-07-15 09:28:00Have a nice daytReplyLA3#The Third Topic of the dayNick2005-07-15 09:28:00I'm a trollt Postq7P[UPost Post PostFakeModel Item Aquaked4doomed2&doomed General Misc  Bone Jruby]Parrotsapphire+ePirate fdiamond             .a-y)`0: 332009-04-16 17:24:482009-04-16 17:24:4809 332009-04-16 17:24:482009-04-16 17:24:48M" 33=2009-04-16 17:24:482009-04-16 17:24:48*NestedSetWithStringScopeL! 33=2009-04-16 17:24:482009-04-16 17:24:48*NestedSetWithStringScope0A 332009-04-16 17:24:482009-04-16 17:24:480; 332009-04-16 17:24:482009-04-16 17:24:480< 332009-04-16 17:24:482009-04-16 17:24:480= 332009-04-16 17:24:482009-04-16 17:24:480> 332009-04-16 17:24:482009-04-16 17:24:480? 332009-04-16 17:24:482009-04-16 17:24:480@ 332009-04-16 17:24:482009-04-16 17:24:480B 332009-04-16 17:24:482009-04-16 17:24:48M# 33=2009-04-16 17:24:482009-04-16 17:24:48*NestedSetWithStringScopeM$ 33=2009-04-16 17:24:482009-04-16 17:24:48*NestedSetWithStringScope   p`M% 33=2009-04-16 17:24:482009-04-16 17:24:48 *NestedSetWithStringScopeM& 33=2009-04-16 17:24:482009-04-16 17:24:48 *NestedSetWithStringScopeM' 33=2009-04-16 17:24:482009-04-16 17:24:48 *NestedSetWithStringScopeM( 33=2009-04-16 17:24:482009-04-16 17:24:48*NestedSetWithStringScopeM) 33=2009-04-16 17:24:482009-04-16 17:24:48*NestedSetWithStringScopeM* 33=2009-04-16 17:24:482009-04-16 17:24:48*NestedSetWithStringScope   Q1UwQU@ 33332009-04-16 17:24:452009-04-16 17:24:452009-04-16 17:24:452009-04-16 17:24:45U? 33332009-04-16 17:24:452009-04-16 17:24:452009-04-16 17:24:452009-04-16 17:24:45j> 73333Killer bandita Dionne2009-04-16 17:24:452009-04-16 17:24:452009-04-16 17:24:452009-04-16 17:24:45e= -3333Posideons Killer2009-04-16 17:24:452009-04-16 17:24:452009-04-16 17:24:452009-04-16 17:24:45m< )!3333Curious GeorgeLiveParrot2009-04-16 17:24:162009-04-16 17:24:162009-04-16 17:24:162009-04-16 17:24:16hI !3333frederickLiveParrot2009-04-16 17:24:162009-04-16 17:24:162009-04-16 17:24:162009-04-16 17:24:16i7 !!3333King LouisLiveParrot2009-04-16 17:24:162009-04-16 17:24:162009-04-16 17:24:162009-04-16 17:24:16h !3333pollyDeadParrot9&2009-04-16 17:24:162009-04-16 17:24:162009-04-16 17:24:162009-04-16 17:24:16_W !3333LiveParrot2009-04-16 17:24:162009-04-16 17:24:162009-04-16 17:24:162009-04-16 17:24:162FME3oo;TFɿa]zgBHv LKqug\Z`͛s o( '[5E C0E%008h ]CeϠQ1P@^í5yNRZó^%00k`c;9Tyy7>Ş2 |1ng>BRQjU ;;|AEEe Jf\%00R(3KeAҹ[[VDbAA/a @1%00hls*1$J%00eкӉK xPNԶZVM iIuoH?*0 8FZQ%25rHzǖ(- \$r265.E\1|0%00]RJ4\@p #yj  @)a7" / q&91#Y8ѢeZw,%00. 5ucW< #z=b1`Kx4ɀ8:Vb/H0Qw G byp#Vu@J%00(P +r=<[R^0eϺGPRbmHY ?%00W-0c|>Ws٫R;Faoj ޢkk%25KCiЍ/1Y?Z0%25%00J%00(P @%009;':R<%00gɌS 6M?Oڐx0xEF6aoE1X`}g&֫Hq 1B"P*Y@%25%00J%00__5%25է|TsT k;N~%25z$+vCQH,_ ĺ3%00@dj ?-Ks}iqu0Be ADu`|S+^9bT`[@dŗ3[|k7|"xMrA%00553XwߧZ^37Gٲ:9=+кu|$hT`ʣo?}پʸQ!# _O-NND90{{w"ܖ-9(,ږJ4[i粴kEDtlB0˫CZ}og^ŀL}`y).{J1{{8> $ލ[5DtvBQ_0?1&?%25דvQrmaD.*`ru=0je{x2bh`6R4|I?&dڏof#,ܨnIߦR]cx`dΟ iG#%00Qi ( xөq8:tuު&h]yrwo є&xX lgt#:qѩ on` v%00gE itgJ |kNP1SR6Hnd7 - TXu}+hc^DJ!u:aP mG99a[{jW%25> +b \Gn>T%00( >&92k/;VU\m9^շD'岂>)&W%25NNg-]"Wb(MޚD6򡊷{e:L}%00z_] -*\np\%25bx#2Ggm$͜c[_̋qkK sSF:e%00# z~˭J{L-ݜD1r>8E"0@gP5dnoکҏan.l%00 #?”R571ӶQ[nY5j6͋P%00ke3aBOP#?Y訃(a|)z zmqר'-s G,A;֞5`76#o`Gzipn%25bDJ[Oɓ(v=7[Ȧ n0vwzJrE/pˮ!g/l璯++;of\ꍈqޢPSOih/bc:kuHQ1kX/:#7·S;BKf+lɍ˂z)Zjpߔuw m\h9շ=}+/qdcM觇p+]SI=T޲ߖc?>M 4*U tV ^ W/Jp4f`"?--Ohb^O+ i[$O*{J2GϾϠPuvmS YzʙwX@Ǎ,s+'X#hyƠs><+Tywm2>y80 Ӿ)/vHxIb%00]OsԷ;{M50*qz jQ|;j&mA+gKBEuq4-<{Vs1ϖ4א^? 8}$j#v>UqIy^]9_\e` K2;* 3E.RHSU|ͦ>x".to{YRb>uH[)|4 "t#Yی]8Ս\WlqmrWt[]31AM6a6H'iI%00S`k IK2yCQ٥lk%00GCL.eoMƫ*"PSG/Kf95L+(όSҭwF}P,oĽ| `ݫ;H%00@KAJqВ B>Lqi9=?,oyAFw}9Ǎ&2<w ?gF%00-T9v>%00A힄8j2p4gV#V,5ֹzdFp[q=XK9܏,;Wgqb^ĖH`<ω[ʈj*K.x0WXF:%00WCƙܲGK*9îdy9*HOwƞĊ~L&kPQVDi9>t)zeNo[[.Ƞ ;%00h 2FEvp"lQ1֣֭I:RPj0ç7ҹrےdOGHc ig;ԗBrIh":c+u@X]’KOF86aፐ2z{i J-㑔71bv #N6 $:sZ1p i?Zfj 2|jeɘ6r,8˦?ZGf)Ɯf8aF-cWK Ā_,Y2[nҳwi"%25KCڭ! gmmΓN헲01TxhRp@:?Zzh;"Eoyt(ˮi=jm&2rgBKP|r壄@eqwqXG#`L %00eK."R׈7r;?wґQ3bTc1`OZӢRI*I%25ε(K6'ڲObƞk%00u*6䗑eڏjWFը)8I3~GaۙQXYH#\g>_NmtYv|*=sq"6 ovo0P @."gTLa {_{z*u4%00F%00CA$-DI OǂO~]rƯyUBǚYR9 p3d x\ʹ*Sڝ-&و6V# 9bF:T>]%00)Y`nGq7[Cu?( V2ʰRIѾ<>T'$.a>g,ՍY7ӵ)y)Mp(}< b~_i%00u0*m13%00 hI_ `֢EDZvC 8鹩)h jfTdQ >22}%00 85'\wB?-kq:aE(K6SJFdl mLҖ_KK4JrqZ]m;kHncm)mOW՗ٵ{8F8l{UdoswfzX\Ǐh(]hA(4]N7 m~t%00{eG\X6ADy-63Jt%004ܿg޵D9{ >~'6mmɺl%00d666666%00C &&,$ $,(+&&&+(//,,//666666666666666%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00@%00 %00%00%00%00!1A"Qa2q#BR3b$C%255Ers%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00*%00%00%00%00%00%00%00!1AQ"a2qBR%00 %00%00?%00u%00J%00(`'`:@{t.a >?:%00M-Y6oQ+4p#| .,P31 dZY!/y)/*A\m:gS'03U[@%25%00J%00(P Mnvh-ѻm2n |u ,C%00+d3ܪf;x6NR`erɞ֐$bn_UY_iJ3i  >tQ33c>*D]w Bbh{mw'VSP @%25%00W4 e۠%004%00nde$ . '0N-7Ҍd vC}WfSEW%00_C߇_%00k{)Bäiڜ2/ tableedgesedgesCREATE TABLE "edges" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "source_id" integer NOT NULL, "sink_id" integer NOT NULL)n?/#indexunique_edge_indexedgesCREATE UNIQUE INDEX "unique_edge_index" ON "edges" ("source_id", "sink_id") rrU<_e//mtableshape_expressionsshape_expressionsBCREATE TABLE "shape_expressions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "paint_type" varchar(255), "paint_id" integer, "shape_type" varchar(255), "shape_id" integer)cf%tableshipsshipsCCREATE TABLE "ships" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "pirate_id" integer, "created_at" datetime, "created_on" datetime, "updated_at" datetime, "updated_on" datetime)g!!stableship_partsship_partsDCREATE TABLE "ship_parts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "ship_id" integer)4h;tablesponsorssponsorsECREATE TABLE "sponsors" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "club_id" integer, "sponsorable_id" integer, "sponsorable_type" varchar(255))qi##)tablesubscriberssubscribersFCREATE TABLE "subscribers" ("nick" varchar(255) NOT NULL, "name" varchar(255)) 22_B`[tablepiratespirates=CREATE TABLE "pirates" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "catchphrase" varchar(255), "parrot_id" integer, "created_on" datetime, "updated_on" datetime)agtablepostsposts>CREATE TABLE "posts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "author_id" integer, "title" varchar(255) NOT NULL, "body" text NOT NULL, "type" varchar(255), "comments_count" integer DEFAULT 0, "taggings_count" integer DEFAULT 0)Gb++Etableprice_estimatesprice_estimates?CREATE TABLE "price_estimates" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "estimate_of_type" varchar(255), "estimate_of_id" integer, "price" integer)cstableprojectsprojects@CREATE TABLE "projects" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "type" varchar(255))dtablereadersreadersACREATE TABLE "readers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_id" integer NOT NULL, "person_id" integer NOT NULL) APr6CtableclubsclubsCREATE TABLE "clubs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255))7%%etablecolnametestscolnametestsCREATE TABLE "colnametests" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "references" integer NOT NULL)-8-tablecommentscommentsCREATE TABLE "comments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_id" integer NOT NULL, "body" text NOT NULL, "type" varchar(255)) 9etablecompaniescompaniesCREATE TABLE "companies" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar(255), "ruby_type" varchar(255), "firm_id" integer, "firm_name" varchar(255), "name" varchar(255), "client_of" integer, "rating" integer DEFAULT 1),:'tablecomputerscomputersCREATE TABLE "computers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "developer" integer NOT NULL, "extendedWarranty" integer NOT NULL) |xxbb [ktableparrotsparrots8CREATE TABLE "parrots" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "parrot_sti_class" varchar(255), "killer_id" integer, "created_at" datetime, "created_on" datetime, "updated_at" datetime, "updated_on" datetime)t\++tableparrots_piratesparrots_pirates9CREATE TABLE "parrots_pirates" ("parrot_id" integer, "pirate_id" integer)|]//'tableparrots_treasuresparrots_treasures:CREATE TABLE "parrots_treasures" ("parrot_id" integer, "treasure_id" integer)tablepeoplepeople;CREATE TABLE "people" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "first_name" varchar(255) NOT NULL, "primary_contact_id" integer, "gender" varchar(1), "lock_version" integer DEFAULT 0 NOT NULL)_tablepetspets