{ "query": "-- phpMyAdmin SQL Dump\n-- version 5.0.0-dev\n-- https://www.phpmyadmin.net/\n--\n-- Hôte : xxxx.xxxxx.eu-west-1.rds.amazonaws.com\n-- Généré le : mer. 05 sep. 2018 à 00:03\n-- Version du serveur : 10.0.24-MariaDB\n-- Version de PHP : 7.2.8-1+ubuntu18.04.1+deb.sury.org+1\n\nSET SQL_MODE = \"NO_AUTO_VALUE_ON_ZERO\";\nSET AUTOCOMMIT = 0;\nSTART TRANSACTION;\nSET time_zone = \"+00:00\";\n\n\n/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;\n/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;\n/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;\n/*!40101 SET NAMES utf8mb4 */;\n\n--\n-- Base de données : `xxxxxdbnamexxxxx`\n--\n\n-- --------------------------------------------------------\n\n--\n-- Structure de la table `monitoring__times`\n--\n\nCREATE TABLE `monitoring__times` (\n `idServer` int(11) UNSIGNED NOT NULL COMMENT 'Id of server',\n `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Time UTC',\n `totalTime` float UNSIGNED NOT NULL COMMENT 'Total time in ms'\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\n\n--\n-- Déclencheurs `monitoring__times`\n--\nDELIMITER $$\nCREATE TRIGGER `copyTimes` AFTER INSERT ON `monitoring__times` FOR EACH ROW INSERT INTO monitoring__times_mirror\n(`idServer`, `time`, `totalTime`) VALUES(new.idServer, new.time, new.totalTime)\n$$\nDELIMITER ;\nDELIMITER $$\nCREATE TRIGGER `deleteTimes` AFTER DELETE ON `monitoring__times` FOR EACH ROW DELETE FROM monitoring__times_mirror\nWHERE `idServer`=old.idServer\nAND `time`=old.time\nAND `totalTime`=old.totalTime\n$$\nDELIMITER ;\nDELIMITER $$\nCREATE TRIGGER `updateTimes` AFTER UPDATE ON `monitoring__times` FOR EACH ROW UPDATE monitoring__times_mirror\nSET `idServer`=new.idServer,\n`time`=new.time,\n`totalTime`=new.totalTime\nWHERE `idServer`=old.idServer\nAND `time`=old.time\nAND `totalTime`=old.totalTime\n$$\nDELIMITER ;\n\n--\n-- Index pour les tables déchargées\n--\n\n--\n-- Index pour la table `monitoring__times`\n--\nALTER TABLE `monitoring__times`\n ADD UNIQUE KEY `idServer` (`idServer`,`time`) USING BTREE COMMENT 'Unique idServer/time',\n ADD KEY `INDEX_totalTime` (`totalTime`) USING BTREE COMMENT 'Index for totalTime column';\n\n--\n-- Contraintes pour les tables déchargées\n--\n\n--\n-- Contraintes pour la table `monitoring__times`\n--\nALTER TABLE `monitoring__times`\n ADD CONSTRAINT `monitoring__times__idServer` FOREIGN KEY (`idServer`) REFERENCES `monitoring__servers` (`id`);\nCOMMIT;\n\n/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;\n/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;\n/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;\n", "lexer": { "@type": "PhpMyAdmin\\SqlParser\\Lexer", "str": { "@type": "PhpMyAdmin\\SqlParser\\UtfString", "str": "-- phpMyAdmin SQL Dump\n-- version 5.0.0-dev\n-- https://www.phpmyadmin.net/\n--\n-- Hôte : xxxx.xxxxx.eu-west-1.rds.amazonaws.com\n-- Généré le : mer. 05 sep. 2018 à 00:03\n-- Version du serveur : 10.0.24-MariaDB\n-- Version de PHP : 7.2.8-1+ubuntu18.04.1+deb.sury.org+1\n\nSET SQL_MODE = \"NO_AUTO_VALUE_ON_ZERO\";\nSET AUTOCOMMIT = 0;\nSTART TRANSACTION;\nSET time_zone = \"+00:00\";\n\n\n/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;\n/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;\n/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;\n/*!40101 SET NAMES utf8mb4 */;\n\n--\n-- Base de données : `xxxxxdbnamexxxxx`\n--\n\n-- --------------------------------------------------------\n\n--\n-- Structure de la table `monitoring__times`\n--\n\nCREATE TABLE `monitoring__times` (\n `idServer` int(11) UNSIGNED NOT NULL COMMENT 'Id of server',\n `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Time UTC',\n `totalTime` float UNSIGNED NOT NULL COMMENT 'Total time in ms'\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\n\n--\n-- Déclencheurs `monitoring__times`\n--\nDELIMITER $$\nCREATE TRIGGER `copyTimes` AFTER INSERT ON `monitoring__times` FOR EACH ROW INSERT INTO monitoring__times_mirror\n(`idServer`, `time`, `totalTime`) VALUES(new.idServer, new.time, new.totalTime)\n$$\nDELIMITER ;\nDELIMITER $$\nCREATE TRIGGER `deleteTimes` AFTER DELETE ON `monitoring__times` FOR EACH ROW DELETE FROM monitoring__times_mirror\nWHERE `idServer`=old.idServer\nAND `time`=old.time\nAND `totalTime`=old.totalTime\n$$\nDELIMITER ;\nDELIMITER $$\nCREATE TRIGGER `updateTimes` AFTER UPDATE ON `monitoring__times` FOR EACH ROW UPDATE monitoring__times_mirror\nSET `idServer`=new.idServer,\n`time`=new.time,\n`totalTime`=new.totalTime\nWHERE `idServer`=old.idServer\nAND `time`=old.time\nAND `totalTime`=old.totalTime\n$$\nDELIMITER ;\n\n--\n-- Index pour les tables déchargées\n--\n\n--\n-- Index pour la table `monitoring__times`\n--\nALTER TABLE `monitoring__times`\n ADD UNIQUE KEY `idServer` (`idServer`,`time`) USING BTREE COMMENT 'Unique idServer/time',\n ADD KEY `INDEX_totalTime` (`totalTime`) USING BTREE COMMENT 'Index for totalTime column';\n\n--\n-- Contraintes pour les tables déchargées\n--\n\n--\n-- Contraintes pour la table `monitoring__times`\n--\nALTER TABLE `monitoring__times`\n ADD CONSTRAINT `monitoring__times__idServer` FOREIGN KEY (`idServer`) REFERENCES `monitoring__servers` (`id`);\nCOMMIT;\n\n/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;\n/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;\n/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;\n", "byteIdx": 2645, "charIdx": 2634, "byteLen": 2646, "charLen": 2635 }, "len": 2635, "last": 2635, "list": { "@type": "PhpMyAdmin\\SqlParser\\TokensList", "tokens": [ { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "-- phpMyAdmin SQL Dump", "value": "-- phpMyAdmin SQL Dump", "keyword": null, "type": 4, "flags": 4, "position": 0 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 22 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "-- version 5.0.0-dev", "value": "-- version 5.0.0-dev", "keyword": null, "type": 4, "flags": 4, "position": 23 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 43 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "-- https://www.phpmyadmin.net/", "value": "-- https://www.phpmyadmin.net/", "keyword": null, "type": 4, "flags": 4, "position": 44 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 74 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "--\n", "value": "--\n", "keyword": null, "type": 4, "flags": 4, "position": 75 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 77 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "-- Hôte : xxxx.xxxxx.eu-west-1.rds.amazonaws.com", "value": "-- Hôte : xxxx.xxxxx.eu-west-1.rds.amazonaws.com", "keyword": null, "type": 4, "flags": 4, "position": 78 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 126 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "-- Généré le : mer. 05 sep. 2018 à 00:03", "value": "-- Généré le : mer. 05 sep. 2018 à 00:03", "keyword": null, "type": 4, "flags": 4, "position": 127 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 168 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "-- Version du serveur : 10.0.24-MariaDB", "value": "-- Version du serveur : 10.0.24-MariaDB", "keyword": null, "type": 4, "flags": 4, "position": 169 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 209 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "-- Version de PHP : 7.2.8-1+ubuntu18.04.1+deb.sury.org+1", "value": "-- Version de PHP : 7.2.8-1+ubuntu18.04.1+deb.sury.org+1", "keyword": null, "type": 4, "flags": 4, "position": 210 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 267 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SET", "value": "SET", "keyword": "SET", "type": 1, "flags": 11, "position": 269 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 272 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SQL_MODE", "value": "SQL_MODE", "keyword": null, "type": 0, "flags": 0, "position": 273 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 281 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 282 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 283 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\"NO_AUTO_VALUE_ON_ZERO\"", "value": "NO_AUTO_VALUE_ON_ZERO", "keyword": null, "type": 7, "flags": 2, "position": 284 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 9, "flags": 0, "position": 307 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 308 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SET", "value": "SET", "keyword": "SET", "type": 1, "flags": 11, "position": 309 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 312 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "AUTOCOMMIT", "value": "AUTOCOMMIT", "keyword": null, "type": 0, "flags": 0, "position": 313 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 323 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 324 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 325 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "0", "value": 0, "keyword": null, "type": 6, "flags": 0, "position": 326 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 9, "flags": 0, "position": 327 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 328 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "START TRANSACTION", "value": "START TRANSACTION", "keyword": "START TRANSACTION", "type": 1, "flags": 7, "position": 329 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 9, "flags": 0, "position": 346 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 347 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SET", "value": "SET", "keyword": "SET", "type": 1, "flags": 11, "position": 348 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 351 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "time_zone", "value": "time_zone", "keyword": null, "type": 0, "flags": 0, "position": 352 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 361 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 362 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 363 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\"+00:00\"", "value": "+00:00", "keyword": null, "type": 7, "flags": 2, "position": 364 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 9, "flags": 0, "position": 372 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n\n\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 373 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "/*!40101", "value": "/*!40101", "keyword": null, "type": 4, "flags": 10, "position": 376 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 384 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SET", "value": "SET", "keyword": "SET", "type": 1, "flags": 11, "position": 385 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 388 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "@OLD_CHARACTER_SET_CLIENT", "value": "OLD_CHARACTER_SET_CLIENT", "keyword": null, "type": 8, "flags": 1, "position": 389 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 414 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "@@CHARACTER_SET_CLIENT", "value": "CHARACTER_SET_CLIENT", "keyword": null, "type": 8, "flags": 9, "position": 415 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 437 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "*/", "value": "*/", "keyword": null, "type": 4, "flags": 2, "position": 438 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 9, "flags": 0, "position": 440 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 441 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "/*!40101", "value": "/*!40101", "keyword": null, "type": 4, "flags": 10, "position": 442 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 450 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SET", "value": "SET", "keyword": "SET", "type": 1, "flags": 11, "position": 451 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 454 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "@OLD_CHARACTER_SET_RESULTS", "value": "OLD_CHARACTER_SET_RESULTS", "keyword": null, "type": 8, "flags": 1, "position": 455 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 481 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "@@CHARACTER_SET_RESULTS", "value": "CHARACTER_SET_RESULTS", "keyword": null, "type": 8, "flags": 9, "position": 482 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 505 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "*/", "value": "*/", "keyword": null, "type": 4, "flags": 2, "position": 506 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 9, "flags": 0, "position": 508 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 509 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "/*!40101", "value": "/*!40101", "keyword": null, "type": 4, "flags": 10, "position": 510 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 518 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SET", "value": "SET", "keyword": "SET", "type": 1, "flags": 11, "position": 519 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 522 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "@OLD_COLLATION_CONNECTION", "value": "OLD_COLLATION_CONNECTION", "keyword": null, "type": 8, "flags": 1, "position": 523 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 548 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "@@COLLATION_CONNECTION", "value": "COLLATION_CONNECTION", "keyword": null, "type": 8, "flags": 9, "position": 549 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 571 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "*/", "value": "*/", "keyword": null, "type": 4, "flags": 2, "position": 572 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 9, "flags": 0, "position": 574 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 575 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "/*!40101", "value": "/*!40101", "keyword": null, "type": 4, "flags": 10, "position": 576 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 584 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SET", "value": "SET", "keyword": "SET", "type": 1, "flags": 11, "position": 585 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 588 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "NAMES", "value": "NAMES", "keyword": "NAMES", "type": 1, "flags": 1, "position": 589 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 594 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "utf8mb4", "value": "utf8mb4", "keyword": null, "type": 0, "flags": 0, "position": 595 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 602 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "*/", "value": "*/", "keyword": null, "type": 4, "flags": 2, "position": 603 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 9, "flags": 0, "position": 605 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 606 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "--\n", "value": "--\n", "keyword": null, "type": 4, "flags": 4, "position": 608 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 610 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "-- Base de données : `xxxxxdbnamexxxxx`", "value": "-- Base de données : `xxxxxdbnamexxxxx`", "keyword": null, "type": 4, "flags": 4, "position": 611 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 651 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "--\n", "value": "--\n", "keyword": null, "type": 4, "flags": 4, "position": 652 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 654 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "-- --------------------------------------------------------", "value": "-- --------------------------------------------------------", "keyword": null, "type": 4, "flags": 4, "position": 656 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 715 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "--\n", "value": "--\n", "keyword": null, "type": 4, "flags": 4, "position": 717 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 719 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "-- Structure de la table `monitoring__times`", "value": "-- Structure de la table `monitoring__times`", "keyword": null, "type": 4, "flags": 4, "position": 720 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 764 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "--\n", "value": "--\n", "keyword": null, "type": 4, "flags": 4, "position": 765 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 767 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "CREATE", "value": "CREATE", "keyword": "CREATE", "type": 1, "flags": 3, "position": 769 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 775 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "TABLE", "value": "TABLE", "keyword": "TABLE", "type": 1, "flags": 3, "position": 776 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 781 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`monitoring__times`", "value": "monitoring__times", "keyword": null, "type": 8, "flags": 2, "position": 782 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 801 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 802 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 803 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`idServer`", "value": "idServer", "keyword": null, "type": 8, "flags": 2, "position": 806 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 816 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "int", "value": "INT", "keyword": "INT", "type": 1, "flags": 11, "position": 817 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 820 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "11", "value": 11, "keyword": null, "type": 6, "flags": 0, "position": 821 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 823 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 824 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "UNSIGNED", "value": "UNSIGNED", "keyword": "UNSIGNED", "type": 1, "flags": 3, "position": 825 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 833 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "NOT NULL", "value": "NOT NULL", "keyword": "NOT NULL", "type": 1, "flags": 7, "position": 834 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 842 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "COMMENT", "value": "COMMENT", "keyword": "COMMENT", "type": 1, "flags": 1, "position": 843 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 850 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "'Id of server'", "value": "Id of server", "keyword": null, "type": 7, "flags": 1, "position": 851 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 865 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 866 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`time`", "value": "time", "keyword": null, "type": 8, "flags": 2, "position": 869 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 875 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "timestamp", "value": "timestamp", "keyword": "TIMESTAMP", "type": 1, "flags": 41, "position": 876 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 885 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "NOT NULL", "value": "NOT NULL", "keyword": "NOT NULL", "type": 1, "flags": 7, "position": 886 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 894 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "DEFAULT", "value": "DEFAULT", "keyword": "DEFAULT", "type": 1, "flags": 35, "position": 895 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 902 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "CURRENT_TIMESTAMP", "value": "CURRENT_TIMESTAMP", "keyword": "CURRENT_TIMESTAMP", "type": 1, "flags": 35, "position": 903 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 920 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "ON UPDATE", "value": "ON UPDATE", "keyword": "ON UPDATE", "type": 1, "flags": 7, "position": 921 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 930 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "CURRENT_TIMESTAMP", "value": "CURRENT_TIMESTAMP", "keyword": "CURRENT_TIMESTAMP", "type": 1, "flags": 35, "position": 931 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 948 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "COMMENT", "value": "COMMENT", "keyword": "COMMENT", "type": 1, "flags": 1, "position": 949 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 956 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "'Time UTC'", "value": "Time UTC", "keyword": null, "type": 7, "flags": 1, "position": 957 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 967 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 968 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`totalTime`", "value": "totalTime", "keyword": null, "type": 8, "flags": 2, "position": 971 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 982 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "float", "value": "FLOAT", "keyword": "FLOAT", "type": 1, "flags": 11, "position": 983 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 988 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "UNSIGNED", "value": "UNSIGNED", "keyword": "UNSIGNED", "type": 1, "flags": 3, "position": 989 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 997 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "NOT NULL", "value": "NOT NULL", "keyword": "NOT NULL", "type": 1, "flags": 7, "position": 998 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1006 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "COMMENT", "value": "COMMENT", "keyword": "COMMENT", "type": 1, "flags": 1, "position": 1007 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1014 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "'Total time in ms'", "value": "Total time in ms", "keyword": null, "type": 7, "flags": 1, "position": 1015 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1033 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 1034 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1035 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "ENGINE", "value": "ENGINE", "keyword": "ENGINE", "type": 1, "flags": 1, "position": 1036 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 1042 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "InnoDB", "value": "InnoDB", "keyword": null, "type": 0, "flags": 0, "position": 1043 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1049 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "DEFAULT CHARSET", "value": "DEFAULT CHARSET", "keyword": "DEFAULT CHARSET", "type": 1, "flags": 7, "position": 1050 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 1065 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "utf8", "value": "utf8", "keyword": null, "type": 0, "flags": 0, "position": 1066 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1070 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "COLLATE", "value": "COLLATE", "keyword": "COLLATE", "type": 1, "flags": 3, "position": 1071 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 1078 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "utf8_unicode_ci", "value": "utf8_unicode_ci", "keyword": null, "type": 0, "flags": 0, "position": 1079 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 9, "flags": 0, "position": 1094 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1095 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "--\n", "value": "--\n", "keyword": null, "type": 4, "flags": 4, "position": 1097 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1099 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "-- Déclencheurs `monitoring__times`", "value": "-- Déclencheurs `monitoring__times`", "keyword": null, "type": 4, "flags": 4, "position": 1100 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1135 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "--\n", "value": "--\n", "keyword": null, "type": 4, "flags": 4, "position": 1136 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1138 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "DELIMITER", "value": "DELIMITER", "keyword": null, "type": 0, "flags": 0, "position": 1139 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1148 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "$$", "value": "$$", "keyword": null, "type": 9, "flags": 0, "position": 1149 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1151 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "CREATE", "value": "CREATE", "keyword": "CREATE", "type": 1, "flags": 3, "position": 1152 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1158 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "TRIGGER", "value": "TRIGGER", "keyword": "TRIGGER", "type": 1, "flags": 3, "position": 1159 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1166 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`copyTimes`", "value": "copyTimes", "keyword": null, "type": 8, "flags": 2, "position": 1167 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1178 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "AFTER", "value": "AFTER", "keyword": "AFTER", "type": 1, "flags": 1, "position": 1179 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1184 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "INSERT", "value": "INSERT", "keyword": "INSERT", "type": 1, "flags": 35, "position": 1185 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1191 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "ON", "value": "ON", "keyword": "ON", "type": 1, "flags": 3, "position": 1192 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1194 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`monitoring__times`", "value": "monitoring__times", "keyword": null, "type": 8, "flags": 2, "position": 1195 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1214 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "FOR EACH ROW", "value": "FOR EACH ROW", "keyword": "FOR EACH ROW", "type": 1, "flags": 7, "position": 1215 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1227 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "INSERT", "value": "INSERT", "keyword": "INSERT", "type": 1, "flags": 35, "position": 1228 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1234 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "INTO", "value": "INTO", "keyword": "INTO", "type": 1, "flags": 3, "position": 1235 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1239 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "monitoring__times_mirror", "value": "monitoring__times_mirror", "keyword": null, "type": 0, "flags": 0, "position": 1240 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1264 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 1265 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`idServer`", "value": "idServer", "keyword": null, "type": 8, "flags": 2, "position": 1266 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 1276 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1277 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`time`", "value": "time", "keyword": null, "type": 8, "flags": 2, "position": 1278 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 1284 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1285 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`totalTime`", "value": "totalTime", "keyword": null, "type": 8, "flags": 2, "position": 1286 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 1297 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1298 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "VALUES", "value": "VALUES", "keyword": "VALUES", "type": 1, "flags": 35, "position": 1299 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 1305 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "new", "value": "new", "keyword": "NEW", "type": 1, "flags": 1, "position": 1306 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ".", "value": ".", "keyword": null, "type": 2, "flags": 16, "position": 1309 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "idServer", "value": "idServer", "keyword": null, "type": 0, "flags": 0, "position": 1310 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 1318 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1319 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "new", "value": "new", "keyword": "NEW", "type": 1, "flags": 1, "position": 1320 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ".", "value": ".", "keyword": null, "type": 2, "flags": 16, "position": 1323 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "time", "value": "time", "keyword": "TIME", "type": 0, "flags": 0, "position": 1324 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 1328 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1329 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "new", "value": "new", "keyword": "NEW", "type": 1, "flags": 1, "position": 1330 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ".", "value": ".", "keyword": null, "type": 2, "flags": 16, "position": 1333 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "totalTime", "value": "totalTime", "keyword": null, "type": 0, "flags": 0, "position": 1334 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 1343 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1344 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "$$", "value": "$$", "keyword": null, "type": 9, "flags": 0, "position": 1345 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1347 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "DELIMITER", "value": "DELIMITER", "keyword": null, "type": 0, "flags": 0, "position": 1348 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1357 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 9, "flags": 0, "position": 1358 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1359 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "DELIMITER", "value": "DELIMITER", "keyword": null, "type": 0, "flags": 0, "position": 1360 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1369 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "$$", "value": "$$", "keyword": null, "type": 9, "flags": 0, "position": 1370 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1372 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "CREATE", "value": "CREATE", "keyword": "CREATE", "type": 1, "flags": 3, "position": 1373 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1379 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "TRIGGER", "value": "TRIGGER", "keyword": "TRIGGER", "type": 1, "flags": 3, "position": 1380 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1387 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`deleteTimes`", "value": "deleteTimes", "keyword": null, "type": 8, "flags": 2, "position": 1388 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1401 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "AFTER", "value": "AFTER", "keyword": "AFTER", "type": 1, "flags": 1, "position": 1402 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1407 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "DELETE", "value": "DELETE", "keyword": "DELETE", "type": 1, "flags": 3, "position": 1408 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1414 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "ON", "value": "ON", "keyword": "ON", "type": 1, "flags": 3, "position": 1415 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1417 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`monitoring__times`", "value": "monitoring__times", "keyword": null, "type": 8, "flags": 2, "position": 1418 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1437 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "FOR EACH ROW", "value": "FOR EACH ROW", "keyword": "FOR EACH ROW", "type": 1, "flags": 7, "position": 1438 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1450 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "DELETE", "value": "DELETE", "keyword": "DELETE", "type": 1, "flags": 3, "position": 1451 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1457 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "FROM", "value": "FROM", "keyword": "FROM", "type": 1, "flags": 3, "position": 1458 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1462 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "monitoring__times_mirror", "value": "monitoring__times_mirror", "keyword": null, "type": 0, "flags": 0, "position": 1463 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1487 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "WHERE", "value": "WHERE", "keyword": "WHERE", "type": 1, "flags": 3, "position": 1488 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1493 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`idServer`", "value": "idServer", "keyword": null, "type": 8, "flags": 2, "position": 1494 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 1504 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "old", "value": "old", "keyword": null, "type": 0, "flags": 0, "position": 1505 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ".", "value": ".", "keyword": null, "type": 2, "flags": 16, "position": 1508 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "idServer", "value": "idServer", "keyword": null, "type": 0, "flags": 0, "position": 1509 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1517 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "AND", "value": "AND", "keyword": "AND", "type": 1, "flags": 3, "position": 1518 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1521 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`time`", "value": "time", "keyword": null, "type": 8, "flags": 2, "position": 1522 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 1528 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "old", "value": "old", "keyword": null, "type": 0, "flags": 0, "position": 1529 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ".", "value": ".", "keyword": null, "type": 2, "flags": 16, "position": 1532 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "time", "value": "time", "keyword": "TIME", "type": 0, "flags": 0, "position": 1533 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1537 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "AND", "value": "AND", "keyword": "AND", "type": 1, "flags": 3, "position": 1538 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1541 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`totalTime`", "value": "totalTime", "keyword": null, "type": 8, "flags": 2, "position": 1542 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 1553 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "old", "value": "old", "keyword": null, "type": 0, "flags": 0, "position": 1554 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ".", "value": ".", "keyword": null, "type": 2, "flags": 16, "position": 1557 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "totalTime", "value": "totalTime", "keyword": null, "type": 0, "flags": 0, "position": 1558 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1567 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "$$", "value": "$$", "keyword": null, "type": 9, "flags": 0, "position": 1568 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1570 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "DELIMITER", "value": "DELIMITER", "keyword": null, "type": 0, "flags": 0, "position": 1571 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1580 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 9, "flags": 0, "position": 1581 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1582 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "DELIMITER", "value": "DELIMITER", "keyword": null, "type": 0, "flags": 0, "position": 1583 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1592 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "$$", "value": "$$", "keyword": null, "type": 9, "flags": 0, "position": 1593 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1595 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "CREATE", "value": "CREATE", "keyword": "CREATE", "type": 1, "flags": 3, "position": 1596 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1602 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "TRIGGER", "value": "TRIGGER", "keyword": "TRIGGER", "type": 1, "flags": 3, "position": 1603 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1610 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`updateTimes`", "value": "updateTimes", "keyword": null, "type": 8, "flags": 2, "position": 1611 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1624 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "AFTER", "value": "AFTER", "keyword": "AFTER", "type": 1, "flags": 1, "position": 1625 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1630 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "UPDATE", "value": "UPDATE", "keyword": "UPDATE", "type": 1, "flags": 3, "position": 1631 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1637 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "ON", "value": "ON", "keyword": "ON", "type": 1, "flags": 3, "position": 1638 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1640 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`monitoring__times`", "value": "monitoring__times", "keyword": null, "type": 8, "flags": 2, "position": 1641 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1660 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "FOR EACH ROW", "value": "FOR EACH ROW", "keyword": "FOR EACH ROW", "type": 1, "flags": 7, "position": 1661 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1673 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "UPDATE", "value": "UPDATE", "keyword": "UPDATE", "type": 1, "flags": 3, "position": 1674 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1680 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "monitoring__times_mirror", "value": "monitoring__times_mirror", "keyword": null, "type": 0, "flags": 0, "position": 1681 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1705 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SET", "value": "SET", "keyword": "SET", "type": 1, "flags": 11, "position": 1706 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1709 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`idServer`", "value": "idServer", "keyword": null, "type": 8, "flags": 2, "position": 1710 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 1720 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "new", "value": "new", "keyword": "NEW", "type": 1, "flags": 1, "position": 1721 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ".", "value": ".", "keyword": null, "type": 2, "flags": 16, "position": 1724 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "idServer", "value": "idServer", "keyword": null, "type": 0, "flags": 0, "position": 1725 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 1733 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1734 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`time`", "value": "time", "keyword": null, "type": 8, "flags": 2, "position": 1735 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 1741 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "new", "value": "new", "keyword": "NEW", "type": 1, "flags": 1, "position": 1742 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ".", "value": ".", "keyword": null, "type": 2, "flags": 16, "position": 1745 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "time", "value": "time", "keyword": "TIME", "type": 0, "flags": 0, "position": 1746 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 1750 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1751 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`totalTime`", "value": "totalTime", "keyword": null, "type": 8, "flags": 2, "position": 1752 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 1763 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "new", "value": "new", "keyword": "NEW", "type": 1, "flags": 1, "position": 1764 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ".", "value": ".", "keyword": null, "type": 2, "flags": 16, "position": 1767 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "totalTime", "value": "totalTime", "keyword": null, "type": 0, "flags": 0, "position": 1768 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1777 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "WHERE", "value": "WHERE", "keyword": "WHERE", "type": 1, "flags": 3, "position": 1778 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1783 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`idServer`", "value": "idServer", "keyword": null, "type": 8, "flags": 2, "position": 1784 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 1794 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "old", "value": "old", "keyword": null, "type": 0, "flags": 0, "position": 1795 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ".", "value": ".", "keyword": null, "type": 2, "flags": 16, "position": 1798 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "idServer", "value": "idServer", "keyword": null, "type": 0, "flags": 0, "position": 1799 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1807 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "AND", "value": "AND", "keyword": "AND", "type": 1, "flags": 3, "position": 1808 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1811 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`time`", "value": "time", "keyword": null, "type": 8, "flags": 2, "position": 1812 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 1818 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "old", "value": "old", "keyword": null, "type": 0, "flags": 0, "position": 1819 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ".", "value": ".", "keyword": null, "type": 2, "flags": 16, "position": 1822 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "time", "value": "time", "keyword": "TIME", "type": 0, "flags": 0, "position": 1823 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1827 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "AND", "value": "AND", "keyword": "AND", "type": 1, "flags": 3, "position": 1828 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1831 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`totalTime`", "value": "totalTime", "keyword": null, "type": 8, "flags": 2, "position": 1832 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 1843 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "old", "value": "old", "keyword": null, "type": 0, "flags": 0, "position": 1844 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ".", "value": ".", "keyword": null, "type": 2, "flags": 16, "position": 1847 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "totalTime", "value": "totalTime", "keyword": null, "type": 0, "flags": 0, "position": 1848 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1857 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "$$", "value": "$$", "keyword": null, "type": 9, "flags": 0, "position": 1858 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1860 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "DELIMITER", "value": "DELIMITER", "keyword": null, "type": 0, "flags": 0, "position": 1861 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1870 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 9, "flags": 0, "position": 1871 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1872 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "--\n", "value": "--\n", "keyword": null, "type": 4, "flags": 4, "position": 1874 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1876 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "-- Index pour les tables déchargées", "value": "-- Index pour les tables déchargées", "keyword": null, "type": 4, "flags": 4, "position": 1877 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1912 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "--\n", "value": "--\n", "keyword": null, "type": 4, "flags": 4, "position": 1913 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1915 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "--\n", "value": "--\n", "keyword": null, "type": 4, "flags": 4, "position": 1917 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1919 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "-- Index pour la table `monitoring__times`", "value": "-- Index pour la table `monitoring__times`", "keyword": null, "type": 4, "flags": 4, "position": 1920 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1962 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "--\n", "value": "--\n", "keyword": null, "type": 4, "flags": 4, "position": 1963 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1965 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "ALTER", "value": "ALTER", "keyword": "ALTER", "type": 1, "flags": 3, "position": 1966 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1971 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "TABLE", "value": "TABLE", "keyword": "TABLE", "type": 1, "flags": 3, "position": 1972 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1977 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`monitoring__times`", "value": "monitoring__times", "keyword": null, "type": 8, "flags": 2, "position": 1978 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1997 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "ADD", "value": "ADD", "keyword": "ADD", "type": 1, "flags": 3, "position": 2000 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2003 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "UNIQUE KEY", "value": "UNIQUE KEY", "keyword": "UNIQUE KEY", "type": 1, "flags": 23, "position": 2004 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2014 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`idServer`", "value": "idServer", "keyword": null, "type": 8, "flags": 2, "position": 2015 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2025 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 2026 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`idServer`", "value": "idServer", "keyword": null, "type": 8, "flags": 2, "position": 2027 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 2037 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`time`", "value": "time", "keyword": null, "type": 8, "flags": 2, "position": 2038 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 2044 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2045 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "USING", "value": "USING", "keyword": "USING", "type": 1, "flags": 3, "position": 2046 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2051 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "BTREE", "value": "BTREE", "keyword": "BTREE", "type": 1, "flags": 1, "position": 2052 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2057 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "COMMENT", "value": "COMMENT", "keyword": "COMMENT", "type": 1, "flags": 1, "position": 2058 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2065 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "'Unique idServer/time'", "value": "Unique idServer/time", "keyword": null, "type": 7, "flags": 1, "position": 2066 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 2088 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2089 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "ADD", "value": "ADD", "keyword": "ADD", "type": 1, "flags": 3, "position": 2092 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2095 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "KEY", "value": "KEY", "keyword": "KEY", "type": 1, "flags": 19, "position": 2096 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2099 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`INDEX_totalTime`", "value": "INDEX_totalTime", "keyword": null, "type": 8, "flags": 2, "position": 2100 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2117 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 2118 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`totalTime`", "value": "totalTime", "keyword": null, "type": 8, "flags": 2, "position": 2119 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 2130 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2131 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "USING", "value": "USING", "keyword": "USING", "type": 1, "flags": 3, "position": 2132 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2137 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "BTREE", "value": "BTREE", "keyword": "BTREE", "type": 1, "flags": 1, "position": 2138 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2143 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "COMMENT", "value": "COMMENT", "keyword": "COMMENT", "type": 1, "flags": 1, "position": 2144 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2151 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "'Index for totalTime column'", "value": "Index for totalTime column", "keyword": null, "type": 7, "flags": 1, "position": 2152 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 9, "flags": 0, "position": 2180 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2181 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "--\n", "value": "--\n", "keyword": null, "type": 4, "flags": 4, "position": 2183 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2185 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "-- Contraintes pour les tables déchargées", "value": "-- Contraintes pour les tables déchargées", "keyword": null, "type": 4, "flags": 4, "position": 2186 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2227 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "--\n", "value": "--\n", "keyword": null, "type": 4, "flags": 4, "position": 2228 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2230 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "--\n", "value": "--\n", "keyword": null, "type": 4, "flags": 4, "position": 2232 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2234 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "-- Contraintes pour la table `monitoring__times`", "value": "-- Contraintes pour la table `monitoring__times`", "keyword": null, "type": 4, "flags": 4, "position": 2235 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2283 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "--\n", "value": "--\n", "keyword": null, "type": 4, "flags": 4, "position": 2284 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2286 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "ALTER", "value": "ALTER", "keyword": "ALTER", "type": 1, "flags": 3, "position": 2287 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2292 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "TABLE", "value": "TABLE", "keyword": "TABLE", "type": 1, "flags": 3, "position": 2293 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2298 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`monitoring__times`", "value": "monitoring__times", "keyword": null, "type": 8, "flags": 2, "position": 2299 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2318 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "ADD", "value": "ADD", "keyword": "ADD", "type": 1, "flags": 3, "position": 2321 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2324 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "CONSTRAINT", "value": "CONSTRAINT", "keyword": "CONSTRAINT", "type": 1, "flags": 3, "position": 2325 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2335 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`monitoring__times__idServer`", "value": "monitoring__times__idServer", "keyword": null, "type": 8, "flags": 2, "position": 2336 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2365 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "FOREIGN KEY", "value": "FOREIGN KEY", "keyword": "FOREIGN KEY", "type": 1, "flags": 23, "position": 2366 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2377 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 2378 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`idServer`", "value": "idServer", "keyword": null, "type": 8, "flags": 2, "position": 2379 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 2389 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2390 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "REFERENCES", "value": "REFERENCES", "keyword": "REFERENCES", "type": 1, "flags": 3, "position": 2391 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2401 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`monitoring__servers`", "value": "monitoring__servers", "keyword": null, "type": 8, "flags": 2, "position": 2402 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2423 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 2424 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`id`", "value": "id", "keyword": null, "type": 8, "flags": 2, "position": 2425 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 2429 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 9, "flags": 0, "position": 2430 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2431 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "COMMIT", "value": "COMMIT", "keyword": "COMMIT", "type": 1, "flags": 1, "position": 2432 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 9, "flags": 0, "position": 2438 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2439 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "/*!40101", "value": "/*!40101", "keyword": null, "type": 4, "flags": 10, "position": 2441 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2449 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SET", "value": "SET", "keyword": "SET", "type": 1, "flags": 11, "position": 2450 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2453 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "CHARACTER_SET_CLIENT", "value": "CHARACTER_SET_CLIENT", "keyword": null, "type": 0, "flags": 0, "position": 2454 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 2474 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "@OLD_CHARACTER_SET_CLIENT", "value": "OLD_CHARACTER_SET_CLIENT", "keyword": null, "type": 8, "flags": 1, "position": 2475 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2500 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "*/", "value": "*/", "keyword": null, "type": 4, "flags": 2, "position": 2501 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 9, "flags": 0, "position": 2503 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2504 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "/*!40101", "value": "/*!40101", "keyword": null, "type": 4, "flags": 10, "position": 2505 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2513 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SET", "value": "SET", "keyword": "SET", "type": 1, "flags": 11, "position": 2514 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2517 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "CHARACTER_SET_RESULTS", "value": "CHARACTER_SET_RESULTS", "keyword": null, "type": 0, "flags": 0, "position": 2518 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 2539 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "@OLD_CHARACTER_SET_RESULTS", "value": "OLD_CHARACTER_SET_RESULTS", "keyword": null, "type": 8, "flags": 1, "position": 2540 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2566 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "*/", "value": "*/", "keyword": null, "type": 4, "flags": 2, "position": 2567 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 9, "flags": 0, "position": 2569 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2570 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "/*!40101", "value": "/*!40101", "keyword": null, "type": 4, "flags": 10, "position": 2571 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2579 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SET", "value": "SET", "keyword": "SET", "type": 1, "flags": 11, "position": 2580 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2583 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "COLLATION_CONNECTION", "value": "COLLATION_CONNECTION", "keyword": null, "type": 0, "flags": 0, "position": 2584 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 2604 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "@OLD_COLLATION_CONNECTION", "value": "OLD_COLLATION_CONNECTION", "keyword": null, "type": 8, "flags": 1, "position": 2605 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2630 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "*/", "value": "*/", "keyword": null, "type": 4, "flags": 2, "position": 2631 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 9, "flags": 0, "position": 2633 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2634 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": null, "value": null, "keyword": null, "type": 9, "flags": 0, "position": null } ], "count": 505, "idx": 505 }, "delimiter": ";", "delimiterLen": 1, "strict": false, "errors": [] }, "parser": { "@type": "PhpMyAdmin\\SqlParser\\Parser", "list": { "@type": "@2" }, "statements": [ { "@type": "PhpMyAdmin\\SqlParser\\Statements\\SetStatement", "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] }, "end_options": null, "set": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\SetOperation", "column": "SQL_MODE", "value": "\"NO_AUTO_VALUE_ON_ZERO\"" } ], "first": 0, "last": 22 }, { "@type": "PhpMyAdmin\\SqlParser\\Statements\\SetStatement", "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] }, "end_options": null, "set": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\SetOperation", "column": "AUTOCOMMIT", "value": "0" } ], "first": 23, "last": 31 }, { "@type": "PhpMyAdmin\\SqlParser\\Statements\\TransactionStatement", "type": 1, "statements": [ { "@type": "PhpMyAdmin\\SqlParser\\Statements\\SetStatement", "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] }, "end_options": null, "set": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\SetOperation", "column": "time_zone", "value": "\"+00:00\"" } ], "first": 35, "last": 43 }, { "@type": "PhpMyAdmin\\SqlParser\\Statements\\SetStatement", "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] }, "end_options": null, "set": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\SetOperation", "column": "@OLD_CHARACTER_SET_CLIENT", "value": "@@CHARACTER_SET_CLIENT" } ], "first": 44, "last": 54 }, { "@type": "PhpMyAdmin\\SqlParser\\Statements\\SetStatement", "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] }, "end_options": null, "set": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\SetOperation", "column": "@OLD_CHARACTER_SET_RESULTS", "value": "@@CHARACTER_SET_RESULTS" } ], "first": 55, "last": 65 }, { "@type": "PhpMyAdmin\\SqlParser\\Statements\\SetStatement", "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] }, "end_options": null, "set": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\SetOperation", "column": "@OLD_COLLATION_CONNECTION", "value": "@@COLLATION_CONNECTION" } ], "first": 66, "last": 76 }, { "@type": "PhpMyAdmin\\SqlParser\\Statements\\SetStatement", "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "3": { "name": "NAMES", "equals": false, "expr": "utf8mb4", "value": "utf8mb4" } } }, "end_options": null, "set": [], "first": 77, "last": 87 }, { "@type": "PhpMyAdmin\\SqlParser\\Statements\\CreateStatement", "name": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "monitoring__times", "column": null, "expr": "`monitoring__times`", "alias": null, "function": null, "subquery": null }, "entityOptions": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "1": { "name": "ENGINE", "equals": true, "expr": "InnoDB", "value": "InnoDB" }, "4": { "name": "DEFAULT CHARSET", "equals": true, "expr": "utf8", "value": "utf8" }, "6": { "name": "COLLATE", "equals": true, "expr": "utf8_unicode_ci", "value": "utf8_unicode_ci" } } }, "fields": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\CreateDefinition", "name": "idServer", "isConstraint": null, "type": { "@type": "PhpMyAdmin\\SqlParser\\Components\\DataType", "name": "INT", "parameters": [ "11" ], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "4": "UNSIGNED" } } }, "key": null, "references": null, "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "1": "NOT NULL", "5": { "name": "COMMENT", "equals": false, "expr": "'Id of server'", "value": "Id of server" } } } }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\CreateDefinition", "name": "time", "isConstraint": null, "type": { "@type": "PhpMyAdmin\\SqlParser\\Components\\DataType", "name": "TIMESTAMP", "parameters": [], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] } }, "key": null, "references": null, "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "1": "NOT NULL", "2": { "name": "DEFAULT", "equals": false, "expr": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": null, "column": null, "expr": "CURRENT_TIMESTAMP", "alias": null, "function": null, "subquery": null }, "value": "CURRENT_TIMESTAMP" }, "7": { "name": "ON UPDATE", "equals": false, "expr": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": null, "column": null, "expr": "CURRENT_TIMESTAMP", "alias": null, "function": null, "subquery": null }, "value": "CURRENT_TIMESTAMP" }, "5": { "name": "COMMENT", "equals": false, "expr": "'Time UTC'", "value": "Time UTC" } } } }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\CreateDefinition", "name": "totalTime", "isConstraint": null, "type": { "@type": "PhpMyAdmin\\SqlParser\\Components\\DataType", "name": "FLOAT", "parameters": [], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "4": "UNSIGNED" } } }, "key": null, "references": null, "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "1": "NOT NULL", "5": { "name": "COMMENT", "equals": false, "expr": "'Total time in ms'", "value": "Total time in ms" } } } } ], "with": null, "select": null, "like": null, "partitionBy": null, "partitionsNum": null, "subpartitionBy": null, "subpartitionsNum": null, "partitions": null, "table": null, "return": null, "parameters": null, "body": [], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "6": "TABLE" } }, "first": 88, "last": 172 }, { "@type": "PhpMyAdmin\\SqlParser\\Statements\\CreateStatement", "name": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "copyTimes", "column": null, "expr": "`copyTimes`", "alias": null, "function": null, "subquery": null }, "entityOptions": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "1": "AFTER", "2": "INSERT" } }, "fields": null, "with": null, "select": null, "like": null, "partitionBy": null, "partitionsNum": null, "subpartitionBy": null, "subpartitionsNum": null, "partitions": null, "table": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "monitoring__times", "column": null, "expr": "`monitoring__times`", "alias": null, "function": null, "subquery": null }, "return": null, "parameters": null, "body": [ { "@type": "@203" }, { "@type": "@204" }, { "@type": "@205" }, { "@type": "@206" }, { "@type": "@207" }, { "@type": "@208" }, { "@type": "@209" }, { "@type": "@210" }, { "@type": "@211" }, { "@type": "@212" }, { "@type": "@213" }, { "@type": "@214" }, { "@type": "@215" }, { "@type": "@216" }, { "@type": "@217" }, { "@type": "@218" }, { "@type": "@219" }, { "@type": "@220" }, { "@type": "@221" }, { "@type": "@222" }, { "@type": "@223" }, { "@type": "@224" }, { "@type": "@225" }, { "@type": "@226" }, { "@type": "@227" }, { "@type": "@228" }, { "@type": "@229" }, { "@type": "@230" }, { "@type": "@231" }, { "@type": "@232" }, { "@type": "@233" }, { "@type": "@234" }, { "@type": "@235" } ], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "6": "TRIGGER" } }, "first": 184, "last": 233 }, { "@type": "PhpMyAdmin\\SqlParser\\Statements\\CreateStatement", "name": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "deleteTimes", "column": null, "expr": "`deleteTimes`", "alias": null, "function": null, "subquery": null }, "entityOptions": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "1": "AFTER", "2": "DELETE" } }, "fields": null, "with": null, "select": null, "like": null, "partitionBy": null, "partitionsNum": null, "subpartitionBy": null, "subpartitionsNum": null, "partitions": null, "table": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "monitoring__times", "column": null, "expr": "`monitoring__times`", "alias": null, "function": null, "subquery": null }, "return": null, "parameters": null, "body": [ { "@type": "@262" }, { "@type": "@263" }, { "@type": "@264" }, { "@type": "@265" }, { "@type": "@266" }, { "@type": "@267" }, { "@type": "@268" }, { "@type": "@269" }, { "@type": "@270" }, { "@type": "@271" }, { "@type": "@272" }, { "@type": "@273" }, { "@type": "@274" }, { "@type": "@275" }, { "@type": "@276" }, { "@type": "@277" }, { "@type": "@278" }, { "@type": "@279" }, { "@type": "@280" }, { "@type": "@281" }, { "@type": "@282" }, { "@type": "@283" }, { "@type": "@284" }, { "@type": "@285" }, { "@type": "@286" }, { "@type": "@287" }, { "@type": "@288" }, { "@type": "@289" }, { "@type": "@290" }, { "@type": "@291" } ], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "6": "TRIGGER" } }, "first": 243, "last": 289 }, { "@type": "PhpMyAdmin\\SqlParser\\Statements\\CreateStatement", "name": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "updateTimes", "column": null, "expr": "`updateTimes`", "alias": null, "function": null, "subquery": null }, "entityOptions": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "1": "AFTER", "2": "UPDATE" } }, "fields": null, "with": null, "select": null, "like": null, "partitionBy": null, "partitionsNum": null, "subpartitionBy": null, "subpartitionsNum": null, "partitions": null, "table": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "monitoring__times", "column": null, "expr": "`monitoring__times`", "alias": null, "function": null, "subquery": null }, "return": null, "parameters": null, "body": [ { "@type": "@318" }, { "@type": "@319" }, { "@type": "@320" }, { "@type": "@321" }, { "@type": "@322" }, { "@type": "@323" }, { "@type": "@324" }, { "@type": "@325" }, { "@type": "@326" }, { "@type": "@327" }, { "@type": "@328" }, { "@type": "@329" }, { "@type": "@330" }, { "@type": "@331" }, { "@type": "@332" }, { "@type": "@333" }, { "@type": "@334" }, { "@type": "@335" }, { "@type": "@336" }, { "@type": "@337" }, { "@type": "@338" }, { "@type": "@339" }, { "@type": "@340" }, { "@type": "@341" }, { "@type": "@342" }, { "@type": "@343" }, { "@type": "@344" }, { "@type": "@345" }, { "@type": "@346" }, { "@type": "@347" }, { "@type": "@348" }, { "@type": "@349" }, { "@type": "@350" }, { "@type": "@351" }, { "@type": "@352" }, { "@type": "@353" }, { "@type": "@354" }, { "@type": "@355" }, { "@type": "@356" }, { "@type": "@357" }, { "@type": "@358" }, { "@type": "@359" }, { "@type": "@360" }, { "@type": "@361" }, { "@type": "@362" }, { "@type": "@363" }, { "@type": "@364" }, { "@type": "@365" }, { "@type": "@366" }, { "@type": "@367" } ], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "6": "TRIGGER" } }, "first": 299, "last": 365 }, { "@type": "PhpMyAdmin\\SqlParser\\Statements\\AlterStatement", "table": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "monitoring__times", "column": null, "expr": "`monitoring__times`", "alias": null, "function": null, "subquery": null }, "altered": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\AlterOperation", "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "1": "ADD" } }, "field": null, "partitions": null, "unknown": [ { "@type": "@394" }, { "@type": "@395" }, { "@type": "@396" }, { "@type": "@397" }, { "@type": "@398" }, { "@type": "@399" }, { "@type": "@400" }, { "@type": "@401" }, { "@type": "@402" }, { "@type": "@403" }, { "@type": "@404" }, { "@type": "@405" }, { "@type": "@406" }, { "@type": "@407" }, { "@type": "@408" }, { "@type": "@409" }, { "@type": "@410" } ] }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\AlterOperation", "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "1": "ADD", "2": "KEY" } }, "field": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": null, "column": "INDEX_totalTime", "expr": "`INDEX_totalTime`", "alias": null, "function": null, "subquery": null }, "partitions": null, "unknown": [ { "@type": "@419" }, { "@type": "@420" }, { "@type": "@421" }, { "@type": "@422" }, { "@type": "@423" }, { "@type": "@424" }, { "@type": "@425" }, { "@type": "@426" }, { "@type": "@427" }, { "@type": "@428" }, { "@type": "@429" } ] } ], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "3": "TABLE" } }, "first": 371, "last": 427 }, { "@type": "PhpMyAdmin\\SqlParser\\Statements\\AlterStatement", "table": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "monitoring__times", "column": null, "expr": "`monitoring__times`", "alias": null, "function": null, "subquery": null }, "altered": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\AlterOperation", "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "1": "ADD", "2": "CONSTRAINT" } }, "field": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": null, "column": "monitoring__times__idServer", "expr": "`monitoring__times__idServer`", "alias": null, "function": null, "subquery": null }, "partitions": null, "unknown": [ { "@type": "@456" }, { "@type": "@457" }, { "@type": "@458" }, { "@type": "@459" }, { "@type": "@460" }, { "@type": "@461" }, { "@type": "@462" }, { "@type": "@463" }, { "@type": "@464" }, { "@type": "@465" }, { "@type": "@466" }, { "@type": "@467" }, { "@type": "@468" } ] } ], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "3": "TABLE" } }, "first": 428, "last": 466 } ], "end": { "@type": "PhpMyAdmin\\SqlParser\\Statements\\TransactionStatement", "type": 2, "statements": null, "end": null, "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "1": "COMMIT" } }, "first": 467, "last": 468 }, "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "1": "START TRANSACTION" } }, "first": 32, "last": 34 }, { "@type": "PhpMyAdmin\\SqlParser\\Statements\\SetStatement", "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] }, "end_options": null, "set": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\SetOperation", "column": "CHARACTER_SET_CLIENT", "value": "@OLD_CHARACTER_SET_CLIENT" } ], "first": 469, "last": 479 }, { "@type": "PhpMyAdmin\\SqlParser\\Statements\\SetStatement", "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] }, "end_options": null, "set": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\SetOperation", "column": "CHARACTER_SET_RESULTS", "value": "@OLD_CHARACTER_SET_RESULTS" } ], "first": 480, "last": 490 }, { "@type": "PhpMyAdmin\\SqlParser\\Statements\\SetStatement", "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] }, "end_options": null, "set": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\SetOperation", "column": "COLLATION_CONNECTION", "value": "@OLD_COLLATION_CONNECTION" } ], "first": 491, "last": 501 } ], "brackets": 0, "strict": false, "errors": [] }, "errors": { "lexer": [], "parser": [] } }