--- a/DB/creation.sql
+++ b/DB/creation.sql
@@ -35,15 +35,7 @@
CONSTRAINT `notificationlist_ibfk_1` FOREIGN KEY (`token`) REFERENCES `registration` (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `notificationlist`
---
-
-LOCK TABLES `notificationlist` WRITE;
-/*!40000 ALTER TABLE `notificationlist` DISABLE KEYS */;
-/*!40000 ALTER TABLE `notificationlist` ENABLE KEYS */;
-UNLOCK TABLES;
+/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
--
-- Table structure for table `registration`
@@ -59,15 +51,7 @@
PRIMARY KEY (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `registration`
---
-
-LOCK TABLES `registration` WRITE;
-/*!40000 ALTER TABLE `registration` DISABLE KEYS */;
-/*!40000 ALTER TABLE `registration` ENABLE KEYS */;
-UNLOCK TABLES;
+/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
--
-- Table structure for table `ruleslist`
@@ -79,30 +63,41 @@
CREATE TABLE `ruleslist` (
`rulesID` int(11) NOT NULL AUTO_INCREMENT,
`description` varchar(100) NOT NULL,
- `parameter` varchar(100) NOT NULL,
+ `parameter` varchar(300) NOT NULL,
`conditionValue` varchar(50) NOT NULL,
`controlValue` varchar(50) NOT NULL,
`notificationType` int(5) NOT NULL,
- `totalNotifications` bigint(50) NOT NULL,
- `totalNotificationsApplyByRules` bigint(50) NOT NULL,
- `totalValue` bigint(50) NOT NULL,
- `averageValue` varchar(50) NOT NULL,
- `percentageNotificationsApplyByRules` varchar(50) NOT NULL,
`token` varchar(100) NOT NULL,
PRIMARY KEY (`rulesID`),
KEY `token` (`token`),
CONSTRAINT `ruleslist_ibfk_1` FOREIGN KEY (`token`) REFERENCES `registration` (`token`)
-) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
+/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
--
--- Dumping data for table `ruleslist`
+-- Table structure for table `statisticslist`
--
-LOCK TABLES `ruleslist` WRITE;
-/*!40000 ALTER TABLE `ruleslist` DISABLE KEYS */;
-/*!40000 ALTER TABLE `ruleslist` ENABLE KEYS */;
-UNLOCK TABLES;
+DROP TABLE IF EXISTS `statisticslist`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `statisticslist` (
+ `statisticsID` int(11) NOT NULL AUTO_INCREMENT,
+ `date` varchar(45) NOT NULL,
+ `result` varchar(5) NOT NULL,
+ `subjectValue` varchar(10) NOT NULL,
+ `subject` varchar(50) NOT NULL,
+ `rulesID` int(11) NOT NULL,
+ PRIMARY KEY (`statisticsID`),
+ KEY `ruleslist_ibfk_1_idx` (`rulesID`),
+ CONSTRAINT `` FOREIGN KEY (`rulesID`) REFERENCES `ruleslist` (`rulesID`) ON DELETE CASCADE ON UPDATE NO ACTION
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
+
+
+
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;