File: FuzzyOcr.mysql

package info (click to toggle)
fuzzyocr 3.6.0-15
  • links: PTS, VCS
  • area: main
  • in suites: bookworm, bullseye, sid
  • size: 804 kB
  • sloc: perl: 3,127; sh: 45; makefile: 2
file content (34 lines) | stat: -rw-r--r-- 1,194 bytes parent folder | download | duplicates (6)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
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';