Add Column
Current Schema
CREATE TABLE `team_selections` (
`id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
`matchday_id` integer NOT NULL,
`manager_id` integer NOT NULL,
`player_id` integer NOT NULL,
`position` text NOT NULL,
`bid_amount` real DEFAULT 0 NOT NULL,
FOREIGN KEY (`matchday_id`) REFERENCES `matchdays`(`id`) ON UPDATE no action ON DELETE no action,
FOREIGN KEY (`manager_id`) REFERENCES `managers`(`id`) ON UPDATE no action ON DELETE no action,
FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON UPDATE no action ON DELETE no action
)