Index: branches/5.1.x/install/upgrades.sql =================================================================== diff -u -N -r13820 -r13958 --- branches/5.1.x/install/upgrades.sql (.../upgrades.sql) (revision 13820) +++ branches/5.1.x/install/upgrades.sql (.../upgrades.sql) (revision 13958) @@ -199,4 +199,13 @@ # ===== v 5.1.0-RC1 ===== -# ===== v 5.1.0 ===== \ No newline at end of file +# ===== v 5.1.0 ===== + +# ===== v 5.1.1-B1 ===== +ALTER TABLE PollsComments CHANGE CreatedById CreatedById INT(11) NULL DEFAULT NULL; + +ALTER TABLE Topic + CHANGE OwnerId OwnerId INT( 11 ) NULL DEFAULT NULL , + CHANGE ModifiedById ModifiedById INT( 11 ) NULL DEFAULT NULL; + +UPDATE Topic SET ModifiedById = NULL WHERE ModifiedById = 0; \ No newline at end of file Index: branches/5.1.x/units/private_messages/private_messages_config.php =================================================================== diff -u -N -r13577 -r13958 --- branches/5.1.x/units/private_messages/private_messages_config.php (.../private_messages_config.php) (revision 13577) +++ branches/5.1.x/units/private_messages/private_messages_config.php (.../private_messages_config.php) (revision 13958) @@ -1,6 +1,6 @@ Array ( 'FromName' => Array ('type' => 'string', 'default' => ''), + 'FromFullName' => Array ('type' => 'string', 'default' => ''), 'ToName' => Array ('type' => 'string', 'default' => ''), + 'ToFullName' => Array ('type' => 'string', 'default' => ''), 'Subject' => Array ('type' => 'string', 'default' => ''), 'Body' => Array ('type' => 'string', 'required' => 1, 'default' => ''), 'Options' => Array ('type' => 'string', 'default' => 0), Index: branches/5.1.x/units/topics/topics_config.php =================================================================== diff -u -N -r13937 -r13958 --- branches/5.1.x/units/topics/topics_config.php (.../topics_config.php) (revision 13937) +++ branches/5.1.x/units/topics/topics_config.php (.../topics_config.php) (revision 13958) @@ -1,6 +1,6 @@ Array ( - 'Groups' => Array ( + 'Groups' => Array ( Array ('mode' => 'AND', 'filters' => Array ('show_new'), 'type' => HAVING_FILTER), Array ('mode' => 'AND', 'filters' => Array ('show_hot'), 'type' => HAVING_FILTER), Array ('mode' => 'AND', 'filters' => Array ('show_pop'), 'type' => HAVING_FILTER), @@ -390,7 +390,7 @@ 'left_key_field' => 'PortalUserId', 'left_title_field' => 'Login', 'error_msgs' => Array ('invalid_option' => '!la_error_UserNotFound!'), - 'required' => 1, 'not_null' => 1, 'default' => USER_ROOT, + 'required' => 1, 'default' => NULL, ), 'ModifiedById' => Array ( 'type' => 'int', @@ -401,7 +401,7 @@ 'left_key_field' => 'PortalUserId', 'left_title_field' => 'Login', 'error_msgs' => Array ('invalid_option' => '!la_error_UserNotFound!'), - 'required' => 1, 'not_null' => 1, 'default' => USER_ROOT, + 'required' => 1, 'default' => NULL, ), 'ResourceId' => Array ('type' => 'int', 'default' => null), 'TopicType' => Array ( @@ -462,8 +462,11 @@ 'options' => Array (), 'default' => 0, ), - 'Filename' => Array ('type' => 'string', 'not_null' => 1, 'default' => ''), + 'Filename' => Array ('type' => 'string', 'default' => ''), + 'CategoryFilename' => Array ('type' => 'string', 'default' => ''), + 'PrimaryCat' => Array ('type' => 'int', 'default' => 0), 'CachedNavbar' => Array ('type' => 'string', 'default' => ''), + 'ParentPath' => Array ('type' => 'string', 'default' => ''), 'LastPoster' => Array ('type' => 'string', 'default' => ''), 'LastPosterId' => Array ('type' => 'int', 'default' => USER_GUEST), Index: branches/5.1.x/units/poll_comments/poll_comments_config.php =================================================================== diff -u -N -r13577 -r13958 --- branches/5.1.x/units/poll_comments/poll_comments_config.php (.../poll_comments_config.php) (revision 13577) +++ branches/5.1.x/units/poll_comments/poll_comments_config.php (.../poll_comments_config.php) (revision 13958) @@ -1,6 +1,6 @@ Array(USER_ROOT => 'root', USER_GUEST => 'Guest'), 'left_sql' => 'SELECT %s FROM '.TABLE_PREFIX.'PortalUser WHERE `%s` = \'%s\'', 'left_key_field' => 'PortalUserId', 'left_title_field' => 'Login', - 'required' => 1, 'not_null' => 1, 'default' => USER_GUEST), + 'required' => 1, 'default' => NULL), 'GuestName' => Array ('type' => 'string', 'max_len' => 255, 'not_null' => 1, 'default' => ''), 'GuestEmail' => Array('type' => 'string', 'max_len' => 255, 'formatter'=>'kFormatter', 'regexp'=>'/^(' . REGEX_EMAIL_USER . '@' . REGEX_EMAIL_DOMAIN . ')$/i', 'sample_value' => 'email@domain.com', 'not_null' => '1', 'default' => '', 'error_msgs' => Array('invalid_format'=>'!la_invalid_email!', 'unique'=>'!lu_email_already_exist!'),'required' => 0 ), 'CommentBody' => Array ('type' => 'string', 'formatter' => 'kFormatter', 'using_fck' => 1, 'default' => NULL, 'required' => 1), Index: branches/5.1.x/units/posts/posts_config.php =================================================================== diff -u -N -r13577 -r13958 --- branches/5.1.x/units/posts/posts_config.php (.../posts_config.php) (revision 13577) +++ branches/5.1.x/units/posts/posts_config.php (.../posts_config.php) (revision 13958) @@ -1,6 +1,6 @@ Array ('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array (1 => 'la_Yes', 0 => 'la_No'), 'use_phrases' => 1, 'default' => 0), 'DisableSmileys' => Array ('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array (1 => 'la_Yes', 0 => 'la_No'), 'use_phrases' => 1, 'default' => 0), 'ShowSignatures' => Array ('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array (0 => 'la_No', 1 => 'la_Yes'), 'use_phrases' => 1, 'default' => 1), - + 'UserName' => Array ('type' => 'string', 'default' => ''), // for avatar image 'AltName' => Array('type' => 'string', 'default' => ''), 'SameImages' => Array('type' => 'string', 'default' => ''), Index: branches/5.1.x/install/install_schema.sql =================================================================== diff -u -N -r13094 -r13958 --- branches/5.1.x/install/install_schema.sql (.../install_schema.sql) (revision 13094) +++ branches/5.1.x/install/install_schema.sql (.../install_schema.sql) (revision 13958) @@ -34,8 +34,8 @@ EditorsPick tinyint(4) NOT NULL DEFAULT '0', `Status` tinyint(4) unsigned NOT NULL DEFAULT '2', Priority int(11) NOT NULL DEFAULT '0', - OwnerId int(11) NOT NULL DEFAULT '-1', - ModifiedById int(11) NOT NULL DEFAULT '0', + OwnerId int(11) DEFAULT NULL, + ModifiedById int(11) DEFAULT NULL, ResourceId int(11) DEFAULT NULL, TopicType int(11) NOT NULL DEFAULT '1', CreatedOn int(11) DEFAULT NULL, @@ -167,7 +167,7 @@ CommentId int(11) NOT NULL AUTO_INCREMENT, PollId int(11) NOT NULL DEFAULT '0', AnswerId int(11) DEFAULT NULL, - CreatedById int(11) NOT NULL DEFAULT '-2', + CreatedById int(11) DEFAULT NULL, GuestName varchar(255) NOT NULL DEFAULT '', GuestEmail varchar(255) NOT NULL DEFAULT '', CommentBody text,