ColdFusion8 doesn’t create Client Variable tables for MySQL

...and potentially other database types.

Tonight I installed the latest CF8 beta on my home file/web server so that I can continue development and tinkering even in the event of a catastrophe. The server is running Ubuntu and MySQL, which to be honest, means this is the first time I've had to store client variables in a MySQL database. In the past, MS SQL Server has always at least been an option, and I never bothered before.

In the event that you might need the code to create these tables, because I did, you can find it here. I gather that this is not a new development (the page I linked indicates that these instructions are for MX), but I personally would have thought that now that MySQL is an officially supported DBMS, they would have implemented such a remedial feature.

If you can't be bothered to click through, here's the code:

<cfquery datasource="mydatasource">   CREATE TABLE cdata (     cfid varchar(64) NOT NULL default '',     app varchar(64) NOT NULL default '',     data longtext NOT NULL,     PRIMARY KEY (cfid,app)   ); </cfquery> <cfquery datasource="mydatasource">   CREATE TABLE cglobal (     cfid varchar(64) NOT NULL default '',     data longtext NOT NULL,     lvisit timestamp(14) NOT NULL,     KEY cfid (cfid),     KEY lvisit (lvisit)   ); </cfquery>

in ColdFusion | Scorpio 2007-06-21 22:08