| 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 124 | Zeile 124 |
|---|
$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 244 |
|---|
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 504 | Zeile 506 |
|---|
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 943 | Zeile 946 |
|---|
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 1029 | Zeile 1033 |
|---|
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 1091 |
|---|
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)
|