commit f74e6bb744285abe3049d43d7fd7a11a2faaf48f
from: Omar Polo <op@omarpolo.com>
date: Sun Aug 13 21:54:32 2023 UTC

add the sqlite schema

commit - 7de3dcd8748cb8495689313b2e71f03163e5f3f2
commit + f74e6bb744285abe3049d43d7fd7a11a2faaf48f
blob - /dev/null
blob + f113c3a89fc8e957b957cda53ee9f50d07289780 (mode 644)
--- /dev/null
+++ schema.sql
@@ -0,0 +1,13 @@
+create virtual table webpkg_fts using fts5(id,
+                                           pkgstem,
+                                           comment,
+                                           descr_contents,
+                                           maintainer);
+
+insert into webpkg_fts
+select pathid,
+       pkgstem,
+       comment,
+       descr_contents,
+       maintainer
+  from portsq;