Announcement

Collapse
No announcement yet.

Needed Certian Queries

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

  • GaleForce
    replied
    Thanks!

    Leave a comment:


  • Steve Machol
    replied
    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)
    )

    Leave a comment:


  • GaleForce
    started a topic Needed Certian Queries

    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!
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X