dctucker

# Usage:
# source tabcolor.sh 96 96 192

# iTerm2 window/tab color commands
#   Requires iTerm2 >= Build 1.0.0.20110804
#   http://code.google.com/p/iterm2/wiki/ProprietaryEscapeCodes
rgb() {
    echo -ne "\033]6;1;bg;red;brightness;$1\a"
    echo -ne "\033]6;1;bg;green;brightness;$2\a"
    echo -ne "\033]6;1;bg;blue;brightness;$3\a"

dctucker

DROP TABLE IF EXISTS calendar;
CREATE TABLE calendar (
        id                      INTEGER PRIMARY KEY,  -- year*10000+month*100+day
        date                    DATE NOT NULL,
        year                    INTEGER NOT NULL,
        month                   INTEGER UNSIGNED NOT NULL, -- 1 to 12
        day                     INTEGER UNSIGNED NOT NULL, -- 1 to 31
        quarter                 INTEGER UNSIGNED NOT NULL, -- 1 to 4
        week                    INTEGER UNSIGNED NOT NULL, -- 1 to 52/53
        dayofweek               INTEGER UNSIGNED NOT NULL, -- 1 to 7