phpBB.de - Die deutsche phpBB-Community
https://www.phpbb.de/community/
Code: Alles auswählen
--
-- Create Table `phpbb_forums`
--
DROP TABLE IF EXISTS `phpbb_forums`;
CREATE TABLE `phpbb_forums` (
`forum_id` smallint(5) unsigned NOT NULL default '0',
`cat_id` mediumint(8) unsigned NOT NULL default '0',
`forum_name` varchar(150) default NULL,
`forum_desc` text,
`forum_status` tinyint(4) NOT NULL default '0',
`forum_order` mediumint(8) unsigned NOT NULL default '1',
`forum_posts` mediumint(8) unsigned NOT NULL default '0',
`forum_topics` mediumint(8) unsigned NOT NULL default '0',
`forum_last_post_id` mediumint(8) unsigned NOT NULL default '0',
`forum_notify` tinyint(1) unsigned NOT NULL default '0',
`prune_next` int(11) default NULL,
`prune_enable` tinyint(1) NOT NULL default '0',
`auth_view` tinyint(2) NOT NULL default '0',
`auth_read` tinyint(2) NOT NULL default '0',
`auth_post` tinyint(2) NOT NULL default '0',
`auth_reply` tinyint(2) NOT NULL default '0',
`auth_edit` tinyint(2) NOT NULL default '0',
`auth_delete` tinyint(2) NOT NULL default '0',
`auth_sticky` tinyint(2) NOT NULL default '0',
`auth_announce` tinyint(2) NOT NULL default '0',
`auth_globalannounce` tinyint(2) NOT NULL default '3',
`auth_vote` tinyint(2) NOT NULL default '0',
`auth_pollcreate` tinyint(2) NOT NULL default '0',
`auth_attachments` tinyint(2) NOT NULL default '0',
`forum_color` varchar(6) NOT NULL default '',
`cst` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`forum_id`),
KEY `forums_order` (`forum_order`),
KEY `cat_id` (`cat_id`),
KEY `forum_last_post_id` (`forum_last_post_id`)
) TYPE=MyISAM;
--
-- Data for Table `phpbb_forums`
--
Danke dir trotzdem.