
SET SESSION sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION';

-- l'utilsiateur ecopilote doit exister tous le temps
INSERT INTO f_user (x_user,x_passwd,x_profil,x_desc,x_service,x_tcreat,x_tlogin,x_inventaire,x_astup) VALUES
('ecopilote','jbpojkpsf','ADMIN','ecopilote','ECO-DEX', now(), now(),0,0)
;

-- creation du produit deverminage
INSERT INTO f_ref (x_ref,x_desig,x_lib_court,x_ref_bis,x_domaine,x_tmodif,x_tsortie,x_tentree,x_tinvent,x_fam_ref,x_adr_pref,x_classe,x_emp_res,x_mono_emp,x_outil,x_s_chrono,x_s_libmax,x_s_minmvt,x_e_chrono,x_e_stricte,x_e_minmvt,x_g_lot,x_s_lot_f,x_e_lot_f,x_e_lot_str,x_g_peremp,x_s_peremp_f,x_e_peremp_f,x_e_peremp_str,x_g_quarant,x_e_quarant_f,x_e_quarant_str,x_s_quarant_f,x_g_admin,x_e_admin_str,x_g_condi,x_condi,x_e_condi,x_s_lieu,x_e_lieu,x_alpha_1,x_alpha_2,x_num_1,x_num_2,x_e_admin_f,x_s_admin_f,x_old_ref,x_stk_mini,x_stk_maxi,x_stk_reap,x_cycle_reap,x_reap_mode,x_prix_u,x_pds_u,x_treap,x_unite,x_pmp,x_g_pmp,x_image,x_val_mag,x_dcreat,x_qml_cde,x_qml_serv,x_marche,x_ageps,x_deb_marche,x_fin_marche,x_t2a,x_tva,x_cpt_budg,x_indic_gest,x_couv_min,x_couv_max,x_rupture,x_g_traca,x_actif,x_cache_web,x_delivrance,x_depot,x_lppr,x_type_marche,x_g_traca_mds,x_cip,x_atc,x_ucd,x_liste_med,x_info_web,x_dci,x_forme,x_dose,x_fraction,x_ref_parent,x_adr_ext,x_desig_bis,x_volume,x_robot,x_unit_gest,x_unit_admin,x_coef_conv,x_delai_peremp,x_externe,x_conversion_ucd,x_multidose_par_uf) VALUES
('DEVERMINAGE','SACHET VIDE POUR DEVERMINAGE','','','','2018-04-19 13:52:00','2019-06-04 14:07:18',NULL,NULL,'','','',0,0,0,1,0,0,0,0,0,1,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0.0,0,'','','','',0.0,0.0,0,0,'',0.0,0,0.0,0,'',0.0,0.0,NULL,'',0.0,0,'','','2016-07-12',0,0,'','',NULL,NULL,0,0.0,'','',0,0,'',0,0,0,0,'','','',0,'','','9088776','','','','53','',0.0,'','','','',0,'','',0.0,0,1,0,0)
;
INSERT INTO f_ref (x_ref,x_desig,x_lib_court,x_ref_bis,x_domaine,x_tmodif,x_tsortie,x_tentree,x_tinvent,x_fam_ref,x_adr_pref,x_classe,x_emp_res,x_mono_emp,x_outil,x_s_chrono,x_s_libmax,x_s_minmvt,x_e_chrono,x_e_stricte,x_e_minmvt,x_g_lot,x_s_lot_f,x_e_lot_f,x_e_lot_str,x_g_peremp,x_s_peremp_f,x_e_peremp_f,x_e_peremp_str,x_g_quarant,x_e_quarant_f,x_e_quarant_str,x_s_quarant_f,x_g_admin,x_e_admin_str,x_g_condi,x_condi,x_e_condi,x_s_lieu,x_e_lieu,x_alpha_1,x_alpha_2,x_num_1,x_num_2,x_e_admin_f,x_s_admin_f,x_old_ref,x_stk_mini,x_stk_maxi,x_stk_reap,x_cycle_reap,x_reap_mode,x_prix_u,x_pds_u,x_treap,x_unite,x_pmp,x_g_pmp,x_image,x_val_mag,x_dcreat,x_qml_cde,x_qml_serv,x_marche,x_ageps,x_deb_marche,x_fin_marche,x_t2a,x_tva,x_cpt_budg,x_indic_gest,x_couv_min,x_couv_max,x_rupture,x_g_traca,x_actif,x_cache_web,x_delivrance,x_depot,x_lppr,x_type_marche,x_g_traca_mds,x_cip,x_atc,x_ucd,x_liste_med,x_info_web,x_dci,x_forme,x_dose,x_fraction,x_ref_parent,x_adr_ext,x_desig_bis,x_volume,x_robot,x_unit_gest,x_unit_admin,x_coef_conv,x_delai_peremp,x_externe,x_conversion_ucd,x_multidose_par_uf,x_com_med,x_bac) VALUES
('DOLIPRANE','DOLIPRANE 100mg','','','','2018-04-19 13:52:00','2019-06-04 14:07:18','0000-00-00 00:00:00','0000-00-00 00:00:00','','','',0,0,0,1,0,0,0,0,0,1,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,'','','','',0,0,0,0,'',0,0,0,0,'',0,0,'0000-00-00 00:00:00','',0,0,'','','2016-07-12',0,0,'','','0000-00-00','0000-00-00',0,0,'','',0,0,'',0,0,0,0,'','','',0,'','','9239091','','','','53','',0,'','','','',0,'','',0,0,1,0,0,'',0)
;
INSERT INTO f_ref (x_ref,x_desig,x_lib_court,x_ref_bis,x_domaine,x_tmodif,x_tsortie,x_tentree,x_tinvent,x_fam_ref,x_adr_pref,x_classe,x_emp_res,x_mono_emp,x_outil,x_s_chrono,x_s_libmax,x_s_minmvt,x_e_chrono,x_e_stricte,x_e_minmvt,x_g_lot,x_s_lot_f,x_e_lot_f,x_e_lot_str,x_g_peremp,x_s_peremp_f,x_e_peremp_f,x_e_peremp_str,x_g_quarant,x_e_quarant_f,x_e_quarant_str,x_s_quarant_f,x_g_admin,x_e_admin_str,x_g_condi,x_condi,x_e_condi,x_s_lieu,x_e_lieu,x_alpha_1,x_alpha_2,x_num_1,x_num_2,x_e_admin_f,x_s_admin_f,x_old_ref,x_stk_mini,x_stk_maxi,x_stk_reap,x_cycle_reap,x_reap_mode,x_prix_u,x_pds_u,x_treap,x_unite,x_pmp,x_g_pmp,x_image,x_val_mag,x_dcreat,x_qml_cde,x_qml_serv,x_marche,x_ageps,x_deb_marche,x_fin_marche,x_t2a,x_tva,x_cpt_budg,x_indic_gest,x_couv_min,x_couv_max,x_rupture,x_g_traca,x_actif,x_cache_web,x_delivrance,x_depot,x_lppr,x_type_marche,x_g_traca_mds,x_cip,x_atc,x_ucd,x_liste_med,x_info_web,x_dci,x_forme,x_dose,x_fraction,x_ref_parent,x_adr_ext,x_desig_bis,x_volume,x_robot,x_unit_gest,x_unit_admin,x_coef_conv,x_delai_peremp,x_externe,x_conversion_ucd,x_multidose_par_uf,x_com_med,x_bac) VALUES
('DOLITEST','DOLIPRANE TEST 100mg','','','','2018-04-19 13:52:00','2019-06-04 14:07:18','0000-00-00 00:00:00','0000-00-00 00:00:00','','','',0,0,0,1,0,0,0,0,0,1,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,'','','','',0,0,0,0,'',0,0,0,0,'',0,0,'0000-00-00 00:00:00','',0,0,'','','2016-07-12',0,0,'','','0000-00-00','0000-00-00',0,0,'','',0,0,'',0,0,0,0,'','','',0,'','','9239091','','','','53','',0,'','','','',0,'','',0,0,1,0,0,'',0)
;

-- gestion des postes
INSERT INTO f_poste (x_poste,x_pc,x_tdepuis,x_ecr,x_tostop,x_tversion,x_proc_pid) VALUES
('COUPE_1','','0000-00-00 00:00:00','',0,'0000-00-00 00:00:00',0)
,('CUEILLETTE_1','','0000-00-00 00:00:00','',0,'0000-00-00 00:00:00',0)
,('SERVEUR','ECODEX','2019-06-04 09:08:15','Mouvements par liste',0,'2018-09-25 14:03:42',0)
,('CUEILLETTE_2','','0000-00-00 00:00:00','',0,'0000-00-00 00:00:00',0)
,('ASTUS_1','SERVEUR','2019-12-23 17:13:08','ASR 2019.12.1.0',0,'0000-00-00 00:00:00',0)
,('ASTUS_2','SERVEUR','0000-00-00 00:00:00','',0,'0000-00-00 00:00:00',0);

-- gestion des magasins
INSERT INTO f_mag (x_mag,x_type_mag,x_dim_2,x_dim_3,x_dim_4,x_dim_5,x_lib_2,x_lib_3,x_lib_4,x_lib_5,x_nb_dim,x_bmp,x_compo_x,x_compo_y,x_emp_res,x_statique,x_pds_max,x_dim_pds,x_multiref,x_parcours,x_palettier,x_armoire,x_dest,x_tampon,x_adr_tampon,x_coef_aut,x_eco_type,x_id_zone,x_inhiber,x_split_liste,x_id_robot) VALUES
 ('ST1','CUEILLETTE_1',2,28,17,4,'ALLEE','COLONNE','LIGNE','PROFONDEUR',5,'',0,5,0,0,0,0,0,'A',0,'','',0,'',35000,'C',0,0,0,1)
,('RE1','RETOUR',1,4,17,2,'ALLEE','COLONNE','LIGNE','PROFONDEUR',5,'',0,5,0,0,0,0,0,'A',0,'','',0,'',35000,'R',0,0,0,1)
,('ST2','CUEILLETTE_2',2,28,17,4,'ALLEE','COLONNE','LIGNE','PROFONDEUR',5,'',0,5,0,0,0,0,0,'A',0,'','',0,'',40000,'C',0,0,0,1)
,('RE2','RETOUR',1,4,17,2,'ALLEE','COLONNE','LIGNE','PROFONDEUR',5,'',0,5,0,0,0,0,0,'A',0,'','',0,'',40000,'R',0,0,0,1)
,('U01','ASTUS_1',22,12,2,0,'LIGNE','COLONNE','PROFONDEUR','',4,'',0,0,0,0,0,0,0,'A',0,'','',0,'',0,'A',0,0,0,1)
,('U02','ASTUS_2',22,12,2,0,'LIGNE','COLONNE','PROFONDEUR','',4,'',0,0,0,0,0,0,0,'A',0,'','',0,'',0,'A',0,0,0,1);

-- code blocage emplacement
INSERT INTO f_defaut (x_pk,x_valeur,x_libelle) VALUES
 (1,2,'Boite vide'), (2,3,'Sachet non lu'), (3,4,'Produit différent')
,(4,5,'Absence BL sur globale'), (5,6,'Produit périmé'), (6,7,'Boite absente')
,(7,8,'Erreur prise sachet'), (8,9,'Autre'), (9,15,'Erreur prise boite')
,(10,16,'Erreur pose boite');

-- creation des emplacements
-- emplacement de coupe
INSERT INTO f_adr (x_adr,x_etat,x_format,x_nb_div,x_classe,x_dim_x,x_dim_y,x_princ,x_adr_topo,x_mag,x_contenant,x_serial,x_bloque,x_qte_posage,x_nouv_qte_posage,x_emplacement,x_nouv_emplacement,x_stup,x_bloque_reappro,x_service) VALUES
('DC1.  1.  1','L','BOITE PASS',2,'',1,2,1,'','DC1','000042551','180926A310200',0,0,0,'','',0,0,0)
,('DC1.  2.  1','L','BOITE PASS',2,'',1,2,1,'','DC1','000051186','180926A310240',0,0,0,'','',0,0,0)
,('DC1.  3.  1','L','BOITE PASS',2,'',1,2,1,'','DC1','','160913A001',0,0,0,'','',0,0,0)
,('DC1.  4.  1','L','BOITE PASS',2,'',1,2,1,'','DC1','000045983','160913A002',0,0,0,'','',0,0,0)
,('DC1.  5.  1','L','BOITE PASS',2,'',1,2,1,'','DC1','000044303','160913A003',0,0,0,'','',0,0,0)
,('DC1.  6.  1','L','BOITE PASS',2,'',1,2,1,'','DC1','000050586','160913A004',0,0,0,'','',0,0,0);

-- emplacement de stock
INSERT INTO f_adr (x_adr,x_etat,x_format,x_nb_div,x_classe,x_dim_x,x_dim_y,x_princ,x_adr_topo,x_mag,x_contenant,x_serial,x_bloque,x_qte_posage,x_nouv_qte_posage,x_emplacement,x_nouv_emplacement,x_stup,x_bloque_reappro,x_service) VALUES
 ('ST1.  1.  5.  1.  1','O','BOITE PASS',2,'',1,2,1,'','ST1','000038166','',7,0,0,'','',0,0,0)
,('ST1.  1.  5.  1.  3','O','BOITE PASS',2,'',1,2,1,'','ST1','000050273','',7,0,0,'','',0,0,0)
,('ST1.  1.  5.  2.  1','O','BOITE PASS',2,'',1,2,1,'','ST1','000039251','',0,0,0,'','',0,0,0)
,('ST1.  1.  5.  2.  3','L','BOITE PASS',2,'',1,2,1,'','ST1','000046073','',0,0,0,'','',0,0,0)
,('ST1.  1.  5.  3.  1','O','BOITE PASS',2,'',1,2,1,'','ST1','000044379','',0,0,0,'','',0,0,0)
,('ST1.  1.  5.  3.  3','O','BOITE PASS',2,'',1,2,1,'','ST1','000046627','',0,0,0,'','',0,0,0)
,('ST1.  1.  5.  4.  1','O','BOITE PASS',2,'',1,2,1,'','ST1','000051086','',0,0,0,'','',0,0,0)
,('ST1.  1.  5.  4.  3','L','BOITE PASS',2,'',1,2,1,'','ST1','000044631','',0,0,0,'','',0,0,0)
,('ST1.  1.  5.  5.  1','O','BOITE PASS',2,'',1,2,1,'','ST1','000040606','',0,0,0,'','',0,0,0)
,('ST1.  1.  5.  5.  3','L','BOITE PASS',2,'',1,2,1,'','ST1','000044437','',0,0,0,'','',0,0,0);
INSERT INTO f_adr (x_adr,x_etat,x_format,x_nb_div,x_classe,x_dim_x,x_dim_y,x_princ,x_adr_topo,x_mag,x_contenant,x_serial,x_bloque,x_qte_posage,x_nouv_qte_posage,x_emplacement,x_nouv_emplacement,x_stup,x_bloque_reappro,x_service) VALUES
 ('ST1.  1.  5.  6.  1','O','BOITE PASS',2,'',1,2,1,'','ST1','000046930','',0,0,0,'','',0,0,0)
,('ST1.  1.  5.  6.  3','L','BOITE PASS',2,'',1,2,1,'','ST1','000050380','',0,0,0,'','',0,0,0)
,('ST1.  1.  5.  7.  1','O','BOITE PASS',2,'',1,2,1,'','ST1','000001682','',0,0,0,'','',0,0,0)
,('ST1.  1.  5.  7.  3','O','BOITE PASS',2,'',1,2,1,'','ST1','000045765','',0,0,0,'','',0,0,0)
,('ST1.  1.  5.  8.  1','O','BOITE PASS',2,'',1,2,1,'','ST1','000049114','',0,0,0,'','',0,0,0)
,('ST1.  1.  5.  8.  3','L','BOITE PASS',2,'',1,2,1,'','ST1','000044315','',0,0,0,'','',0,0,0)
,('ST1.  1.  5.  9.  1','O','BOITE PASS',2,'',1,2,1,'','ST1','000044658','',6,0,0,'','',0,0,0)
,('ST1.  1.  5.  9.  3','L','BOITE PASS',2,'',1,2,1,'','ST1','000043200','',6,0,0,'','',0,0,0)
,('ST1.  1.  5. 10.  1','L','BOITE PASS',2,'',1,2,1,'','ST1','000044340','',0,0,0,'','',0,0,0)
,('ST1.  1.  5. 10.  3','L','BOITE PASS',2,'',1,2,1,'','ST1','000046107','',0,0,0,'','',0,0,0);

-- emplacement stock ST2
INSERT INTO f_adr (x_adr,x_etat,x_format,x_nb_div,x_classe,x_dim_x,x_dim_y,x_princ,x_adr_topo,x_mag,x_contenant,x_serial,x_bloque,x_qte_posage,x_nouv_qte_posage,x_emplacement,x_nouv_emplacement,x_stup,x_bloque_reappro,x_service) VALUES
('ST2.  1.  6.  1.  1','O','BOITE PASS',2,'',1,2,1,'','ST2','000037955','',0,0,0,'','',0,0,0)
,('ST2.  1.  6.  1.  3','L','BOITE PASS',2,'',1,2,1,'','ST2','000020894','',0,0,0,'','',0,0,0)
,('ST2.  1.  6.  2.  1','O','BOITE PASS',2,'',1,2,1,'','ST2','000040173','',0,0,0,'','',0,0,0)
,('ST2.  1.  6.  2.  3','L','BOITE PASS',2,'',1,2,1,'','ST2','000049143','',0,0,0,'','',0,0,0)
,('ST2.  1.  6.  3.  1','O','BOITE PASS',2,'',1,2,1,'','ST2','000042332','',0,0,0,'','',0,0,0)
,('ST2.  1.  6.  3.  3','L','BOITE PASS',2,'',1,2,1,'','ST2','000050887','',0,0,0,'','',0,0,0)
,('ST2.  1.  6.  4.  1','O','BOITE PASS',2,'',1,2,1,'','ST2','000036772','',0,0,0,'','',0,0,0)
,('ST2.  1.  6.  4.  3','L','BOITE PASS',2,'',1,2,1,'','ST2','000042206','',0,0,0,'','',0,0,0)
,('ST2.  1.  6.  5.  1','O','BOITE PASS',2,'',1,2,1,'','ST2','000042846','',0,0,0,'','',0,0,0)
,('ST2.  1.  6.  5.  3','O','BOITE PASS',2,'',1,2,1,'','ST2','000049195','',0,0,0,'','',0,0,0);
INSERT INTO f_adr (x_adr,x_etat,x_format,x_nb_div,x_classe,x_dim_x,x_dim_y,x_princ,x_adr_topo,x_mag,x_contenant,x_serial,x_bloque,x_qte_posage,x_nouv_qte_posage,x_emplacement,x_nouv_emplacement,x_stup,x_bloque_reappro,x_service) VALUES
('ST2.  1.  6.  6.  1','O','BOITE PASS',2,'',1,2,1,'','ST2','000047059','',0,0,0,'','',0,0,0)
,('ST2.  1.  6.  6.  3','L','BOITE PASS',2,'',1,2,1,'','ST2','000047734','',0,0,0,'','',0,0,0)
,('ST2.  1.  6.  7.  1','O','BOITE PASS',2,'',1,2,1,'','ST2','000039244','',0,0,0,'','',0,0,0)
,('ST2.  1.  6.  7.  3','L','BOITE PASS',2,'',1,2,1,'','ST2','000041556','',0,0,0,'','',0,0,0)
,('ST2.  1.  6.  8.  1','O','BOITE PASS',2,'',1,2,1,'','ST2','000038291','',0,0,0,'','',0,0,0)
,('ST2.  1.  6.  8.  3','L','BOITE PASS',2,'',1,2,1,'','ST2','000049043','',0,0,0,'','',0,0,0)
,('ST2.  1.  6.  9.  1','O','BOITE PASS',2,'',1,2,1,'','ST2','000046875','',0,0,0,'','',0,0,0)
,('ST2.  1.  6.  9.  3','L','BOITE PASS',2,'',1,2,1,'','ST2','000046026','',0,0,0,'','',0,0,0)
,('ST2.  1.  6. 10.  1','O','BOITE PASS',2,'',1,2,1,'','ST2','000014353','',0,0,0,'','',0,0,0)
,('ST2.  1.  6. 10.  3','O','BOITE PASS',2,'',1,2,1,'','ST2','000044402','',0,0,0,'','',0,0,0);

-- emplacement ASTUS
INSERT INTO f_adr (x_adr,x_etat,x_format,x_nb_div,x_classe,x_dim_x,x_dim_y,x_princ,x_adr_topo,x_mag,x_contenant,x_serial,x_bloque,x_qte_posage,x_nouv_qte_posage,x_emplacement,x_nouv_emplacement,x_stup,x_bloque_reappro,x_service) VALUES
('U01.  A.  1.  1','O','BAC 1/7 B',1,'',1,1,1,'','U01','bP1/7112448','',0,10,0,'319347','',0,0,0)
,('U01.  A.  1.  2','O','BAC 1/7 B',1,'',1,1,1,'','U01','bP1/7112455','',0,10,0,'319347','',0,0,0)
,('U01.  A.  2.  1','O','BAC 1/7 B',1,'',1,1,1,'','U01','bP1/710828','',0,15,0,'330160','',0,0,0)
,('U01.  A.  2.  2','O','BAC 1/7 B',1,'',1,1,1,'','U01','bP1/7112323','',0,15,0,'330160','',0,0,0)
,('U01.  A.  3.  1','O','BAC 1/7 B',1,'',1,1,1,'','U01','bP1/7112339','',0,10,0,'326444','',0,0,0)
,('U01.  A.  3.  2','O','BAC 1/7 B',1,'',1,1,1,'','U01','bP1/710827','',0,10,0,'326444','',0,0,0)
,('U01.  A.  4.  1','O','BAC 1/7 B',1,'',1,1,1,'','U01','bP1/7112345','',0,5,0,'302565','',0,0,0)
,('U01.  A.  4.  2','O','BAC 1/7 B',1,'',1,1,1,'','U01','bP1/710891','',0,5,0,'302565','',0,0,0)
,('U01.  A.  5.  1','L','BAC 1/7 B',1,'',1,1,1,'','U01','000050278','',0,10,0,'340094','',0,0,0)
,('U01.  A.  5.  2','O','BAC 1/7 B',1,'',1,1,1,'','U01','bP1/7112510','',0,10,0,'340094','',0,0,0)
;
INSERT INTO f_adr (x_adr,x_etat,x_format,x_nb_div,x_classe,x_dim_x,x_dim_y,x_princ,x_adr_topo,x_mag,x_contenant,x_serial,x_bloque,x_qte_posage,x_nouv_qte_posage,x_emplacement,x_nouv_emplacement,x_stup,x_bloque_reappro,x_service) VALUES
('U01.  A.  6.  1','O','BAC 1/7 B',1,'',1,1,1,'','U01','bP1/710805','',0,10,0,'344265','',0,0,0)
,('U01.  A.  6.  2','O','BAC 1/7 B',1,'',1,1,1,'','U01','bP1/710818','',0,10,0,'344265','',0,0,0)
,('U01.  A.  7.  1','L','BAC 1/7 B',1,'',1,1,1,'','U01','','',0,7,0,'565796','',0,0,0)
,('U01.  A.  7.  2','L','BAC 1/7 B',1,'',1,1,1,'','U01','','',0,7,0,'565796','',0,0,0)
,('U01.  A.  8.  1','O','BAC 1/7 B',1,'',1,1,1,'','U01','bP1/710739','',0,6,0,'351773','',0,0,0)
,('U01.  A.  8.  2','L','BAC 1/7 B',1,'',1,1,1,'','U01','bP1/7112460','',0,6,0,'351773','',0,0,0)
,('U01.  A.  9.  1','O','BAC 1/3 B',1,'',1,1,1,'','U01','bP1/331247','',0,20,0,'329761','',0,0,0)
,('U01.  A.  9.  2','O','BAC 1/3 B',1,'',1,1,1,'','U01','bP1/331296','',0,20,0,'329761','',0,0,0)
,('U01.  B.  1.  1','O','BAC 1/7 B',1,'',1,1,1,'','U01','bP1/7112311','',0,10,0,'352970','',0,0,0)
,('U01.  B.  1.  2','L','BAC 1/7 B',1,'',1,1,1,'','U01','bP1/710738','',0,10,0,'352970','',0,0,0)
;
INSERT INTO f_adr (x_adr,x_etat,x_format,x_nb_div,x_classe,x_dim_x,x_dim_y,x_princ,x_adr_topo,x_mag,x_contenant,x_serial,x_bloque,x_qte_posage,x_nouv_qte_posage,x_emplacement,x_nouv_emplacement,x_stup,x_bloque_reappro,x_service) VALUES
('U01.  B.  2.  1','L','BAC 1/7 B',1,'',1,1,1,'','U01','','',0,10,0,'329350','',0,0,0)
,('U01.  B.  2.  2','L','BAC 1/7 B',1,'',1,1,1,'','U01','','',0,10,0,'329350','',0,0,0)
,('U01.  B.  3.  1','L','BAC 1/7 B',1,'',1,1,1,'','U01','','',0,14,0,'338336','',0,0,0)
,('U01.  B.  3.  2','L','BAC 1/7 B',1,'',1,1,1,'','U01','','',0,14,0,'338336','',0,0,0)
,('U01.  B.  4.  1','O','BAC 1/7 B',1,'',1,1,1,'','U01','bP1/710846','',0,10,0,'317238','',0,0,0)
,('U01.  B.  4.  2','O','BAC 1/7 B',1,'',1,1,1,'','U01','bP1/7112432','',0,10,0,'317238','',0,0,0)
,('U01.  B.  5.  1','O','BAC 1/7 B',1,'',1,1,1,'','U01','bP1/7112360','',0,10,0,'300435','',0,0,0)
,('U01.  B.  5.  2','L','BAC 1/7 B',1,'',1,1,1,'','U01','bP1/7112360','',0,10,0,'300435','',0,0,0)
,('U01.  B.  6.  1','L','BAC 1/7 B',1,'',1,1,1,'','U01','','',0,7,0,'315396','',0,0,0)
,('U01.  B.  6.  2','L','BAC 1/7 B',1,'',1,1,1,'','U01','','',0,7,0,'315396','',0,0,0)
;
INSERT INTO f_adr (x_adr,x_etat,x_format,x_nb_div,x_classe,x_dim_x,x_dim_y,x_princ,x_adr_topo,x_mag,x_contenant,x_serial,x_bloque,x_qte_posage,x_nouv_qte_posage,x_emplacement,x_nouv_emplacement,x_stup,x_bloque_reappro,x_service) VALUES
('U01.  B.  7.  1','L','BAC 1/7 B',1,'',1,1,1,'','U01','','',0,10,0,'347945','',0,0,0)
,('U01.  B.  7.  2','L','BAC 1/7 B',1,'',1,1,1,'','U01','','',0,10,0,'347945','',0,0,0)
,('U01.  B.  8.  1','L','BAC 1/7 B',1,'',1,1,1,'','U01','','',0,10,0,'314995','',0,0,0)
,('U01.  B.  8.  2','L','BAC 1/7 B',1,'',1,1,1,'','U01','','',0,10,0,'314995','',0,0,0)
,('U01.  B.  9.  1','L','BAC 1/3 B',1,'',1,1,1,'','U01','','',0,10,0,'348762','',0,0,0)
,('U01.  B.  9.  2','L','BAC 1/3 B',1,'',1,1,1,'','U01','','',0,10,0,'348762','',0,0,0)
;
INSERT INTO f_stock (x_adr,x_ref,x_qte,x_id_fifo,x_lot,x_admin,x_tperemp,x_tquarant,x_tentree,x_tsortie,x_tinvent,x_info,x_condi,x_bloque,x_contenant,x_mag,x_reinteg,x_manquant,x_ucd,x_etat,x_serial,x_zone_admin,x_fraction,x_capa) VALUES
('ST1.  1.  5.  2.  1','DEVERMINAGE',1,1,'1048','','2028-10-31 00:00:00','0000-00-00 00:00:00','2018-08-06 07:31:07','2016-12-05 09:56:48','2019-01-07 10:56:38','',0,0,'000036039','ST1',1,1,'3400893730331','','161109A120056','CUEILLETTE_1',100,60)
;

INSERT INTO f_seuil (x_ref,x_zone,x_stk_mini,x_stk_maxi,x_fraction) VALUES
('DEVERMINAGE','CUEILLETTE_1',10,50,100)
,('DEVERMINAGE','CUEILLETTE_1',5,25,50)
,('DEVERMINAGE','CUEILLETTE_1',2,10,25)
,('DEVERMINAGE','CUEILLETTE_2',8,40,100)
,('DEVERMINAGE','CUEILLETTE_2',4,20,50)
;

INSERT INTO f_seuil (x_ref,x_zone,x_stk_mini,x_stk_maxi,x_fraction) VALUES
('DOLIPRANE','CUEILLETTE_2',10,20,100)
,('DOLIPRANE','CUEILLETTE_1',10,20,100)
,('DOLIPRANE','CUEILLETTE_2',10,20,50)
;
