I had a little time, so I’ve just created a quick sample page and added everything to Lucee 184.108.40.206 administrator, and here is the reference to complete this old post. Maybe there wasn’t any other posts, because Lucee creates the table cf_client_data “on the fly” as soon as you set a variable of scope “client” in your app for the first time. I’ve made this with MariaDB, but it still is compatible with MySQL
and here is a table creation export for a default MariaDB 10.4.10 InnoDB Engine. This is just as a reference, so you can see al the important data fields and indexes that Lucee has created.
CREATE TABLE IF NOT EXISTS `cf_client_data` (
`expires` varchar(64) NOT NULL,
`cfid` varchar(64) NOT NULL,
`name` varchar(255) NOT NULL,
`data` longtext NOT NULL,
UNIQUE KEY `ix_cf_client_data` (`cfid`,`name`,`expires`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
I’m going to add this as a contrib to Lucees documentation as soon as I can, because this is something I’ve found that is still missing in the FAQ section (@Zac_Spitzer)
Hope it helps.