diff options
Diffstat (limited to 'src/database.rs')
| -rw-r--r-- | src/database.rs | 11 |
1 files changed, 1 insertions, 10 deletions
diff --git a/src/database.rs b/src/database.rs index d5ccf92..5bdb4f4 100644 --- a/src/database.rs +++ b/src/database.rs @@ -168,7 +168,7 @@ impl Database { let conn = self.conn.lock().unwrap(); let sql = lb.sql("SELECT * FROM leaderboard_LBID WHERE user_id=?1"); - let user_handle: String = conn + let _user_handle: String = conn .query_row(&sql, params![user], |row| row.get(1)) .map_err(|_| Error::UserNotExist)?; @@ -233,15 +233,6 @@ const CREATE_TABLE_LEADERBOARD_HISTORY: &'static str = "\ points INTEGER NOT NULL DEFAULT 0 );"; -const CREATE_TRIGGER_LDBCHANGETIME_UPDATE: &'static str = "\ - CREATE TRIGGER ldbchangetime_update_LBID - AFTER UPDATE ON leaderboard_LBID - FOR EACH ROW - WHEN NEW.score_updated < OLD.score_updated OR OLD.score_updated IS NULL - BEGIN - UPDATE leaderboard_LBID SET score_updated=CURRENT_TIMESTAMP WHERE user_id=OLD.user_id; - END;"; - const CREATE_TRIGGER_LDBHIST_UPDATE: &'static str = "\ CREATE TRIGGER ldbdhist_update_LBID BEFORE UPDATE ON leaderboard_LBID BEGIN |