+export GPG_TTY="$(tty)"
+export EDITOR="$(which vim)"
+export LESS='-RFX'
+export HISTCONTROL='ignoredups'
+export HISTTIMEFORMAT="<%a %b %d @ %H:%M:%S> "
+export HISTSIZE=-1
+export HISTFILESIZE=-1
+
+shopt -s checkwinsize
+
+alias ls='ls --color=auto'
+alias grep='grep --color=auto'
+alias http='http -p HBhb'
+alias last='last -w'
+alias radlast='radlast -w'
+alias checkhours="echo 'SELECT MIN(date) AS date_____, WEEK(date,6) AS week, SEC_TO_TIME(SUM(TIME_TO_SEC(time_out)-TIME_TO_SEC(time_in))) AS time FROM timesheet WHERE user_id = 50 GROUP BY YEARWEEK(date,6);' | mysql"
+alias dailyhours="echo 'SELECT date AS date_____, WEEK(date,6) AS week, DAY(date) AS day, RPAD(DAYNAME(date),10,'\"'\"' '\"'\"') AS dayn_____, SEC_TO_TIME(SUM(TIME_TO_SEC(time_out)-TIME_TO_SEC(time_in))) AS time_____, ROUND(SUM(TIME_TO_SEC(time_out)-TIME_TO_SEC(time_in))/60/60,2) AS time2____ FROM timesheet WHERE user_id = 50 AND MONTH(date) = MONTH(NOW()) AND YEAR(date) = YEAR(NOW()) GROUP BY date;' | mysql"
+
+# vim: nosmarttab noexpandtab ts=4