82 lines
7.0 KiB
SQL
82 lines
7.0 KiB
SQL
ALTER TABLE `committees` ADD COLUMN `updated_by` INT DEFAULT NULL;
|
|
ALTER TABLE `committees` ADD FOREIGN KEY (`updated_by`) REFERENCES `users`(`id`) ON DELETE SET NULL;
|
|
ALTER TABLE `committee_plans` ADD COLUMN `created_by` INT DEFAULT NULL;
|
|
ALTER TABLE `committee_plans` ADD FOREIGN KEY (`created_by`) REFERENCES `users`(`id`) ON DELETE SET NULL;
|
|
ALTER TABLE `committee_plans` ADD COLUMN `updated_by` INT DEFAULT NULL;
|
|
ALTER TABLE `committee_plans` ADD FOREIGN KEY (`updated_by`) REFERENCES `users`(`id`) ON DELETE SET NULL;
|
|
ALTER TABLE `charity_members` ADD COLUMN `created_by` INT DEFAULT NULL;
|
|
ALTER TABLE `charity_members` ADD FOREIGN KEY (`created_by`) REFERENCES `users`(`id`) ON DELETE SET NULL;
|
|
ALTER TABLE `charity_members` ADD COLUMN `updated_by` INT DEFAULT NULL;
|
|
ALTER TABLE `charity_members` ADD FOREIGN KEY (`updated_by`) REFERENCES `users`(`id`) ON DELETE SET NULL;
|
|
ALTER TABLE `charity_plans` ADD COLUMN `created_by` INT DEFAULT NULL;
|
|
ALTER TABLE `charity_plans` ADD FOREIGN KEY (`created_by`) REFERENCES `users`(`id`) ON DELETE SET NULL;
|
|
ALTER TABLE `charity_plans` ADD COLUMN `updated_by` INT DEFAULT NULL;
|
|
ALTER TABLE `charity_plans` ADD FOREIGN KEY (`updated_by`) REFERENCES `users`(`id`) ON DELETE SET NULL;
|
|
ALTER TABLE `expenses` ADD COLUMN `created_by` INT DEFAULT NULL;
|
|
ALTER TABLE `expenses` ADD FOREIGN KEY (`created_by`) REFERENCES `users`(`id`) ON DELETE SET NULL;
|
|
ALTER TABLE `expenses` ADD COLUMN `updated_by` INT DEFAULT NULL;
|
|
ALTER TABLE `expenses` ADD FOREIGN KEY (`updated_by`) REFERENCES `users`(`id`) ON DELETE SET NULL;
|
|
ALTER TABLE `expense_categories` ADD COLUMN `created_by` INT DEFAULT NULL;
|
|
ALTER TABLE `expense_categories` ADD FOREIGN KEY (`created_by`) REFERENCES `users`(`id`) ON DELETE SET NULL;
|
|
ALTER TABLE `expense_categories` ADD COLUMN `updated_by` INT DEFAULT NULL;
|
|
ALTER TABLE `expense_categories` ADD FOREIGN KEY (`updated_by`) REFERENCES `users`(`id`) ON DELETE SET NULL;
|
|
ALTER TABLE `accounting_accounts` ADD COLUMN `created_by` INT DEFAULT NULL;
|
|
ALTER TABLE `accounting_accounts` ADD FOREIGN KEY (`created_by`) REFERENCES `users`(`id`) ON DELETE SET NULL;
|
|
ALTER TABLE `accounting_accounts` ADD COLUMN `updated_by` INT DEFAULT NULL;
|
|
ALTER TABLE `accounting_accounts` ADD FOREIGN KEY (`updated_by`) REFERENCES `users`(`id`) ON DELETE SET NULL;
|
|
ALTER TABLE `accounting_journal` ADD COLUMN `created_by` INT DEFAULT NULL;
|
|
ALTER TABLE `accounting_journal` ADD FOREIGN KEY (`created_by`) REFERENCES `users`(`id`) ON DELETE SET NULL;
|
|
ALTER TABLE `accounting_journal` ADD COLUMN `updated_by` INT DEFAULT NULL;
|
|
ALTER TABLE `accounting_journal` ADD FOREIGN KEY (`updated_by`) REFERENCES `users`(`id`) ON DELETE SET NULL;
|
|
ALTER TABLE `hr_employees` ADD COLUMN `created_by` INT DEFAULT NULL;
|
|
ALTER TABLE `hr_employees` ADD FOREIGN KEY (`created_by`) REFERENCES `users`(`id`) ON DELETE SET NULL;
|
|
ALTER TABLE `hr_employees` ADD COLUMN `updated_by` INT DEFAULT NULL;
|
|
ALTER TABLE `hr_employees` ADD FOREIGN KEY (`updated_by`) REFERENCES `users`(`id`) ON DELETE SET NULL;
|
|
ALTER TABLE `hr_attendance` ADD COLUMN `created_by` INT DEFAULT NULL;
|
|
ALTER TABLE `hr_attendance` ADD FOREIGN KEY (`created_by`) REFERENCES `users`(`id`) ON DELETE SET NULL;
|
|
ALTER TABLE `hr_attendance` ADD COLUMN `updated_by` INT DEFAULT NULL;
|
|
ALTER TABLE `hr_attendance` ADD FOREIGN KEY (`updated_by`) REFERENCES `users`(`id`) ON DELETE SET NULL;
|
|
ALTER TABLE `hr_holidays` ADD COLUMN `created_by` INT DEFAULT NULL;
|
|
ALTER TABLE `hr_holidays` ADD FOREIGN KEY (`created_by`) REFERENCES `users`(`id`) ON DELETE SET NULL;
|
|
ALTER TABLE `hr_holidays` ADD COLUMN `updated_by` INT DEFAULT NULL;
|
|
ALTER TABLE `hr_holidays` ADD FOREIGN KEY (`updated_by`) REFERENCES `users`(`id`) ON DELETE SET NULL;
|
|
ALTER TABLE `hr_leaves` ADD COLUMN `created_by` INT DEFAULT NULL;
|
|
ALTER TABLE `hr_leaves` ADD FOREIGN KEY (`created_by`) REFERENCES `users`(`id`) ON DELETE SET NULL;
|
|
ALTER TABLE `hr_leaves` ADD COLUMN `updated_by` INT DEFAULT NULL;
|
|
ALTER TABLE `hr_leaves` ADD FOREIGN KEY (`updated_by`) REFERENCES `users`(`id`) ON DELETE SET NULL;
|
|
ALTER TABLE `hr_payroll` ADD COLUMN `created_by` INT DEFAULT NULL;
|
|
ALTER TABLE `hr_payroll` ADD FOREIGN KEY (`created_by`) REFERENCES `users`(`id`) ON DELETE SET NULL;
|
|
ALTER TABLE `hr_payroll` ADD COLUMN `updated_by` INT DEFAULT NULL;
|
|
ALTER TABLE `hr_payroll` ADD FOREIGN KEY (`updated_by`) REFERENCES `users`(`id`) ON DELETE SET NULL;
|
|
ALTER TABLE `stock_items` ADD COLUMN `created_by` INT DEFAULT NULL;
|
|
ALTER TABLE `stock_items` ADD FOREIGN KEY (`created_by`) REFERENCES `users`(`id`) ON DELETE SET NULL;
|
|
ALTER TABLE `stock_items` ADD COLUMN `updated_by` INT DEFAULT NULL;
|
|
ALTER TABLE `stock_items` ADD FOREIGN KEY (`updated_by`) REFERENCES `users`(`id`) ON DELETE SET NULL;
|
|
ALTER TABLE `stock_categories` ADD COLUMN `created_by` INT DEFAULT NULL;
|
|
ALTER TABLE `stock_categories` ADD FOREIGN KEY (`created_by`) REFERENCES `users`(`id`) ON DELETE SET NULL;
|
|
ALTER TABLE `stock_categories` ADD COLUMN `updated_by` INT DEFAULT NULL;
|
|
ALTER TABLE `stock_categories` ADD FOREIGN KEY (`updated_by`) REFERENCES `users`(`id`) ON DELETE SET NULL;
|
|
ALTER TABLE `stock_stores` ADD COLUMN `created_by` INT DEFAULT NULL;
|
|
ALTER TABLE `stock_stores` ADD FOREIGN KEY (`created_by`) REFERENCES `users`(`id`) ON DELETE SET NULL;
|
|
ALTER TABLE `stock_stores` ADD COLUMN `updated_by` INT DEFAULT NULL;
|
|
ALTER TABLE `stock_stores` ADD FOREIGN KEY (`updated_by`) REFERENCES `users`(`id`) ON DELETE SET NULL;
|
|
ALTER TABLE `stock_transactions` ADD COLUMN `created_by` INT DEFAULT NULL;
|
|
ALTER TABLE `stock_transactions` ADD FOREIGN KEY (`created_by`) REFERENCES `users`(`id`) ON DELETE SET NULL;
|
|
ALTER TABLE `stock_transactions` ADD COLUMN `updated_by` INT DEFAULT NULL;
|
|
ALTER TABLE `stock_transactions` ADD FOREIGN KEY (`updated_by`) REFERENCES `users`(`id`) ON DELETE SET NULL;
|
|
ALTER TABLE `stock_lending` ADD COLUMN `created_by` INT DEFAULT NULL;
|
|
ALTER TABLE `stock_lending` ADD FOREIGN KEY (`created_by`) REFERENCES `users`(`id`) ON DELETE SET NULL;
|
|
ALTER TABLE `stock_lending` ADD COLUMN `updated_by` INT DEFAULT NULL;
|
|
ALTER TABLE `stock_lending` ADD FOREIGN KEY (`updated_by`) REFERENCES `users`(`id`) ON DELETE SET NULL;
|
|
ALTER TABLE `users` ADD COLUMN `created_by` INT DEFAULT NULL;
|
|
ALTER TABLE `users` ADD FOREIGN KEY (`created_by`) REFERENCES `users`(`id`) ON DELETE SET NULL;
|
|
ALTER TABLE `users` ADD COLUMN `updated_by` INT DEFAULT NULL;
|
|
ALTER TABLE `users` ADD FOREIGN KEY (`updated_by`) REFERENCES `users`(`id`) ON DELETE SET NULL;
|
|
ALTER TABLE `inbound_mail` ADD COLUMN `updated_by` INT DEFAULT NULL;
|
|
ALTER TABLE `inbound_mail` ADD FOREIGN KEY (`updated_by`) REFERENCES `users`(`id`) ON DELETE SET NULL;
|
|
ALTER TABLE `outbound_mail` ADD COLUMN `updated_by` INT DEFAULT NULL;
|
|
ALTER TABLE `outbound_mail` ADD FOREIGN KEY (`updated_by`) REFERENCES `users`(`id`) ON DELETE SET NULL;
|
|
ALTER TABLE `internal_mail` ADD COLUMN `updated_by` INT DEFAULT NULL;
|
|
ALTER TABLE `internal_mail` ADD FOREIGN KEY (`updated_by`) REFERENCES `users`(`id`) ON DELETE SET NULL;
|
|
ALTER TABLE `meetings` ADD COLUMN `updated_by` INT DEFAULT NULL;
|
|
ALTER TABLE `meetings` ADD FOREIGN KEY (`updated_by`) REFERENCES `users`(`id`) ON DELETE SET NULL; |