karlgray

DROP TABLE IF EXISTS time_dimension;
CREATE TABLE time_dimension (
        id                      INTEGER PRIMARY KEY,  -- year*10000+month*100+day
        db_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
        day_name                VARCHAR(9) NOT NULL, -- 'Monday', 'Tuesday'...

karlgray

<?php  if ( ! defined('BASEPATH')) exit('No direct script access allowed');
/**
 * My Model
 *
 * Used as a base class for all admin or app related model functions.
 *
 * @author Alex Garcia
 * @since 0.1
 * @version 1
 */