CREATE TABLE `soo` (
  `id` int(11) NOT NULL auto_increment,
  `id_admin` int(11) NOT NULL,
  `nik_admin` varchar(25) NOT NULL,
  `name` varchar(25) NOT NULL,
  `desc` varchar(50) NOT NULL,
  `description` varchar(500) NOT NULL,
  `dostup` int(1) NOT NULL default '1',
  `time` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE TABLE
 `soo_us` (
  `rid` int(11) NOT NULL,
  `mod` int(1) NOT NULL default '1',
  `uid` int(11) NOT NULL,
  `name` varchar(25) NOT NULL,
  `time` int(11) NOT NULL default '0') ENGINE=MyISAM  DEFAULT CHARSET=utf8;


CREATE TABLE `soo_forum` (
  `id` int(11) NOT NULL auto_increment,
  `refid` int(11) NOT NULL default '0',
  `soo` int(5) NOT NULL default '0',
  `type` char(1) NOT NULL default '',
  `time` int(11) NOT NULL default '0',
  `user_id` int(11) NOT NULL,
  `from` varchar(25) NOT NULL default '',
  `realid` int(3) NOT NULL default '0',
  `text` text NOT NULL,
  `close` tinyint(1) NOT NULL default '0',
  `close_who` varchar(25) NOT NULL,
  `vip` tinyint(1) NOT NULL default '0',
  `edit` text NOT NULL,
  `tedit` int(11) NOT NULL default '0',
  `kedit` int(2) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `refid` (`refid`),
  KEY `type` (`type`),
  KEY `time` (`time`),
  KEY `close` (`close`),
  KEY `user_id` (`user_id`),
  FULLTEXT KEY `text` (`text`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE TABLE `soo_forum_files` (
  `id` int(11) NOT NULL auto_increment,
  `cat` int(11) NOT NULL,
  `subcat` int(11) NOT NULL,
  `topic` int(11) NOT NULL,
  `post` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  `filename` text NOT NULL,
  `filetype` tinyint(4) NOT NULL,
  `dlcount` int(11) NOT NULL,
  `del` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `cat` (`cat`),
  KEY `subcat` (`subcat`),
  KEY `topic` (`topic`),
  KEY `post` (`post`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;