USE rdf;

CREATE TABLE theyrule (
  subj varchar(255) NOT NULL default '',
  pred varchar(255) NOT NULL default '',
  obj text NOT NULL,
  type tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (subj(120),pred(120),obj(120)),
  KEY subj (subj),
  KEY obj (obj(100)),
  KEY pred (pred),
  KEY subjpred (subj(117),pred(117)),
  KEY predobj (pred(117),obj(117))
) TYPE=MyISAM;