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.
12 lines
521 B
SQL
12 lines
521 B
SQL
-- Add visibility and team_id to the drills table
|
|
ALTER TABLE drills
|
|
ADD COLUMN visibility ENUM('private', 'team', 'public') NOT NULL DEFAULT 'private',
|
|
ADD COLUMN team_id INT NULL,
|
|
ADD FOREIGN KEY (team_id) REFERENCES teams(id) ON DELETE SET NULL;
|
|
|
|
-- Add visibility and team_id to the training_sessions table
|
|
ALTER TABLE training_sessions
|
|
ADD COLUMN visibility ENUM('private', 'team', 'public') NOT NULL DEFAULT 'private',
|
|
ADD COLUMN team_id INT NULL,
|
|
ADD FOREIGN KEY (team_id) REFERENCES teams(id) ON DELETE SET NULL;
|