WEB vBulletin admins assemble v.db table structure.

Discussion in 'OT Technology' started by 2ofdem, Oct 2, 2008.

  1. 2ofdem

    2ofdem OT Supporter

    Joined:
    Jun 17, 2003
    Messages:
    114,854
    Likes Received:
    8
    Location:
    aus.vic.mel
    I need to get a copy of the table structure for the users table from vBulletin.

    Anyone happen to have access to this?
     
  2. biawokauns

    biawokauns New Member

    Joined:
    Sep 18, 2001
    Messages:
    19,893
    Likes Received:
    0
    Location:
    Republic of Kalifornia
  3. FLY-FAST

    FLY-FAST OT Supporter

    Joined:
    Sep 30, 2003
    Messages:
    8,713
    Likes Received:
    3
    Location:
    boston, MA
    can you clarify what your objective is? I'm not sure what you're looking for...
     
  4. Drowned

    Drowned NameThatPornstar.com

    Joined:
    Mar 26, 2001
    Messages:
    8,534
    Likes Received:
    2
    Code:
    CREATE TABLE `user_new` (
      `userid` INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT,
      `usergroupid` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
      `membergroupids` VARCHAR(250) COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
      `displaygroupid` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
      `username` VARCHAR(100) COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
      `password` VARCHAR(32) COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
      `passworddate` DATE NOT NULL DEFAULT '0000-00-00',
      `email` VARCHAR(100) COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
      `styleid` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
      `parentemail` VARCHAR(50) COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
      `homepage` VARCHAR(100) COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
      `icq` VARCHAR(20) COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
      `aim` VARCHAR(20) COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
      `yahoo` VARCHAR(32) COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
      `showvbcode` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
      `showbirthday` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '2',
      `usertitle` VARCHAR(250) COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
      `customtitle` SMALLINT(6) NOT NULL DEFAULT '0',
      `joindate` INTEGER(10) UNSIGNED NOT NULL DEFAULT '0',
      `daysprune` SMALLINT(6) NOT NULL DEFAULT '0',
      `lastvisit` INTEGER(10) UNSIGNED NOT NULL DEFAULT '0',
      `lastactivity` INTEGER(10) UNSIGNED NOT NULL DEFAULT '0',
      `lastpost` INTEGER(10) UNSIGNED NOT NULL DEFAULT '0',
      `posts` INTEGER(10) UNSIGNED NOT NULL DEFAULT '0',
      `reputation` INTEGER(11) NOT NULL DEFAULT '10',
      `reputationlevelid` INTEGER(10) UNSIGNED NOT NULL DEFAULT '1',
      `timezoneoffset` VARCHAR(4) COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
      `pmpopup` SMALLINT(6) NOT NULL DEFAULT '0',
      `avatarid` SMALLINT(6) NOT NULL DEFAULT '0',
      `avatarrevision` INTEGER(10) UNSIGNED NOT NULL DEFAULT '0',
      `profilepicrevision` INTEGER(10) UNSIGNED NOT NULL DEFAULT '0',
      `options` INTEGER(10) UNSIGNED NOT NULL DEFAULT '15',
      `birthday` VARCHAR(10) COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
      `birthday_search` DATE NOT NULL DEFAULT '0000-00-00',
      `maxposts` SMALLINT(6) NOT NULL DEFAULT '-1',
      `startofweek` SMALLINT(6) NOT NULL DEFAULT '1',
      `ipaddress` VARCHAR(15) COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
      `referrerid` INTEGER(10) UNSIGNED NOT NULL DEFAULT '0',
      `languageid` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
      `msn` VARCHAR(100) COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
      `emailstamp` INTEGER(10) UNSIGNED NOT NULL DEFAULT '0',
      `threadedmode` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
      `autosubscribe` SMALLINT(6) NOT NULL DEFAULT '-1',
      `pmtotal` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
      `pmunread` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
      `salt` CHAR(3) COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
      `skype` VARCHAR(32) COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
      `adminoptions` INTEGER(10) UNSIGNED NOT NULL DEFAULT '0',
      `lastpostid` INTEGER(10) UNSIGNED NOT NULL DEFAULT '0',
      `sigpicrevision` INTEGER(10) UNSIGNED NOT NULL DEFAULT '0',
      `ipoints` INTEGER(10) UNSIGNED NOT NULL DEFAULT '0',
      `infractions` INTEGER(10) UNSIGNED NOT NULL DEFAULT '0',
      `warnings` INTEGER(10) UNSIGNED NOT NULL DEFAULT '0',
      `infractiongroupids` VARCHAR(255) COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
      `infractiongroupid` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
      `itrader_total` SMALLINT(5) NOT NULL DEFAULT '0',
      `itrader_pcnt` TINYINT(3) NOT NULL DEFAULT '0',
      `credits` DOUBLE NOT NULL DEFAULT '0',
      `credits_numrefs` INTEGER(10) UNSIGNED NOT NULL DEFAULT '0',
      `credits_canearn` TINYINT(1) UNSIGNED NOT NULL DEFAULT '1',
      `credits_saved` DOUBLE NOT NULL DEFAULT '0',
      `credits_canspend` TINYINT(1) UNSIGNED NOT NULL DEFAULT '1',
      `credits_score` INTEGER(11) NOT NULL DEFAULT '0',
      `credits_statement` VARCHAR(255) COLLATE latin1_swedish_ci NOT NULL DEFAULT 'none',
      `credits_alert` VARCHAR(255) COLLATE latin1_swedish_ci NOT NULL DEFAULT 'none',
      PRIMARY KEY (`userid`),
      KEY `usergroupid` (`usergroupid`),
      KEY `username` (`username`),
      KEY `birthday` (`birthday`, `showbirthday`),
      KEY `birthday_search` (`birthday_search`),
      KEY `posts` (`posts`)
    )ENGINE=MyISAM
    AUTO_INCREMENT=23428 CHARACTER SET 'latin1' COLLATE 'latin1_swedish_ci';
    
    :dunno:
     
  5. hurleyint1386

    hurleyint1386 Someone has sand in their vagina

    Joined:
    Jan 6, 2005
    Messages:
    3,687
    Likes Received:
    0
    Location:
    Rochester, NY
    describe tbl_users;

    :dunno:


    (I know that's not the actual table name)
     
  6. biawokauns

    biawokauns New Member

    Joined:
    Sep 18, 2001
    Messages:
    19,893
    Likes Received:
    0
    Location:
    Republic of Kalifornia
    mysql dump, --no-data
     
  7. HYBR|D

    HYBR|D Beep Beeeeee'p

    Joined:
    May 5, 2006
    Messages:
    2,009
    Likes Received:
    0
    Location:
    Ozz
    What version.? :hsd:
     
  8. 2ofdem

    2ofdem OT Supporter

    Joined:
    Jun 17, 2003
    Messages:
    114,854
    Likes Received:
    8
    Location:
    aus.vic.mel
    :h5:
     
  9. 2ofdem

    2ofdem OT Supporter

    Joined:
    Jun 17, 2003
    Messages:
    114,854
    Likes Received:
    8
    Location:
    aus.vic.mel
    Im writing a query blind dont have access to the DB I just needed to know the table and fields.
     
  10. whup

    whup I wish you had children and.. so that I could step

    Joined:
    Feb 12, 2007
    Messages:
    1,603
    Likes Received:
    0
    soko

    :mamoru:
     

Share This Page