[theforum] Launch deadline

Jeff Howden jeff at jeffhowden.com
Mon Apr 4 13:23:11 CDT 2005


> 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?


More information about the theforum mailing list