DROP TABLE IF EXISTS __shop_cart CREATE TABLE __shop_cart id int 11 NO

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
DROP TABLE IF EXISTS `#__shop_cart`;
CREATE TABLE `#__shop_cart` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`session_id` varchar(100) NOT NULL,
`item_id` int(11) NOT NULL,
`var_art_no` varchar(50) NOT NULL,
`qty` int(11) NOT NULL,
`pubdate` datetime NOT NULL,
`chars` text,
`chars_hash` varchar(32) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `session_id` (`session_id`),
KEY `chars_hash` (`chars_hash`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;