Corrections in PortalUser table fields

Components

Labels

Description

Corrections in PortalUser table fields:

1. Increase the length of Phone and City DB fields for User prefix.

Currently pone field is 20 characters, while it's 255 for Fax. 255 makes more sense because, for example, 555-555-5555 ext. 555 phone number doesn't fit.

2. Adjust field types and NULL state based on todays rules:

When NULL value has special meaning and it's not the same as empty string
for code using it, then NOT NULL should be used.

Context Information

None

Additional information (do not use)

This minor bug should be applied to 5.1.1 RC1 in order to escape issues with code conflicts in Upgrades.sql possible if patch is left for future releases.

Attachments

1
  • 29 Oct 2010, 06:29 PM

Confluence content

mentioned on

Phabricator

Activity

Show:

Dmitry Andrejev November 30, 2010 at 6:48 PM

Closing released 5.1.1 task.

Alex November 1, 2010 at 8:48 PM

Fix committed to [b]5.1.x branch/b. Commit Message:

1. Fixes #0000909: Corrections in PortalUser table fields
2. Commit on behalf of Dmitry

Alex November 1, 2010 at 8:47 PM

ok

Dmitry Andrejev October 31, 2010 at 3:45 PM

Please test when you have a chance.

Dmitry Andrejev October 29, 2010 at 6:29 PM

Please review and test.

Fixed

Priority

Assignee

Alex

Reporter

Developer

Change Log Message

Patch Instructions

Patches must be submitted through Phabricator.

External issue ID

Fix versions

Affects versions

Created October 29, 2010 at 4:22 PM
Updated December 29, 2024 at 9:15 PM
Resolved November 30, 2010 at 6:48 PM

Flag notifications