| 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 4249 2008-10-25 05:37:16Z Tikitiki $
|
*/
$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 '',
description TEXT NOT NULL,
| 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',
| visible int(1) NOT NULL default '0',
private int(1) NOT NULL default '0',
dateline int(10) 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,
|
$tables[] = "CREATE TABLE mybb_forumsubscriptions (
fsid INTEGER PRIMARY KEY,
|
| 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 '',
| sid INTEGER PRIMARY KEY,
name varchar(120) NOT NULL default '',
|
title varchar(120) NOT NULL default '',
description TEXT NOT NULL,
optionscode TEXT NOT NULL,
| title varchar(120) NOT NULL default '',
description TEXT NOT NULL,
optionscode 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,
|