);
CREATE TABLE songshorttitles (
- song INTEGER NOT NULL REFERENCES song,
+ song INTEGER NOT NULL REFERENCES songs,
shorttitle VARCHAR NOT NULL,
PRIMARY KEY ( song, shorttitle ),
tournament INTEGER NOT NULL REFERENCES bigscreen.active_tournament,
round INTEGER NOT NULL,
parallel INTEGER NOT NULL,
+ last_updated TIMESTAMP NOT NULL,
PRIMARY KEY ( tournament, round, parallel ),
FOREIGN KEY ( tournament, round, parallel ) REFERENCES groups
);
-);