[theforum] Launch deadline

[Jeff Howden]

John,

><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> From: John Handelaar
> 
> Now I need to write code to convert its ludicrous
> schema (*) into something less insane before proceeding
> to the import.
> 
> (*)  Unique numeric-only IDs for articles, users and
>      comments are stored as strings for some reason. 
>      This makes simple queries about what we already
>      have versus what changed between the 2 DB dumps
>      extremely difficult.  Specifically, for example,
>      "5" is always a *larger* value than "4999". 
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><

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?

Jeff