cc/cirrus_home: results/cdx.sql annotate

annotate results/cdx.sql @ 144:3abcb61e0bd9

basic, works

author	Henry S. Thompson <ht@inf.ed.ac.uk>
date	Wed, 20 Oct 2021 17:14:18 +0000
parents	ddff993994be
children

rev	line source
144 3abcb61e0bd9 basic, works Henry S. Thompson <ht@inf.ed.ac.uk> parents: 143 diff changeset	1 -- Table for storing index file counts
143 ddff993994be too clever by half, keys won't work in parallel for e.g. media types Henry S. Thompson <ht@inf.ed.ac.uk> parents: diff changeset	2 -- Keyed names for various closed-class types
144 3abcb61e0bd9 basic, works Henry S. Thompson <ht@inf.ed.ac.uk> parents: 143 diff changeset	3 CREATE TABLE props(
3abcb61e0bd9 basic, works Henry S. Thompson <ht@inf.ed.ac.uk> parents: 143 diff changeset	4 segment INTEGER NOT NULL,
3abcb61e0bd9 basic, works Henry S. Thompson <ht@inf.ed.ac.uk> parents: 143 diff changeset	5 ftype CHAR(1) NOT NULL, -- 'r', 'w', 'c'
3abcb61e0bd9 basic, works Henry S. Thompson <ht@inf.ed.ac.uk> parents: 143 diff changeset	6 https INTEGER NOT NULL, -- 0:http vs. 1:https
3abcb61e0bd9 basic, works Henry S. Thompson <ht@inf.ed.ac.uk> parents: 143 diff changeset	7 ct_primary VARCHAR(11) NOT NULL, -- 'text', 'image', 'audio', 'video', 'application'
3abcb61e0bd9 basic, works Henry S. Thompson <ht@inf.ed.ac.uk> parents: 143 diff changeset	8 ct_sub VARCHAR(32),
3abcb61e0bd9 basic, works Henry S. Thompson <ht@inf.ed.ac.uk> parents: 143 diff changeset	9 sniffed_primary VARCHAR(11) NOT NULL, -- as above
3abcb61e0bd9 basic, works Henry S. Thompson <ht@inf.ed.ac.uk> parents: 143 diff changeset	10 sniffed_sub VARCHAR(32),
3abcb61e0bd9 basic, works Henry S. Thompson <ht@inf.ed.ac.uk> parents: 143 diff changeset	11 nlangs INTEGER NOT NULL,
3abcb61e0bd9 basic, works Henry S. Thompson <ht@inf.ed.ac.uk> parents: 143 diff changeset	12 lang1 CHAR(3),
3abcb61e0bd9 basic, works Henry S. Thompson <ht@inf.ed.ac.uk> parents: 143 diff changeset	13 lang2 CHAR(3),
3abcb61e0bd9 basic, works Henry S. Thompson <ht@inf.ed.ac.uk> parents: 143 diff changeset	14 lang3 CHAR(3)
143 ddff993994be too clever by half, keys won't work in parallel for e.g. media types Henry S. Thompson <ht@inf.ed.ac.uk> parents: diff changeset	15 );