can anyone tell me if this looks ok? im doin a mysql with php site, the column types and default values im not too sure about and just wanted a 2nd opinion with someone knowin how to do this stuff hehe....

also the date and time one, is there anyway to save it as dd-mm-yyyy hh:mm:ss instead of reserve (thats all it given in the mysql manual)?

wasnt sure if those enum ones are right either, also i set everythin to not null.. such i hope again isnt bad design hehe.

thanks for any advice

Code:
CREATE TABLE user (
 	id int(11) NOT NULL auto_increment,
 	username varchar(22) NOT NULL default '',
 	password varchar(32) NOT NULL default '',
 	email varchar(155) NOT NULL default '',
 	phone int(15) NOT NULL default '0',
 	address1 text(20) NOT NULL default '',
 	address2 text(20) NOT NULL default '',
 	address3 text(20) NOT NULL default '',
 	company text(15) NOT NULL default '',
 	date_joined date NOT NULL default '0000-00-00',
 	last_act datetime NOT NULL default '0000-00-00 00:00:00',
 	status enum('Awaiting','Rejected','Accepted') NOT NULL default 'Awaiting',
 	group enum('Normal','Admin','Owner') NOT NULL default 'Normal',
 	count int(10) NOT NULL,
 	PRIMARY KEY (id)
 ) TYPE=MyISAM;
 
 CREATE TABLE article (
 	id int(11) NOT NULL auto_increment,
 	title text(40) NOT NULL default '',
 	version text(8) NOT NULL default '',
 	description text NOT NULL,
 	category text(4) NOT NULL default '',
 	date_sub date NOT NULL default '0000-00-00',
 	status enum('New','Updated') NOT NULL,
 	username varchar(22) NOT NULL default '',
 	location text NOT NULL,
 	filename text NOT NULL,
 	extension text NOT NULL,
 	count int(10) NOT NULL,
 	PRIMARY KEY (id)
 ) TYPE=MyISAM;
 
 CREATE TABLE help (
 	id int(11) NOT NULL auto_increment,
 	question text NOT NULL,
 	answer text NOT NULL,
 	PRIMARY KEY (id)
 ) TYPE=MyISAM;