--- a/DB/creation.sql
+++ b/DB/creation.sql
@@ -28,7 +28,7 @@
`notificationID` int(11) NOT NULL AUTO_INCREMENT,
`emailTo` varchar(100) NOT NULL,
`subject` varchar(100) NOT NULL,
- `date` varchar(50) NOT NULL,
+ `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`token` varchar(100) NOT NULL,
`ntype` int(5) NOT NULL,
PRIMARY KEY (`notificationID`),
@@ -85,7 +85,7 @@
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `statisticslist` (
`statisticsID` int(11) NOT NULL AUTO_INCREMENT,
- `date` varchar(45) NOT NULL,
+ `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`result` varchar(5) NOT NULL,
`subjectValue` varchar(10) NOT NULL,
`subject` varchar(50) NOT NULL,