dbstore/sql/fill-fts.sql


1
2
3
4
5
6
7
8
9
10

-- populate fts table
INSERT INTO cpe_fts(rowid, title)
  SELECT a.cpe_id,
         COALESCE(b.val, '')

    FROM cpes a
    LEFT JOIN cpe_titles b
      ON (b.cpe_id = a.cpe_id)

   WHERE b.lang = 'en-US';