MnjUYsjX

1CREATE TABLE IF NOT EXISTS `synonyms` (
2  `w_id` int(10) unsigned default NULL,
3  `s_id` int(10) unsigned default NULL,
4  KEY `s_id` (`s_id`),
5  KEY `w_id` (`w_id`)
6);
7
8INSERT INTO `synonyms` (`w_id`, `s_id`) VALUES
9(1, 2),
10(1, 3),
11(2, 1),
12(2, 3),
13(3, 1),
14(3, 2);
15
16-- --------------------------------------------------------
17
18CREATE TABLE IF NOT EXISTS `words` (
19  `id` int(10) unsigned NOT NULL auto_increment,
20  `word` varchar(30) default NULL,
21  PRIMARY KEY  (`id`)
22);
23
24
25INSERT INTO `words` (`id`, `word`) VALUES
26(1, 'penis'),
27(2, 'dick'),
28(3, 'cock');