USE storm_db;

SET @surl1 := "srm://centos6-devel.cnaf.infn.it:8444/test.vo/test00001.dat";
SET @surl2 := "srm://centos6-devel.cnaf.infn.it:8444/test.vo/test00002.dat";
SET @r_token := "fea89716-ae54-11e7-bbec-525400a1c1b9";
SET @timestamp_rq := DATE_SUB(CURRENT_TIMESTAMP(), INTERVAL 2592000 SECOND);

INSERT INTO request_queue (pinLifetime, r_token, status, timeStamp, config_RequestTypeID)
VALUES (10000, @r_token, 18, @timestamp_rq, 'PTP');

SELECT @id_rq := LAST_INSERT_ID();

INSERT INTO request_Put (targetSURL, request_queueID)
VALUES (@surl1, @id_rq);

SELECT @id_rp := LAST_INSERT_ID();

INSERT INTO status_Put (request_PutID, statusCode)
VALUES (@id_rp, 18);

INSERT INTO request_Put (targetSURL, request_queueID)
VALUES (@surl2, @id_rq);

SELECT @id_rp := LAST_INSERT_ID();

INSERT INTO status_Put (request_PutID, statusCode)
VALUES (@id_rp, 18);