user table

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Craig A
    Senior Member
    • Apr 2000
    • 620

    user table

    Hi guys
    I'm just in the process of having some software installed which uses vB's user table as a membership base. Can you please let me know if there are any changes affecting this table and the way which the data is stored within ?

    Thanks in advance
  • chrispadfield
    Senior Member
    • Aug 2000
    • 5366

    #2
    Code:
    userid  int(10)   UNSIGNED   No  0  auto_increment  Change Drop Primary Index Unique 
    usergroupid  smallint(5)   UNSIGNED   No  0    Change Drop Primary Index Unique 
    username  varchar(50)    No      Change Drop Primary Index Unique 
    password  varchar(50)    No      Change Drop Primary Index Unique 
    email  varchar(50)    No      Change Drop Primary Index Unique 
    styleid  smallint(5)   UNSIGNED   No  0    Change Drop Primary Index Unique 
    parentemail  varchar(50)    No      Change Drop Primary Index Unique 
    coppauser  smallint(6)    No  0    Change Drop Primary Index Unique 
    homepage  varchar(100)    No      Change Drop Primary Index Unique 
    icq  varchar(20)    No      Change Drop Primary Index Unique 
    aim  varchar(20)    No      Change Drop Primary Index Unique 
    yahoo  varchar(20)    No      Change Drop Primary Index Unique 
    signature  mediumtext    No      Change Drop Primary Index Unique 
    adminemail  smallint(6)    No  0    Change Drop Primary Index Unique 
    showemail  smallint(6)    No  0    Change Drop Primary Index Unique 
    invisible  smallint(6)    No  0    Change Drop Primary Index Unique 
    usertitle  varchar(250)    No      Change Drop Primary Index Unique 
    customtitle  smallint(6)    No  0    Change Drop Primary Index Unique 
    joindate  int(10)   UNSIGNED   No  0    Change Drop Primary Index Unique 
    cookieuser  smallint(6)    No  0    Change Drop Primary Index Unique 
    daysprune  smallint(6)    No  0    Change Drop Primary Index Unique 
    lastvisit  int(10)   UNSIGNED   No  0    Change Drop Primary Index Unique 
    lastactivity  int(10)   UNSIGNED   No  0    Change Drop Primary Index Unique 
    lastpost  int(10)   UNSIGNED   No  0    Change Drop Primary Index Unique 
    posts  smallint(5)   UNSIGNED   No  0    Change Drop Primary Index Unique 
    timezoneoffset  varchar(4)    No      Change Drop Primary Index Unique 
    emailnotification  smallint(6)    No  0    Change Drop Primary Index Unique 
    buddylist  mediumtext    No      Change Drop Primary Index Unique 
    ignorelist  mediumtext    No      Change Drop Primary Index Unique 
    pmfolders  mediumtext    No      Change Drop Primary Index Unique 
    receivepm  smallint(6)    No  0    Change Drop Primary Index Unique 
    emailonpm  smallint(6)    No  0    Change Drop Primary Index Unique 
    pmpopup  smallint(6)    No  0    Change Drop Primary Index Unique 
    avatarid  smallint(6)    No  0    Change Drop Primary Index Unique 
    showsignatures  smallint(6)    No  1    Change Drop Primary Index Unique 
    birthday  date    No  0000-00-00    Change Drop Primary Index Unique 
    maxposts  smallint(6)    No  -1    Change Drop Primary Index Unique 
    startofweek  smallint(6)    No  1    Change Drop Primary Index Unique 
    ipaddress  varchar(20)    No      Change Drop Primary Index Unique 
    referrerid  int(10)   UNSIGNED   No  0    Change Drop Primary Index Unique 
    nosessionhash  smallint(6)    No  0
    this is my phpmyadmin dump
    Christopher Padfield
    Web Based Helpdesk
    DeskPRO v3.0.3 Released - Download Demo Now!

    Comment

    • Craig A
      Senior Member
      • Apr 2000
      • 620

      #3
      Thanks chap - i'll contact the author and pass this on... though I suspect you may already have done this if a post by yourself in their support forum is anything to go by...

      Comment

      • chrispadfield
        Senior Member
        • Aug 2000
        • 5366

        #4
        hehe you going for links sql ?

        they will get vb2.0 when it comes out i am sure...
        Christopher Padfield
        Web Based Helpdesk
        DeskPRO v3.0.3 Released - Download Demo Now!

        Comment

        • Craig A
          Senior Member
          • Apr 2000
          • 620

          #5
          Couldn't possibly comment... I'm under instructions not to let the cat out of the bag on any future developments we have planned as our fingers got burned last time...

          Comment

          • chrispadfield
            Senior Member
            • Aug 2000
            • 5366

            #6
            lol

            co-branding... hehe.. you will like it, it works good (far better than the forum structure which aint so good).
            Christopher Padfield
            Web Based Helpdesk
            DeskPRO v3.0.3 Released - Download Demo Now!

            Comment

            widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
            Working...