"Fossies" - the Fresh Open Source Software Archive  

Source code changes of the file "Upload/install/resources/mysql_db_tables.php" between
mybb_1821.zip and mybb_1822.zip

About: MyBB is a multilingual, standards-compliant and free forum (discussion board) software.

mysql_db_tables.php  (mybb_1821):mysql_db_tables.php  (mybb_1822)
skipping to change at line 85 skipping to change at line 85
allowsmilies tinyint(1) NOT NULL default '0', allowsmilies tinyint(1) NOT NULL default '0',
KEY fid (fid), KEY fid (fid),
PRIMARY KEY (aid) PRIMARY KEY (aid)
) ENGINE=MyISAM;"; ) ENGINE=MyISAM;";
$tables[] = "CREATE TABLE mybb_attachments ( $tables[] = "CREATE TABLE mybb_attachments (
aid int unsigned NOT NULL auto_increment, aid int unsigned NOT NULL auto_increment,
pid int unsigned NOT NULL default '0', pid int unsigned NOT NULL default '0',
posthash varchar(50) NOT NULL default '', posthash varchar(50) NOT NULL default '',
uid int unsigned NOT NULL default '0', uid int unsigned NOT NULL default '0',
filename varchar(120) NOT NULL default '', filename varchar(255) NOT NULL default '',
filetype varchar(120) NOT NULL default '', filetype varchar(120) NOT NULL default '',
filesize int(10) unsigned NOT NULL default '0', filesize int(10) unsigned NOT NULL default '0',
attachname varchar(120) NOT NULL default '', attachname varchar(255) NOT NULL default '',
downloads int unsigned NOT NULL default '0', downloads int unsigned NOT NULL default '0',
dateuploaded int unsigned NOT NULL default '0', dateuploaded int unsigned NOT NULL default '0',
visible tinyint(1) NOT NULL default '0', visible tinyint(1) NOT NULL default '0',
thumbnail varchar(120) NOT NULL default '', thumbnail varchar(120) NOT NULL default '',
KEY pid (pid, visible), KEY pid (pid, visible),
KEY uid (uid), KEY uid (uid),
PRIMARY KEY (aid) PRIMARY KEY (aid)
) ENGINE=MyISAM;"; ) ENGINE=MyISAM;";
$tables[] = "CREATE TABLE mybb_attachtypes ( $tables[] = "CREATE TABLE mybb_attachtypes (
skipping to change at line 1073 skipping to change at line 1073
usergroup smallint unsigned NOT NULL default '0', usergroup smallint unsigned NOT NULL default '0',
additionalgroups varchar(200) NOT NULL default '', additionalgroups varchar(200) NOT NULL default '',
displaygroup smallint unsigned NOT NULL default '0', displaygroup smallint unsigned NOT NULL default '0',
usertitle varchar(250) NOT NULL default '', usertitle varchar(250) NOT NULL default '',
regdate int unsigned NOT NULL default '0', regdate int unsigned NOT NULL default '0',
lastactive int unsigned NOT NULL default '0', lastactive int unsigned NOT NULL default '0',
lastvisit int unsigned NOT NULL default '0', lastvisit int unsigned NOT NULL default '0',
lastpost int unsigned NOT NULL default '0', lastpost int unsigned NOT NULL default '0',
website varchar(200) NOT NULL default '', website varchar(200) NOT NULL default '',
icq varchar(10) NOT NULL default '', icq varchar(10) NOT NULL default '',
yahoo varchar(50) NOT NULL default '',
skype varchar(75) NOT NULL default '', skype varchar(75) NOT NULL default '',
google varchar(75) NOT NULL default '', google varchar(75) NOT NULL default '',
birthday varchar(15) NOT NULL default '', birthday varchar(15) NOT NULL default '',
birthdayprivacy varchar(4) NOT NULL default 'all', birthdayprivacy varchar(4) NOT NULL default 'all',
signature text NOT NULL, signature text NOT NULL,
allownotices tinyint(1) NOT NULL default '0', allownotices tinyint(1) NOT NULL default '0',
hideemail tinyint(1) NOT NULL default '0', hideemail tinyint(1) NOT NULL default '0',
subscriptionmethod tinyint(1) NOT NULL default '0', subscriptionmethod tinyint(1) NOT NULL default '0',
invisible tinyint(1) NOT NULL default '0', invisible tinyint(1) NOT NULL default '0',
receivepms tinyint(1) NOT NULL default '0', receivepms tinyint(1) NOT NULL default '0',
 End of changes. 3 change blocks. 
3 lines changed or deleted 2 lines changed or added

Home  |  About  |  Features  |  All  |  Newest  |  Dox  |  Diffs  |  RSS Feeds  |  Screenshots  |  Comments  |  Imprint  |  Privacy  |  HTTP(S)