--
-- Table structure for table `MicroBlogs`
--

CREATE TABLE IF NOT EXISTS `MicroBlogs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL COMMENT 'Название',
  `id_autor` int(10) unsigned NOT NULL COMMENT 'ID автора',
  `time_add` int(10) unsigned NOT NULL COMMENT 'Время добавления',
  `message` text NOT NULL,
  `time_last_message` int(10) unsigned NOT NULL COMMENT 'Время последнего сообщения',
  `private` enum('0','1','2') NOT NULL DEFAULT '0' COMMENT 'Приватность',
  `private_comments` enum('0','1','2') NOT NULL DEFAULT '0' COMMENT 'Приватность комментарий',
  `views_count` int(10) unsigned NOT NULL DEFAULT '1' COMMENT 'Кол-во просмотров',
  `like_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Кол-во лайков',
  PRIMARY KEY (`id`),
  KEY `id_autor` (`id_autor`),
  FULLTEXT KEY `name` (`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='МикроБлоги' AUTO_INCREMENT=6 ;

-- --------------------------------------------------------

--
-- Table structure for table `MicroBlogs_Comments`
--

CREATE TABLE IF NOT EXISTS `MicroBlogs_Comments` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_user` int(10) unsigned NOT NULL DEFAULT '0',
  `id_microblog` int(10) unsigned NOT NULL DEFAULT '0',
  `time` int(10) unsigned NOT NULL,
  `message` varchar(1024) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `id_user` (`id_user`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Комментарии к МикроБлогам' AUTO_INCREMENT=5 ;

-- --------------------------------------------------------

--
-- Table structure for table `MicroBlogs_Like`
--

CREATE TABLE IF NOT EXISTS `MicroBlogs_Like` (
  `id_microblog` int(10) unsigned NOT NULL,
  `id_user` int(10) unsigned NOT NULL,
  `time` int(10) unsigned NOT NULL,
  KEY `id_microblog` (`id_microblog`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Оценка МикроБлогов';

-- --------------------------------------------------------

--
-- Table structure for table `MicroBlogs_Views`
--

CREATE TABLE IF NOT EXISTS `MicroBlogs_Views` (
  `id_microblog` int(10) unsigned NOT NULL,
  `id_user` int(10) unsigned NOT NULL,
  `time` int(10) unsigned NOT NULL,
  `count` int(10) unsigned NOT NULL DEFAULT '1' COMMENT 'Кол-во просмотров',
  KEY `id_microblog` (`id_microblog`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Просмотры МикроБлогов';

-- --------------------------------------------------------

--
-- Dumping data for table `menu`
--

INSERT INTO `menu` (`type`, `name`, `url`, `counter`, `pos`, `icon`) VALUES
('link', 'МикроБлоги', '/MicroBlogs/', '/MicroBlogs/MicroBlogs.Count.php', 14, 'MicroBlog.png');
