1#@!#!123s

��JFIF�� 1#@!#!123s

: / var / www / html / projects / projects_ilium / db /

Filename : Queries - Mani.txt

back

15.07.2024
	ALTER TABLE `user` ADD `deleted` INT NOT NULL COMMENT '0 - No, 1 - Yes' AFTER `updated_at`, ADD `deleted_by` INT NULL AFTER `deleted`, ADD `deleted_at` DATETIME NULL AFTER `deleted_by`;
	ALTER TABLE `user` ADD `user_type` INT NOT NULL COMMENT '1 - Admin, 2 - Usere' AFTER `status`;
	ALTER TABLE `user` ADD `user_reporting_manage` INT NULL AFTER `user_role`;

12.09.2024
	ALTER TABLE `employee` DROP `crp_name`;
	ALTER TABLE `employee` DROP `crp_number`;
	ALTER TABLE `employee` DROP `crp_issue_date`;
	ALTER TABLE `employee` DROP `crp_expiry_date`;