[{"_1":2,"_1389":-5,"_1390":-5},"loaderData",{"_3":4,"_12":13},"root",{"_5":6,"_7":8,"_9":10,"_11":10},"isProd",true,"enableStats",false,"domain","dailyplanet.io","siteHost","routes/$",{"_14":15,"_1094":1095},"json",{"_16":17,"_18":19,"_20":-5,"_21":-5,"_22":-5,"_23":8,"_24":-5,"_25":26,"_82":6,"_36":83,"_94":95,"_96":97,"_1076":1077,"_1078":6,"_11":1079,"_1080":1079,"_1081":1082,"_1089":1090},"prefersLanguages",[],"viewTerm","collaborators","panelParam","openComment","accountUid","isInspect","inspectTab","document",{"_27":28,"_58":39,"_59":60,"_61":62,"_64":65,"_66":67,"_68":67,"_69":70,"_73":74,"_75":39,"_76":77,"_80":81},"content",[29,48],{"_30":31,"_32":33},"children",[],"block",{"_34":35,"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47},"type","Paragraph","id","aCEYbPQu","revision","bafy2bzacecx5esnrxl5jn7vuvipekststglxkcucs6vtnqa42zlqiq3i3ue2y","attributes",{},"annotations",[],"text","web/web-db.sqlite '.schema'","link","",{"_30":49,"_32":50},[],{"_34":51,"_36":52,"_38":39,"_40":53,"_42":56,"_44":57,"_46":47},"Code","21av0R-X",{"_54":55},"language","sql",[],"CREATE TABLE emails (\n email TEXT UNIQUE NOT NULL,\n adminToken TEXT NOT NULL,\n createdAt DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,\n isUnsubscribed BOOLEAN NOT NULL DEFAULT FALSE\n );\nCREATE TABLE notifier_status (\n field TEXT UNIQUE NOT NULL,\n value TEXT NOT NULL\n );\nCREATE TABLE email_subscriptions (\n id TEXT NOT NULL,\n email TEXT NOT NULL REFERENCES emails(email),\n createdAt DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,\n notifyAllMentions BOOLEAN NOT NULL DEFAULT FALSE,\n notifyAllReplies BOOLEAN NOT NULL DEFAULT FALSE,\n notifyOwnedDocChange BOOLEAN NOT NULL DEFAULT FALSE,\n notifySiteDiscussions BOOLEAN NOT NULL DEFAULT FALSE,\n notifyAllComments BOOLEAN NOT NULL DEFAULT FALSE,\n PRIMARY KEY (id, email)\n ) WITHOUT ROWID;","version","account","z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno","authors",[63],"z6MkrbYsRzKb1VABdvhsDSAk6JK8fAszKsyHhcaZigYeWCou","path","/specs/email-service-database-schema","createTime","2025-10-09T09:14:16.050Z","updateTime","metadata",{"_71":72},"name","Email Service Database Schema","detachedBlocks",{},"genesis","generationInfo",{"_75":39,"_78":79},"generation","1760001256050","visibility","PUBLIC","isLatest",{"_64":84,"_58":39,"_87":8,"_88":60,"_36":89,"_90":-5,"_91":-5,"_92":-5,"_93":-5},[85,86],"specs","email-service-database-schema","latest","uid","hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/specs/email-service-database-schema","blockRef","blockRange","hostname","scheme","siteHomeIcon","ipfs://bafkreibbbufz2nmtqikzu4xilamfp2z77umkmlj5r7h4vqvgydf4gq57rm","dehydratedState",{"_98":99,"_100":101},"mutations",[],"queries",[102,146,256,757,763,778,1051],{"_103":104,"_141":142,"_144":145},"state",{"_105":106,"_125":126,"_127":128,"_129":-5,"_130":131,"_132":131,"_133":131,"_134":-5,"_135":-5,"_136":8,"_137":138,"_139":140},"data",{"_34":25,"_25":107,"_36":123},{"_27":108,"_58":39,"_59":60,"_61":119,"_64":65,"_66":67,"_68":67,"_69":120,"_73":121,"_75":39,"_76":122,"_80":81},[109,114],{"_30":110,"_32":111},[],{"_34":35,"_36":37,"_38":39,"_40":112,"_42":113,"_44":45,"_46":47},{},[],{"_30":115,"_32":116},[],{"_34":51,"_36":52,"_38":39,"_40":117,"_42":118,"_44":57,"_46":47},{"_54":55},[],[63],{"_71":72},{},{"_75":39,"_78":79},{"_36":89,"_88":60,"_64":124,"_58":39,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_87":8},[85,86],"dataUpdateCount",1,"dataUpdatedAt",1779025288052,"error","errorUpdateCount",0,"errorUpdatedAt","fetchFailureCount","fetchFailureReason","fetchMeta","isInvalidated","status","success","fetchStatus","idle","queryKey",[143,89,39,8],"ENTITY","queryHash","[\"ENTITY\",\"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/specs/email-service-database-schema\",\"bafy2bzacecx5esnrxl5jn7vuvipekststglxkcucs6vtnqa42zlqiq3i3ue2y\",false]",{"_103":147,"_141":254,"_144":255},{"_105":148,"_125":126,"_127":253,"_129":-5,"_130":131,"_132":131,"_133":131,"_134":-5,"_135":-5,"_136":8,"_137":138,"_139":140},{"_34":25,"_25":149,"_36":250},{"_27":150,"_58":156,"_59":60,"_61":181,"_64":47,"_66":186,"_68":187,"_69":188,"_73":198,"_75":247,"_76":248,"_80":81},[151],{"_30":152,"_32":153},[],{"_34":154,"_36":155,"_38":156,"_40":157,"_42":179,"_44":180,"_46":47},"Query","j95CSEq5","bafy2bzacecegestw5sab3x2k6kdwv756vwrywm2xmisp4csbapbsriiafn7xu",{"_158":8,"_159":160,"_161":162,"_177":178},"banner","columnCount",3,"query",{"_163":164,"_169":170,"_171":172},"sort",[165],{"_166":167,"_168":8},"term","ActivityTime","reverse","limit",80,"includes",[173],{"_174":175,"_64":47,"_176":60},"mode","AllDescendants","space","style","List",[],"/",[182,183,184,63,60,185],"z6MkgYR76i3w2Xc2fcvgFJWfYjsop6YwUonDhQx3AdLmQ4BQ","z6MkgisVMELvqnsCo3dYmtVpy8PiqPGMVwfAyBWFn84vebq4","z6MkkGNjfnikRkxK9EaxMPYy3HYxNGkRyXTWxxRtynB2kyeb","z6Mkvz9TgGtv9zsGsdrksfNk1ajbFancgHREJEz3Y2HsAVdk","1970-01-01T00:00:00Z","2026-04-10T16:53:31.218Z",{"_71":189,"_190":95,"_191":192,"_193":194,"_195":8,"_196":197},"Develop Seed Hypermedia","icon","cover","ipfs://bafybeib4utfkwzslucqnkinoar5cdo4ajz4zx45ytqjrfdfbgqebjteyt4","siteUrl","https://seedteamtalks.hyper.media","showActivity","contentWidth","L",{"_199":200},"navigation",{"_30":201,"_32":245},[202,209,215,221,227,233,239],{"_30":203,"_32":204},[],{"_34":205,"_36":206,"_46":207,"_44":208},"Link","UvOMbyhnsjpL3CaU8_0pg","hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/projects?v=bafy2bzacec3blhe775ddawbmajnfdac7xee6yoajs2brtdc5mbzg24sn6hjhg&l","Projects",{"_30":210,"_32":211},[],{"_34":205,"_36":212,"_46":213,"_44":214},"0dneHA1iYVUB6pwR-YPMv","hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/roadmap","Roadmap",{"_30":216,"_32":217},[],{"_34":205,"_36":218,"_46":219,"_44":220},"Os3QakPzxNB8OzZpVdpQ3","hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/tech-talks","Tech",{"_30":222,"_32":223},[],{"_34":205,"_36":224,"_46":225,"_44":226},"Jh7YrFGNfT5LqzWXR9hZ-","hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/human-interface-library","Design",{"_30":228,"_32":229},[],{"_34":205,"_36":230,"_46":231,"_44":232},"hgoxp_CZgdacfA6L4fMLf","hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/specs","Specs",{"_30":234,"_32":235},[],{"_34":205,"_36":236,"_46":237,"_44":238},"7QpiCgdQDsxYY4tekQd47","hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/discussions","Notes",{"_30":240,"_32":241},[],{"_34":205,"_36":242,"_46":243,"_44":244},"bdfz0tfzzZc0Kho3U3ZKw","hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/meeting-notes?v=bafy2bzacecdujov4k6h3filkpqwm4kgrrjxj3dpnurspxw2pbbpeyewqnesry&l","Meetings",{"_34":246,"_36":199},"Group","bafy2bzacec7wxg3z4sucahp62txnbuf4k2qv3vzpwh72ivlmchvbzw5anhzku",{"_75":247,"_78":249},"0",{"_36":251,"_88":60,"_64":252,"_58":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_87":6},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno",[],1779025288283,[143,251,-5,6],"[\"ENTITY\",\"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno\",null,true]",{"_103":257,"_141":753,"_144":756},{"_105":258,"_125":126,"_127":752,"_129":-5,"_130":131,"_132":131,"_133":131,"_134":-5,"_135":-5,"_136":8,"_137":138,"_139":140},[259,299,328,354,382,411,434,462,489,517,546,575,599,619,646,670,698,722],{"_34":25,"_36":260,"_64":264,"_61":265,"_66":267,"_68":272,"_275":276,"_75":277,"_58":263,"_278":279,"_282":283,"_76":295,"_296":-5,"_69":297,"_80":81},{"_36":225,"_88":60,"_64":261,"_58":263,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_87":6},[262],"human-interface-library","bafy2bzacecxbqfqvvvkbnfjtpxrh55smjl56gud2clbdzu3t7p3cqx3i3727m",[262],[63,266,185,183,184],"z6MkfnCSnmstMXTAb6MBXXCj4zdPwZedtRF6YBgYtE5Q8Sov",{"_268":269,"_270":271},"seconds","1752161904","nanos",417000000,{"_268":273,"_270":274},"1776440581",14000000,"sortTime","2025-07-10T15:38:24.417Z","bafy2bzacec6hrmu6x3i4sig3v65yimreki35vksxz7rvahnhcgbn4zbnqxh4c","breadcrumbs",[280],{"_71":189,"_64":47,"_281":8},"isMissing","activitySummary",{"_284":285,"_288":289,"_290":291,"_292":293,"_294":6},"latestCommentTime",{"_268":286,"_270":287},"1776340335",457000000,"latestCommentId","z6MkkGNjfnikRkxK9EaxMPYy3HYxNGkRyXTWxxRtynB2kyeb/z6GLVY2M8des8j","commentCount",81,"latestChangeTime",{"_268":273,"_270":274},"isUnread",{"_75":277,"_78":249},"redirectInfo",{"_71":226,"_196":298},"M",{"_34":25,"_36":300,"_64":305,"_61":306,"_66":307,"_68":310,"_275":313,"_75":314,"_58":304,"_278":315,"_282":317,"_76":324,"_296":-5,"_69":326,"_80":81},{"_36":301,"_88":60,"_64":302,"_58":304,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_87":6},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/opportunities",[303],"opportunities","bafy2bzaceabaf435zbgb6dcuyclu252j6z4hbrzhin5vdirudwdq36upu2zq6",[303],[63,60,185,184],{"_268":308,"_270":309},"1773675441",829000000,{"_268":311,"_270":312},"1776243381",301000000,"2026-03-16T15:37:21.829Z","bafyreiaxt6v6p36usl3ymb4m55nvf6vld7p2qjmpncxh3fpu53zdiokxou",[316],{"_71":189,"_64":47,"_281":8},{"_284":318,"_288":321,"_290":322,"_292":323,"_294":6},{"_268":319,"_270":320},"1775467626",413000000,"z6MkrbYsRzKb1VABdvhsDSAk6JK8fAszKsyHhcaZigYeWCou/z6GBnuC6qwSTFr",32,{"_268":311,"_270":312},{"_75":314,"_78":325},"1773675441867",{"_71":327},"Opportunities",{"_34":25,"_36":329,"_64":334,"_61":335,"_66":338,"_68":341,"_275":344,"_75":345,"_58":333,"_278":346,"_282":348,"_76":350,"_296":-5,"_69":352,"_80":81},{"_36":330,"_88":60,"_64":331,"_58":333,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_87":6},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/projects",[332],"projects","bafy2bzacedfq4xabnf7vdjhn2hywt4dbjga4o7byoqm4yqkdv2x6xhfyg2pnk",[332],[63,336,60,185,183,337,182],"z6Mkq9emq1yUBq4KSeiSH5yzgNBJSnidPVqFnTpzjCdLxB3R","z6MkqULds7oeqGPgtSpqpisK77FxhwP57ikVNFVfYfsMb2KZ",{"_268":339,"_270":340},"1737452534",659000000,{"_268":342,"_270":343},"1776165388",875000000,"2025-01-21T09:42:14.659Z","bafy2bzaceclwoffe3urzgxzxeuaozsyftjoswi7kymxmnbame5ruwmf665oei",[347],{"_71":189,"_64":47,"_281":8},{"_284":-5,"_288":47,"_290":131,"_292":349,"_294":6},{"_268":342,"_270":343},{"_75":345,"_78":351},"1776159433168",{"_71":208,"_353":47,"_196":197},"summary",{"_34":25,"_36":355,"_64":359,"_61":360,"_66":361,"_68":364,"_275":367,"_75":368,"_58":358,"_278":369,"_282":371,"_76":378,"_296":-5,"_69":380,"_80":81},{"_36":219,"_88":60,"_64":356,"_58":358,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_87":6},[357],"tech-talks","bafy2bzacec3hf2dnrxwxcdbi2dp5viy2kzptmtbi24zy5lpme7bndtws6bj5y",[357],[63,336,185,183,337],{"_268":362,"_270":363},"1760379588",8000000,{"_268":365,"_270":366},"1775132885",363000000,"2025-10-13T18:19:48.008Z","bafy2bzaceci4odwwqtrrrhrntnq46pdvkpshot2xnkm3jpatfyvpfqwjmlhnq",[370],{"_71":189,"_64":47,"_281":8},{"_284":372,"_288":375,"_290":376,"_292":377,"_294":6},{"_268":373,"_270":374},"1775298187",857000000,"z6MkgisVMELvqnsCo3dYmtVpy8PiqPGMVwfAyBWFn84vebq4/z6GA6vaVVhfjgS",4,{"_268":365,"_270":366},{"_75":368,"_78":379},"1774993923224",{"_71":220,"_353":381},"Conversations about technology and enlightenment.",{"_34":25,"_36":383,"_64":388,"_61":389,"_66":390,"_68":393,"_275":396,"_75":397,"_58":387,"_278":398,"_282":400,"_76":407,"_296":-5,"_69":409,"_80":81},{"_36":384,"_88":60,"_64":385,"_58":387,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_87":6},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/user-story-map",[386],"user-story-map","bafy2bzacebkvsp55y66yio2qcnf6sqi56nouw6pb4jski76heq4loruz7ureo",[386],[63,183],{"_268":391,"_270":392},"1753177046",860000000,{"_268":394,"_270":395},"1774859074",164000000,"2025-07-22T09:37:26.860Z","bafy2bzacealtqjbqauikxnocl2so3eorgne3ggkhv7cogtf4onodqaxartg7o",[399],{"_71":189,"_64":47,"_281":8},{"_284":401,"_288":404,"_290":405,"_292":406,"_294":8},{"_268":402,"_270":403},"1770976718",280000000,"z6MkgisVMELvqnsCo3dYmtVpy8PiqPGMVwfAyBWFn84vebq4/z6FR25YjTujXE6",6,{"_268":394,"_270":395},{"_75":397,"_78":408},"1753177046858",{"_71":410},"User Story Map",{"_34":25,"_36":412,"_64":417,"_61":418,"_66":419,"_68":422,"_275":425,"_75":426,"_58":416,"_278":427,"_282":429,"_76":431,"_296":-5,"_69":433,"_80":81},{"_36":413,"_88":60,"_64":414,"_58":416,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_87":6},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/tags",[415],"tags","bafy2bzacebh3uai5xosfuptcc7odxbksnhq2fbwhxhzhgto4zbgmyhyyi2n7a",[415],[63],{"_268":420,"_270":421},"1773928289",806000000,{"_268":423,"_270":424},"1774091072",932000000,"2026-03-19T13:51:29.806Z","bafyreib7lekmh45w6pw5ctoz7t2vlyox44umxddr73jdzadncm5nnfexje",[428],{"_71":189,"_64":47,"_281":8},{"_284":-5,"_288":47,"_290":131,"_292":430,"_294":6},{"_268":423,"_270":424},{"_75":426,"_78":432},"1773928289849",{"_71":415},{"_34":25,"_36":435,"_64":439,"_61":440,"_66":441,"_68":444,"_275":447,"_75":448,"_58":438,"_278":449,"_282":451,"_76":458,"_296":-5,"_69":460,"_80":81},{"_36":237,"_88":60,"_64":436,"_58":438,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_87":6},[437],"discussions","bafy2bzacebah2eatzegt3q5jqtnjzvp7sshanoe5lhnofmrz2iri4ftor7pbu",[437],[63,60,185],{"_268":442,"_270":443},"1732791826",161000000,{"_268":445,"_270":446},"1773912127",677000000,"2024-11-28T11:03:46.161Z","bafy2bzacecai7zv2yssq7j6on5wnylvsdgg2ctbyrnwoknh4wwtasexjh22wm",[450],{"_71":189,"_64":47,"_281":8},{"_284":452,"_288":455,"_290":456,"_292":457,"_294":6},{"_268":453,"_270":454},"1775666612",310000000,"z6MkgisVMELvqnsCo3dYmtVpy8PiqPGMVwfAyBWFn84vebq4/z6GDmxm9nJZUeX",139,{"_268":445,"_270":446},{"_75":448,"_78":459},"1732791826161",{"_71":238,"_353":461,"_196":197},"Sometimes a Comment is not enough. Write a Note.",{"_34":25,"_36":463,"_64":467,"_61":468,"_66":469,"_68":472,"_275":475,"_75":476,"_58":466,"_278":477,"_282":479,"_76":486,"_296":-5,"_69":488,"_80":81},{"_36":213,"_88":60,"_64":464,"_58":466,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_87":6},[465],"roadmap","bafyreia57kttdwgrrwsrc2l4z6amvovcbhrcp3xig5oojvlnrlwlubiggq",[465],[63,266,60,183,182],{"_268":470,"_270":471},"1751702529",991000000,{"_268":473,"_270":474},"1773744906",927000000,"2025-07-05T08:02:09.991Z","bafy2bzaced3t5nb4pyuu5iukdirwdsblmggv2vuq6urpnd4vftg5lnu5yjuey",[478],{"_71":189,"_64":47,"_281":8},{"_284":480,"_288":483,"_290":484,"_292":485,"_294":6},{"_268":481,"_270":482},"1771863047",262000000,"z6MkomKJd58PhVSoDZPi9RtUZ6rLrT2P8UN9ijLpb7Hj2tdn/z6FZrbATfsngbe",8,{"_268":473,"_270":474},{"_75":476,"_78":487},"1751702529991",{"_71":214},{"_34":25,"_36":490,"_64":495,"_61":496,"_66":497,"_68":500,"_275":503,"_75":504,"_58":494,"_278":505,"_282":507,"_76":513,"_296":-5,"_69":515,"_80":81},{"_36":491,"_88":60,"_64":492,"_58":494,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_87":6},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/stories",[493],"stories","bafyreiaw6iu4ehtc5kn2cfdwr2y3yxa3hu6snyujjnn2qc5rkzsl7t7bxe",[493],[63,60,185],{"_268":498,"_270":499},"1756300583",462000000,{"_268":501,"_270":502},"1773744591",518000000,"2025-08-27T13:16:23.462Z","bafy2bzacecrattxfobgydg3rqsirjsquulwbxpermpxqfohwlugmidlepcqi2",[506],{"_71":189,"_64":47,"_281":8},{"_284":508,"_288":511,"_290":376,"_292":512,"_294":6},{"_268":509,"_270":510},"1756890701",660000000,"z6MkrbYsRzKb1VABdvhsDSAk6JK8fAszKsyHhcaZigYeWCou/z6Czaz5aHoBXeb",{"_268":501,"_270":502},{"_75":504,"_78":514},"1756300583462",{"_71":516},"Stories",{"_34":25,"_36":518,"_64":523,"_61":524,"_66":525,"_68":528,"_275":531,"_75":532,"_58":522,"_278":533,"_282":535,"_76":541,"_296":-5,"_69":543,"_80":81},{"_36":519,"_88":60,"_64":520,"_58":522,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_87":6},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/methodologies",[521],"methodologies","bafyreiaegtx6u7ok6fbhsarksggyrmsruf7eki3g6txntzdue2basya5tu",[521],[63],{"_268":526,"_270":527},"1752483694",123000000,{"_268":529,"_270":530},"1773743554",608000000,"2025-07-14T09:01:34.123Z","bafy2bzacebip7pvsmdoewquvcmipekt53gcksnn7pbc7igu7u5wpsonneptvq",[534],{"_71":189,"_64":47,"_281":8},{"_284":536,"_288":539,"_290":160,"_292":540,"_294":6},{"_268":537,"_270":538},"1762185594",5000000,"z6MkrbYsRzKb1VABdvhsDSAk6JK8fAszKsyHhcaZigYeWCou/z6DuNhfkk1A2qb",{"_268":529,"_270":530},{"_75":532,"_78":542},"1752483694123",{"_71":544,"_353":545},"Methodologies","Methodologies are a necessary element for human intellect augmentation. ",{"_34":25,"_36":547,"_64":552,"_61":553,"_66":554,"_68":557,"_275":560,"_75":561,"_58":551,"_278":562,"_282":564,"_76":570,"_296":-5,"_69":572,"_80":81},{"_36":548,"_88":60,"_64":549,"_58":551,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_87":6},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/meeting-notes",[550],"meeting-notes","bafy2bzaceb3t47birzausbjryuzwdkop24jy7cxtkytzvax5lgsxmjrksm6ng",[550],[182],{"_268":555,"_270":556},"1758055379",977000000,{"_268":558,"_270":559},"1772015186",609000000,"2025-09-16T20:42:59.977Z","bafy2bzaceba7jlw74w3a6fh5yq7y7tp4hpzp4ubbqkknmuel3nogbihkthzes",[563],{"_71":189,"_64":47,"_281":8},{"_284":565,"_288":568,"_290":160,"_292":569,"_294":6},{"_268":566,"_270":567},"1773738814",25000000,"z6MkgYR76i3w2Xc2fcvgFJWfYjsop6YwUonDhQx3AdLmQ4BQ/z6FtZESzQxvSJd",{"_268":558,"_270":559},{"_75":561,"_78":571},"1758055379977",{"_71":573,"_353":574},"Meeting Notes","Every time we have a meeting, it's useful to take notes. When we do, let's put them in this directory.",{"_34":25,"_36":576,"_64":579,"_61":580,"_66":581,"_68":584,"_275":587,"_75":588,"_58":578,"_278":589,"_282":591,"_76":597,"_296":-5,"_69":598,"_80":81},{"_36":231,"_88":60,"_64":577,"_58":578,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_87":6},[85],"bafy2bzacedfa3cmxkeswnj5eqvsuzyg3n2jrihwkrekq2u7v7p7xfdot53a4e",[85],[63,60,185,183],{"_268":582,"_270":583},"1757507072",743000000,{"_268":585,"_270":586},"1770899043",471000000,"2025-09-10T12:24:32.743Z","bafy2bzacedgzqyw4bffanmgxuxigf7w4qksk4ib5ut7mhfcggm5w4f3ud3xwm",[590],{"_71":189,"_64":47,"_281":8},{"_284":592,"_288":594,"_290":595,"_292":596,"_294":6},{"_268":593,"_270":471},"1767006098","z6MkkGNjfnikRkxK9EaxMPYy3HYxNGkRyXTWxxRtynB2kyeb/z6EjS7JQ2Gzgun",5,{"_268":585,"_270":586},{"_75":588,"_78":249},{"_71":232},{"_34":25,"_36":600,"_64":605,"_61":606,"_66":607,"_68":610,"_275":611,"_75":604,"_58":604,"_278":612,"_282":614,"_76":616,"_296":-5,"_69":617,"_80":81},{"_36":601,"_88":60,"_64":602,"_58":604,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_87":6},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/funnel-analytics",[603],"funnel-analytics","bafy2bzaced3kgwogkq4sbf755r6lnw4ccg6hsqrwshqfxbznshfga3yxs3fyo",[603],[63],{"_268":608,"_270":609},"1767610404",700000000,{"_268":608,"_270":609},"2026-01-05T10:53:24.700Z",[613],{"_71":189,"_64":47,"_281":8},{"_284":-5,"_288":47,"_290":131,"_292":615,"_294":6},{"_268":608,"_270":609},{"_75":604,"_78":249},{"_71":618},"Funnel Analytics",{"_34":25,"_36":620,"_64":625,"_61":626,"_66":627,"_68":630,"_275":633,"_75":634,"_58":624,"_278":635,"_282":637,"_76":643,"_296":-5,"_69":644,"_80":81},{"_36":621,"_88":60,"_64":622,"_58":624,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_87":6},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/identified-pain-points",[623],"identified-pain-points","bafy2bzacebn5gompe4lz5crytfykeyi7vkbszyd4ejepwe7i2zj64el3cvjcq",[623],[63],{"_268":628,"_270":629},"1753351865",631000000,{"_268":631,"_270":632},"1758272387",548000000,"2025-07-24T10:11:05.631Z","bafy2bzacebpdextl7sosiws4oprqfldkj3lswtl3mng3lxkqagwtqgnza5rfo",[636],{"_71":189,"_64":47,"_281":8},{"_284":638,"_288":641,"_290":126,"_292":642,"_294":6},{"_268":639,"_270":640},"1758272380",427000000,"z6MkrbYsRzKb1VABdvhsDSAk6JK8fAszKsyHhcaZigYeWCou/z6DEMvgvGpZY5d",{"_268":631,"_270":632},{"_75":634,"_78":249},{"_71":645},"Identified Pain Points",{"_34":25,"_36":647,"_64":652,"_61":653,"_66":654,"_68":657,"_275":660,"_75":661,"_58":651,"_278":662,"_282":664,"_76":666,"_296":-5,"_69":668,"_80":81},{"_36":648,"_88":60,"_64":649,"_58":651,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_87":6},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/site-organization",[650],"site-organization","bafy2bzacebjuo7m4ljbnnw6f3qwve3wqnu24wkmcwmv4scjsqizgfyk6ls2wm",[650],[63,60],{"_268":655,"_270":656},"1757971251",134000000,{"_268":658,"_270":659},"1758011895",764000000,"2025-09-15T21:20:51.134Z","bafy2bzacecspxqbvg4vyrgwuazy766ndx7i2aa2zfc76kt5awvr2lzz4tb65y",[663],{"_71":189,"_64":47,"_281":8},{"_284":-5,"_288":47,"_290":131,"_292":665,"_294":6},{"_268":658,"_270":659},{"_75":661,"_78":667},"1757971251133",{"_71":669},"Site Organization",{"_34":25,"_36":671,"_64":676,"_61":677,"_66":678,"_68":681,"_275":684,"_75":685,"_58":675,"_278":686,"_282":688,"_76":694,"_296":-5,"_69":696,"_80":81},{"_36":672,"_88":60,"_64":673,"_58":675,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_87":6},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/create-a-new-discussion",[674],"create-a-new-discussion","bafy2bzacecwyuyxhqqfwmkd4hek7yudoebwjaqt2ehun346r5vah6qnyqaau2",[674],[63,182],{"_268":679,"_270":680},"1756300679",383000000,{"_268":682,"_270":683},"1757423008",601000000,"2025-08-27T13:17:59.383Z","bafy2bzacedokt2n6ku35tovylopn76r4vbcuwf4je7v5rdomdyr35adapsdaq",[687],{"_71":189,"_64":47,"_281":8},{"_284":689,"_288":692,"_290":160,"_292":693,"_294":6},{"_268":690,"_270":691},"1756457180",886000000,"z6MkfnCSnmstMXTAb6MBXXCj4zdPwZedtRF6YBgYtE5Q8Sov/z6CvGJhetZ6XBp",{"_268":682,"_270":683},{"_75":685,"_78":695},"1756300679383",{"_71":697},"Create a new Discussion",{"_34":25,"_36":699,"_64":704,"_61":705,"_66":706,"_68":709,"_275":712,"_75":713,"_58":703,"_278":714,"_282":716,"_76":718,"_296":-5,"_69":720,"_80":81},{"_36":700,"_88":60,"_64":701,"_58":703,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_87":6},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/definitions",[702],"definitions","bafy2bzaceardarkdfmc7l5gko4v2zi3z5kf6y7alekquvqxzp3ioexqzabo72",[702],[63,60],{"_268":707,"_270":708},"1752232211",716000000,{"_268":710,"_270":711},"1752232556",193000000,"2025-07-11T11:10:11.716Z","bafy2bzaceaqctzadpz27ncr674vzix6jgcvuqvuix3jcqlfhpetpblxm6o2fg",[715],{"_71":189,"_64":47,"_281":8},{"_284":-5,"_288":47,"_290":131,"_292":717,"_294":6},{"_268":710,"_270":711},{"_75":713,"_78":719},"1752232211716",{"_71":721},"Definitions",{"_34":25,"_36":723,"_64":728,"_61":729,"_66":730,"_68":733,"_275":736,"_75":737,"_58":727,"_278":738,"_282":740,"_76":747,"_296":-5,"_69":749,"_80":81},{"_36":724,"_88":60,"_64":725,"_58":727,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_87":6},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/updates",[726],"updates","bafy2bzacedjhk4r4tzf2bfkhd3rqbzep2o7s6ec3tzuwpn3jbqo4ipv2vrnle",[726],[336,185,183,182],{"_268":731,"_270":732},"1745330217",834000000,{"_268":734,"_270":735},"1746610473",772000000,"2025-04-22T13:56:57.834Z","bafy2bzacedajlr6y5olm3ee24vmpat7yxi7ysb35qnyu3z7fkmsd7sloxwpm6",[739],{"_71":189,"_64":47,"_281":8},{"_284":741,"_288":744,"_290":745,"_292":746,"_294":6},{"_268":742,"_270":743},"1763480049",21000000,"zDnaeUAteHX98erunHCNphgNFnXeQnAegvQjUKqxKJWQFP6Z3/z6E8HCybawN6HA",2,{"_268":734,"_270":735},{"_75":737,"_78":748},"1745330217833",{"_71":750,"_751":8,"_196":197},"Updates","showOutline",1779025289079,[754,251,755],"DOC_LIST_DIRECTORY","Children","[\"DOC_LIST_DIRECTORY\",\"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno\",\"Children\"]",{"_103":758,"_141":761,"_144":762},{"_105":759,"_125":126,"_127":760,"_129":-5,"_130":131,"_132":131,"_133":131,"_134":-5,"_135":-5,"_136":8,"_137":138,"_139":140},[],1779025289578,[754,89,755],"[\"DOC_LIST_DIRECTORY\",\"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/specs/email-service-database-schema\",\"Children\"]",{"_103":764,"_141":775,"_144":777},{"_105":765,"_125":126,"_127":774,"_129":-5,"_130":131,"_132":131,"_133":131,"_134":-5,"_135":-5,"_136":8,"_137":138,"_139":140},{"_766":126,"_767":126,"_768":126,"_30":131,"_769":770,"_771":772},"citations","comments","changes","authorUids",[185,63],"blocks",{"_37":773},{"_766":131,"_767":126},1779025288351,[776,89],"DOCUMENT_INTERACTION_SUMMARY","[\"DOCUMENT_INTERACTION_SUMMARY\",\"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/specs/email-service-database-schema\"]",{"_103":779,"_141":1049,"_144":1050},{"_105":780,"_125":126,"_127":1048,"_129":-5,"_130":131,"_132":131,"_133":131,"_134":-5,"_135":-5,"_136":8,"_137":138,"_139":140},{"_34":25,"_25":781,"_36":1046},{"_27":782,"_58":578,"_59":60,"_61":1040,"_64":1041,"_66":587,"_68":1042,"_69":1043,"_73":1044,"_75":588,"_76":1045,"_80":81},[783,819,1031],{"_30":784,"_32":785},[],{"_34":35,"_36":786,"_38":787,"_40":788,"_42":789,"_44":818,"_46":47},"CrDSSVHp","bafy2bzaced5ybl3dlltqdy65loclddtjdylfjyxt4psnr36j7b6qn6japn2fe",{},[790,799,805,811],{"_34":791,"_792":793,"_795":796,"_40":798,"_46":491},"Embed","starts",[794],11,"ends",[797],12,{},{"_34":791,"_792":800,"_795":802,"_40":804,"_46":225},[801],14,[803],15,{},{"_34":791,"_792":806,"_795":808,"_40":810,"_46":213},[807],17,[809],18,{},{"_34":791,"_792":812,"_795":814,"_40":816,"_46":817},[813],24,[815],25,{},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/definitions?v=bafy2bzaceardarkdfmc7l5gko4v2zi3z5kf6y7alekquvqxzp3ioexqzabo72","Read first , , , and .",{"_30":820,"_32":1026},[821,844,863,883],{"_30":822,"_32":836},[823],{"_30":824,"_32":825},[],{"_34":35,"_36":826,"_38":827,"_40":828,"_42":829,"_44":835,"_46":47},"uyJZ3btY","bafy2bzacedrjp5kokeljzirkimkdfqk7zvdn7rqtumopopal4h2uxivyv5eic",{},[830],{"_34":791,"_792":831,"_795":832,"_40":833,"_46":834},[131],[126],{},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/specs/role-permissions-logic?l"," ",{"_34":837,"_36":838,"_38":827,"_40":839,"_42":842,"_44":843,"_46":47},"Heading","oSRDdI6p",{"_840":841},"childrenType","Unordered",[],"Permissions",{"_30":845,"_32":858},[846],{"_30":847,"_32":848},[],{"_34":35,"_36":849,"_38":850,"_40":851,"_42":852,"_44":835,"_46":47},"ZNbvLWHY","bafy2bzaceb2l7xdpg4ktqcjnjk6pvkgrvyn5xszwdg4z3fdueycsfow2reb3y",{},[853],{"_34":791,"_792":854,"_795":855,"_40":856,"_46":857},[131],[126],{},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/specs/keyboard-shortcuts?l",{"_34":837,"_36":859,"_38":850,"_40":860,"_42":861,"_44":862,"_46":47},"nECoiOo0",{"_840":841},[],"Keyboard Shortcuts",{"_30":864,"_32":878},[865],{"_30":866,"_32":867},[],{"_34":35,"_36":868,"_38":869,"_40":870,"_42":871,"_44":72,"_46":47},"po2aStW7","bafy2bzacebujexsc7nsvt6gazccal5ipio3wjhr5guga6btbik2whpm47xkge",{},[872],{"_34":205,"_792":873,"_795":874,"_40":876,"_46":877},[131],[875],29,{},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/specs/email-service-database-schema?v=bafy2bzacecx5esnrxl5jn7vuvipekststglxkcucs6vtnqa42zlqiq3i3ue2y",{"_34":837,"_36":879,"_38":787,"_40":880,"_42":881,"_44":882,"_46":47},"pPeVyc4D",{"_840":841},[],"Data Base Schemas",{"_30":884,"_32":1021},[885,919,926,947,979,1000],{"_30":886,"_32":914},[887,900],{"_30":888,"_32":889},[],{"_34":35,"_36":890,"_38":891,"_40":892,"_42":893,"_44":899,"_46":47},"mTmk7dFs","bafy2bzaced2x4xrm7iobdiu36zpr5joik67ajmjdix4ttxcuhvtphsi5x6uty",{},[894],{"_34":205,"_792":895,"_795":896,"_40":897,"_46":898},[131],[807],{},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/specs/activity-protobuf?l","Activity Protobuf",{"_30":901,"_32":902},[],{"_34":35,"_36":903,"_38":904,"_40":905,"_42":906,"_44":913,"_46":47},"fAf10Wv8","bafy2bzaceal25j72rqozt7ee6ksbosidqtj6ewtv26zdr6z76vvgnhphhavko",{},[907],{"_34":205,"_792":908,"_795":909,"_40":911,"_46":912},[131],[910],23,{},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/specs/subscriptions-protobuf-?v=bafy2bzaceb6rrgmjvfztimahzmkjw7w5i6ospg4j5uzinc7ksyglzc7ngm5ic","Subscriptions Protobuf ",{"_34":837,"_36":915,"_38":787,"_40":916,"_42":917,"_44":918,"_46":47},"4WdIM9KV",{"_840":841},[],"Activity",{"_30":920,"_32":921},[],{"_34":837,"_36":922,"_38":787,"_40":923,"_42":924,"_44":925,"_46":47},"2oSi0axl",{},[],"Daemon",{"_30":927,"_32":942},[928],{"_30":929,"_32":930},[],{"_34":35,"_36":931,"_38":932,"_40":933,"_42":934,"_44":941,"_46":47},"AFPvnuLy","bafy2bzacecnu2ssfuhqen522rwbr2mwzj56skms2gt2ln4n5buo5q2kwsh7nu",{},[935],{"_34":205,"_792":936,"_795":937,"_40":939,"_46":940},[131],[938],52,{},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/specs/entities-protobuf-service-message-spec-v1alpha?l","Entities Protobuf – Service & Message Spec (v1alpha)",{"_34":837,"_36":943,"_38":787,"_40":944,"_42":945,"_44":946,"_46":47},"UeDqjh_3",{"_840":841},[],"Entities",{"_30":948,"_32":975},[949,962],{"_30":950,"_32":951},[],{"_34":35,"_36":952,"_38":932,"_40":953,"_42":954,"_44":961,"_46":47},"JXUcjRnB",{},[955],{"_34":205,"_792":956,"_795":957,"_40":959,"_46":960},[131],[958],38,{},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/specs/resources-protobuf-documents-v3alpha?l","Resources Protobuf (Documents v3alpha)",{"_30":963,"_32":964},[],{"_34":35,"_36":965,"_38":966,"_40":967,"_42":968,"_44":974,"_46":47},"l25HcjeA","bafy2bzacedlzr2xy3v5kxiwjytn7yw4bsd5s2s2gwngsvgw75z7uzm3nw7zdk",{},[969],{"_34":205,"_792":970,"_795":971,"_40":972,"_46":973},[131],[875],{},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/specs/networking-protobuf-v1alpha?v=bafy2bzacebm2ukcjuhbyaygmeiq5kfdjy6dhb7w3m4733tdctz4ar7bstyppg","Networking Protobuf (v1alpha)",{"_34":35,"_36":976,"_38":787,"_40":977,"_42":978,"_44":47,"_46":47},"AmSBu87z",{"_840":841},[],{"_30":980,"_32":995},[981],{"_30":982,"_32":983},[],{"_34":35,"_36":984,"_38":985,"_40":986,"_42":987,"_44":994,"_46":47},"BIpTdddD","bafy2bzacedvypqymgdzc2ter3jj6c4eqdfhjzbnojvjqqlfj6emqwudlszudi",{},[988],{"_34":205,"_792":989,"_795":990,"_40":992,"_46":993},[131],[991],43,{},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/specs/access-control-protobuf-documents-v3alpha?v=bafy2bzacecx3tpppwww33qnl6blqxqhx4ol6n6lprc3qvpw3d5fxssf7urk4w","Access Control Protobuf (Documents v3alpha)",{"_34":837,"_36":996,"_38":787,"_40":997,"_42":998,"_44":999,"_46":47},"1Ut2zIyy",{"_840":841},[],"Documents",{"_30":1001,"_32":1016},[1002,1009],{"_30":1003,"_32":1004},[],{"_34":837,"_36":1005,"_38":787,"_40":1006,"_42":1007,"_44":1008,"_46":47},"OEbKp1RE",{},[],"P2P",{"_30":1010,"_32":1011},[],{"_34":837,"_36":1012,"_38":787,"_40":1013,"_42":1014,"_44":1015,"_46":47},"bmZTKbKm",{},[],"Payments",{"_34":837,"_36":1017,"_38":787,"_40":1018,"_42":1019,"_44":1020,"_46":47},"ubP9mwWx",{"_840":246},[],"Networking",{"_34":837,"_36":1022,"_38":787,"_40":1023,"_42":1024,"_44":1025,"_46":47},"YZBL4vMe",{"_840":246},[],"Protobufs",{"_34":35,"_36":1027,"_38":787,"_40":1028,"_42":1029,"_44":1030,"_46":47},"6hfaSiXD",{"_840":246},[],"List of Documents:",{"_30":1032,"_32":1033},[],{"_34":791,"_36":1034,"_38":578,"_40":1035,"_42":1038,"_44":47,"_46":1039},"G7d8ATUPlj",{"_1036":1037},"view","Card",[],"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/specs/onyx-wg?v=bafy2bzaceblp4exrlwv2ulguftmrk7i2xzel7a2iitpnmh3k3aqdwdtzkavls",[183,63,60,185],"/specs","2026-02-12T12:24:03.471Z",{"_71":232},{},{"_75":588,"_78":249},{"_36":231,"_88":60,"_64":1047,"_58":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5},[85],1779025288166,[143,231,-5,8],"[\"ENTITY\",\"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/specs\",null,false]",{"_103":1052,"_141":1073,"_144":1075},{"_105":1053,"_125":126,"_127":1072,"_129":-5,"_130":131,"_132":131,"_133":131,"_134":-5,"_135":-5,"_136":8,"_137":138,"_139":140},{"_34":59,"_36":1054,"_69":1058},{"_58":1055,"_88":63,"_36":1056,"_64":1057,"_90":-5,"_91":-5,"_92":-5,"_93":-5},"bafy2bzaceard7t4wrqhqzizymqwow34l7foxc5yn2ihqapmwys4qs5mnmalzm","hm://z6MkrbYsRzKb1VABdvhsDSAk6JK8fAszKsyHhcaZigYeWCou",[],{"_71":1059,"_190":1060,"_1061":1060,"_191":1062,"_193":1063,"_1064":47,"_1065":1066,"_1067":47,"_195":8,"_196":197,"_1068":1069,"_353":-5},"Gabo H Beaumont","ipfs://bafkreifg4zwc2bidz3zuddxbld6dzeq5xfmbfhrzgx4hpj5bkxqtw6mgku","thumbnail","ipfs://bafybeiguwj7jll23xgh37usasgzapg7n5x2xfbzyat3jyrdthmwv2mufe4","https://gabo.es","layout","displayPublishTime","2025-01-21","seedExperimentalLogo","theme",{"_1070":1071},"headerLayout","Center",1779025289593,[1074,63],"ACCOUNT","[\"ACCOUNT\",\"z6MkrbYsRzKb1VABdvhsDSAk6JK8fAszKsyHhcaZigYeWCou\"]","ssrContentHTML","

web/web-db.sqlite '.schema'

CREATE TABLE emails (\n        email TEXT UNIQUE NOT NULL,\n        adminToken TEXT NOT NULL,\n        createdAt DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,\n        isUnsubscribed BOOLEAN NOT NULL DEFAULT FALSE\n      );\nCREATE TABLE notifier_status (\n        field TEXT UNIQUE NOT NULL,\n        value TEXT NOT NULL\n      );\nCREATE TABLE email_subscriptions (\n      id TEXT NOT NULL,\n      email TEXT NOT NULL REFERENCES emails(email),\n      createdAt DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,\n      notifyAllMentions BOOLEAN NOT NULL DEFAULT FALSE,\n      notifyAllReplies BOOLEAN NOT NULL DEFAULT FALSE,\n      notifyOwnedDocChange BOOLEAN NOT NULL DEFAULT FALSE,\n      notifySiteDiscussions BOOLEAN NOT NULL DEFAULT FALSE,\n      notifyAllComments BOOLEAN NOT NULL DEFAULT FALSE,\n      PRIMARY KEY (id, email)\n    ) WITHOUT ROWID;

","enableWebSigning","https://dailyplanet.io","origin","homeMetadata",{"_71":1083,"_190":1084,"_1061":1084,"_191":1085,"_193":1079,"_1064":47,"_1067":1084,"_1086":1087,"_751":8,"_196":197,"_1068":1088},"Daily Planet","ipfs://bafkreibwi4h3nzuc7invuqbq55pdsa4n6gyh2stz6a6a5vi2qylp62w2na","ipfs://bafybeifzrxuorbf6gmsw65r3ro3t5jko3vvhbuxeiljflvvysmg447di6m","seedExperimentalHomeOrder","CreatedFirst",{"_1070":1071},"originHomeId",{"_88":1091,"_36":1092,"_64":1093,"_58":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5},"z6Mkp8UGrBu3RMJZkoNKTgBiRp7LTA2bZ2EUvqFokKDof8FW","hm://z6Mkp8UGrBu3RMJZkoNKTgBiRp7LTA2bZ2EUvqFokKDof8FW",[],"meta",{"_1096":1097,"_1367":1368},"values",{"_1098":1099,"_1101":1102,"_1103":1104,"_1105":1106,"_1108":1109,"_1110":1111,"_1112":1113,"_1115":1116,"_1117":1118,"_1119":1120,"_1121":1122,"_1123":1124,"_1125":1126,"_1127":1128,"_1129":1130,"_1131":1132,"_1133":1134,"_1135":1136,"_1137":1138,"_1139":1140,"_1141":1142,"_1143":1144,"_1145":1146,"_1147":1148,"_1149":1150,"_1151":1152,"_1153":1154,"_1155":1156,"_1157":1158,"_1159":1160,"_1161":1162,"_1163":1164,"_1165":1166,"_1167":1168,"_1169":1170,"_1171":1172,"_1173":1174,"_1175":1176,"_1177":1178,"_1179":1180,"_1181":1182,"_1183":1184,"_1185":1186,"_1187":1188,"_1189":1190,"_1191":1192,"_1193":1194,"_1195":1196,"_1197":1198,"_1199":1200,"_1201":1202,"_1203":1204,"_1205":1206,"_1207":1208,"_1209":1210,"_1211":1212,"_1213":1214,"_1215":1216,"_1217":1218,"_1219":1220,"_1221":1222,"_1223":1224,"_1225":1226,"_1227":1228,"_1229":1230,"_1231":1232,"_1233":1234,"_1235":1236,"_1237":1238,"_1239":1240,"_1241":1242,"_1243":1244,"_1245":1246,"_1247":1248,"_1249":1250,"_1251":1252,"_1253":1254,"_1255":1256,"_1257":1258,"_1259":1260,"_1261":1262,"_1263":1264,"_1265":1266,"_1267":1268,"_1269":1270,"_1271":1272,"_1273":1274,"_1275":1276,"_1277":1278,"_1279":1280,"_1281":1282,"_1283":1284,"_1285":1286,"_1287":1288,"_1289":1290,"_1291":1292,"_1293":1294,"_1295":1296,"_1297":1298,"_1299":1300,"_1301":1302,"_1303":1304,"_1305":1306,"_1307":1308,"_1309":1310,"_1311":1312,"_1313":1314,"_1315":1316,"_1317":1318,"_1319":1320,"_1321":1322,"_1323":1324,"_1325":1326,"_1327":1328,"_1329":1330,"_1331":1332,"_1333":1334,"_1335":1336,"_1337":1338,"_1339":1340,"_1341":1342,"_1343":1344,"_1345":1346,"_1347":1348,"_1349":1350,"_1351":1352,"_1353":1354,"_1355":1356,"_1357":1358,"_1359":1360,"_1361":1362,"_1363":1364,"_1365":1366},"document.generationInfo.generation",[1100],"bigint","dehydratedState.queries.0.state.data.document.generationInfo.generation",[1100],"dehydratedState.queries.1.state.data.document.generationInfo.generation",[1100],"dehydratedState.queries.1.queryKey.2",[1107],"undefined","dehydratedState.queries.2.state.data.0.createTime.seconds",[1100],"dehydratedState.queries.2.state.data.0.updateTime.seconds",[1100],"dehydratedState.queries.2.state.data.0.sortTime",[1114],"Date","dehydratedState.queries.2.state.data.0.activitySummary.latestCommentTime.seconds",[1100],"dehydratedState.queries.2.state.data.0.activitySummary.latestChangeTime.seconds",[1100],"dehydratedState.queries.2.state.data.0.generationInfo.generation",[1100],"dehydratedState.queries.2.state.data.0.redirectInfo",[1107],"dehydratedState.queries.2.state.data.1.createTime.seconds",[1100],"dehydratedState.queries.2.state.data.1.updateTime.seconds",[1100],"dehydratedState.queries.2.state.data.1.sortTime",[1114],"dehydratedState.queries.2.state.data.1.activitySummary.latestCommentTime.seconds",[1100],"dehydratedState.queries.2.state.data.1.activitySummary.latestChangeTime.seconds",[1100],"dehydratedState.queries.2.state.data.1.generationInfo.generation",[1100],"dehydratedState.queries.2.state.data.1.redirectInfo",[1107],"dehydratedState.queries.2.state.data.2.createTime.seconds",[1100],"dehydratedState.queries.2.state.data.2.updateTime.seconds",[1100],"dehydratedState.queries.2.state.data.2.sortTime",[1114],"dehydratedState.queries.2.state.data.2.activitySummary.latestCommentTime",[1107],"dehydratedState.queries.2.state.data.2.activitySummary.latestChangeTime.seconds",[1100],"dehydratedState.queries.2.state.data.2.generationInfo.generation",[1100],"dehydratedState.queries.2.state.data.2.redirectInfo",[1107],"dehydratedState.queries.2.state.data.3.createTime.seconds",[1100],"dehydratedState.queries.2.state.data.3.updateTime.seconds",[1100],"dehydratedState.queries.2.state.data.3.sortTime",[1114],"dehydratedState.queries.2.state.data.3.activitySummary.latestCommentTime.seconds",[1100],"dehydratedState.queries.2.state.data.3.activitySummary.latestChangeTime.seconds",[1100],"dehydratedState.queries.2.state.data.3.generationInfo.generation",[1100],"dehydratedState.queries.2.state.data.3.redirectInfo",[1107],"dehydratedState.queries.2.state.data.4.createTime.seconds",[1100],"dehydratedState.queries.2.state.data.4.updateTime.seconds",[1100],"dehydratedState.queries.2.state.data.4.sortTime",[1114],"dehydratedState.queries.2.state.data.4.activitySummary.latestCommentTime.seconds",[1100],"dehydratedState.queries.2.state.data.4.activitySummary.latestChangeTime.seconds",[1100],"dehydratedState.queries.2.state.data.4.generationInfo.generation",[1100],"dehydratedState.queries.2.state.data.4.redirectInfo",[1107],"dehydratedState.queries.2.state.data.5.createTime.seconds",[1100],"dehydratedState.queries.2.state.data.5.updateTime.seconds",[1100],"dehydratedState.queries.2.state.data.5.sortTime",[1114],"dehydratedState.queries.2.state.data.5.activitySummary.latestCommentTime",[1107],"dehydratedState.queries.2.state.data.5.activitySummary.latestChangeTime.seconds",[1100],"dehydratedState.queries.2.state.data.5.generationInfo.generation",[1100],"dehydratedState.queries.2.state.data.5.redirectInfo",[1107],"dehydratedState.queries.2.state.data.6.createTime.seconds",[1100],"dehydratedState.queries.2.state.data.6.updateTime.seconds",[1100],"dehydratedState.queries.2.state.data.6.sortTime",[1114],"dehydratedState.queries.2.state.data.6.activitySummary.latestCommentTime.seconds",[1100],"dehydratedState.queries.2.state.data.6.activitySummary.latestChangeTime.seconds",[1100],"dehydratedState.queries.2.state.data.6.generationInfo.generation",[1100],"dehydratedState.queries.2.state.data.6.redirectInfo",[1107],"dehydratedState.queries.2.state.data.7.createTime.seconds",[1100],"dehydratedState.queries.2.state.data.7.updateTime.seconds",[1100],"dehydratedState.queries.2.state.data.7.sortTime",[1114],"dehydratedState.queries.2.state.data.7.activitySummary.latestCommentTime.seconds",[1100],"dehydratedState.queries.2.state.data.7.activitySummary.latestChangeTime.seconds",[1100],"dehydratedState.queries.2.state.data.7.generationInfo.generation",[1100],"dehydratedState.queries.2.state.data.7.redirectInfo",[1107],"dehydratedState.queries.2.state.data.8.createTime.seconds",[1100],"dehydratedState.queries.2.state.data.8.updateTime.seconds",[1100],"dehydratedState.queries.2.state.data.8.sortTime",[1114],"dehydratedState.queries.2.state.data.8.activitySummary.latestCommentTime.seconds",[1100],"dehydratedState.queries.2.state.data.8.activitySummary.latestChangeTime.seconds",[1100],"dehydratedState.queries.2.state.data.8.generationInfo.generation",[1100],"dehydratedState.queries.2.state.data.8.redirectInfo",[1107],"dehydratedState.queries.2.state.data.9.createTime.seconds",[1100],"dehydratedState.queries.2.state.data.9.updateTime.seconds",[1100],"dehydratedState.queries.2.state.data.9.sortTime",[1114],"dehydratedState.queries.2.state.data.9.activitySummary.latestCommentTime.seconds",[1100],"dehydratedState.queries.2.state.data.9.activitySummary.latestChangeTime.seconds",[1100],"dehydratedState.queries.2.state.data.9.generationInfo.generation",[1100],"dehydratedState.queries.2.state.data.9.redirectInfo",[1107],"dehydratedState.queries.2.state.data.10.createTime.seconds",[1100],"dehydratedState.queries.2.state.data.10.updateTime.seconds",[1100],"dehydratedState.queries.2.state.data.10.sortTime",[1114],"dehydratedState.queries.2.state.data.10.activitySummary.latestCommentTime.seconds",[1100],"dehydratedState.queries.2.state.data.10.activitySummary.latestChangeTime.seconds",[1100],"dehydratedState.queries.2.state.data.10.generationInfo.generation",[1100],"dehydratedState.queries.2.state.data.10.redirectInfo",[1107],"dehydratedState.queries.2.state.data.11.createTime.seconds",[1100],"dehydratedState.queries.2.state.data.11.updateTime.seconds",[1100],"dehydratedState.queries.2.state.data.11.sortTime",[1114],"dehydratedState.queries.2.state.data.11.activitySummary.latestCommentTime.seconds",[1100],"dehydratedState.queries.2.state.data.11.activitySummary.latestChangeTime.seconds",[1100],"dehydratedState.queries.2.state.data.11.generationInfo.generation",[1100],"dehydratedState.queries.2.state.data.11.redirectInfo",[1107],"dehydratedState.queries.2.state.data.12.createTime.seconds",[1100],"dehydratedState.queries.2.state.data.12.updateTime.seconds",[1100],"dehydratedState.queries.2.state.data.12.sortTime",[1114],"dehydratedState.queries.2.state.data.12.activitySummary.latestCommentTime",[1107],"dehydratedState.queries.2.state.data.12.activitySummary.latestChangeTime.seconds",[1100],"dehydratedState.queries.2.state.data.12.generationInfo.generation",[1100],"dehydratedState.queries.2.state.data.12.redirectInfo",[1107],"dehydratedState.queries.2.state.data.13.createTime.seconds",[1100],"dehydratedState.queries.2.state.data.13.updateTime.seconds",[1100],"dehydratedState.queries.2.state.data.13.sortTime",[1114],"dehydratedState.queries.2.state.data.13.activitySummary.latestCommentTime.seconds",[1100],"dehydratedState.queries.2.state.data.13.activitySummary.latestChangeTime.seconds",[1100],"dehydratedState.queries.2.state.data.13.generationInfo.generation",[1100],"dehydratedState.queries.2.state.data.13.redirectInfo",[1107],"dehydratedState.queries.2.state.data.14.createTime.seconds",[1100],"dehydratedState.queries.2.state.data.14.updateTime.seconds",[1100],"dehydratedState.queries.2.state.data.14.sortTime",[1114],"dehydratedState.queries.2.state.data.14.activitySummary.latestCommentTime",[1107],"dehydratedState.queries.2.state.data.14.activitySummary.latestChangeTime.seconds",[1100],"dehydratedState.queries.2.state.data.14.generationInfo.generation",[1100],"dehydratedState.queries.2.state.data.14.redirectInfo",[1107],"dehydratedState.queries.2.state.data.15.createTime.seconds",[1100],"dehydratedState.queries.2.state.data.15.updateTime.seconds",[1100],"dehydratedState.queries.2.state.data.15.sortTime",[1114],"dehydratedState.queries.2.state.data.15.activitySummary.latestCommentTime.seconds",[1100],"dehydratedState.queries.2.state.data.15.activitySummary.latestChangeTime.seconds",[1100],"dehydratedState.queries.2.state.data.15.generationInfo.generation",[1100],"dehydratedState.queries.2.state.data.15.redirectInfo",[1107],"dehydratedState.queries.2.state.data.16.createTime.seconds",[1100],"dehydratedState.queries.2.state.data.16.updateTime.seconds",[1100],"dehydratedState.queries.2.state.data.16.sortTime",[1114],"dehydratedState.queries.2.state.data.16.activitySummary.latestCommentTime",[1107],"dehydratedState.queries.2.state.data.16.activitySummary.latestChangeTime.seconds",[1100],"dehydratedState.queries.2.state.data.16.generationInfo.generation",[1100],"dehydratedState.queries.2.state.data.16.redirectInfo",[1107],"dehydratedState.queries.2.state.data.17.createTime.seconds",[1100],"dehydratedState.queries.2.state.data.17.updateTime.seconds",[1100],"dehydratedState.queries.2.state.data.17.sortTime",[1114],"dehydratedState.queries.2.state.data.17.activitySummary.latestCommentTime.seconds",[1100],"dehydratedState.queries.2.state.data.17.activitySummary.latestChangeTime.seconds",[1100],"dehydratedState.queries.2.state.data.17.generationInfo.generation",[1100],"dehydratedState.queries.2.state.data.17.redirectInfo",[1107],"dehydratedState.queries.5.state.data.document.generationInfo.generation",[1100],"dehydratedState.queries.5.queryKey.2",[1107],"dehydratedState.queries.6.state.data.metadata.summary",[1107],"referentialEqualities",{"_1098":1369,"_1103":1370,"_1110":1371,"_1125":1372,"_1139":1373,"_1153":1374,"_1167":1375,"_1181":1376,"_1195":1377,"_1209":1378,"_1223":1379,"_1237":1380,"_1251":1381,"_1265":1382,"_1277":1383,"_1293":1384,"_1307":1385,"_1321":1386,"_1335":1387,"_1349":1388},[1101],[1119,1273,1287,1301,1361],[1117],[1131],[1145],[1159],[1173],[1187],[1201],[1215],[1229],[1243],[1257],[1271],[1279,1285],[1299],[1313],[1327],[1341],[1355],"actionData","errors"]