INSERT INTO fait.fait_assignment_condition  SELECT  ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,20),  ROUND(RAND(), 0), substring(MD5(RAND()*1000000000),1,150), substring(MD5(RAND()*1000000000),1,4), CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND FROM seq_1_to_2000000;
INSERT INTO fait.fait_assignments  SELECT  ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,3), substring(MD5(RAND()*1000000000),1,10), substring(MD5(RAND()*1000000000),1,40), substring(MD5(RAND()*1000000000),1,8), substring(MD5(RAND()*1000000000),1,48), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,5), substring(MD5(RAND()*1000000000),1,510), substring(MD5(RAND()*1000000000),1,256), substring(MD5(RAND()*1000000000),1,359), substring(MD5(RAND()*1000000000),1,30), substring(MD5(RAND()*1000000000),1,100), substring(MD5(RAND()*1000000000),1,2), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0),  ROUND(RAND() * 10000, 0),  ROUND(RAND() * 10000, 0),  ROUND(RAND() * 10000, 0),  ROUND(RAND() * 10000, 0), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,5), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,10), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,12), substring(MD5(RAND()*1000000000),1,1), substring(MD5(RAND()*1000000000),1,40), substring(MD5(RAND()*1000000000),1,510), substring(MD5(RAND()*1000000000),1,40), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,20), substring(MD5(RAND()),1,6), substring(MD5(RAND()),1,6), ROUND(RAND() * 1, 0), ROUND(RAND() * 999, 2), substring(MD5(RAND()*1000000000),1,7), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,50), substring(MD5(RAND()*1000000000),1,150), substring(MD5(RAND()*1000000000),1,2000), substring(MD5(RAND()*1000000000),1,10), substring(MD5(RAND()*1000000000),1,100), substring(MD5(RAND()*1000000000),1,100), substring(MD5(RAND()*1000000000),1,100), ROUND(RAND() * 1, 0),  ROUND(RAND() * 127, 0), substring(MD5(RAND()*1000000000),1,50), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 10000000, 5), substring(MD5(RAND()*1000000000),1,3), substring(MD5(RAND()*1000000000),1,20), ROUND(RAND() * 1, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0), substring(MD5(RAND()*1000000000),1,1), CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND,  ROUND(RAND() * 127, 0), CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND FROM seq_1_to_2000000;
INSERT INTO fait.fait_bulletin_salaire  SELECT  ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,3), substring(MD5(RAND()*1000000000),1,10), ROUND(RAND() * 10000000, 5), substring(MD5(RAND()*1000000000),1,50), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 10000000, 5), substring(MD5(RAND()*1000000000),1,5), substring(MD5(RAND()*1000000000),1,510),  ROUND(RAND() * 127, 0), substring(MD5(RAND()*1000000000),1,30), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,10), substring(MD5(RAND()*1000000000),1,50), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), substring(MD5(RAND()),1,6), CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND,  ROUND(RAND() * 127, 0) FROM seq_1_to_2000000;
INSERT INTO fait.fait_contrat_mission  SELECT  ROUND(RAND() * 1, 0),  ROUND(RAND() * 32000, 0), substring(MD5(RAND()*1000000000),1,40), substring(MD5(RAND()*1000000000),1,8), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,40), substring(MD5(RAND()*1000000000),1,8), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0),  ROUND(RAND() * 10000, 0),  ROUND(RAND() * 10000, 0), substring(MD5(RAND()*1000000000),1,10), substring(MD5(RAND()*1000000000),1,510), substring(MD5(RAND()*1000000000),1,5), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), substring(MD5(RAND()),1,6), substring(MD5(RAND()),1,6), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,40), substring(MD5(RAND()*1000000000),1,10), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,150), CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND FROM seq_1_to_2000000;
INSERT INTO fait.fait_contrat_salarie  SELECT  ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,40), substring(MD5(RAND()*1000000000),1,8), substring(MD5(RAND()*1000000000),1,10), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,3), substring(MD5(RAND()*1000000000),1,1), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0),  ROUND(RAND() * 127, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,10), substring(MD5(RAND()*1000000000),1,50), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,5), substring(MD5(RAND()*1000000000),1,510), substring(MD5(RAND()*1000000000),1,45), substring(MD5(RAND()*1000000000),1,510), substring(MD5(RAND()*1000000000),1,40), substring(MD5(RAND()*1000000000),1,10), substring(MD5(RAND()*1000000000),1,400), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,50), substring(MD5(RAND()*1000000000),1,150), substring(MD5(RAND()*1000000000),1,100), substring(MD5(RAND()*1000000000),1,1000), substring(MD5(RAND()*1000000000),1,1000), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 10000000, 5),  ROUND(RAND() * 10000, 0),  ROUND(RAND() * 10000, 0),  ROUND(RAND() * 10000, 0),  ROUND(RAND() * 10000, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,2), substring(MD5(RAND()),1,6), ROUND(RAND() * 1, 0), CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND FROM seq_1_to_2000000;
INSERT INTO fait.fait_doc_signature  SELECT  ROUND(RAND() * 1, 0), CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,30), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), substring(MD5(RAND()),1,6), substring(MD5(RAND()),1,6), CURRENT_DATE - INTERVAL FLOOR(RAND() * 365) DAY, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND FROM seq_1_to_2000000;
INSERT INTO fait.fait_expression  SELECT  ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,3), substring(MD5(RAND()*1000000000),1,10), substring(MD5(RAND()*1000000000),1,30), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,5), substring(MD5(RAND()*1000000000),1,510), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,40), substring(MD5(RAND()*1000000000),1,10), substring(MD5(RAND()*1000000000),1,2200), substring(MD5(RAND()*1000000000),1,256), substring(MD5(RAND()*1000000000),1,256), substring(MD5(RAND()*1000000000),1,1000), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,50), substring(MD5(RAND()*1000000000),1,150), substring(MD5(RAND()*1000000000),1,2000), substring(MD5(RAND()*1000000000),1,10), substring(MD5(RAND()*1000000000),1,256), substring(MD5(RAND()*1000000000),1,1000), substring(MD5(RAND()*1000000000),1,1000), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), substring(MD5(RAND()),1,2), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,50), substring(MD5(RAND()*1000000000),1,1000), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,10), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,30), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0),  ROUND(RAND() * 32000, 0),  ROUND(RAND() * 32000, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,1), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,3), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND,  ROUND(RAND() * 127, 0) FROM seq_1_to_2000000;
INSERT INTO fait.fait_expression_diffusion  SELECT  substring(MD5(RAND()),1,20), ROUND(RAND() * 1, 0), substring(MD5(RAND()),1,3), ROUND(RAND() * 1, 0), CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND,  ROUND(RAND() * 127, 0) FROM seq_1_to_2000000;
INSERT INTO fait.fait_expression_poste  SELECT  substring(MD5(RAND()),1,20), ROUND(RAND() * 1, 0), substring(MD5(RAND()),1,3), CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND,  ROUND(RAND() * 127, 0) FROM seq_1_to_2000000;
INSERT INTO fait.fait_integration  SELECT  ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,3), CURRENT_DATE - INTERVAL FLOOR(RAND() * 365) DAY, substring(MD5(RAND()),1,2), substring(MD5(RAND()),1,2), substring(MD5(RAND()),1,2), CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, substring(MD5(RAND()),1,1), substring(MD5(RAND()),1,1), substring(MD5(RAND()*1000000000),1,30), substring(MD5(RAND()*1000000000),1,30), ROUND(RAND() * 1, 0), substring(MD5(RAND()),1,4), substring(MD5(RAND()),1,5),  ROUND(RAND() * 127, 0), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,100), substring(MD5(RAND()*1000000000),1,250), substring(MD5(RAND()*1000000000),1,250), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND FROM seq_1_to_2000000;

INSERT INTO fait.fait_integration_doc  SELECT  ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), CURRENT_DATE - INTERVAL FLOOR(RAND() * 365) DAY, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, substring(MD5(RAND()*1000000000),1,30), substring(MD5(RAND()*1000000000),1,5), substring(MD5(RAND()*1000000000),1,50), substring(MD5(RAND()*1000000000),1,30), substring(MD5(RAND()*1000000000),1,30), substring(MD5(RAND()*1000000000),1,20), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,10), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND FROM seq_1_to_2000000;
INSERT INTO fait.fait_invoice_entete  SELECT  ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,3), substring(MD5(RAND()*1000000000),1,10), substring(MD5(RAND()*1000000000),1,30), substring(MD5(RAND()*1000000000),1,40), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,7), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 10000000, 5), substring(MD5(RAND()*1000000000),1,14), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,103), substring(MD5(RAND()*1000000000),1,100), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), substring(MD5(RAND()),1,6), substring(MD5(RAND()),1,6), ROUND(RAND() * 1, 0), ROUND(RAND() * 99, 2),  ROUND(RAND() * 32000, 0), CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, ROUND(RAND() * 10000000, 5), CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND,  ROUND(RAND() * 127, 0) FROM seq_1_to_2000000;
INSERT INTO fait.fait_invoice_line  SELECT  ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,3), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,30), ROUND(RAND() * 10000000, 5), substring(MD5(RAND()*1000000000),1,30), substring(MD5(RAND()*1000000000),1,500), ROUND(RAND() * 10000000, 5), substring(MD5(RAND()*1000000000),1,30), ROUND(RAND() * 10000000, 5),  ROUND(RAND() * 127, 0), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 10000000, 5), substring(MD5(RAND()*1000000000),1,10), CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND,  ROUND(RAND() * 127, 0) FROM seq_1_to_2000000;
INSERT INTO fait.fait_invoice_raf  SELECT  ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,3), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,40), substring(MD5(RAND()*1000000000),1,300), substring(MD5(RAND()*1000000000),1,600), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,200), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 10000000, 5), substring(MD5(RAND()*1000000000),1,10), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,50), substring(MD5(RAND()*1000000000),1,150), substring(MD5(RAND()*1000000000),1,2000), substring(MD5(RAND()*1000000000),1,10), substring(MD5(RAND()*1000000000),1,100), substring(MD5(RAND()*1000000000),1,50), substring(MD5(RAND()*1000000000),1,50), substring(MD5(RAND()*1000000000),1,7), CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND,  ROUND(RAND() * 127, 0) FROM seq_1_to_2000000;
INSERT INTO fait.fait_invoice_rubrique  SELECT  ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,3), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,100), substring(MD5(RAND()*1000000000),1,3), substring(MD5(RAND()*1000000000),1,100), substring(MD5(RAND()*1000000000),1,3), substring(MD5(RAND()*1000000000),1,100), substring(MD5(RAND()*1000000000),1,3), substring(MD5(RAND()*1000000000),1,100), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 10000000, 5), substring(MD5(RAND()*1000000000),1,15), CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND,  ROUND(RAND() * 127, 0) FROM seq_1_to_2000000;
INSERT INTO fait.fait_mission  SELECT  substring(MD5(RAND()*1000000000),1,15), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,3), substring(MD5(RAND()*1000000000),1,50), substring(MD5(RAND()*1000000000),1,5), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,256), substring(MD5(RAND()*1000000000),1,100), substring(MD5(RAND()*1000000000),1,359), substring(MD5(RAND()*1000000000),1,4), substring(MD5(RAND()*1000000000),1,40), substring(MD5(RAND()*1000000000),1,100), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 99999999, 2), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0), substring(MD5(RAND()*1000000000),1,10), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0),  ROUND(RAND() * 32000, 0), substring(MD5(RAND()*1000000000),1,40), ROUND(RAND() * 99, 2), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,50), substring(MD5(RAND()*1000000000),1,150), substring(MD5(RAND()*1000000000),1,2000), substring(MD5(RAND()*1000000000),1,10), substring(MD5(RAND()*1000000000),1,100), substring(MD5(RAND()*1000000000),1,50), substring(MD5(RAND()*1000000000),1,50), ROUND(RAND() * 1, 0),  ROUND(RAND() * 32000, 0), substring(MD5(RAND()*1000000000),1,50), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 10000000, 5),  ROUND(RAND() * 32000, 0), CURRENT_DATE - INTERVAL FLOOR(RAND() * 365) DAY, CURRENT_DATE - INTERVAL FLOOR(RAND() * 365) DAY, substring(MD5(RAND()*1000000000),1,3), substring(MD5(RAND()*1000000000),1,10),  ROUND(RAND(), 0),  ROUND(RAND(), 0), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 10000000, 5), CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, substring(MD5(RAND()),1,2), ROUND(RAND() * 10000000, 5), substring(MD5(RAND()*1000000000),1,3), substring(MD5(RAND()*1000000000),1,20), CURRENT_DATE - INTERVAL FLOOR(RAND() * 365) DAY, CURRENT_DATE - INTERVAL FLOOR(RAND() * 365) DAY, substring(MD5(RAND()*1000000000),1,8), substring(MD5(RAND()*1000000000),1,100), substring(MD5(RAND()*1000000000),1,1), CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND,  ROUND(RAND() * 127, 0), CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND FROM seq_1_to_2000000;
INSERT INTO fait.fait_mission_date  SELECT  substring(MD5(RAND()*1000000000),1,15), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,3),  ROUND(RAND() * 32000, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0),  ROUND(RAND() * 127, 0), substring(MD5(RAND()*1000000000),1,10), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 99, 2), ROUND(RAND() * 1, 0),  ROUND(RAND() * 32000, 0), substring(MD5(RAND()*1000000000),1,50),  ROUND(RAND() * 32000, 0), substring(MD5(RAND()*1000000000),1,10), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 10000000, 5), substring(MD5(RAND()*1000000000),1,1), CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, substring(MD5(RAND()),1,2), CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND,  ROUND(RAND() * 127, 0), CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND FROM seq_1_to_16000000;
INSERT INTO fait.fait_orders  SELECT  ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,3), substring(MD5(RAND()*1000000000),1,10), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,30), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,256), substring(MD5(RAND()*1000000000),1,256), substring(MD5(RAND()*1000000000),1,1024), substring(MD5(RAND()*1000000000),1,50), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,6), ROUND(RAND() * 1, 0), substring(MD5(RAND()),1,6), substring(MD5(RAND()),1,6), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,26), substring(MD5(RAND()*1000000000),1,300), substring(MD5(RAND()*1000000000),1,40), substring(MD5(RAND()*1000000000),1,10), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,50), substring(MD5(RAND()*1000000000),1,150), substring(MD5(RAND()*1000000000),1,2000), substring(MD5(RAND()*1000000000),1,10), substring(MD5(RAND()*1000000000),1,256), substring(MD5(RAND()*1000000000),1,1000), substring(MD5(RAND()*1000000000),1,1000), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,50), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 10000000, 5), CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND,  ROUND(RAND() * 127, 0) FROM seq_1_to_2000000;
INSERT INTO fait.fait_orders_assignments  SELECT  ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,30), substring(MD5(RAND()*1000000000),1,40), CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND,  ROUND(RAND() * 127, 0) FROM seq_1_to_2000000;

INSERT INTO fait.fait_orders_ressource  SELECT  ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,150), substring(MD5(RAND()*1000000000),1,150), substring(MD5(RAND()*1000000000),1,10), substring(MD5(RAND()*1000000000),1,50), substring(MD5(RAND()*1000000000),1,150), substring(MD5(RAND()*1000000000),1,10), substring(MD5(RAND()),1,10), ROUND(RAND() * 1, 0), CURRENT_DATE - INTERVAL FLOOR(RAND() * 365) DAY, CURRENT_DATE - INTERVAL FLOOR(RAND() * 365) DAY, substring(MD5(RAND()*1000000000),1,3), CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND,  ROUND(RAND() * 127, 0) FROM seq_1_to_2000000;
INSERT INTO fait.fait_ra  SELECT  ROUND(RAND() * 1, 0),  ROUND(RAND() * 10000, 0), substring(MD5(RAND()*1000000000),1,3), substring(MD5(RAND()*1000000000),1,10), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,100), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 10000000, 5), substring(MD5(RAND()*1000000000),1,50), ROUND(RAND() * 10000000, 5), substring(MD5(RAND()*1000000000),1,510), substring(MD5(RAND()*1000000000),1,40), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,256), substring(MD5(RAND()*1000000000),1,50), substring(MD5(RAND()*1000000000),1,309), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,10), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,100), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,7), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,10), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 10000000, 5), substring(MD5(RAND()*1000000000),1,40), substring(MD5(RAND()*1000000000),1,255), substring(MD5(RAND()*1000000000),1,40), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 999, 2), substring(MD5(RAND()*1000000000),1,15), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,50), substring(MD5(RAND()*1000000000),1,150), substring(MD5(RAND()*1000000000),1,2000), substring(MD5(RAND()*1000000000),1,10), substring(MD5(RAND()*1000000000),1,100), substring(MD5(RAND()*1000000000),1,50), substring(MD5(RAND()*1000000000),1,50),  ROUND(RAND() * 32000, 0), ROUND(RAND() * 1, 0), substring(MD5(RAND()),1,6), substring(MD5(RAND()),1,6), CURRENT_DATE - INTERVAL FLOOR(RAND() * 365) DAY, CURRENT_DATE - INTERVAL FLOOR(RAND() * 365) DAY, ROUND(RAND() * 10000000, 5), substring(MD5(RAND()*1000000000),1,3), substring(MD5(RAND()*1000000000),1,20), ROUND(RAND() * 10000000, 5), CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND,  ROUND(RAND() * 127, 0) FROM seq_1_to_2000000;
INSERT INTO fait.fait_rav  SELECT  ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,3), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,50), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,510), substring(MD5(RAND()*1000000000),1,40), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,256), substring(MD5(RAND()*1000000000),1,50), substring(MD5(RAND()*1000000000),1,309), substring(MD5(RAND()*1000000000),1,100), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,10), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,7), ROUND(RAND() * 1, 0), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 10000000, 5), substring(MD5(RAND()*1000000000),1,2), substring(MD5(RAND()*1000000000),1,40), substring(MD5(RAND()*1000000000),1,255), substring(MD5(RAND()*1000000000),1,40), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 99, 2), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), substring(MD5(RAND()),1,6), substring(MD5(RAND()),1,6), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,15), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,50), substring(MD5(RAND()*1000000000),1,150), substring(MD5(RAND()*1000000000),1,2000), substring(MD5(RAND()*1000000000),1,10), substring(MD5(RAND()*1000000000),1,100), substring(MD5(RAND()*1000000000),1,50), substring(MD5(RAND()*1000000000),1,50),  ROUND(RAND() * 32000, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 10000000, 5), CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, substring(MD5(RAND()),1,2), CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND,  ROUND(RAND() * 127, 0), CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND FROM seq_1_to_2000000;
INSERT INTO fait.fait_rcv  SELECT  ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,3), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,50), substring(MD5(RAND()*1000000000),1,5), substring(MD5(RAND()*1000000000),1,510), substring(MD5(RAND()*1000000000),1,40), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,256), substring(MD5(RAND()*1000000000),1,50), substring(MD5(RAND()*1000000000),1,309), substring(MD5(RAND()*1000000000),1,100), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,10), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,7), ROUND(RAND() * 1, 0), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 10000000, 5), substring(MD5(RAND()*1000000000),1,2), substring(MD5(RAND()*1000000000),1,40), substring(MD5(RAND()*1000000000),1,255), substring(MD5(RAND()*1000000000),1,40), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 99, 2), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,50), substring(MD5(RAND()*1000000000),1,150), substring(MD5(RAND()*1000000000),1,2000), substring(MD5(RAND()*1000000000),1,10), substring(MD5(RAND()*1000000000),1,100), substring(MD5(RAND()*1000000000),1,50), substring(MD5(RAND()*1000000000),1,50),  ROUND(RAND() * 32000, 0), ROUND(RAND() * 10000000, 5), ROUND(RAND() * 10000000, 5), substring(MD5(RAND()*1000000000),1,1000), substring(MD5(RAND()*1000000000),1,200), substring(MD5(RAND()*1000000000),1,200), CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND,  ROUND(RAND() * 127, 0), CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND FROM seq_1_to_2000000;
INSERT INTO fait.fait_sms  SELECT   ROUND(RAND() * 10000, 0), substring(MD5(RAND()),1,3), ROUND(RAND() * 1, 0), CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, substring(MD5(RAND()*1000000000),1,5), substring(MD5(RAND()*1000000000),1,50), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,40), substring(MD5(RAND()*1000000000),1,25), substring(MD5(RAND()*1000000000),1,30), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,400), ROUND(RAND() * 1, 0), substring(MD5(RAND()),1,6), substring(MD5(RAND()),1,6), CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND FROM seq_1_to_2000000;
INSERT INTO fait.fait_signature  SELECT  ROUND(RAND() * 1, 0), CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,5), substring(MD5(RAND()*1000000000),1,10), substring(MD5(RAND()*1000000000),1,100), substring(MD5(RAND()*1000000000),1,10), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,10), CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND FROM seq_1_to_2000000;
INSERT INTO fait.fait_stat_mission  SELECT  ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), substring(MD5(RAND()),1,3), CURRENT_DATE - INTERVAL FLOOR(RAND() * 365) DAY, CURRENT_DATE - INTERVAL FLOOR(RAND() * 365) DAY, substring(MD5(RAND()),1,4), substring(MD5(RAND()*1000000000),1,3), substring(MD5(RAND()*1000000000),1,3), substring(MD5(RAND()*1000000000),1,8), substring(MD5(RAND()*1000000000),1,2), substring(MD5(RAND()),1,2), substring(MD5(RAND()*1000000000),1,5), substring(MD5(RAND()*1000000000),1,2), ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,3), substring(MD5(RAND()*1000000000),1,3), substring(MD5(RAND()*1000000000),1,10), CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND FROM seq_1_to_2000000;
INSERT INTO fait.fait_stat_mission_date  SELECT  ROUND(RAND() * 1, 0), CURRENT_DATE - INTERVAL FLOOR(RAND() * 365) DAY, ROUND(RAND() * 10000000, 5),  ROUND(RAND() * 32000, 0), CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND FROM seq_1_to_2000000;
INSERT INTO fait.fait_stat_pixid  SELECT   ROUND(RAND() * 10000, 0), CURRENT_DATE - INTERVAL FLOOR(RAND() * 365) DAY, substring(MD5(RAND()),1,4), substring(MD5(RAND()*1000000000),1,2), substring(MD5(RAND()),1,2), substring(MD5(RAND()*1000000000),1,3), substring(MD5(RAND()*1000000000),1,3), CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND FROM seq_1_to_2000000;
INSERT INTO fait.fait_suivi_build  SELECT  ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,100), CURRENT_DATE - INTERVAL FLOOR(RAND() * 365) DAY, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, substring(MD5(RAND()),1,2), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND FROM seq_1_to_2000000;
INSERT INTO fait.fait_suivi_table  SELECT  substring(MD5(RAND()*1000000000),1,30), substring(MD5(RAND()*1000000000),1,30),  ROUND(RAND() * 10000, 0),  ROUND(RAND() * 10000, 0), CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND FROM seq_1_to_2000000;
INSERT INTO fait.fait_suivi_traitement  SELECT  ROUND(RAND() * 1, 0), substring(MD5(RAND()*1000000000),1,30), CURRENT_DATE - INTERVAL FLOOR(RAND() * 365) DAY, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND, substring(MD5(RAND()),1,2), ROUND(RAND() * 1, 0), ROUND(RAND() * 1, 0), CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 365 * 24 * 60 *60) SECOND FROM seq_1_to_2000000;

