#######################################################
################   USERSERVICE MODULE  ################ 
#######################################################
userinfo.insert = INSERT INTO USERINFO VALUES (?, ?, ?, ?, ?)
userinfo.update = UPDATE USERINFO \
                  SET password=?, name=?, email=?, adminYN=? WHERE userId=?
userinfo.delete = DELETE FROM USERINFO WHERE userId=?
userinfo.select.byuserid = \
    SELECT \
        userId, password, name, email, adminYN \
    FROM USERINFO WHERE userId = ?
userinfo.select.count = SELECT count(*) FROM USERINFO WHERE userId=?    
userinfo.select.list = SELECT userId, name, email, adminYN FROM USERINFO

#######################################################
#################   BOARDSERVICE MODULE  ############## 
#######################################################
board.sql.insert = INSERT INTO BOARD \
       					(boardno, title, name, email, password, \
       					createdate, content) \
    			   VALUES(?, ?, ?, ?, ?, ?, ?)
board.sql.update = UPDATE BOARD SET \
						title=?, name=?, email=?, content=? \
				   WHERE boardno=?
board.sql.update.hitcount = UPDATE BOARD SET \
								hitcount = hitcount + 1 \
				   			WHERE boardno=?
board.sql.delete = DELETE FROM BOARD WHERE boardno=?
board.sql.select.byboardno = SELECT \
								title, name, email, password, \
								createdate, content, hitcount \
							 FROM BOARD WHERE boardno=?
board.sql.select.list = SELECT \
							boardno, title, name, email, createdate, hitcount \
						FROM BOARD ORDER BY CREATEDATE DESC LIMIT ?, ?
board.sql.totalcount = SELECT count(*) FROM BOARD						
boardfile.sql.insert = INSERT INTO BOARDFILE VALUES(?, ?, ?, ?, ?, ?)
boardfile.sql.delete.byboardno = DELETE FROM BOARDFILE WHERE boardno=?
boardfile.sql.delete.byboardfileno = DELETE FROM BOARDFILE WHERE fileno=?
boardfile.sql.select.byboardfileno = SELECT \
										fileno, filesize, filename, \
										contenttype, tempfilename \
								 	 FROM BOARDFILE WHERE fileno=?
boardfile.sql.select.byboardno = SELECT \
									fileno, filesize, filename \
								 FROM BOARDFILE WHERE boardno=?
								 
#######################################################
#################   LOGINFO MODULE      ############## 
#######################################################
loginfo.sql.insert = \
	INSERT INTO LOGINFO \
		(logno, logcreatedate, loginuserid, logindatetime) \
	VALUES(?,?,?,?)