Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on Apr 25th, 2012  |  syntax: PL/SQL  |  size: 4.13 KB  |  hits: 28  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. CREATE TABLE IF NOT EXISTS `mybb_users` (
  2.   `UID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  3.   `username` VARCHAR(120) NOT NULL DEFAULT '',
  4.   `password` VARCHAR(120) NOT NULL DEFAULT '',
  5.   `salt` VARCHAR(10) NOT NULL DEFAULT '',
  6.   `loginkey` VARCHAR(50) NOT NULL DEFAULT '',
  7.   `email` VARCHAR(220) NOT NULL DEFAULT '',
  8.   `postnum` int(10) NOT NULL DEFAULT '0',
  9.   `avatar` VARCHAR(200) NOT NULL DEFAULT '',
  10.   `avatardimensions` VARCHAR(10) NOT NULL DEFAULT '',
  11.   `avatartype` VARCHAR(10) NOT NULL DEFAULT '0',
  12.   `usergroup` SMALLINT(5) unsigned NOT NULL DEFAULT '0',
  13.   `additionalgroups` VARCHAR(200) NOT NULL DEFAULT '',
  14.   `displaygroup` SMALLINT(5) unsigned NOT NULL DEFAULT '0',
  15.   `usertitle` VARCHAR(250) NOT NULL DEFAULT '',
  16.   `regdate` bigint(30) NOT NULL DEFAULT '0',
  17.   `lastactive` bigint(30) NOT NULL DEFAULT '0',
  18.   `lastvisit` bigint(30) NOT NULL DEFAULT '0',
  19.   `lastpost` bigint(30) NOT NULL DEFAULT '0',
  20.   `website` VARCHAR(200) NOT NULL DEFAULT '',
  21.   `icq` VARCHAR(10) NOT NULL DEFAULT '',
  22.   `aim` VARCHAR(50) NOT NULL DEFAULT '',
  23.   `yahoo` VARCHAR(50) NOT NULL DEFAULT '',
  24.   `msn` VARCHAR(75) NOT NULL DEFAULT '',
  25.   `birthday` VARCHAR(15) NOT NULL DEFAULT '',
  26.   `birthdayprivacy` VARCHAR(4) NOT NULL DEFAULT 'all',
  27.   `signature` text NOT NULL,
  28.   `allownotices` int(1) NOT NULL DEFAULT '0',
  29.   `hideemail` int(1) NOT NULL DEFAULT '0',
  30.   `subscriptionmethod` int(1) NOT NULL DEFAULT '0',
  31.   `invisible` int(1) NOT NULL DEFAULT '0',
  32.   `receivepms` int(1) NOT NULL DEFAULT '0',
  33.   `receivefrombuddy` int(1) NOT NULL DEFAULT '0',
  34.   `pmnotice` int(1) NOT NULL DEFAULT '0',
  35.   `pmnotify` int(1) NOT NULL DEFAULT '0',
  36.   `threadmode` VARCHAR(8) NOT NULL DEFAULT '',
  37.   `showsigs` int(1) NOT NULL DEFAULT '0',
  38.   `showavatars` int(1) NOT NULL DEFAULT '0',
  39.   `showquickreply` int(1) NOT NULL DEFAULT '0',
  40.   `showredirect` int(1) NOT NULL DEFAULT '0',
  41.   `ppp` SMALLINT(6) NOT NULL DEFAULT '0',
  42.   `tpp` SMALLINT(6) NOT NULL DEFAULT '0',
  43.   `daysprune` SMALLINT(6) NOT NULL DEFAULT '0',
  44.   `dateformat` VARCHAR(4) NOT NULL DEFAULT '',
  45.   `timeformat` VARCHAR(4) NOT NULL DEFAULT '',
  46.   `timezone` VARCHAR(4) NOT NULL DEFAULT '',
  47.   `dst` int(1) NOT NULL DEFAULT '0',
  48.   `dstcorrection` int(1) NOT NULL DEFAULT '0',
  49.   `buddylist` text NOT NULL,
  50.   `ignorelist` text NOT NULL,
  51.   `style` SMALLINT(5) unsigned NOT NULL DEFAULT '0',
  52.   `away` int(1) NOT NULL DEFAULT '0',
  53.   `awaydate` int(10) unsigned NOT NULL DEFAULT '0',
  54.   `returndate` VARCHAR(15) NOT NULL DEFAULT '',
  55.   `awayreason` VARCHAR(200) NOT NULL DEFAULT '',
  56.   `pmfolders` text NOT NULL,
  57.   `notepad` text NOT NULL,
  58.   `referrer` int(10) unsigned NOT NULL DEFAULT '0',
  59.   `referrals` int(10) unsigned NOT NULL DEFAULT '0',
  60.   `reputation` bigint(30) NOT NULL DEFAULT '0',
  61.   `regip` VARCHAR(50) NOT NULL DEFAULT '',
  62.   `lastip` VARCHAR(50) NOT NULL DEFAULT '',
  63.   `longregip` int(11) NOT NULL DEFAULT '0',
  64.   `longlastip` int(11) NOT NULL DEFAULT '0',
  65.   `language` VARCHAR(50) NOT NULL DEFAULT '',
  66.   `timeonline` bigint(30) NOT NULL DEFAULT '0',
  67.   `showcodebuttons` int(1) NOT NULL DEFAULT '1',
  68.   `totalpms` int(10) NOT NULL DEFAULT '0',
  69.   `unreadpms` int(10) NOT NULL DEFAULT '0',
  70.   `warningpoints` int(3) NOT NULL DEFAULT '0',
  71.   `moderateposts` int(1) NOT NULL DEFAULT '0',
  72.   `moderationtime` bigint(30) NOT NULL DEFAULT '0',
  73.   `suspendposting` int(1) NOT NULL DEFAULT '0',
  74.   `suspensiontime` bigint(30) NOT NULL DEFAULT '0',
  75.   `suspendsignature` int(1) NOT NULL DEFAULT '0',
  76.   `suspendsigtime` bigint(30) NOT NULL DEFAULT '0',
  77.   `coppauser` int(1) NOT NULL DEFAULT '0',
  78.   `classicpostbit` int(1) NOT NULL DEFAULT '0',
  79.   `loginattempts` tinyint(2) NOT NULL DEFAULT '1',
  80.   `failedlogin` bigint(30) NOT NULL DEFAULT '0',
  81.   `usernotes` text NOT NULL,
  82.   `mysb_banned` SMALLINT(1) NOT NULL DEFAULT '0',
  83.   `mysb_banned_reason` VARCHAR(255) NOT NULL DEFAULT '',
  84.   `usemobileversion` int(1) NOT NULL DEFAULT '1',
  85.   PRIMARY KEY (`UID`),
  86.   UNIQUE KEY `username` (`username`),
  87.   KEY `usergroup` (`usergroup`),
  88.   KEY `birthday` (`birthday`),
  89.   KEY `longregip` (`longregip`),
  90.   KEY `longlastip` (`longlastip`)
  91. ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=158 ;
  92.  
  93. --
  94. -- Zrzut danych tabeli `mybb_users`
  95. --
create a new version of this paste RAW Paste Data