Skip to content

Instantly share code, notes, and snippets.

@raihan-uddin

raihan-uddin/gist:46cf166d9bd0f4e6632f7b510eef0be6

Last active April 25, 2022 09:55
Show Gist options
  • Save raihan-uddin/46cf166d9bd0f4e6632f7b510eef0be6 to your computer and use it in GitHub Desktop.
Save raihan-uddin/46cf166d9bd0f4e6632f7b510eef0be6 to your computer and use it in GitHub Desktop.
Download ZIP
DB.
Raw
gistfile1.txt
ALTER TABLE `employees` ADD `last_increment_date` DATE NULL DEFAULT NULL AFTER `signature_by`, ADD `last_increment_amount` DOUBLE NULL DEFAULT NULL AFTER `last_increment_date`;
ALTER TABLE `employees` CHANGE `contact_end` `contact_end` DATE NULL DEFAULT NULL;
ALTER TABLE `complain_sheet2` CHANGE `qc_remarks` `qc_remarks` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment