Wismas  1.1
BTS SN-IR La Salle Avignon 2017
Base de données

-- -- Table structure for table `cameras` --

DROP TABLE IF EXISTS `cameras`; CREATE TABLE `cameras` ( `idCamera` int(11) unsigned NOT NULL AUTO_INCREMENT, `nom` varchar(255) DEFAULT NULL, `description` varchar(255) DEFAULT NULL, `chemin` varchar(255) DEFAULT NULL, `prefixe` varchar(255) DEFAULT NULL, `extension` varchar(16) DEFAULT NULL, `etat` int(11) DEFAULT NULL, `largeur` int(11) DEFAULT NULL, `hauteur` int(11) DEFAULT NULL, `idSite` int(11) unsigned NOT NULL, `horodatage` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`idCamera`), KEY `fk_sites_idSite1` (`idSite`), CONSTRAINT `fk_sites_idSite1` FOREIGN KEY (`idSite`) REFERENCES `sites` (`idSite`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

INSERT INTO `cameras` VALUES (1,'camera1','...','/var/www/wismas/videos','camera1','mjpg',1,640,480,1,'2017-05-03 08:00:03'),(2,'camera2','...','/var/www/wismas/videos','camera2','mjpg',1,640,480,2,'2017-05-03 08:00:03'),(3,'camera3','...','/var/www/wismas/videos','camera3','mjpg',1,640,480,3,'2017-05-03 08:00:03');

-- -- Table structure for table `hauteurNeige` --

DROP TABLE IF EXISTS `hauteurNeige`; CREATE TABLE `hauteurNeige` ( `id` mediumint(9) NOT NULL AUTO_INCREMENT, `idSite` int(11) NOT NULL, `hauteur` int(11) NOT NULL, `horodatage` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `fk_sites_idSite1` (`idSite`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

INSERT INTO `hauteurNeige` VALUES (1,2,76,'2017-05-03 08:00:03'),(2,3,63,'2017-05-03 08:00:03'),(3,1,57,'2017-05-03 08:00:03');

-- -- Table structure for table `humidite` --

DROP TABLE IF EXISTS `humidite`; CREATE TABLE `humidite` ( `id` mediumint(9) NOT NULL AUTO_INCREMENT, `idSite` mediumint(9) NOT NULL, `humidite` mediumint(9) NOT NULL, `horodatage` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

INSERT INTO `humidite` VALUES (1,1,24,'2017-05-04 09:18:15'),(2,1,36,'2017-05-04 09:18:28'),(3,3,43,'2017-05-04 10:05:16'),(4,2,24,'2017-05-04 10:05:17'),(5,2,26,'2017-05-04 10:05:34');

-- -- Table structure for table `sites` --

DROP TABLE IF EXISTS `sites`; CREATE TABLE `sites` ( `idSite` int(11) unsigned NOT NULL AUTO_INCREMENT, `nom` varchar(255) DEFAULT NULL, `etat` int(11) DEFAULT NULL, PRIMARY KEY (`idSite`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

INSERT INTO `sites` VALUES (1,'Site Alpin',1),(2,'Site Fond',1),(3,'Site Snow Kite',1);

-- -- Table structure for table `tempAir` --

DROP TABLE IF EXISTS `tempAir`; CREATE TABLE `tempAir` ( `id` mediumint(9) NOT NULL AUTO_INCREMENT, `idSite` int(11) NOT NULL, `temperature` int(11) NOT NULL, `horodatage` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

INSERT INTO `tempAir` VALUES (1,1,-16,'2017-05-03 07:29:37'),(2,2,-18,'2017-05-03 07:49:00'),(3,3,-14,'2017-05-03 07:53:34');

-- -- Table structure for table `tempNeige` --

DROP TABLE IF EXISTS `tempNeige`; CREATE TABLE `tempNeige` ( `id` mediumint(9) NOT NULL AUTO_INCREMENT, `idSite` int(11) NOT NULL, `temperature` int(11) NOT NULL, `horodatage` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

INSERT INTO `tempNeige` VALUES (1,3,-20,'2017-05-03 07:45:00'),(2,1,-16,'2017-05-03 07:46:19'),(3,2,-23,'2017-05-03 07:47:34');

 Tout Classes Fichiers Fonctions Variables Définitions de type Macros