LBCmu1L6

1--
2-- Структура таблицы `library_category`
3--
4DROP TABLE IF EXISTS `library_category`;
5CREATE TABLE IF NOT EXISTS `library_category` (
6`id` int(11) NOT NULL auto_increment,
7`refid` int(11) NOT NULL,
8`realid` int(11) NOT NULL,
9`name` varchar(250) NOT NULL,
10`translate` varchar(250) NOT NULL,
11`text` varchar(250) NOT NULL,
12`user` enum('0', '1') NOT NULL default '0',
13`keywords` varchar(2500) NOT NULL,
14`description` varchar(2500) NOT NULL,
15PRIMARY KEY (`id`),
16KEY `refid` (`refid`)
17) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
18
19--
20-- Структура таблицы `library`
21--
22DROP TABLE IF EXISTS `library`;
23CREATE TABLE IF NOT EXISTS `library` (
24`id` int(11) auto_increment,
25`id_user` int(11) NOT NULL,
26`refid` int(11) NOT NULL,
27`name` varchar(250) NOT NULL,
28`translate` varchar(250) NOT NULL,
29`anons` varchar(500) NOT NULL,
30`time` int(11) NOT NULL,
31`views` int(11) NOT NULL default '0',
32`keywords` varchar(2500) NOT NULL,
33`description` varchar(2500) NOT NULL,
34PRIMARY KEY  (`id`),
35KEY `id_user` (`id_user`),
36KEY `refid` (`refid`),
37FULLTEXT `nt` (`name`, `anons`)
38) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
39	
40SELECT `library_category`.*, 
41        (SELECT COUNT(*) 
42         FROM `library` 
43         WHERE `library`.`refid` = `library_category`.`id`
44        ) AS `count` 
45FROM `library_category`