You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
ibihf/migrations/20230324224957_create_teams...

12 lines
289 B

-- Add up migration script here
CREATE TABLE IF NOT EXISTS teams (
id SERIAL PRIMARY KEY NOT NULL,
division INTEGER NOT NULL,
-- possibly add an image
image VARCHAR(255),
CONSTRAINT division_fk
FOREIGN KEY(division)
REFERENCES divisions(id)
ON DELETE RESTRICT
);