All pastes #510996 Raw Edit

Someone

public text v1 · immutable
#510996 ·published 2007-05-26 05:55 UTC
rendered paste body
CREATE TABLE `samosa_assoc_elections_races` (\n  `assoc_id` mediumint(8) unsigned NOT NULL auto_increment,\n  `election_id` mediumint(8) unsigned NOT NULL,\n  `race_id` mediumint(8) unsigned NOT NULL,\n  PRIMARY KEY  (`assoc_id`),\n  UNIQUE KEY `race_id` (`race_id`),\n  UNIQUE KEY `election_id` (`election_id`,`race_id`),\n  CONSTRAINT `samosa_assoc_elections_races_ibfk_4` FOREIGN KEY (`race_id`) REFERENCES `samosa_races` (`race_id`) ON DELETE CASCADE ON UPDATE CASCADE,\n  CONSTRAINT `samosa_assoc_elections_races_ibfk_3` FOREIGN KEY (`election_id`) REFERENCES `samosa_elections` (`election_id`) ON DELETE CASCADE ON UPDATE CASCADE\n) ENGINE=InnoDB DEFAULT CHARSET=utf8