| 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: sqlite_db_tables.php 3982 2008-07-04 21:25:56Z Tikitiki $
| * $Id: sqlite_db_tables.php 5379 2011-02-21 11:06:42Z Tomm $
|
*/
$tables[] = "CREATE TABLE mybb_adminlog (
| */
$tables[] = "CREATE TABLE mybb_adminlog (
|
| Zeile 15 | Zeile 15 |
|---|
dateline bigint(30) NOT NULL default '0',
module varchar(50) NOT NULL default '',
action varchar(50) NOT NULL default '',
|
dateline bigint(30) NOT NULL default '0',
module varchar(50) NOT NULL default '',
action varchar(50) NOT NULL default '',
|
data TEXT NOT NULL );";
| data TEXT NOT NULL
);";
|
$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,
|
notes TEXT NOT NULL,
permissions TEXT NOT NULL,
|
defaultviews TEXT NOT NULL );";
| defaultviews TEXT NOT NULL
);";
|
$tables[] = "CREATE TABLE mybb_adminsessions (
sid varchar(32) NOT NULL default '',
|
$tables[] = "CREATE TABLE mybb_adminsessions (
sid varchar(32) NOT NULL default '',
|
| Zeile 31 | Zeile 34 |
|---|
ip varchar(40) NOT NULL default '',
dateline bigint(30) NOT NULL default '0',
lastactive bigint(30) NOT NULL default '0',
|
ip varchar(40) NOT NULL default '',
dateline bigint(30) NOT NULL default '0',
lastactive bigint(30) NOT NULL default '0',
|
data TEXT NOT NULL );";
| data TEXT NOT NULL
);";
|
$tables[] = "CREATE TABLE mybb_adminviews (
vid INTEGER PRIMARY KEY,
|
$tables[] = "CREATE TABLE mybb_adminviews (
vid INTEGER PRIMARY KEY,
|
| Zeile 55 | Zeile 59 |
|---|
message TEXT NOT NULL,
startdate bigint(30) NOT NULL default '0',
enddate bigint(30) NOT NULL default '0',
|
message TEXT NOT NULL,
startdate bigint(30) NOT NULL default '0',
enddate bigint(30) NOT NULL default '0',
|
allowhtml int(1) NOT NULL default '0',
allowmycode int(1) NOT NULL default '0',
| allowhtml int(1) NOT NULL default '0',
allowmycode int(1) NOT NULL default '0',
|
allowsmilies int(1) NOT NULL default '0'
);";
| allowsmilies int(1) NOT NULL default '0'
);";
|
| Zeile 106 | Zeile 110 |
|---|
type int(1) NOT NULL default '0',
lastuse bigint(30) NOT NULL default '0',
dateline bigint(30) NOT NULL default '0'
|
type int(1) NOT NULL default '0',
lastuse bigint(30) NOT NULL default '0',
dateline bigint(30) NOT NULL default '0'
|
);";
| );";
|
$tables[] = "CREATE TABLE mybb_banned (
uid int NOT NULL default '0',
gid int NOT NULL default '0',
| $tables[] = "CREATE TABLE mybb_banned (
uid int NOT NULL default '0',
gid int NOT NULL default '0',
|
| Zeile 133 | Zeile 137 |
|---|
allowmycode int(1) NOT NULL default '0',
allowimgcode int(1) NOT NULL default '0',
allowsmilies int(1) NOT NULL default '0'
|
allowmycode int(1) NOT NULL default '0',
allowimgcode int(1) NOT NULL default '0',
allowsmilies int(1) NOT NULL default '0'
|
);";
| );";
|
$tables[] = "CREATE TABLE mybb_calendarpermissions (
cid int NOT NULL default '0',
|
$tables[] = "CREATE TABLE mybb_calendarpermissions (
cid int NOT NULL default '0',
|
| Zeile 151 | Zeile 155 |
|---|
);";
$tables[] = "CREATE TABLE mybb_datacache (
|
);";
$tables[] = "CREATE TABLE mybb_datacache (
|
title varchar(50) NOT NULL default '',
cache mediumTEXT NOT NULL );";
| title varchar(50) NOT NULL default '' PRIMARY KEY,
cache mediumTEXT NOT NULL
);";
|
$tables[] = "CREATE TABLE mybb_events (
eid INTEGER PRIMARY KEY,
cid int NOT NULL default '0',
|
$tables[] = "CREATE TABLE mybb_events (
eid INTEGER PRIMARY KEY,
cid int NOT NULL default '0',
|
uid int NOT NULL default '0',
name varchar(120) NOT NULL default '',
| uid int NOT NULL default '0',
name varchar(120) NOT NULL default '',
|
description TEXT NOT NULL,
visible int(1) NOT NULL default '0',
private int(1) NOT NULL default '0',
dateline int(10) NOT NULL default '0',
starttime int(10) NOT NULL default '0',
endtime int(10) NOT NULL default '0',
|
description TEXT NOT NULL,
visible int(1) NOT NULL default '0',
private int(1) NOT NULL default '0',
dateline int(10) NOT NULL default '0',
starttime int(10) NOT NULL default '0',
endtime int(10) 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 );";
$tables[] = "CREATE TABLE mybb_forumpermissions (
pid INTEGER PRIMARY KEY,
|
ignoretimezone int(1) NOT NULL default '0',
usingtime int(1) NOT NULL default '0',
repeats TEXT NOT NULL );";
$tables[] = "CREATE TABLE mybb_forumpermissions (
pid INTEGER PRIMARY KEY,
|
fid int NOT NULL default '0',
| fid int NOT NULL default '0',
|
gid int NOT NULL default '0',
canview int(1) NOT NULL default '0',
canviewthreads int(1) NOT NULL default '0',
| gid int NOT NULL default '0',
canview int(1) NOT NULL default '0',
canviewthreads int(1) NOT NULL default '0',
|
| Zeile 235 | Zeile 240 |
|---|
);";
$tables[] = "CREATE TABLE mybb_forumsread (
|
);";
$tables[] = "CREATE TABLE mybb_forumsread (
|
fid int NOT NULL default '0',
uid int NOT NULL default '0',
dateline int(10) NOT NULL default '0'
);";
| fid int NOT NULL default '0',
uid int NOT NULL default '0',
dateline int(10) NOT NULL default '0'
);";
|
$tables[] = "CREATE TABLE mybb_forumsubscriptions (
fsid INTEGER PRIMARY KEY,
fid smallint NOT NULL default '0',
| $tables[] = "CREATE TABLE mybb_forumsubscriptions (
fsid INTEGER PRIMARY KEY,
fid smallint NOT NULL default '0',
|
| Zeile 418 | Zeile 423 |
|---|
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 NOT NULL default '0',
| includesig int(1) NOT NULL default '0',
smilieoff int(1) NOT NULL default '0',
edituid int NOT NULL default '0',
|
| Zeile 531 | Zeile 536 |
|---|
anonymous int(1) NOT NULL default '0',
nopermission int(1) NOT NULL default '0',
location1 int(10) NOT NULL default '0',
|
anonymous int(1) 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'
);";
| location2 int(10) NOT NULL default '0'
);";
|
$tables[] = "CREATE TABLE mybb_settinggroups (
gid INTEGER PRIMARY KEY,
name varchar(100) NOT NULL default '',
| $tables[] = "CREATE TABLE mybb_settinggroups (
gid INTEGER PRIMARY KEY,
name varchar(100) NOT NULL default '',
|
| Zeile 545 | Zeile 548 |
|---|
isdefault int(1) NOT NULL default '0'
);";
|
isdefault int(1) NOT NULL default '0'
);";
|
|
|
$tables[] = "CREATE TABLE mybb_settings (
|
$tables[] = "CREATE TABLE mybb_settings (
|
sid INTEGER PRIMARY KEY,
name varchar(120) NOT NULL default '',
title varchar(120) NOT NULL default '',
| sid INTEGER PRIMARY KEY,
name varchar(120) NOT NULL default '',
title varchar(120) NOT NULL default '',
|
description TEXT NOT NULL,
optionscode TEXT NOT NULL,
value TEXT NOT NULL,
| description TEXT NOT NULL,
optionscode TEXT NOT NULL,
value TEXT NOT NULL,
|
| Zeile 600 | Zeile 603 |
|---|
enabled int(1) NOT NULL default '1',
logging int(1) NOT NULL default '0',
locked bigint(30) NOT NULL default '0'
|
enabled int(1) NOT NULL default '1',
logging int(1) NOT NULL default '0',
locked bigint(30) NOT NULL default '0'
|
);";
| );";
|
$tables[] = "CREATE TABLE mybb_tasklog (
lid INTEGER PRIMARY KEY,
tid int NOT NULL default '0',
dateline bigint(30) NOT NULL default '0',
data TEXT NOT NULL );";
|
$tables[] = "CREATE TABLE mybb_tasklog (
lid INTEGER PRIMARY KEY,
tid int NOT NULL default '0',
dateline bigint(30) NOT NULL default '0',
data TEXT NOT NULL );";
|
|
|
$tables[] = "CREATE TABLE mybb_templategroups (
gid INTEGER PRIMARY KEY,
prefix varchar(50) NOT NULL default '',
title varchar(100) NOT NULL default ''
|
$tables[] = "CREATE TABLE mybb_templategroups (
gid INTEGER PRIMARY KEY,
prefix varchar(50) NOT NULL default '',
title varchar(100) NOT NULL default ''
|
);";
| );";
|
$tables[] = "CREATE TABLE mybb_templates (
tid INTEGER PRIMARY KEY,
title varchar(120) NOT NULL default '',
| $tables[] = "CREATE TABLE mybb_templates (
tid INTEGER PRIMARY KEY,
title varchar(120) NOT NULL default '',
|
| Zeile 651 | Zeile 654 |
|---|
$tables[] = "CREATE TABLE mybb_threadratings (
rid INTEGER PRIMARY KEY,
|
$tables[] = "CREATE TABLE mybb_threadratings (
rid INTEGER PRIMARY KEY,
|
tid int NOT NULL default '0',
| tid int NOT NULL default '0',
|
uid int NOT NULL default '0',
rating smallint NOT NULL default '0',
ipaddress varchar(30) NOT NULL default ''
| uid int NOT NULL default '0',
rating smallint NOT NULL default '0',
ipaddress varchar(30) NOT NULL default ''
|
| Zeile 685 | Zeile 688 |
|---|
unapprovedposts int(10) NOT NULL default '0',
attachmentcount int(10) NOT NULL default '0',
deletetime int(10) NOT NULL default '0'
|
unapprovedposts int(10) NOT NULL default '0',
attachmentcount int(10) NOT NULL default '0',
deletetime int(10) NOT NULL default '0'
|
);";
| );";
|
$tables[] = "CREATE TABLE mybb_threadsread (
tid int NOT NULL default '0',
uid int NOT NULL default '0',
dateline int(10) NOT NULL default '0'
|
$tables[] = "CREATE TABLE mybb_threadsread (
tid int NOT NULL default '0',
uid int NOT NULL default '0',
dateline int(10) NOT NULL default '0'
|
);";
| );";
|
$tables[] = "CREATE TABLE mybb_threadsubscriptions (
sid INTEGER PRIMARY KEY,
uid int NOT NULL default '0',
| $tables[] = "CREATE TABLE mybb_threadsubscriptions (
sid INTEGER PRIMARY KEY,
uid int NOT NULL default '0',
|
| Zeile 706 | Zeile 709 |
|---|
ufid int NOT NULL default '0',
fid1 TEXT NOT NULL,
fid2 TEXT NOT NULL,
|
ufid int NOT NULL default '0',
fid1 TEXT NOT NULL,
fid2 TEXT NOT NULL,
|
fid3 TEXT NOT NULL );";
| fid3 TEXT NOT NULL
);";
|
$tables[] = "CREATE TABLE mybb_usergroups (
gid INTEGER PRIMARY KEY,
|
$tables[] = "CREATE TABLE mybb_usergroups (
gid INTEGER PRIMARY KEY,
|
| Zeile 833 | Zeile 837 |
|---|
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 846 | Zeile 850 |
|---|
suspendposting int(1) NOT NULL default '0',
suspensiontime bigint(30) NOT NULL default '0',
coppauser int(1) NOT NULL default '0',
|
suspendposting 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'
);";
| classicpostbit int(1) NOT NULL default '0',
loginattempts tinyint(2) NOT NULL default '1',
failedlogin bigint(30) NOT NULL default '0'
);";
|
$tables[] = "CREATE TABLE mybb_usertitles (
utid INTEGER PRIMARY KEY,
|
$tables[] = "CREATE TABLE mybb_usertitles (
utid INTEGER PRIMARY KEY,
|
| Zeile 861 | Zeile 867 |
|---|
$tables[] = "CREATE TABLE mybb_warninglevels (
lid INTEGER PRIMARY KEY,
percentage int(2) NOT NULL default '0',
|
$tables[] = "CREATE TABLE mybb_warninglevels (
lid INTEGER PRIMARY KEY,
percentage int(2) NOT NULL default '0',
|
action TEXT NOT NULL );";
| action TEXT NOT NULL
);";
|
$tables[] = "CREATE TABLE mybb_warningtypes (
tid INTEGER PRIMARY KEY,
|
$tables[] = "CREATE TABLE mybb_warningtypes (
tid INTEGER PRIMARY KEY,
|