| Server IP : 134.29.175.74 / Your IP : 216.73.216.160 Web Server : nginx/1.10.2 System : Windows NT CST-WEBSERVER 10.0 build 19045 (Windows 10) i586 User : Administrator ( 0) PHP Version : 7.1.0 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/Users/Administrator/AppData/Roaming/MySQL/Workbench/sql_history/ |
Upload File : |
<?xml version="1.0" encoding="UTF-8" ?> <ENTRY timestamp='00:04:31'>SELECT * FROM jimmarti_cst.user</ENTRY> <ENTRY timestamp='04:07:01'>SELECT *
 FROM `user`
 WHERE userUsername = 'wp4452ys'
 AND userPasswordMD5 = 'TWlubjAxMjA='</ENTRY> <ENTRY timestamp='04:07:13'>~</ENTRY> <ENTRY timestamp='06:24:27'>SELECT * FROM jimmarti_cst.classstudent</ENTRY> <ENTRY timestamp='06:27:52'>ALTER TABLE `jimmarti_cst`.`classstudent` 
CHANGE COLUMN `userStudentId` `userStudentId` CHAR(8) NOT NULL DEFAULT '0' ,
ADD COLUMN `userStarID` CHAR(8) NULL AFTER `classstudentCredits`</ENTRY> <ENTRY timestamp='06:30:35'>SELECT * FROM jimmarti_cst.userdata</ENTRY> <ENTRY timestamp='06:30:52'>SELECT * FROM jimmarti_cst.user</ENTRY> <ENTRY timestamp='06:31:30'>SELECT * FROM jimmarti_cst.classstudent</ENTRY> <ENTRY timestamp='06:31:41'>SELECT * FROM jimmarti_cst.userdata</ENTRY> <ENTRY timestamp='18:31:12'>SELECT *
 FROM `user`
 WHERE userLastName'Mulder'</ENTRY> <ENTRY timestamp='18:31:59'>SELECT *
 FROM `user`
 WHERE userLastName'Meuleners'</ENTRY> <ENTRY timestamp='18:32:10'>SELECT *
 FROM `user`
 WHERE userLastName = 'Meuleners'</ENTRY> <ENTRY timestamp='18:33:19'>SELECT *
 FROM `user`
 WHERE userLastName = 'Beckmann'</ENTRY> <ENTRY timestamp='23:06:06'>SELECT *
 FROM `user`
 WHERE userLastName = 'Martinson'</ENTRY> <ENTRY timestamp='23:08:00'>SELECT FROM_Base64(userPasswordMD5) AS PW , *
 FROM `user`
 WHERE userLastName = 'Martinson'</ENTRY> <ENTRY timestamp='23:11:15'>SELECT FROM_Base64(userPasswordMD5) AS thepw
 , *
 FROM `user`
 WHERE userLastName = 'Martinson'</ENTRY> <ENTRY timestamp='23:11:35'>SELECT FROM_BASE64(userPasswordMD5) AS thepw
 , *
 FROM `user`
 WHERE userLastName = 'Martinson'</ENTRY> <ENTRY timestamp='23:11:47'>SELECT TO_BASE64(userPasswordMD5) AS thepw
 , *
 FROM `user`
 WHERE userLastName = 'Martinson'</ENTRY> <ENTRY timestamp='23:12:00'>SELECT userPasswordMD5 AS thepw
 , *
 FROM `user`
 WHERE userLastName = 'Martinson'</ENTRY> <ENTRY timestamp='23:12:23'>SELECT userPasswordMD5 AS thepw
 , user.*
 FROM `user`
 WHERE userLastName = 'Martinson'</ENTRY> <ENTRY timestamp='23:12:44'>SELECT FROM_BASE64(userPasswordMD5) AS thepw
 , user.*
 FROM `user`
 WHERE userLastName = 'Martinson'</ENTRY> <ENTRY timestamp='23:13:08'>SELECT FROM_BASE64(TO_BASE64(userPasswordMD5)) AS thepw
 , user.*
 FROM `user`
 WHERE userLastName = 'Martinson'</ENTRY> <ENTRY timestamp='23:13:44'>SELECT CAST(FROM_BASE64(userPasswordMD5) as string) AS thepw
 , user.*
 FROM `user`
 WHERE userLastName = 'Martinson'</ENTRY> <ENTRY timestamp='23:13:59'>SELECT CAST(FROM_BASE64(userPasswordMD5) as char) AS thepw
 , user.*
 FROM `user`
 WHERE userLastName = 'Martinson'</ENTRY> <ENTRY timestamp='00:59:08'>~</ENTRY> <ENTRY timestamp='02:27:47'>~</ENTRY> <ENTRY timestamp='02:30:03'>UPDATE `jimmarti_cst`.`user` SET `userPasswordMD5`= NULL WHERE `userId`='1'</ENTRY> <ENTRY timestamp='02:30:10'>SELECT * FROM jimmarti_cst.user</ENTRY> <ENTRY timestamp='02:37:00'>~</ENTRY> <ENTRY timestamp='03:33:44'>delete
from `classstudent`
where classId IN (1219)</ENTRY> <ENTRY timestamp='03:38:50'>delete
from `classstudent`
where classId IN (1218, 1219, 1220, 1221, 1222, 1223, 1224)</ENTRY> <ENTRY timestamp='04:53:46'>SELECT * FROM jimmarti_cst.user</ENTRY> <ENTRY timestamp='04:57:43'>SELECT CAST(FROM_BASE64(userPasswordMD5) as char) AS password
 , user.*
 FROM `user`
 WHERE userLastName = 'Finberg'</ENTRY> <ENTRY timestamp='04:58:02'>delete
from `classstudent`
where classId IN (1218, 1219, 1220, 1221, 1222, 1223, 1224)</ENTRY> <ENTRY timestamp='05:02:48'>SELECT CAST(FROM_BASE64(userPasswordMD5) as char) AS password
 , user.*
 FROM `user`
 WHERE userLastName = 'Finberg'</ENTRY> <ENTRY timestamp='05:02:50'>~</ENTRY> <ENTRY timestamp='05:02:51'>~</ENTRY> <ENTRY timestamp='~'>~</ENTRY> <ENTRY timestamp='05:02:52'>~</ENTRY> <ENTRY timestamp='05:02:53'>~</ENTRY> <ENTRY timestamp='~'>~</ENTRY> <ENTRY timestamp='~'>~</ENTRY> <ENTRY timestamp='05:03:34'>delete
from `classstudent`
where classId IN (1218, 1219, 1220, 1221, 1222, 1223, 1224)</ENTRY> <ENTRY timestamp='05:06:56'>SELECT CAST(FROM_BASE64(userPasswordMD5) as char) AS password
 , user.*
 FROM `user`
 WHERE userLastName = 'Finberg'</ENTRY> <ENTRY timestamp='05:08:22'>delete
from `classstudent`
where classId IN (1218, 1219, 1220, 1221, 1222, 1223, 1224)</ENTRY> <ENTRY timestamp='06:15:04'>UPDATE studentprofile
SET studentprofileGraded = 0</ENTRY> <ENTRY timestamp='06:30:48'>UPDATE studentprofile
SET studentprofileGraded = 1</ENTRY> <ENTRY timestamp='~'>UPDATE studentprofile
SET studentprofileSubmitted = 0
 , studentprofileGraded = 0
WHERE lastModified > '2019-08-01'</ENTRY> <ENTRY timestamp='07:03:01'>UPDATE studentprofile
SET studentprofileSubmitted = 0
 , studentprofileGraded = 0
#WHERE lastModified > '2019-08-01'</ENTRY> <ENTRY timestamp='17:07:17'>SELECT CAST(FROM_BASE64(userPasswordMD5) as char) AS password
 , user.*
 FROM `user`
 WHERE userLastName = 'Marwueedant'</ENTRY> <ENTRY timestamp='17:07:30'>SELECT CAST(FROM_BASE64(userPasswordMD5) as char) AS password
 , user.*
 FROM `user`
 WHERE userLastName = 'Marw\queedant'</ENTRY> <ENTRY timestamp='17:07:39'>SELECT CAST(FROM_BASE64(userPasswordMD5) as char) AS password
 , user.*
 FROM `user`
 WHERE userLastName = 'Marqueedant'</ENTRY> <ENTRY timestamp='17:07:48'>SELECT CAST(FROM_BASE64(userPasswordMD5) as char) AS password
 , user.*
 FROM `user`
 WHERE userLastName = 'Marquedant'</ENTRY> <ENTRY timestamp='17:09:02'>SELECT CAST(FROM_BASE64(userPasswordMD5) as char) AS password
 , user.*
 FROM `user`
 WHERE userLastName = 'Krug'</ENTRY> <ENTRY timestamp='18:34:49'>SELECT CAST(FROM_BASE64(userPasswordMD5) as char) AS password
 , user.*
 FROM `user`
 WHERE userLastName = 'Stabenow'</ENTRY> <ENTRY timestamp='21:32:00'>SELECT CAST(FROM_BASE64(userPasswordMD5) as char) AS password
 , user.*
 FROM `user`
 WHERE userFirstName = 'Timothy'</ENTRY> <ENTRY timestamp='21:33:16'>SELECT * FROM jimmarti_cst.user</ENTRY> <ENTRY timestamp='21:35:11'>UPDATE `jimmarti_cst`.`user` SET `userLastName`='O\'Neil' WHERE `userId`='1426'</ENTRY> <ENTRY timestamp='21:35:16'>SELECT * FROM jimmarti_cst.user</ENTRY> <ENTRY timestamp='21:35:58'>SELECT userLastName FROM jimmarti_cst.user</ENTRY> <ENTRY timestamp='21:36:54'>SELECT userLastName, userFirstName FROM jimmarti_cst.user</ENTRY> <ENTRY timestamp='21:39:54'>SELECT userLastName, userFirstName FROM jimmarti_cst.user
where userLastName like 'O\'%'</ENTRY> <ENTRY timestamp='21:40:26'>SELECT userLastName, userFirstName FROM jimmarti_cst.user
where userLastName like 'O\'%'
or userLastName like 'Mc\'%'</ENTRY> <ENTRY timestamp='21:40:35'>SELECT userLastName, userFirstName FROM jimmarti_cst.user
where userLastName like 'O\'%'
or userLastName like 'Mc%'</ENTRY> <ENTRY timestamp='21:40:48'>SELECT userLastName, userFirstName FROM jimmarti_cst.user
where userLastName like 'O\'%'
or userLastName like 'Mc%'
or userLastName like 'Mac%'</ENTRY> <ENTRY timestamp='10:16:06'>SET @UN = `jt1515ku1';

UPDATE `user`
SET userPassword = NULL
 , userPasswordMD5 = NULL
WHERE userUserName = @UN
;</ENTRY> <ENTRY timestamp='10:17:09'>UPDATE `user`
SET userPassword = NULL
 , userPasswordMD5 = NULL
WHERE userUserName = @UN</ENTRY> <ENTRY timestamp='10:17:44'>SET @UN = 'jt1515ku1'</ENTRY> <ENTRY timestamp='~'>UPDATE `user`
SET userPassword = NULL
 , userPasswordMD5 = NULL
WHERE userUserName = @UN</ENTRY> <ENTRY timestamp='10:17:50'>SELECT CAST(FROM_BASE64(userPasswordMD5) as char) AS password
 , user.*
 FROM `user`
 WHERE userLastName = 'Moise'</ENTRY> <ENTRY timestamp='10:17:51'>~</ENTRY> <ENTRY timestamp='10:17:59'>~</ENTRY> <ENTRY timestamp='10:19:04'>UPDATE `user`
SET userPassword = NULL
 , userPasswordMD5 = NULL
WHERE userUserName = @UN</ENTRY> <ENTRY timestamp='10:19:29'>SET @UN = 'jt1515ku1'</ENTRY> <ENTRY timestamp='~'>UPDATE `user`
SET userPassword = NULL
 , userPasswordMD5 = NULL
WHERE userUserName = @UN</ENTRY> <ENTRY timestamp='10:20:17'>SET @UN = 'jt1515ku'</ENTRY> <ENTRY timestamp='~'>UPDATE `user`
SET userPassword = NULL
 , userPasswordMD5 = NULL
WHERE userUserName = @UN</ENTRY> <ENTRY timestamp='10:20:26'>SELECT CAST(FROM_BASE64(userPasswordMD5) as char) AS password
 , user.*
 FROM `user`
 WHERE userLastName = 'Moise'</ENTRY> <ENTRY timestamp='10:20:43'>~</ENTRY> <ENTRY timestamp='10:21:26'>SET @UN = 'jt1515ku'</ENTRY> <ENTRY timestamp='~'>UPDATE `user`
SET userPassword = NULL
 , userPasswordMD5 = NULL
WHERE userUserName = @UN</ENTRY> <ENTRY timestamp='10:21:30'>SELECT CAST(FROM_BASE64(userPasswordMD5) as char) AS password
 , user.*
 FROM `user`
 WHERE userLastName = 'Moise'</ENTRY> <ENTRY timestamp='10:21:41'>~</ENTRY> <ENTRY timestamp='10:24:21'>SET @UN = 'jt1515ku'</ENTRY> <ENTRY timestamp='~'>UPDATE `user`
SET userPassword = NULL
 , userPasswordMD5 = NULL
WHERE userUserName = @UN</ENTRY> <ENTRY timestamp='10:24:24'>SELECT CAST(FROM_BASE64(userPasswordMD5) as char) AS password
 , user.*
 FROM `user`
 WHERE userLastName = 'Moise'</ENTRY> <ENTRY timestamp='10:24:45'>~</ENTRY> <ENTRY timestamp='10:26:26'>SET @ULN = 'Moise'</ENTRY> <ENTRY timestamp='~'>SELECT CAST(FROM_BASE64(userPasswordMD5) as char) AS password
 , user.*
 FROM `user`
 WHERE userLastName = @ULN</ENTRY> <ENTRY timestamp='10:28:17'>SET @UFN = 'Reji'</ENTRY> <ENTRY timestamp='~'>SELECT CAST(FROM_BASE64(userPasswordMD5) as char) AS password
 , user.*
 FROM `user`
 WHERE userFirstName = @UFN</ENTRY> <ENTRY timestamp='10:28:42'>SET @UFN = 'Rejino'</ENTRY> <ENTRY timestamp='~'>SELECT CAST(FROM_BASE64(userPasswordMD5) as char) AS password
 , user.*
 FROM `user`
 WHERE userFirstName = @UFN</ENTRY> <ENTRY timestamp='10:50:12'>SET @ULN = ''</ENTRY> <ENTRY timestamp='~'>SELECT CAST(FROM_BASE64(userPasswordMD5) as char) AS password
 , user.*
 FROM `user`
 WHERE userLastName = @ULN</ENTRY> <ENTRY timestamp='10:50:19'>SET @UFN = ''</ENTRY> <ENTRY timestamp='~'>SELECT CAST(FROM_BASE64(userPasswordMD5) as char) AS password
 , user.*
 FROM `user`
 WHERE userFirstName = @UFN</ENTRY> <ENTRY timestamp='11:18:46'>SET @UFN = ''</ENTRY> <ENTRY timestamp='~'>SELECT user.*, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userFirstName = @UFN</ENTRY> <ENTRY timestamp='11:21:28'>SET @ULN = ''</ENTRY> <ENTRY timestamp='~'>SELECT user.*, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 , user.*
 FROM `user`
 WHERE userLastName = @ULN</ENTRY> <ENTRY timestamp='11:22:18'>SET @ULN = 'Martinson'</ENTRY> <ENTRY timestamp='~'>SELECT user.*, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 , user.*
 FROM `user`
 WHERE userLastName = @ULN</ENTRY> <ENTRY timestamp='11:22:34'>SET @ULN = 'Martinson'</ENTRY> <ENTRY timestamp='~'>SELECT user.*, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userLastName = @ULN</ENTRY> <ENTRY timestamp='11:22:45'>SET @ULN = ''</ENTRY> <ENTRY timestamp='~'>SELECT user.*, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userLastName = @ULN</ENTRY> <ENTRY timestamp='20:17:44'>SET @UFN = 'Terence'</ENTRY> <ENTRY timestamp='~'>SELECT user.*, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userFirstName = @UFN</ENTRY> <ENTRY timestamp='20:33:51'>SET @UFN = 'Alex'</ENTRY> <ENTRY timestamp='~'>SELECT user.*, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userFirstName = @UFN</ENTRY> <ENTRY timestamp='20:36:34'>SELECT * FROM jimmarti_cst.user</ENTRY> <ENTRY timestamp='20:39:57'>UPDATE `jimmarti_cst`.`user` SET `userEmail`='alex.neuman@go.ridgewater.edu' WHERE `userId`='1417'</ENTRY> <ENTRY timestamp='20:41:37'>SET @ULN = 'Cermak'</ENTRY> <ENTRY timestamp='~'>SELECT user.*, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userLastName = @ULN</ENTRY> <ENTRY timestamp='20:42:22'>SELECT * FROM jimmarti_cst.user</ENTRY> <ENTRY timestamp='20:42:56'>~</ENTRY> <ENTRY timestamp='20:45:33'>~</ENTRY> <ENTRY timestamp='20:46:41'>UPDATE `jimmarti_cst`.`user` SET `userEmail`='anthony.cermak@go.ridgewater.edu' WHERE `userId`='1420'</ENTRY> <ENTRY timestamp='20:48:43'>UPDATE `jimmarti_cst`.`user`
SET `userEmail`='brayden.weaver@go.ridgewater.edu'
WHERE `userUsername`='yh6112cy'</ENTRY> <ENTRY timestamp='21:13:14'>UPDATE `jimmarti_cst`.`user`
SET `userEmail`='brenda.rabago@go.ridgewater.edu'
WHERE `userUsername`='ew7681dv'</ENTRY> <ENTRY timestamp='21:14:30'>UPDATE `jimmarti_cst`.`user`
SET `userEmail`='ignacio.hernandez@go.ridgewater.edu'
WHERE `userUsername`='pk2556ob'</ENTRY> <ENTRY timestamp='21:15:16'>UPDATE `jimmarti_cst`.`user`
SET `userEmail`='jordan.wiest@go.ridgewater.edu'
WHERE `userUsername`='oj5253up'</ENTRY> <ENTRY timestamp='21:15:50'>UPDATE `jimmarti_cst`.`user`
SET `userEmail`='Josh.VanBuren@go.ridgewater.edu'
WHERE `userUsername`='qc6556qf'</ENTRY> <ENTRY timestamp='21:15:52'>~</ENTRY> <ENTRY timestamp='21:16:43'>UPDATE `jimmarti_cst`.`user`
SET `userEmail`='KienholzKai@go.ridgewater.edu'
WHERE `userUsername`='jv8126hn'</ENTRY> <ENTRY timestamp='21:17:15'>UPDATE `jimmarti_cst`.`user`
SET `userEmail`='parker.towne@go.ridgewater.edu'
WHERE `userUsername`='ek9058mr'</ENTRY> <ENTRY timestamp='21:17:48'>UPDATE `jimmarti_cst`.`user`
SET `userEmail`='tanner.petschl@go.ridgewater.edu'
WHERE `userUsername`='do2730xl'</ENTRY> <ENTRY timestamp='21:54:23'>SELECT * FROM jimmarti_cst.user</ENTRY> <ENTRY timestamp='21:55:01'>SET @ULN = ''</ENTRY> <ENTRY timestamp='~'>SELECT user.*, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userLastName = @ULN</ENTRY> <ENTRY timestamp='21:55:46'>DELETE FROM `jimmarti_cst`.`user` WHERE `userId`='1160'</ENTRY> <ENTRY timestamp='22:01:48'>UPDATE `jimmarti_cst`.`user`
SET `userEmail`='annabelle.solomon@go.ridgewater.edu'
WHERE `userUsername`='kj5777sw'</ENTRY> <ENTRY timestamp='22:02:37'>UPDATE `jimmarti_cst`.`user`
SET `userEmail`='brandon.kidrowski@go.ridgewater.edu'
WHERE `userUsername`='hk4344zx'</ENTRY> <ENTRY timestamp='22:05:47'>SET @UUN = 'wi8731ji'</ENTRY> <ENTRY timestamp='~'>SET @EMAIL = 'gene.leppala@go.ridgewater.edu'</ENTRY> <ENTRY timestamp='~'>UPDATE `jimmarti_cst`.`user`
SET `userEmail`=@EMAIL
WHERE `userUsername`=@UUN</ENTRY> <ENTRY timestamp='22:06:17'>SET @UUN = 'lf8821fl'</ENTRY> <ENTRY timestamp='~'>SET @EMAIL = 'delante.sowada@go.ridgewater.edu'</ENTRY> <ENTRY timestamp='~'>UPDATE `jimmarti_cst`.`user`
SET `userEmail`=@EMAIL
WHERE `userUsername`=@UUN</ENTRY> <ENTRY timestamp='22:06:46'>SET @UUN = 'fn0672ti'</ENTRY> <ENTRY timestamp='~'>SET @EMAIL = 'kalliope.milne@go.ridgewater.edu'</ENTRY> <ENTRY timestamp='~'>UPDATE `jimmarti_cst`.`user`
SET `userEmail`=@EMAIL
WHERE `userUsername`=@UUN</ENTRY> <ENTRY timestamp='22:07:46'>SET @UUN = 'bi5536pi'</ENTRY> <ENTRY timestamp='~'>SET @EMAIL = 'jack.rice@go.ridgewater.edu'</ENTRY> <ENTRY timestamp='~'>UPDATE `jimmarti_cst`.`user`
SET `userEmail`=@EMAIL
WHERE `userUsername`=@UUN</ENTRY> <ENTRY timestamp='22:08:44'>SET @UUN = 'dn5134dk'</ENTRY> <ENTRY timestamp='~'>SET @EMAIL = 'candace.grabinger@go.ridgewater.edu'</ENTRY> <ENTRY timestamp='~'>UPDATE `jimmarti_cst`.`user`
SET `userEmail`=@EMAIL
WHERE `userUsername`=@UUN</ENTRY> <ENTRY timestamp='22:09:27'>SET @UUN = 'rt2337ju'</ENTRY> <ENTRY timestamp='~'>SET @EMAIL = 'jack.poulin@go.ridgewater.edu'</ENTRY> <ENTRY timestamp='22:09:28'>UPDATE `jimmarti_cst`.`user`
SET `userEmail`=@EMAIL
WHERE `userUsername`=@UUN</ENTRY> <ENTRY timestamp='22:10:34'>SET @UUN = 'zv2138de'</ENTRY> <ENTRY timestamp='~'>SET @EMAIL = 'RichardsonPai@go.ridgewater.edu'</ENTRY> <ENTRY timestamp='~'>UPDATE `jimmarti_cst`.`user`
SET `userEmail`=@EMAIL
WHERE `userUsername`=@UUN</ENTRY> <ENTRY timestamp='22:12:00'>SET @UUN = 'et7406ez'</ENTRY> <ENTRY timestamp='~'>SET @EMAIL = 'dylan.weidman@go.ridgewater.edu'</ENTRY> <ENTRY timestamp='~'>UPDATE `jimmarti_cst`.`user`
SET `userEmail`=@EMAIL
WHERE `userUsername`=@UUN</ENTRY> <ENTRY timestamp='22:12:43'>SET @UUN = 'cm9430xd'</ENTRY> <ENTRY timestamp='~'>SET @EMAIL = 'james.young@go.ridgewater.edu'</ENTRY> <ENTRY timestamp='~'>UPDATE `jimmarti_cst`.`user`
SET `userEmail`=@EMAIL
WHERE `userUsername`=@UUN</ENTRY> <ENTRY timestamp='22:13:02'>SET @UUN = 'qx6183zf'</ENTRY> <ENTRY timestamp='~'>SET @EMAIL = 'michael.young@go.ridgewater.edu'</ENTRY> <ENTRY timestamp='~'>UPDATE `jimmarti_cst`.`user`
SET `userEmail`=@EMAIL
WHERE `userUsername`=@UUN</ENTRY> <ENTRY timestamp='22:14:19'>SET @UUN = 'qu7441dn'</ENTRY> <ENTRY timestamp='~'>SET @EMAIL = 'nathaniel.dean@go.ridgewater.edu'</ENTRY> <ENTRY timestamp='~'>UPDATE `jimmarti_cst`.`user`
SET `userEmail`=@EMAIL
WHERE `userUsername`=@UUN</ENTRY> <ENTRY timestamp='22:14:43'>SET @UUN = 'kl8668yg'</ENTRY> <ENTRY timestamp='~'>SET @EMAIL = 'tristan.johnson@go.ridgewater.edu'</ENTRY> <ENTRY timestamp='~'>UPDATE `jimmarti_cst`.`user`
SET `userEmail`=@EMAIL
WHERE `userUsername`=@UUN</ENTRY> <ENTRY timestamp='22:15:08'>SET @UUN = 'gj3530su'</ENTRY> <ENTRY timestamp='~'>SET @EMAIL = 'emily.madrid@go.ridgewater.edu'</ENTRY> <ENTRY timestamp='~'>UPDATE `jimmarti_cst`.`user`
SET `userEmail`=@EMAIL
WHERE `userUsername`=@UUN</ENTRY> <ENTRY timestamp='22:15:35'>SET @UUN = 'kw2732rl'</ENTRY> <ENTRY timestamp='~'>SET @EMAIL = 'timothy.oneil@go.ridgewater.edu'</ENTRY> <ENTRY timestamp='~'>UPDATE `jimmarti_cst`.`user`
SET `userEmail`=@EMAIL
WHERE `userUsername`=@UUN</ENTRY> <ENTRY timestamp='22:15:56'>SET @UUN = 'wi4118vi'</ENTRY> <ENTRY timestamp='~'>SET @EMAIL = 'david.pillatzki@go.ridgewater.edu'</ENTRY> <ENTRY timestamp='~'>UPDATE `jimmarti_cst`.`user`
SET `userEmail`=@EMAIL
WHERE `userUsername`=@UUN</ENTRY> <ENTRY timestamp='22:16:17'>SET @UUN = 'qs7433sr'</ENTRY> <ENTRY timestamp='~'>SET @EMAIL = 'mak.stabenow@go.ridgewater.edu'</ENTRY> <ENTRY timestamp='~'>UPDATE `jimmarti_cst`.`user`
SET `userEmail`=@EMAIL
WHERE `userUsername`=@UUN</ENTRY> <ENTRY timestamp='22:16:49'>SET @UUN = 'ft5542vr'</ENTRY> <ENTRY timestamp='~'>SET @EMAIL = 'patrick.wallace@go.ridgewater.edu'</ENTRY> <ENTRY timestamp='~'>UPDATE `jimmarti_cst`.`user`
SET `userEmail`=@EMAIL
WHERE `userUsername`=@UUN</ENTRY> <ENTRY timestamp='22:17:22'>SET @UUN = 'ee6482en'</ENTRY> <ENTRY timestamp='~'>SET @EMAIL = 'racheal.walz@go.ridgewater.edu'</ENTRY> <ENTRY timestamp='~'>UPDATE `jimmarti_cst`.`user`
SET `userEmail`=@EMAIL
WHERE `userUsername`=@UUN</ENTRY> <ENTRY timestamp='22:18:04'>SET @UFN = ''</ENTRY> <ENTRY timestamp='~'>SELECT user.*, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userFirstName = @UFN</ENTRY> <ENTRY timestamp='22:18:27'>SET @UUN = ''</ENTRY> <ENTRY timestamp='22:18:31'>~</ENTRY> <ENTRY timestamp='~'>SELECT user.*, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userUsername = @UUN</ENTRY> <ENTRY timestamp='22:18:53'>SET @ULN = ''</ENTRY> <ENTRY timestamp='~'>SELECT user.*, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userLastName = @ULN</ENTRY> <ENTRY timestamp='16:04:45'>SELECT userFirstName
 , userMiddleName
 , userLastName
 , userNickname
 #, IF ( userNickname = '' OR userNickname IS NULL, userFirstName, userNickname ) AS preferredName # username[].
 FROM `user` 
 WHERE userId = 1</ENTRY> <ENTRY timestamp='16:09:53'>SELECT DISTINCT
 userId,
 userUsername,
 user.userStudentId,
 userFirstName,
 userMiddleName,
 userLastName,
 userNickname,
 userDN,
 userEmail,
 userImage,
 userIsInactive,
 userIsStudent,
 userIsAlumni,
 userComments,
 userDefaultDrive,
 userLoggedIn,
 userLoginCount,
 userAccessTime,
 userIPAddress,
 userIPDecimal,
 userPHPSESSID,
 lastModified,
 modifiedBy,
 userAdvisor,
 userClassification,
 userMajor,

 IF (user.userStudentId = `4035`, 50,
 IF (user.userStudentId LIKE `%4035`, 25,
 IF (user.userStudentId LIKE `%4035%`, 12, 0 ) ) )
 +
 
 0 AS score
 FROM `user`
 LEFT JOIN userdata ON user.userStudentId = userdata.userStudentId
 LEFT JOIN studentprofile ON studentprofile.userId = user.userId
 WHERE (
 1=0

 OR userFirstName LIKE `%4035%`
 OR userNickname LIKE `%4035%`
 OR userMiddleName LIKE `%4035%`
 OR userLastName LIKE `%4035%`
 OR user.userStudentId LIKE `%4035%`
 OR studentprofile.studentprofileEmail1 LIKE `%4035%`
 OR studentprofile.studentprofileEmail2 LIKE `%4035%`
 OR studentprofile.studentprofilePhone1 LIKE `%4035%`
 OR studentprofile.studentprofilePhone2 LIKE `%4035%`
 
 )
 ORDER BY score DESC, userLastName, userFirstName, userMiddleName</ENTRY> <ENTRY timestamp='16:10:51'>SELECT DISTINCT
 user.userId,
 userUsername,
 user.userStudentId,
 userFirstName,
 userMiddleName,
 userLastName,
 userNickname,
 userDN,
 userEmail,
 userImage,
 userIsInactive,
 userIsStudent,
 userIsAlumni,
 userComments,
 userDefaultDrive,
 userLoggedIn,
 userLoginCount,
 userAccessTime,
 userIPAddress,
 userIPDecimal,
 userPHPSESSID,
 lastModified,
 modifiedBy,
 userAdvisor,
 userClassification,
 userMajor,

 IF (user.userStudentId = `4035`, 50,
 IF (user.userStudentId LIKE `%4035`, 25,
 IF (user.userStudentId LIKE `%4035%`, 12, 0 ) ) )
 +
 
 0 AS score
 FROM `user`
 LEFT JOIN userdata ON user.userStudentId = userdata.userStudentId
 LEFT JOIN studentprofile ON studentprofile.userId = user.userId
 WHERE (
 1=0

 OR userFirstName LIKE `%4035%`
 OR userNickname LIKE `%4035%`
 OR userMiddleName LIKE `%4035%`
 OR userLastName LIKE `%4035%`
 OR user.userStudentId LIKE `%4035%`
 OR studentprofile.studentprofileEmail1 LIKE `%4035%`
 OR studentprofile.studentprofileEmail2 LIKE `%4035%`
 OR studentprofile.studentprofilePhone1 LIKE `%4035%`
 OR studentprofile.studentprofilePhone2 LIKE `%4035%`
 
 )
 ORDER BY score DESC, userLastName, userFirstName, userMiddleName</ENTRY> <ENTRY timestamp='17:42:51'>SET @ULN = 'King'</ENTRY> <ENTRY timestamp='~'>SELECT user.*, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userLastName = @ULN</ENTRY> <ENTRY timestamp='17:43:19'>SELECT * FROM jimmarti_cst.user</ENTRY> <ENTRY timestamp='17:44:36'>INSERT INTO `jimmarti_cst`.`user` (`userUsername`, `userStudentId`, `userFirstName`, `userLastName`) VALUES ('hc7283jk', '15046222', 'Andrew', 'King')</ENTRY> <ENTRY timestamp='17:44:42'>SET @ULN = 'King'</ENTRY> <ENTRY timestamp='~'>SELECT user.*, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userLastName = @ULN</ENTRY> <ENTRY timestamp='17:45:02'>SET @ULN = 'King'</ENTRY> <ENTRY timestamp='~'>SELECT user.*, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userLastName = @ULN</ENTRY> <ENTRY timestamp='17:45:20'>SET @UFN = 'Andrew'</ENTRY> <ENTRY timestamp='~'>SELECT user.*, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userFirstName = @UFN</ENTRY> <ENTRY timestamp='17:46:13'>SET @UFN = 'Andrew'</ENTRY> <ENTRY timestamp='~'>SELECT user.*, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userFirstName = @UFN
ORDER BY userUsername</ENTRY> <ENTRY timestamp='17:46:32'>SET @UFN = 'Andrew'</ENTRY> <ENTRY timestamp='~'>SELECT user.*, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userFirstName = @UFN
ORDER BY userLastName</ENTRY> <ENTRY timestamp='17:47:08'>SET @ULN = 'King'</ENTRY> <ENTRY timestamp='~'>SELECT user.*, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userLastName = @ULN
ORDER By userFirstName</ENTRY> <ENTRY timestamp='17:47:14'>SET @UUN = ''</ENTRY> <ENTRY timestamp='~'>SELECT user.*, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userUsername = @UUN</ENTRY> <ENTRY timestamp='17:47:25'>SELECT DISTINCT
 user.userId,
 userUsername,
 user.userStudentId,
 userFirstName,
 userMiddleName,
 userLastName,
 userNickname,
 userDN,
 userEmail,
 userImage,
 userIsInactive,
 userIsStudent,
 userIsAlumni,
 userComments,
 userDefaultDrive,
 userLoggedIn,
 userLoginCount,
 userAccessTime,
 userIPAddress,
 userIPDecimal,
 userPHPSESSID,
 lastModified,
 modifiedBy,
 userAdvisor,
 userClassification,
 userMajor,

 IF (user.userStudentId = `4035`, 50,
 IF (user.userStudentId LIKE `%4035`, 25,
 IF (user.userStudentId LIKE `%4035%`, 12, 0 ) ) )
 +
 
 0 AS score
 FROM `user`
 LEFT JOIN userdata ON user.userStudentId = userdata.userStudentId
 LEFT JOIN studentprofile ON studentprofile.userId = user.userId
 WHERE (
 1=0

 OR userFirstName LIKE `%4035%`
 OR userNickname LIKE `%4035%`
 OR userMiddleName LIKE `%4035%`
 OR userLastName LIKE `%4035%`
 OR user.userStudentId LIKE `%4035%`
 OR studentprofile.studentprofileEmail1 LIKE `%4035%`
 OR studentprofile.studentprofileEmail2 LIKE `%4035%`
 OR studentprofile.studentprofilePhone1 LIKE `%4035%`
 OR studentprofile.studentprofilePhone2 LIKE `%4035%`
 
 )
 ORDER BY score DESC, userLastName, userFirstName, userMiddleName</ENTRY> <ENTRY timestamp='17:47:53'>SELECT DISTINCT
 user.userId,
 userUsername,
 user.userStudentId,
 userFirstName,
 userMiddleName,
 userLastName,
 userNickname,
 userDN,
 userEmail,
 userImage,
 userIsInactive,
 userIsStudent,
 userIsAlumni,
 userComments,
 userDefaultDrive,
 userLoggedIn,
 userLoginCount,
 userAccessTime,
 userIPAddress,
 userIPDecimal,
 userPHPSESSID,
 userAdvisor,
 userClassification,
 userMajor,

 IF (user.userStudentId = `4035`, 50,
 IF (user.userStudentId LIKE `%4035`, 25,
 IF (user.userStudentId LIKE `%4035%`, 12, 0 ) ) )
 +
 
 0 AS score
 FROM `user`
 LEFT JOIN userdata ON user.userStudentId = userdata.userStudentId
 LEFT JOIN studentprofile ON studentprofile.userId = user.userId
 WHERE (
 1=0

 OR userFirstName LIKE `%4035%`
 OR userNickname LIKE `%4035%`
 OR userMiddleName LIKE `%4035%`
 OR userLastName LIKE `%4035%`
 OR user.userStudentId LIKE `%4035%`
 OR studentprofile.studentprofileEmail1 LIKE `%4035%`
 OR studentprofile.studentprofileEmail2 LIKE `%4035%`
 OR studentprofile.studentprofilePhone1 LIKE `%4035%`
 OR studentprofile.studentprofilePhone2 LIKE `%4035%`
 
 )
 ORDER BY score DESC, userLastName, userFirstName, userMiddleName</ENTRY> <ENTRY timestamp='17:48:40'>~</ENTRY> <ENTRY timestamp='17:49:03'>~</ENTRY> <ENTRY timestamp='17:51:36'>SELECT DISTINCT
 user.userId,
 userUsername,
 user.userStudentId,
 userFirstName,
 userMiddleName,
 userLastName,
 userNickname,
 userDN,
 userEmail,
 userImage,
 userIsInactive,
 userIsStudent,
 userIsAlumni,
 userComments,
 userDefaultDrive,
 userLoggedIn,
 userLoginCount,
 userAccessTime,
 userIPAddress,
 userIPDecimal,
 userPHPSESSID,
 userAdvisor,
 userClassification,
 userMajor,

 IF (user.userStudentId = '4035', 50,
 IF (user.userStudentId LIKE '%4035', 25,
 IF (user.userStudentId LIKE '%4035%', 12, 0 ) ) )
 +
 
 0 AS score
 FROM 'user'
 LEFT JOIN userdata ON user.userStudentId = userdata.userStudentId
 LEFT JOIN studentprofile ON studentprofile.userId = user.userId
 WHERE (
 1=0

 OR userFirstName LIKE '%4035%'
 OR userNickname LIKE '%4035%'
 OR userMiddleName LIKE '%4035%'
 OR userLastName LIKE '%4035%'
 OR user.userStudentId LIKE '%4035%'
 OR studentprofile.studentprofileEmail1 LIKE '%4035%'
 OR studentprofile.studentprofileEmail2 LIKE '%4035%'
 OR studentprofile.studentprofilePhone1 LIKE '%4035%'
 OR studentprofile.studentprofilePhone2 LIKE '%4035%'
 
 )
 ORDER BY score DESC, userLastName, userFirstName, userMiddleName</ENTRY> <ENTRY timestamp='17:52:49'>SELECT DISTINCT
 user.userId,
 userUsername,
 user.userStudentId,
 userFirstName,
 userMiddleName,
 userLastName,
 userNickname,
 userDN,
 userEmail,
 userImage,
 userIsInactive,
 userIsStudent,
 userIsAlumni,
 userComments,
 userDefaultDrive,
 userLoggedIn,
 userLoginCount,
 userAccessTime,
 userIPAddress,
 userIPDecimal,
 userPHPSESSID,
 userAdvisor,
 userClassification,
 userMajor,

 IF (user.userStudentId = '4035', 50,
 IF (user.userStudentId LIKE '%4035', 25,
 IF (user.userStudentId LIKE '%4035%', 12, 0 ) ) )
 +
 
 0 AS score
 FROM `user`
 LEFT JOIN `userdata` ON user.userStudentId = userdata.userStudentId
 LEFT JOIN `studentprofile` ON studentprofile.userId = user.userId
 WHERE (
 1=0

 OR userFirstName LIKE '%4035%'
 OR userNickname LIKE '%4035%'
 OR userMiddleName LIKE '%4035%'
 OR userLastName LIKE '%4035%'
 OR user.userStudentId LIKE '%4035%'
 OR studentprofile.studentprofileEmail1 LIKE '%4035%'
 OR studentprofile.studentprofileEmail2 LIKE '%4035%'
 OR studentprofile.studentprofilePhone1 LIKE '%4035%'
 OR studentprofile.studentprofilePhone2 LIKE '%4035%'
 
 )
 ORDER BY score DESC, userLastName, userFirstName, userMiddleName</ENTRY> <ENTRY timestamp='17:54:42'>SET @search = '4035'</ENTRY> <ENTRY timestamp='~'>SELECT DISTINCT
 user.userId,
 userUsername,
 user.userStudentId,
 userFirstName,
 userMiddleName,
 userLastName,
 userNickname,
 userDN,
 userEmail,
 userImage,
 userIsInactive,
 userIsStudent,
 userIsAlumni,
 userComments,
 userDefaultDrive,
 userLoggedIn,
 userLoginCount,
 userAccessTime,
 userIPAddress,
 userIPDecimal,
 userPHPSESSID,
 userAdvisor,
 userClassification,
 userMajor,

 IF (user.userStudentId = '@search ', 50,
 IF (user.userStudentId LIKE '%@search ', 25,
 IF (user.userStudentId LIKE '%@search %', 12, 0 ) ) )
 +
 
 0 AS score
 FROM `user`
 LEFT JOIN `userdata` ON user.userStudentId = userdata.userStudentId
 LEFT JOIN `studentprofile` ON studentprofile.userId = user.userId
 WHERE (
 1=0

 OR userFirstName LIKE '%@search %'
 OR userNickname LIKE '%@search %'
 OR userMiddleName LIKE '%@search %'
 OR userLastName LIKE '%@search %'
 OR user.userStudentId LIKE '%@search %'
 OR studentprofile.studentprofileEmail1 LIKE '%@search %'
 OR studentprofile.studentprofileEmail2 LIKE '%@search %'
 OR studentprofile.studentprofilePhone1 LIKE '%@search %'
 OR studentprofile.studentprofilePhone2 LIKE '%@search %'
 
 )
 ORDER BY score DESC, userLastName, userFirstName, userMiddleName</ENTRY> <ENTRY timestamp='17:55:28'>SET @search = '4035'</ENTRY> <ENTRY timestamp='17:55:29'>SELECT DISTINCT
 user.userId,
 userUsername,
 user.userStudentId,
 userFirstName,
 userMiddleName,
 userLastName,
 userNickname,
 userDN,
 userEmail,
 userImage,
 userIsInactive,
 userIsStudent,
 userIsAlumni,
 userComments,
 userDefaultDrive,
 userLoggedIn,
 userLoginCount,
 userAccessTime,
 userIPAddress,
 userIPDecimal,
 userPHPSESSID,
 userAdvisor,
 userClassification,
 userMajor,

 IF (user.userStudentId = '@search', 50,
 IF (user.userStudentId LIKE '%@search', 25,
 IF (user.userStudentId LIKE '%@search%', 12, 0 ) ) )
 +
 
 0 AS score
 FROM `user`
 LEFT JOIN `userdata` ON user.userStudentId = userdata.userStudentId
 LEFT JOIN `studentprofile` ON studentprofile.userId = user.userId
 WHERE (
 1=0

 OR userFirstName LIKE '%@search%'
 OR userNickname LIKE '%@search%'
 OR userMiddleName LIKE '%@search%'
 OR userLastName LIKE '%@search%'
 OR user.userStudentId LIKE '%@search%'
 OR studentprofile.studentprofileEmail1 LIKE '%@search%'
 OR studentprofile.studentprofileEmail2 LIKE '%@search%'
 OR studentprofile.studentprofilePhone1 LIKE '%@search%'
 OR studentprofile.studentprofilePhone2 LIKE '%@search%'
 
 )
 ORDER BY score DESC, userLastName, userFirstName, userMiddleName</ENTRY> <ENTRY timestamp='17:56:23'>SET @search = 'Andrew'</ENTRY> <ENTRY timestamp='~'>SELECT DISTINCT
 user.userId,
 userUsername,
 user.userStudentId,
 userFirstName,
 userMiddleName,
 userLastName,
 userNickname,
 userDN,
 userEmail,
 userImage,
 userIsInactive,
 userIsStudent,
 userIsAlumni,
 userComments,
 userDefaultDrive,
 userLoggedIn,
 userLoginCount,
 userAccessTime,
 userIPAddress,
 userIPDecimal,
 userPHPSESSID,
 userAdvisor,
 userClassification,
 userMajor,

 IF (user.userStudentId = '@search', 50,
 IF (user.userStudentId LIKE '%@search', 25,
 IF (user.userStudentId LIKE '%@search%', 12, 0 ) ) )
 +
 
 0 AS score
 FROM `user`
 LEFT JOIN `userdata` ON user.userStudentId = userdata.userStudentId
 LEFT JOIN `studentprofile` ON studentprofile.userId = user.userId
 WHERE (
 1=0

 OR userFirstName LIKE '%@search%'
 OR userNickname LIKE '%@search%'
 OR userMiddleName LIKE '%@search%'
 OR userLastName LIKE '%@search%'
 OR user.userStudentId LIKE '%@search%'
 OR studentprofile.studentprofileEmail1 LIKE '%@search%'
 OR studentprofile.studentprofileEmail2 LIKE '%@search%'
 OR studentprofile.studentprofilePhone1 LIKE '%@search%'
 OR studentprofile.studentprofilePhone2 LIKE '%@search%'
 
 )
 ORDER BY score DESC, userLastName, userFirstName, userMiddleName</ENTRY> <ENTRY timestamp='17:59:56'>SET @search = '4035'</ENTRY> <ENTRY timestamp='~'>SELECT DISTINCT
 user.userId,
 userUsername,
 user.userStudentId,
 userFirstName,
 userMiddleName,
 userLastName,
 userNickname,
 userDN,
 userEmail,
 userImage,
 userIsInactive,
 userIsStudent,
 userIsAlumni,
 userComments,
 userDefaultDrive,
 userLoggedIn,
 userLoginCount,
 userAccessTime,
 userIPAddress,
 userIPDecimal,
 userPHPSESSID,
 userAdvisor,
 userClassification,
 userMajor,

 IF (user.userStudentId = @search, 50,
 IF (user.userStudentId LIKE CONCAT('%',@search) 25,
 IF (user.userStudentId LIKE CONCAT('%',@search,'%'), 12, 0 ) ) )
 +
 
 0 AS score
 FROM `user`
 LEFT JOIN `userdata` ON user.userStudentId = userdata.userStudentId
 LEFT JOIN `studentprofile` ON studentprofile.userId = user.userId
 WHERE (
 1=0

 OR userFirstName LIKE CONCAT('%',@search,'%')
 OR userNickname LIKE CONCAT('%',@search,'%')
 OR userMiddleName LIKE CONCAT('%',@search,'%')
 OR userLastName LIKE CONCAT('%',@search,'%')
 OR user.userStudentId LIKE CONCAT('%',@search,'%')
 OR studentprofile.studentprofileEmail1 LIKE CONCAT('%',@search,'%')
 OR studentprofile.studentprofileEmail2 LIKE CONCAT('%',@search,'%')
 OR studentprofile.studentprofilePhone1 LIKE CONCAT('%',@search,'%')
 OR studentprofile.studentprofilePhone2 LIKE CONCAT('%',@search,'%')
 
 )
 ORDER BY score DESC, userLastName, userFirstName, userMiddleName</ENTRY> <ENTRY timestamp='18:01:26'>SET @search = '4035'</ENTRY> <ENTRY timestamp='~'>SELECT DISTINCT
 user.userId,
 userUsername,
 user.userStudentId,
 userFirstName,
 userMiddleName,
 userLastName,
 userNickname,
 userDN,
 userEmail,
 userImage,
 userIsInactive,
 userIsStudent,
 userIsAlumni,
 userComments,
 userDefaultDrive,
 userLoggedIn,
 userLoginCount,
 userAccessTime,
 userIPAddress,
 userIPDecimal,
 userPHPSESSID,
 userAdvisor,
 userClassification,
 userMajor,

 IF (user.userStudentId = @search, 50,
 IF (user.userStudentId LIKE CONCAT('%',@search), 25,
 IF (user.userStudentId LIKE CONCAT('%',@search,'%'), 12, 0 ) ) )
 +
 
 0 AS score
 FROM `user`
 LEFT JOIN `userdata` ON user.userStudentId = userdata.userStudentId
 LEFT JOIN `studentprofile` ON studentprofile.userId = user.userId
 WHERE (
 1=0

 OR userFirstName LIKE CONCAT('%',@search,'%')
 OR userNickname LIKE CONCAT('%',@search,'%')
 OR userMiddleName LIKE CONCAT('%',@search,'%')
 OR userLastName LIKE CONCAT('%',@search,'%')
 OR user.userStudentId LIKE CONCAT('%',@search,'%')
 OR studentprofile.studentprofileEmail1 LIKE CONCAT('%',@search,'%')
 OR studentprofile.studentprofileEmail2 LIKE CONCAT('%',@search,'%')
 OR studentprofile.studentprofilePhone1 LIKE CONCAT('%',@search,'%')
 OR studentprofile.studentprofilePhone2 LIKE CONCAT('%',@search,'%')
 
 )
 ORDER BY score DESC, userLastName, userFirstName, userMiddleName</ENTRY> <ENTRY timestamp='18:03:30'>SET @UFN = 'Andrew'</ENTRY> <ENTRY timestamp='~'>SELECT user.*, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userFirstName = @UFN
ORDER BY userLastName</ENTRY> <ENTRY timestamp='18:03:36'>SET @ULN = 'King'</ENTRY> <ENTRY timestamp='~'>SELECT user.*, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userLastName = @ULN
ORDER By userFirstName</ENTRY> <ENTRY timestamp='18:11:20'>GRANT SELECT
ON mysql.proc
TO cst_backup@localhost</ENTRY> <ENTRY timestamp='18:12:50'>SHOW GRANTS for cst_backup@localhost</ENTRY> <ENTRY timestamp='22:32:21'>SET @ULN = 'Olson'</ENTRY> <ENTRY timestamp='22:32:22'>SELECT user.*, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userLastName = @ULN
ORDER By userFirstName</ENTRY> <ENTRY timestamp='22:34:25'>UPDATE `user`
SET userEmail = 'OlsonDer1@go.ridgewater.edu'
where userId = 759</ENTRY> <ENTRY timestamp='04:18:34'>SET @search = '8546'</ENTRY> <ENTRY timestamp='~'>SELECT DISTINCT
 user.userId,
 userUsername,
 user.userStudentId,
 userFirstName,
 userMiddleName,
 userLastName,
 userNickname,
 userDN,
 userEmail,
 userImage,
 userIsInactive,
 userIsStudent,
 userIsAlumni,
 userComments,
 userDefaultDrive,
 userLoggedIn,
 userLoginCount,
 userAccessTime,
 userIPAddress,
 userIPDecimal,
 userPHPSESSID,
 userAdvisor,
 userClassification,
 userMajor,

 IF (user.userStudentId = @search, 50,
 IF (user.userStudentId LIKE CONCAT('%',@search), 25,
 IF (user.userStudentId LIKE CONCAT('%',@search,'%'), 12, 0 ) ) )
 +
 
 0 AS score
 FROM `user`
 LEFT JOIN `userdata` ON user.userStudentId = userdata.userStudentId
 LEFT JOIN `studentprofile` ON studentprofile.userId = user.userId
 WHERE (
 1=0

 OR userFirstName LIKE CONCAT('%',@search,'%')
 OR userNickname LIKE CONCAT('%',@search,'%')
 OR userMiddleName LIKE CONCAT('%',@search,'%')
 OR userLastName LIKE CONCAT('%',@search,'%')
 OR user.userStudentId LIKE CONCAT('%',@search,'%')
 OR studentprofile.studentprofileEmail1 LIKE CONCAT('%',@search,'%')
 OR studentprofile.studentprofileEmail2 LIKE CONCAT('%',@search,'%')
 OR studentprofile.studentprofilePhone1 LIKE CONCAT('%',@search,'%')
 OR studentprofile.studentprofilePhone2 LIKE CONCAT('%',@search,'%')
 
 )
 ORDER BY score DESC, userLastName, userFirstName, userMiddleName</ENTRY> <ENTRY timestamp='12:38:56'>SET @UUN = 'tr3688as'</ENTRY> <ENTRY timestamp='~'>SELECT user.*, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userUsername = @UUN</ENTRY> <ENTRY timestamp='12:42:43'>SELECT * FROM jimmarti_cst.user</ENTRY> <ENTRY timestamp='12:44:38'>delete from jimmarti_cst.user where userId = 1397</ENTRY> <ENTRY timestamp='~'>SELECT * FROM jimmarti_cst.user</ENTRY> <ENTRY timestamp='12:44:43'>SET @UUN = 'tr3688as'</ENTRY> <ENTRY timestamp='~'>SELECT user.*, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userUsername = @UUN</ENTRY> <ENTRY timestamp='12:45:52'>update jimmarti_cst.user set userPassword = ''</ENTRY> <ENTRY timestamp='12:46:06'>delete from jimmarti_cst.user where userId = 1397</ENTRY> <ENTRY timestamp='~'>SELECT * FROM jimmarti_cst.user</ENTRY> <ENTRY timestamp='12:46:27'>~</ENTRY> <ENTRY timestamp='12:47:17'>SELECT * FROM jimmarti_cst.user limit 2000</ENTRY> <ENTRY timestamp='12:48:01'>SET @UUN = '%'</ENTRY> <ENTRY timestamp='~'>SELECT user.*, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userUsername = @UUN</ENTRY> <ENTRY timestamp='12:48:23'>SET @UUN = '%'</ENTRY> <ENTRY timestamp='~'>SELECT user.*, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userUsername like @UUN</ENTRY> <ENTRY timestamp='12:49:31'>SET @UUN = '%'</ENTRY> <ENTRY timestamp='~'>SELECT user.*, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw, 5
 FROM `user`
 WHERE userUsername like @UUN</ENTRY> <ENTRY timestamp='17:42:38'>GRANT SELECT
ON mysql.proc
TO cst_backup@localhost</ENTRY> <ENTRY timestamp='17:42:51'>SHOW GRANTS for cst_backup@localhost</ENTRY> <ENTRY timestamp='17:43:05'>GRANT SELECT
ON mysql.proc
TO cst_backup@localhost</ENTRY> <ENTRY timestamp='~'>SHOW GRANTS for cst_backup@localhost</ENTRY> <ENTRY timestamp='17:43:15'>GRANT SELECT
ON mysql.proc
TO cst_backup@localhost</ENTRY> <ENTRY timestamp='17:44:34'>SET @UUN = 'go6495hb'</ENTRY> <ENTRY timestamp='~'>UPDATE `user`
 SET userPassword = NULL
 , userPasswordMD5 = NULL
 WHERE userUserName = @UUN</ENTRY> <ENTRY timestamp='18:01:22'>SET @ID = ''</ENTRY> <ENTRY timestamp='~'>delete from jimmarti_cst.user where userId = @ID</ENTRY> <ENTRY timestamp='~'>SELECT * FROM jimmarti_cst.user limit 2000</ENTRY> <ENTRY timestamp='18:02:34'>SET @ULN = 'Peterson'</ENTRY> <ENTRY timestamp='~'>SELECT user.*, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userLastName = @ULN
ORDER By userFirstName</ENTRY> <ENTRY timestamp='18:05:43'>SELECT * FROM jimmarti_cst.user limit 2000</ENTRY> <ENTRY timestamp='22:24:56'>UPDATE `jimmarti_cst`.`user` SET `userFirstName`='Jeremiah' WHERE `userId`='1456'</ENTRY> <ENTRY timestamp='~'>UPDATE `jimmarti_cst`.`user` SET `userFirstName`='Owen' WHERE `userId`='1455'</ENTRY> <ENTRY timestamp='~'>UPDATE `jimmarti_cst`.`user` SET `userFirstName`='Aaron' WHERE `userId`='1452'</ENTRY> <ENTRY timestamp='22:25:28'>SET @ULN = 'Peterson'</ENTRY> <ENTRY timestamp='~'>SELECT user.*, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userLastName = @ULN
ORDER By userFirstName</ENTRY> <ENTRY timestamp='22:26:00'>SET @ULN = 'Malacko'</ENTRY> <ENTRY timestamp='~'>SELECT user.*, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userLastName = @ULN
ORDER By userFirstName</ENTRY> <ENTRY timestamp='22:27:33'>SELECT * FROM jimmarti_cst.user limit 2000</ENTRY> <ENTRY timestamp='22:28:00'>SET @ULN = 'Couglin'</ENTRY> <ENTRY timestamp='~'>SELECT user.*, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userLastName = @ULN
ORDER By userFirstName</ENTRY> <ENTRY timestamp='22:28:15'>SET @ULN = 'Coughlin'</ENTRY> <ENTRY timestamp='~'>SELECT user.*, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userLastName = @ULN
ORDER By userFirstName</ENTRY> <ENTRY timestamp='22:33:38'>SELECT * FROM jimmarti_cst.user limit 2000</ENTRY> <ENTRY timestamp='22:34:05'>UPDATE `jimmarti_cst`.`user` SET `userFirstName`='' WHERE `userId`='1'</ENTRY> <ENTRY timestamp='22:34:28'>SELECT * FROM jimmarti_cst.user limit 2000</ENTRY> <ENTRY timestamp='22:34:48'>SET @ULN = ''</ENTRY> <ENTRY timestamp='~'>SELECT user.*, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userLastName = @ULN
ORDER By userFirstName</ENTRY> <ENTRY timestamp='22:34:59'>SET @ID = ''</ENTRY> <ENTRY timestamp='~'>SET @EMAIL = ''</ENTRY> <ENTRY timestamp='~'>UPDATE jimmarti_cst.user
SET userEmail= @EMAIL
where userId = @ID</ENTRY> <ENTRY timestamp='22:35:08'>SET @ID = ''</ENTRY> <ENTRY timestamp='~'>delete from jimmarti_cst.user where userId = @ID</ENTRY> <ENTRY timestamp='~'>SELECT * FROM jimmarti_cst.user limit 2000</ENTRY> <ENTRY timestamp='22:37:44'>SET @UFN = 'Jim'</ENTRY> <ENTRY timestamp='~'>SELECT user.*



























, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userFirstName = @UFN
ORDER BY userFirstName, userLastName</ENTRY> <ENTRY timestamp='22:38:29'>SET @UUN = '%'</ENTRY> <ENTRY timestamp='~'>SELECT user.*


















, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw, 5
 FROM `user`
 WHERE userUsername like @UUN
 ORDER BY userUsername</ENTRY> <ENTRY timestamp='22:39:04'>SET @UUN = '%'</ENTRY> <ENTRY timestamp='~'>SELECT user.*


















, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw, 5
 FROM `user`
 WHERE userUsername like @UUN
 ORDER BY userUsername
 LIMIT 2000</ENTRY> <ENTRY timestamp='22:39:52'>SET @ULN = '%'</ENTRY> <ENTRY timestamp='~'>SELECT user.*

















, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userLastName = @ULN
ORDER By userLastName, userFirstName
 LIMIT 2000</ENTRY> <ENTRY timestamp='22:40:32'>SET @ULN = '%'</ENTRY> <ENTRY timestamp='~'>SELECT user.*

















, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userLastName like @ULN
ORDER By userLastName, userFirstName
 LIMIT 2000</ENTRY> <ENTRY timestamp='22:40:54'>SET @ULN = '%'</ENTRY> <ENTRY timestamp='~'>SELECT user.*

















, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userLastName like @ULN
ORDER By userLastName, userFirstName
 LIMIT 2000</ENTRY> <ENTRY timestamp='22:45:48'>SELECT * FROM jimmarti_cst.user orderby userFirstName, userLastName limit 2000</ENTRY> <ENTRY timestamp='22:46:00'>SELECT * FROM jimmarti_cst.user order by userFirstName, userLastName limit 2000</ENTRY> <ENTRY timestamp='22:47:01'>SELECT * FROM jimmarti_cst.userpermission</ENTRY> <ENTRY timestamp='22:47:12'>SELECT * FROM jimmarti_cst.useruserpermission</ENTRY> <ENTRY timestamp='22:47:48'>DELETE FROM `jimmarti_cst`.`useruserpermission` WHERE `userId`='12' and`userpermissionId`='2'</ENTRY> <ENTRY timestamp='22:54:32'>SET @search = '8490'</ENTRY> <ENTRY timestamp='~'>SELECT DISTINCT
 user.userId,
 userUsername,
 user.userStudentId,
 userFirstName,
 userMiddleName,
 userLastName,
 userNickname,
 userDN,
 userEmail,
 userImage,
 userIsInactive,
 userIsStudent,
 userIsAlumni,
 userComments,
 userDefaultDrive,
 userLoggedIn,
 userLoginCount,
 userAccessTime,
 userIPAddress,
 userIPDecimal,
 userPHPSESSID,
 userAdvisor,
 userClassification,
 userMajor,

 IF (user.userStudentId = @search, 50,
 IF (user.userStudentId LIKE CONCAT('%',@search), 25,
 IF (user.userStudentId LIKE CONCAT('%',@search,'%'), 12, 0 ) ) )
 +
 
 0 AS score
 FROM `user`
 LEFT JOIN `userdata` ON user.userStudentId = userdata.userStudentId
 LEFT JOIN `studentprofile` ON studentprofile.userId = user.userId
 WHERE (
 1=0

 OR userFirstName LIKE CONCAT('%',@search,'%')
 OR userNickname LIKE CONCAT('%',@search,'%')
 OR userMiddleName LIKE CONCAT('%',@search,'%')
 OR userLastName LIKE CONCAT('%',@search,'%')
 OR user.userStudentId LIKE CONCAT('%',@search,'%')
 OR studentprofile.studentprofileEmail1 LIKE CONCAT('%',@search,'%')
 OR studentprofile.studentprofileEmail2 LIKE CONCAT('%',@search,'%')
 OR studentprofile.studentprofilePhone1 LIKE CONCAT('%',@search,'%')
 OR studentprofile.studentprofilePhone2 LIKE CONCAT('%',@search,'%')
 
 )
 ORDER BY score DESC, userLastName, userFirstName, userMiddleName</ENTRY> <ENTRY timestamp='~'>SELECT user.*

















, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userLastName like @ULN
ORDER By userLastName, userFirstName
 LIMIT 2000</ENTRY> <ENTRY timestamp='12:27:01'>SET @UFN = 'Paul'</ENTRY> <ENTRY timestamp='~'>SELECT user.*



























, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userFirstName like @UFN
ORDER BY userFirstName, userLastName
 LIMIT 2000</ENTRY> <ENTRY timestamp='13:50:42'>SET @UFN = 'Jim'</ENTRY> <ENTRY timestamp='~'>SELECT user.*



























, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userFirstName like @UFN
ORDER BY userFirstName, userLastName
 LIMIT 2000</ENTRY> <ENTRY timestamp='~'>SELECT user.*



























, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userFirstName like @UFN
ORDER BY userFirstName, userLastName
 LIMIT 2000</ENTRY> <ENTRY timestamp='02:00:49'>SELECT * FROM jimmarti_cst.user</ENTRY> <ENTRY timestamp='02:01:00'>SET @UFN = 'Tim%'</ENTRY> <ENTRY timestamp='~'>SELECT user.*



























, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userFirstName like @UFN
ORDER BY userFirstName, userLastName
 LIMIT 2000</ENTRY> <ENTRY timestamp='02:04:11'>UPDATE `jimmarti_cst`.`user` SET `userLastName`='O\'Neil' WHERE `userId`='1426'</ENTRY> <ENTRY timestamp='20:00:08'>SELECT *#studentprofile.studentprofileId
FROM `studentprofile`
WHERE studentprofile.studentprofile = 1

AND studentprofile.userId = 1</ENTRY> <ENTRY timestamp='20:00:26'>SELECT *#studentprofile.studentprofileId
FROM `studentprofile`
WHERE studentprofile.studentprofileSubmitted = 1

AND studentprofile.userId = 1</ENTRY> <ENTRY timestamp='20:01:03'>SELECT *#studentprofile.studentprofileId
FROM `studentprofile`
WHERE studentprofile.studentprofileSubmitted = true

AND studentprofile.userId = 1</ENTRY> <ENTRY timestamp='20:01:06'>~</ENTRY> <ENTRY timestamp='20:01:13'>~</ENTRY> <ENTRY timestamp='20:01:22'>SELECT *#studentprofile.studentprofileId
FROM `studentprofile`
WHERE studentprofile.studentprofileSubmitted = true

#AND studentprofile.userId = 1</ENTRY> <ENTRY timestamp='20:01:45'>SELECT *#studentprofile.studentprofileId
FROM `studentprofile`
WHERE studentprofile.studentprofileSubmitted = true
 AND studentprofile.studentprofileGraded = false
#AND studentprofile.userId = 1</ENTRY> <ENTRY timestamp='20:01:47'>~</ENTRY> <ENTRY timestamp='~'>~</ENTRY> <ENTRY timestamp='20:02:04'>SELECT *#studentprofile.studentprofileId
FROM `studentprofile`
WHERE studentprofile.studentprofileSubmitted = true
 #AND studentprofile.studentprofileGraded = false
#AND studentprofile.userId = 1</ENTRY> <ENTRY timestamp='20:02:37'>SELECT *#studentprofile.studentprofileId
FROM `studentprofile`
WHERE studentprofile.studentprofileSubmitted = true
 #AND studentprofile.studentprofileGraded = false
#AND studentprofile.userId = 1
ORDER BY studentprofile.userId</ENTRY> <ENTRY timestamp='20:07:23'>~</ENTRY> <ENTRY timestamp='20:07:34'>SELECT *#studentprofile.studentprofileId
FROM `studentprofile`
WHERE studentprofile.studentprofileSubmitted = true
 AND studentprofile.studentprofileGraded = false
#AND studentprofile.userId = 1
ORDER BY studentprofile.userId</ENTRY> <ENTRY timestamp='20:14:30'>SELECT * FROM jimmarti_cst.useruserpermission</ENTRY> <ENTRY timestamp='20:14:42'>SELECT * FROM jimmarti_cst.userpermission</ENTRY> <ENTRY timestamp='20:26:47'>SELECT * FROM jimmarti_cst.userhistory</ENTRY> <ENTRY timestamp='20:27:21'>SELECT * FROM jimmarti_cst.userhistory
ORDER BY userAccessTime DESC</ENTRY> <ENTRY timestamp='20:27:39'>SELECT * FROM jimmarti_cst.user</ENTRY> <ENTRY timestamp='20:28:17'>SELECT * FROM jimmarti_cst.user
order by lastModified desc</ENTRY> <ENTRY timestamp='20:31:10'>~</ENTRY> <ENTRY timestamp='20:31:19'>SELECT * FROM jimmarti_cst.userhistory
ORDER BY userAccessTime DESC</ENTRY> <ENTRY timestamp='20:32:30'>SELECT *, userLoginCount
FROM jimmarti_cst.user
order by lastModified desc</ENTRY> <ENTRY timestamp='20:33:05'>SELECT * FROM jimmarti_cst.userhistory
ORDER BY userAccessTime DESC</ENTRY> <ENTRY timestamp='20:34:03'>SELECT * FROM jimmarti_cst.userhistory
ORDER BY userId, userAccessTime DESC</ENTRY> <ENTRY timestamp='20:34:29'>SELECT * FROM jimmarti_cst.userhistory
ORDER BY userId, userAccessTime</ENTRY> <ENTRY timestamp='20:34:39'>SELECT * FROM jimmarti_cst.userhistory
ORDER BY userId, userAccessTime DESC</ENTRY> <ENTRY timestamp='20:35:05'>SELECT * FROM jimmarti_cst.userhistory
ORDER BY userId, userAccessTime DESC
limit 1</ENTRY> <ENTRY timestamp='20:35:29'>SELECT count(*)
ORDER BY userId, userAccessTime DESC
#limit 1</ENTRY> <ENTRY timestamp='20:36:21'>SELECT count(*)
FROM userhistory
ORDER BY userId, userAccessTime DESC
#limit 1</ENTRY> <ENTRY timestamp='20:36:38'>SELECT count(*)
FROM userhistory
group by userId
ORDER BY userId, userAccessTime DESC
#limit 1</ENTRY> <ENTRY timestamp='20:36:51'>SELECT userId, count(*)
FROM userhistory
group by userId
ORDER BY userId, userAccessTime DESC
#limit 1</ENTRY> <ENTRY timestamp='20:37:22'>SELECT userId, userhistoryId, count(*)
FROM userhistory
group by userId
ORDER BY userId, userAccessTime DESC
#limit 1</ENTRY> <ENTRY timestamp='20:37:37'>~</ENTRY> <ENTRY timestamp='20:38:07'>SELECT userId, userhistoryId
FROM userhistory
ORDER BY userId, userAccessTime DESC
#limit 1</ENTRY> <ENTRY timestamp='20:38:22'>SELECT userId, userhistoryId, userAccessTime
FROM userhistory
ORDER BY userId, userAccessTime DESC
#limit 1</ENTRY> <ENTRY timestamp='20:38:38'>SELECT userId, userhistoryId, userAccessTime
FROM userhistory
ORDER BY userId, userAccessTime DESC
limit 1</ENTRY> <ENTRY timestamp='20:39:58'>SELECT userhistoryId
FROM userhistory uh
ORDER BY uh.userAccessTime DESC
limit 1</ENTRY> <ENTRY timestamp='20:41:24'>SELECT *
FROM userhistory
WHERE userhistoryId = (
	SELECT userhistoryId
	FROM userhistory uh
 where uh.userId = userhistory.userId
	ORDER BY uh.userAccessTime DESC
	limit 1
)</ENTRY> <ENTRY timestamp='20:42:59'>SELECT userhistoryId
	FROM userhistory uh
 where uh.userId = 1#userhistory.userId
	ORDER BY uh.userAccessTime DESC
	limit 1</ENTRY> <ENTRY timestamp='20:44:35'>SELECT *, count(*)
FROM userhistory
WHERE userhistoryId = (
	SELECT userhistoryId
	FROM userhistory uh
 where uh.userId = userhistory.userId
	ORDER BY uh.userAccessTime DESC
	limit 1
)
GROUP BY userId</ENTRY> <ENTRY timestamp='20:54:40'>SELECT userhistoryId
	FROM userhistory uh
 where uh.userId = 1#userhistory.userId
	ORDER BY uh.userAccessTime DESC
	limit 1</ENTRY> <ENTRY timestamp='20:55:58'>SELECT *, count(userhistoryId)
	FROM userhistory uh
 #where uh.userId = 1#userhistory.userId
 group by uh.userId
	ORDER BY uh.userAccessTime DESC
	#limit 1</ENTRY> <ENTRY timestamp='20:56:38'>SELECT *#, count(userhistoryId)
	FROM userhistory uh
 #where uh.userId = 1#userhistory.userId
 group by uh.userId
	ORDER BY uh.userAccessTime DESC
	#limit 1</ENTRY> <ENTRY timestamp='20:57:04'>SELECT * FROM jimmarti_cst.userhistory</ENTRY> <ENTRY timestamp='20:57:35'>SELECT * FROM jimmarti_cst.userhistory
order by userAccessTime desc</ENTRY> <ENTRY timestamp='20:59:28'>SELECT userUsername, userFirstName, userLastName. userhistory.* 
FROM jimmarti_cst.userhistory uh
JOIN `user` ON user.userId = uh.userId
order by userAccessTime desc</ENTRY> <ENTRY timestamp='20:59:44'>SELECT userUsername, userFirstName, userLastName, userhistory.* 
FROM jimmarti_cst.userhistory uh
JOIN `user` ON user.userId = uh.userId
order by userAccessTime desc</ENTRY> <ENTRY timestamp='20:59:55'>SELECT userUsername, userFirstName, userLastName, uh.* 
FROM jimmarti_cst.userhistory uh
JOIN `user` ON user.userId = uh.userId
order by userAccessTime desc</ENTRY> <ENTRY timestamp='21:00:21'>SELECT *#, count(userhistoryId)
	FROM userhistory uh
 #where uh.userId = 1#userhistory.userId
 group by uh.userId
	ORDER BY uh.userAccessTime DESC
	#limit 1</ENTRY> <ENTRY timestamp='21:01:10'>~</ENTRY> <ENTRY timestamp='21:02:17'>SELECT *#, count(userhistoryId)
	FROM userhistory uh
 #where uh.userId = 1#userhistory.userId
 group by uh.userId
	ORDER BY uh.userId, uh.userAccessTime DESC
	#limit 1</ENTRY> <ENTRY timestamp='21:02:57'>SELECT userhistoryId
	FROM userhistory uh
 group by uh.userId
	ORDER BY uh.userId, uh.userAccessTime DESC</ENTRY> <ENTRY timestamp='21:03:21'>SELECT *#userhistoryId
	FROM userhistory uh
 group by uh.userId
	ORDER BY uh.userId, uh.userAccessTime DESC</ENTRY> <ENTRY timestamp='21:03:41'>SELECT *#userhistoryId
	FROM userhistory uh
 group by uh.userId
	ORDER BY uh.userAccessTime DESC</ENTRY> <ENTRY timestamp='21:06:36'>SELECT t1.*
FROM userhistory t1
WHERE t1.userAccessTime = (SELECT MAX(t2.userAccessTime)
 FROM userhistory t2
 WHERE t2.user = t1.user)</ENTRY> <ENTRY timestamp='21:07:03'>SELECT t1.*
FROM userhistory t1
WHERE t1.userAccessTime = (SELECT MAX(t2.userAccessTime)
 FROM userhistory t2
 WHERE t2.userId = t1.userId)</ENTRY> <ENTRY timestamp='21:08:12'>SELECT * FROM jimmarti_cst.userhistory</ENTRY> <ENTRY timestamp='21:09:32'>SELECT t1.*
FROM userhistory t1
WHERE t1.userhistoryId = (SELECT MAX(t2.userhistoryId)
 FROM userhistory t2
 WHERE t2.userId = t1.userId)</ENTRY> <ENTRY timestamp='22:49:39'>SELECT t1.*
FROM userhistory t1
WHERE t1.userhistoryId = (SELECT t2.userhistoryId
 FROM userhistory t2
 WHERE t2.userId = t1.userId
 order by t2.userhistoryId desc
 limit 1
 )</ENTRY> <ENTRY timestamp='22:51:24'>SELECT COUNT(*) FROM userhistory</ENTRY> <ENTRY timestamp='22:52:58'>SELECT userhistoryId.userId, userhistory.userhistoryId, userhistoryId.userAccessTime
FROM userhistory
WHERE t1.userhistoryId = (SELECT t2.userhistoryId
 FROM userhistory t2
 WHERE t2.userId = userhistory.userId
 order by t2.userhistoryId desc
 limit 1
 )</ENTRY> <ENTRY timestamp='22:53:15'>SELECT userhistory.userId, userhistory.userhistoryId, userhistory.userAccessTime
FROM userhistory
WHERE t1.userhistoryId = (SELECT t2.userhistoryId
 FROM userhistory t2
 WHERE t2.userId = userhistory.userId
 order by t2.userhistoryId desc
 limit 1
 )</ENTRY> <ENTRY timestamp='22:53:49'>~</ENTRY> <ENTRY timestamp='22:54:08'>SELECT t1.userId, t1.userhistoryId, t1.userAccessTime
FROM userhistory t1
WHERE t1.userhistoryId = (SELECT t2.userhistoryId
 FROM userhistory t2
 WHERE t2.userId = t1.userId
 order by t2.userhistoryId desc
 limit 1
 )</ENTRY> <ENTRY timestamp='23:07:20'>SELECT * 
FROM jimmarti_cst.userhistory
WHERE userAccessTime < '2008'</ENTRY> <ENTRY timestamp='23:08:10'>DELETE 
FROM jimmarti_cst.userhistory
WHERE userAccessTime < '2008'</ENTRY> <ENTRY timestamp='23:08:21'>SELECT COUNT(*) FROM userhistory</ENTRY> <ENTRY timestamp='23:09:54'>SELECT SUBSTRING(userAccessTime,0,4)
#delete 
FROM jimmarti_cst.userhistory
WHERE SUBSTRING(userAccessTime,0,4) < '2008'</ENTRY> <ENTRY timestamp='23:10:26'>SELECT SUBSTRING(userAccessTime,1,4)
#delete 
FROM jimmarti_cst.userhistory
WHERE SUBSTRING(userAccessTime,1,4) < '2008'</ENTRY> <ENTRY timestamp='23:10:44'>delete 
FROM jimmarti_cst.userhistory
WHERE SUBSTRING(userAccessTime,1,4) < '2008'</ENTRY> <ENTRY timestamp='23:10:50'>SELECT COUNT(*) FROM userhistory</ENTRY> <ENTRY timestamp='23:11:14'>delete 
FROM jimmarti_cst.userhistory
WHERE SUBSTRING(userAccessTime,1,4) < '2010'</ENTRY> <ENTRY timestamp='23:11:21'>SELECT COUNT(*) FROM userhistory</ENTRY> <ENTRY timestamp='23:11:35'>SELECT t1.userId, t1.userhistoryId, t1.userAccessTime
FROM userhistory t1
WHERE t1.userhistoryId = (SELECT t2.userhistoryId
 FROM userhistory t2
 WHERE t2.userId = t1.userId
 order by t2.userhistoryId desc
 limit 1
 )</ENTRY> <ENTRY timestamp='23:41:54'>SELECT t1.userId, t1.userhistoryId, t1.userAccessTime
FROM userhistory t1
WHERE t1.userhistoryId = (SELECT t2.userhistoryId
 FROM userhistory t2
 WHERE t2.userId = t1.userId
 order by t2.userhistoryId desc
 limit 1
 )
ORDER BY t1.userId</ENTRY> <ENTRY timestamp='00:07:54'>DELETE
 FROM userhistory
 WHERE userhistoryId NOT IN (
	SELECT t1.userhistoryId
	FROM userhistory t1
	WHERE t1.userhistoryId = (
				 SELECT t2.userhistoryId
					 FROM userhistory t2
					 WHERE t2.userId = t1.userId
				 ORDER BY t2.userhistoryId desc
					 LIMIT 1
					 )
	ORDER BY t1.userId
)</ENTRY> <ENTRY timestamp='00:15:16'>SELECT COUNT(*) FROM userhistory</ENTRY> <ENTRY timestamp='00:17:54'>SELECT t1.userhistoryId
FROM userhistory t1
WHERE t1.userhistoryId = (SELECT t2.userhistoryId
 FROM userhistory t2
 WHERE t2.userId = t1.userId
 order by t2.userhistoryId desc
 limit 1
 )
ORDER BY t1.userId</ENTRY> <ENTRY timestamp='00:47:05'>DELETE
 FROM userhistory
 WHERE userhistoryId NOT IN (
	190110, 120783, 136771, 185988, 119605, 146316, 140455, 131833, 125726, 126301, 113037, 123859, 112782, 125426, 142281, 153118, 125836, 127105, 122709, 135659, 109774, 112851, 131311, 123906, 117062, 128200, 114583, 126100, 136531, 189713, 126302, 111876, 146284, 177646, 128516, 120634, 114140, 135242, 131585, 110660, 131556, 126271, 142629, 123447, 123847, 123893, 113988, 114860, 120835, 125398, 139768, 114994, 120812, 120651, 107745, 111577, 122043, 189811, 121350, 142023, 141295, 123391, 123951, 123347, 136032, 129279, 112195, 121245, 123884, 123675, 132589, 132251, 130258, 114062, 123901, 122464, 137227, 109700, 111843, 120707, 123699, 123249, 139966, 120479, 132254, 113282, 123546, 132255, 132204, 123686, 126901, 132261, 115892, 120804, 112670, 113233, 139888, 150445, 123950, 120418, 163449, 119321, 122702, 123554, 110242, 114563, 123980, 180501, 132257, 123392, 123622, 109086, 123849, 123930, 133479, 122358, 113787, 120969, 123339, 124260, 109444, 115879, 120448, 113871, 129956, 146062, 132258, 152661, 123316, 111349, 112145, 137706, 109600, 113459, 132278, 121066, 120800, 113070, 113827, 109153, 128273, 141752, 112146, 131731, 137982, 120993, 132200, 117243, 108664, 180454, 120807, 139773, 109420, 113939, 110460, 122225, 114373, 116355, 114618, 126013, 114750, 124498, 115128, 125392, 182203, 123246, 120509, 119797, 136150, 131966, 128545, 136138, 127073, 126783, 121411, 138661, 123846, 132234, 132102, 132253, 125370, 136155, 120106, 126826, 132331, 137447, 136855, 132208, 120081, 119863, 126644, 119440, 136066, 144492, 144710, 118626, 123702, 123813, 117439, 121371, 130278, 162706, 118718, 120412, 140814, 126927, 118415, 116750, 142969, 117594, 132177, 122851, 120623, 123529, 117441, 120486, 117592, 119395, 118981, 118748, 118753, 121913, 119895, 119740, 120586, 171576, 120928, 121227, 164826, 133745, 132184, 152226, 136139, 123647, 121591, 122470, 122713, 122094, 136091, 123824, 152679, 138204, 123750, 123810, 146240, 139923, 121670, 123678, 121807, 121809, 124838, 121811, 123812, 122344, 123842, 123856, 123229, 123312, 132073, 139588, 146367, 126990, 135937, 125252, 145422, 134773, 127114, 139872, 139906, 132181, 129515, 137662, 124796, 142818, 147678, 140029, 139756, 132064, 126841, 140220, 125663, 134286, 132164, 136220, 124793, 124187, 124188, 132198, 126952, 131261, 126261, 127016, 125838, 131978, 141178, 124784, 125353, 135889, 136099, 139266, 139914, 125894, 146247, 140044, 139755, 139857, 146350, 131950, 134041, 135655, 142957, 129137, 136536, 128619, 139915, 139230, 132106, 139187, 128917, 138439, 139593, 132203, 136582, 127914, 139939, 139722, 131984, 131992, 140263, 130602, 131109, 139922, 132057, 136810, 132124, 132059, 139799, 139769, 128043, 140960, 128281, 130620, 130680, 130861, 153412, 140503, 139910, 135901, 139781, 149982, 140790, 132328, 142557, 139795, 132368, 146387, 139676, 132351, 142981, 139936, 146226, 139705, 134047, 139760, 134454, 133861, 133669, 140035, 135941, 139904, 146322, 147756, 139962, 170335, 143010, 146157, 133305, 132741, 133389, 137740, 136359, 139815, 139884, 136534, 138998, 139949, 139693, 136522, 139794, 139947, 139887, 164857, 139600, 138031, 137807, 139901, 140368, 140030, 139931, 139929, 139681, 138747, 136585, 138032, 139610, 137660, 139981, 139984, 139987, 139992, 139993, 139994, 139996, 140001, 140003, 140005, 140006, 140017, 142946, 140021, 156399, 142923, 144506, 143030, 140031, 140037, 148541, 140846, 140053, 140059, 150427, 143239, 152657, 140069, 140070, 159770, 159658, 153127, 141945, 162610, 150486, 156507, 152932, 142524, 140128, 149440, 150424, 142479, 149421, 142423, 156516, 148372, 142801, 140155, 144791, 140168, 146329, 140170, 146365, 142562, 142535, 153016, 153410, 189929, 156208, 140185, 142563, 142955, 140211, 140221, 150056, 140268, 146124, 140303, 153011, 155172, 140352, 141394, 140373, 142932, 146862, 140444, 140437, 189776, 146342, 140545, 150061, 150331, 141909, 142061, 187249, 142839, 146187, 164710, 142967, 147150, 152984, 146056, 164747, 167534, 144864, 145752, 146274, 153478, 143055, 146186, 154549, 143074, 145984, 146239, 143080, 144267, 150393, 156337, 143137, 146681, 156556, 174184, 143178, 145869, 145320, 152448, 146214, 146197, 145193, 146319, 144957, 143475, 146340, 143493, 146249, 144246, 151979, 153842, 144577, 187222, 161643, 144932, 145222, 147694, 145511, 146331, 147190, 164869, 150664, 153901, 153204, 146435, 152682, 156523, 148565, 148720, 152184, 150749, 153176, 167223, 154762, 165087, 153241, 176386, 156583, 185548, 149653, 146473, 147323, 152935, 150872, 146856, 161621, 148656, 156627, 152868, 146541, 152753, 162673, 153097, 156287, 151747, 156715, 171320, 146603, 153304, 157396, 153015, 190055, 152927, 150347, 150322, 150434, 150341, 150291, 151124, 150451, 147843, 163774, 153159, 153456, 161344, 152593, 150538, 156539, 164850, 168054, 170117, 151042, 163972, 152958, 156540, 153028, 150632, 150895, 151772, 152950, 156522, 150782, 150977, 150719, 151912, 152503, 153089, 156586, 160976, 153126, 190005, 154718, 153168, 190068, 164827, 153348, 153208, 164788, 168972, 167061, 160829, 161142, 168365, 153449, 164545, 153352, 171570, 153251, 156428, 163815, 153400, 153270, 171850, 153505, 161910, 161491, 155475, 154135, 166000, 170543, 164184, 157934, 153526, 153519, 153551, 159504, 184578, 161115, 156377, 177637, 156500, 156455, 164760, 168181, 153600, 156687, 153667, 153623, 155384, 162768, 164656, 180632, 171427, 167597, 189957, 190078, 176062, 160775, 161737, 158974, 154076, 155791, 157854, 153870, 168299, 153932, 153967, 153985, 154130, 156574, 184798, 154310, 156352, 165729, 176658, 178113, 171514, 161796, 190032, 157444, 156648, 164848, 159753, 163598, 157339, 156759, 170384, 168402, 171290, 168927, 171459, 156693, 157438, 162373, 164870, 189797, 189598, 157094, 171528, 162743, 157192, 156726, 156742, 171113, 161618, 164847, 175511, 157939, 162561, 156876, 159728, 157014, 159762, 161521, 156820, 171520, 157061, 156868, 164849, 157116, 179364, 171464, 171989, 168315, 157353, 159453, 157088, 165481, 158426, 167071, 168536, 163318, 157305, 157713, 157408, 157300, 161205, 158034, 160221, 161409, 164038, 175945, 176540, 182778, 161735, 180940, 161825, 161627, 176110, 174722, 161495, 170072, 162684, 161499, 161598, 163230, 165686, 163798, 161535, 161541, 164930, 161590, 161593, 161607, 161911, 161647, 162901, 161809, 161719, 161731, 161870, 161742, 176268, 161798, 161824, 171778, 161843, 161905, 163320, 180785, 171479, 180529, 171534, 167932, 180946, 166108, 176057, 166867, 187749, 176210, 164914, 168587, 185264, 171271, 164925, 170129, 164928, 173601, 166668, 175924, 166430, 180844, 164952, 171703, 168385, 184180, 172553, 171406, 180473, 165050, 180353, 185760, 187598, 168530, 168786, 168807, 168682, 168689, 165447, 187676, 168694, 167394, 165032, 165239, 165048, 168377, 176618, 165072, 165074, 184329, 166246, 168363, 165099, 176053, 165103, 171321, 168187, 174770, 168334, 165386, 165162, 180587, 166983, 169957, 165210, 180750, 165261, 180462, 165377, 165383, 165428, 169686, 167429, 186032, 168711, 171302, 168476, 171218, 172027, 169383, 170523, 171624, 171541, 186795, 168549, 168632, 171492, 171653, 171281, 190042, 168888, 171656, 168685, 168687, 171899, 171658, 168726, 180828, 171930, 168748, 180957, 171776, 171926, 168791, 171952, 168878, 169453, 168946, 169018, 171118, 171603, 171659, 171617, 171953, 187677, 176628, 176265, 187547, 189965, 173330, 189397, 187631, 171730, 172738, 186846, 175442, 187613, 187668, 176475, 174974, 176255, 180679, 190031, 179517, 189692, 180393, 176248, 171670, 189676, 184933, 175273, 171682, 180285, 189701, 184588, 190004, 172826, 176155, 187581, 179821, 177706, 187671, 189203, 172570, 171757, 178214, 175463, 171770, 173547, 171786, 189655, 172095, 188748, 176232, 189980, 187497, 171882, 177595, 187606, 189679, 187702, 176254, 172315, 186372, 176156, 172353, 172425, 190044, 176474, 189832, 184603, 177529, 180669, 179471, 177711, 190029, 176444, 176375, 176364, 180311, 185241, 180303, 180128, 180452, 189962, 184878, 180752, 176486, 184427, 190063, 190043, 176553, 180573, 179474, 177075, 176548, 180182, 176557, 180433, 187694, 178798, 177086, 176607, 176630, 176622, 184564, 177496, 179875, 178692, 180221, 190072, 190023, 180486, 181931, 182482, 187706, 180513, 180514, 189866, 189932, 180520, 181871, 190102, 180696, 189642, 189666, 184376, 183053, 183532, 189996, 190027, 184089, 189554, 189788, 190099, 187617, 184624, 189822, 182647, 182592, 189935, 186719, 190101, 180892, 182678, 187239, 180834, 190026, 180594, 190080, 189933, 189627, 189615, 189954, 186487, 190041, 180846, 189977, 185852, 180700, 187272, 189430, 183574, 183940, 184605, 183634, 180977, 180953, 184993, 184583, 181750, 181232, 189686, 187669, 189968, 189924, 187607, 187579, 190109, 185086, 190111, 187478, 187135, 189714, 187632, 184836, 190011, 190077, 187612, 187284, 184958, 185023, 186878, 187375, 190037, 187936, 190030, 190081, 189613, 190097, 188887, 189961, 189709, 188568, 189908, 189621, 188173, 189625, 190039, 188449, 189952, 189574, 189620, 188284, 189610, 189960, 189921, 189710, 188029, 189694, 189856, 190050, 190105, 190015, 190108, 190087, 190024, 189992, 190070, 190058, 190107, 189806, 189995, 190104, 190064, 190094, 190082, 190025, 189767, 190083, 189909, 190003, 190060, 189841, 189823, 189950, 189920, 190093, 189902, 189903, 189904, 189991, 189948, 189956, 190008, 190035, 
)</ENTRY> <ENTRY timestamp='00:47:24'>DELETE
 FROM userhistory
 WHERE userhistoryId NOT IN (
	190110, 120783, 136771, 185988, 119605, 146316, 140455, 131833, 125726, 126301, 113037, 123859, 112782, 125426, 142281, 153118, 125836, 127105, 122709, 135659, 109774, 112851, 131311, 123906, 117062, 128200, 114583, 126100, 136531, 189713, 126302, 111876, 146284, 177646, 128516, 120634, 114140, 135242, 131585, 110660, 131556, 126271, 142629, 123447, 123847, 123893, 113988, 114860, 120835, 125398, 139768, 114994, 120812, 120651, 107745, 111577, 122043, 189811, 121350, 142023, 141295, 123391, 123951, 123347, 136032, 129279, 112195, 121245, 123884, 123675, 132589, 132251, 130258, 114062, 123901, 122464, 137227, 109700, 111843, 120707, 123699, 123249, 139966, 120479, 132254, 113282, 123546, 132255, 132204, 123686, 126901, 132261, 115892, 120804, 112670, 113233, 139888, 150445, 123950, 120418, 163449, 119321, 122702, 123554, 110242, 114563, 123980, 180501, 132257, 123392, 123622, 109086, 123849, 123930, 133479, 122358, 113787, 120969, 123339, 124260, 109444, 115879, 120448, 113871, 129956, 146062, 132258, 152661, 123316, 111349, 112145, 137706, 109600, 113459, 132278, 121066, 120800, 113070, 113827, 109153, 128273, 141752, 112146, 131731, 137982, 120993, 132200, 117243, 108664, 180454, 120807, 139773, 109420, 113939, 110460, 122225, 114373, 116355, 114618, 126013, 114750, 124498, 115128, 125392, 182203, 123246, 120509, 119797, 136150, 131966, 128545, 136138, 127073, 126783, 121411, 138661, 123846, 132234, 132102, 132253, 125370, 136155, 120106, 126826, 132331, 137447, 136855, 132208, 120081, 119863, 126644, 119440, 136066, 144492, 144710, 118626, 123702, 123813, 117439, 121371, 130278, 162706, 118718, 120412, 140814, 126927, 118415, 116750, 142969, 117594, 132177, 122851, 120623, 123529, 117441, 120486, 117592, 119395, 118981, 118748, 118753, 121913, 119895, 119740, 120586, 171576, 120928, 121227, 164826, 133745, 132184, 152226, 136139, 123647, 121591, 122470, 122713, 122094, 136091, 123824, 152679, 138204, 123750, 123810, 146240, 139923, 121670, 123678, 121807, 121809, 124838, 121811, 123812, 122344, 123842, 123856, 123229, 123312, 132073, 139588, 146367, 126990, 135937, 125252, 145422, 134773, 127114, 139872, 139906, 132181, 129515, 137662, 124796, 142818, 147678, 140029, 139756, 132064, 126841, 140220, 125663, 134286, 132164, 136220, 124793, 124187, 124188, 132198, 126952, 131261, 126261, 127016, 125838, 131978, 141178, 124784, 125353, 135889, 136099, 139266, 139914, 125894, 146247, 140044, 139755, 139857, 146350, 131950, 134041, 135655, 142957, 129137, 136536, 128619, 139915, 139230, 132106, 139187, 128917, 138439, 139593, 132203, 136582, 127914, 139939, 139722, 131984, 131992, 140263, 130602, 131109, 139922, 132057, 136810, 132124, 132059, 139799, 139769, 128043, 140960, 128281, 130620, 130680, 130861, 153412, 140503, 139910, 135901, 139781, 149982, 140790, 132328, 142557, 139795, 132368, 146387, 139676, 132351, 142981, 139936, 146226, 139705, 134047, 139760, 134454, 133861, 133669, 140035, 135941, 139904, 146322, 147756, 139962, 170335, 143010, 146157, 133305, 132741, 133389, 137740, 136359, 139815, 139884, 136534, 138998, 139949, 139693, 136522, 139794, 139947, 139887, 164857, 139600, 138031, 137807, 139901, 140368, 140030, 139931, 139929, 139681, 138747, 136585, 138032, 139610, 137660, 139981, 139984, 139987, 139992, 139993, 139994, 139996, 140001, 140003, 140005, 140006, 140017, 142946, 140021, 156399, 142923, 144506, 143030, 140031, 140037, 148541, 140846, 140053, 140059, 150427, 143239, 152657, 140069, 140070, 159770, 159658, 153127, 141945, 162610, 150486, 156507, 152932, 142524, 140128, 149440, 150424, 142479, 149421, 142423, 156516, 148372, 142801, 140155, 144791, 140168, 146329, 140170, 146365, 142562, 142535, 153016, 153410, 189929, 156208, 140185, 142563, 142955, 140211, 140221, 150056, 140268, 146124, 140303, 153011, 155172, 140352, 141394, 140373, 142932, 146862, 140444, 140437, 189776, 146342, 140545, 150061, 150331, 141909, 142061, 187249, 142839, 146187, 164710, 142967, 147150, 152984, 146056, 164747, 167534, 144864, 145752, 146274, 153478, 143055, 146186, 154549, 143074, 145984, 146239, 143080, 144267, 150393, 156337, 143137, 146681, 156556, 174184, 143178, 145869, 145320, 152448, 146214, 146197, 145193, 146319, 144957, 143475, 146340, 143493, 146249, 144246, 151979, 153842, 144577, 187222, 161643, 144932, 145222, 147694, 145511, 146331, 147190, 164869, 150664, 153901, 153204, 146435, 152682, 156523, 148565, 148720, 152184, 150749, 153176, 167223, 154762, 165087, 153241, 176386, 156583, 185548, 149653, 146473, 147323, 152935, 150872, 146856, 161621, 148656, 156627, 152868, 146541, 152753, 162673, 153097, 156287, 151747, 156715, 171320, 146603, 153304, 157396, 153015, 190055, 152927, 150347, 150322, 150434, 150341, 150291, 151124, 150451, 147843, 163774, 153159, 153456, 161344, 152593, 150538, 156539, 164850, 168054, 170117, 151042, 163972, 152958, 156540, 153028, 150632, 150895, 151772, 152950, 156522, 150782, 150977, 150719, 151912, 152503, 153089, 156586, 160976, 153126, 190005, 154718, 153168, 190068, 164827, 153348, 153208, 164788, 168972, 167061, 160829, 161142, 168365, 153449, 164545, 153352, 171570, 153251, 156428, 163815, 153400, 153270, 171850, 153505, 161910, 161491, 155475, 154135, 166000, 170543, 164184, 157934, 153526, 153519, 153551, 159504, 184578, 161115, 156377, 177637, 156500, 156455, 164760, 168181, 153600, 156687, 153667, 153623, 155384, 162768, 164656, 180632, 171427, 167597, 189957, 190078, 176062, 160775, 161737, 158974, 154076, 155791, 157854, 153870, 168299, 153932, 153967, 153985, 154130, 156574, 184798, 154310, 156352, 165729, 176658, 178113, 171514, 161796, 190032, 157444, 156648, 164848, 159753, 163598, 157339, 156759, 170384, 168402, 171290, 168927, 171459, 156693, 157438, 162373, 164870, 189797, 189598, 157094, 171528, 162743, 157192, 156726, 156742, 171113, 161618, 164847, 175511, 157939, 162561, 156876, 159728, 157014, 159762, 161521, 156820, 171520, 157061, 156868, 164849, 157116, 179364, 171464, 171989, 168315, 157353, 159453, 157088, 165481, 158426, 167071, 168536, 163318, 157305, 157713, 157408, 157300, 161205, 158034, 160221, 161409, 164038, 175945, 176540, 182778, 161735, 180940, 161825, 161627, 176110, 174722, 161495, 170072, 162684, 161499, 161598, 163230, 165686, 163798, 161535, 161541, 164930, 161590, 161593, 161607, 161911, 161647, 162901, 161809, 161719, 161731, 161870, 161742, 176268, 161798, 161824, 171778, 161843, 161905, 163320, 180785, 171479, 180529, 171534, 167932, 180946, 166108, 176057, 166867, 187749, 176210, 164914, 168587, 185264, 171271, 164925, 170129, 164928, 173601, 166668, 175924, 166430, 180844, 164952, 171703, 168385, 184180, 172553, 171406, 180473, 165050, 180353, 185760, 187598, 168530, 168786, 168807, 168682, 168689, 165447, 187676, 168694, 167394, 165032, 165239, 165048, 168377, 176618, 165072, 165074, 184329, 166246, 168363, 165099, 176053, 165103, 171321, 168187, 174770, 168334, 165386, 165162, 180587, 166983, 169957, 165210, 180750, 165261, 180462, 165377, 165383, 165428, 169686, 167429, 186032, 168711, 171302, 168476, 171218, 172027, 169383, 170523, 171624, 171541, 186795, 168549, 168632, 171492, 171653, 171281, 190042, 168888, 171656, 168685, 168687, 171899, 171658, 168726, 180828, 171930, 168748, 180957, 171776, 171926, 168791, 171952, 168878, 169453, 168946, 169018, 171118, 171603, 171659, 171617, 171953, 187677, 176628, 176265, 187547, 189965, 173330, 189397, 187631, 171730, 172738, 186846, 175442, 187613, 187668, 176475, 174974, 176255, 180679, 190031, 179517, 189692, 180393, 176248, 171670, 189676, 184933, 175273, 171682, 180285, 189701, 184588, 190004, 172826, 176155, 187581, 179821, 177706, 187671, 189203, 172570, 171757, 178214, 175463, 171770, 173547, 171786, 189655, 172095, 188748, 176232, 189980, 187497, 171882, 177595, 187606, 189679, 187702, 176254, 172315, 186372, 176156, 172353, 172425, 190044, 176474, 189832, 184603, 177529, 180669, 179471, 177711, 190029, 176444, 176375, 176364, 180311, 185241, 180303, 180128, 180452, 189962, 184878, 180752, 176486, 184427, 190063, 190043, 176553, 180573, 179474, 177075, 176548, 180182, 176557, 180433, 187694, 178798, 177086, 176607, 176630, 176622, 184564, 177496, 179875, 178692, 180221, 190072, 190023, 180486, 181931, 182482, 187706, 180513, 180514, 189866, 189932, 180520, 181871, 190102, 180696, 189642, 189666, 184376, 183053, 183532, 189996, 190027, 184089, 189554, 189788, 190099, 187617, 184624, 189822, 182647, 182592, 189935, 186719, 190101, 180892, 182678, 187239, 180834, 190026, 180594, 190080, 189933, 189627, 189615, 189954, 186487, 190041, 180846, 189977, 185852, 180700, 187272, 189430, 183574, 183940, 184605, 183634, 180977, 180953, 184993, 184583, 181750, 181232, 189686, 187669, 189968, 189924, 187607, 187579, 190109, 185086, 190111, 187478, 187135, 189714, 187632, 184836, 190011, 190077, 187612, 187284, 184958, 185023, 186878, 187375, 190037, 187936, 190030, 190081, 189613, 190097, 188887, 189961, 189709, 188568, 189908, 189621, 188173, 189625, 190039, 188449, 189952, 189574, 189620, 188284, 189610, 189960, 189921, 189710, 188029, 189694, 189856, 190050, 190105, 190015, 190108, 190087, 190024, 189992, 190070, 190058, 190107, 189806, 189995, 190104, 190064, 190094, 190082, 190025, 189767, 190083, 189909, 190003, 190060, 189841, 189823, 189950, 189920, 190093, 189902, 189903, 189904, 189991, 189948, 189956, 190008, 190035 
)</ENTRY> <ENTRY timestamp='00:47:30'>SELECT COUNT(*) FROM userhistory</ENTRY> <ENTRY timestamp='00:48:04'>SELECT t1.userhistoryId
FROM userhistory t1
WHERE t1.userhistoryId = (SELECT t2.userhistoryId
 FROM userhistory t2
 WHERE t2.userId = t1.userId
 order by t2.userhistoryId desc
 limit 1
 )
ORDER BY t1.userId</ENTRY> <ENTRY timestamp='23:46:24'>SET @ULN = 'Hagen'</ENTRY> <ENTRY timestamp='~'>SELECT user.*

















, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userLastName like @ULN
ORDER By userLastName, userFirstName
 LIMIT 2000</ENTRY> <ENTRY timestamp='23:47:08'>SET @ULN = 'Martinson'</ENTRY> <ENTRY timestamp='~'>SELECT user.*

















, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userLastName like @ULN
ORDER By userLastName, userFirstName
 LIMIT 2000</ENTRY> <ENTRY timestamp='23:47:25'>SET @ULN = 'Kramer'</ENTRY> <ENTRY timestamp='~'>SELECT user.*

















, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userLastName like @ULN
ORDER By userLastName, userFirstName
 LIMIT 2000</ENTRY> <ENTRY timestamp='23:56:07'>SET @ULN = 'Reierson'</ENTRY> <ENTRY timestamp='~'>SELECT user.*

















, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userLastName like @ULN
ORDER By userLastName, userFirstName
 LIMIT 2000</ENTRY> <ENTRY timestamp='~'>SELECT user.*

















, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userLastName like @ULN
ORDER By userLastName, userFirstName
 LIMIT 2000</ENTRY> <ENTRY timestamp='00:01:31'>SET @UFN = ''</ENTRY> <ENTRY timestamp='~'>SELECT user.*



























, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userFirstName like @UFN
ORDER BY userFirstName, userLastName
 LIMIT 2000</ENTRY> <ENTRY timestamp='00:01:53'>SET @UFN = 'xxx'</ENTRY> <ENTRY timestamp='~'>SELECT user.*



























, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userFirstName like @UFN
ORDER BY userFirstName, userLastName
 LIMIT 2000</ENTRY> <ENTRY timestamp='00:29:20'>ALTER TABLE `jimmarti_cst`.`user` 
DROP COLUMN `userData`,
CHANGE COLUMN `userDataFolder` `userDataFolder` VARCHAR(64) NULL DEFAULT NULL AFTER `userDefaultDrive`</ENTRY> <ENTRY timestamp='01:07:05'>SELECT * FROM jimmarti_cst.user</ENTRY> <ENTRY timestamp='01:28:07'>~</ENTRY> <ENTRY timestamp='01:38:59'>~</ENTRY> <ENTRY timestamp='01:56:59'>~</ENTRY> <ENTRY timestamp='01:58:44'>~</ENTRY> <ENTRY timestamp='02:05:23'>~</ENTRY> <ENTRY timestamp='02:05:38'>~</ENTRY> <ENTRY timestamp='02:12:46'>~</ENTRY> <ENTRY timestamp='02:13:27'>~</ENTRY> <ENTRY timestamp='02:18:44'>~</ENTRY> <ENTRY timestamp='02:19:40'>SELECT userFirstName, userLastName, userDefaultDrive, userDataFolder FROM jimmarti_cst.user</ENTRY> <ENTRY timestamp='02:26:41'>~</ENTRY> <ENTRY timestamp='02:26:49'>~</ENTRY> <ENTRY timestamp='02:27:00'>~</ENTRY> <ENTRY timestamp='02:38:43'>~</ENTRY> <ENTRY timestamp='02:39:50'>~</ENTRY> <ENTRY timestamp='02:40:09'>~</ENTRY> <ENTRY timestamp='02:40:19'>~</ENTRY> <ENTRY timestamp='02:45:06'>~</ENTRY> <ENTRY timestamp='02:45:36'>~</ENTRY> <ENTRY timestamp='02:46:15'>~</ENTRY> <ENTRY timestamp='02:46:17'>~</ENTRY> <ENTRY timestamp='~'>~</ENTRY> <ENTRY timestamp='~'>~</ENTRY> <ENTRY timestamp='02:46:18'>~</ENTRY> <ENTRY timestamp='~'>~</ENTRY> <ENTRY timestamp='~'>~</ENTRY> <ENTRY timestamp='02:52:53'>~</ENTRY> <ENTRY timestamp='02:53:36'>~</ENTRY> <ENTRY timestamp='02:57:06'>~</ENTRY> <ENTRY timestamp='02:57:20'>~</ENTRY> <ENTRY timestamp='02:57:25'>~</ENTRY> <ENTRY timestamp='03:03:38'>~</ENTRY> <ENTRY timestamp='03:07:22'>~</ENTRY> <ENTRY timestamp='03:07:31'>~</ENTRY> <ENTRY timestamp='03:08:01'>~</ENTRY> <ENTRY timestamp='03:08:14'>~</ENTRY> <ENTRY timestamp='03:08:15'>~</ENTRY> <ENTRY timestamp='~'>~</ENTRY> <ENTRY timestamp='~'>~</ENTRY> <ENTRY timestamp='03:08:39'>~</ENTRY> <ENTRY timestamp='03:09:23'>~</ENTRY> <ENTRY timestamp='03:18:34'>~</ENTRY> <ENTRY timestamp='03:18:41'>~</ENTRY> <ENTRY timestamp='03:18:49'>~</ENTRY> <ENTRY timestamp='03:19:25'>~</ENTRY> <ENTRY timestamp='03:19:30'>~</ENTRY> <ENTRY timestamp='03:19:52'>~</ENTRY> <ENTRY timestamp='03:23:33'>~</ENTRY> <ENTRY timestamp='03:23:40'>~</ENTRY> <ENTRY timestamp='03:23:52'>~</ENTRY> <ENTRY timestamp='03:28:13'>~</ENTRY> <ENTRY timestamp='03:28:24'>~</ENTRY> <ENTRY timestamp='03:28:36'>~</ENTRY> <ENTRY timestamp='03:28:49'>~</ENTRY> <ENTRY timestamp='03:29:04'>~</ENTRY> <ENTRY timestamp='03:31:11'>~</ENTRY> <ENTRY timestamp='03:31:30'>~</ENTRY> <ENTRY timestamp='03:31:45'>~</ENTRY> <ENTRY timestamp='03:31:47'>~</ENTRY> <ENTRY timestamp='~'>~</ENTRY> <ENTRY timestamp='~'>~</ENTRY> <ENTRY timestamp='03:34:16'>~</ENTRY> <ENTRY timestamp='03:34:21'>~</ENTRY> <ENTRY timestamp='03:34:33'>~</ENTRY> <ENTRY timestamp='03:35:00'>~</ENTRY> <ENTRY timestamp='03:35:12'>~</ENTRY> <ENTRY timestamp='03:36:08'>~</ENTRY> <ENTRY timestamp='03:36:26'>~</ENTRY> <ENTRY timestamp='03:39:00'>~</ENTRY> <ENTRY timestamp='03:39:06'>~</ENTRY> <ENTRY timestamp='03:40:04'>~</ENTRY> <ENTRY timestamp='03:40:13'>~</ENTRY> <ENTRY timestamp='03:40:23'>~</ENTRY> <ENTRY timestamp='03:40:31'>~</ENTRY> <ENTRY timestamp='03:40:44'>~</ENTRY> <ENTRY timestamp='03:41:04'>~</ENTRY> <ENTRY timestamp='03:41:15'>~</ENTRY> <ENTRY timestamp='03:41:20'>~</ENTRY> <ENTRY timestamp='03:42:01'>~</ENTRY> <ENTRY timestamp='03:42:08'>~</ENTRY> <ENTRY timestamp='03:42:14'>~</ENTRY> <ENTRY timestamp='03:42:23'>~</ENTRY> <ENTRY timestamp='03:42:30'>~</ENTRY> <ENTRY timestamp='03:42:42'>~</ENTRY> <ENTRY timestamp='03:42:48'>~</ENTRY> <ENTRY timestamp='03:42:53'>~</ENTRY> <ENTRY timestamp='03:43:08'>~</ENTRY> <ENTRY timestamp='03:43:13'>~</ENTRY> <ENTRY timestamp='03:43:18'>~</ENTRY> <ENTRY timestamp='03:43:24'>~</ENTRY> <ENTRY timestamp='03:43:43'>~</ENTRY> <ENTRY timestamp='05:24:41'>~</ENTRY> <ENTRY timestamp='05:27:24'>~</ENTRY> <ENTRY timestamp='11:07:37'>~</ENTRY> <ENTRY timestamp='11:07:47'>SET @UFN = 'xxx'</ENTRY> <ENTRY timestamp='~'>SELECT user.*



























, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userFirstName like @UFN
ORDER BY userFirstName, userLastName
 LIMIT 2000</ENTRY> <ENTRY timestamp='11:07:58'>SET @ULN = 'xxx'</ENTRY> <ENTRY timestamp='~'>SELECT user.*

















, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userLastName like @ULN
ORDER By userLastName, userFirstName
 LIMIT 2000</ENTRY> <ENTRY timestamp='11:08:07'>SET @search = '8490'</ENTRY> <ENTRY timestamp='~'>SELECT DISTINCT
 user.userId,
 userUsername,
 user.userStudentId,
 userFirstName,
 userMiddleName,
 userLastName,
 userNickname,
 userDN,
 userEmail,
 userImage,
 userIsInactive,
 userIsStudent,
 userIsAlumni,
 userComments,
 userDefaultDrive,
 userLoggedIn,
 userLoginCount,
 userAccessTime,
 userIPAddress,
 userIPDecimal,
 userPHPSESSID,
 userAdvisor,
 userClassification,
 userMajor,

 IF (user.userStudentId = @search, 50,
 IF (user.userStudentId LIKE CONCAT('%',@search), 25,
 IF (user.userStudentId LIKE CONCAT('%',@search,'%'), 12, 0 ) ) )
 +
 
 0 AS score
 FROM `user`
 LEFT JOIN `userdata` ON user.userStudentId = userdata.userStudentId
 LEFT JOIN `studentprofile` ON studentprofile.userId = user.userId
 WHERE (
 1=0

 OR userFirstName LIKE CONCAT('%',@search,'%')
 OR userNickname LIKE CONCAT('%',@search,'%')
 OR userMiddleName LIKE CONCAT('%',@search,'%')
 OR userLastName LIKE CONCAT('%',@search,'%')
 OR user.userStudentId LIKE CONCAT('%',@search,'%')
 OR studentprofile.studentprofileEmail1 LIKE CONCAT('%',@search,'%')
 OR studentprofile.studentprofileEmail2 LIKE CONCAT('%',@search,'%')
 OR studentprofile.studentprofilePhone1 LIKE CONCAT('%',@search,'%')
 OR studentprofile.studentprofilePhone2 LIKE CONCAT('%',@search,'%')
 
 )
 ORDER BY score DESC, userLastName, userFirstName, userMiddleName</ENTRY> <ENTRY timestamp='22:03:26'>INSERT INTO `jimmarti_cst`.`userpermission` (`userpermissionName`, `userpermissionInactive`, `modifiedBy`) VALUES ('TUTOR', '0', '1')</ENTRY> <ENTRY timestamp='~'>UPDATE `jimmarti_cst`.`userpermission` SET `userpermissionInactive`='1' WHERE `userpermissionId`='0'</ENTRY> <ENTRY timestamp='22:04:09'>INSERT INTO `jimmarti_cst`.`userpermission` (`userpermissionId`, `userpermissionName`, `userpermissionInactive`, `modifiedBy`) VALUES ('4', 'TUTOR', '0', '1')</ENTRY> <ENTRY timestamp='~'>UPDATE `jimmarti_cst`.`userpermission` SET `userpermissionInactive`='1' WHERE `userpermissionId`='0'</ENTRY> <ENTRY timestamp='22:04:32'>SET @ULN = 'Olson'</ENTRY> <ENTRY timestamp='~'>SELECT user.*

















, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userLastName like @ULN
ORDER By userLastName, userFirstName
 LIMIT 2000</ENTRY> <ENTRY timestamp='22:04:58'>SELECT * FROM jimmarti_cst.useruserpermission</ENTRY> <ENTRY timestamp='22:05:31'>INSERT INTO `jimmarti_cst`.`useruserpermission` (`userId`, `userpermissionId`, `modifiedBy`) VALUES ('759', '2', '1')</ENTRY> <ENTRY timestamp='~'>SELECT user.*

















, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userLastName like @ULN
ORDER By userLastName, userFirstName
 LIMIT 2000</ENTRY> <ENTRY timestamp='13:20:20'>SET @ULN = 'Nelsen'</ENTRY> <ENTRY timestamp='~'>SELECT user.*

















, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userLastName like @ULN
ORDER By userLastName, userFirstName
 LIMIT 2000</ENTRY> <ENTRY timestamp='13:23:22'>update `user`
set userPasswordMD5 = null
where userId = 1324</ENTRY> <ENTRY timestamp='13:23:25'>SET @ULN = 'Nelsen'</ENTRY> <ENTRY timestamp='~'>SELECT user.*

















, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userLastName like @ULN
ORDER By userLastName, userFirstName
 LIMIT 2000</ENTRY> <ENTRY timestamp='13:28:33'>SET @ULN = 'Nelsen'</ENTRY> <ENTRY timestamp='~'>SELECT user.*

















, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userLastName like @ULN
ORDER By userLastName, userFirstName
 LIMIT 2000</ENTRY> <ENTRY timestamp='22:56:35'>~</ENTRY> <ENTRY timestamp='22:57:07'>DELETE FROM `jimmarti_cst`.`session` WHERE `sessionId`='285'</ENTRY> <ENTRY timestamp='~'>DELETE FROM `jimmarti_cst`.`session` WHERE `sessionId`='286'</ENTRY> <ENTRY timestamp='~'>DELETE FROM `jimmarti_cst`.`session` WHERE `sessionId`='287'</ENTRY> <ENTRY timestamp='~'>DELETE FROM `jimmarti_cst`.`session` WHERE `sessionId`='288'</ENTRY> <ENTRY timestamp='~'>DELETE FROM `jimmarti_cst`.`session` WHERE `sessionId`='289'</ENTRY> <ENTRY timestamp='22:57:11'>SELECT * FROM jimmarti_cst.session</ENTRY> <ENTRY timestamp='22:57:36'>~</ENTRY> <ENTRY timestamp='22:59:09'>~</ENTRY> <ENTRY timestamp='22:59:28'>~</ENTRY> <ENTRY timestamp='23:00:47'>~</ENTRY> <ENTRY timestamp='16:25:48'>SELECT * FROM jimmarti_cst.user
where userLastName = 'Hyberger'</ENTRY> <ENTRY timestamp='16:27:11'>SELECT * FROM jimmarti_cst.userpermission</ENTRY> <ENTRY timestamp='16:27:34'>SELECT * FROM jimmarti_cst.useruserpermission</ENTRY> <ENTRY timestamp='16:28:45'>INSERT INTO `jimmarti_cst`.`useruserpermission` (`userId`, `userpermissionId`) VALUES ('12', '2')</ENTRY> <ENTRY timestamp='16:30:23'>SELECT * FROM jimmarti_cst.session</ENTRY> <ENTRY timestamp='16:31:49'>select *
#delete
from session
where sessionStart is null</ENTRY> <ENTRY timestamp='16:32:16'>select *
#delete
from session
where sessionStart is not null</ENTRY> <ENTRY timestamp='16:32:58'>delete
from session
where sessionStart is null</ENTRY> <ENTRY timestamp='16:33:06'>SELECT * FROM jimmarti_cst.session</ENTRY> <ENTRY timestamp='16:34:09'>ALTER TABLE `jimmarti_cst`.`session` 
AUTO_INCREMENT = 300</ENTRY> <ENTRY timestamp='17:04:21'>SELECT * FROM jimmarti_cst.user
where UserUsername = 'kw2732rl'</ENTRY> <ENTRY timestamp='17:04:45'>UPDATE `jimmarti_cst`.`user` SET `userLastName`='O\'Neil' WHERE `userId`='1426'</ENTRY> <ENTRY timestamp='17:05:40'>SELECT * FROM jimmarti_cst.user
#where UserUsername = 'kw2732rl'</ENTRY> <ENTRY timestamp='12:09:26'>show grants for cst_backup@localhost</ENTRY> <ENTRY timestamp='12:10:59'>show grants for backup@localhost</ENTRY> <ENTRY timestamp='12:11:49'>~</ENTRY> <ENTRY timestamp='12:12:33'>show grants for backup@%</ENTRY> <ENTRY timestamp='12:12:36'>~</ENTRY> <ENTRY timestamp='12:12:48'>show grants for backup@'%'</ENTRY> <ENTRY timestamp='12:14:08'>~</ENTRY> <ENTRY timestamp='12:15:47'>grant selecton mysql.proc to backup@'%'</ENTRY> <ENTRY timestamp='12:16:24'>GRANT SELECT mysql.proc to 'backup'@'%'</ENTRY> <ENTRY timestamp='12:16:27'>~</ENTRY> <ENTRY timestamp='12:16:43'>GRANT SELECT ON mysql.proc TO 'backup'@'%'</ENTRY> <ENTRY timestamp='12:19:05'>show grants for 'testuser'@'localhsot'</ENTRY> <ENTRY timestamp='12:19:49'>show grants for 'testuser'@'localhost'</ENTRY> <ENTRY timestamp='12:29:26'>GRANT SELECT, SHOW VIEW, RELOAD, EVENT, TRIGGER, LOCK TABLES ON jimmarti_cst TO 'cst_backup'@'localhost'</ENTRY> <ENTRY timestamp='12:30:06'>GRANT SELECT, SHOW VIEW, EVENT, TRIGGER, LOCK TABLES ON jimmarti_cst TO 'cst_backup'@'localhost'</ENTRY> <ENTRY timestamp='12:30:09'>~</ENTRY> <ENTRY timestamp='12:30:17'>~</ENTRY> <ENTRY timestamp='12:30:33'>GRANT SELECT, SHOW VIEW, TRIGGER, LOCK TABLES ON jimmarti_cst TO 'cst_backup'@'localhost'</ENTRY> <ENTRY timestamp='12:31:04'>GRANT SELECT, SHOW VIEW, TRIGGER, LOCK TABLES ON `jimmarti_cst` TO 'cst_backup'@'localhost'</ENTRY> <ENTRY timestamp='12:31:27'>GRANT SELECT, SHOW VIEW, TRIGGER, LOCK TABLES ON `jimmarti_cst`.* TO 'cst_backup'@'localhost'</ENTRY> <ENTRY timestamp='12:31:39'>GRANT SELECT, SHOW VIEW, RELOAD, REPLICATION CLIENT, EVENT, TRIGGER, LOCK TABLES ON jimmarti_cst.* TO 'cst_backup'@'localhost'</ENTRY> <ENTRY timestamp='12:31:57'>GRANT SELECT, SHOW VIEW, EVENT, TRIGGER, LOCK TABLES ON jimmarti_cst.* TO 'cst_backup'@'localhost'</ENTRY> <ENTRY timestamp='09:06:11'>SELECT *
 FROM `user`
 WHERE userLastName = 'Martinson'
 ORDER BY userFirstName, userLastName</ENTRY> <ENTRY timestamp='09:06:32'>UPDATE `jimmarti_cst`.`user` SET `userFirstName`='James' WHERE `userId`='1'</ENTRY> <ENTRY timestamp='13:23:30'>SELECT * FROM jimmarti_cst.course</ENTRY> <ENTRY timestamp='12:19:21'>SELECT count(*) FROM jimmarti_cst.userhistory</ENTRY> <ENTRY timestamp='17:24:12'>SET @ULN = 'Hyberger'</ENTRY> <ENTRY timestamp='~'>SELECT user.*

















, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userLastName like @ULN
ORDER By userLastName, userFirstName
 LIMIT 2000</ENTRY> <ENTRY timestamp='17:25:32'>SELECT * FROM jimmarti_cst.userpermission</ENTRY> <ENTRY timestamp='17:25:41'>SELECT * FROM jimmarti_cst.useruserpermission</ENTRY> <ENTRY timestamp='17:30:57'>SELECT userUsername, userFirstName, userLastName
 , userpermission.userpermissionId, userpermission.userpermissionName
FROM `user`
JOIN useruserpermission ON useruserpermission.userId = user.userId
JOIN userpermission ON userpermission.userpermissionId = useruserpermission.userpermissionId</ENTRY> <ENTRY timestamp='17:32:19'>SELECT * FROM jimmarti_cst.userpermission</ENTRY> <ENTRY timestamp='17:32:32'>SELECT * FROM jimmarti_cst.useruserpermission</ENTRY> <ENTRY timestamp='17:32:54'>DELETE FROM `jimmarti_cst`.`useruserpermission` WHERE `userId`='12' and`userpermissionId`='2'</ENTRY> <ENTRY timestamp='17:32:58'>SELECT userUsername, userFirstName, userLastName
 , userpermission.userpermissionId, userpermission.userpermissionName
FROM `user`
JOIN useruserpermission ON useruserpermission.userId = user.userId
JOIN userpermission ON userpermission.userpermissionId = useruserpermission.userpermissionId</ENTRY> <ENTRY timestamp='17:34:21'>SELECT count(*) FROM jimmarti_cst.userhistory</ENTRY> <ENTRY timestamp='12:32:26'>SELECT userEmail
FROM `user`
WHERE userStudentId = '15452678'</ENTRY> <ENTRY timestamp='11:01:45'>SELECT * FROM jimmarti_cst.calendarschool where schoolDate like '2023'</ENTRY> <ENTRY timestamp='11:01:54'>SELECT * FROM jimmarti_cst.calendarschool where schoolDate like '2023%'</ENTRY> <ENTRY timestamp='11:02:13'>UPDATE `jimmarti_cst`.`calendarschool` SET `schoolNote`='President\'s Day Holiday' WHERE `schoolId`='150'</ENTRY> <ENTRY timestamp='11:06:34'>SELECT * FROM jimmarti_cst.calendarschool where schoolDate like '2023%'</ENTRY> <ENTRY timestamp='11:06:46'>SELECT * FROM jimmarti_cst.calendarschool where schoolDate like '2022%'</ENTRY> <ENTRY timestamp='11:07:07'>UPDATE `jimmarti_cst`.`calendarschool` SET `schoolNote`='Presiden`s Day Holiday' WHERE `schoolId`='136'</ENTRY> <ENTRY timestamp='11:07:20'>SELECT * FROM jimmarti_cst.calendarschool where schoolDate like '2023%'</ENTRY> <ENTRY timestamp='11:14:59'>SELECT * FROM jimmarti_cst.session</ENTRY> <ENTRY timestamp='10:57:53'>SELECT * FROM jimmarti_cst.user
where userId = 1619</ENTRY> <ENTRY timestamp='10:58:18'>SELECT * FROM jimmarti_cst.user
where userId = 1618</ENTRY> <ENTRY timestamp='11:00:41'>SET @ULN = 'Marcus'</ENTRY> <ENTRY timestamp='~'>SELECT user.*
userpermission
















, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userLastName like @ULN
ORDER By userLastName, userFirstName
 LIMIT 2000</ENTRY> <ENTRY timestamp='11:01:10'>SET @ULN = 'Marcus'</ENTRY> <ENTRY timestamp='~'>SELECT user.*
















, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userLastName like @ULN
ORDER By userLastName, userFirstName
 LIMIT 2000</ENTRY> <ENTRY timestamp='11:46:21'>SELECT * FROM jimmarti_cst.calendarschool where schoolDate like '2023%'</ENTRY> <ENTRY timestamp='07:07:59'>SET @UFN = 'James'</ENTRY> <ENTRY timestamp='~'>SELECT user.*



























, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userFirstName like @UFN
ORDER BY userFirstName, userLastName
 LIMIT 2000</ENTRY> <ENTRY timestamp='07:08:46'>USE jimmarti_cst</ENTRY> <ENTRY timestamp='~'>SET @UFN = 'James'</ENTRY> <ENTRY timestamp='~'>SELECT user.*



























, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userFirstName like @UFN
ORDER BY userFirstName, userLastName
 LIMIT 2000</ENTRY> <ENTRY timestamp='07:09:40'>, userId</ENTRY> <ENTRY timestamp='07:09:43'>USE jimmarti_cst</ENTRY> <ENTRY timestamp='~'>SET @UFN = 'James'</ENTRY> <ENTRY timestamp='~'>SELECT user.*



























, CAST(FROM_BASE64(userPasswordMD5) as char) AS pw
 FROM `user`
 WHERE userFirstName like @UFN
ORDER BY userFirstName, userLastName, userId
 LIMIT 2000</ENTRY> <ENTRY timestamp='07:18:28'>SELECT * FROM scheduler.user</ENTRY> <ENTRY timestamp='07:19:57'>UPDATE `scheduler`.`user` SET `userPassword`='' WHERE `userId`='1'</ENTRY> <ENTRY timestamp='17:32:56'>SELECT * FROM jimmarti_cst.user</ENTRY> <ENTRY timestamp='17:33:29'>SELECT * FROM jimmarti_cst.user
where userLastName LIKE '%Ludwig'</ENTRY> <ENTRY timestamp='17:33:54'>SELECT * FROM jimmarti_cst.studentprofile
where userId = 1599</ENTRY> <ENTRY timestamp='17:35:40'>UPDATE `jimmarti_cst`.`studentprofile` SET `lastModified`='2023-01-09 14:55:57' WHERE `studentprofileId`='1242'</ENTRY> <ENTRY timestamp='17:41:26'>UPDATE `jimmarti_cst`.`studentprofile` SET `lastModified`='2023-01-08 14:55:57' WHERE `studentprofileId`='1242'</ENTRY> <ENTRY timestamp='17:59:25'>DELETE FROM `jimmarti_cst`.`class` WHERE `classId`='1259'</ENTRY> <ENTRY timestamp='~'>DELETE FROM `jimmarti_cst`.`class` WHERE `classId`='1260'</ENTRY> <ENTRY timestamp='09:16:09'>SELECT * FROM scheduler.scheduleclass</ENTRY> <ENTRY timestamp='09:17:40'>SELECT * FROM scheduler.scheduleclass where courseId = 3790</ENTRY> <ENTRY timestamp='09:17:52'>SELECT * FROM scheduler.course where courseId = 3790</ENTRY> <ENTRY timestamp='09:18:37'>SELECT * FROM scheduler.department</ENTRY> <ENTRY timestamp='11:12:09'>SELECT * FROM scheduler.department</ENTRY> <ENTRY timestamp='11:50:29'>SELECT * FROM information_schema.KEY_COLUMN_USAGE</ENTRY> <ENTRY timestamp='11:51:05'>SELECT * FROM information_schema.KEY_COLUMN_USAGE
wherer CONSTRAINT_SCHEMA = 'scheduler'</ENTRY> <ENTRY timestamp='11:51:16'>SELECT * FROM information_schema.KEY_COLUMN_USAGE
where CONSTRAINT_SCHEMA = 'scheduler'</ENTRY> <ENTRY timestamp='11:55:23'>SELECT `column_name`
 , `referenced_table_schema` AS foreign_db
 , `referenced_table_name` AS foreign_table
 , `referenced_column_name` AS foreign_column 
 FROM `information_schema`.`KEY_COLUMN_USAGE`
 WHERE `constraint_schema` = SCHEMA()
 AND `table_name` = 'department'
 AND `referenced_column_name` IS NOT NULL
 ORDER BY `column_name`</ENTRY> <ENTRY timestamp='11:56:59'>SELECT column_name
 , referenced_table_schema
 , referenced_table_name
 , referenced_column_name
 , 
FROM information_schema.KEY_COLUMN_USAGE
where CONSTRAINT_SCHEMA = 'scheduler'</ENTRY> <ENTRY timestamp='11:57:11'>SELECT column_name
 , referenced_table_schema
 , referenced_table_name
 , referenced_column_name

FROM information_schema.KEY_COLUMN_USAGE
where CONSTRAINT_SCHEMA = 'scheduler'</ENTRY> <ENTRY timestamp='11:57:37'>SELECT column_name
 , referenced_table_schema
 , referenced_table_name
 , referenced_column_name

FROM information_schema.KEY_COLUMN_USAGE
where CONSTRAINT_SCHEMA = 'scheduler'
and `table_name` = 'department'</ENTRY> <ENTRY timestamp='11:57:46'>SELECT column_name
 , referenced_table_schema
 , referenced_table_name
 , referenced_column_name

FROM information_schema.KEY_COLUMN_USAGE
where CONSTRAINT_SCHEMA = 'scheduler'
and `table_name` = 'course'</ENTRY> <ENTRY timestamp='11:57:56'>SELECT * FROM information_schema.KEY_COLUMN_USAGE</ENTRY> <ENTRY timestamp='11:59:39'>SELECT * FROM information_schema.KEY_COLUMN_USAGE
where CONSTRAINT_SCHEMA = 'scheduler'</ENTRY> <ENTRY timestamp='12:00:58'>SELECT column_name
 , IFNULL(referenced_table_schema,'')
 , IFNULL(referenced_table_name,'')
 , IFNULL(referenced_column_name,'')

FROM information_schema.KEY_COLUMN_USAGE
where CONSTRAINT_SCHEMA = 'scheduler'
and `table_name` = 'course'</ENTRY> <ENTRY timestamp='12:04:08'>~</ENTRY> <ENTRY timestamp='12:04:31'>SELECT column_name
 , referenced_table_schema
 , referenced_table_name
 , referenced_column_name

FROM information_schema.KEY_COLUMN_USAGE
where CONSTRAINT_SCHEMA = 'scheduler'
and `table_name` = 'course'</ENTRY> <ENTRY timestamp='12:04:41'>SELECT `column_name`
 , `referenced_table_schema` AS foreign_db
 , `referenced_table_name` AS foreign_table
 , `referenced_column_name` AS foreign_column 
 FROM `information_schema`.`KEY_COLUMN_USAGE`
 WHERE `constraint_schema` = SCHEMA()
 AND `table_name` = 'department'
 AND `referenced_column_name` IS NOT NULL
 ORDER BY `column_name`</ENTRY> <ENTRY timestamp='12:04:42'>~</ENTRY> <ENTRY timestamp='~'>~</ENTRY> <ENTRY timestamp='12:04:43'>~</ENTRY> <ENTRY timestamp='12:04:58'>~</ENTRY> <ENTRY timestamp='12:05:10'>SELECT `column_name`
 , `referenced_table_schema` AS foreign_db
 , `referenced_table_name` AS foreign_table
 , `referenced_column_name` AS foreign_column 
 FROM `information_schema`.`KEY_COLUMN_USAGE`
 WHERE `constraint_schema` = SCHEMA()
 AND `table_name` = 'course'
 AND `referenced_column_name` IS NOT NULL
 ORDER BY `column_name`</ENTRY> <ENTRY timestamp='12:05:22'>SELECT column_name
 , referenced_table_schema
 , referenced_table_name
 , referenced_column_name

FROM information_schema.KEY_COLUMN_USAGE
where CONSTRAINT_SCHEMA = 'course'
and `table_name` = 'course'</ENTRY> <ENTRY timestamp='12:05:44'>SELECT column_name
 , referenced_table_schema
 , referenced_table_name
 , referenced_column_name

FROM information_schema.KEY_COLUMN_USAGE
where CONSTRAINT_SCHEMA = 'scheduler'
and `table_name` = 'course'</ENTRY> <ENTRY timestamp='12:05:58'>SELECT column_name
 , referenced_table_schema
 , referenced_table_name
 , referenced_column_name

FROM information_schema.KEY_COLUMN_USAGE
where CONSTRAINT_SCHEMA = 'scheduler'
and `table_name` = 'department'</ENTRY> <ENTRY timestamp='20:41:40'>CREATE TABLE `cst2146` (
 `userId` int(10) unsigned NOT NULL,
 `web` varchar(255) DEFAULT '',
 `php` varchar(255) DEFAULT '',
 `site` varchar(255) DEFAULT '',
 PRIMARY KEY (`userId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8</ENTRY> <ENTRY timestamp='20:41:59'>DROP TABLE `scheduler`.`cst2146`</ENTRY> <ENTRY timestamp='20:42:21'>SELECT * FROM jimmarti_cst.cst2146</ENTRY> <ENTRY timestamp='23:01:27'>~</ENTRY> <ENTRY timestamp='23:02:37'>DELETE FROM `jimmarti_cst`.`cst2146` WHERE `userId`='1'</ENTRY> <ENTRY timestamp='23:03:45'>SELECT * FROM jimmarti_cst.cst2146</ENTRY> <ENTRY timestamp='17:31:58'>INSERT INTO `scheduler`.`session` (`YRTR`, `sessionType`, `sessionName`, `sessionStart`, `sessionEnd`) VALUES ('20243', '1', '2023 Fall Semester', '2023-08-21', '2023-12-15')</ENTRY> <ENTRY timestamp='~'>INSERT INTO `scheduler`.`session` (`YRTR`, `sessionType`, `sessionName`, `sessionStart`, `sessionEnd`) VALUES ('20245', '1', '2024 Spring Semester', '2024-01-08', '2024-05-10')</ENTRY> <ENTRY timestamp='17:33:24'>SELECT * FROM scheduler.session</ENTRY> <ENTRY timestamp='17:37:15'>SELECT * FROM jimmarti_cst.session</ENTRY> <ENTRY timestamp='17:39:38'>INSERT INTO `jimmarti_cst`.`session` (`YRTR`, `sessionType`, `sessionName`, `sessionStart`, `sessionEnd`) VALUES ('20243', '2', '2023 Fall Semester', '2023-08-21', '2023-12-15')</ENTRY> <ENTRY timestamp='~'>INSERT INTO `jimmarti_cst`.`session` (`YRTR`, `sessionType`, `sessionName`, `sessionStart`, `sessionEnd`) VALUES ('20245', '2', '2024 Spring Semester', '2024-01-08', '2024-05-10')</ENTRY> <ENTRY timestamp='21:18:21'>DELETE FROM `jimmarti_cst`.`user` WHERE `userId`='1636'</ENTRY> <ENTRY timestamp='12:26:58'>SELECT userFirstName
 , userLastName
 , grade.*
 FROM `grade`
 JOIN `user` ON user.userId = grade.userId
 WHERE evaluationId IN ( 3060,3061,3062,3063,3064,3065,3066,3067,3068,3069,3070,3071,3072,3073,3074,3075,3076,3077,3078,3079,3080,3081,3082,3083,3084,3085,3086,3087 )
 AND gradeSubmitted = 1
 AND ( userId = 1 )</ENTRY> <ENTRY timestamp='12:27:14'>SELECT userFirstName
 , userLastName
 , grade.*
 FROM `grade`
 JOIN `user` ON user.userId = grade.userId
 WHERE evaluationId IN ( 3060,3061,3062,3063,3064,3065,3066,3067,3068,3069,3070,3071,3072,3073,3074,3075,3076,3077,3078,3079,3080,3081,3082,3083,3084,3085,3086,3087 )
 AND gradeSubmitted = 1
 AND ( grade.userId = 1 )</ENTRY> <ENTRY timestamp='12:27:59'>SELECT grade.*
 FROM `grade`
 WHERE evaluationId IN ( 3060,3061,3062,3063,3064,3065,3066,3067,3068,3069,3070,3071,3072,3073,3074,3075,3076,3077,3078,3079,3080,3081,3082,3083,3084,3085,3086,3087 )
 AND gradeSubmitted = 1
 AND ( grade.userId = 1 )</ENTRY> <ENTRY timestamp='12:28:29'>DELETE FROM `jimmarti_cst`.`grade` WHERE `gradeId`='20170'</ENTRY> <ENTRY timestamp='10:50:31'>SELECT * FROM jimmarti_cst.user</ENTRY> <ENTRY timestamp='10:52:22'>SELECT * FROM jimmarti_cst.user
where userUsername = `wp4452ys`
or userUsername = `fj2517cb`</ENTRY> <ENTRY timestamp='10:52:50'>SELECT * FROM jimmarti_cst.user
where userUsername = 'wp4452ys'
or userUsername = 'fj2517cb'</ENTRY> <ENTRY timestamp='10:54:12'>SELECT * FROM jimmarti_cst.useruserpermission</ENTRY> <ENTRY timestamp='10:54:57'>INSERT INTO `jimmarti_cst`.`useruserpermission` (`userId`, `userpermissionId`) VALUES ('1688', '2')</ENTRY> <ENTRY timestamp='~'>~</ENTRY> <ENTRY timestamp='~'>INSERT INTO `jimmarti_cst`.`useruserpermission` (`userId`, `userpermissionId`) VALUES ('1', '2')</ENTRY> <ENTRY timestamp='~'>INSERT INTO `jimmarti_cst`.`useruserpermission` (`userId`, `userpermissionId`) VALUES ('1', '3')</ENTRY> <ENTRY timestamp='10:55:57'>SELECT * FROM jimmarti_cst.useruserpermission</ENTRY> <ENTRY timestamp='10:56:22'>INSERT INTO `jimmarti_cst`.`useruserpermission` (`userId`, `userpermissionId`) VALUES ('1688', '1')</ENTRY> <ENTRY timestamp='10:56:44'>INSERT INTO `jimmarti_cst`.`useruserpermission` (`userId`, `userpermissionId`) VALUES ('1688', '3')</ENTRY> <ENTRY timestamp='~'>UPDATE `jimmarti_cst`.`useruserpermission` SET `userpermissionId`='2' WHERE `userId`='1688' and`userpermissionId`='1'</ENTRY> <ENTRY timestamp='10:57:05'>INSERT INTO `jimmarti_cst`.`useruserpermission` (`userId`, `userpermissionId`) VALUES ('1', '2')</ENTRY> <ENTRY timestamp='10:57:16'>INSERT INTO `jimmarti_cst`.`useruserpermission` (`userId`, `userpermissionId`) VALUES ('1', '3')</ENTRY> <ENTRY timestamp='10:58:09'>SELECT * FROM jimmarti_cst.session</ENTRY> <ENTRY timestamp='11:45:10'>SELECT * FROM jimmarti_cst.userpermission</ENTRY> <ENTRY timestamp='11:45:21'>SELECT * FROM jimmarti_cst.useruserpermission</ENTRY> <ENTRY timestamp='11:46:02'>DELETE FROM `jimmarti_cst`.`useruserpermission` WHERE `userId`='1' and`userpermissionId`='3'</ENTRY> <ENTRY timestamp='~'>DELETE FROM `jimmarti_cst`.`useruserpermission` WHERE `userId`='1688' and`userpermissionId`='3'</ENTRY> <ENTRY timestamp='11:47:31'>SELECT * FROM jimmarti_cst.user
where userUsername = 'wp4452ys'
or userUsername = 'fj2517cb'</ENTRY> <ENTRY timestamp='14:44:40'>SELECT * FROM jimmarti_cst.useruserpermission</ENTRY> <ENTRY timestamp='14:44:51'>DELETE FROM `jimmarti_cst`.`useruserpermission` WHERE `userId`='1' and`userpermissionId`='2'</ENTRY> <ENTRY timestamp='12:25:32'>SELECT * FROM jimmarti_cst.course</ENTRY> <ENTRY timestamp='12:25:52'>SELECT * FROM jimmarti_cst.course
where courseNumber = 'CST1600'</ENTRY> <ENTRY timestamp='12:27:59'>UPDATE `jimmarti_cst`.`course` SET `courseInactive`=?, `courseObsolete`=?, `courseUnavailable`=? WHERE `courseId`='53'</ENTRY> <ENTRY timestamp='12:28:58'>UPDATE `jimmarti_cst`.`course` SET `courseInactive`=null, `courseObsolete`=null, `courseUnavailable`=null WHERE `courseId`='53'</ENTRY> <ENTRY timestamp='12:29:22'>SELECT * FROM jimmarti_cst.course
where courseNumber = 'CST1600'</ENTRY> <ENTRY timestamp='12:31:15'>UPDATE `jimmarti_cst`.`course` SET `courseInactive`=0, `courseObsolete`=0, `courseUnavailable`=0 WHERE `courseId`='53'</ENTRY> <ENTRY timestamp='12:31:20'>SELECT * FROM jimmarti_cst.course
where courseNumber = 'CST1600'</ENTRY> <ENTRY timestamp='13:21:10'>SELECT * FROM jimmarti_cst.useruserpermission</ENTRY> <ENTRY timestamp='13:21:34'>UPDATE `jimmarti_cst`.`useruserpermission` SET `userpermissionId`='3' WHERE `userId`='1' and`userpermissionId`='2'</ENTRY> <ENTRY timestamp='18:25:23'>SELECT * FROM jimmarti_cst.classprofile</ENTRY> <ENTRY timestamp='18:25:34'>SELECT * FROM jimmarti_cst.user</ENTRY> <ENTRY timestamp='18:27:03'>SELECT * FROM jimmarti_cst.user where userStudentId=10970913</ENTRY> <ENTRY timestamp='18:29:09'>UPDATE `jimmarti_cst`.`user` SET `userEmail`='cody.niece@go.ridgewater.edu' WHERE `userId`='1694'</ENTRY> <ENTRY timestamp='18:30:23'>SELECT * FROM jimmarti_cst.user where userStudentId=16620024</ENTRY> <ENTRY timestamp='18:31:16'>UPDATE `jimmarti_cst`.`user` SET `userEmail`='thomas.walz@go.ridgewater.edu' WHERE `userId`='1690'</ENTRY> <ENTRY timestamp='19:14:30'>SELECT * FROM jimmarti_cst.user where userStudentId=16574034</ENTRY> <ENTRY timestamp='19:15:48'>UPDATE `jimmarti_cst`.`user` SET `userEmail`='neil.bigaouette@go.ridgewater.edu' WHERE `userId`='1689'</ENTRY> <ENTRY timestamp='19:26:30'>SELECT * FROM jimmarti_cst.classprofile</ENTRY> <ENTRY timestamp='19:26:58'>SELECT * FROM jimmarti_cst.class</ENTRY> <ENTRY timestamp='15:56:25'>INSERT INTO `jimmarti_cst`.`session` (`YRTR`, `sessionType`, `sessionName`, `sessionStart`, `sessionEnd`) VALUES ('20253', '2', '2024 Fall Semester', '2024-08-26', '2024-12-20')</ENTRY> <ENTRY timestamp='16:03:04'>SELECT * FROM jimmarti_cst.course</ENTRY> <ENTRY timestamp='16:05:20'>UPDATE `jimmarti_cst`.`course` SET `YRTR`='20253', `courseTitle`='Advanced Databases', `courseCredits`='3' WHERE `courseId`='196'</ENTRY> <ENTRY timestamp='16:07:03'>SELECT * FROM jimmarti_cst.course</ENTRY> <ENTRY timestamp='16:10:21'>~</ENTRY> <ENTRY timestamp='16:11:14'>UPDATE `jimmarti_cst`.`course` SET `YRTR`='20101', `courseTitle`='Data Driven Web', `courseCredits`='3' WHERE `courseId`='197'</ENTRY> <ENTRY timestamp='16:15:47'>SELECT * FROM jimmarti_cst.course</ENTRY> <ENTRY timestamp='16:16:40'>UPDATE `jimmarti_cst`.`course` SET `YRTR`='20101', `courseTitle`='Linux Server Administration', `courseCredits`='3' WHERE `courseId`='198'</ENTRY> <ENTRY timestamp='~'>UPDATE `jimmarti_cst`.`course` SET `YRTR`='20101' WHERE `courseId`='196'</ENTRY> <ENTRY timestamp='16:36:51'>SELECT * FROM jimmarti_cst.classprofile</ENTRY> <ENTRY timestamp='16:37:13'>SELECT * FROM jimmarti_cst.classstudent</ENTRY> <ENTRY timestamp='17:00:53'>SELECT * FROM jimmarti_cst.sessiontype</ENTRY> <ENTRY timestamp='17:01:04'>SELECT * FROM jimmarti_cst.user</ENTRY> <ENTRY timestamp='17:01:53'>SELECT * FROM jimmarti_cst.course</ENTRY> <ENTRY timestamp='17:06:32'>UPDATE `jimmarti_cst`.`course` SET `YRTR`='20253', `courseTitle`='Relational Databases' WHERE `courseId`='194'</ENTRY> <ENTRY timestamp='17:08:20'>SELECT * FROM jimmarti_cst.course</ENTRY> <ENTRY timestamp='17:09:19'>SELECT * FROM jimmarti_cst.classfaculty</ENTRY> <ENTRY timestamp='17:10:49'>SELECT * FROM jimmarti_cst.evaluation</ENTRY> <ENTRY timestamp='17:11:09'>SELECT * FROM jimmarti_cst.class</ENTRY> <ENTRY timestamp='17:11:52'>SELECT * FROM jimmarti_cst.grade</ENTRY> <ENTRY timestamp='17:12:19'>SELECT * FROM jimmarti_cst.pclass</ENTRY> <ENTRY timestamp='17:12:59'>SELECT * FROM jimmarti_cst.class_event</ENTRY> <ENTRY timestamp='17:13:55'>SELECT * FROM jimmarti_cst.evaluationupload</ENTRY> <ENTRY timestamp='17:14:11'>SELECT * FROM jimmarti_cst.gr_class</ENTRY> <ENTRY timestamp='17:14:16'>SELECT * FROM jimmarti_cst.gr_classmeeting</ENTRY> <ENTRY timestamp='17:14:45'>SELECT * FROM jimmarti_cst.evaluation</ENTRY> <ENTRY timestamp='17:15:27'>SELECT * FROM jimmarti_cst.event</ENTRY> <ENTRY timestamp='17:17:15'>SELECT * FROM jimmarti_cst.studentprofile</ENTRY> <ENTRY timestamp='17:18:28'>SELECT * FROM jimmarti_cst.course</ENTRY> <ENTRY timestamp='17:18:42'>SELECT * FROM jimmarti_cst.evaluation</ENTRY> <ENTRY timestamp='17:20:04'>SELECT * FROM jimmarti_cst.session</ENTRY> <ENTRY timestamp='17:20:37'>SELECT * FROM jimmarti_cst.class</ENTRY> <ENTRY timestamp='18:08:29'>SELECT * FROM jimmarti_cst.calendarschool</ENTRY> <ENTRY timestamp='13:28:05'>SELECT * FROM jimmarti_cst.session</ENTRY> <ENTRY timestamp='13:33:22'>INSERT INTO `jimmarti_cst`.`session` (`YRTR`, `sessionType`, `sessionName`, `sessionStart`, `sessionEnd`, `modifiedBy`) VALUES ('20255', '2', '2025 Spring Semester', '2025-01-13', '2025-05-16', '0')</ENTRY> <ENTRY timestamp='13:46:35'>SELECT * FROM jimmarti_cst.class</ENTRY> <ENTRY timestamp='13:47:34'>SELECT * FROM jimmarti_cst.course</ENTRY> <ENTRY timestamp='13:50:02'>INSERT INTO `jimmarti_cst`.`course` (`courseId`, `userId`, `YRTR`, `courseNumber`, `courseTitle`, `courseCredits`, `courseCreditsMax`) VALUES ('445', '1688', '20255', 'CST1600', 'Database Design', '3', '0')</ENTRY> <ENTRY timestamp='13:52:15'>UPDATE `jimmarti_cst`.`course` SET `courseTitle`='Relational Databases' WHERE `courseId`='445'</ENTRY> <ENTRY timestamp='13:54:18'>INSERT INTO `jimmarti_cst`.`class` (`courseId`, `YRTR`, `RCclassId`, `classSection`, `studentProfilePoints`, `classProfilePoints`) VALUES ('445', '20255', '000445', '41', '0', '0')</ENTRY> <ENTRY timestamp='13:57:56'>SELECT * FROM jimmarti_cst.course</ENTRY> <ENTRY timestamp='13:59:43'>UPDATE `jimmarti_cst`.`course` SET `courseId`='194' WHERE `courseId`='445'</ENTRY> <ENTRY timestamp='14:00:46'>UPDATE `jimmarti_cst`.`course` SET `courseId`='445' WHERE `courseId`='445'</ENTRY> <ENTRY timestamp='14:32:29'>SELECT * FROM jimmarti_cst.course</ENTRY> <ENTRY timestamp='14:37:51'>UPDATE `jimmarti_cst`.`class` SET `courseId`='194' WHERE `classId`='1280'</ENTRY> <ENTRY timestamp='14:40:04'>DELETE FROM `jimmarti_cst`.`course` WHERE `courseId`='445'</ENTRY> <ENTRY timestamp='11:55:33'>SELECT * FROM jimmarti_cst.course</ENTRY> <ENTRY timestamp='12:04:10'>~</ENTRY> <ENTRY timestamp='12:04:33'>UPDATE `jimmarti_cst`.`course` SET `courseTitle`='Web Server Administration' WHERE `courseId`='199'</ENTRY> <ENTRY timestamp='13:18:09'>SELECT * FROM jimmarti_cst.session</ENTRY> <ENTRY timestamp='13:19:59'>UPDATE `jimmarti_cst`.`class` SET `RCclassId`='000451' WHERE `classId`='1281'</ENTRY> <ENTRY timestamp='15:38:41'>SELECT * FROM jimmarti_cst.session</ENTRY> <ENTRY timestamp='15:42:55'>INSERT INTO `jimmarti_cst`.`session` (`YRTR`, `sessionType`, `sessionName`, `sessionStart`, `sessionEnd`) VALUES ('20263', '2', '2025 Fall Semester', '2025-08-25', '2025-12-19')</ENTRY> <ENTRY timestamp='15:43:55'>SELECT * FROM jimmarti_cst.course</ENTRY> <ENTRY timestamp='15:49:24'>SELECT * FROM jimmarti_cst.evaluation</ENTRY>