mafernando

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