1
2
3
4
5
6
7
8
9

CREATE TABLE `resp_freq` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `rn_id` int(10) unsigned NOT NULL,
  `email` varchar(245) CHARACTER SET ascii NOT NULL,
  `num` int(11) DEFAULT '0',
  `time_resp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `rn_id` (`rn_id`,`email`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

CREATE TABLE `resp_freq` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `rn_id` int(10) unsigned NOT NULL, `email` varchar(245) CHARACTER SET ascii NOT NULL, `num` int(11) DEFAULT '0', `time_resp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `rn_id` (`rn_id`,`email`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1