<?php

class Upgrade12 extends UpgradeNew
{
    // overi, jestli je opravnene provest upgrade
    public function checkRightfulness_1()
    {
        $change = true;

        $SQL = sqlQuery('SHOW FIELDS FROM '.getTableName('sections'));
        while ($row = sqlFetchArray($SQL)) {
            if ($row['Field'] == 'photo') {
                $change = false;
                break;
            }
        }

        return $change;
    }

    // provest samotny upgrade
    public function makeChanges_1()
    {
        // Add constraint to photos
        $SQL = sqlQuery('ALTER TABLE '.getTableName('sections').'
		      ADD `photo` VARCHAR(50) DEFAULT NULL');

        $this->upgradeOK();
    }

    // overi, jestli je opravnene provest upgrade
    public function checkRightfulness_2()
    {
        $change = true;

        $SQL = sqlQuery('SHOW FIELDS FROM '.getTableName('orders_history'));
        while ($row = sqlFetchArray($SQL)) {
            if ($row['Field'] == 'notified') {
                $change = false;
                break;
            }
        }

        return $change;
    }

    // provest samotny upgrade
    public function makeChanges_2()
    {
        // Add constraint to photos
        $SQL = sqlQuery('ALTER TABLE '.getTableName('orders_history').'
	         ADD `notified` TINYINT(1) NOT NULL');

        $this->upgradeOK();
    }
}