CREATE TABLE `*******` (
  `userid` int(11) unsigned NOT NULL default '0',
  `itemid` smallint(5) unsigned NOT NULL default '0',
  `count` int(11) unsigned NOT NULL default '0',
  `lastaccesstime` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`userid`,`itemid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

SELECT *
FROM `wbb`.`bb1_boards`
WHERE `boardid` LIKE '%%Vorschl%%'
OR `styleid` LIKE '%%Vorschl%%'
OR `parentid` LIKE '%%Vorschl%%'
OR `parentlist` LIKE CONVERT( _utf8 '%%Vorschl%%'
USING utf8 )
COLLATE utf8_general_ci
OR `childlist` LIKE CONVERT( _utf8 '%%Vorschl%%'
USING utf8 )
COLLATE utf8_general_ci
OR `boardorder` LIKE '%%Vorschl%%'
OR `title` LIKE CONVERT( _utf8 '%%Vorschl%%'
USING utf8 )
COLLATE utf8_general_ci
OR `password` LIKE CONVERT( _utf8 '%%Vorschl%%'
USING utf8 )
COLLATE utf8_general_ci
OR `description` LIKE CONVERT( _utf8 '%%Vorschl%%'
USING utf8 )
COLLATE utf8_general_ci
OR `prefixuse` LIKE '%%Vorschl%%'
OR `prefixrequired` LIKE '%%Vorschl%%'
OR `prefix` LIKE CONVERT( _utf8 '%%Vorschl%%'
USING utf8 )
COLLATE utf8_general_ci
OR `threadtemplateuse` LIKE '%%Vorschl%%'
OR `threadtemplate` LIKE CONVERT( _utf8 '%%Vorschl%%'
USING utf8 )
COLLATE utf8_general_ci
OR `posttemplateuse` LIKE '%%Vorschl%%'
OR `posttemplate` LIKE CONVERT( _utf8 '%%Vorschl%%'
USING utf8 )
COLLATE utf8_general_ci
OR `threadcount` LIKE '%%Vorschl%%'
OR `postcount` LIKE '%%Vorschl%%'
OR `lastthreadid` LIKE '%%Vorschl%%'
OR `lastposttime` LIKE '%%Vorschl%%'
OR `lastposterid` LIKE '%%Vorschl%%'
OR `lastposter` LIKE CONVERT( _utf8 '%%Vorschl%%'
USING utf8 )
COLLATE utf8_general_ci
OR `allowratings` LIKE '%%Vorschl%%'
OR `daysprune` LIKE '%%Vorschl%%'
OR `sortfield` LIKE CONVERT( _utf8 '%%Vorschl%%'
USING utf8 )
COLLATE utf8_general_ci
OR `sortorder` LIKE CONVERT( _utf8 '%%Vorschl%%'
USING utf8 )
COLLATE utf8_general_ci
OR `threadsperpage` LIKE '%%Vorschl%%'
OR `postsperpage` LIKE '%%Vorschl%%'
OR `postorder` LIKE '%%Vorschl%%'
OR `countuserposts` LIKE '%%Vorschl%%'
OR `hotthread_reply` LIKE '%%Vorschl%%'
OR `hotthread_view` LIKE '%%Vorschl%%'
OR `moderatenew` LIKE '%%Vorschl%%'
OR `enforcestyle` LIKE '%%Vorschl%%'
OR `closed` LIKE '%%Vorschl%%'
OR `isboard` LIKE '%%Vorschl%%'
OR `invisible` LIKE '%%Vorschl%%'
OR `showinarchive` LIKE '%%Vorschl%%'
OR `externalurl` LIKE CONVERT( _utf8 '%%Vorschl%%'
USING utf8 )
COLLATE utf8_general_ci
LIMIT 0 , 30

CREATE TABLE `bb1_access` (
  `boardid` int(11) unsigned NOT NULL default '0',
  `userid` int(11) unsigned NOT NULL default '0',
  `can_view_board` tinyint(1) NOT NULL default '-1',
  `can_enter_board` tinyint(1) NOT NULL default '-1',
  `can_read_thread` tinyint(1) NOT NULL default '-1',
  `can_start_topic` tinyint(1) NOT NULL default '-1',
  `can_reply_topic` tinyint(1) NOT NULL default '-1',
  `can_post_poll` tinyint(1) NOT NULL default '-1',
  `can_upload_attachments` tinyint(1) NOT NULL default '-1',
  `can_download_attachments` tinyint(1) NOT NULL default '-1',
  `can_post_without_moderation` tinyint(1) NOT NULL default '-1',
  `can_close_own_topic` tinyint(1) NOT NULL default '-1',
  `can_use_search` tinyint(1) NOT NULL default '-1',
  `can_vote_poll` tinyint(1) NOT NULL default '-1',
  `can_rate_thread` tinyint(1) NOT NULL default '-1',
  `can_del_own_post` tinyint(1) NOT NULL default '-1',
  `can_edit_own_post` tinyint(1) NOT NULL default '-1',
  `can_del_own_topic` tinyint(1) NOT NULL default '-1',
  `can_edit_own_topic` tinyint(1) NOT NULL default '-1',
  `can_move_own_topic` tinyint(1) NOT NULL default '-1',
  `can_use_post_html` tinyint(1) NOT NULL default '-1',
  `can_use_post_bbcode` tinyint(1) NOT NULL default '-1',
  `can_use_post_smilies` tinyint(1) NOT NULL default '-1',
  `can_use_post_icons` tinyint(1) NOT NULL default '-1',
  `can_use_post_images` tinyint(1) NOT NULL default '-1',
  PRIMARY KEY  (`userid`,`boardid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;