| Zeile 6 | Zeile 6 |
|---|
* Website: http://mybb.com
* License: http://mybb.com/about/license
*
|
* Website: http://mybb.com
* License: http://mybb.com/about/license
*
|
* $Id: mysql_db_tables.php 5440 2011-04-15 10:18:35Z Tomm $
| * $Id$
|
*/
$tables[] = "CREATE TABLE mybb_adminlog (
| */
$tables[] = "CREATE TABLE mybb_adminlog (
|
| Zeile 49 | Zeile 49 |
|---|
visibility int(1) NOT NULL default '0',
`fields` text NOT NULL,
conditions text NOT NULL,
|
visibility int(1) NOT NULL default '0',
`fields` text NOT NULL,
conditions text NOT NULL,
|
| | custom_profile_fields text NOT NULL,
|
sortby varchar(20) NOT NULL default '',
sortorder varchar(4) NOT NULL default '',
perpage int(4) NOT NULL default '0',
| sortby varchar(20) NOT NULL default '',
sortorder varchar(4) NOT NULL default '',
perpage int(4) NOT NULL default '0',
|
| Zeile 425 | Zeile 426 |
|---|
canopenclosethreads int(1) NOT NULL default '0',
canmanagethreads int(1) NOT NULL default '0',
canmovetononmodforum int(1) NOT NULL default '0',
|
canopenclosethreads int(1) NOT NULL default '0',
canmanagethreads int(1) NOT NULL default '0',
canmovetononmodforum int(1) NOT NULL default '0',
|
| | canusecustomtools int(1) NOT NULL default '0',
|
KEY uid (id, fid),
PRIMARY KEY (mid)
) ENGINE=MyISAM;";
| KEY uid (id, fid),
PRIMARY KEY (mid)
) ENGINE=MyISAM;";
|
| Zeile 459 | Zeile 461 |
|---|
options text NOT NULL,
votes text NOT NULL,
numoptions smallint unsigned NOT NULL default '0',
|
options text NOT NULL,
votes text NOT NULL,
numoptions smallint unsigned NOT NULL default '0',
|
numvotes smallint unsigned NOT NULL default '0',
| numvotes text NOT NULL,
|
timeout bigint(30) NOT NULL default '0',
closed int(1) NOT NULL default '0',
multiple int(1) NOT NULL default '0',
| timeout bigint(30) NOT NULL default '0',
closed int(1) NOT NULL default '0',
multiple int(1) NOT NULL default '0',
|
| Zeile 540 | Zeile 542 |
|---|
required int(1) NOT NULL default '0',
editable int(1) NOT NULL default '0',
hidden int(1) NOT NULL default '0',
|
required int(1) NOT NULL default '0',
editable int(1) NOT NULL default '0',
hidden int(1) NOT NULL default '0',
|
| | postnum bigint(30) NOT NULL default '0',
|
PRIMARY KEY (fid)
) ENGINE=MyISAM;";
| PRIMARY KEY (fid)
) ENGINE=MyISAM;";
|
| Zeile 883 | Zeile 886 |
|---|
pmquota int(3) NOT NULL default '0',
maxpmrecipients int(4) NOT NULL default '5',
cansendemail int(1) NOT NULL default '0',
|
pmquota int(3) NOT NULL default '0',
maxpmrecipients int(4) NOT NULL default '5',
cansendemail int(1) NOT NULL default '0',
|
| | cansendemailoverride int(1) NOT NULL default '0',
|
maxemails int(3) NOT NULL default '5',
canviewmemberlist int(1) NOT NULL default '0',
canviewcalendar int(1) NOT NULL default '0',
| maxemails int(3) NOT NULL default '5',
canviewmemberlist int(1) NOT NULL default '0',
canviewcalendar int(1) NOT NULL default '0',
|
| Zeile 913 | Zeile 917 |
|---|
canreceivewarnings int(1) NOT NULL default '0',
maxwarningsday int(3) NOT NULL default '3',
canmodcp int(1) NOT NULL default '0',
|
canreceivewarnings int(1) NOT NULL default '0',
maxwarningsday int(3) NOT NULL default '3',
canmodcp int(1) NOT NULL default '0',
|
| | showinbirthdaylist int(1) NOT NULL default '0',
canoverridepm int(1) NOT NULL default '0',
canusesig int(1) NOT NULL default '0',
canusesigxposts bigint(30) NOT NULL default '0',
signofollow int(1) NOT NULL default '0',
|
PRIMARY KEY (gid)
) ENGINE=MyISAM;";
| PRIMARY KEY (gid)
) ENGINE=MyISAM;";
|
| Zeile 996 | Zeile 1005 |
|---|
coppauser int(1) NOT NULL default '0',
classicpostbit int(1) NOT NULL default '0',
loginattempts tinyint(2) NOT NULL default '1',
|
coppauser int(1) NOT NULL default '0',
classicpostbit int(1) NOT NULL default '0',
loginattempts tinyint(2) NOT NULL default '1',
|
failedlogin bigint(30) NOT NULL default '0',
| |
usernotes text NOT NULL,
UNIQUE KEY username (username),
KEY usergroup (usergroup),
| usernotes text NOT NULL,
UNIQUE KEY username (username),
KEY usergroup (usergroup),
|