| 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 5428 2011-04-07 15:49:37Z Tomm $
| * $Id$
|
*/
$tables[] = "CREATE TABLE mybb_adminlog (
| */
$tables[] = "CREATE TABLE mybb_adminlog (
|
| Zeile 47 | Zeile 47 |
|---|
title varchar(100) NOT NULL default '',
type varchar(6) NOT NULL default '',
visibility int(1) NOT NULL default '0',
|
title varchar(100) NOT NULL default '',
type varchar(6) NOT NULL default '',
visibility int(1) NOT NULL default '0',
|
fields text NOT NULL,
| `fields` text NOT NULL,
|
conditions text NOT NULL,
custom_profile_fields text NOT NULL,
sortby varchar(20) NOT NULL default '',
| conditions text NOT NULL,
custom_profile_fields text NOT NULL,
sortby varchar(20) NOT NULL default '',
|
| Zeile 426 | 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 460 | 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 541 | 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 884 | 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 914 | 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 997 | 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),
|