phpBB.de

Code: Alles auswählen

-- Change the prefix if required!
--

ALTER TABLE `phpbb_forums` ADD `forum_auto_answer` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '1' AFTER `forum_status` ;
	
--
-- Change the prefix if required!
--

CREATE TABLE IF NOT EXISTS `phpbb_auto_a_config` (
  `config_id` tinyint(1) unsigned NOT NULL auto_increment,
  `enable` tinyint(3) unsigned NOT NULL default '0',
  `user_id` mediumint(8) unsigned NOT NULL default '2',
  `guests` tinyint(1) unsigned NOT NULL default '1',
  `multi_words` tinyint(1) unsigned NOT NULL default '0',
  `answer_edited` tinyint(1) unsigned NOT NULL default '0',
  `post_locked` tinyint(1) unsigned NOT NULL default '1',
  `post_normal` tinyint(1) unsigned NOT NULL default '1',
  `post_sticky` tinyint(1) unsigned NOT NULL default '1',
  `post_announce` tinyint(1) unsigned NOT NULL default '1',
  `post_global` tinyint(1) unsigned NOT NULL default '1',
  `no_answer` tinyint(1) unsigned NOT NULL default '0',
  `no_answer_word` varchar(255) default NULL,
  PRIMARY KEY  (`config_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Change the prefix if required!
--

INSERT INTO `phpbb_auto_a_config` (`config_id`, `enable`, `user_id`, `guests`, `multi_words`, `answer_edited`, `post_locked`, `post_normal`, `post_sticky`, `post_announce`, `post_global`, `no_answer`, `no_answer_word`) VALUES
(1, 1, 2, 1, 3, 0, 1, 1, 1, 1, 1, 0, 'nobot');

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

--
-- Change the prefix if required!
--

CREATE TABLE IF NOT EXISTS `phpbb_auto_a_msgs` (
  `post_id` mediumint(8) unsigned NOT NULL auto_increment,
  `icon_id` mediumint(8) unsigned NOT NULL default '0',
  `enable_bbcode` tinyint(1) unsigned NOT NULL default '1',
  `enable_smilies` tinyint(1) unsigned NOT NULL default '1',
  `enable_magic_url` tinyint(1) unsigned NOT NULL default '1',
  `enable_sig` tinyint(1) unsigned NOT NULL default '1',
  `post_subject` varchar(100) character set utf8 collate utf8_unicode_ci NOT NULL,
  `post_text` mediumtext character set utf8 collate utf8_bin NOT NULL,
  `bbcode_uid` varchar(8) character set utf8 collate utf8_bin NOT NULL,
  `bbcode_bitfield` varchar(255) character set utf8 collate utf8_bin NOT NULL,
  `write_as` tinyint(1) unsigned NOT NULL default '1',
  `post_edit_locked` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`post_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Change the prefix if required!
--

CREATE TABLE IF NOT EXISTS `phpbb_auto_a_words` (
  `post_id` mediumint(8) unsigned NOT NULL,
  `word_text` varchar(255) NOT NULL,
  `word_type` tinyint(1) unsigned NOT NULL default '0',
  `word_match` tinyint(1) unsigned NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Code: Alles auswählen

-- Change the prefix if required!
--