[theforum] Launch deadline

[William Anderson]

Jeff Howden wrote:
> [snip]
> 
> Are you saying the dump I gave you had the primary keys stored as strings?
> Or, was that a result of porting it to MySQL?  Is there any reason you can't
> just go into the MySQL schema, edit the relevant tables, and change the
> datatype to numeric?

ALTER TABLE tablename MODIFY fieldname TYPE; ought to do it

i.e ALTER TABLE users MODIFY id INT(11) TYPE;

cf http://dev.mysql.com/doc/mysql/en/alter-table.html

-- 
_ __/|  William Anderson      | "There's something about records which is
\`O_o'  neuro at well dot com |  really satisfying."
=(_ _)= http://neuro.me.uk/   |     -- John Peel (1939 - 2004)
   U  - Thhbt! GPG 0xFA5F1100 |