Vergleich install/resources/sqlite_db_tables.php - 1.8.8 - 1.8.21

  Keine Änderungen   Hinzugefügt   Modifiziert   Entfernt
Zeile 112Zeile 112
$tables[] = "CREATE TABLE mybb_badwords (
bid INTEGER PRIMARY KEY,
badword varchar(100) NOT NULL default '',

$tables[] = "CREATE TABLE mybb_badwords (
bid INTEGER PRIMARY KEY,
badword varchar(100) NOT NULL default '',

 
	regex tinyint(1) NOT NULL default '0',

	replacement varchar(100) NOT NULL default ''
);";


	replacement varchar(100) NOT NULL default ''
);";


Zeile 224Zeile 225
	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 467Zeile 469
	pid int NOT NULL default '0',
uid int NOT NULL default '0',
voteoption smallint NOT NULL default '0',

	pid int NOT NULL default '0',
uid int NOT NULL default '0',
voteoption smallint NOT NULL default '0',

	dateline int NOT NULL default '0'


	dateline int NOT NULL default '0',
ipaddress blob(16) NOT NULL default ''

);";

$tables[] = "CREATE TABLE mybb_posts (

);";

$tables[] = "CREATE TABLE mybb_posts (

Zeile 865Zeile 868
	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 950Zeile 954
	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 '',

	yahoo varchar(50) NOT NULL default '',
skype varchar(75) NOT NULL default '',
google varchar(75) NOT NULL default '',

Zeile 1010Zeile 1013
	suspendsigtime int NOT NULL default '0',
coppauser tinyint(1) NOT NULL default '0',
classicpostbit tinyint(1) NOT NULL default '0',

	suspendsigtime int NOT NULL default '0',
coppauser tinyint(1) NOT NULL default '0',
classicpostbit tinyint(1) NOT NULL default '0',

	loginattempts smallint(2) NOT NULL default '1',


	loginattempts smallint(2) NOT NULL default '0',
loginlockoutexpiry int NOT NULL default '0',

	usernotes TEXT NOT NULL,
sourceeditor tinyint(1) NOT NULL default '0'
);";

	usernotes TEXT NOT NULL,
sourceeditor tinyint(1) NOT NULL default '0'
);";