Zeile 103 | Zeile 103 |
---|
maxsize int(15) unsigned NOT NULL default '0', icon varchar(100) NOT NULL default '', enabled tinyint(1) NOT NULL default '1',
|
maxsize int(15) unsigned NOT NULL default '0', icon varchar(100) NOT NULL default '', enabled tinyint(1) NOT NULL default '1',
|
groups TEXT NOT NULL,
| `groups` TEXT NOT NULL,
|
forums TEXT NOT NULL, avatarfile tinyint(1) NOT NULL default '0', PRIMARY KEY (atid)
| forums TEXT NOT NULL, avatarfile tinyint(1) NOT NULL default '0', PRIMARY KEY (atid)
|
Zeile 123 | Zeile 123 |
---|
$tables[] = "CREATE TABLE mybb_badwords ( bid int unsigned NOT NULL auto_increment, badword varchar(100) NOT NULL default '',
|
$tables[] = "CREATE TABLE mybb_badwords ( bid int unsigned NOT NULL auto_increment, badword varchar(100) NOT NULL default '',
|
| regex tinyint(1) NOT NULL default '0',
|
replacement varchar(100) NOT NULL default '', PRIMARY KEY (bid) ) ENGINE=MyISAM;";
| replacement varchar(100) NOT NULL default '', PRIMARY KEY (bid) ) ENGINE=MyISAM;";
|
Zeile 252 | Zeile 253 |
---|
candeleteposts tinyint(1) NOT NULL default '0', candeletethreads tinyint(1) NOT NULL default '0', caneditattachments tinyint(1) NOT NULL default '0',
|
candeleteposts tinyint(1) NOT NULL default '0', candeletethreads tinyint(1) NOT NULL default '0', caneditattachments tinyint(1) NOT NULL default '0',
|
| canviewdeletionnotice tinyint(1) NOT NULL default '0',
|
modposts tinyint(1) NOT NULL default '0', modthreads tinyint(1) NOT NULL default '0', mod_edit_posts tinyint(1) NOT NULL default '0',
| modposts tinyint(1) NOT NULL default '0', modthreads tinyint(1) NOT NULL default '0', mod_edit_posts tinyint(1) NOT NULL default '0',
|
Zeile 480 | Zeile 482 |
---|
name varchar(200) NOT NULL, description text NOT NULL, forums text NOT NULL,
|
name varchar(200) NOT NULL, description text NOT NULL, forums text NOT NULL,
|
groups text NOT NULL,
| `groups` text NOT NULL,
|
type char(1) NOT NULL default '', postoptions text NOT NULL, threadoptions text NOT NULL,
| type char(1) NOT NULL default '', postoptions text NOT NULL, threadoptions text NOT NULL,
|
Zeile 522 | Zeile 524 |
---|
uid int unsigned NOT NULL default '0', voteoption smallint unsigned NOT NULL default '0', dateline int unsigned NOT NULL default '0',
|
uid int unsigned NOT NULL default '0', voteoption smallint unsigned NOT NULL default '0', dateline int unsigned NOT NULL default '0',
|
| ipaddress varbinary(16) NOT NULL default '',
|
KEY pid (pid, uid), PRIMARY KEY (vid) ) ENGINE=MyISAM;";
| KEY pid (pid, uid), PRIMARY KEY (vid) ) ENGINE=MyISAM;";
|
Zeile 871 | Zeile 874 |
---|
prefix varchar(120) NOT NULL default '', displaystyle varchar(200) NOT NULL default '', forums text NOT NULL,
|
prefix varchar(120) NOT NULL default '', displaystyle varchar(200) NOT NULL default '', forums text NOT NULL,
|
groups text NOT NULL,
| `groups` text NOT NULL,
|
PRIMARY KEY (pid) ) ENGINE=MyISAM;";
| PRIMARY KEY (pid) ) ENGINE=MyISAM;";
|
Zeile 980 | Zeile 983 |
---|
candeleteposts tinyint(1) NOT NULL default '0', candeletethreads tinyint(1) NOT NULL default '0', caneditattachments tinyint(1) NOT NULL default '0',
|
candeleteposts tinyint(1) NOT NULL default '0', candeletethreads tinyint(1) NOT NULL default '0', caneditattachments tinyint(1) NOT NULL default '0',
|
| canviewdeletionnotice tinyint(1) NOT NULL default '0',
|
canpostpolls tinyint(1) NOT NULL default '0', canvotepolls tinyint(1) NOT NULL default '0', canundovotes tinyint(1) NOT NULL default '0',
| canpostpolls tinyint(1) NOT NULL default '0', canvotepolls tinyint(1) NOT NULL default '0', canundovotes tinyint(1) NOT NULL default '0',
|
Zeile 1066 | Zeile 1070 |
---|
lastpost int unsigned NOT NULL default '0', website varchar(200) NOT NULL default '', icq varchar(10) NOT NULL default '',
|
lastpost int unsigned 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 '',
| yahoo varchar(50) NOT NULL default '', skype varchar(75) NOT NULL default '', google varchar(75) NOT NULL default '',
|
Zeile 1126 | Zeile 1129 |
---|
suspendsigtime int unsigned NOT NULL default '0', coppauser tinyint(1) NOT NULL default '0', classicpostbit tinyint(1) NOT NULL default '0',
|
suspendsigtime int unsigned NOT NULL default '0', coppauser tinyint(1) NOT NULL default '0', classicpostbit tinyint(1) NOT NULL default '0',
|
loginattempts smallint(2) unsigned NOT NULL default '1',
| loginattempts smallint(2) unsigned NOT NULL default '0', loginlockoutexpiry int unsigned NOT NULL default '0',
|
usernotes text NOT NULL, sourceeditor tinyint(1) NOT NULL default '0', UNIQUE KEY username (username),
| usernotes text NOT NULL, sourceeditor tinyint(1) NOT NULL default '0', UNIQUE KEY username (username),
|