| 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 4224 2008-10-05 11:17:04Z 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 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),
| PRIMARY KEY(sid),
KEY location1 (location1),
KEY location2 (location2),
|
| Zeile 624 | Zeile 624 |
|---|
$tables[] = "CREATE TABLE mybb_settings (
|
$tables[] = "CREATE TABLE mybb_settings (
|
sid smallint unsigned NOT NULL auto_increment,
| sid smallint unsigned NOT NULL auto_increment,
|
name varchar(120) NOT NULL default '',
title varchar(120) NOT NULL default '',
description text NOT NULL,
| name varchar(120) NOT NULL default '',
title varchar(120) NOT NULL default '',
description text NOT NULL,
|
| Zeile 634 | Zeile 634 |
|---|
gid smallint unsigned NOT NULL default '0',
isdefault int(1) NOT NULL default '0',
PRIMARY KEY (sid)
|
gid smallint unsigned NOT NULL default '0',
isdefault int(1) NOT NULL default '0',
PRIMARY KEY (sid)
|
) TYPE=MyISAM;";
| ) TYPE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_smilies (
|
$tables[] = "CREATE TABLE mybb_smilies (
|
| Zeile 644 | Zeile 644 |
|---|
image varchar(220) NOT NULL default '',
disporder smallint unsigned NOT NULL default '0',
showclickable int(1) NOT NULL default '0',
|
image varchar(220) NOT NULL default '',
disporder smallint unsigned NOT NULL default '0',
showclickable int(1) NOT NULL default '0',
|
PRIMARY KEY (sid)
) TYPE=MyISAM;";
| PRIMARY KEY (sid)
) TYPE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_spiders (
sid int unsigned NOT NULL auto_increment,
name varchar(100) NOT NULL default '',
| $tables[] = "CREATE TABLE mybb_spiders (
sid int unsigned NOT NULL auto_increment,
name varchar(100) NOT NULL default '',
|
| Zeile 656 | Zeile 656 |
|---|
useragent varchar(200) NOT NULL default '',
lastvisit bigint(30) NOT NULL default '0',
PRIMARY KEY (sid)
|
useragent varchar(200) NOT NULL default '',
lastvisit bigint(30) NOT NULL default '0',
PRIMARY KEY (sid)
|
) TYPE=MyISAM;";
| ) TYPE=MyISAM;";
|
$tables[] = "CREATE TABLE mybb_stats (
dateline bigint(30) NOT NULL default '0',
numusers int unsigned NOT NULL default '0',
| $tables[] = "CREATE TABLE mybb_stats (
dateline bigint(30) NOT NULL default '0',
numusers int unsigned NOT NULL default '0',
|
| Zeile 690 | Zeile 690 |
|---|
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,
|
$tables[] = "CREATE TABLE mybb_templategroups (
gid int unsigned NOT NULL auto_increment,
|
| Zeile 941 | Zeile 941 |
|---|
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 955 |
|---|
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;";
|