virendra
04-14-2014, 07:28 AM
Create the "sessions" table:
CREATE TABLE `sessions` (
`id` CHAR(128) NOT NULL,
`set_time` CHAR(10) NOT NULL,
`data` text NOT NULL,
`session_key` CHAR(128) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
We use the CHAR datatype for fields we know the length of, as the fields "id" and "session_key" will always be 128 characters long. Using CHAR here saves on processing power.
Powered by vBulletin® Version 4.2.4 Copyright © 2025 vBulletin Solutions, Inc. All rights reserved.