Database Modifications: change to "course_attendees" #58

New Issue

EagleTrooper · 2025-12-06T23:30:52-06:00

EagleTrooper commented

2025-12-06 23:30:52 -06:00

Changes to Existing Tables Database

Training Credit is expired and cannot be used as reference for awards

ALTER TABLE `course_attendees`
	ADD COLUMN `expired` TINYINT NOT NULL DEFAULT '0' AFTER `remarks`,
	ADD COLUMN `expired_reason` VARCHAR(50) NOT NULL DEFAULT '0' AFTER `expired`;

This will allow us to mark a training as expired if someone "Retires" or "Voided" then future logic to "Award" things

## Changes to Existing Tables Database ### Training Credit is expired and cannot be used as reference for awards ```sql ALTER TABLE `course_attendees` ADD COLUMN `expired` TINYINT NOT NULL DEFAULT '0' AFTER `remarks`, ADD COLUMN `expired_reason` VARCHAR(50) NOT NULL DEFAULT '0' AFTER `expired`; ``` This will allow us to mark a training as expired if someone "Retires" or "Voided" then future logic to "Award" things

EagleTrooper changed title from ~~Database Modifications: TRACKING~~ to Database Modifications: change to "course_attendees"

2025-12-07 00:55:27 -06:00

EagleTrooper added the Database Changes label 2025-12-07 00:57:32 -06:00

Sign in to join this conversation.

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: 17th-Ranger-Battalion-ORG/milsim-site-v4#58