-- This table needs to be created in a database with the name of your "workspace" 
-- For example if your configuration file is pcr/conf/pcr.xml you will need to
--    add this table to a database named "pcr"
CREATE TABLE c (p text NOT NULL,
n text NOT NULL,
v text NOT NULL,
KEY INDEX1 (p (1000)),
KEY INDEX2 (p (850), n (150)),
KEY INDEX3 (p (550), n (150), v (300)))
ENGINE = MyISAM DEFAULT CHARSET = latin1