/**
* Upgrades for MajorVersion = 0, MinorVersion = 0
*
* Add code to perform actual database updgrad operation 
* For first version, create supporting tables
*
* @param $dbhandle  handle to database
* @return $status   true if operation was successful
*/
function V_Major0_Minor0_Upgrade($dbhandle)
{
    $logger = LoggerSingleton::GetInstance();
    $logger->LogInfo("V0_0_Upgrade - Enter ");
    $status = true;
    /* create password table if not persent */
    // check if existing
    if (true == $status) {
        $status = IsExisting_Password($dbhandle);
        $logger->LogInfo("IsExisting Password table status :" . var_export($status, true));
    }
    // Create table
    if (false == $status) {
        $status = CreateTable_Password($dbhandle);
        $logger->LogInfo("Create Password table status : " . var_export($status, true));
    }
    /* Create UserDetails table if not present */
    if (true == $status) {
        $status = IsExisting_UserDetails($dbhandle);
        $logger->LogInfo("IsExisting UserDetails table status :" . var_export($status, true));
    }
    // Create table
    if (false == $status) {
        $status = CreateTable_UserDetails($dbhandle);
        $logger->LogInfo("Create UserDetails table status : " . var_export($status, true));
    }
    /* Create TodoList table if not present already */
    if (true == $status) {
        $status = IsExisting_TodoList($dbhandle);
        $logger->LogInfo("IsExisting TodoList table status :" . var_export($status, true));
    }
    // Create table
    if (false == $status) {
        $status = CreateTable_TodoList($dbhandle);
        $logger->LogInfo("Create TodoList table status : " . var_export($status, true));
    }
    $logger->LogInfo("Exit form V_Major0_Minor0_Upgrade with status :" . var_export($status, true));
    return $status;
}
    $status = SelectByIdFrom_Password($dbhandle, $id, $user, $password);
    $logger->LogInfo("Select into Password table status : " . var_export($status, true));
}
// display record
if (true == $status) {
    $logger->LogInfo("userid - {$id}, username - {$user}, password - {$password}");
}
/** TodoTable Table Operations **/
// check if existing
if (true == $status) {
    $status = IsExisting_TodoList($dbhandle);
    $logger->LogInfo("IsExisting TodoList table status :" . var_export($status, true));
}
// Create table
if (false == $status) {
    $status = CreateTable_TodoList($dbhandle);
    $logger->LogInfo("Create TodoList table status : " . var_export($status, true));
}
// insert into table
$userid = $id;
$priority = $TodoListTable_PriorityNormal;
$task_status = $TodoListTable_StatusNotStarted;
$task = "Complete this todo task";
$today = date("Y-m-d");
$createdDate = $today;
$estimatedDate = date('Y-m-d', strtotime($today . ' + 2 days'));
$remainderDate = date('Y-m-d', strtotime($today . ' + 1 days'));
$completedDate = null;
//$sometime = mktime(0,0,0,12,31,2015);
if (true == $status) {
    $status = InsertInto_TodoList($dbhandle, $mid, $userid, $priority, $task_status, $task, $createdDate, $estimatedDate, $completedDate, $remainderDate);