[ Index ]

PHP Cross Reference of MyBB 1.8.29

title

Body

[close]

/install/resources/ -> pgsql_db_tables.php (source)

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


2005 - 2021 © MyBB.de | Alle Rechte vorbehalten! | Sponsor: netcup Cross-referenced by PHPXref