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

  Keine Änderungen   Hinzugefügt   Modifiziert   Entfernt
Zeile 76Zeile 76
	pid int(10) NOT NULL default '0',
posthash varchar(50) NOT NULL default '',
uid int NOT NULL default '0',

	pid int(10) 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(10) NOT NULL default '0',

	filetype varchar(120) NOT NULL default '',
filesize int(10) 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 tinyint(1) NOT NULL default '0',

	downloads int NOT NULL default '0',
dateuploaded int NOT NULL default '0',
visible tinyint(1) NOT NULL default '0',

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 112Zeile 113
$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 468Zeile 470
	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 896Zeile 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 952Zeile 956
	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 1012Zeile 1014
	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'
);";