Task #83986

Streamline size of all email fields at the database schema

Added by Guido S. almost 3 years ago. Updated about 2 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
-
Target version:
Start date:
2018-02-20
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
9
PHP Version:
Tags:
Complexity:
Sprint Focus:

Description

We have different sizes of the email field at the database schema

  • be_users.email => varchar(80)
  • pages.author_email => varchar(80)
  • tx_extensionmanager_domain_model_extension.author_email => varchar(255)
  • fe_users.email => varchar(255)
  • pages_language_overlay.author_email => varchar(80)

I think we should streamline all email fields to varchar(255)

Source: https://en.wikipedia.org/wiki/Email_address#RFC_specification


Related issues

Related to TYPO3 Core - Bug #79094: Extension Manager API potentially makes destructive database schema changesClosedNicole Cordes2016-12-25

Actions
Related to TYPO3 Core - Bug #55484: fe_user:username is limited to 50 charsClosed2014-01-30

Actions
Related to TYPO3 Core - Bug #67704: value too long for type character varying(150)ClosedMorton Jonuschat2015-06-23

Actions
#1

Updated by Guido S. almost 3 years ago

  • Related to Bug #79094: Extension Manager API potentially makes destructive database schema changes added
#2

Updated by Guido S. almost 3 years ago

  • Related to Bug #55484: fe_user:username is limited to 50 chars added
#3

Updated by Guido S. almost 3 years ago

  • Related to Bug #67704: value too long for type character varying(150) added
#4

Updated by Georg Ringer almost 3 years ago

can you do a patch for that? remember that 9 does not need any change in pages_language_overlay anymore.

#5

Updated by Georg Ringer almost 3 years ago

  • Status changed from New to Accepted
#6

Updated by Guido S. almost 3 years ago

I would try this. It is a good start to learn how to contribute ;-)

#7

Updated by Guido S. almost 3 years ago

  • Tracker changed from Feature to Task
  • TYPO3 Version set to 9
#8

Updated by Gerrit Code Review almost 3 years ago

  • Status changed from Accepted to Under Review

Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/55868

#9

Updated by Anonymous almost 3 years ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100
#10

Updated by Benni Mack about 2 years ago

  • Status changed from Resolved to Closed

Also available in: Atom PDF