-- Run this once in phpMyAdmin before uploading the PHP files

ALTER TABLE `users` ADD `fampay_connected` VARCHAR(10) NOT NULL DEFAULT 'No' AFTER `mobikwik_connected`;

CREATE TABLE `fampay_tokens` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `user_token` VARCHAR(191) NOT NULL,
  `user_id` INT(11) DEFAULT NULL,
  `phoneNumber` VARCHAR(20) DEFAULT NULL,
  `upi_id` VARCHAR(191) DEFAULT NULL,
  `gmail` VARCHAR(191) DEFAULT NULL,
  `app_password` VARCHAR(191) DEFAULT NULL,
  `status` VARCHAR(20) NOT NULL DEFAULT 'Deactive',
  `date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
