#----------------------
	#备份
	DROP TABLE plugin_checkin_userrecord_BAK;
	CREATE TABLE plugin_checkin_userrecord_BAK AS SELECT * FROM plugin_checkin_userrecord;
	
	DROP TABLE IF EXISTS TEMP_CONTINUECHECKINS;
	CREATE TABLE TEMP_CONTINUECHECKINS AS 
	SELECT UID,(CASE 
				    WHEN SUM(DAY(CREATEAT)) = 0 + 0 + 0 + 0 THEN 0
				    WHEN SUM(DAY(CREATEAT)) = 0 + 0 + 0 + 6 THEN 1
				    WHEN SUM(DAY(CREATEAT)) = 0 + 0 + 5 + 0 THEN 1
				    WHEN SUM(DAY(CREATEAT)) = 0 + 0 + 5 + 6 THEN 2
				    WHEN SUM(DAY(CREATEAT)) = 0 + 4 + 0 + 0 THEN 0
				    WHEN SUM(DAY(CREATEAT)) = 0 + 4 + 0 + 6 THEN 1
				    WHEN SUM(DAY(CREATEAT)) = 0 + 4 + 5 + 0 THEN 2
				    WHEN SUM(DAY(CREATEAT)) = 0 + 4 + 5 + 6 THEN 3
				    WHEN SUM(DAY(CREATEAT)) = 3 + 0 + 0 + 0 THEN 0
				    WHEN SUM(DAY(CREATEAT)) = 3 + 0 + 0 + 6 AND DAY(MAX(CREATEAT)) = 6 THEN 1
				    WHEN SUM(DAY(CREATEAT)) = 3 + 0 + 5 + 0 THEN 1
				    WHEN SUM(DAY(CREATEAT)) = 3 + 0 + 5 + 6 THEN 2
				    WHEN SUM(DAY(CREATEAT)) = 3 + 4 + 0 + 0 THEN 0
				    WHEN SUM(DAY(CREATEAT)) = 3 + 4 + 0 + 6 THEN 1
				    WHEN SUM(DAY(CREATEAT)) = 3 + 4 + 5 + 0 THEN 3
				    WHEN SUM(DAY(CREATEAT)) = 3 + 4 + 5 + 6 THEN 4
				 ELSE 0 END
				    ) AS DAYS FROM bbs7_log_score_201312 
		WHERE  ACTION = 'scoreCheckIn' AND CREATEAT >= '2013-12-03'  GROUP BY UID ;
	
	UPDATE plugin_checkin_userrecord A ,TEMP_CONTINUECHECKINS B SET A.CONTINUECHECKINS = B.DAYS WHERE A.UID = B.UID;
	
	COMMIT;