DROP TABLE IF EXISTS `cart`; CREATE TABLE `cart` ( `cart_id` int(11) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL DEFAULT 0, `session_id` varchar(32) NOT NULL DEFAULT '', `data` TEXT NOT NULL, `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`cart_id`), KEY `user_id` (`user_id`) );