I am trying to execute this command on the phpmyadmin:
CREATE TABLE guilds (
id INT( 4 ) UNSIGNED NOT NULL AUTO_INCREMENT,
name VARCHAR,
shard VARCHAR,
abrev VARCHAR,
charter TEXT,
location VARCHAR,
website VARCHAR,
uosite VARCHAR,
email VARCHAR,
password CHAR( 7 ) ,
rp TINYTEXT( 1 ) ,
pk TINYTEXT( 1 ) ,
pvp TINYTEXT( 1 ) ,
faction TINYTEXT( 1 ) ,
alignment CHAR( 4 ) ,
waring CHAR( 10 )
)
But it keeps giving me this error, whatever I do:
You have an error in your SQL syntax near ' shard VARCHAR, abrev VARCHAR, charter TEXT, location VARCHAR, website' at line 1
Ehh? What the heck is that supposed to mean?