· 8 years ago · Apr 07, 2018, 11:40 AM
1id | active | group | name | description | price | ...
21 | 1 | A | T-Shirt white | This is a.. | 9.90 | ...
32 | 1 | A | T-Shirt Black | This is a.. | 9.90 | ...
43 | 1 | B | Hat yellow | This is a.. | 9.90 | ...
54 | 1 | B | Hat red | This is a.. | 9.90 | ...
65 | 1 | null | Custom dress | This is a.. | 9.90 | ...
76 | 1 | null | Belt | This is a.. | 9.90 | ...
8
9CREATE TABLE IF NOT EXISTS `product` (
10 `id` int(11) NOT NULL AUTO_INCREMENT,
11 `active` tinyint(1) NOT NULL DEFAULT '0',
12 `group` varchar(10) DEFAULT NULL,
13 `name` varchar(250) NOT NULL,
14 `description` longtext NOT NULL,
15 `price` decimal(10,2) NOT NULL,
16 PRIMARY KEY (`id`),
17);