57 lines
1.3 KiB
PHP
57 lines
1.3 KiB
PHP
<?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();
|
|
}
|
|
}
|