5 lines
562 B
SQL
5 lines
562 B
SQL
INSERT INTO `coupon` (`coupon_id`, `name`, `code`, `type`, `discount`, `logged_in`, `free_shipping`, `total`, `from_date`, `to_date`, `limit`, `limit_user`, `status`, `created_at`) VALUES
|
|
(1, '-10% Discount', 'discount10', 'P', 10, 0, 0, 0.0000, '2022-05-01', '2024-05-01', 10, '10', 0, '2023-06-01 14:00:00'),
|
|
(2, 'Free Shipping', 'freeship', 'P', 0.0000, 0, 1, 100.0000, '2022-05-01', '2024-05-01', 10, '10', 0, '2023-06-01 14:00:00'),
|
|
(3, '-5.00 Discount', 'hi5', 'F', 5, 0, 0, 10.0000, '2022-05-01', '2024-05-01', 100000, '10000', 0, '2023-06-01 14:00:00');
|