INSERT INTO `payment_methods` (`payment_methods_id`, `payment_method`, `status`, `environment`, `created_at`, `updated_at`) VALUES 
(NULL, 'banktransfer', '0', '0', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
(NULL, 'paystack', '0', '0', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
(NULL, 'midtrans', '1', '0', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);

INSERT INTO `payment_description` (`id`, `payment_methods_id`, `name`, `language_id`, `sub_name_1`, `sub_name_2`) VALUES 
(NULL, '9', 'Direct Bank Transfer', '1', 'Make your payment directly into our bank account. Please use your Order ID as the payment reference.', ''), 
(NULL, '10', 'Paystack', '1', '', ''),(NULL, '11', 'Midtrans', '1', '', '');

INSERT INTO `payment_methods_detail` (`id`, `payment_methods_id`, `key`, `value`) VALUES 
(NULL, '9', 'account_name', ''), 
(NULL, '9', 'account_number', ''), 
(NULL, '9', 'bank_name', ''), 
(NULL, '9', 'short_code', ''), 
(NULL, '9', 'iban', ''), 
(NULL, '9', 'swift', ''), 
(NULL, '10', 'secret_key', ''), 
(NULL, '10', 'public_key', ''), 
(NULL, '10', 'paystack_callback_url', '/paystack/verify/transaction'),
(NULL, '11', 'merchant_id', ''), 
(NULL, '11', 'server_key', ''), 
(NULL, '11', 'client_key', '');

ALTER TABLE `manufacturers` CHANGE `manufacturer_image` `manufacturer_image` VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL;

ALTER TABLE `manufacturers_info` CHANGE `manufacturers_url` `manufacturers_url` VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL;

ALTER TABLE `inventory` CHANGE `reference_code` `reference_code` VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL;


ALTER TABLE `inventory` CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP;

ALTER TABLE `products` ADD `products_video_link` TEXT NULL AFTER `products_image`;