| 12345678910111213141516171819202122232425262728 |
- <?php
- class ModelExtensionModuleLinksToMarketplaces extends Model {
- public function addColumnsToTable() {
- $has_url_ozon_column = $this->db->query("SHOW COLUMNS FROM " . DB_PREFIX . "product WHERE Field='url_ozon'")->num_rows > 0;
- if (!$has_url_ozon_column) {
- $this->db->query("ALTER TABLE " . DB_PREFIX . "product ADD COLUMN url_ozon VARCHAR(255) NULL");
- }
- $has_url_wildberries_column = $this->db->query("SHOW COLUMNS FROM " . DB_PREFIX . "product WHERE Field='url_wildberries'")->num_rows > 0;
- if (!$has_url_wildberries_column) {
- $this->db->query("ALTER TABLE " . DB_PREFIX . "product ADD COLUMN url_wildberries VARCHAR(255) NULL");
- }
- $has_url_yandex_market_column = $this->db->query("SHOW COLUMNS FROM " . DB_PREFIX . "product WHERE Field='url_yandex_market'")->num_rows > 0;
- if (!$has_url_yandex_market_column) {
- $this->db->query("ALTER TABLE " . DB_PREFIX . "product ADD COLUMN url_yandex_market VARCHAR(255) NULL");
- }
- $has_url_megamarket_column = $this->db->query("SHOW COLUMNS FROM " . DB_PREFIX . "product WHERE Field='url_megamarket'")->num_rows > 0;
- if (!$has_url_megamarket_column) {
- $this->db->query("ALTER TABLE " . DB_PREFIX . "product ADD COLUMN url_megamarket VARCHAR(255) NULL");
- }
- }
- }
|