[Summary view] [Print] [Text view]

   1  <?php
   2  /**
   3   * MyBB 1.8
   4   * Copyright 2014 MyBB Group, All Rights Reserved
   5   *
   6   * Website: http://www.mybb.com
   7   * License: http://www.mybb.com/about/license
   8   *
   9   */
  10  
  11  $tables[] = "CREATE TABLE mybb_adminlog (
  12      uid int NOT NULL default '0',
  13      ipaddress blob(16) NOT NULL default '',
  14      dateline int NOT NULL default '0',
  15      module varchar(50) NOT NULL default '',
  16      action varchar(50) NOT NULL default '',
  17      data TEXT NOT NULL
  18   );";
  19  
  20  $tables[] = "CREATE TABLE mybb_adminoptions (
  21      uid int NOT NULL default '0',
  22      cpstyle varchar(50) NOT NULL default '',
  23      cplanguage varchar(50) NOT NULL default '',
  24      codepress tinyint(1) NOT NULL default '1',
  25      notes TEXT NOT NULL,
  26      permissions TEXT NOT NULL,
  27      defaultviews TEXT NOT NULL,
  28      loginattempts smallint NOT NULL default '0',
  29      loginlockoutexpiry int NOT NULL default '0',
  30      authsecret varchar(16) NOT NULL default '',
  31      recovery_codes varchar(177) NOT NULL default ''
  32   );";
  33  
  34  $tables[] = "CREATE TABLE mybb_adminsessions (
  35      sid varchar(32) NOT NULL default '',
  36      uid int NOT NULL default '0',
  37      loginkey varchar(50) NOT NULL default '',
  38      ip blob(16) NOT NULL default '',
  39      dateline int NOT NULL default '0',
  40      lastactive int NOT NULL default '0',
  41      data TEXT NOT NULL,
  42      useragent varchar(200) NOT NULL default '',
  43      authenticated tinyint(1) NOT NULL default '0'
  44  );";
  45  
  46  $tables[] = "CREATE TABLE mybb_adminviews (
  47      vid INTEGER PRIMARY KEY,
  48      uid int(10) NOT NULL default '0',
  49      title varchar(100) NOT NULL default '',
  50      type varchar(6) NOT NULL default '',
  51      visibility tinyint(1) NOT NULL default '0',
  52      fields TEXT NOT NULL,
  53      conditions TEXT NOT NULL,
  54      custom_profile_fields TEXT NOT NULL,
  55      sortby varchar(20) NOT NULL default '',
  56      sortorder varchar(4) NOT NULL default '',
  57      perpage smallint(4) NOT NULL default '0',
  58      view_type varchar(6) NOT NULL default ''
  59  );";
  60  
  61  $tables[] = "CREATE TABLE mybb_announcements (
  62      aid INTEGER PRIMARY KEY,
  63      fid int NOT NULL default '0',
  64      uid int NOT NULL default '0',
  65      subject varchar(120) NOT NULL default '',
  66      message TEXT NOT NULL,
  67      startdate int NOT NULL default '0',
  68      enddate int NOT NULL default '0',
  69      allowhtml tinyint(1) NOT NULL default '0',
  70      allowmycode tinyint(1) NOT NULL default '0',
  71      allowsmilies tinyint(1) NOT NULL default '0'
  72  );";
  73  
  74  $tables[] = "CREATE TABLE mybb_attachments (
  75      aid INTEGER PRIMARY KEY,
  76      pid int(10) NOT NULL default '0',
  77      posthash varchar(50) NOT NULL default '',
  78      uid int NOT NULL default '0',
  79      filename varchar(255) NOT NULL default '',
  80      filetype varchar(120) NOT NULL default '',
  81      filesize int(10) NOT NULL default '0',
  82      attachname varchar(255) NOT NULL default '',
  83      downloads int NOT NULL default '0',
  84      dateuploaded int NOT NULL default '0',
  85      visible tinyint(1) NOT NULL default '0',
  86      thumbnail varchar(120) NOT NULL default ''
  87  );";
  88  
  89  $tables[] = "CREATE TABLE mybb_attachtypes (
  90      atid INTEGER PRIMARY KEY,
  91      name varchar(120) NOT NULL default '',
  92      mimetype varchar(120) NOT NULL default '',
  93      extension varchar(10) NOT NULL default '',
  94      maxsize int(15) NOT NULL default '0',
  95      icon varchar(100) NOT NULL default '',
  96      enabled tinyint(1) NOT NULL default '1',
  97      forcedownload tinyint(1) NOT NULL default '0',
  98      groups TEXT NOT NULL,
  99      forums TEXT NOT NULL,
 100      avatarfile tinyint(1) NOT NULL default '0'
 101  );";
 102  
 103  $tables[] = "CREATE TABLE mybb_awaitingactivation (
 104      aid INTEGER PRIMARY KEY,
 105      uid int NOT NULL default '0',
 106      dateline int NOT NULL default '0',
 107      code varchar(100) NOT NULL default '',
 108      type char(1) NOT NULL default '',
 109      validated tinyint(1) NOT NULL default '0',
 110      misc varchar(255) NOT NULL default ''
 111  );";
 112  
 113  $tables[] = "CREATE TABLE mybb_badwords (
 114      bid INTEGER PRIMARY KEY,
 115      badword varchar(100) NOT NULL default '',
 116      regex tinyint(1) NOT NULL default '0',
 117      replacement varchar(100) NOT NULL default ''
 118  );";
 119  
 120  $tables[] = "CREATE TABLE mybb_banfilters (
 121      fid INTEGER PRIMARY KEY,
 122      filter varchar(200) NOT NULL default '',
 123      type tinyint(1) NOT NULL default '0',
 124      lastuse int NOT NULL default '0',
 125      dateline int NOT NULL default '0'
 126  );";
 127  
 128  $tables[] = "CREATE TABLE mybb_banned (
 129      uid int NOT NULL default '0',
 130      gid int NOT NULL default '0',
 131      oldgroup int NOT NULL default '0',
 132      oldadditionalgroups TEXT NOT NULL,
 133      olddisplaygroup int NOT NULL default '0',
 134      admin int NOT NULL default '0',
 135      dateline int NOT NULL default '0',
 136      bantime varchar(50) NOT NULL default '',
 137      lifted int NOT NULL default '0',
 138      reason varchar(255) NOT NULL default ''
 139  );";
 140  
 141  $tables[] = "CREATE TABLE mybb_buddyrequests (
 142      id INTEGER PRIMARY KEY,
 143      uid int NOT NULL default '0',
 144      touid int NOT NULL default '0',
 145      date int NOT NULL default '0'
 146  );";
 147  
 148  $tables[] = "CREATE TABLE mybb_calendars (
 149      cid INTEGER PRIMARY KEY,
 150      name varchar(100) NOT NULL default '',
 151      disporder smallint NOT NULL default '0',
 152      startofweek tinyint(1) NOT NULL default '0',
 153      showbirthdays tinyint(1) NOT NULL default '0',
 154      eventlimit smallint(3) NOT NULL default '0',
 155      moderation tinyint(1) NOT NULL default '0',
 156      allowhtml tinyint(1) NOT NULL default '0',
 157      allowmycode tinyint(1) NOT NULL default '0',
 158      allowimgcode tinyint(1) NOT NULL default '0',
 159      allowvideocode tinyint(1) NOT NULL default '0',
 160      allowsmilies tinyint(1) NOT NULL default '0'
 161  );";
 162  
 163  $tables[] = "CREATE TABLE mybb_calendarpermissions (
 164      cid int NOT NULL default '0',
 165      gid int NOT NULL default '0',
 166      canviewcalendar tinyint(1) NOT NULL default '0',
 167      canaddevents tinyint(1) NOT NULL default '0',
 168      canbypasseventmod tinyint(1) NOT NULL default '0',
 169      canmoderateevents tinyint(1) NOT NULL default '0'
 170  );";
 171  
 172  $tables[] = "CREATE TABLE mybb_captcha (
 173      imagehash varchar(32) NOT NULL default '',
 174      imagestring varchar(8) NOT NULL default '',
 175      dateline int NOT NULL default '0',
 176      used tinyint(1) NOT NULL default '0'
 177  );";
 178  
 179  $tables[] = "CREATE TABLE mybb_datacache (
 180      title varchar(50) NOT NULL default '' PRIMARY KEY,
 181      cache mediumTEXT NOT NULL
 182  );";
 183  
 184  $tables[] = "CREATE TABLE mybb_delayedmoderation (
 185      did integer PRIMARY KEY,
 186      type varchar(30) NOT NULL default '',
 187      delaydateline int NOT NULL default '0',
 188      uid int(10) NOT NULL default '0',
 189      fid smallint(5) NOT NULL default '0',
 190      tids text NOT NULL,
 191      dateline int NOT NULL default '0',
 192      inputs text NOT NULL
 193  );";
 194  
 195  $tables[] = "CREATE TABLE mybb_events (
 196      eid INTEGER PRIMARY KEY,
 197      cid int NOT NULL default '0',
 198      uid int NOT NULL default '0',
 199      name varchar(120) NOT NULL default '',
 200      description TEXT NOT NULL,
 201      visible tinyint(1) NOT NULL default '0',
 202      private tinyint(1) NOT NULL default '0',
 203      dateline int(10) NOT NULL default '0',
 204      starttime int(10) NOT NULL default '0',
 205      endtime int(10) NOT NULL default '0',
 206      timezone varchar(5) NOT NULL default '',
 207      ignoretimezone tinyint(1) NOT NULL default '0',
 208      usingtime tinyint(1) NOT NULL default '0',
 209      repeats TEXT NOT NULL
 210  );";
 211  
 212  $tables[] = "CREATE TABLE mybb_forumpermissions (
 213      pid INTEGER PRIMARY KEY,
 214      fid int NOT NULL default '0',
 215      gid int NOT NULL default '0',
 216      canview tinyint(1) NOT NULL default '0',
 217      canviewthreads tinyint(1) NOT NULL default '0',
 218      canonlyviewownthreads tinyint(1) NOT NULL default '0',
 219      candlattachments tinyint(1) NOT NULL default '0',
 220      canpostthreads tinyint(1) NOT NULL default '0',
 221      canpostreplys tinyint(1) NOT NULL default '0',
 222      canonlyreplyownthreads tinyint(1) NOT NULL default '0',
 223      canpostattachments tinyint(1) NOT NULL default '0',
 224      canratethreads tinyint(1) NOT NULL default '0',
 225      caneditposts tinyint(1) NOT NULL default '0',
 226      candeleteposts tinyint(1) NOT NULL default '0',
 227      candeletethreads tinyint(1) NOT NULL default '0',
 228      caneditattachments tinyint(1) NOT NULL default '0',
 229      canviewdeletionnotice tinyint(1) NOT NULL default '0',
 230      modposts tinyint(1) NOT NULL default '0',
 231      modthreads tinyint(1) NOT NULL default '0',
 232      mod_edit_posts tinyint(1) NOT NULL default '0',
 233      modattachments tinyint(1) NOT NULL default '0',
 234      canpostpolls tinyint(1) NOT NULL default '0',
 235      canvotepolls tinyint(1) NOT NULL default '0',
 236      cansearch tinyint(1) NOT NULL default '0'
 237  );";
 238  
 239  $tables[] = "CREATE TABLE mybb_forums (
 240      fid INTEGER PRIMARY KEY,
 241      name varchar(120) NOT NULL default '',
 242      description TEXT NOT NULL,
 243      linkto varchar(180) NOT NULL default '',
 244      type char(1) NOT NULL default '',
 245      pid smallint NOT NULL default '0',
 246      parentlist TEXT NOT NULL,
 247      disporder smallint NOT NULL default '0',
 248      active tinyint(1) NOT NULL default '0',
 249      open tinyint(1) NOT NULL default '0',
 250      threads int NOT NULL default '0',
 251      posts int NOT NULL default '0',
 252      lastpost int(10) NOT NULL default '0',
 253      lastposter varchar(120) NOT NULL default '',
 254      lastposteruid int(10) NOT NULL default '0',
 255      lastposttid int(10) NOT NULL default '0',
 256      lastpostsubject varchar(120) NOT NULL default '',
 257      allowhtml tinyint(1) NOT NULL default '0',
 258      allowmycode tinyint(1) NOT NULL default '0',
 259      allowsmilies tinyint(1) NOT NULL default '0',
 260      allowimgcode tinyint(1) NOT NULL default '0',
 261      allowvideocode tinyint(1) NOT NULL default '0',
 262      allowpicons tinyint(1) NOT NULL default '0',
 263      allowtratings tinyint(1) NOT NULL default '0',
 264      usepostcounts tinyint(1) NOT NULL default '0',
 265      usethreadcounts tinyint(1) NOT NULL default '0',
 266      requireprefix tinyint(1) NOT NULL default '0',
 267      password varchar(50) NOT NULL default '',
 268      showinjump tinyint(1) NOT NULL default '0',
 269      style smallint NOT NULL default '0',
 270      overridestyle tinyint(1) NOT NULL default '0',
 271      rulestype tinyint(1) NOT NULL default '0',
 272      rulestitle varchar(200) NOT NULL default '',
 273      rules TEXT NOT NULL,
 274      unapprovedthreads int(10) NOT NULL default '0',
 275      unapprovedposts int(10) NOT NULL default '0',
 276      deletedthreads int(10) NOT NULL default '0',
 277      deletedposts int(10) NOT NULL default '0',
 278      defaultdatecut smallint(4) NOT NULL default '0',
 279      defaultsortby varchar(10) NOT NULL default '',
 280      defaultsortorder varchar(4) NOT NULL default ''
 281  );";
 282  
 283  $tables[] = "CREATE TABLE mybb_forumsread (
 284      fid int NOT NULL default '0',
 285      uid int NOT NULL default '0',
 286      dateline int(10) NOT NULL default '0'
 287  );";
 288  
 289  $tables[] = "CREATE TABLE mybb_forumsubscriptions (
 290      fsid INTEGER PRIMARY KEY,
 291      fid smallint NOT NULL default '0',
 292      uid int NOT NULL default '0'
 293  );";
 294  
 295  $tables[] = "CREATE TABLE mybb_groupleaders (
 296      lid INTEGER PRIMARY KEY,
 297      gid smallint NOT NULL default '0',
 298      uid int NOT NULL default '0',
 299      canmanagemembers tinyint(1) NOT NULL default '0',
 300      canmanagerequests tinyint(1) NOT NULL default '0',
 301      caninvitemembers tinyint(1) NOT NULL default '0'
 302  );";
 303  
 304  $tables[] = "CREATE TABLE mybb_helpdocs (
 305      hid INTEGER PRIMARY KEY,
 306      sid smallint NOT NULL default '0',
 307      name varchar(120) NOT NULL default '',
 308      description TEXT NOT NULL,
 309      document TEXT NOT NULL,
 310      usetranslation tinyint(1) NOT NULL default '0',
 311      enabled tinyint(1) NOT NULL default '0',
 312      disporder smallint NOT NULL default '0'
 313  );";
 314  
 315  $tables[] = "CREATE TABLE mybb_helpsections (
 316      sid INTEGER PRIMARY KEY,
 317      name varchar(120) NOT NULL default '',
 318      description TEXT NOT NULL,
 319      usetranslation tinyint(1) NOT NULL default '0',
 320      enabled tinyint(1) NOT NULL default '0',
 321      disporder smallint NOT NULL default '0'
 322  );";
 323  
 324  $tables[] = "CREATE TABLE mybb_icons (
 325      iid INTEGER PRIMARY KEY,
 326      name varchar(120) NOT NULL default '',
 327      path varchar(220) NOT NULL default ''
 328  );";
 329  
 330  $tables[] = "CREATE TABLE mybb_joinrequests (
 331      rid INTEGER PRIMARY KEY,
 332      uid int NOT NULL default '0',
 333      gid smallint NOT NULL default '0',
 334      reason varchar(250) NOT NULL default '',
 335      dateline int NOT NULL default '0',
 336      invite tinyint(1) NOT NULL default '0'
 337  );";
 338  
 339  $tables[] = "CREATE TABLE mybb_massemails (
 340      mid INTEGER PRIMARY KEY,
 341      uid int NOT NULL default '0',
 342      subject varchar(200) NOT NULL default '',
 343      message text NOT NULL,
 344      htmlmessage text NOT NULL,
 345      type tinyint(1) NOT NULL default '0',
 346      format tinyint(1) NOT NULL default '0',
 347      dateline int NOT NULL default '0',
 348      senddate int NOT NULL default '0',
 349      status tinyint(1) NOT NULL default '0',
 350      sentcount int NOT NULL default '0',
 351      totalcount int NOT NULL default '0',
 352      conditions text NOT NULL,
 353      perpage smallint(4) NOT NULL default '50'
 354  );";
 355  
 356  $tables[] = "CREATE TABLE mybb_mailerrors (
 357      eid INTEGER PRIMARY KEY,
 358      subject varchar(200) NOT NULL default '',
 359      message TEXT NOT NULL,
 360      toaddress varchar(150) NOT NULL default '',
 361      fromaddress varchar(150) NOT NULL default '',
 362      dateline int NOT NULL default '0',
 363      error TEXT NOT NULL,
 364      smtperror varchar(200) NOT NULL default '',
 365      smtpcode smallint(5) NOT NULL default '0'
 366  );";
 367  
 368  $tables[] = "CREATE TABLE mybb_maillogs (
 369      mid INTEGER PRIMARY KEY,
 370      subject varchar(200) not null default '',
 371      message TEXT NOT NULL,
 372      dateline int NOT NULL default '0',
 373      fromuid int NOT NULL default '0',
 374      fromemail varchar(200) not null default '',
 375      touid int NOT NULL default '0',
 376      toemail varchar(200) NOT NULL default '',
 377      tid int NOT NULL default '0',
 378      ipaddress blob(16) NOT NULL default '',
 379      type tinyint(1) NOT NULL default '0'
 380  );";
 381  
 382  $tables[] = "CREATE TABLE mybb_mailqueue (
 383      mid INTEGER PRIMARY KEY,
 384      mailto varchar(200) NOT NULL default '',
 385      mailfrom varchar(200) NOT NULL default '',
 386      subject varchar(200) NOT NULL default '',
 387      message TEXT NOT NULL,
 388      headers TEXT NOT NULL );";
 389  
 390  $tables[] = "CREATE TABLE mybb_moderatorlog (
 391      uid int NOT NULL default '0',
 392      dateline int NOT NULL default '0',
 393      fid smallint NOT NULL default '0',
 394      tid int NOT NULL default '0',
 395      pid int NOT NULL default '0',
 396      action TEXT NOT NULL,
 397      data text NOT NULL,
 398      ipaddress blob(16) NOT NULL default ''
 399  );";
 400  
 401  $tables[] = "CREATE TABLE mybb_moderators (
 402      mid INTEGER PRIMARY KEY,
 403      fid smallint NOT NULL default '0',
 404      id int NOT NULL default '0',
 405      isgroup tinyint(1) NOT NULL default '0',
 406      caneditposts tinyint(1) NOT NULL default '0',
 407      cansoftdeleteposts tinyint(1) NOT NULL default '0',
 408      canrestoreposts tinyint(1) NOT NULL default '0',
 409      candeleteposts tinyint(1) NOT NULL default '0',
 410      cansoftdeletethreads tinyint(1) NOT NULL default '0',
 411      canrestorethreads tinyint(1) NOT NULL default '0',
 412      candeletethreads tinyint(1) NOT NULL default '0',
 413      canviewips tinyint(1) NOT NULL default '0',
 414      canviewunapprove tinyint(1) NOT NULL default '0',
 415      canviewdeleted tinyint(1) NOT NULL default '0',
 416      canopenclosethreads tinyint(1) NOT NULL default '0',
 417      canstickunstickthreads tinyint(1) NOT NULL default '0',
 418      canapproveunapprovethreads tinyint(1) NOT NULL default '0',
 419      canapproveunapproveposts tinyint(1) NOT NULL default '0',
 420      canapproveunapproveattachs tinyint(1) NOT NULL default '0',
 421      canmanagethreads tinyint(1) NOT NULL default '0',
 422      canmanagepolls tinyint(1) NOT NULL default '0',
 423      canpostclosedthreads tinyint(1) NOT NULL default '0',
 424      canmovetononmodforum tinyint(1) NOT NULL default '0',
 425      canusecustomtools tinyint(1) NOT NULL default '0',
 426      canmanageannouncements tinyint(1) NOT NULL default '0',
 427      canmanagereportedposts tinyint(1) NOT NULL default '0',
 428      canviewmodlog tinyint(1) NOT NULL default '0'
 429  );";
 430  
 431  $tables[] = "CREATE TABLE mybb_modtools (
 432      tid INTEGER PRIMARY KEY,
 433      name varchar(200) NOT NULL default '',
 434      description TEXT NOT NULL,
 435      forums TEXT NOT NULL,
 436      groups TEXT NOT NULL,
 437      type char(1) NOT NULL default '',
 438      postoptions TEXT NOT NULL,
 439      threadoptions TEXT NOT NULL
 440  );";
 441  
 442  $tables[] = "CREATE TABLE mybb_mycode (
 443      cid INTEGER PRIMARY KEY,
 444      title varchar(100) NOT NULL default '',
 445      description TEXT NOT NULL,
 446      regex TEXT NOT NULL,
 447      replacement TEXT NOT NULL,
 448      active tinyint(1) NOT NULL default '0',
 449      parseorder smallint NOT NULL default '0'
 450  );";
 451  
 452  $tables[] = "CREATE TABLE mybb_polls (
 453      pid INTEGER PRIMARY KEY,
 454      tid int NOT NULL default '0',
 455      question varchar(200) NOT NULL default '',
 456      dateline int NOT NULL default '0',
 457      options TEXT NOT NULL,
 458      votes TEXT NOT NULL,
 459      numoptions smallint NOT NULL default '0',
 460      numvotes int NOT NULL default '0',
 461      timeout int NOT NULL default '0',
 462      closed tinyint(1) NOT NULL default '0',
 463      multiple tinyint(1) NOT NULL default '0',
 464      public tinyint(1) NOT NULL default '0',
 465      maxoptions smallint NOT NULL default '0'
 466  );";
 467  
 468  $tables[] = "CREATE TABLE mybb_pollvotes (
 469      vid INTEGER PRIMARY KEY,
 470      pid int NOT NULL default '0',
 471      uid int NOT NULL default '0',
 472      voteoption smallint NOT NULL default '0',
 473      dateline int NOT NULL default '0',
 474      ipaddress blob(16) NOT NULL default ''
 475  );";
 476  
 477  $tables[] = "CREATE TABLE mybb_posts (
 478      pid INTEGER PRIMARY KEY,
 479      tid int NOT NULL default '0',
 480      replyto int NOT NULL default '0',
 481      fid smallint NOT NULL default '0',
 482      subject varchar(120) NOT NULL default '',
 483      icon smallint NOT NULL default '0',
 484      uid int NOT NULL default '0',
 485      username varchar(80) NOT NULL default '',
 486      dateline int NOT NULL default '0',
 487      message TEXT NOT NULL,
 488      ipaddress blob(16) NOT NULL default '',
 489      includesig tinyint(1) NOT NULL default '0',
 490      smilieoff tinyint(1) NOT NULL default '0',
 491      edituid int NOT NULL default '0',
 492      edittime int(10) NOT NULL default '0',
 493      editreason varchar(150) NOT NULL default '',
 494      visible tinyint(1) NOT NULL default '0'
 495  );";
 496  
 497  $tables[] = "CREATE TABLE mybb_privatemessages (
 498      pmid INTEGER PRIMARY KEY,
 499      uid int NOT NULL default '0',
 500      toid int NOT NULL default '0',
 501      fromid int NOT NULL default '0',
 502      recipients TEXT NOT NULL,
 503      folder smallint NOT NULL default '1',
 504      subject varchar(120) NOT NULL default '',
 505      icon smallint NOT NULL default '0',
 506      message TEXT NOT NULL,
 507      dateline int NOT NULL default '0',
 508      deletetime int NOT NULL default '0',
 509      status tinyint(1) NOT NULL default '0',
 510      statustime int NOT NULL default '0',
 511      includesig tinyint(1) NOT NULL default '0',
 512      smilieoff tinyint(1) NOT NULL default '0',
 513      receipt tinyint(1) NOT NULL default '0',
 514      readtime int NOT NULL default '0',
 515      ipaddress blob(16) NOT NULL default ''
 516  );";
 517  
 518  $tables[] = "CREATE TABLE mybb_profilefields (
 519      fid INTEGER PRIMARY KEY,
 520      name varchar(100) NOT NULL default '',
 521      description TEXT NOT NULL,
 522      disporder smallint NOT NULL default '0',
 523      type TEXT NOT NULL,
 524      regex TEXT NOT NULL,
 525      length smallint NOT NULL default '0',
 526      maxlength smallint NOT NULL default '0',
 527      required tinyint(1) NOT NULL default '0',
 528      registration tinyint(1) NOT NULL default '0',
 529      profile tinyint(1) NOT NULL default '0',
 530      postbit tinyint(1) NOT NULL default '0',
 531      viewableby TEXT NOT NULL,
 532      editableby TEXT NOT NULL,
 533      postnum smallint NOT NULL default '0',
 534      allowhtml tinyint(1) NOT NULL default '0',
 535      allowmycode tinyint(1) NOT NULL default '0',
 536      allowsmilies tinyint(1) NOT NULL default '0',
 537      allowimgcode tinyint(1) NOT NULL default '0',
 538      allowvideocode tinyint(1) NOT NULL default '0'
 539  );";
 540  
 541  $tables[] = "CREATE TABLE mybb_promotions (
 542      pid INTEGER PRIMARY KEY,
 543      title varchar(120) NOT NULL default '',
 544      description TEXT NOT NULL,
 545      enabled tinyint(1) NOT NULL default '1',
 546      logging tinyint(1) NOT NULL default '0',
 547      posts int NOT NULL default '0',
 548      posttype varchar(2) NOT NULL default '',
 549      threads int NOT NULL default '0',
 550      threadtype varchar(2) NOT NULL default '',
 551      registered int NOT NULL default '0',
 552      registeredtype varchar(20) NOT NULL default '',
 553      online int NOT NULL default '0',
 554      onlinetype varchar(20) NOT NULL default '',
 555      reputations int NOT NULL default '0',
 556      reputationtype varchar(2) NOT NULL default '',
 557      referrals int NOT NULL default '0',
 558      referralstype varchar(2) NOT NULL default '',
 559      warnings int NOT NULL default '0',
 560      warningstype varchar(2) NOT NULL default '',
 561      requirements varchar(200) NOT NULL default '',
 562      originalusergroup varchar(120) NOT NULL default '0',
 563      newusergroup smallint NOT NULL default '0',
 564      usergrouptype varchar(120) NOT NULL default '0'
 565  );";
 566  
 567  $tables[] = "CREATE TABLE mybb_promotionlogs (
 568      plid INTEGER PRIMARY KEY,
 569      pid int NOT NULL default '0',
 570      uid int NOT NULL default '0',
 571      oldusergroup varchar(200) NOT NULL default '0',
 572      newusergroup smallint NOT NULL default '0',
 573      dateline int NOT NULL default '0',
 574      type varchar(9) NOT NULL default 'primary'
 575  );";
 576  
 577  $tables[] = "CREATE TABLE mybb_questions (
 578      qid INTEGER PRIMARY KEY,
 579      question varchar(200) NOT NULL default '',
 580      answer varchar(150) NOT NULL default '',
 581      shown int NOT NULL default 0,
 582      correct int NOT NULL default 0,
 583      incorrect int NOT NULL default 0,
 584      active tinyint(1) NOT NULL default '0'
 585  );";
 586  
 587  $tables[] = "CREATE TABLE mybb_questionsessions (
 588      sid varchar(32) NOT NULL default '',
 589      qid int NOT NULL default '0',
 590      dateline int NOT NULL default '0'
 591  );";
 592  
 593  $tables[] = "CREATE TABLE mybb_reportedcontent (
 594      rid INTEGER PRIMARY KEY,
 595      id int NOT NULL default '0',
 596      id2 int NOT NULL default '0',
 597      id3 int NOT NULL default '0',
 598      uid int NOT NULL default '0',
 599      reportstatus tinyint(1) NOT NULL default '0',
 600      reasonid smallint NOT NULL default '0',
 601      reason varchar(250) NOT NULL default '',
 602      type varchar(50) NOT NULL default '',
 603      reports int NOT NULL default '0',
 604      reporters text NOT NULL,
 605      dateline int NOT NULL default '0',
 606      lastreport int NOT NULL default '0'
 607  );";
 608  
 609  $tables[] = "CREATE TABLE mybb_reportreasons (
 610      rid INTEGER PRIMARY KEY,
 611      title varchar(250) NOT NULL default '',
 612      appliesto varchar(250) NOT NULL default '',
 613      extra tinyint(1) NOT NULL default '0',
 614      disporder smallint NOT NULL default '0'
 615  );";
 616  
 617  $tables[] = "CREATE TABLE mybb_reputation (
 618      rid INTEGER PRIMARY KEY,
 619      uid int NOT NULL default '0',
 620      adduid int NOT NULL default '0',
 621      pid int NOT NULL default '0',
 622      reputation smallint NOT NULL default '0',
 623      dateline int NOT NULL default '0',
 624      comments TEXT NOT NULL
 625  );";
 626  
 627  $tables[] = "CREATE TABLE mybb_searchlog (
 628      sid varchar(32) NOT NULL default '',
 629      uid int NOT NULL default '0',
 630      dateline int NOT NULL default '0',
 631      ipaddress blob(16) NOT NULL default '',
 632      threads LONGTEXT NOT NULL,
 633      posts LONGTEXT NOT NULL,
 634      resulttype varchar(10) NOT NULL default '',
 635      querycache TEXT NOT NULL,
 636      keywords TEXT NOT NULL
 637  );";
 638  
 639  $tables[] = "CREATE TABLE mybb_sessions (
 640      sid varchar(32) NOT NULL default '',
 641      uid int NOT NULL default '0',
 642      ip blob(16) NOT NULL default '',
 643      time int NOT NULL default '0',
 644      location varchar(150) NOT NULL default '',
 645      useragent varchar(200) NOT NULL default '',
 646      anonymous tinyint(1) NOT NULL default '0',
 647      nopermission tinyint(1) NOT NULL default '0',
 648      location1 int(10) NOT NULL default '0',
 649      location2 int(10) NOT NULL default '0'
 650  );";
 651  
 652  $tables[] = "CREATE TABLE mybb_settinggroups (
 653      gid INTEGER PRIMARY KEY,
 654      name varchar(100) NOT NULL default '',
 655      title varchar(220) NOT NULL default '',
 656      description TEXT NOT NULL,
 657      disporder smallint NOT NULL default '0',
 658      isdefault tinyint(1) NOT NULL default '0'
 659  );";
 660  
 661  $tables[] = "CREATE TABLE mybb_settings (
 662      sid INTEGER PRIMARY KEY,
 663      name varchar(120) NOT NULL default '',
 664      title varchar(120) NOT NULL default '',
 665      description TEXT NOT NULL,
 666      optionscode TEXT NOT NULL,
 667      value TEXT NOT NULL,
 668      disporder smallint NOT NULL default '0',
 669      gid smallint NOT NULL default '0',
 670      isdefault tinyint(1) NOT NULL default '0'
 671  );";
 672  
 673  $tables[] = "CREATE TABLE mybb_smilies (
 674      sid INTEGER PRIMARY KEY,
 675      name varchar(120) NOT NULL default '',
 676      find TEXT NOT NULL,
 677      image varchar(220) NOT NULL default '',
 678      disporder smallint NOT NULL default '0',
 679      showclickable tinyint(1) NOT NULL default '0'
 680  );";
 681  
 682  $tables[] = "CREATE TABLE mybb_spamlog (
 683      sid INTEGER PRIMARY KEY,
 684      username varchar(120) NOT NULL DEFAULT '',
 685      email varchar(220) NOT NULL DEFAULT '',
 686      ipaddress blob(16) NOT NULL default '',
 687      dateline int NOT NULL default '0',
 688      data TEXT NOT NULL default ''
 689  );";
 690  
 691  $tables[] = "CREATE TABLE mybb_spiders (
 692      sid INTEGER PRIMARY KEY,
 693      name varchar(100) NOT NULL default '',
 694      theme smallint NOT NULL default '0',
 695      language varchar(20) NOT NULL default '',
 696      usergroup smallint NOT NULL default '0',
 697      useragent varchar(200) NOT NULL default '',
 698      lastvisit int NOT NULL default '0'
 699  );";
 700  
 701  $tables[] = "CREATE TABLE mybb_stats (
 702      dateline int NOT NULL default '0' PRIMARY KEY,
 703      numusers int NOT NULL default '0',
 704      numthreads int NOT NULL default '0',
 705      numposts int NOT NULL default '0'
 706  );";
 707  
 708  $tables[] = "CREATE TABLE mybb_tasks (
 709      tid INTEGER PRIMARY KEY,
 710      title varchar(120) NOT NULL default '',
 711      description TEXT NOT NULL,
 712      file varchar(30) NOT NULL default '',
 713      minute varchar(200) NOT NULL default '',
 714      hour varchar(200) NOT NULL default '',
 715      day varchar(100) NOT NULL default '',
 716      month varchar(30) NOT NULL default '',
 717      weekday varchar(15) NOT NULL default '',
 718      nextrun int NOT NULL default '0',
 719      lastrun int NOT NULL default '0',
 720      enabled tinyint(1) NOT NULL default '1',
 721      logging tinyint(1) NOT NULL default '0',
 722      locked int NOT NULL default '0'
 723  );";
 724  
 725  $tables[] = "CREATE TABLE mybb_tasklog (
 726      lid INTEGER PRIMARY KEY,
 727      tid int NOT NULL default '0',
 728      dateline int NOT NULL default '0',
 729      data TEXT NOT NULL
 730  );";
 731  
 732  $tables[] = "CREATE TABLE mybb_templategroups (
 733      gid INTEGER PRIMARY KEY,
 734      prefix varchar(50) NOT NULL default '',
 735      title varchar(100) NOT NULL default '',
 736      isdefault tinyint(1) NOT NULL default '0'
 737  );";
 738  
 739  $tables[] = "CREATE TABLE mybb_templates (
 740      tid INTEGER PRIMARY KEY,
 741      title varchar(120) NOT NULL default '',
 742      template TEXT NOT NULL,
 743      sid smallint NOT NULL default '0',
 744      version varchar(20) NOT NULL default '0',
 745      status varchar(10) NOT NULL default '',
 746      dateline int(10) NOT NULL default '0'
 747  );";
 748  
 749  $tables[] = "CREATE TABLE mybb_templatesets (
 750      sid INTEGER PRIMARY KEY,
 751      title varchar(120) NOT NULL default ''
 752  );";
 753  
 754  $tables[] = "CREATE TABLE mybb_themes (
 755      tid INTEGER PRIMARY KEY,
 756      name varchar(100) NOT NULL default '',
 757      pid smallint NOT NULL default '0',
 758      def tinyint(1) NOT NULL default '0',
 759      properties TEXT NOT NULL,
 760      stylesheets TEXT NOT NULL,
 761      allowedgroups TEXT NOT NULL
 762  );";
 763  
 764  $tables[] = "CREATE TABLE mybb_themestylesheets(
 765      sid INTEGER PRIMARY KEY,
 766      name varchar(30) NOT NULL default '',
 767      tid smallint NOT NULL default '0',
 768      attachedto TEXT NOT NULL,
 769      stylesheet LONGTEXT NOT NULL,
 770      cachefile varchar(100) NOT NULL default '',
 771      lastmodified int NOT NULL default '0'
 772  );";
 773  
 774  $tables[] = "CREATE TABLE mybb_threadprefixes (
 775      pid INTEGER PRIMARY KEY,
 776      prefix varchar(120) NOT NULL default '',
 777      displaystyle varchar(200) NOT NULL default '',
 778      forums TEXT NOT NULL,
 779      groups TEXT NOT NULL
 780  );";
 781  
 782  $tables[] = "CREATE TABLE mybb_threadratings (
 783      rid INTEGER PRIMARY KEY,
 784      tid int NOT NULL default '0',
 785      uid int NOT NULL default '0',
 786      rating tinyint(1) NOT NULL default '0',
 787      ipaddress blob(16) NOT NULL default ''
 788  );";
 789  
 790  $tables[] = "CREATE TABLE mybb_threadviews (
 791      tid int NOT NULL default '0'
 792  );";
 793  
 794  $tables[] = "CREATE TABLE mybb_threads (
 795      tid INTEGER PRIMARY KEY,
 796      fid smallint NOT NULL default '0',
 797      subject varchar(120) NOT NULL default '',
 798      prefix smallint NOT NULL default '0',
 799      icon smallint NOT NULL default '0',
 800      poll int NOT NULL default '0',
 801      uid int NOT NULL default '0',
 802      username varchar(80) NOT NULL default '',
 803      dateline int NOT NULL default '0',
 804      firstpost int NOT NULL default '0',
 805      lastpost int NOT NULL default '0',
 806      lastposter varchar(120) NOT NULL default '',
 807      lastposteruid int NOT NULL default '0',
 808      views int(100) NOT NULL default '0',
 809      replies int(100) NOT NULL default '0',
 810      closed varchar(30) NOT NULL default '',
 811      sticky tinyint(1) NOT NULL default '0',
 812      numratings smallint NOT NULL default '0',
 813      totalratings smallint NOT NULL default '0',
 814      notes TEXT NOT NULL,
 815      visible tinyint(1) NOT NULL default '0',
 816      unapprovedposts int(10) NOT NULL default '0',
 817      deletedposts int(10) NOT NULL default '0',
 818      attachmentcount int(10) NOT NULL default '0',
 819      deletetime int(10) NOT NULL default '0'
 820  );";
 821  
 822  $tables[] = "CREATE TABLE mybb_threadsread (
 823      tid int NOT NULL default '0',
 824      uid int NOT NULL default '0',
 825      dateline int(10) NOT NULL default '0'
 826  );";
 827  
 828  $tables[] = "CREATE TABLE mybb_threadsubscriptions (
 829      sid INTEGER PRIMARY KEY,
 830      uid int NOT NULL default '0',
 831      tid int NOT NULL default '0',
 832      notification tinyint(1) NOT NULL default '0',
 833      dateline int NOT NULL default '0'
 834  );";
 835  
 836  $tables[] = "CREATE TABLE mybb_userfields (
 837      ufid int NOT NULL default '0',
 838      fid1 TEXT NOT NULL,
 839      fid2 TEXT NOT NULL,
 840      fid3 TEXT NOT NULL
 841  );";
 842  
 843  $tables[] = "CREATE TABLE mybb_usergroups (
 844      gid INTEGER PRIMARY KEY,
 845      type tinyint(1) NOT NULL default '2',
 846      title varchar(120) NOT NULL default '',
 847      description TEXT NOT NULL,
 848      namestyle varchar(200) NOT NULL default '{username}',
 849      usertitle varchar(120) NOT NULL default '',
 850      stars smallint(4) NOT NULL default '0',
 851      starimage varchar(120) NOT NULL default '',
 852      image varchar(120) NOT NULL default '',
 853      disporder smallint(6) NOT NULL default '0',
 854      isbannedgroup tinyint(1) NOT NULL default '0',
 855      canview tinyint(1) NOT NULL default '0',
 856      canviewthreads tinyint(1) NOT NULL default '0',
 857      canviewprofiles tinyint(1) NOT NULL default '0',
 858      candlattachments tinyint(1) NOT NULL default '0',
 859      canviewboardclosed tinyint(1) NOT NULL default '0',
 860      canpostthreads tinyint(1) NOT NULL default '0',
 861      canpostreplys tinyint(1) NOT NULL default '0',
 862      canpostattachments tinyint(1) NOT NULL default '0',
 863      canratethreads tinyint(1) NOT NULL default '0',
 864      modposts tinyint(1) NOT NULL default '0',
 865      modthreads tinyint(1) NOT NULL default '0',
 866      mod_edit_posts tinyint(1) NOT NULL default '0',
 867      modattachments tinyint(1) NOT NULL default '0',
 868      caneditposts tinyint(1) NOT NULL default '0',
 869      candeleteposts tinyint(1) NOT NULL default '0',
 870      candeletethreads tinyint(1) NOT NULL default '0',
 871      caneditattachments tinyint(1) NOT NULL default '0',
 872      canviewdeletionnotice tinyint(1) NOT NULL default '0',
 873      canpostpolls tinyint(1) NOT NULL default '0',
 874      canvotepolls tinyint(1) NOT NULL default '0',
 875      canundovotes tinyint(1) NOT NULL default '0',
 876      canusepms tinyint(1) NOT NULL default '0',
 877      cansendpms tinyint(1) NOT NULL default '0',
 878      cantrackpms tinyint(1) NOT NULL default '0',
 879      candenypmreceipts tinyint(1) NOT NULL default '0',
 880      pmquota int(3) NOT NULL default '0',
 881      maxpmrecipients int(4) NOT NULL default '5',
 882      cansendemail tinyint(1) NOT NULL default '0',
 883      cansendemailoverride tinyint(1) NOT NULL default '0',
 884      maxemails int(3) NOT NULL default '5',
 885      emailfloodtime int(3) NOT NULL default '5',
 886      canviewmemberlist tinyint(1) NOT NULL default '0',
 887      canviewcalendar tinyint(1) NOT NULL default '0',
 888      canaddevents tinyint(1) NOT NULL default '0',
 889      canbypasseventmod tinyint(1) NOT NULL default '0',
 890      canmoderateevents tinyint(1) NOT NULL default '0',
 891      canviewonline tinyint(1) NOT NULL default '0',
 892      canviewwolinvis tinyint(1) NOT NULL default '0',
 893      canviewonlineips tinyint(1) NOT NULL default '0',
 894      cancp tinyint(1) NOT NULL default '0',
 895      issupermod tinyint(1) NOT NULL default '0',
 896      cansearch tinyint(1) NOT NULL default '0',
 897      canusercp tinyint(1) NOT NULL default '0',
 898      canuploadavatars tinyint(1) NOT NULL default '0',
 899      canratemembers tinyint(1) NOT NULL default '0',
 900      canchangename tinyint(1) NOT NULL default '0',
 901      canbereported tinyint(1) NOT NULL default '0',
 902      canbeinvisible tinyint(1) NOT NULL default '1',
 903      canchangewebsite tinyint(1) NOT NULL default '1',
 904      showforumteam tinyint(1) NOT NULL default '0',
 905      usereputationsystem tinyint(1) NOT NULL default '0',
 906      cangivereputations tinyint(1) NOT NULL default '0',
 907      candeletereputations tinyint(1) NOT NULL default '0',
 908      reputationpower int NOT NULL default '0',
 909      maxreputationsday int NOT NULL default '0',
 910      maxreputationsperuser int NOT NULL default '0',
 911      maxreputationsperthread int NOT NULL default '0',
 912      candisplaygroup tinyint(1) NOT NULL default '0',
 913      attachquota int NOT NULL default '0',
 914      cancustomtitle tinyint(1) NOT NULL default '0',
 915      canwarnusers tinyint(1) NOT NULL default '0',
 916      canreceivewarnings tinyint(1) NOT NULL default '0',
 917      maxwarningsday int NOT NULL default '3',
 918      canmodcp tinyint(1) NOT NULL default '0',
 919      showinbirthdaylist tinyint(1) NOT NULL default '0',
 920      canoverridepm tinyint(1) NOT NULL default '0',
 921      canusesig tinyint(1) NOT NULL default '0',
 922      canusesigxposts int NOT NULL default '0',
 923      signofollow tinyint(1) NOT NULL default '0',
 924      edittimelimit int(4) NOT NULL default '0',
 925      maxposts int(4) NOT NULL default '0',
 926      showmemberlist tinyint(1) NOT NULL default '1',
 927      canmanageannounce tinyint(1) NOT NULL default '0',
 928      canmanagemodqueue tinyint(1) NOT NULL default '0',
 929      canmanagereportedcontent tinyint(1) NOT NULL default '0',
 930      canviewmodlogs tinyint(1) NOT NULL default '0',
 931      caneditprofiles tinyint(1) NOT NULL default '0',
 932      canbanusers tinyint(1) NOT NULL default '0',
 933      canviewwarnlogs tinyint(1) NOT NULL default '0',
 934      canuseipsearch tinyint(1) NOT NULL default '0'
 935  );";
 936  
 937  $tables[] = "CREATE TABLE mybb_users (
 938      uid INTEGER PRIMARY KEY,
 939      username varchar(120) NOT NULL default '',
 940      password varchar(120) NOT NULL default '',
 941      salt varchar(10) NOT NULL default '',
 942      loginkey varchar(50) NOT NULL default '',
 943      email varchar(220) NOT NULL default '',
 944      postnum int(10) NOT NULL default '0',
 945      threadnum int(10) NOT NULL default '0',
 946      avatar varchar(200) NOT NULL default '',
 947      avatardimensions varchar(10) NOT NULL default '',
 948      avatartype varchar(10) NOT NULL default '0',
 949      usergroup smallint NOT NULL default '0',
 950      additionalgroups varchar(200) NOT NULL default '',
 951      displaygroup smallint NOT NULL default '0',
 952      usertitle varchar(250) NOT NULL default '',
 953      regdate int NOT NULL default '0',
 954      lastactive int NOT NULL default '0',
 955      lastvisit int NOT NULL default '0',
 956      lastpost int NOT NULL default '0',
 957      website varchar(200) NOT NULL default '',
 958      icq varchar(10) NOT NULL default '',
 959      skype varchar(75) NOT NULL default '',
 960      google varchar(75) NOT NULL default '',
 961      birthday varchar(15) NOT NULL default '',
 962      birthdayprivacy varchar(4) NOT NULL default 'all',
 963      signature TEXT NOT NULL,
 964      allownotices tinyint(1) NOT NULL default '0',
 965      hideemail tinyint(1) NOT NULL default '0',
 966      subscriptionmethod tinyint(1) NOT NULL default '0',
 967      invisible tinyint(1) NOT NULL default '0',
 968      receivepms tinyint(1) NOT NULL default '0',
 969      receivefrombuddy tinyint(1) NOT NULL default '0',
 970      pmnotice tinyint(1) NOT NULL default '0',
 971      pmnotify tinyint(1) NOT NULL default '0',
 972      buddyrequestspm tinyint(1) NOT NULL default '1',
 973      buddyrequestsauto tinyint(1) NOT NULL default '0',
 974      threadmode varchar(8) NOT NULL default '',
 975      showimages tinyint(1) NOT NULL default '0',
 976      showvideos tinyint(1) NOT NULL default '0',
 977      showsigs tinyint(1) NOT NULL default '0',
 978      showavatars tinyint(1) NOT NULL default '0',
 979      showquickreply tinyint(1) NOT NULL default '0',
 980      showredirect tinyint(1) NOT NULL default '0',
 981      ppp smallint(6) NOT NULL default '0',
 982      tpp smallint(6) NOT NULL default '0',
 983      daysprune smallint(6) NOT NULL default '0',
 984      dateformat varchar(4) NOT NULL default '',
 985      timeformat varchar(4) NOT NULL default '',
 986      timezone varchar(5) NOT NULL default '',
 987      dst tinyint(1) NOT NULL default '0',
 988      dstcorrection tinyint(1) NOT NULL default '0',
 989      buddylist TEXT NOT NULL,
 990      ignorelist TEXT NOT NULL,
 991      style smallint NOT NULL default '0',
 992      away tinyint(1) NOT NULL default '0',
 993      awaydate int(10) NOT NULL default '0',
 994      returndate varchar(15) NOT NULL default '',
 995      awayreason varchar(200) NOT NULL default '',
 996      pmfolders TEXT NOT NULL,
 997      notepad TEXT NOT NULL,
 998      referrer int NOT NULL default '0',
 999      referrals int NOT NULL default '0',
1000      reputation int NOT NULL default '0',
1001      regip blob(16) NOT NULL default '',
1002      lastip blob(16) NOT NULL default '',
1003      language varchar(50) NOT NULL default '',
1004      timeonline int NOT NULL default '0',
1005      showcodebuttons tinyint(1) NOT NULL default '1',
1006      totalpms int(10) NOT NULL default '0',
1007      unreadpms int(10) NOT NULL default '0',
1008      warningpoints int(3) NOT NULL default '0',
1009      moderateposts tinyint(1) NOT NULL default '0',
1010      moderationtime int NOT NULL default '0',
1011      suspendposting tinyint(1) NOT NULL default '0',
1012      suspensiontime int NOT NULL default '0',
1013      suspendsignature tinyint(1) NOT NULL default '0',
1014      suspendsigtime int NOT NULL default '0',
1015      coppauser tinyint(1) NOT NULL default '0',
1016      classicpostbit tinyint(1) NOT NULL default '0',
1017      loginattempts smallint(2) NOT NULL default '0',
1018      loginlockoutexpiry int NOT NULL default '0',
1019      usernotes TEXT NOT NULL,
1020      sourceeditor tinyint(1) NOT NULL default '0'
1021  );";
1022  
1023  $tables[] = "CREATE TABLE mybb_usertitles (
1024      utid INTEGER PRIMARY KEY,
1025      posts int NOT NULL default '0',
1026      title varchar(250) NOT NULL default '',
1027      stars smallint(4) NOT NULL default '0',
1028      starimage varchar(120) NOT NULL default ''
1029  );";
1030  
1031  $tables[] = "CREATE TABLE mybb_warninglevels (
1032      lid INTEGER PRIMARY KEY,
1033      percentage smallint(3) NOT NULL default '0',
1034      action TEXT NOT NULL
1035  );";
1036  
1037  $tables[] = "CREATE TABLE mybb_warningtypes (
1038      tid INTEGER PRIMARY KEY,
1039      title varchar(120) NOT NULL default '',
1040      points smallint NOT NULL default '0',
1041      expirationtime int NOT NULL default '0'
1042  );";
1043  
1044  $tables[] = "CREATE TABLE mybb_warnings (
1045      wid INTEGER PRIMARY KEY,
1046      uid int NOT NULL default '0',
1047      tid int NOT NULL default '0',
1048      pid int NOT NULL default '0',
1049      title varchar(120) NOT NULL default '',
1050      points smallint NOT NULL default '0',
1051      dateline int NOT NULL default '0',
1052      issuedby int NOT NULL default '0',
1053      expires int NOT NULL default '0',
1054      expired tinyint(1) NOT NULL default '0',
1055      daterevoked int NOT NULL default '0',
1056      revokedby int NOT NULL default '0',
1057      revokereason TEXT NOT NULL,
1058      notes TEXT NOT NULL
1059  );";
1060