60 lines
1.6 KiB
PHP
60 lines
1.6 KiB
PHP
<?php
|
|
|
|
namespace KupShop\ContentBundle\Resources\upgrade;
|
|
|
|
class PhotosUpgrade extends \UpgradeNew
|
|
{
|
|
public function check_PhotosFilenameColumn()
|
|
{
|
|
return $this->checkColumnExists('photos', 'filename');
|
|
}
|
|
|
|
/** Add filename column into photos table */
|
|
public function upgrade_PhotosFilenameColumn()
|
|
{
|
|
sqlQuery('ALTER TABLE photos ADD COLUMN filename VARCHAR(100) DEFAULT NULL AFTER id');
|
|
|
|
$this->upgradeOK();
|
|
}
|
|
|
|
public function check_PhotosDateUpdate()
|
|
{
|
|
return $this->checkColumnExists('photos', 'date_update');
|
|
}
|
|
|
|
/** Add date_update column into photos table */
|
|
public function upgrade_PhotosDateUpdate()
|
|
{
|
|
sqlQuery('ALTER TABLE photos ADD date_update DATETIME DEFAULT NOW() NULL;');
|
|
|
|
$this->upgradeOK();
|
|
}
|
|
|
|
public function check_ResponsivePhotoFields(): bool
|
|
{
|
|
return $this->checkColumnExists('photos', 'image_tablet');
|
|
}
|
|
|
|
/** Add image_tablet and image_mobile fields to photos table */
|
|
public function upgrade_ResponsivePhotoFields(): void
|
|
{
|
|
sqlQuery('ALTER TABLE photos ADD COLUMN image_tablet VARCHAR(100) DEFAULT NULL AFTER image_2;');
|
|
sqlQuery('ALTER TABLE photos ADD COLUMN image_mobile VARCHAR(100) DEFAULT NULL AFTER image_tablet;');
|
|
|
|
$this->upgradeOK();
|
|
}
|
|
|
|
public function check_CustomDataField(): bool
|
|
{
|
|
return $this->checkColumnExists('photos', 'data');
|
|
}
|
|
|
|
/** Add custom_data field to photos table **/
|
|
public function upgrade_CustomDataField(): void
|
|
{
|
|
sqlQuery('alter table photos add data longtext null;');
|
|
|
|
$this->upgradeOK();
|
|
}
|
|
}
|