ALTER TABLE `tw_payments` ADD `payment_method` VARCHAR(150) NULL DEFAULT NULL AFTER `payment_status_id`;

CREATE TABLE `tw_payment_method` (
  `payment_method_id` int(11) NOT NULL,
  `payment_method` varchar(150) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

ALTER TABLE `tw_payment_method`
  ADD PRIMARY KEY (`payment_method_id`);

ALTER TABLE `tw_payment_method`
  MODIFY `payment_method_id` int(11) NOT NULL AUTO_INCREMENT;

INSERT INTO `tw_payment_method` (`payment_method_id`, `payment_method`) VALUES
(1, 'Bank'),
(2, 'Card'),
(3, 'Cash'),
(4, 'Others');

CREATE TABLE `tw_payment_setting` (
  `payment_setting_id` int(11) NOT NULL,
  `publickey` text,
  `secretkey` text,
  `payment_method` varchar(100) DEFAULT NULL,
  `isenable` tinyint(4) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

ALTER TABLE `tw_payment_setting`
  ADD PRIMARY KEY (`payment_setting_id`);

ALTER TABLE `tw_payment_setting`
  MODIFY `payment_setting_id` int(11) NOT NULL AUTO_INCREMENT;

UPDATE `tw_payments` SET `payment_method` = 'Bank';

INSERT INTO `tw_labels` (`label_index`, `label`) VALUES ('Stripe Setting', 'Stripe Setting');
INSERT INTO `tw_labels` (`label_index`, `label`) VALUES ('Stripe Key', 'Stripe Key');
INSERT INTO `tw_labels` (`label_index`, `label`) VALUES ('Stripe Secret', 'Stripe Secret');
INSERT INTO `tw_labels` (`label_index`, `label`) VALUES ('Payment Method', 'Payment Method');
INSERT INTO `tw_labels` (`label_index`, `label`) VALUES ('Enter your card information', 'Enter your card information');
INSERT INTO `tw_labels` (`label_index`, `label`) VALUES ('Card Information', 'Card Information');
INSERT INTO `tw_labels` (`label_index`, `label`) VALUES ('Name on Card', 'Name on Card');
INSERT INTO `tw_labels` (`label_index`, `label`) VALUES ('Click here', 'Click here');
INSERT INTO `tw_labels` (`label_index`, `label`) VALUES ('Please provide stripe information', 'Please provide stripe information');
INSERT INTO `tw_labels` (`label_index`, `label`) VALUES ('Please type valid card number', 'Please type valid card number');