tables.sql

CREATE TABLE IF NOT EXISTS {$lang}_terms (
  `id` int(12) NOT NULL auto_increment,
  `term` varchar(255) NOT NULL,
  `type` ENUM ('unknown', 'noun', 'verb', 'adj', 'adv'),
  PRIMARY KEY `id` (`id`),
  UNIQUE KEY  (`term`)
) ENGINE=MyISAM DEFAULT CHARSET=binary AUTO_INCREMENT=0 ;

CREATE TABLE IF NOT EXISTS {$lang}_concepts (
  `id` int(12) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  `type` ENUM ('unknown', 'person', 'place', 'time', 'lifeform', 'number'),
  PRIMARY KEY `id` (`id`),
  UNIQUE KEY  (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=binary AUTO_INCREMENT=0 ;

CREATE TABLE IF NOT EXISTS {$lang}_resources (
  `id` int(12) NOT NULL auto_increment,
  `domain` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `type` ENUM ('normal', 'redirect', 'disambig'),
  `timestamp` datetime default NULL,
  PRIMARY KEY `id` (`id`),
  UNIQUE KEY  (`domain`, `name`)
) ENGINE=MyISAM DEFAULT CHARSET=binary AUTO_INCREMENT=0 ;

CREATE TABLE IF NOT EXISTS {$lang}_meaning (
  `fromterm` int(12) NOT NULL,
  `toconcept` int(12) NOT NULL,
  `resource` int(12) NOT NULL,
  `confidence` float NOT NULL default '0',
  KEY `fromto` (`fromterm`,`toconcept`),
  KEY `tofrom` (`toconcept`,`fromterm`)
) ENGINE=MyISAM DEFAULT CHARSET=binary AUTO_INCREMENT=0 ;

CREATE TABLE IF NOT EXISTS {$lang}_similar (
  `fromconcept` int(12) NOT NULL,
  `toconcept` int(12) NOT NULL,
  `resource` int(12) NOT NULL,
  `confidence` float NOT NULL default '0',
  KEY `fromto` (`fromconcept`,`toconcept`),
  KEY `tofrom` (`toconcept`,`fromconcept`)
) ENGINE=MyISAM DEFAULT CHARSET=binary AUTO_INCREMENT=0 ;

CREATE TABLE IF NOT EXISTS {$lang}_similar_trans (
  `fromconcept` int(12) NOT NULL,
  `tolang` varchar(12) NOT NULL,
  `toconcept` int(12) NOT NULL,
  `resource` int(12) NOT NULL,
  `confidence` float NOT NULL default '0',
  KEY `fromto` (`fromconcept`,`tolang`,`toconcept`),
  KEY `tofrom` (`tolang`,`toconcept`,`fromconcept`)
) ENGINE=MyISAM DEFAULT CHARSET=binary AUTO_INCREMENT=0 ;

CREATE TABLE IF NOT EXISTS {$lang}_links (
  `fromconcept` int(12) NOT NULL,
  `toconcept` int(12) NOT NULL,
  `resource` int(12) NOT NULL,
  `confidence` float NOT NULL default '0',
  KEY `fromto` (`fromconcept`,`toconcept`),
  KEY `tofrom` (`toconcept`,`fromconcept`)
) ENGINE=MyISAM DEFAULT CHARSET=binary AUTO_INCREMENT=0 ;

CREATE TABLE IF NOT EXISTS {$lang}_cat (
  `fromconcept` int(12) NOT NULL,
  `toconcept` int(12) NOT NULL,
  `resource` int(12) NOT NULL,
  `confidence` float NOT NULL default '0',
  KEY `fromto` (`fromconcept`,`toconcept`),
  KEY `tofrom` (`toconcept`,`fromconcept`)
) ENGINE=MyISAM DEFAULT CHARSET=binary AUTO_INCREMENT=0 ;