[Summary view] [Print] [Text view]

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