Untitled

CREATE TABLE character (id INT() unsigned NOT NULL auto_increment,
firstname VARCHAR(32) NOT NULL default '',
lastname VARCHAR(32) NOT NULL default '',
nickname VARCHAR(32) NOT NULL default '',
sex ENUM( "male", "female" ) NOT NULL,
age TINYINT() unsigned NOT NULL default 0,
other_phys_attribs VARCHAR(255) NOT NULL default '',
mannerisms TEXT() NOT NULL default '',
habits TEXT() NOT NULL default '',
hobbies TEXT() NOT NULL default '',
personality TEXT() NOT NULL default '',
background = TEXT() NOT NULL default '',
occupation = TEXT() NOT NULL default '',
environment = TEXT() NOT NULL default '',
angst TEXT() NOT NULL default '',
goals TEXT() NOT NULL default '',
used BOOL() default 0,
active BOOL() default 0,
PRIMARY KEY(id))