<dleplugin>
<name>Dle-Forum</name>
<description>DLE Forum configuration</description>
<icon>engine/skins/images/dle_forum.png</icon>
<version>2.7.2</version>
<dleversion>13.3</dleversion>
<versioncompare>greater</versioncompare>
<upgradeurl/>
<filedelete>0</filedelete>
<needplugin/>
<mnotice>0</mnotice>
<mysqlinstall>
<![CDATA[ CREATE TABLE {prefix}_forum_forums ( `id` int(11) NOT NULL AUTO_INCREMENT, `parentid` int(11) NOT NULL default '0', `is_category` TINYINT(1) NOT NULL default '0', `alt_name` varchar(50) NOT NULL default '', `topics` mediumint(6) NOT NULL default '0', `posts` mediumint(6 ]]>
<![CDATA[ ) NOT NULL default '0', `name` varchar(128) NOT NULL default '', `description` text NOT NULL, `position` tinyint(3) NOT NULL default '0', `status` tinyint(1) NOT NULL default '1', `access_read` varchar(150) NOT NULL default '', `access_write` varchar(150) NOT NULL default '', `access_mod` varchar(150) NOT NULL default '', `access_topic` varchar(150) NOT NULL default '', `access_upload` varchar(150) NOT NULL default '', `access_download` varchar(150) NOT NULL default '', `f_last_tid` smallint(5) NOT NULL default '0', `f_last_title` varchar(70) NOT NULL default '', `f_last_date` datetime NOT NULL default '0000-00-00 00:00:00', `f_last_poster_name` varchar(40) NOT NULL default '', `password` varchar(32) NOT NULL default '', `rules_title` varchar(128) NOT NULL default '', `rules` text NOT NULL, `icon` varchar(40) NOT NULL default '', `moderators` varchar(150) NOT NULL default '', `postcount` tinyint(1) NOT NULL default '1', `fixpost` tinyint(1) NOT NULL default '0', `last_post_id` int(11) NOT NULL default '0', `banner` text NOT NULL, `q_reply` tinyint(1) NOT NULL default '1', `i_edit` tinyint(1) NOT NULL default '0', `redirect` varchar(250) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE={engine} DEFAULT CHARSET={charset}; CREATE TABLE {prefix}_forum_topics ( `tid` int(11) NOT NULL AUTO_INCREMENT, `forum_id` int(11) NOT NULL default '0', `alt_name` varchar(200) NOT NULL default '', `title` varchar(70) NOT NULL default '', `topic_descr` varchar(70) NOT NULL default '', `icon` varchar(20) default '0', `post` int(11) NOT NULL default '0', `views` int(11) NOT NULL default '0', `author_topic` varchar(40) NOT NULL default '', `start_date` datetime NOT NULL default '0000-00-00 00:00:00', `last_date` datetime NOT NULL default '0000-00-00 00:00:00', `last_poster_name` varchar(40) NOT NULL default '', `topic_status` int(1) NOT NULL default '0', `hidden` int(1) NOT NULL default '0', `fixed` int(1) NOT NULL default '1', `poll_title` varchar(200) NOT NULL default '', `frage` varchar(200) NOT NULL default '', `poll_body` text NOT NULL, `poll_count` mediumint(8) NOT NULL default '0', `answer` varchar(150) NOT NULL default '', `multiple` tinyint(1) NOT NULL default '0', `meta_descr` varchar(200) default NULL, `meta_keywords` text, `first_post` int(11) NOT NULL default '0', `last_post_id` int(11) NOT NULL default '0', PRIMARY KEY (`tid`) ) ENGINE={engine} DEFAULT CHARSET={charset}; CREATE TABLE {prefix}_forum_posts ( `pid` int(11) NOT NULL AUTO_INCREMENT, `topic_id` int(11) NOT NULL default '0', `post_date` datetime NOT NULL default '0000-00-00 00:00:00', `post_author` varchar(40) NOT NULL default '', `post_text` text NOT NULL, `post_ip` varchar(16) NOT NULL default '', `is_register` tinyint(1) NOT NULL default '0', `e_mail` varchar(40) NOT NULL default '', `edit_user` varchar(40) NOT NULL default '0', `edit_time` int(10) NOT NULL default '0', `hidden` tinyint(1) NOT NULL default '0', `wysiwyg` tinyint(1) default '0', `is_count` tinyint(1) NOT NULL default '1', PRIMARY KEY (`pid`) ) ENGINE={engine} DEFAULT CHARSET={charset}; CREATE TABLE {prefix}_forum_email ( `id` int(11) NOT NULL default '0', `name` varchar(40) NOT NULL default '', `template` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE={engine} DEFAULT CHARSET={charset}; CREATE TABLE {prefix}_forum_files ( `file_id` int(11) NOT NULL AUTO_INCREMENT, `file_type` varchar(10) NOT NULL default '', `forum_id` int(11) NOT NULL default '0', `topic_id` int(11) NOT NULL default '0', `post_id` int(11) NOT NULL default '0', `file_attach` tinyint(1) NOT NULL default '0', `file_name` varchar(250) NOT NULL default '', `onserver` varchar(250) NOT NULL default '', `file_author` varchar(40) NOT NULL default '', `file_date` int(10) NOT NULL default '0', `file_size` int(11) NOT NULL default '0', `dcount` int(11) NOT NULL default '0', PRIMARY KEY (`file_id`) ) ENGINE={engine} DEFAULT CHARSET={charset}; CREATE TABLE {prefix}_forum_groups ( `group_id` int(11) NOT NULL default '0', `group_colour` varchar(40) NOT NULL default '', `offline` tinyint(1) NOT NULL default '0', `post_edit` tinyint(1) NOT NULL default '0', `post_del` tinyint(1) NOT NULL default '0', `topic_set` tinyint(1) NOT NULL default '0', `topic_edit` tinyint(1) NOT NULL default '0', `topic_del` tinyint(1) NOT NULL default '0', `vote` tinyint(1) NOT NULL default '0', `flood` char(1) NOT NULL default '0', `html` tinyint(1) NOT NULL default '0', `filter` tinyint(1) NOT NULL default '0', `youtube` tinyint(1) NOT NULL default '0', `flash` tinyint(1) NOT NULL default '0', KEY `group_id` (`group_id`) ) ENGINE={engine} DEFAULT CHARSET={charset}; CREATE TABLE {prefix}_forum_poll_log ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `topic_id` int(10) unsigned NOT NULL default '0', `member` varchar(30) NOT NULL default '', PRIMARY KEY (`id`), KEY `news_id` (`topic_id`,`member`) ) ENGINE={engine} DEFAULT CHARSET={charset}; CREATE TABLE {prefix}_forum_reputation_log ( `rid` int(11) NOT NULL AUTO_INCREMENT, `mid` varchar(8) NOT NULL default '0', `author` varchar(40) NOT NULL, `action` char(1) NOT NULL, `cause` text NOT NULL, `date` int(10) NOT NULL default '0', PRIMARY KEY (`rid`) ) ENGINE={engine} DEFAULT CHARSET={charset}; CREATE TABLE {prefix}_forum_sessions ( `id` varchar(60) NOT NULL default '0', `member_name` varchar(64) NOT NULL default '', `user_group` int(11) NOT NULL default '5', `member_id` mediumint(8) NOT NULL default '0', `ip` varchar(16) NOT NULL default '', `browser` varchar(200) NOT NULL default '', `running_time` int(10) NOT NULL default '0', `location` varchar(40) NOT NULL default '', `act_index` int(10) NOT NULL default '0', `act_forum` int(10) NOT NULL default '0', `act_topic` int(10) NOT NULL default '0', PRIMARY KEY (`id`), KEY `act_topic` (`act_topic`), KEY `act_forum` (`act_forum`), KEY `act_index` (`act_index`), KEY `running_time` (`running_time`) ) ENGINE={engine} DEFAULT CHARSET={charset}; CREATE TABLE {prefix}_forum_subscription ( `sid` int(11) NOT NULL AUTO_INCREMENT, `user_id` mediumint(8) NOT NULL default '0', `topic_id` int(10) NOT NULL default '0', PRIMARY KEY (`sid`) ) ENGINE={engine} DEFAULT CHARSET={charset}; CREATE TABLE {prefix}_forum_titles ( `id` int(11) NOT NULL AUTO_INCREMENT, `posts` int(11) NOT NULL default '0', `title` varchar(128) NOT NULL default '', `pips` varchar(128) NOT NULL default '', KEY `id` (`id`) ) ENGINE={engine} DEFAULT CHARSET={charset}; CREATE TABLE {prefix}_forum_views ( `topic_id` int(11) NOT NULL default '0', `forum_id` int(11) NOT NULL default '0', `user_id` mediumint(8) NOT NULL default '0', `time` int(11) default NULL ) ENGINE={engine} DEFAULT CHARSET={charset}; CREATE TABLE {prefix}_forum_warn_log ( `wid` int(11) NOT NULL AUTO_INCREMENT, `mid` varchar(8) NOT NULL default '0', `author` varchar(40) NOT NULL, `action` char(1) NOT NULL, `cause` text NOT NULL, `date` int(10) NOT NULL default '0', PRIMARY KEY (`wid`) ) ENGINE={engine} DEFAULT CHARSET={charset}; CREATE TABLE {prefix}_forum_moderators ( `mid` mediumint(8) NOT NULL AUTO_INCREMENT, `forum_id` int(11) NOT NULL default '0', `member_name` varchar(32) NOT NULL default '', `member_id` mediumint(8) NOT NULL default '0', `edit_post` tinyint(1) default NULL, `edit_topic` tinyint(1) default NULL, `delete_post` tinyint(1) default NULL, `delete_topic` tinyint(1) default NULL, `open_topic` tinyint(1) default NULL, `close_topic` tinyint(1) default NULL, `mass_prune` tinyint(1) default NULL, `move_topic` tinyint(1) default NULL, `pin_topic` tinyint(1) default NULL, `unpin_topic` tinyint(1) default NULL, `allow_warn` tinyint(1) default NULL, `is_group` tinyint(1) default '0', `group_id` smallint(3) default NULL, `combining_post` tinyint(1) default NULL, `move_post` tinyint(1) default NULL, `banned` tinyint(1) default NULL, `read_mode` tinyint(1) default NULL, PRIMARY KEY (`mid`), KEY `forum_id` (`forum_id`), KEY `group_id` (`group_id`), KEY `member_id` (`member_id`) ) ENGINE={engine} DEFAULT CHARSET={charset}; CREATE TABLE {prefix}_forum_faq ( `id` int(10) NOT NULL AUTO_INCREMENT, `type` set('categ','item') NOT NULL DEFAULT 'item', `question` text NOT NULL, `answer` text NOT NULL, `flag` set('0','1','2','3') NOT NULL DEFAULT '1', `categ` int(10) NOT NULL DEFAULT '0', `order` int(10) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE={engine} DEFAULT CHARSET={charset}; ALTER TABLE {prefix}_forum_topics ADD FULLTEXT title_fulltext_search (title); ALTER TABLE {prefix}_forum_posts ADD FULLTEXT post_text_fulltext_search (post_text); ALTER TABLE {prefix}_forum_posts ADD poster_id INT(11) NOT NULL DEFAULT '0' AFTER post_author; INSERT INTO {prefix}_forum_groups VALUES (1, 'red', 1, 1, 1, 1, 1, 1, 1, '0', 0, 0, 1, 1); INSERT INTO {prefix}_forum_groups VALUES (2, 'blue', 0, 1, 1, 1, 1, 1, 1, '0', 0, 0, 0, 0); INSERT INTO {prefix}_forum_groups VALUES (3, '', 0, 1, 1, 1, 0, 0, 1, '1', 0, 1, 0, 0); INSERT INTO {prefix}_forum_groups VALUES (4, '', 0, 1, 1, 0, 0, 0, 1, '1', 0, 1, 0, 0); INSERT INTO {prefix}_forum_groups VALUES (5, '', 0, 0, 0, 0, 0, 0, 0, '0', 0, 0, 0, 0); INSERT INTO {prefix}_forum_moderators VALUES (1, 0, '', 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 1, 1); INSERT INTO {prefix}_forum_moderators VALUES (2, 0, '', 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 2, 0, 0, 0, 0); INSERT INTO {prefix}_forum_moderators VALUES (3, 0, '', 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 1, 0, 3, 0, 0, 0, 0); INSERT INTO {prefix}_forum_moderators VALUES (4, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4, 0, 0, 0, 0); INSERT INTO {prefix}_forum_moderators VALUES (5, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5, 0, 0, 0, 0); ALTER TABLE {prefix}_users ADD `forum_post` SMALLINT( 5 ) DEFAULT '0' NOT NULL; ALTER TABLE {prefix}_users ADD `forum_warn` SMALLINT( 5 ) DEFAULT '0' NOT NULL; ALTER TABLE {prefix}_users ADD `forum_update` VARCHAR( 20 ) DEFAULT '0' NOT NULL; ALTER TABLE {prefix}_users ADD `forum_rank` VARCHAR( 40 ) DEFAULT '0' NOT NULL; ALTER TABLE {prefix}_users ADD `forum_pips` SMALLINT( 2 ) DEFAULT '0' NOT NULL; ALTER TABLE {prefix}_users ADD `forum_reputation` SMALLINT( 5 ) DEFAULT '0' NOT NULL; ALTER TABLE {prefix}_users ADD `forum_last` VARCHAR( 20 ) DEFAULT '0' NOT NULL; ALTER TABLE {prefix}_users ADD `forum_time` VARCHAR( 20 ) DEFAULT '0' NOT NULL; ALTER TABLE {prefix}_users ADD `forum_read` VARCHAR( 20 ) NOT NULL; ALTER TABLE {prefix}_post ADD `news_tid` SMALLINT( 5 ) DEFAULT '0' NOT NULL; ALTER TABLE {prefix}_category ADD `forum_id` SMALLINT( 5 ) DEFAULT '0' NOT NULL; ]]>
</mysqlinstall>
</dleplugin>