DROP TABLE IF EXISTS `prefix_forum`; 
CREATE TABLE `prefix_forum` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pos` int(11) NOT NULL,
  `name` text COLLATE utf8_unicode_ci NOT NULL,
  `label` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 

-- --------------------------------------------------------
-- 
-- Table structure for table `cms_menu_count`
-- 

DROP TABLE IF EXISTS `cms_menu_count`;
CREATE TABLE `cms_menu_count` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text COLLATE utf8_unicode_ci NOT NULL,
  `code` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------
-- 
-- Table structure for table `cms_menu_group`
-- 

DROP TABLE IF EXISTS `cms_menu_group`;
CREATE TABLE `cms_menu_group` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pos` int(11) NOT NULL,
  `pic` text COLLATE utf8_unicode_ci NOT NULL,
  `name` text COLLATE utf8_unicode_ci NOT NULL,
  `show` int(2) NOT NULL,
  `sumbo` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------
-- 
-- Table structure for table `cms_menu_link`
-- 

DROP TABLE IF EXISTS `cms_menu_link`;
CREATE TABLE `cms_menu_link` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pos` int(11) NOT NULL,
  `pic` text COLLATE utf8_unicode_ci NOT NULL,
  `type` int(11) NOT NULL,
  `show` int(2) NOT NULL,
  `name` text COLLATE utf8_unicode_ci NOT NULL,
  `link` text COLLATE utf8_unicode_ci NOT NULL,
  `group` text COLLATE utf8_unicode_ci NOT NULL,
  `sumbo` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=0 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



DROP TABLE IF EXISTS `bot`;
CREATE TABLE `bot` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` varchar(50) NOT NULL,
  `key` varchar(100) NOT NULL DEFAULT '',
  `text` text NOT NULL,
  `txt1` varchar(500) NOT NULL,
  `txt2` varchar(500) NOT NULL,
  `txt3` varchar(500) NOT NULL,
  `time` int(15) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `forum_thank`;
CREATE TABLE `forum_thank` (
  `id` int(11) NOT NULL auto_increment,
  `user` int(11) NOT NULL default '0',
  `topic` int(11) NOT NULL,
  `userthank` int(11) NOT NULL,
  `chude` int(11) NOT NULL,
  `time` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;


ALTER TABLE `users` ADD `thanked` varchar(500) NOT NULL default '0';
ALTER TABLE `users` ADD `thanks` varchar(500) NOT NULL default '0';
ALTER TABLE `users` ADD `notif_forum` int(11) NOT NULL default 0;
ALTER TABLE `forum` ADD `id_user` int(11) NOT NULL default 0;
ALTER TABLE `users` ADD `premium` int(11) NOT NULL default '0';
ALTER TABLE `forum` ADD `nircable` varchar(100) NOT NULL default '0';
ALTER TABLE `forum` ADD `tags` varchar(500) NOT NULL default '0';
ALTER TABLE `cms_ads` ADD `left` TINYINT(1) NOT NULL DEFAULT '0';
ALTER TABLE `cms_ads` ADD `center` TINYINT(1) NOT NULL DEFAULT '0';
ALTER TABLE `cms_ads` ADD `right` TINYINT(1) NOT NULL DEFAULT '0';


