Avarian
Bring Out Your Dead!
For my AAC i'm working on I need people to upload an SQL file that will add the following into `accounts`
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.
Code:
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.