1#@!#!123s

��JFIF�� 1#@!#!123s
: / var / www / html / projects / 4petalsdemo / sql /
Filename : Queries.txt
back
26.07.2024
	ALTER TABLE `tbl_agent` ADD `agent_shop_id` INT NULL AFTER `agent_decline_details`;
	ALTER TABLE `tbl_agent` ADD `agent_shop_updated_at` DATETIME NULL AFTER `agent_shop_id`;

27.07.2024
	ALTER TABLE `tbl_agent_wallet` ADD `payment_paid_at` DATETIME NULL AFTER `payment_details`;
	
19.08.2024
	ALTER TABLE `tbl_orders` ADD `ord_alter_agent_id` INT NULL AFTER `ord_agent_id`;
	INSERT INTO `tbl_profile` (`id`, `content_title`, `content_value`, `updated_at`) VALUES (NULL, 'Checkout QR Code', NULL, NULL);
	ALTER TABLE `tbl_orders` ADD `payment_method` VARCHAR(250) NULL AFTER `ord_distance_fee`, ADD `paid_name` VARCHAR(250) NULL AFTER `payment_method`, ADD `paid_reference_no` VARCHAR(250) NULL AFTER `paid_name`, ADD `paid_amount` VARCHAR(250) NULL AFTER `paid_reference_no`;
	
04.09.2024
	ALTER TABLE `tbl_customer_otp` CHANGE `customer_id` `customer_mobile_no` VARCHAR(250) NULL DEFAULT NULL;
	ALTER TABLE `tbl_customer` ADD `google_id` TEXT NULL AFTER `customer_refer_code`, ADD `google_verified_email` TEXT NULL AFTER `google_id`, ADD `google_given_name` TEXT NULL AFTER `google_verified_email`, ADD `google_family_name` TEXT NULL AFTER `google_given_name`, ADD `google_picture` TEXT NULL AFTER `google_family_name`;
	
09.09.2024
	ALTER TABLE `tbl_orders_items` CHANGE `ord_pro_total` `ord_pro_price` TEXT NULL;
	ALTER TABLE `tbl_orders_items` CHANGE `ord_pro_id` `ord_pro_id` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL;