Kann mir jemand sagen, was ich hier als SQL Befehl nutzen muss ?
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;
