Zeile 85 | Zeile 85 |
---|
pid int NOT NULL default '0', posthash varchar(50) NOT NULL default '', uid int NOT NULL default '0',
|
pid int NOT NULL default '0', posthash varchar(50) NOT NULL default '', uid int NOT NULL default '0',
|
filename varchar(120) NOT NULL default '',
| filename varchar(255) NOT NULL default '',
|
filetype varchar(120) NOT NULL default '', filesize int NOT NULL default '0',
|
filetype varchar(120) NOT NULL default '', filesize int NOT NULL default '0',
|
attachname varchar(120) NOT NULL default '',
| attachname varchar(255) NOT NULL default '',
|
downloads int NOT NULL default '0', dateuploaded int NOT NULL default '0', visible smallint NOT NULL default '0',
| downloads int NOT NULL default '0', dateuploaded int NOT NULL default '0', visible smallint NOT NULL default '0',
|
Zeile 104 | Zeile 104 |
---|
maxsize int NOT NULL default '0', icon varchar(100) NOT NULL default '', enabled smallint NOT NULL default '1',
|
maxsize int NOT NULL default '0', icon varchar(100) NOT NULL default '', enabled smallint NOT NULL default '1',
|
| forcedownload smallint NOT NULL default '0',
|
groups text NOT NULL default '-1', forums text NOT NULL default '-1', avatarfile smallint NOT NULL default '0',
| groups text NOT NULL default '-1', forums text NOT NULL default '-1', avatarfile smallint NOT NULL default '0',
|
Zeile 124 | Zeile 125 |
---|
$tables[] = "CREATE TABLE mybb_badwords ( bid serial, badword varchar(100) NOT NULL default '',
|
$tables[] = "CREATE TABLE mybb_badwords ( bid serial, badword varchar(100) NOT NULL default '',
|
| regex smallint NOT NULL default '0',
|
replacement varchar(100) NOT NULL default '', PRIMARY KEY (bid) );";
| replacement varchar(100) NOT NULL default '', PRIMARY KEY (bid) );";
|
Zeile 243 | Zeile 245 |
---|
candeleteposts smallint NOT NULL default '0', candeletethreads smallint NOT NULL default '0', caneditattachments smallint NOT NULL default '0',
|
candeleteposts smallint NOT NULL default '0', candeletethreads smallint NOT NULL default '0', caneditattachments smallint NOT NULL default '0',
|
| canviewdeletionnotice smallint NOT NULL default '0',
|
modposts smallint NOT NULL default '0', modthreads smallint NOT NULL default '0', mod_edit_posts smallint NOT NULL default '0',
| modposts smallint NOT NULL default '0', modthreads smallint NOT NULL default '0', mod_edit_posts smallint NOT NULL default '0',
|
Zeile 301 | Zeile 304 |
---|
$tables[] = "CREATE TABLE mybb_forumsread ( fid int NOT NULL default '0', uid int NOT NULL default '0',
|
$tables[] = "CREATE TABLE mybb_forumsread ( fid int NOT NULL default '0', uid int NOT NULL default '0',
|
dateline int NOT NULL default '0'
| dateline int NOT NULL default '0', UNIQUE (fid, uid)
|
);";
$tables[] = "CREATE TABLE mybb_forumsubscriptions (
| );";
$tables[] = "CREATE TABLE mybb_forumsubscriptions (
|
Zeile 504 | Zeile 508 |
---|
uid int NOT NULL default '0', voteoption smallint NOT NULL default '0', dateline int NOT NULL default '0',
|
uid int NOT NULL default '0', voteoption smallint NOT NULL default '0', dateline int NOT NULL default '0',
|
| ipaddress bytea NOT NULL default '',
|
PRIMARY KEY (vid) );";
| PRIMARY KEY (vid) );";
|
Zeile 519 | Zeile 524 |
---|
dateline int NOT NULL default '0', message text NOT NULL default '', ipaddress bytea NOT NULL default '',
|
dateline int NOT NULL default '0', message text NOT NULL default '', ipaddress bytea NOT NULL default '',
|
includesig smallint NOT NULL default '0',
| includesig smallint NOT NULL default '0',
|
smilieoff smallint NOT NULL default '0', edituid int NOT NULL default '0', edittime int NOT NULL default '0',
| smilieoff smallint NOT NULL default '0', edituid int NOT NULL default '0', edittime int NOT NULL default '0',
|
Zeile 665 | Zeile 670 |
---|
dateline int NOT NULL default '0', comments text NOT NULL default '', PRIMARY KEY(rid)
|
dateline int NOT NULL default '0', comments text NOT NULL default '', PRIMARY KEY(rid)
|
);";
| );";
|
$tables[] = "CREATE TABLE mybb_searchlog ( sid varchar(32) NOT NULL default '',
| $tables[] = "CREATE TABLE mybb_searchlog ( sid varchar(32) NOT NULL default '',
|
Zeile 883 | Zeile 888 |
---|
$tables[] = "CREATE TABLE mybb_threadsread ( tid int NOT NULL default '0', uid int NOT NULL default '0',
|
$tables[] = "CREATE TABLE mybb_threadsread ( tid int NOT NULL default '0', uid int NOT NULL default '0',
|
dateline int NOT NULL default '0'
| dateline int NOT NULL default '0', UNIQUE (tid, uid)
|
);";
$tables[] = "CREATE TABLE mybb_threadsubscriptions (
| );";
$tables[] = "CREATE TABLE mybb_threadsubscriptions (
|
Zeile 902 | Zeile 908 |
---|
fid3 text NOT NULL default '', PRIMARY KEY (ufid) );";
|
fid3 text NOT NULL default '', PRIMARY KEY (ufid) );";
|
$query = $db->write_query("SELECT column_name FROM information_schema.constraint_column_usage WHERE table_name = '".$config['tableprefix']."userfields' AND constraint_name = '".$config['tableprefix']."userfields_pkey' LIMIT 1"); $main_field = $db->fetch_field($query, 'column_name'); if(!empty($main_field)) { $tables[] = "DROP SEQUENCE mybb_userfields_ufid_seq;"; }
| |
$tables[] = "CREATE SEQUENCE mybb_userfields_ufid_seq;";
$tables[] = "CREATE TABLE mybb_usergroups (
| $tables[] = "CREATE SEQUENCE mybb_userfields_ufid_seq;";
$tables[] = "CREATE TABLE mybb_usergroups (
|
Zeile 943 | Zeile 939 |
---|
candeleteposts smallint NOT NULL default '0', candeletethreads smallint NOT NULL default '0', caneditattachments smallint NOT NULL default '0',
|
candeleteposts smallint NOT NULL default '0', candeletethreads smallint NOT NULL default '0', caneditattachments smallint NOT NULL default '0',
|
| canviewdeletionnotice smallint NOT NULL default '0',
|
canpostpolls smallint NOT NULL default '0', canvotepolls smallint NOT NULL default '0', canundovotes smallint NOT NULL default '0',
| canpostpolls smallint NOT NULL default '0', canvotepolls smallint NOT NULL default '0', canundovotes smallint NOT NULL default '0',
|
Zeile 972 | Zeile 969 |
---|
canratemembers smallint NOT NULL default '0', canchangename smallint NOT NULL default '0', canbereported smallint NOT NULL default '0',
|
canratemembers smallint NOT NULL default '0', canchangename smallint NOT NULL default '0', canbereported smallint NOT NULL default '0',
|
| canbeinvisible smallint NOT NULL default '1',
|
canchangewebsite smallint NOT NULL default '1', showforumteam smallint NOT NULL default '0', usereputationsystem smallint NOT NULL default '0',
| canchangewebsite smallint NOT NULL default '1', showforumteam smallint NOT NULL default '0', usereputationsystem smallint NOT NULL default '0',
|
Zeile 1029 | Zeile 1027 |
---|
lastpost int NOT NULL default '0', website varchar(200) NOT NULL default '', icq varchar(10) NOT NULL default '',
|
lastpost int NOT NULL default '0', website varchar(200) NOT NULL default '', icq varchar(10) NOT NULL default '',
|
aim varchar(50) NOT NULL default '', yahoo varchar(50) NOT NULL default '',
| |
skype varchar(75) NOT NULL default '', google varchar(75) NOT NULL default '', birthday varchar(15) NOT NULL default '',
| skype varchar(75) NOT NULL default '', google varchar(75) NOT NULL default '', birthday varchar(15) NOT NULL default '',
|
Zeile 1089 | Zeile 1085 |
---|
suspendsigtime int NOT NULL default '0', coppauser smallint NOT NULL default '0', classicpostbit smallint NOT NULL default '0',
|
suspendsigtime int NOT NULL default '0', coppauser smallint NOT NULL default '0', classicpostbit smallint NOT NULL default '0',
|
loginattempts smallint NOT NULL default '1',
| loginattempts smallint NOT NULL default '0', loginlockoutexpiry int NOT NULL default '0',
|
usernotes text NOT NULL default '', sourceeditor smallint NOT NULL default '0', PRIMARY KEY (uid)
| usernotes text NOT NULL default '', sourceeditor smallint NOT NULL default '0', PRIMARY KEY (uid)
|