49N32zvf

1CREATE TABLE IF NOT EXISTS `lib_transactions` (
2  `transaction_id` int(11) NOT NULL,
3  `person` varchar(60) NOT NULL,
4  `isbn` varchar(20) NOT NULL,
5  `action` varchar(20) NOT NULL,
6  `timestamp` int(11) NOT NULL
7) ENGINE=InnoDB AUTO_INCREMENT=205 DEFAULT CHARSET=utf8;
8
9--
10-- Dumping data for table `lib_transactions`
11--
12
13INSERT INTO `lib_transactions` (`transaction_id`, `person`, `isbn`, `action`, `timestamp`) VALUES
14(186, '1', '99-9263-544-4', 'check-out', 1483228800),
15(187, '2', '99-9263-544-5', 'check-out', 1483229100),
16(188, '1', '99-9263-544-4', 'check-in', 1483315200),
17(189, '2', '99-9263-544-5', 'check-in', 1483661100),
18(190, '3', '99-9263-544-4', 'check-out', 1483747500),
19(191, '2', '99-9263-544-6', 'check-out', 1483833900),
20(192, '2', '99-9263-544-6', 'check-in', 1483920300),
21(193, '3', '99-9263-544-7', 'check-out', 1484006700),
22(194, '3', '99-9263-544-8', 'check-out', 1484100300),
23(195, '3', '99-9263-544-7', 'check-in', 1484453100),
24(196, '3', '99-9263-544-8', 'check-in', 1484460300),
25(197, '4', '99-9263-544-7', 'check-out', 1484553900),
26(198, '4', '99-9263-544-8', 'check-out', 1484611500),
27(199, '4', '99-9263-544-7', 'check-in', 1484705100),
28(200, '4', '99-9263-543-8', 'check-in', 1484798700),
29(201, '5', '99-9263-543-1', 'check-out', 1484798700),
30(202, '5', '99-9263-544-2', 'check-out', 1484798700),
31(203, '5', '99-9263-542-3', 'check-out', 1484798700),
32(204, '5', '99-9263-541-4', 'check-out', 1484798700);