jGJ0YgSF

1CREATE TABLE IF NOT EXISTS `test_time_counters` (
2  `test_time_counters_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
3  `user_id` int(10) unsigned NOT NULL,
4  `problem_id` int(10) unsigned NOT NULL,
5  `test_id` int(10) unsigned NOT NULL,
6  `question_id` int(10) unsigned DEFAULT NULL,
7  `start_time` datetime DEFAULT NULL,
8  PRIMARY KEY (`test_time_counters_id`),
9  KEY `user_id` (`user_id`),
10  KEY `problem_id` (`problem_id`)
11) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
12
13ALTER TABLE `test_time_counters`
14  ADD CONSTRAINT `test_time_counters_ibfk_2` FOREIGN KEY (`problem_id`) REFERENCES `problems` (`problem_id`) ON DELETE CASCADE ON UPDATE CASCADE,
15  ADD CONSTRAINT `test_time_counters_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;