Game.sql.php

<?php

Game::addSqlQuery('GAME_LIST',
    "SELECT * FROM GAME ORDER BY GAME_ID");

Game::addSqlQuery('GAME_BY_ID',
    "SELECT * FROM  GAME WHERE GAME_ID=:game_id");

Game::addSqlQuery('GAME_CREATE',
    "INSERT INTO GAME (GAME_ID, GAME_DESC) VALUES (NULL, :GAME_DESC)");

Game::addSqlQuery('GAME_ID_MAX',
    "SELECT MAX(GAME_ID) AS id FROM GAME");

Game::addSqlQuery('GAME_UPDATE',
    "UPDATE GAME SET GAME_DESC=:GAME_DESC WHERE GAME_ID=:GAME_ID");

Game::addSqlQuery('GAME_DELETE',
    "DELETE FROM GAME WHERE GAME_ID=:GAME_ID");

Game::addSqlQuery('GAME_GET_USERS',
    "SELECT USER_ID FROM GAME_HISTO WHERE GAME_ID=:GAME_ID");

Game::addSqlQuery('GAME_ADD_USER',
    "INSERT INTO GAME_HISTO (GAME_HISTO_ID, GAME_ID, USER_ID) VALUES (NULL, :GAME_ID, :USER_ID)");

Game::addSqlQuery('GAME_DELETE_USER',
    "DELETE FROM GAME_HISTO WHERE (GAME_ID=:GAME_ID AND USER_ID=:USER_ID)");