"Fossies" - the Fresh Open Source Software Archive  

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

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

pgsql_db_tables.php  (mybb_1821):pgsql_db_tables.php  (mybb_1822)
skipping to change at line 88 skipping to change at line 88
allowmycode smallint NOT NULL default '0', allowmycode smallint NOT NULL default '0',
allowsmilies smallint NOT NULL default '0', allowsmilies smallint NOT NULL default '0',
PRIMARY KEY (aid) PRIMARY KEY (aid)
);"; );";
$tables[] = "CREATE TABLE mybb_attachments ( $tables[] = "CREATE TABLE mybb_attachments (
aid serial, aid serial,
pid int NOT NULL default '0', pid int NOT NULL default '0',
posthash varchar(50) NOT NULL default '', posthash varchar(50) NOT NULL default '',
uid int NOT NULL default '0', uid int 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 NOT NULL default '0', filesize int NOT NULL default '0',
attachname varchar(120) NOT NULL default '', attachname varchar(255) NOT NULL default '',
downloads int NOT NULL default '0', downloads int NOT NULL default '0',
dateuploaded int NOT NULL default '0', dateuploaded int NOT NULL default '0',
visible smallint NOT NULL default '0', visible smallint NOT NULL default '0',
thumbnail varchar(120) NOT NULL default '', thumbnail varchar(120) NOT NULL default '',
PRIMARY KEY (aid) PRIMARY KEY (aid)
);"; );";
$tables[] = "CREATE TABLE mybb_attachtypes ( $tables[] = "CREATE TABLE mybb_attachtypes (
atid serial, atid serial,
name varchar(120) NOT NULL default '', name varchar(120) NOT NULL default '',
skipping to change at line 1036 skipping to change at line 1036
usergroup smallint NOT NULL default '0', usergroup smallint NOT NULL default '0',
additionalgroups varchar(200) NOT NULL default '', additionalgroups varchar(200) NOT NULL default '',
displaygroup smallint NOT NULL default '0', displaygroup smallint NOT NULL default '0',
usertitle varchar(250) NOT NULL default '', usertitle varchar(250) NOT NULL default '',
regdate int NOT NULL default '0', regdate int NOT NULL default '0',
lastactive int NOT NULL default '0', lastactive int NOT NULL default '0',
lastvisit int NOT NULL default '0', lastvisit int NOT NULL default '0',
lastpost int NOT NULL default '0', lastpost int 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 default '', signature text NOT NULL default '',
allownotices smallint NOT NULL default '0', allownotices smallint NOT NULL default '0',
hideemail smallint NOT NULL default '0', hideemail smallint NOT NULL default '0',
subscriptionmethod smallint NOT NULL default '0', subscriptionmethod smallint NOT NULL default '0',
invisible smallint NOT NULL default '0', invisible smallint NOT NULL default '0',
receivepms smallint NOT NULL default '0', receivepms smallint 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)