Announcement

Collapse
No announcement yet.

Needed Certian Queries

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Needed Certian Queries

    I need the qeueries to run to make a fresh attachment table, and a fresh customavatar table. I am moving my forums and these two tables keep getting corrupted, and since they aren't of upmost important, I would just like to "reset" these tables on my new server. Thanks!

  • #2
    Straight from install.php:

    Code:
    CREATE TABLE attachment (
       attachmentid smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment,
       userid int(10) unsigned DEFAULT '0' NOT NULL,
       dateline int(10) unsigned DEFAULT '0' NOT NULL,
       filename varchar(100) NOT NULL,
       filedata mediumtext NOT NULL,
       visible smallint(5) unsigned DEFAULT '0' NOT NULL,
       counter smallint(5) unsigned DEFAULT '0' NOT NULL,
       PRIMARY KEY (attachmentid)
    )
    Code:
    CREATE TABLE customavatar (
       userid int(10) unsigned DEFAULT '0' NOT NULL,
       avatardata mediumtext NOT NULL,
       dateline int(10) unsigned DEFAULT '0' NOT NULL,
       filename CHAR(100) NOT NULL,
       PRIMARY KEY (userid)
    )
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      Thanks!

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...
      X