ALTER TABLE `_app` DROP INDEX `search`; ALTER TABLE `_app` ADD FULLTEXT INDEX `search` (`name_ru`, `name_en`, `name_be`, `name_pl`, `description_ru`, `description_en`, `description_be`, `description_pl`); Array ( [0] => ALTER TABLE `_app` CHANGE COLUMN `user_id` `user_id` int DEFAULT 1; [1] => ALTER TABLE `_app` CHANGE COLUMN `date_added` `date_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP; [2] => ALTER TABLE `_app` CHANGE COLUMN `date_modified` `date_modified` DATETIME NOT NULL NULL; [3] => ALTER TABLE `_app` CHANGE COLUMN `key` `key` varchar(200) NOT NULL ; [4] => ALTER TABLE `_app` CHANGE COLUMN `viewed` `viewed` int(11) unsigned DEFAULT 0; [5] => ALTER TABLE `_app` CHANGE COLUMN `server_ip` `server_ip` varchar(200) NOT NULL ; [6] => ALTER TABLE `_app` CHANGE COLUMN `localise` `localise` varchar(200) DEFAULT "en_EN"; [7] => ALTER TABLE `_app` CHANGE COLUMN `robots.txt` `robots.txt` text ; [8] => ALTER TABLE `_app` CHANGE COLUMN `manifest.json` `manifest.json` text ; [9] => ALTER TABLE `_app` CHANGE COLUMN `.htaccess` `.htaccess` text ; [10] => ALTER TABLE `_app` CHANGE COLUMN `name_ru` `name_ru` varchar(200) ; [11] => ALTER TABLE `_app` CHANGE COLUMN `name_en` `name_en` varchar(200) ; [12] => ALTER TABLE `_app` CHANGE COLUMN `name_be` `name_be` varchar(200) ; [13] => ALTER TABLE `_app` CHANGE COLUMN `name_pl` `name_pl` varchar(200) ; [14] => ALTER TABLE `_app` CHANGE COLUMN `slogan_ru` `slogan_ru` varchar(800) ; [15] => ALTER TABLE `_app` CHANGE COLUMN `slogan_en` `slogan_en` varchar(800) ; [16] => ALTER TABLE `_app` CHANGE COLUMN `slogan_be` `slogan_be` varchar(800) ; [17] => ALTER TABLE `_app` CHANGE COLUMN `slogan_pl` `slogan_pl` varchar(800) ; [18] => ALTER TABLE `_app` CHANGE COLUMN `description_ru` `description_ru` longtext ; [19] => ALTER TABLE `_app` CHANGE COLUMN `description_en` `description_en` longtext ; [20] => ALTER TABLE `_app` CHANGE COLUMN `description_be` `description_be` longtext ; [21] => ALTER TABLE `_app` CHANGE COLUMN `description_pl` `description_pl` longtext ; [22] => ALTER TABLE `_app` CHANGE COLUMN `_working_hours` `_working_hours` mediumtext ; [23] => ALTER TABLE `_app` CHANGE COLUMN `postal_code` `postal_code` varchar(200) ; [24] => ALTER TABLE `_app` CHANGE COLUMN `address_ru` `address_ru` varchar(200) ; [25] => ALTER TABLE `_app` CHANGE COLUMN `address_en` `address_en` varchar(200) ; [26] => ALTER TABLE `_app` CHANGE COLUMN `address_be` `address_be` varchar(200) ; [27] => ALTER TABLE `_app` CHANGE COLUMN `address_pl` `address_pl` varchar(200) ; [28] => ALTER TABLE `_app` CHANGE COLUMN `driving_directions` `driving_directions` mediumtext ; [29] => ALTER TABLE `_app` CHANGE COLUMN `legal_name_ru` `legal_name_ru` varchar(200) ; [30] => ALTER TABLE `_app` CHANGE COLUMN `legal_name_en` `legal_name_en` varchar(200) ; [31] => ALTER TABLE `_app` CHANGE COLUMN `legal_name_be` `legal_name_be` varchar(200) ; [32] => ALTER TABLE `_app` CHANGE COLUMN `legal_name_pl` `legal_name_pl` varchar(200) ; [33] => ALTER TABLE `_app` CHANGE COLUMN `taxpayer_number` `taxpayer_number` varchar(200) ; [34] => ALTER TABLE `_app` CHANGE COLUMN `legal_register_number` `legal_register_number` varchar(200) ; [35] => ALTER TABLE `_app` CHANGE COLUMN `legal_register_date` `legal_register_date` DATETIME NULL; [36] => ALTER TABLE `_app` CHANGE COLUMN `bank_name_ru` `bank_name_ru` varchar(200) ; [37] => ALTER TABLE `_app` CHANGE COLUMN `bank_name_en` `bank_name_en` varchar(200) ; [38] => ALTER TABLE `_app` CHANGE COLUMN `bank_name_be` `bank_name_be` varchar(200) ; [39] => ALTER TABLE `_app` CHANGE COLUMN `bank_name_pl` `bank_name_pl` varchar(200) ; [40] => ALTER TABLE `_app` CHANGE COLUMN `bank_address_ru` `bank_address_ru` varchar(200) ; [41] => ALTER TABLE `_app` CHANGE COLUMN `bank_address_en` `bank_address_en` varchar(200) ; [42] => ALTER TABLE `_app` CHANGE COLUMN `bank_address_be` `bank_address_be` varchar(200) ; [43] => ALTER TABLE `_app` CHANGE COLUMN `bank_address_pl` `bank_address_pl` varchar(200) ; [44] => ALTER TABLE `_app` CHANGE COLUMN `bank_code` `bank_code` varchar(200) ; [45] => ALTER TABLE `_app` CHANGE COLUMN `bank_checking_account` `bank_checking_account` varchar(200) ; [46] => ALTER TABLE `_app` CHANGE COLUMN `first_currency` `first_currency` int DEFAULT 0; [47] => ALTER TABLE `_app` CHANGE COLUMN `currency_exchange` `currency_exchange` longtext ; [48] => ALTER TABLE `_app` CHANGE COLUMN `date_exchange_actual` `date_exchange_actual` DATETIME NULL; [49] => ALTER TABLE `_app` CHANGE COLUMN `app_logo` `app_logo` boolean DEFAULT 0; [50] => ALTER TABLE `_app` CHANGE COLUMN `app_icon` `app_icon` boolean DEFAULT 0; [51] => ALTER TABLE `_app` CHANGE COLUMN `app_pic` `app_pic` boolean DEFAULT 0; [52] => ALTER TABLE `_app` CHANGE COLUMN `theme_color` `theme_color` varchar(32) ; [53] => ALTER TABLE `_app` CHANGE COLUMN `background_color` `background_color` varchar(32) ; [54] => ALTER TABLE `_app` CHANGE COLUMN `style` `style` int DEFAULT 0; [55] => ALTER TABLE `_app` CHANGE COLUMN `shared` `shared` varchar(200) ; [56] => ALTER TABLE `_app` CHANGE COLUMN `facebook_group` `facebook_group` varchar(200) ; [57] => ALTER TABLE `_app` CHANGE COLUMN `vk_group` `vk_group` varchar(200) ; [58] => ALTER TABLE `_app` CHANGE COLUMN `mailru_group` `mailru_group` varchar(200) ; [59] => ALTER TABLE `_app` CHANGE COLUMN `odnoklassniki_group` `odnoklassniki_group` varchar(200) ; [60] => ALTER TABLE `_app` CHANGE COLUMN `yandex_group` `yandex_group` varchar(200) ; [61] => ALTER TABLE `_app` CHANGE COLUMN `twitter_group` `twitter_group` varchar(200) ; [62] => ALTER TABLE `_app` CHANGE COLUMN `instagram_group` `instagram_group` varchar(200) ; [63] => ALTER TABLE `_app` CHANGE COLUMN `youtube_group` `youtube_group` varchar(200) ; [64] => ALTER TABLE `_app` CHANGE COLUMN `telegram_channel` `telegram_channel` varchar(200) ; [65] => ALTER TABLE `_app` CHANGE COLUMN `telegram_market` `telegram_market` varchar(200) ; [66] => ALTER TABLE `_app` CHANGE COLUMN `feed_market` `feed_market` varchar(200) ; [67] => ALTER TABLE `_app` CHANGE COLUMN `google_client_id` `google_client_id` varchar(200) ; [68] => ALTER TABLE `_app` CHANGE COLUMN `google_client_secret` `google_client_secret` varchar(200) ; [69] => ALTER TABLE `_app` CHANGE COLUMN `facebook_client_id` `facebook_client_id` varchar(200) ; [70] => ALTER TABLE `_app` CHANGE COLUMN `facebook_client_secret` `facebook_client_secret` varchar(200) ; [71] => ALTER TABLE `_app` CHANGE COLUMN `vk_client_id` `vk_client_id` varchar(200) ; [72] => ALTER TABLE `_app` CHANGE COLUMN `vk_client_secret` `vk_client_secret` varchar(200) ; [73] => ALTER TABLE `_app` CHANGE COLUMN `mailru_client_id` `mailru_client_id` varchar(200) ; [74] => ALTER TABLE `_app` CHANGE COLUMN `mailru_client_secret` `mailru_client_secret` varchar(200) ; [75] => ALTER TABLE `_app` CHANGE COLUMN `yandex_client_id` `yandex_client_id` varchar(200) ; [76] => ALTER TABLE `_app` CHANGE COLUMN `yandex_client_secret` `yandex_client_secret` varchar(200) ; [77] => ALTER TABLE `_app` CHANGE COLUMN `odnoklassniki_client_id` `odnoklassniki_client_id` varchar(200) ; [78] => ALTER TABLE `_app` CHANGE COLUMN `odnoklassniki_client_secret` `odnoklassniki_client_secret` varchar(200) ; [79] => ALTER TABLE `_app` CHANGE COLUMN `odnoklassniki_public_key` `odnoklassniki_public_key` varchar(200) ; [80] => ALTER TABLE `_app` CHANGE COLUMN `author` `author` varchar(200) ; [81] => ALTER TABLE `_app` CHANGE COLUMN `custom_scripts` `custom_scripts` text ; [82] => ALTER TABLE `_app` CHANGE COLUMN `remarketing_code` `remarketing_code` text ; [83] => ALTER TABLE `_app` CHANGE COLUMN `gtm_script` `gtm_script` text ; [84] => ALTER TABLE `_app` CHANGE COLUMN `gtm_no_script` `gtm_no_script` text ; )