| Zeile 6 | Zeile 6 |
|---|
* Website: http://www.mybboard.net
* License: http://www.mybboard.net/about/license
*
|
* Website: http://www.mybboard.net
* License: http://www.mybboard.net/about/license
*
|
* $Id: mysql_db_tables.php 3981 2008-07-04 21:24:03Z Tikitiki $
| * $Id: mysql_db_tables.php 4322 2009-02-21 23:00:49Z Tikitiki $
|
*/
$tables[] = "CREATE TABLE mybb_adminlog (
| */
$tables[] = "CREATE TABLE mybb_adminlog (
|
| Zeile 22 | Zeile 22 |
|---|
$tables[] = "CREATE TABLE mybb_adminoptions (
uid int(10) NOT NULL default '0',
cpstyle varchar(50) NOT NULL default '',
|
$tables[] = "CREATE TABLE mybb_adminoptions (
uid int(10) NOT NULL default '0',
cpstyle varchar(50) NOT NULL default '',
|
| | codepress int(1) NOT NULL default '1',
|
notes text NOT NULL,
permissions text NOT NULL,
defaultviews text NOT NULL,
| notes text NOT NULL,
permissions text NOT NULL,
defaultviews text NOT NULL,
|
| Zeile 188 | Zeile 189 |
|---|
dateline int(10) unsigned NOT NULL default '0',
starttime int(10) unsigned NOT NULL default '0',
endtime int(10) unsigned NOT NULL default '0',
|
dateline int(10) unsigned NOT NULL default '0',
starttime int(10) unsigned NOT NULL default '0',
endtime int(10) unsigned NOT NULL default '0',
|
timezone int(3) NOT NULL default '0',
| timezone varchar(4) NOT NULL default '0',
|
ignoretimezone int(1) NOT NULL default '0',
usingtime int(1) NOT NULL default '0',
repeats text NOT NULL,
| ignoretimezone int(1) NOT NULL default '0',
usingtime int(1) NOT NULL default '0',
repeats text NOT NULL,
|
| Zeile 470 | Zeile 471 |
|---|
dateline bigint(30) NOT NULL default '0',
message text NOT NULL,
ipaddress varchar(30) NOT NULL default '',
|
dateline bigint(30) NOT NULL default '0',
message text NOT NULL,
ipaddress varchar(30) NOT NULL default '',
|
longipaddress int(10) NOT NULL default '0',
| longipaddress int(11) NOT NULL default '0',
|
includesig int(1) NOT NULL default '0',
smilieoff int(1) NOT NULL default '0',
edituid int unsigned NOT NULL default '0',
| includesig int(1) NOT NULL default '0',
smilieoff int(1) NOT NULL default '0',
edituid int unsigned NOT NULL default '0',
|
| Zeile 481 | Zeile 482 |
|---|
KEY uid (uid),
KEY visible (visible),
KEY dateline (dateline),
|
KEY uid (uid),
KEY visible (visible),
KEY dateline (dateline),
|
| | KEY longipaddress (longipaddress),
|
PRIMARY KEY (pid)
) TYPE=MyISAM;";
| PRIMARY KEY (pid)
) TYPE=MyISAM;";
|
| Zeile 603 | Zeile 605 |
|---|
nopermission int(1) NOT NULL default '0',
location1 int(10) NOT NULL default '0',
location2 int(10) NOT NULL default '0',
|
nopermission int(1) NOT NULL default '0',
location1 int(10) NOT NULL default '0',
location2 int(10) NOT NULL default '0',
|
loginattempts tinyint(2) NOT NULL default '1',
failedlogin bigint(30) NOT NULL default '0',
| |
PRIMARY KEY(sid),
KEY location1 (location1),
KEY location2 (location2),
KEY time (time),
|
PRIMARY KEY(sid),
KEY location1 (location1),
KEY location2 (location2),
KEY time (time),
|
KEY uid (uid)
| KEY uid (uid),
KEY ip (ip)
|
) TYPE=MyISAM;";
$tables[] = "CREATE TABLE mybb_settinggroups (
| ) TYPE=MyISAM;";
$tables[] = "CREATE TABLE mybb_settinggroups (
|
| Zeile 690 | Zeile 691 |
|---|
dateline bigint(30) NOT NULL default '0',
data text NOT NULL,
PRIMARY KEY (lid)
|
dateline bigint(30) NOT NULL default '0',
data text NOT NULL,
PRIMARY KEY (lid)
|
) TYPE=MyISAM;";
| ) TYPE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_templategroups (
gid int unsigned NOT NULL auto_increment,
prefix varchar(50) NOT NULL default '',
| $tables[] = "CREATE TABLE mybb_templategroups (
gid int unsigned NOT NULL auto_increment,
prefix varchar(50) NOT NULL default '',
|
| Zeile 941 | Zeile 942 |
|---|
reputation bigint(30) NOT NULL default '0',
regip varchar(50) NOT NULL default '',
lastip varchar(50) NOT NULL default '',
|
reputation bigint(30) NOT NULL default '0',
regip varchar(50) NOT NULL default '',
lastip varchar(50) NOT NULL default '',
|
longregip int(10) NOT NULL default '0',
longlastip int(10) NOT NULL default '0',
| longregip int(11) NOT NULL default '0',
longlastip int(11) NOT NULL default '0',
|
language varchar(50) NOT NULL default '',
timeonline bigint(30) NOT NULL default '0',
showcodebuttons int(1) NOT NULL default '1',
| language varchar(50) NOT NULL default '',
timeonline bigint(30) NOT NULL default '0',
showcodebuttons int(1) NOT NULL default '1',
|
| Zeile 955 | Zeile 956 |
|---|
suspensiontime bigint(30) NOT NULL default '0',
coppauser int(1) NOT NULL default '0',
classicpostbit int(1) NOT NULL default '0',
|
suspensiontime bigint(30) NOT NULL default '0',
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',
|
UNIQUE KEY username (username),
KEY usergroup (usergroup),
KEY birthday (birthday),
|
UNIQUE KEY username (username),
KEY usergroup (usergroup),
KEY birthday (birthday),
|
| | KEY longregip (longregip),
KEY longlastip (longlastip),
|
PRIMARY KEY (uid)
) TYPE=MyISAM;";
| PRIMARY KEY (uid)
) TYPE=MyISAM;";
|