-- Table for storing index file counts
-- Keyed names for various closed-class types
CREATE TABLE props(
  segment INTEGER NOT NULL, 
  ftype CHAR(1) NOT NULL, -- 'r', 'w', 'c'
  https INTEGER NOT NULL, -- 0:http vs. 1:https
  ct_primary VARCHAR(11) NOT NULL, -- 'text', 'image', 'audio', 'video', 'application'
  ct_sub VARCHAR(32),
  sniffed_primary VARCHAR(11) NOT NULL, -- as above
  sniffed_sub VARCHAR(32),
  nlangs INTEGER NOT NULL,
  lang1 CHAR(3),
  lang2 CHAR(3),
  lang3 CHAR(3)
);