0006_insert_lend.sql

INSERT INTO lend(device_id, user_id, lend_datetime, return_due_date, return_datetime, return_flag)
VALUES
    (1, 1, '2019-01-06 11:08:43', '2019-01-06', '2019-01-06 18:05:12', 1)
    ,(2, 1, '2019-01-08 12:05:25', '2019-01-13', '2019-01-09 17:58:32', 1)
    ,(1, 1, '2019-01-08 14:25:01', '2019-01-09', '2019-01-09 15:35:44', 1)
    ,(2, 2, '2019-01-17 14:01:01', '2019-01-18', '2019-01-18 16:31:06', 1)
    ,(1, 2, '2019-01-19 16:41:38', '2019-01-21', '2019-01-23 19:01:08', 1)
    ,(2, 4, '2019-01-30 09:55:01', '2019-01-31', '2019-02-02 09:17:35', 1)
;


INSERT INTO lend(device_id, user_id, lend_datetime, return_due_date)
VALUES
    (1, 3, '2019-01-30 15:05:02', '2019-01-30')
    ,(3, 1, '2019-01-31 10:10:18', '2019-02-01')
    ,(2, 3, '2019-01-31 12:01:49', '2019-01-31')
;

UPDATE device_lend_status
SET
    lended = 1
WHERE
    device_id IN (1, 3, 2)
;