DROP TABLE IF EXISTS `h2ht8_community_files`;

CREATE TABLE `h2ht8_community_files` (
`id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `groupid` int(11) NOT NULL,
  `discussionid` int(11) NOT NULL,
  `bulletinid` int(11) NOT NULL,
  `eventid` int(11) NOT NULL,
  `profileid` int(11) NOT NULL,
  `messageid` int(11) NOT NULL,
  `filepath` varchar(255) NOT NULL,
  `filesize` int(11) NOT NULL,
  `hits` int(11) NOT NULL,
  `storage` varchar(64) NOT NULL,
  `creator` int(11) NOT NULL,
  `created` datetime NOT NULL,
  `type` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

ALTER TABLE `h2ht8_community_files`
 ADD PRIMARY KEY (`id`), ADD KEY `discussionid` (`discussionid`), ADD KEY `groupid` (`groupid`), ADD KEY `creator` (`creator`), ADD KEY `bulletinid` (`bulletinid`);

ALTER TABLE `h2ht8_community_files`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;