--
-- Host: localhost    Database: suivi_production
-- ------------------------------------------------------


--
-- Table structure for table `f_cadence_cueillette_carnet`
--

CREATE TABLE `f_cadence_cueillette_carnet` (
  `x_pk` int NOT NULL,
  `x_chrono` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `x_index` int NOT NULL DEFAULT '0',
  `x_nomservice` varchar(50) NOT NULL,
  `x_heuredebut` varchar(50) NOT NULL,
  `x_duree` varchar(50) NOT NULL,
  `x_tempsarret` varchar(50) NOT NULL,
  `x_nb_carnet` float NOT NULL,
  `x_nb_carnetheure` float NOT NULL,
  `x_nbproduit` float NOT NULL,
  `x_nbproduitheure` float NOT NULL,
  `x_nbpilullier` float NOT NULL,
  `x_nbpilullierheure` float NOT NULL,
  `x_nbplateau` float NOT NULL,
  `x_nbplateauheure` float NOT NULL,
  `x_poste` varchar(20) NOT NULL,
  PRIMARY KEY (`x_pk`),
  KEY `cadence_carnet_par_service_x_poste` (`x_poste`),
  KEY `cadence_carnet_par_service_x_chrono_x_poste` (`x_chrono`,`x_poste`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `f_cadence_cueillette_carnet`
--


--
-- Table structure for table `f_cadence_cueillette_pil`
--

CREATE TABLE `f_cadence_cueillette_pil` (
  `x_pk` int NOT NULL,
  `x_chrono` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `x_index` int NOT NULL DEFAULT '0',
  `x_nomservice` varchar(50) NOT NULL,
  `x_heuredebut` varchar(50) NOT NULL,
  `x_duree` varchar(50) NOT NULL,
  `x_tempsarret` varchar(50) NOT NULL,
  `x_nbproduit` float NOT NULL DEFAULT '0',
  `x_nbproduitheure` float NOT NULL DEFAULT '0',
  `x_nbpilullier` float NOT NULL DEFAULT '0',
  `x_nbpilullierheure` float NOT NULL DEFAULT '0',
  `x_nbplateau` float NOT NULL DEFAULT '0',
  `x_nbplateauheure` float NOT NULL DEFAULT '0',
  `x_poste` varchar(20) NOT NULL,
  PRIMARY KEY (`x_pk`),
  KEY `cadence_pilulier_par_service_x_poste` (`x_poste`),
  KEY `cadence_pilulier_par_service_x_chrono_x_poste` (`x_chrono`,`x_poste`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `f_cadence_cueillette_pil`
--


--
-- Table structure for table `f_suivi_production`
--

CREATE TABLE `f_suivi_production` (
  `x_pk` int NOT NULL AUTO_INCREMENT,
  `x_chrono` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `x_variable` varchar(40) NOT NULL,
  `x_valeur_alpha` varchar(20) NOT NULL DEFAULT '',
  `x_valeur_num` float DEFAULT '0',
  `x_poste` varchar(20) NOT NULL DEFAULT '',
  `x_type` varchar(20) NOT NULL DEFAULT '',
  `x_etat` varchar(1) NOT NULL DEFAULT 'A',
  PRIMARY KEY (`x_pk`),
  KEY `suiviprod_x_chrono` (`x_chrono`),
  KEY `suiviprod_x_poste` (`x_poste`),
  KEY `suiviprod_x_variable` (`x_variable`),
  KEY `suiviprod_x_variable_x_chrono_x_poste` (`x_variable`,`x_chrono`,`x_poste`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `f_suivi_production`
--


--
-- Temporary view structure for view `v_minutes`
--

/*!50001 DROP VIEW IF EXISTS `v_minutes`*/;
/*!50001 CREATE VIEW `v_minutes` AS SELECT 
 1 AS `x_chrono`,
 1 AS `x_variable`,
 1 AS `x_valeur_num`,
 1 AS `x_valeur_alpha`,
 1 AS `aa`,
 1 AS `aaa`*/;

--
-- Dumping events for database 'suivi_production'
--

--
-- Dumping routines for database 'suivi_production'
--

--
-- Final view structure for view `v_minutes`
--

/*!50001 DROP VIEW IF EXISTS `v_minutes`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v_minutes` AS select date_format(`a`.`DATE`,'%Y-%m-%d %H:%i:%s') AS `x_chrono`,'' AS `x_variable`,'' AS `x_valeur_num`,'' AS `x_valeur_alpha`,`a`.`aa` AS `aa`,`a`.`aaa` AS `aaa` from (select (curdate() + interval ((((`a`.`a` + (10 * `b`.`a`)) + (100 * `c`.`a`)) + (1000 * `d`.`a`)) + (10000 * `e`.`a`)) second) AS `DATE`,`a`.`a` AS `aaa`,((((`a`.`a` + (10 * `b`.`a`)) + (100 * `c`.`a`)) + (1000 * `d`.`a`)) + (10000 * `e`.`a`)) AS `aa` from (((((select 0 AS `a`) `a` join (select 0 AS `a` union all select 1 AS `1` union all select 2 AS `2` union all select 3 AS `3` union all select 4 AS `4` union all select 5 AS `5` union all select 6 AS `6` union all select 7 AS `7` union all select 8 AS `8` union all select 9 AS `9`) `b`) join (select 0 AS `a` union all select 1 AS `1` union all select 2 AS `2` union all select 3 AS `3` union all select 4 AS `4` union all select 5 AS `5` union all select 6 AS `6` union all select 7 AS `7` union all select 8 AS `8` union all select 9 AS `9`) `c`) join (select 0 AS `a` union all select 1 AS `1` union all select 2 AS `2` union all select 3 AS `3` union all select 4 AS `4` union all select 5 AS `5` union all select 6 AS `6` union all select 7 AS `7` union all select 8 AS `8` union all select 9 AS `9`) `d`) join (select 0 AS `a` union all select 1 AS `1` union all select 2 AS `2` union all select 3 AS `3` union all select 4 AS `4` union all select 5 AS `5` union all select 6 AS `6` union all select 7 AS `7` union all select 8 AS `8` union all select 9 AS `9`) `e`)) `a` */;


