· 8 years ago · Apr 19, 2018, 08:30 AM
1CREATE TABLE IF NOT EXISTS `yield_history` (
2 `yield_history_id` int(10) unsigned NOT NULL UNIQUE,
3 `product_id` int(10) NOT NULL,
4 `yield` DECIMAL(7,2) UNSIGNED NOT NULL DEFAULT '0.00',
5 `origin` varchar(200),
6 `date_create` datetime,
7 PRIMARY KEY `yield_history_id` (`yield_history_id`)
8) ENGINE=InnoDB DEFAULT CHARSET=utf8;