TEXT   18

TaxInsert

Guest on 22nd August 2022 07:41:07 AM

  1. INSERT INTO `sps_tax` (`id`, `label`, `percentage`, `calculation_base`, `area_id`, `location_id`, `created_by`, `updated_by`, `created_at`, `updated_at`, `deleted_at`, `old_id`, `superadmin`, `sync_at`) VALUES (NULL, 'Base Fare', '', '', '', '', '', '', CURRENT_TIMESTAMP, '0000-00-00 00:00:00.000000', NULL, '', '', NULL);
  2.  
  3. ALTER TABLE `sps_transactions` CHANGE `foc` `out_foc` TINYINT(3) NULL DEFAULT NULL, CHANGE `foc_reason` `out_foc_reason` BIGINT(20) NULL DEFAULT NULL, CHANGE `foc_approval` `out_foc_approval` INT(20) NULL DEFAULT NULL, CHANGE `foc_note` `out_foc_note` MEDIUMTEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL;
  4.  
  5. ALTER TABLE `sps_transactions` ADD `in_foc` TINYINT NULL AFTER `in_foc_difference`, ADD `in_foc_reason` BIGINT NULL AFTER `in_foc`, ADD `in_foc_approval` BIGINT NULL AFTER `in_foc_reason`, ADD `in_foc_note` MEDIUMTEXT NULL AFTER `in_foc_approval`;

Raw Paste


Login or Register to edit or fork this paste. It's free.