CREATE TABLE `announce` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `userid` int(11) NOT NULL default '0',
  `added` datetime NOT NULL default '0000-00-00 00:00:00',
  `body` text NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `added` (`added`),
  FULLTEXT KEY `body` (`body`)
) ENGINE=MyISAM AUTO_INCREMENT=25 ;

    ALTER TABLE `users` ADD `shoutban` ENUM('yes', 'no') NOT NULL default 'no';

    ALTER TABLE `users` ADD `uploadpos` ENUM( 'yes', 'no' ) DEFAULT 'yes' NOT NULL;
    ALTER TABLE `users` ADD `forumpost` ENUM( 'yes', 'no' ) DEFAULT 'yes' NOT NULL;
    ALTER TABLE `users` ADD `downloadpos` ENUM( 'yes', 'no' ) DEFAULT 'yes' NOT NULL;

-- 
-- Table structure for table `announce`
-- 

CREATE TABLE `announce` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `userid` int(11) NOT NULL default '0',
  `added` datetime NOT NULL default '0000-00-00 00:00:00',
  `body` text NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `added` (`added`),
  FULLTEXT KEY `body` (`body`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=25 ;

-- 
-- Dumping data for table `announce`
-- 

INSERT INTO `announce` VALUES (24, 1, '2006-03-13 12:46:59', '[color=blue][b]This is just testing the announcement mod,\r\nalso looks as though the bbcode is working proper inside it[/color][/b]');