DROP TABLE IF EXISTS phpbb_extensions_bbcode;
CREATE TABLE phpbb_extensions_bbcode (
  extension_id mediumint(8) unsigned NOT NULL auto_increment,
  group_id mediumint(8) unsigned NOT NULL default '0',
  extension varchar(100) collate utf8_bin NOT NULL default '',
  group_name varchar(255) collate utf8_bin NOT NULL,
  bbcode_id mediumint(8) NOT NULL,
  PRIMARY KEY  (extension_id)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- --------------------------------------------------------

--
-- Table structure for table 'phpbb_extension_bbcode_groups'
--

DROP TABLE IF EXISTS phpbb_extension_bbcode_groups;
CREATE TABLE phpbb_extension_bbcode_groups (
  group_id mediumint(8) unsigned NOT NULL auto_increment,
  group_name varchar(255) collate utf8_bin NOT NULL default '',
  allow_group tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (group_id)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin;