-CREATE TABLE requests (
- id INT(11) NOT NULL AUTO_INCREMENT,
- domain INT(11) NOT NULL,
- repuri VARCHAR(255) NOT NULL,
- pct TINYINT(4) NOT NULL,
- policy TINYINT(4) NOT NULL,
- spolicy TINYINT(4) NOT NULL,
- aspf TINYINT(4) NOT NULL,
- adkim TINYINT(4) NOT NULL,
- locked TINYINT(4) NOT NULL DEFAULT '0',
- firstseen TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
- lastsent TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
- PRIMARY KEY(id)
-) ENGINE=innodb DEFAULT CHARSET=latin1;
-
--- table for tracking DKIM signature evaluation results
-CREATE TABLE signatures (
- id INT(11) NOT NULL AUTO_INCREMENT,
- message INT(11) NOT NULL,
- domain INT(11) NOT NULL,
- pass TINYINT(4) NOT NULL,
- error TINYINT(4) NOT NULL,
- PRIMARY KEY(id)
-) ENGINE=innodb DEFAULT CHARSET=latin1;
+/*Table structure for table `requests` */
+
+CREATE TABLE `requests` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `domain` int(11) NOT NULL,
+ `repuri` varchar(255) DEFAULT NULL,
+ `adkim` tinyint(4) DEFAULT NULL,
+ `aspf` tinyint(4) DEFAULT NULL,
+ `policy` tinyint(4) DEFAULT NULL,
+ `spolicy` tinyint(4) DEFAULT NULL,
+ `pct` tinyint(4) DEFAULT NULL,
+ `locked` tinyint(4) NOT NULL DEFAULT '0',
+ `firstseen` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ `lastsent` timestamp NOT NULL DEFAULT '1971-01-01 00:00:01',
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `domain` (`domain`),
+ KEY `lastsent` (`lastsent`)
+) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
+
+-- table for tracking DKIM signature
+/*Table structure for table `signatures` */
+
+CREATE TABLE `signatures` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `message` int(11) NOT NULL,
+ `domain` int(11) NOT NULL,
+ `pass` tinyint(4) NOT NULL,
+ `error` tinyint(4) NOT NULL,
+ PRIMARY KEY (`id`),
+ KEY `message` (`message`)
+) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
+
+/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
+/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
+/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
+/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;