· 9 years ago · Jan 16, 2017, 01:26 PM
1 -- Adminer 4.2.5 MySQL dump
2
3SET NAMES utf8;
4SET time_zone = '+00:00';
5SET foreign_key_checks = 0;
6SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
7
8SET NAMES utf8mb4;
9
10DROP TABLE IF EXISTS `GLADOM`;
11CREATE TABLE `GLADOM` (
12 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
13 `nb_point_graph` int(10) unsigned NOT NULL,
14 `alertes` int(11) NOT NULL,
15 PRIMARY KEY (`id`)
16) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
17
18
19DROP TABLE IF EXISTS `LACK`;
20CREATE TABLE `LACK` (
21 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
22 `temp_piscine` double DEFAULT NULL,
23 `temp_domes` double DEFAULT NULL,
24 `temp_ext` double DEFAULT NULL,
25 `ph` double DEFAULT NULL,
26 `chlore` double DEFAULT NULL,
27 PRIMARY KEY (`id`)
28) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
29
30
31-- 2016-12-18 23:13:33