AndyJarrett

Changing UUIDs for INTs in Soundings

Soundings is a great survey app written in CFML by Ray Camden.

My only issue is that the keys are all 35 character UUID's which is fine but sucks for indexing. Below is a script which goes through the application and changes them all to INTS. (Should note that this is for MySQL tables.)

Please note this is still part 1 though. In the Soundings app itself you still need to remove the createUUID() functions if/when you want to add questions etc.

I've made the code available via Gist on github at https://gist.github.com/989931