-- Données de contexte
-- BDD version 1.0.0 ou plus
--
-- Base de données: `erp`
-- 
use erp;

-- --------------------------------------------------------
-- Vidage des tables avant insertion
-- 	ATTENTION, ne pas changer l'ordre des tables, il y a des dépendances de référence (clés étrangères)
-- --------------------------------------------------------
delete FROM `cptajournal` ;
delete FROM `stockmvt` ;
delete FROM `panierarticle` ;
delete FROM `panier` ;
delete FROM `lignecdefourart` ;
delete FROM `cdefour` ;
delete FROM `lignecdeclientart` ;
delete FROM `cdeclient` ;
delete FROM `ordfab` ;
delete FROM `ofnomenclature` ;
delete FROM `ofgamme` ;
delete FROM `artnomenclature` ;
delete FROM `artgamme` ;
delete FROM `article` ;
delete FROM `tier` ;
delete FROM `artcategorie` ;
delete FROM `param` WHERE parmCode not like 'SOC%' and parmCode <> 'TVA';
-- --------------------------------------------------------