Menu

#278 increasing online_uname size

open
nobody
None
5
2012-09-25
2008-03-31
irmtfan
No

currently the size is VARCHAR(25) but it should be increase to VARCHAR( 225 )

ALTER TABLE xoops_online CHANGE online_uname online_uname VARCHAR( 225 )

Discussion

  • D.J.

    D.J. - 2008-03-31

    Logged In: YES
    user_id=1001493
    Originator: NO

    The 'uname' should be kept the same as user table, which is varchar(25)

     
  • irmtfan

    irmtfan - 2008-04-16

    Logged In: YES
    user_id=1166047
    Originator: YES

    sorry for my late.
    DJ,
    you are right for the 2.0.X series but in the 2.2.x series we use uname as display name and it has 225 bytes long.

    also we are going to integrate 2 versions. so you dont think it is the time in 2.3 to change the size of the uname field in every table to 225?

    please correct me if im worng.

     

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.