diff --git a/src/main/kotlin/net/taehui/twilight/system/DB.kt b/src/main/kotlin/net/taehui/twilight/system/DB.kt index a5fea98..1d80428 100644 --- a/src/main/kotlin/net/taehui/twilight/system/DB.kt +++ b/src/main/kotlin/net/taehui/twilight/system/DB.kt @@ -492,15 +492,14 @@ val pmsNoteID = "${Utility.getNoteID512(noteID)}:1" it.prepareStatement( """ - UPDATE tw_note - SET Note_ID = ?, Input_Mode = 12 + DELETE + FROM tw_note WHERE Note_ID = ? """.trimIndent() ).use { dbStatement -> - dbStatement.setString(1, pmsNoteID) dbStatement.setString(2, noteID) if (dbStatement.executeUpdate() > 0) { - logger.logInfo("PMSed Note File") + logger.logInfo("Wiped Note") } } it.prepareStatement( @@ -512,7 +511,7 @@ ).use { dbStatement -> dbStatement.setString(1, pmsNoteID) dbStatement.setString(2, noteID) - logger.logInfo("PMSed ${dbStatement.executeUpdate()} Comment Files") + logger.logInfo("PMSed ${dbStatement.executeUpdate()} Comments") } it.commit() }