SQL-query:
Code: Select all
CREATE TABLE armor(
armor_key INT NOT NULL AUTO_INCREMENT UNSIGNED,
armor_server VARCHAR( 10 ) NOT NULL ,
armor_name VARCHAR( 250 ) NOT NULL ,
armor_level SMALLINT NOT NULL UNSIGNED,
covers TINYINT NOT NULL UNSIGNED,
craft TINYINT NOT NULL UNSIGNED,
tinks TINYINT UNSIGNED DEFAULT '0',
value SMALLINT NOT NULL UNSIGNED,
wield_meleed SMALLINT UNSIGNED,
wield_missiled SMALLINT UNSIGNED,
wield_magicd SMALLINT UNSIGNED,
act_meleed SMALLINT UNSIGNED,
act_missiled SMALLINT UNSIGNED,
act_magicd SMALLINT UNSIGNED,
act_rank SMALLINT UNSIGNED,
act_race SMALLINT UNSIGNED,
act_arcane SMALLINT UNSIGNED,
imbue TINYINT UNSIGNED,
date_posted DATETIME NOT NULL ,
date_ends DATETIME NOT NULL ,
armor_status CHAR DEFAULT '0',
seller INT NOT NULL ,
high_bidder INT NOT NULL ,
low_bidder INT NOT NULL ,
bids_total INT UNSIGNED DEFAULT '0',
low_bid SMALLINT UNSIGNED DEFAULT '0',
high_bid SMALLINT UNSIGNED DEFAULT '0',
spells VARCHAR( 250 ) ,
major1 VARCHAR( 250 ) ,
major2 VARCHAR( 250 ) ,
major3 VARCHAR( 250 ) ,
major4 VARCHAR( 250 ) ,
minor1 VARCHAR( 250 ) ,
minor2 VARCHAR( 250 ) ,
minor3 VARCHAR( 250 ) ,
minor4 VARCHAR( 250 ) ,
)I read it over and over again, but I don't see why this shouldn't work. It's probably someting very simple but I just don't see the problem... Any help is appreciated.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 'UNSIGNED,
armor_server VARCHAR(10) NOT NULL ,
armor_name
