SELECT activityID, stamp FROM #application.settings.tableprefix#activity ORDER BY stamp DESC UPDATE #application.settings.tableprefix#activity SET stamp = #DateConvert("local2utc",stamp)# WHERE activityID = '#activityID#' ACTIVITY RECORDS CONVERTED...
SELECT commentID, stamp FROM #application.settings.tableprefix#comments ORDER BY stamp DESC UPDATE #application.settings.tableprefix#comments SET stamp = #DateConvert("local2utc",stamp)# WHERE commentID = '#commentID#' COMMENT RECORDS CONVERTED...
SELECT fileID, uploaded FROM #application.settings.tableprefix#files ORDER BY uploaded DESC UPDATE #application.settings.tableprefix#files SET uploaded = #DateConvert("local2utc",uploaded)# WHERE fileID = '#fileID#' FILE RECORDS CONVERTED...
SELECT issueID, created FROM #application.settings.tableprefix#issues ORDER BY created DESC UPDATE #application.settings.tableprefix#issues SET created = #DateConvert("local2utc",created)# WHERE issueID = '#issueID#' ISSUE RECORDS CONVERTED...
SELECT messageID, stamp FROM #application.settings.tableprefix#messages ORDER BY stamp DESC UPDATE #application.settings.tableprefix#messages SET stamp = #DateConvert("local2utc",stamp)# WHERE messageID = '#messageID#' MESSAGE RECORDS CONVERTED...
SELECT milestoneID, completed FROM #application.settings.tableprefix#milestones ORDER BY completed DESC UPDATE #application.settings.tableprefix#milestones SET completed = #DateConvert("local2utc",completed)# WHERE milestoneID = '#milestoneID#' MILESTONE RECORDS CONVERTED...
SELECT projectID, added FROM #application.settings.tableprefix#projects ORDER BY added DESC UPDATE #application.settings.tableprefix#projects SET added = #DateConvert("local2utc",added)# WHERE projectID = '#projectID#' PROJECT RECORDS CONVERTED...
SELECT fileID, uploaded FROM #application.settings.tableprefix#screenshots ORDER BY uploaded DESC UPDATE #application.settings.tableprefix#screenshots SET uploaded = #DateConvert("local2utc",uploaded)# WHERE fileID = '#fileID#' SCREENSHOT RECORDS CONVERTED...
SELECT todoID, added, completed FROM #application.settings.tableprefix#todos ORDER BY added DESC UPDATE #application.settings.tableprefix#todos SET added = #DateConvert("local2utc",added)# WHERE todoID = '#todoID#' UPDATE #application.settings.tableprefix#todos SET completed = #DateConvert("local2utc",completed)# WHERE todoID = '#todoID#' TODO RECORDS CONVERTED...
SELECT todolistID, added FROM #application.settings.tableprefix#todolists ORDER BY added DESC UPDATE #application.settings.tableprefix#todolists SET added = #DateConvert("local2utc",added)# WHERE todolistID = '#todolistID#' TODOLIST RECORDS CONVERTED...
SELECT userID, lastLogin FROM #application.settings.tableprefix#users ORDER BY lastLogin DESC UPDATE #application.settings.tableprefix#users SET lastLogin = #DateConvert("local2utc",lastLogin)# WHERE userID = '#userID#' USER RECORDS CONVERTED...