var query = {
    CREATEFOLDER: "INSERT INTO user_folder(FOLDERID, USERID, FOLDERNAME, PARENTFOLDERNAME, DATE) VALUES (?,?,?,?,?)",
    SELECTFOLDER : "SELECT * FROM user_folder WHERE USERID = ? AND FOLDERNAME = ? AND PARENTFOLDERNAME = ?",
    FOLDERLIST : "SELECT FOLDERID, FOLDERNAME, PARENTFOLDERNAME FROM user_folder WHERE USERID = ? AND PARENTFOLDERNAME = ?",
    DELETEFOLDER : "DELETE FROM user_folder WHERE USERID = ? AND FOLDERID = ? AND PARENTFOLDERNAME = ?",
    SELECTFROMPARENTNAME : "SELECT FOLDERNAME,FOLDERID FROM user_folder WHERE  USERID = ?  AND PARENTFOLDERNAME = ?",
    UPLOADFILE : "INSERT INTO user_file(FILEID, USERID, PARENTFOLDERNAME, FILENAME, FILETYPE, FILESIZE, FILEPATH, DATE) VALUES (?,?,?,?,?,?,?,?)",
    FILELIST : "SELECT * FROM user_file WHERE USERID = ? AND PARENTFOLDERNAME = ?",
    CHECKFILE : "SELECT * FROM user_file WHERE USERID = ? AND FILENAME = ? AND PARENTFOLDERNAME = ?",
    DELETEFILE : "DELETE FROM user_file WHERE USERID = ? AND FILEID = ? AND PARENTFOLDERNAME = ?",
    TOTALSIZE : "SELECT SUM(FILESIZE) AS SIZE FROM user_file WHERE USERID = ? ",
    SELECTUSER: "SELECT USERID,USERNAME,EMAIL FROM user_info WHERE USERID = ? ",
    CREATEUSER : "INSERT INTO user_info(USERID, USERNAME, PROVIDER, DATE, EMAIL) VALUES (?,?,?,?,?)",
    FILEFOLDERCOUNT : "SELECT folder_counts, file_counts FROM (SELECT COUNT(FOLDERID) AS folder_counts FROM user_folder WHERE USERID = ? AND  PARENTFOLDERNAME= ? ) AS folder_counts, (SELECT COUNT(FILEID) AS file_counts FROM user_file WHERE USERID = ? AND  PARENTFOLDERNAME= ? ) AS file_counts",
    STARTFILE : "UPDATE user_file SET STAR = ? WHERE USERID= ? AND FILEID= ?",
}

export default query