CREATE TABLE `orders_items` ( | |
`id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
`order_id` int(10) unsigned NOT NULL, | |
`product_id` int(10) unsigned NOT NULL, | |
`product_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00', | |
`quantity` int(10) unsigned NOT NULL DEFAULT 1, | |
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, | |
`updated_at` varchar(45) NOT NULL DEFAULT 'CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP', | |
PRIMARY KEY (`id`) | |
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment