vVmVH8Bf

1
2CREATE TABLE IF NOT EXISTS `dictionary` (
3  `id` int(10) NOT NULL AUTO_INCREMENT,
4  `word` varchar(50) NOT NULL,
5  PRIMARY KEY (`id`),
6  UNIQUE KEY `word` (`word`)
7) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2097 ;
8
9-- --------------------------------------------------------
10
11--
12-- Table structure for table `synonyms`
13--
14
15CREATE TABLE IF NOT EXISTS `synonyms` (
16  `id` int(10) NOT NULL AUTO_INCREMENT,
17  `word` int(10) NOT NULL,
18  `synonym` varchar(50) NOT NULL,
19  `meaning` int(10) NOT NULL DEFAULT '1',
20  `quodvide` enum('0','1') NOT NULL DEFAULT '0'
21  PRIMARY KEY (`id`),
22  KEY `word` (`word`,`synonym`)
23) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3743 ;