· 7 years ago · Jan 22, 2019, 06:32 AM
1CREATE TABLE IF NOT EXISTS `product` (
2 `product_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3 `entity_id` bigint(20) unsigned NOT NULL,
4 `name` varchar(255) NOT NULL,
5 `price` double NOT NULL DEFAULT '0',
6 PRIMARY KEY (`product_id`),
7 KEY `inx_entity_id` (`entity_id`)
8) DEFAULT CHARSET=utf8 ;