Sophie

Sophie

distrib > Fedora > 14 > i386 > by-pkgid > ba02fe3850f2de2ce34a7aefd196fe40 > files > 7

spamassassin-FuzzyOcr-3.6.0-5.fc14.noarch.rpm

CREATE DATABASE FuzzyOcr;
use FuzzyOcr;

CREATE TABLE `Hash` (
  `key` varchar(255) NOT NULL default '',
  `basic` varchar(64) NOT NULL default '',
  `fname` varchar(160) NOT NULL default '',
  `ctype` varchar(64) NOT NULL default '',
  `ftype` smallint(5) unsigned NOT NULL default '0', 
  `match` int(10) unsigned NOT NULL default '0',
  `input` int(10) unsigned NOT NULL default '0',
  `check` int(10) unsigned NOT NULL default '0',
  `score` decimal(8,3) NOT NULL default '0.000',
  `dinfo` text NOT NULL,
  PRIMARY KEY  (`key`)
  ) TYPE=MyISAM;

CREATE TABLE `Safe` (
  `key` varchar(255) NOT NULL default '',
  `basic` varchar(64) NOT NULL default '',
  `fname` varchar(160) NOT NULL default '',
  `ctype` varchar(64) NOT NULL default '',
  `ftype` smallint(5) unsigned NOT NULL default '0', 
  `match` int(10) unsigned NOT NULL default '0',
  `input` int(10) unsigned NOT NULL default '0',
  `check` int(10) unsigned NOT NULL default '0',
  `score` decimal(8,3) NOT NULL default '0.000',
  `dinfo` text NOT NULL,
  PRIMARY KEY  (`key`)
  ) TYPE=MyISAM;

GRANT SELECT,UPDATE,INSERT,DELETE
  ON FuzzyOcr.* TO fuzzyocr@localhost IDENTIFIED BY 'fuzzyocr';