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

  Keine Änderungen   Hinzugefügt   Modifiziert   Entfernt
Zeile 482Zeile 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 680Zeile 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 759Zeile 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 769Zeile 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 799Zeile 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 955Zeile 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 '',