root/trunk/devel/FuzzyOcr.mysql

Revision 66, 1.2 kB (checked in by jorge, 2 years ago)

Satisfies Ticket #14 (now closed)

Line 
1 CREATE DATABASE FuzzyOcr;
2 use FuzzyOcr;
3
4 CREATE TABLE `Hash` (
5   `key` varchar(255) NOT NULL default '',
6   `basic` varchar(64) NOT NULL default '',
7   `fname` varchar(160) NOT NULL default '',
8   `ctype` varchar(64) NOT NULL default '',
9   `ftype` smallint(5) unsigned NOT NULL default '0',
10   `match` int(10) unsigned NOT NULL default '0',
11   `input` int(10) unsigned NOT NULL default '0',
12   `check` int(10) unsigned NOT NULL default '0',
13   `score` decimal(8,3) NOT NULL default '0.000',
14   `dinfo` text NOT NULL,
15   PRIMARY KEY  (`key`)
16   ) TYPE=MyISAM;
17
18 CREATE TABLE `Safe` (
19   `key` varchar(255) NOT NULL default '',
20   `basic` varchar(64) NOT NULL default '',
21   `fname` varchar(160) NOT NULL default '',
22   `ctype` varchar(64) NOT NULL default '',
23   `ftype` smallint(5) unsigned NOT NULL default '0',
24   `match` int(10) unsigned NOT NULL default '0',
25   `input` int(10) unsigned NOT NULL default '0',
26   `check` int(10) unsigned NOT NULL default '0',
27   `score` decimal(8,3) NOT NULL default '0.000',
28   `dinfo` text NOT NULL,
29   PRIMARY KEY  (`key`)
30   ) TYPE=MyISAM;
31
32 GRANT SELECT,UPDATE,INSERT,DELETE
33   ON FuzzyOcr.* TO fuzzyocr@localhost IDENTIFIED BY 'fuzzyocr';
34
Note: See TracBrowser for help on using the browser.