Unless things have changed with mySQL you have to hand-create the
tables. You'll also have to manually fire up the drivers and dsn as
was described earlier.
I just went to my server and read out my table stru via SQLYog. Here
it is. Note the myISAM table type. Note also the lack of a primary
key in the cglobal table. These tables were brought in from a mySQL
4.x installation, and before that they were generated by CF
automatically in another platform and then imported into mySQL.
CREATE TABLE `cdata` (
`cfid` varchar(64) NOT NULL default '',
`app` varchar(64) NOT NULL,
`data` longtext NOT NULL,
PRIMARY KEY (`cfid`,`app`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
CREATE TABLE `cglobal` (
`cfid` varchar(64) NOT NULL default '',
`data` longtext NOT NULL,
`lvisit` timestamp NOT NULL default CURRENT_TIMESTAMP on
update CURRENT_TIMESTAMP,
KEY `cfid` (`cfid`,`lvisit`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
--
[EMAIL PROTECTED]
Janitor, The Robertson Team
mysecretbase.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272608
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
