Vergleich install/resources/sqlite_db_tables.php - 1.8.24 - 1.8.39

  Keine Änderungen   Hinzugefügt   Modifiziert   Entfernt
Zeile 94Zeile 94
	maxsize int(15) NOT NULL default '0',
icon varchar(100) NOT NULL default '',
enabled tinyint(1) NOT NULL default '1',

	maxsize int(15) NOT NULL default '0',
icon varchar(100) NOT NULL default '',
enabled tinyint(1) NOT NULL default '1',

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

	groups TEXT NOT NULL,
forums TEXT NOT NULL,
avatarfile tinyint(1) NOT NULL default '0'

	groups TEXT NOT NULL,
forums TEXT NOT NULL,
avatarfile tinyint(1) NOT NULL default '0'

Zeile 481Zeile 482
	subject varchar(120) NOT NULL default '',
icon smallint NOT NULL default '0',
uid int NOT NULL default '0',

	subject varchar(120) NOT NULL default '',
icon smallint NOT NULL default '0',
uid int NOT NULL default '0',

	username varchar(80) NOT NULL default '',

	username varchar(120) NOT NULL default '',

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

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

Zeile 679Zeile 680
);";

$tables[] = "CREATE TABLE mybb_spamlog (

);";

$tables[] = "CREATE TABLE mybb_spamlog (

	sid INTEGER PRIMARY KEY,

	sid INTEGER PRIMARY KEY,

	username varchar(120) NOT NULL DEFAULT '',
email varchar(220) NOT NULL DEFAULT '',
ipaddress blob(16) NOT NULL default '',

	username varchar(120) NOT NULL DEFAULT '',
email varchar(220) NOT NULL DEFAULT '',
ipaddress blob(16) NOT NULL default '',

Zeile 758Zeile 759
	properties TEXT NOT NULL,
stylesheets TEXT NOT NULL,
allowedgroups TEXT NOT NULL

	properties TEXT NOT NULL,
stylesheets TEXT NOT NULL,
allowedgroups TEXT NOT NULL

);";

);";


$tables[] = "CREATE TABLE mybb_themestylesheets(
sid INTEGER PRIMARY KEY,


$tables[] = "CREATE TABLE mybb_themestylesheets(
sid INTEGER PRIMARY KEY,

Zeile 768Zeile 769
	stylesheet LONGTEXT NOT NULL,
cachefile varchar(100) NOT NULL default '',
lastmodified int NOT NULL default '0'

	stylesheet LONGTEXT NOT NULL,
cachefile varchar(100) NOT NULL default '',
lastmodified int NOT NULL default '0'

);";

);";


$tables[] = "CREATE TABLE mybb_threadprefixes (
pid INTEGER PRIMARY KEY,


$tables[] = "CREATE TABLE mybb_threadprefixes (
pid INTEGER PRIMARY KEY,

Zeile 798Zeile 799
	icon smallint NOT NULL default '0',
poll int NOT NULL default '0',
uid int NOT NULL default '0',

	icon smallint NOT NULL default '0',
poll int NOT NULL default '0',
uid int NOT NULL default '0',

	username varchar(80) NOT NULL default '',

	username varchar(120) NOT NULL default '',

	dateline int NOT NULL default '0',
firstpost int NOT NULL default '0',
lastpost int NOT NULL default '0',

	dateline int NOT NULL default '0',
firstpost int NOT NULL default '0',
lastpost int NOT NULL default '0',

Zeile 898Zeile 899
	canratemembers tinyint(1) NOT NULL default '0',
canchangename tinyint(1) NOT NULL default '0',
canbereported tinyint(1) NOT NULL default '0',

	canratemembers tinyint(1) NOT NULL default '0',
canchangename tinyint(1) NOT NULL default '0',
canbereported tinyint(1) NOT NULL default '0',

 
	canbeinvisible tinyint(1) NOT NULL default '1',

	canchangewebsite tinyint(1) NOT NULL default '1',
showforumteam tinyint(1) NOT NULL default '0',
usereputationsystem tinyint(1) NOT NULL default '0',

	canchangewebsite tinyint(1) NOT NULL default '1',
showforumteam tinyint(1) NOT NULL default '0',
usereputationsystem tinyint(1) NOT NULL default '0',

Zeile 953Zeile 955
	lastvisit int NOT NULL default '0',
lastpost int NOT NULL default '0',
website varchar(200) NOT NULL default '',

	lastvisit int NOT NULL default '0',
lastpost int NOT NULL default '0',
website varchar(200) NOT NULL default '',

	icq varchar(10) 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 '',