d076708932
- Redesigned the main page with a modern look and feel. - Added search and filtering functionality for drills. - Implemented pagination for browsing drills. - Added the ability for users to mark drills as favorites.
10 lines
388 B
SQL
10 lines
388 B
SQL
|
|
CREATE TABLE IF NOT EXISTS `training_session_drills` (
|
|
`session_id` INT NOT NULL,
|
|
`drill_id` INT NOT NULL,
|
|
`sequence` INT NOT NULL DEFAULT 0,
|
|
PRIMARY KEY (`session_id`, `drill_id`),
|
|
FOREIGN KEY (`session_id`) REFERENCES `training_sessions`(`id`) ON DELETE CASCADE,
|
|
FOREIGN KEY (`drill_id`) REFERENCES `drills`(`id`) ON DELETE CASCADE
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
|