2019-01-10T19:34:03.851138Z	   15 Connect	root@localhost on wlb using TCP/IP
2019-01-10T19:34:03.856237Z	   15 Query	DROP TABLE if exists `wlb`.`library`, `wlb`.`tag_instance`, `wlb`.`tags`, `wlb`.`users`, `wlb`.`vote_library`, `wlb`.`vote_table`
2019-01-10T19:34:04.073912Z	   15 Query	CREATE  TABLE `wlb`.`Users` ( `idusers` int(11) NOT NULL, `username` varchar(45) NOT NULL, `password` char(64) NOT NULL, `email` varchar(45) DEFAULT NULL, PRIMARY KEY (`idusers`), UNIQUE KEY `username_UNIQUE` (`username`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2019-01-10T19:34:04.142907Z	   15 Query	CREATE  TABLE `wlb`.`library` (`idlibrary` INT NOT NULL,`library_name` VARCHAR(45) NOT NULL,`status` ENUM('Private', 'Public') NOT NULL,`id_user` INT NULL,`total_votes` INT NULL,PRIMARY KEY (`idlibrary`),INDEX `iduser_fk_idx` (`id_user` ASC) VISIBLE,  CONSTRAINT `iduser_fk`FOREIGN KEY (`id_user`)  REFERENCES `wlb`.`users` (`idusers`) ON DELETE SET NULL ON UPDATE CASCADE)
2019-01-10T19:34:04.203754Z	   15 Query	CREATE TABLE `wlb`.`tags` (`idtags` INT NOT NULL,`tag_name` VARCHAR(45) NULL,`usage_count` INT NULL,`idusers` INT NULL,PRIMARY KEY (`idtags`),UNIQUE INDEX `tag_name_UNIQUE` (`tag_name` ASC) VISIBLE,INDEX `iduser_fk_idx` (`idusers` ASC) VISIBLE,CONSTRAINT `iduser_fk2`FOREIGN KEY (`idusers`)REFERENCES `wlb`.`users` (`idusers`)ON DELETE SET NULL ON UPDATE CASCADE)
2019-01-10T19:34:04.280807Z	   15 Query	CREATE TABLE `wlb`.`tag_instance` (`idtag_instance` INT NOT NULL,`idtag` INT NULL,`idlibrary` INT NULL,`vote_count` INT NULL,PRIMARY KEY (`idtag_instance`),INDEX `idlibrary_fk_idx` (`idlibrary` ASC) VISIBLE,INDEX `idtag_fk_idx` (`idtag` ASC) VISIBLE,CONSTRAINT `idlibrary_fk`FOREIGN KEY (`idlibrary`)REFERENCES `wlb`.`library` (`idlibrary`) ON DELETE SET NULL ON UPDATE CASCADE,CONSTRAINT `idtag_fk` FOREIGN KEY (`idtag`)REFERENCES `wlb`.`tags` (`idtags`)ON DELETE SET NULL ON UPDATE CASCADE)
2019-01-10T19:34:04.350198Z	   15 Query	CREATE TABLE `wlb`.`vote_table` (  `idvote_table` INT NOT NULL,`iduser` INT NULL,`idtag_instance` INT NULL,`vote_kind` ENUM('Upvote', 'Downvote') NOT NULL,PRIMARY KEY (`idvote_table`),INDEX `idusers_fk_idx` (`iduser` ASC) VISIBLE,INDEX `idtag_instance_fk_idx` (`idtag_instance` ASC) VISIBLE,CONSTRAINT `id_users_fk`FOREIGN KEY (`iduser`)REFERENCES `wlb`.`users` (`idusers`)ON DELETE SET NULL ON UPDATE CASCADE,CONSTRAINT `idtag_instance_fk` FOREIGN KEY (`idtag_instance`) REFERENCES `wlb`.`tag_instance` (`idtag_instance`) ON DELETE SET NULL ON UPDATE CASCADE)
2019-01-10T19:34:04.433018Z	   15 Query	CREATE TABLE `wlb`.`vote_library` (`idvote_library` INT NOT NULL,`iduser` INT NULL,`idlibrary` INT NULL,`vote_kind` ENUM('Upvote', 'Downvote') NULL,PRIMARY KEY (`idvote_library`),INDEX `userid_fk_idx` (`iduser` ASC) VISIBLE,INDEX `library_fk_idx` (`idlibrary` ASC) VISIBLE,CONSTRAINT `userid_fk`FOREIGN KEY (`iduser`)REFERENCES `wlb`.`users` (`idusers`)ON DELETE SET NULL ON UPDATE CASCADE,CONSTRAINT `library_fk`FOREIGN KEY (`idlibrary`)REFERENCES `wlb`.`library` (`idlibrary`) ON DELETE SET NULL ON UPDATE CASCADE)
2019-01-10T19:34:04.511848Z	   15 Query	INSERT INTO `wlb`.users VALUES (1000, 'Khalil Nielsen', 'ssSeZmwK4vZMcYl3Y3oVV1Q58vSh6bYUTzklkQILlrjGYMTJQobU4DwJm3Nc018n', 'ajohnson@aol.com'), (1001, 'Lea Jackson', 'V4AH3strm5sW4T8wLrzvmSd1Z8eKLVCbc8CmY55Pq6bLqKctUReDvlV0EV1bp9TV', 'curly@att.net'), (1002, 'Horace Valencia', 'qLDvpusG1jWIU9SXFtZ3ZX5X8yKRg9gQXoggGQ1jp4KLwJK5YjbQfTeKhx4XPm20', 'andrewik@icloud.com'), (1003, 'Gethin Roberson', 'zXFsRvtwzxjIW4e8l6QbcHm4jiP3vCVKA92gga7Lrme3P1UlCQBpDi3WnVFScUKb', 'gtaylor@outlook.com'), (1004, 'Marion Patton', 'cMS88TtcBP4qtipJhMR31E3h0SAPRoQB651bRSfw0vawJdTdQxLhKHEGXHfvWfaO', 'denton@aol.com'), (1005, 'Esmai Haas', 'sCHpeedfO3P3lSnUogQRVyB5drlrJ9mE2LirKhfdmIMNN7mOF50qts7ESMMGrgp7', 'firstpr@aol.com'), (1006, 'Benny Andrade', 'RMBKzYrlE7HxcZyA2goa1i2HLXJtrVFAjBTdgh0k5PnpjF7OkG1JKORZDHo0e977', 'maikelnai@me.com'), (1007, 'Wilbur Mccormack', '8Ynelju2zb0Amzz41Pdn4rcKixaeHf6Rv8dEKfWs8g6pEXNK5ZOq0LuuYwU89N3F', 'staikos@comcast.net'), (1008, 'Jonas Horne', 'dtcLy2jSNPhBdTUuMPF6VU2zVCu7pTiLGKFf99FQklaiZMOz8KqAdn41xdVN7FRZ', 'notaprguy@yahoo.ca'), (1009, 'Mila Allman', '3ZAwTUSoVF0jma3fiK7ka1wGz22QWHkgAKxtoHuOpbPyXSnzk1aABdWjivCkQw9q', 'mjewell@outlook.com'), (1010, 'Elouise Green', '6E3veUWRRZKmsix9DhCQtfMhY15ca5YD2F3ATJhy3npcAmoIcHv9v23ECLJNn0Or', 'sblack@comcast.net'), (1011, 'Rayhan Garcia', 'thSXATqHNQWpFvK7C7dbbtDqr02ARd7s8p8vYtF3AA3km1OBUMmcSEnSlg4Aqnuf', 'niknejad@aol.com'), (1012, 'Peggy Lucas', 'LGM2z3P58ttNdI56BvStsEsY4XGNwF5FSh4bl7oFsuh2uOva2fOfn5rAb8eRiP0y', 'brbarret@verizon.net'), (1013, 'Catriona Hough', '4H32uanOL5L7fg3E8CEKpsQLRG6Z8sJq2z7Zrvzwoaih5bdoZ5wSFGAquFCrNRuT', 'kjetilk@yahoo.ca'), (1014, 'Rhianne Compton', 'VJWfQF6icze6o21Y78SOyMmyvwMc9aJdNwZkjxTfJZThScqSeK9WkzVNmihLLPhh', 'mdielmann@me.com'), (1015, 'Winston Finnegan', 'uuNbIWCvUdoMFHXTyA6nqdueKIvJSxZumPz8YKZalhl5bYThdVQCHCXYMAwQN7F3', 'bahwi@optonline.net'), (1016, 'Sultan Price', 'eMivpGygrkg9CGoHipfGMfRRO5D1EGNYIuEZ5OY8JxGLpS7iegcq0Gfow0nxSrpB', 'srour@yahoo.ca'), (1017, 'Rachael Booth', 'nDhuqs4I02QLiUTqnx0pUHCM1NP30OrmFV3ecrMhUNs8tGpp6SUatGY6WmyL8CmG', 'bowmanbs@yahoo.com'), (1018, 'Elaine Frederick', 'JntVD495zWHOyNdctGGlKVsuTDlR9HXwhjTUtxD5Tb2TBNGLics3TNjdqbWiH7or', 'report@aol.com'), (1019, 'Ikrah Griffith', 'eMjSujhSqGOTAtQcSU6zW3MIRC2XoHuKE33dEO63XJIukVvYCRQsEvrdP6yc6UeL', 'yangyan@aol.com'), (1020, 'Nadine Hutchinson', 'CivSvyvpL1cIFf8Vg6ezWkgN8EeMSJ6QqJRwhevGFJuct2etTgT7RsVUBJQgpcTl', 'jguyer@mac.com'), (1021, 'Lacey-Mai Bean', 'mBigm0G4WXb2KZ6r7qd2Lkv04fx90XUaeNFV0tjxzIbLSArgiceiNvalpJUgDr7I', 'scottlee@att.net'), (1022, 'Ammara Roth', 'Ror6RmrEGXVM4hQ76xpZaxCbwhmo1L7FIzEIdEYIjmTaIhuDOApmrSRazl5hm9ag', 'jespley@sbcglobal.net'), (1023, 'Bryson Gardiner', 'vdGXSzFHpU9vS2ke1IXj0ZbWUNj9riWha46gQxxyUCvnyMQm6O8tJMBoRQuxFUr0', 'afeldspar@aol.com'), (1024, 'Macey Cross', 'K5maeNVRjvkH9zsEGT1JpC3dK6QqqjuY5HcWMP6esrw7SFqV2vaHtBZEimsfOnvE', 'caidaperl@aol.com'), (1025, 'Rodney Pollard', 'KoqcHCXJG6BChhmtK1XYdtpxQfHoMS3Do0iqeNKCvGMYxFP6uwMMea3JWm4ojdEU', 'tangsh@optonline.net'), (1026, 'Lacey Underwood', 'MitaqGCw9AD0tyZ5A1SqhObrXqvCu6V3hDsGs7mA99F8CegztB8hXVf0hf27aMc4', 'camenisch@att.net'), (1027, 'Jac Brook', 'AxcqZGcSk3ZQEhrwJ4JhGPKfGncAKmqFEO52P2wbPqbryrd7Q7cQqFZKeNIu3qKW', 'bdthomas@me.com'), (1028, 'Maia Page', 'imz0jYPmHx04extxfvoyPjhZGIfmS3w9m0UkFlEh1ckEbYL7sGBjmsIRdlzeGeSE', 'rfisher@mac.com'), (1029, 'Jun Burrows', 'e4DrtXduA97sBgbe9qYLH1s3eElL9oycCNYlGy0KkCHpYQ3Qe3uvmYzJniBxz7UZ', 'treeves@outlook.com'), (1030, 'Toyah Knox', 'MkeUYltAGIhlv7GKpBmepi8g970v1HglUeb8WDUO6vxbFOIeeJY4G7AY7uTzdvLE', 'demmel@verizon.net'), (1031, 'Katelin Watson', 'qfSodbAG37zm5JhmiAbWP3cwDP9t8Lio8poHk0dpw6Xz5YoIXb0idrqXzjhMwUD9', 'fallorn@verizon.net'), (1032, 'Dewey Broughton', 'uI8a0f3a9Ow2aMxlov4F516sBDJr6I1n93JNEfQb4lpefA1nrXUfTyPPQnUqPZIj', 'zwood@live.com'), (1033, 'Roberto Soto', '3PcvuqUSVzM0Szlt6lQPhPeDcXIcLYbNPLqwHbmly8ypGvUVAe1kQ4XOPIKlBFUy', 'ateniese@verizon.net'), (1034, 'Gail Manning', 'LRTnOs1F5qSEjgpKI3wHgrYatsSkxcrl6HW0Tiyb8GrRGYYjtn17OfGkNjzEBDeP', 'crandall@gmail.co'), (1035, 'Keon Rosa', 'MSemD6Kwce4boKcOJLOKEoAn4RG37yaOpvxOUZbHxIwacI47IL60elxiPkCz2hYk', 'ribet@aol.com'), (1036, 'Rosanna Kaur', 'HYGvy9noAs3CbxjjnEJsbZbdAUOkD90o7c4FdQHC0Se9XcmWuiYj1iF5W2QLMDVT', 'jkegl@comcast.net'), (1037, 'Shayna Almond', 'dWuvLqU5L1RSFELmmzmUwax4WSwLv1ZLEzVPnEMVyLfxEzzwr6md97OF1mvy9CQN', 'jigsaw@comcast.net'), (1038, 'Farrah Whitmore', 'IJTSuljb3VyaNGfiziUi8aU3J2Xu4o5y2NK3d57eSw2Ee3Yv2C32QenkCb58NYMw', 'dprice@sbcglobal.net'), (1039, 'Elizabeth Ruiz', 'eYbqXx6UBSsQsLbZtSkZd0HKml5iiRT7VxDDNNtyHzvPesP89du7YIR1ZNWopMk6', 'msloan@msn.com'), (1040, 'Safiyah Aguilar', 'kokKVzAlhboQfnyUXA3VzGgsx8rGbSV1aNEFdSNhOEkjsuAoRalaRLRKS2kAQ0G9', 'pizza@live.com'), (1041, 'Renesmae Foster', '2OwrEUhiqEmv8IoigtQq0yJWxaeIEfkpImJpTu1dW8StZ7y1i5p8Edz3lPdoXglj', 'bonmots@live.com'), (1042, 'Hanan Paul', 'l0bmFbHuEgPsda8GB6V2yA5VJr3YWJS8sQE3NtuMyy7DIFeszxJIekIn8ey2MjRU', 'cremonini@comcast.net'), (1043, 'Wilf Goddard', 'SHCHknaIf2KptQcA1wnZcjagfATWgxCBg1vNNnT8xpRDxp8fV8tXRWLMJglSZGb3', 'nanop@icloud.com'), (1044, 'Tonisha Rivas', '0PpvULv6W1i5Wz71dXOQqKi5tgixDIVw6iDLT9gc03TmnzZ7x8IBtIXq6uSdbcYW', 'pkplex@gmail.com'), (1045, 'Hayden Mcfarland', '3DiXIHMPtDNXLbZZeHvGnLpplBG3TVZoh3uCfHKNVbGYhHMFG0cJmXGk7tQX6H4k', 'scottzed@aol.com'), (1046, 'Connar Carson', 'Pb6BOAT3GxoEpavII9k8R2upusYTXQiTJfoovOeMRLvwUwEfsf2ZcPvNhEJGGMMw', 'syrinx@verizon.net'), (1047, 'Kirsten Ball', '8SQq3htQr4zkR10FqtSvsGUWiTEqYDhL5SXYz4IYrQ7MKUmLSEhEkdOidP46Vhei', 'smcnabb@comcast.net'), (1048, 'Harry Mcgowan', '8agbp8jYJPwIgUpFfmUHHZc0V8CK4vBK7DpICMW7qL5rD7dxbMbrlL5Nzp4mINYB', 'twoflower@live.com'), (1049, 'Kira Bartlett', 'LZQTTAqaidjLGEJq49GkCKXPjIVn3NPVh18SRIaoEmaH7cdySKX82jS1qcqeY70r', 'msloan@gmail.com')
2019-01-10T19:34:04.526162Z	   15 Query	INSERT INTO `wlb`.Library VALUES (1, 'Requiem Athenaeum', 1, 1011, 3), (2, 'Infinity Bibliotheca', 1, 1021, 41), (3, 'Global Bibliotheca', 2, 1027, 95), (4, 'Idle Hour Library', 1, 1006, 80), (5, 'Spectrum Library', 2, 1040, 4), (6, 'National Public Library', 1, 1043, 8), (7, 'Freedom Library', 2, 1033, 99), (8, 'Millennium Library', 2, 1032, 98), (9, 'Royal Library', 1, 1008, 45), (10, 'Tempest Library', 1, 1004, 27), (11, 'Marvel Library', 2, 1020, 80), (12, 'Art Archive Library', 1, 1019, 29), (13, 'Crescent Moon Library', 2, 1040, 23), (14, 'Reverie Library', 2, 1004, 69), (15, 'Stellar Library', 2, 1014, 21), (16, 'Jubilee Library', 2, 1025, 50), (17, 'Trove Library', 1, 1006, 27), (18, 'Stellar Library', 2, 1028, 16), (19, 'Aeos Library', 2, 1032, 30), (20, 'Charity Library', 1, 1013, 82), (21, 'Pom opm', 1, 1048, 93)
2019-01-10T19:34:04.535750Z	   15 Query	INSERT INTO `wlb`.tags VALUES (50, 'cow', 9119, 1001), (51, 'tested', 7054, 1013), (52, 'monkey', 2592, 1050), (53, 'nutty', 1077, 1004), (54, 'harm', 9626, 1017), (55, 'tender', 3605, 1009), (56, 'stiff', 3943, 1048), (57, 'brick', 9657, 1020), (58, 'channel', 5418, 1048), (59, 'twist', 1415, 1012), (60, 'excuse', 6922, 1015), (61, 'plastic', 4028, 1031), (62, 'confess', 7656, 1037), (63, 'troubled', 1367, 1012), (64, 'frame', 4455, 1040), (65, 'malicious', 3808, 1013), (66, 'legal', 695, 1032), (67, 'somber', 8470, 1025), (68, 'strange', 1961, 1010), (69, 'wrist', 8664, 1032), (70, 'enthusiastic', 5708, 1049), (71, 'defiant', 7207, 1039), (72, 'flame', 7618, 1001), (73, 'necessary', 5019, 1024), (74, 'boundary', 6857, 1018), (75, 'curtain', 3900, 1013), (76, 'neat', 4665, 1011), (77, 'planes', 6988, 1046), (78, 'scorch', 6090, 1015), (79, 'tire', 9950, 1047), (80, 'squeeze', 302, 1031), (81, 'flower', 6238, 1047), (82, 'boiling', 4297, 1008), (83, 'burst', 561, 1050), (84, 'bewildered', 5392, 1039), (85, 'force', 3937, 1049), (86, 'preserve', 5645, 1013), (87, 'overwrought', 2325, 1022)
2019-01-10T19:34:04.544588Z	   15 Query	INSERT INTO `wlb`.Tag_instance VALUES (1, 83, 9, 7002), (2, 75, 6, 9937), (3, 81, 9, 2411), (4, 58, 5, 9714), (5, 57, 6, 3223), (6, 55, 16, 8392), (7, 79, 21, 5305), (8, 63, 17, 3543), (9, 69, 19, 2444), (10, 74, 7, 5888), (11, 68, 16, 595), (12, 50, 21, 9819), (13, 61, 7, 6990), (14, 81, 12, 5080), (15, 65, 6, 9106), (16, 85, 16, 9856), (17, 51, 12, 7618), (18, 58, 6, 8799), (19, 87, 7, 724), (20, 56, 18, 8249), (21, 72, 6, 6574), (22, 78, 17, 6465), (23, 86, 9, 9271), (24, 87, 5, 6765), (25, 80, 5, 8707), (26, 82, 12, 5436), (27, 78, 17, 2086), (28, 59, 4, 532), (29, 70, 8, 9698), (30, 61, 7, 3073), (31, 53, 10, 5743), (32, 64, 20, 683), (33, 55, 6, 8463), (34, 71, 10, 105), (35, 59, 6, 5297), (36, 69, 13, 8281), (37, 59, 20, 9967), (38, 82, 17, 2525), (39, 77, 7, 5237), (40, 77, 12, 2836), (41, 58, 4, 3012), (42, 67, 8, 1265), (43, 56, 5, 9529), (44, 72, 2, 48), (45, 52, 10, 9533), (46, 66, 19, 9410), (47, 76, 2, 288), (48, 60, 2, 9340), (49, 84, 12, 9275), (50, 68, 19, 927)