[Question] MySQL Syntax

[Avarian]

I'm hoping Talaturen will read this because he seems to be pretty good with MySQL syntax.

Anyway I started working on my AAC again that is specifically for The Forgotten Server and I need some help with adding some things to `accounts`

ALTER TABLE `accounts`
(
  	`rlname` varchar(45) NOT NULL default '',
  	`location` varchar(45) NOT NULL default '',
  	`hide` tinyint(1) NOT NULL default '0',
  	`hidemail` tinyint(1) NOT NULL default '0',

INSERT INTO `accounts` VALUES ('', '', '0', '0');

However i'm not sure how to do this, I found this site http://dev.mysql.com/doc/refman/5.0/en/alter-table.html which talks about Altering tables which is what I think I need to do but I cant figure out how to work it. So if someone could please help me or if Talaturen would like to make my life simpler just add these to theforgottendatabase in the next release.

Thanks much.

 

[Mark]

ALTER TABLE `accounts` ADD `rlname` VARCHAR( 45 ) NOT NULL DEFAULT '',
ADD `location` VARCHAR ( 45 ) NOT NULL DEFAULT '',
ADD `hide` TINYINT( 1 ) NOT NULL DEFAULT '0',
ADD `hidemail` TINYINT( 1 ) NOT NULL DEFAULT '0';

 

[Avarian]

Thanks a lot man