-- INSERT modèles et pièces/stock pour phpMyAdmin
-- Généré depuis CSV BACKUP + stock (si fourni)
-- Date référence inventaire: 2025-12-31

-- ========== MODÈLES (depuis CSV backup + libellés stock) ==========
-- IGNORE = skip si (nom, constructeur) existe déjà
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('Aficio MP C5502', 'RICOH', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('Aficio SP 5200S', 'RICOH', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('C2240', 'LEXMARK', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('Color Device', 'LEXMARK', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('Color Device', 'RICOH', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('DesignJet T930', 'HP', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('IM 2702', 'RICOH', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('IM 350', 'RICOH', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('IM 430', 'RICOH', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('IM 7000', 'RICOH', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('IM 9000', 'RICOH', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('IM C2000', 'RICOH', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('IM C2010', 'RICOH', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('IM C2500', 'RICOH', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('IM C300', 'RICOH', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('IM C3000', 'RICOH', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('IM C3010', 'RICOH', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('IM C3500', 'RICOH', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('IM C4500', 'RICOH', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('IM C4510', 'RICOH', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('IM C5500', 'RICOH', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('IM C5510', 'RICOH', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('IM C6000', 'RICOH', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('IM', 'RICOH', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('LaserJet M506', 'HP', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('M1246', 'LEXMARK', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('M3250', 'LEXMARK', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('M5255', 'LEXMARK', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('Monochrome Device', 'LEXMARK', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('MP 402SPF', 'RICOH', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('MP 6503', 'RICOH', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('MP 9003', 'RICOH', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('MP C2003', 'RICOH', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('MP C2004', 'RICOH', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('MP C2503', 'RICOH', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('MP C2504', 'RICOH', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('MP C2504ex', 'RICOH', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('MP C3003', 'RICOH', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('MP C3004', 'RICOH', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('MP C305', 'RICOH', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('MP C306', 'RICOH', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('MP C307', 'RICOH', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('MP C3503', 'RICOH', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('MP C3504', 'RICOH', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('MP C407', 'RICOH', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('MP C4503', 'RICOH', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('MP C4504', 'RICOH', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('MP C5503', 'RICOH', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('MP C5504', 'RICOH', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('MP C5504ex', 'RICOH', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('MP C6003', 'RICOH', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('MP C6004', 'RICOH', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('P 501', 'RICOH', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('SP 3600DN', 'RICOH', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('SP 4510', 'RICOH', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('XC4240', 'LEXMARK', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('XM1242', 'LEXMARK', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('XM1246', 'LEXMARK', NOW());
INSERT IGNORE INTO modele (nom, constructeur, created_at) VALUES ('XM3142', 'LEXMARK', NOW());

-- ========== SITES (depuis CSV) ==========
-- IGNORE = skip si nom existe déjà. Les sites peuvent exister si import CSV fait.
INSERT IGNORE INTO site (nom, created_at) VALUES ('212 YACHTS', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('ADAPEI CSE', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('ADHAP - APAD06 CANNES', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('ADHAP SERVICE ANTIBES', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('ADONIS Paysages', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('AGENCE CASTEL', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('AGENCE DE LA CALIFORNIE NICE', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('AGENCE DE MONTE CARLO', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('Agence MAYENT', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('AluServiceMiroiterie', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('Ambassade RFA', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('AML', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('APF Courtage', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('Apprendre nice', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('AUTOCARS BAIE DES ANGES', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('AZUR CLOISONS STAFF', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('AZUR CONTACT IMMO EX LANCELOT Mougins', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('BALBO BEAL Notaires Draguignan', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('BALLESTRA Menuiserie', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('Barou Notaire', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('BERTHE NOVA HOLDING', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('BERTRAND BORRA BERGEL Notaire Marseille', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('BIENAIMEEnotaireNice', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('BIO SEV PASERO', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('BITTINI CABINET', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('BLET NOTAIRE', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('Blueberry Aviation Monaco', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('BO VEGETAL', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('BONZANINI Avocats', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('BORDES BEAULIEU', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('BORGOGNO', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('BURGER King Antibes FAR SARL', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('CABINET MICHEL ROQUEFORT', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('CABINET MICHEL Rouret', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('CABINET PIERROT CANNES Pythagore', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('CABINET PIERROT MANDELIEU - Pythagore', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('CAISSES DE RETRAITE MONACO', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('CALAMUSO', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('Californie Notaires Derey Marot', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('Camille FRANCES NOTAIRE', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('CANNES AUDIT PEIRIN', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('Cantine st Paul en Forêt', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('Cap Construction', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('CAP MARTIN PROPERTIES', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('CARDON Notaire Le Cannet', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('CBL CARRELAGES', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('CCE SAINT LAURENT DU VAR', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('CHAIX ARCHITECTE', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('CHANCEL Immobilier', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('CHANCEL Immobilier GUSTAVE', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('CHANCEL ST LAURENT DU VAR', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('Cheminees Concept', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('CIFE', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('CL IMMO NICE', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('CLEMENT HORVAT Radiologie', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('club de foot de mougins', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('Concorde immobilier', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('CONFIANCE IMMO Century21', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('CSAE Soudure Carros', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('CUISINELLA ACCESS GRASSE', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('CUISINELLA CANNES Cedrane', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('CUISINELLA Distrirob', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('CUISINELLA Excom Villeneuve', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('CUISINELLA GROUPE ROBERTA', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('CUISINELLA KDIS ANTIBE', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('CUISINELLA NVH Nice', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('DARRAS CHOUMAN AVOCATS', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('DASILVA Notaire mougin', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('DBS', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('DELAIN IMMOBILIER', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('DI MARTINO TOM TIP', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('DOCTEUR FERRAND VENCE', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('Docteur MOL', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('Dr. Païdassi  SCM LapCo PAIDASSI', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('EA PNEU GRASSE', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('EA PNEU LA ROQUETTE SUR SIAGNE', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('EA PNEU NICE', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('EA PNEU St Laurent du Var', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('EA PNEU Vallauris', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('EA PNEU VILLENEUVE LOUBET', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('ECI BIOT', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('Edmiston Monaco', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('EMMEREZ Notaire Valbonne', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('ENGLIMMO', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('ESTATE SERVICE', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('EXCLUSIVE FRANCE TOURS NICE', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('FLASH ALARME Roquefort', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('FLASH ALARME ROURET', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('FOOTBALL CLUB GOLFE', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('fprenov', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('FURIO FRISCH Avocat', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('GALA ZINGARA', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('Gamm vert Arcagri Les ARCS', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('Gamm vert Mandelieu Valsiagne', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('GAMM VERT MOUGINS', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('GAMM VERT PEGOMAS ESPACE PRO_MAGASIN', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('GAMM VERT PEYMEINADE CAISSE', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('GAMM VERT ST LAURENT XC2326', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('GAMM VERT VALLAURIS', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('GAMVERT VALSIAGNE PEGOMAS DEPOT 2', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('GEMSA Nicholas Avocat', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('Gillet Broc Avocats', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('GIRAUDI NOTAIRE FIGAGNIERES', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('GIUSTINIANI PARIS notaire Marseille', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('GP GRASSE TRANSAKAUTO', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('GP INVEST Gilles Parent', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('Grasse développement', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('GRILLET', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('GROOS', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('GS ENVIRONNEMENT', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('GUIGUI AVOCAT Cannes', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('H&V Yachting MONACO', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('HENTZEIN AVOCAT', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('HENTZIEN-BOCQUET', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('ILEC CANNES', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('INTERGESTION Cannet 2EME', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('JOLY STORES', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('JSJ Juan', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('Jurion Genest Notaire St Maxime', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('JURIS RIVIERA', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('KAPPA', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('KOMILFO AMC GRASSE', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('Komilfo AMC maison Naouel', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('KONAN LINE AVOCAT Mandelieu', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('L''ADRESSE MOUGINS LEBRAS', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('LABORATOIRE DISSOLVUROL', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('LAMBERT notaire marseille', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('LAPORTE BALL TRAP', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('Larere Senequier Notaires Nice', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('LAS Distribution', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('Lauga Cannes', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('LAVERSA AVOCATE', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('Lefevre aix PHILIA Notaires', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('LEFEVRE NOTAIRE nice', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('LOMBARD France Notaire', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('LYVIO MARINE Antibes', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('Madesco Management Beaulieu', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('MAIRIE DE ST PAUL EN FORET', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('Mairie St Paul en Foret_Mediatheque', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('Marina Immobilier Century21', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('MASSENA SERVICES CENTER', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('MASSON JEAN PAUL Architecte', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('MATTEI ARCHITECTE', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('MAUMELAT MAURETTE', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('MAURETTE Collab1', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('MAURETTE Collab2', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('Me PARISOT DE BAYARD NOTAIRE ST RAPHAEL', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('Méditerranée Réalisation', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('MIDOCEAN FRANCE', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('MISSIMMO', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('MLNBA', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('MODVERRE', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('MONFORT', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('MORETTI SARAH Avocat Cagnes', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('MORISSET RIVIERA TRAITEUR', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('MOZER Cabinet', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('MRA TRAMONTI architecte Nice', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('NAHABEDIAN', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('NAJAL Notaire - JOUSSIN Anne Laure NOTAIRE', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('NARDINI Notaire', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('NAVA', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('NEROLIUM GOLFE JUAN XM13142', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('NICE RIVIERA MONTOULIEU', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('NOJE', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('NOTAIRE BERS SALTEL', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('NOTAIRE Tiphanie D’AGOSTINO_St BRIEUC', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('NOVATIS Cuisines Mougins', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('NUISITEC', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('OFFSHORE SERVICES Cap Ail', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('ORPI AB PARTNER', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('ORPI AB PARTNER MONTAUROUX', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('ORPI AB Partner Pegomas', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('ORPI ACTION IMMO', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('ORPI AG immo Mimosas', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('ORPI AG IMMO ROCHEVILLE', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('Orpi Agence ALBION Antibes', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('ORPI Agence de La Siagne', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('ORPI Agence du Centre Vallauris', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('ORPI ALLIANCE IMMO MOUANS SARTOUX', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('ORPI EUROAGENCE SIEGE', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('ORPI FRANCE AZUR GESTION  NICE', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('ORPI GRAND DUC', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('ORPI JDB CANNET MAIRIE', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('Paroisse Saint Armentaire', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('PASCAL MARTIN', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('PHARMACIE Pigrenet Cannet', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('PIERRISNARD CABINET', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('PINVILLE LE MUY NOTAIRE', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('Pompes Funèbre Paradis', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('Presse ST AYGULF TWINSET', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('PYTHAGORE Roquefort', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('RAMOINO', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('REER CONSEILS', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('RESIDEAL ANTIBES', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('RESIDEAL CANNES', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('RESIDEAL Cannet CompagnieEuropHotellerie', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('RESIDEAL GRANDE MOTTE', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('Riva Immobilier Transaction _ Cannes', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('ROGER CUILLIERE', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('ROSIER Mickael NOTAIRE', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('roustan', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('RUSSEL SCHMITT NOTAIRE', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('SANTANTONI', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('SARDO LA GUAUDE', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('SARDO Matériaux', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('SAS MBA-7 - SCHMIDT VILLENEUVE LOUBET', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('SAYAG Architecte', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('Schmidt Buffa', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('Schmidt IKONE ikea', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('SCI ENFANTS MENUISERIE', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('SCIMONE Notaire Nice', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('SCORPION', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('SCP  HERMANT  CASTELLAN JUSBERT  LUCIANI Nice', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('SCP CLEMENT ETUDE G. DE GAULLE ANTIBES', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('SCP EYMARD MARIE TEMPLE', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('SCP FONTAINE SEGUIN ACCORSI  Notaires Menton', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('SCP MITOV ARBAUD AMABLE BRIGNON', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('SCP VIALATTE GIRAUD DIMEGLIO NOTAIRES CANNES', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('SCP Vouillon Bouguereau Accorsi', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('SELARL GBM', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('SERNET', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('SFB Antibes', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('SIEVI', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('SIMONUCCI Cabinet', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('SIPME Fréjus - SMGSE Syndicat Mixte du Grand Site de l''Esterel', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('SNDA', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('SPG SECURITE Beaulieu', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('SPPL06', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('ST GELY Notaires LEA MAURI EX LEFEVRE', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('ST PHILIPPE NERI', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('ST PHILIPPE NERI PEDAGOGIE', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('STARCHANGE Antibes', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('STARCHANGE Cannes', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('STARCHANGE juan', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('STON_Depoulpiquet', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('STORELED', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('STRUCTURE DESIGN', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('SUD RIVAGES MENTON', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('Tapis Rouge', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('TAYAC Philippe Patisserie', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('TELECONCEPT TSM', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('TELECONCEPT TSM SALON', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('TELSAM', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('Temmes Monaco', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('TEXTISUN', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('TOULLEC Romain Notaire Antibes', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('Union Locale CGT GRASSE', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('VARLET ROURET IMC4500 et CAP AIL MPC2003', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('VESTA SAM MONACO', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('VGB Avocats Mimont Cannes', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('VISION FUTUR NICE', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('VOLPE CORALIE Notaire Antibes', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('Westminster', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('westminster Direction General GRINDA', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('YOOPALA', NOW());
INSERT IGNORE INTO site (nom, created_at) VALUES ('Yoopala Paris', NOW());

-- ========== PIÈCES (depuis stock) ==========
INSERT IGNORE INTO piece (reference, libelle, type, created_at) VALUES ('reference', 'libelle', 'autre', NOW());
INSERT IGNORE INTO piece (reference, libelle, type, created_at) VALUES ('TNR-IMC5500-N', 'Toner noir RICOH IM C5500', 'toner', NOW());
INSERT IGNORE INTO piece (reference, libelle, type, created_at) VALUES ('BC-IMC5500', 'Bac récupération RICOH IM C5500', 'bac_recup', NOW());
INSERT IGNORE INTO piece (reference, libelle, type, created_at) VALUES ('TNR-IMC3000-N', 'Toner noir RICOH IM C3000', 'toner', NOW());

-- ========== STOCK (via SELECT pour résoudre piece_id et site_id) ==========
INSERT INTO stock (piece_id, site_id, quantite, date_reference, updated_at) SELECT p.id, s.id, 0, '2025-12-31', NOW() FROM piece p, site s WHERE p.reference = 'reference' AND s.nom = 'site' ON DUPLICATE KEY UPDATE quantite = 0, date_reference = '2025-12-31', updated_at = NOW();
INSERT INTO stock (piece_id, site_id, quantite, date_reference, updated_at) SELECT p.id, s.id, 2, '2025-12-31', NOW() FROM piece p, site s WHERE p.reference = 'TNR-IMC5500-N' AND s.nom = 'CIFE' ON DUPLICATE KEY UPDATE quantite = 2, date_reference = '2025-12-31', updated_at = NOW();
INSERT INTO stock (piece_id, site_id, quantite, date_reference, updated_at) SELECT p.id, s.id, 1, '2025-12-31', NOW() FROM piece p, site s WHERE p.reference = 'BC-IMC5500' AND s.nom = 'CIFE' ON DUPLICATE KEY UPDATE quantite = 1, date_reference = '2025-12-31', updated_at = NOW();
INSERT INTO stock (piece_id, site_id, quantite, date_reference, updated_at) SELECT p.id, s.id, 1, '2025-12-31', NOW() FROM piece p, site s WHERE p.reference = 'TNR-IMC3000-N' AND s.nom = 'CABINET MICHEL ROQUEFORT' ON DUPLICATE KEY UPDATE quantite = 1, date_reference = '2025-12-31', updated_at = NOW();

-- Fin