· 8 years ago · Aug 04, 2018, 03:28 AM
1mysql queries to add simple prodcts in magento
2CREATE TABLE IF NOT EXISTS `product` (
3`id` int(11) NOT NULL,
4`title` text NOT NULL,
5`author` text NOT NULL,
6`isbn13` bigint(13) NOT NULL,
7`isbn10` varchar(10) NOT NULL,
8`rank` varchar(10) NOT NULL,
9`pic` varchar(25) NOT NULL,
10`price` int(10) NOT NULL,
11`publicationdate` varchar(10) NOT NULL,
12`publisher` varchar(255) NOT NULL,
13`desc1` text NOT NULL,
14`cat` varchar(25) NOT NULL
15)