#### ATTENTION: You don't need to run or use this file! The install.php script does everything for you!
#
# Table structure for table `attachments`
#
CREATE TABLE {$db_prefix}attachments(
ID_ATTACH int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
ID_THUMB int( 10 ) unsigned NOT NULL default '0',
ID_MSG int( 10 ) unsigned NOT NULL default '0',
ID_MEMBER mediumint( 8 ) unsigned NOT NULL default '0',
attachmentType tinyint( 3 ) unsigned NOT NULL default '0',
filename tinytext NOT NULL ,
file_hash varchar( 40 ) NOT NULL default '',
size int( 10 ) unsigned NOT NULL default '0',
downloads mediumint( 8 ) unsigned NOT NULL default '0',
width mediumint( 8 ) unsigned NOT NULL default '0',
height mediumint( 8 ) unsigned NOT NULL default '0',
PRIMARY KEY ( ID_ATTACH ) ,
UNIQUE ID_MEMBER( ID_MEMBER, ID_ATTACH ) ,
KEY ID_MSG( ID_MSG )
) TYPE = MYISAM ;
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '{$db_prefix}attachments (
ID_ATTACH int(10) unsigned NOT NULL auto_increment,' at line 1
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '{$db_prefix}attachments (
ID_ATTACH int(10) unsigned NOT NULL auto_increment,' at line 1