1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
|
--
-- Tabellenstruktur für Tabelle `bb1_groups`
--
CREATE TABLE `bb1_groups` (
`groupid` int(11) unsigned NOT NULL auto_increment,
`title` varchar(30) NOT NULL default '',
`canviewboard` tinyint(1) NOT NULL default '0',
`canviewoffboard` tinyint(1) NOT NULL default '0',
`canusesearch` tinyint(1) NOT NULL default '0',
`canusepms` tinyint(1) NOT NULL default '0',
`canstarttopic` tinyint(1) NOT NULL default '0',
`canreplyowntopic` tinyint(1) NOT NULL default '0',
`canreplytopic` tinyint(1) NOT NULL default '0',
`canpostwithoutmoderation` tinyint(1) NOT NULL default '0',
`caneditownpost` tinyint(1) NOT NULL default '0',
`candelownpost` tinyint(1) NOT NULL default '0',
`cancloseowntopic` tinyint(1) NOT NULL default '0',
`candelowntopic` tinyint(1) NOT NULL default '0',
`caneditowntopic` tinyint(1) NOT NULL default '0',
`canpostpoll` tinyint(1) NOT NULL default '0',
`canvotepoll` tinyint(1) NOT NULL default '0',
`canuseavatar` tinyint(1) NOT NULL default '0',
`canuploadavatar` tinyint(1) NOT NULL default '0',
`canuploadattachments` tinyint(1) NOT NULL default '0',
`candownloadattachments` tinyint(1) NOT NULL default '0',
`canratethread` tinyint(1) NOT NULL default '0',
`canviewmblist` tinyint(1) NOT NULL default '0',
`canviewprofile` tinyint(1) NOT NULL default '0',
`canviewcalender` tinyint(1) NOT NULL default '0',
`canprivateevent` tinyint(1) NOT NULL default '0',
`canpublicevent` tinyint(1) NOT NULL default '0',
`canrateusers` tinyint(1) NOT NULL default '0',
`appendeditnote` tinyint(1) NOT NULL default '0',
`avoidfc` tinyint(1) NOT NULL default '0',
`ismod` tinyint(1) NOT NULL default '0',
`issupermod` tinyint(1) NOT NULL default '0',
`canuseacp` tinyint(1) NOT NULL default '0',
`maxpostimage` smallint(5) NOT NULL default '0',
`maxsigimage` smallint(5) NOT NULL default '0',
`maxsiglength` smallint(5) unsigned NOT NULL default '0',
`allowedavatarextensions` text NOT NULL,
`maxavatarwidth` smallint(5) unsigned NOT NULL default '0',
`maxavatarheight` smallint(5) unsigned NOT NULL default '0',
`maxavatarsize` mediumint(7) unsigned NOT NULL default '0',
`allowedattachmentextensions` text NOT NULL,
`maxattachmentsize` int(11) unsigned NOT NULL default '0',
`maxusertextlength` smallint(5) unsigned NOT NULL default '0',
`default_group` tinyint(1) NOT NULL default '0',
`canusesbox` tinyint(1) NOT NULL default '1',
`canseesbox` tinyint(1) NOT NULL default '1',
`canviewwiw` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`groupid`),
KEY `default_group` (`default_group`)
) TYPE=MyISAM AUTO_INCREMENT=9 AUTO_INCREMENT=9 ;
--
-- Daten für Tabelle `bb1_groups`
--
INSERT INTO `bb1_groups` VALUES (1, 'Administratoren', 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 1, 0, 1, 1, -1, -1, 1000, 'gif\njpg\njpeg', 100, 250, 10000, 'gif\njpg\njpeg\npng\nbmp\nzip\ntxt', 20480, 1000, 0, 1, 1, 1);
INSERT INTO `bb1_groups` VALUES (2, 'Super Moderatoren', 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 1, 1, 0, 1, 0, -1, -1, 500, 'gif\njpg\njpeg\npng', 100, 110, 10000, 'gif\njpg\njpeg\npng\nbmp\nzip\ntxt', 204800, 3000, 0, 1, 1, 1);
INSERT INTO `bb1_groups` VALUES (3, 'Moderatoren', 1, 0, 1, 1, 1, 1, 1, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 1, 0, 1, 0, 0, -1, -1, 500, 'gif\njpg\njpeg\npng', 100, 100, 10000, 'gif\njpg\njpeg\npng\nbmp\nzip\ntxt', 20480, 1000, 0, 1, 1, 1);
INSERT INTO `bb1_groups` VALUES (4, 'User', 1, 0, 1, 1, 1, 1, 1, 0, 1, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, -1, 1, 250, 'gif\njpg\njpeg', 100, 100, 10000, 'gif\njpg\njpeg\npng\nbmp\nzip\ntxt', 20480, 250, 2, 1, 1, 0);
INSERT INTO `bb1_groups` VALUES (5, 'Gäste', 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, '', 0, 0, 1, 0, 1, 0);
INSERT INTO `bb1_groups` VALUES (6, 'SAMPer', 1, 0, 1, 1, 1, 1, 1, 0, 1, 0, 0, 0, 1, 1, 1, 1, 1, 0, 0, 1, 1, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, -1, 2, 500, 'jpg\njpeg\npng', 100, 100, 10000, '', 0, 1000, 0, 1, 1, 0);
INSERT INTO `bb1_groups` VALUES (7, 'Verwarnt', 1, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 2, 500, 'jpg\njpeg\npng', 100, 100, 10000, '', 0, 3000, 0, 1, 1, 0);
|
