CREATE TABLE `sps_vendors` (
  `vendor_id` bigint(20) NOT NULL,
  `vendor_name` varchar(50) NOT NULL,
  `vendor_access_token` varchar(245) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

ALTER TABLE `sps_vendors`
  ADD PRIMARY KEY (`vendor_id`);

ALTER TABLE `sps_vendors`
  MODIFY `vendor_id` bigint(20) NOT NULL AUTO_INCREMENT;

ALTER TABLE `sps_vouchers` ADD `vendor_id` BIGINT(20) NULL DEFAULT NULL AFTER `status`;