Sessiondata - Create Table

[Elton]

Whoops! I just dropped my Sessiondata table, instead of emptying it. What's the easiest way to recreate it, please?

[Elton]

I've muddled my way through and added a manual table, but it can't be right LOL

If anyone can tell me the proper way to drop it and create a correct one, I'd much appreciate it. I've also submitted a ticket.

[shketuljko]

Go to phpMyAdmin and just create table with this code:

CREATE TABLE `".$tbl_prefix."Sessiondata` (
	`id` char(32) collate utf8_unicode_ci NOT NULL,
	`expiry` int(10) unsigned NOT NULL default '0',
	`data` text collate utf8_unicode_ci NOT NULL,
	PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

You need to know that this code ".$tbl_prefix." you need to replace with your table prefix.