ALTER TABLE `karishyebackend`.`booking_transactions` 
CHANGE COLUMN `id` `id` VARCHAR(100) NOT NULL ,
CHANGE COLUMN `reference_id` `transaction_id` VARCHAR(200) NOT NULL ,
CHANGE COLUMN `amount` `totalAmount` INT NULL DEFAULT NULL ,
CHANGE COLUMN `mode` `paidAmount` INT NULL DEFAULT NULL ,
CHANGE COLUMN `from` `payment_status` ENUM('failure', 'success') NULL DEFAULT NULL ,
CHANGE COLUMN `to` `payment_type` ENUM('website', 'poojari') NULL DEFAULT NULL ,
CHANGE COLUMN `notes` `razorpay_id` VARCHAR(45) NOT NULL ,
ADD UNIQUE INDEX `transaction_id_UNIQUE` (`transaction_id` ASC) VISIBLE;
;


ALTER TABLE pujas ADD COLUMN url_name VARCHAR(255);


UPDATE `karishyebackend`.`pujas` SET `url_name` = 'naamakaranam' WHERE (`id` = '4');
UPDATE `karishyebackend`.`pujas` SET `url_name` = 'aksharabhyasam' WHERE (`id` = '6');
UPDATE `karishyebackend`.`pujas` SET `url_name` = 'gruhapravesham' WHERE (`id` = '10');
UPDATE `karishyebackend`.`pujas` SET `url_name` = 'ganapati-homam' WHERE (`id` = '16');
UPDATE `karishyebackend`.`pujas` SET `url_name` = 'satyanarayana-vratam' WHERE (`id` = '24');
UPDATE `karishyebackend`.`pujas` SET `url_name` = 'rudrabhishekam' WHERE (`id` = '132');
UPDATE `karishyebackend`.`pujas` SET `url_name` = 'navagraha-homam' WHERE (`id` = '135');
UPDATE `karishyebackend`.`pujas` SET `url_name` = 'varalakshmi-vratham' WHERE (`id` = '136');
UPDATE `karishyebackend`.`pujas` SET `url_name` = 'mangala-gowri-vratham' WHERE (`id` = '137');
UPDATE `karishyebackend`.`pujas` SET `url_name` = 'punsavanam' WHERE (`id` = '138');
UPDATE `karishyebackend`.`pujas` SET `url_name` = 'garbhaadanam' WHERE (`id` = '139');
UPDATE `karishyebackend`.`pujas` SET `url_name` = 'seemanthonayanam' WHERE (`id` = '140');
UPDATE `karishyebackend`.`pujas` SET `url_name` = 'annaprasana' WHERE (`id` = '141');
UPDATE `karishyebackend`.`pujas` SET `url_name` = 'upanayanam' WHERE (`id` = '142');
UPDATE `karishyebackend`.`pujas` SET `url_name` = 'shankusthapana' WHERE (`id` = '143');
UPDATE `karishyebackend`.`pujas` SET `url_name` = 'vaahana-pooja' WHERE (`id` = '144');
UPDATE `karishyebackend`.`pujas` SET `url_name` = 'shashtipoorthi' WHERE (`id` = '145');
UPDATE `karishyebackend`.`pujas` SET `url_name` = 'saraswathi-homam' WHERE (`id` = '146');
UPDATE `karishyebackend`.`pujas` SET `url_name` = 'lakshmi-kubera-homam' WHERE (`id` = '147');
UPDATE `karishyebackend`.`pujas` SET `url_name` = 'maha-mryutyunjaya-homam' WHERE (`id` = '148');
UPDATE `karishyebackend`.`pujas` SET `url_name` = 'ayushya-homam' WHERE (`id` = '149');
UPDATE `karishyebackend`.`pujas` SET `url_name` = 'sudarshana-homam' WHERE (`id` = '150');
UPDATE `karishyebackend`.`pujas` SET `url_name` = 'shop-office-company-opening' WHERE (`id` = '154');
UPDATE `karishyebackend`.`pujas` SET `url_name` = 'punyahavachanam' WHERE (`id` = '155');
UPDATE `karishyebackend`.`pujas` SET `url_name` = 'samvathsarikam-yajurvedulu' WHERE (`id` = '156');
UPDATE `karishyebackend`.`pujas` SET `url_name` = 'aabhdhikam-yajurvedulu' WHERE (`id` = '157');
UPDATE `karishyebackend`.`pujas` SET `url_name` = 'masikam-yajurvedulu' WHERE (`id` = '158');
UPDATE `karishyebackend`.`pujas` SET `url_name` = 'ganesha-for-navaratri-pandals' WHERE (`id` = '167');
UPDATE `karishyebackend`.`pujas` SET `url_name` = 'ganesha-chaturdhi-kit-river-ganesha-10-inch' WHERE (`id` = '168');
UPDATE `karishyebackend`.`pujas` SET `url_name` = 'aabhdhikam-three-bhotha' WHERE (`id` = '169');
UPDATE `karishyebackend`.`pujas` SET `url_name` = 'samvathsarikam' WHERE (`id` = '171');
UPDATE `karishyebackend`.`pujas` SET `url_name` = 'chandi-homam' WHERE (`id` = '172');
UPDATE `karishyebackend`.`pujas` SET `url_name` = 'dasa-danaalu' WHERE (`id` = '173');
UPDATE `karishyebackend`.`pujas` SET `url_name` = 'aabhdhikam-one-bhoktha' WHERE (`id` = '175');
UPDATE `karishyebackend`.`pujas` SET `url_name` = 'masikam' WHERE (`id` = '176');
UPDATE `karishyebackend`.`pujas` SET `url_name` = 'vinayaka-vratham' WHERE (`id` = '178');
UPDATE `karishyebackend`.`pujas` SET `url_name` = 'paashupatha-homam' WHERE (`id` = '179');
UPDATE `karishyebackend`.`pujas` SET `url_name` = 'durga-puja' WHERE (`id` = '181');
UPDATE `karishyebackend`.`pujas` SET `url_name` = 'ganesh-puja' WHERE (`id` = '182');
UPDATE `karishyebackend`.`pujas` SET `url_name` = 'saraswathi-pooja-for-kids' WHERE (`id` = '183');
UPDATE `karishyebackend`.`pujas` SET `url_name` = 'pooja-samagri-only' WHERE (`id` = '184');
UPDATE `karishyebackend`.`pujas` SET `url_name` = 'samagri-only' WHERE (`id` = '186');
UPDATE `karishyebackend`.`pujas` SET `url_name` = 'aarogya-pasupatha-parayanam-and-homam' WHERE (`id` = '187');
UPDATE `karishyebackend`.`pujas` SET `url_name` = 'bhuvaneswari-shanthi-pooja' WHERE (`id` = '188');
UPDATE `karishyebackend`.`pujas` SET `url_name` = 'pooja-samagri' WHERE (`id` = '189');
UPDATE `karishyebackend`.`pujas` SET `url_name` = 'kedareswara-vratham' WHERE (`id` = '190');
UPDATE `karishyebackend`.`pujas` SET `url_name` = 'pooja-samagri' WHERE (`id` = '191');
UPDATE `karishyebackend`.`pujas` SET `url_name` = 'narayana-bali' WHERE (`id` = '192');
UPDATE `karishyebackend`.`pujas` SET `url_name` = 'gummam-pooja' WHERE (`id` = '193');
UPDATE `karishyebackend`.`pujas` SET `url_name` = 'vasthu-pooja' WHERE (`id` = '194');
UPDATE `karishyebackend`.`pujas` SET `url_name` = 'lakshmi-ganapathi-homam' WHERE (`id` = '195');
UPDATE `karishyebackend`.`pujas` SET `url_name` = 'masikam-one-bhoktha' WHERE (`id` = '196');
UPDATE `karishyebackend`.`pujas` SET `url_name` = 'marriage-engagement' WHERE (`id` = '197');
UPDATE `karishyebackend`.`pujas` SET `url_name` = 'marriage-groom' WHERE (`id` = '198');
UPDATE `karishyebackend`.`pujas` SET `url_name` = 'marriage-bride' WHERE (`id` = '199');