-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Hôte : 127.0.0.1:3306
-- Généré le : ven. 01 août 2025 à 18:26
-- Version du serveur : 9.1.0
-- Version de PHP : 8.3.14

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Base de données : `webnlogi_farm`
--

-- --------------------------------------------------------

--
-- Structure de la table `_article`
--

DROP TABLE IF EXISTS `_article`;
CREATE TABLE IF NOT EXISTS `_article` (
  `id` int NOT NULL AUTO_INCREMENT,
  `code` varchar(30) DEFAULT NULL,
  `nom` varchar(256) DEFAULT NULL,
  `unite` varchar(20) DEFAULT NULL,
  `prix_achat` decimal(20,2) DEFAULT NULL,
  `prix_vente` decimal(20,2) DEFAULT NULL,
  `stock` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=latin1;

--
-- Déchargement des données de la table `_article`
--

INSERT INTO `_article` (`id`, `code`, `nom`, `unite`, `prix_achat`, `prix_vente`, `stock`) VALUES
(1, 'PN030', 'POULE PONDEUSE', 'SAC', 138000.00, 142000.00, 9),
(2, '210AX', 'PIC DE PONTE', 'SAC', 134400.00, 138400.00, 10),
(3, '210CX', 'PONDEUSE CONCENTRE', 'SAC', 139500.00, 142000.00, 0),
(4, '225', 'FIN PONTE', 'SAC', 131375.00, 134000.00, 0),
(5, '521', 'DEMARRAGE POULET DE CHAIR', 'SAC', 179375.00, 182000.00, 0),
(6, '541', 'FINITION POULET DE CHAIR', 'SAC', 171375.00, 174000.00, 0),
(7, '542', 'POST-FINITION POULET DE CHAIR', 'SAC', 154000.00, 158000.00, 0),
(8, '1410CX', 'PORC WEANER CONCENTRE SAC DE 25KG', 'SAC', 74950.00, 76200.00, 0),
(9, '1420CX', 'CROISSANCE PORC CONCENTRE', 'SAC', 65250.00, 66500.00, 0),
(10, '1430CX', 'FINITION PORC CONCENTRE', 'SAC', 61950.00, 63200.00, 0),
(11, '1410X', 'PORC PIG WEANER CONCENTRE', 'SAC', 155675.00, 158300.00, 0),
(12, '1420X', 'CROISSANCE PORC', 'SAC', 126875.00, 129500.00, 0),
(13, '1430X', 'FINITION PORC', 'SAC', 121875.00, 124500.00, 0),
(14, '1510X', 'GESTATION', 'SAC', 131000.00, 135000.00, 0),
(15, '1520X', 'LACTATION', 'SAC', 141900.00, 145900.00, 0),
(16, 'CVL', 'RUMINANT', 'SAC', 108000.00, 112000.00, 0),
(17, 'PGO', 'TILAPIA OPTIMAL PREGROWER', 'SAC', 148000.00, 151000.00, 0),
(18, 'GO', 'GROWER OPTIMAL', 'SAC', 138000.00, 142000.00, 0),
(19, 'BC', 'BIG CRUMBLE', 'SAC', 0.00, 173000.00, 0),
(20, 'PN010', 'DEMARRAGE PONTE', 'SAC', 161000.00, 165000.00, 0),
(21, 'PN020', 'CROISSANCE PONDEUSE', 'SAC', 136875.00, 139500.00, 0),
(22, '02PSN03', 'POUSSIN CHAIR', 'U', 3670.00, 3900.00, 0),
(23, '04ATV03', 'TETRACOLIVIT 100G', 'SAC', 15000.00, 16500.00, 0),
(24, '04VIT02', 'AMINTOTAL 150G', 'SAC', 30000.00, 33000.00, 0),
(25, '04HPP01', 'ANTITOX 100G', 'SAC', 14576.00, 16000.00, 0),
(26, '04DES09', 'VIRUNET 50G', 'SAC', 12400.00, 14000.00, 0),
(27, '04ATB04', 'TRISULMYCINE 100G', 'SAC', 34599.00, 38000.00, 0),
(28, '04VIT07', 'SELIC250ML', 'SAC', 22300.00, 24500.00, 0),
(29, '04ATC01', 'ANTICOC SUPER 100G', 'SAC', 25013.00, 27500.00, 0),
(30, '06MTE06', 'MANGEOIRE MM 7KG', 'SAC', 24012.00, 32000.00, 0),
(31, '06MTE02', 'ABREUVOIR 1GAL', 'SAC', 12600.00, 17000.00, 0),
(32, '1420XF', 'CROISSANCE PORC FARINE', 'SAC', 108500.00, 117500.00, 0),
(33, '1430XF', 'FINITION PORC FARINE', 'SAC', 103500.00, 113500.00, 0),
(34, 'FP', 'FINISHER', 'SAC', 128000.00, 130000.00, 0),
(35, '1520XF', 'ALLAITEMENT FARINE', 'SAC', 116900.00, 129500.00, 0),
(36, 'KB10M', 'COMBO DEMARAGE', 'SAC', 161000.00, 167000.00, 0),
(37, 'KB20F', 'COMBO CROISSANCE', 'SAC', 135500.00, 139500.00, 0),
(38, 'KB30F', 'COMBO POULETTE', 'SAC', 138000.00, 142000.00, 0),
(39, 'KB40F', 'COMBO PONTE', 'SAC', 134400.00, 138400.00, 0),
(40, '02PSNWPF', 'COMBO POUSSIN', 'U', 4170.00, 4300.00, 0);
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
