22.
-- Структура таблицы `blogger`
--
CREATE TABLE IF NOT EXISTS `blogger` (
`id` int(20) NOT NULL AUTO_INCREMENT,
`nick` varchar(32) CHARACTER SET cp1251 COLLATE cp1251_bin NOT NULL,
`pass` varchar(64) CHARACTER SET cp1251 COLLATE cp1251_bin DEFAULT NULL,
`name` varchar(40) CHARACTER SET cp1251 COLLATE cp1251_bin DEFAULT NULL,
`sex` varchar(4) NOT NULL,
`email` varchar(50) CHARACTER SET cp1251 COLLATE cp1251_bin DEFAULT NULL,
`ip` text,
`soft` text,
`last` bigint(20) DEFAULT NULL,
`icq` bigint(20) NOT NULL,
`level` int(2) NOT NULL DEFAULT '0',
`online` int(11) NOT NULL DEFAULT '0',
`birthday` varchar(10) NOT NULL DEFAULT '01.01.1970',
`country` varchar(100) DEFAULT NULL,
`city` varchar(100) DEFAULT NULL,
`about` text,
`status` varchar(100) DEFAULT NULL,
`mosh` int(11) NOT NULL DEFAULT '0',
`style` varchar(100) NOT NULL DEFAULT 'default',
`nickcolor1` varchar(255) DEFAULT NULL,
`nickcolor2` varchar(255) DEFAULT NULL,
`jur` enum('0','1') DEFAULT '0',
`money` int(11) NOT NULL DEFAULT '0',
`skype` varchar(50) NOT NULL,
`site` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
`mobtel` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
`icon` varchar(50) DEFAULT NULL,
`ups` enum('0','1') DEFAULT '0',
`family` varchar(40) NOT NULL,
`wmid` char(22) DEFAULT NULL,
`wmr` char(22) NOT NULL,
`email_secret` varchar(40) NOT NULL,
`activ` int(22) NOT NULL DEFAULT '1',
`spec` int(22) NOT NULL DEFAULT '0',
`activ_who` int(11) DEFAULT NULL,
`ava` varchar(250) DEFAULT NULL,
`gears` int(22) DEFAULT '0',
`reg` bigint(20) DEFAULT NULL,
`post` int(22) NOT NULL,
`hash_code` char(200) NOT NULL,
`rec_time` int(11) NOT NULL,
`wm` enum('0','1') DEFAULT '0',
`pro` enum('0','1') DEFAULT '0',
`row` int(2) NOT NULL DEFAULT '0',
`panel` enum('0','1') DEFAULT '0',
`vis` int(22) NOT NULL,
`vk` varchar(50) NOT NULL,
`rodz` text,
`sneg` enum('0','1') DEFAULT '0',
`inter` varchar(100) NOT NULL,
`oper` varchar(100) NOT NULL,
`model` varchar(100) NOT NULL,
`rur` char(22) NOT NULL DEFAULT '0',
`us_browser` varchar(99) NOT NULL,
`total_onl` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 PACK_KEYS=0 AUTO_INCREMENT=301 ;