Evet 2. denemede unutmusum ENUM yapmayı, boylede calısmıyor ama.
Kod:
CREATE TABLE user
(
userid INT( 5 ) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT,
username VARCHAR( 12 ) NOT NULL ,
ad VARCHAR( 15 ) NOT NULL ,
soyad VARCHAR( 20 ) NOT NULL ,
sifre VARCHAR( 32 ) NOT NULL ,
eposta VARCHAR( 50 ) NOT NULL ,
sunucu ENUM( 'Locus', 'Quann' ),
class ENUM( 'Warrrior', 'Mage', 'Warlock', 'Craftman' ),
icq INT( 10 ) NOT NULL ,
msn VARCHAR( 50 ) NOT NULL ,
oturum VARCHAR( 32 ) NOT NULL ,
yetki ENUM( '0', '1', '2', '3', '4', '5' ),
guild VARCHAR( 20 ) NOT NULL ,
skill VARCHAR NOT NULL ,
PRIMARY KEY (userid)
)