hhamilton-src/fmrd-sql — Issue #32: Composite primary key for In/OutSubstitutions tables
Author: hhamilton-src
Created: 2011-11-16 06:07:01+00:00
State: open
Labels: Normal

In/OutSubstitutions tables do not have primary keys defined:
'''SQL
CREATE TABLE tbl_insubstitutions (
subs_id	integer REFERENCES tbl_substitutions,
lineup_id	integer	REFERENCES tbl_lineups,
) WITH OIDS;
'''

Define a composite primary key from the two foreign keys in each table.