Skip to content

armgit / Vvveb

Public Imported from GitHub
0

Powerful and easy to use cms to build websites, blogs or ecommerce stores.

437 B
Raw Blame
DROP TABLE IF EXISTS `cart`;

CREATE TABLE `cart` (
  `cart_id` INTEGER PRIMARY KEY AUTOINCREMENT,
  `user_id` INT 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`)
);

CREATE INDEX `cart_user_id` ON `cart` (`user_id`);
CREATE INDEX `cart_session_id` ON `cart` (`session_id`);