oc_cart table missi…
 
Notifications
Clear all

oc_cart table missing

1 Posts
1 Users
0 Reactions
204 Views
(@cipher5)
Posts: 152
Member Admin
Topic starter
 

[URL] https://forum.opencart.com/viewtopic.php?t=152661 [/URL]

[COLOR=#000000][FONT=&amp]Just need to create a SQL query from installation opencart.sql in database with phpmyadmin etc.

[/FONT][/COLOR] https://github.com/opencart/opencart/issues/3424 [COLOR=#000000][FONT=&amp]
[/FONT][/COLOR][COLOR=#000000][FONT=&amp]

[/FONT][/COLOR]SET sql_mode = ”;


— Table structure for table `oc_api`

DROP TABLE IF EXISTS `oc_api`;
CREATE TABLE `oc_api` (
`api_id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(64) NOT NULL,
`key` text NOT NULL,
`status` tinyint(1) NOT NULL,
`date_added` datetime NOT NULL,
`date_modified` datetime NOT NULL,
PRIMARY KEY (`api_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

— ——————————————————–


— Table structure for table `oc_api_ip`

DROP TABLE IF EXISTS `oc_api_ip`;
CREATE TABLE `oc_api_ip` (
`api_ip_id` int(11) NOT NULL AUTO_INCREMENT,
`api_id` int(11) NOT NULL,
`ip` varchar(40) NOT NULL,
PRIMARY KEY (`api_ip_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

— ——————————————————–


— Table structure for table `oc_api_session`

DROP TABLE IF EXISTS `oc_api_session`;
CREATE TABLE `oc_api_session` (
`api_session_id` int(11) NOT NULL AUTO_INCREMENT,
`api_id` int(11) NOT NULL,
`token` varchar(32) NOT NULL,
`session_id` varchar(32) NOT NULL,
`session_name` varchar(32) NOT NULL,
`ip` varchar(40) NOT NULL,
`date_added` datetime NOT NULL,
`date_modified` datetime NOT NULL,
PRIMARY KEY (`api_session_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;


— Table structure for table `oc_cart`

DROP TABLE IF EXISTS `oc_cart`;
CREATE TABLE `oc_cart` (
`cart_id` int(11) NOT NULL AUTO_INCREMENT,
`customer_id` int(11) NOT NULL,
`session_id` varchar(32) NOT NULL,
`product_id` int(11) NOT NULL,
`recurring_id` int(11) NOT NULL,
`option` text NOT NULL,
`quantity` int(5) NOT NULL,
`date_added` datetime NOT NULL,
PRIMARY KEY (`cart_id`),
KEY `cart_id` (`customer_id`,`session_id`,`product_id`,`recurring_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;


— Table structure for table `oc_customer_wishlist`

DROP TABLE IF EXISTS `oc_customer_wishlist`;
CREATE TABLE `oc_customer_wishlist` (
`customer_id` int(11) NOT NULL,
`product_id` int(11) NOT NULL,
`date_added` datetime NOT NULL,
PRIMARY KEY (`customer_id`,`product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

ALTER TABLE `oc_customer` CHANGE COLUMN `token` `token` text NOT NULL;

DROP TABLE IF EXISTS `oc_customer_ban_ip`;

 
Posted : 25/03/2022 1:26 pm
Share: