public function safeUp() { $this->execute("ALTER TABLE `da_ajax` DROP `param_value`"); $this->execute("ALTER TABLE `da_ajax` DROP `param_name`"); $this->execute("ALTER TABLE `da_ajax` DROP `type_instance`"); $this->execute("ALTER TABLE `da_ajax` DROP `locate_type`"); $this->execute("ALTER TABLE `da_ajax` DROP `path`"); $this->execute("ALTER TABLE `da_ajax` DROP `function_name`"); $this->execute("ALTER TABLE `da_ajax` DROP `id_ajax`"); $this->execute("DROP TABLE `da_ajax`"); $this->execute("DROP TABLE `da_antispam`"); $this->execute("ALTER TABLE `da_file_upload_settings` DROP `sizeLimit`"); $this->execute("ALTER TABLE `da_file_upload_settings` DROP `minSizeLimit`"); $this->execute("ALTER TABLE `da_file_upload_settings` DROP `id_file_type`"); $this->execute("ALTER TABLE `da_file_upload_settings` DROP `countFiles`"); $this->execute("ALTER TABLE `da_file_upload_settings` DROP `id_add_object`"); $this->execute("ALTER TABLE `da_file_upload_settings` DROP `id_parameter`"); $this->execute("ALTER TABLE `da_file_upload_settings` DROP `id_object`"); $this->execute("DROP TABLE `da_file_upload_settings`"); $this->execute("ALTER TABLE `da_module` DROP `id_child_parent_object`"); $this->execute("ALTER TABLE `da_module` DROP `id_module_parent`"); $this->execute("ALTER TABLE `da_module` DROP `id_module_handler`"); $this->execute("ALTER TABLE `da_module` DROP `id_object`"); $this->execute("ALTER TABLE `da_module` DROP `name`"); $this->execute("DROP TABLE `da_module`"); $this->execute("DROP TABLE `da_cache_data`, `da_cache_setting_script`, `da_cache_url_block`, `da_domain_module`, `da_module_view`, `da_php_script_type_obj_rel`, `da_property`, `da_property_value`, `da_sequence`, `da_session`, `da_session_parameter`"); $path = dirname(__FILE__) . "/../../assets/"; HFile::removeDirectoryRecursive($path, false, false, false, array(".gitignore")); }
public function safeUp() { $this->execute("ALTER TABLE `pr_question` CHANGE `name` `name` VARCHAR(255) NOT NULL"); $this->execute("ALTER TABLE `pr_question` CHANGE `question` `question` LONGTEXT NOT NULL"); $path = dirname(__FILE__) . "/../../assets/"; HFile::removeDirectoryRecursive($path, false); }
public function safeUp() { $this->execute("UPDATE `da_object_parameters` SET `caption`='Обязательное', `not_null`=0 WHERE `da_object_parameters`.`id_object`=21 AND `da_object_parameters`.`id_parameter`=84"); $this->execute("UPDATE `da_object_parameters` SET `not_null`=0 WHERE `da_object_parameters`.`id_object`=21 AND `da_object_parameters`.`id_parameter`=156"); $path = dirname(__FILE__) . "/../../assets/"; HFile::removeDirectoryRecursive($path, false, false, false); }
public function safeUp() { $this->execute("DELETE FROM da_search_data WHERE id_object=21 AND id_instance='39'"); $this->execute("DELETE FROM `da_object_parameters` WHERE `da_object_parameters`.`id_object`=34 AND `da_object_parameters`.`id_parameter`=39"); $path = dirname(__FILE__) . "/../../assets/"; HFile::removeDirectoryRecursive($path, false, false, false, array(".gitignore")); }
public function safeUp() { $this->execute("ALTER TABLE `da_object` CHANGE `id_object` `id_object` VARCHAR( 255 ) NOT NULL COMMENT 'id'"); $this->execute("ALTER TABLE `da_object_parameters` CHANGE `id_object` `id_object` VARCHAR( 255 ) NOT NULL DEFAULT '0' COMMENT 'Объект',\r\nCHANGE `add_parameter` `add_parameter` VARCHAR( 255 ) NULL DEFAULT NULL COMMENT 'Параметр'"); $this->execute("ALTER TABLE `da_object_view` CHANGE `id_object` `id_object` VARCHAR( 255 ) NOT NULL COMMENT 'Объект'"); $this->execute("ALTER TABLE `da_object_view_column` CHANGE `id_object` `id_object` VARCHAR( 255 ) NOT NULL COMMENT 'Объект'"); $this->execute("ALTER TABLE `da_files` CHANGE `id_object` `id_object` VARCHAR( 255 ) NULL DEFAULT NULL COMMENT 'Объект'"); $this->execute("ALTER TABLE `da_object_parameters` CHANGE `id_parameter` `id_parameter` VARCHAR( 255 ) NOT NULL COMMENT 'ИД'"); $this->execute("ALTER TABLE `da_object` CHANGE `id_field_order` `id_field_order` VARCHAR( 255 ) NULL DEFAULT NULL COMMENT 'Свойство для порядка'"); $this->execute("ALTER TABLE `da_object` CHANGE `id_field_caption` `id_field_caption` VARCHAR( 255 ) NULL DEFAULT NULL COMMENT 'Свойство для отображения'"); $this->execute("ALTER TABLE `da_files` CHANGE `id_parameter` `id_parameter` VARCHAR( 255 ) NULL DEFAULT NULL COMMENT 'Свойство объекта'"); $this->execute("ALTER TABLE `da_object_view_column` CHANGE `id_object_parameter` `id_object_parameter` VARCHAR( 255 ) NULL DEFAULT NULL COMMENT 'Параметр объекта'"); $this->execute("ALTER TABLE `da_object_view` CHANGE `id_object_view` `id_object_view` VARCHAR( 255 ) NOT NULL COMMENT 'id'"); $this->execute("ALTER TABLE `da_object_view_column` CHANGE `id_object_view` `id_object_view` VARCHAR( 255 ) NOT NULL COMMENT 'Представление'"); $this->execute("ALTER TABLE `da_object_view_column` CHANGE `id_object_view_column` `id_object_view_column` VARCHAR( 255 ) NOT NULL COMMENT 'id'"); $this->execute("ALTER TABLE `da_job_parameter_value` DROP `id_job_parameter`"); $this->execute("ALTER TABLE `da_job_parameter_value` DROP `name`"); $this->execute("ALTER TABLE `da_job_parameter_value` DROP `value`"); $this->execute("DROP TABLE `da_job_parameter_value`"); $this->execute("ALTER TABLE `da_job` CHANGE `id_job` `id_job` VARCHAR( 255 ) NOT NULL COMMENT 'ИД задачи'"); $this->execute("ALTER TABLE `da_job` CHANGE `name` `name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'Имя задачи'"); $this->execute("ALTER TABLE `da_php_script_type` CHANGE `id_php_script_type` `id_php_script_type` VARCHAR( 255 ) NOT NULL COMMENT 'id'"); $this->execute("ALTER TABLE `da_php_script` CHANGE `id_php_script_type` `id_php_script_type` VARCHAR( 255 ) NOT NULL"); $this->execute("ALTER TABLE `da_object_view_column` CHANGE `handler` `handler` VARCHAR( 255 ) NULL DEFAULT NULL COMMENT 'Обработчик'"); $this->execute("ALTER TABLE `da_system_parameter` CHANGE `id_system_parameter` `id_system_parameter` VARCHAR( 255 ) NOT NULL COMMENT 'id'"); $this->execute("ALTER TABLE `da_references` CHANGE `id_reference` `id_reference` VARCHAR( 255 ) NOT NULL COMMENT 'id'"); $this->execute("ALTER TABLE `da_reference_element` CHANGE `id_reference` `id_reference` VARCHAR( 255 ) NOT NULL DEFAULT '0' COMMENT 'Справочник'"); $this->execute("ALTER TABLE `da_reference_element` CHANGE `id_reference_element_instance` `id_reference_element_instance` VARCHAR( 255 ) NOT NULL COMMENT 'id'"); $path = dirname(__FILE__) . "/../../assets/"; @HFile::removeDirectoryRecursive($path, false, false, false, array(".gitignore")); }
public function safeUp() { $this->execute("UPDATE `da_object` SET `id_object`='101', `name`='Наборы виджетов', `id_field_order`='16', `order_type`=2, `table_name`='da_site_module_template', `id_field_caption`='13', `object_type`=1, `folder_name`=NULL, `parent_object`=102, `sequence`=7, `use_domain_isolation`=0, `field_caption`='name', `yii_model`='SiteModuleTemplate' WHERE `da_object`.`id_object`='101'"); $this->execute("INSERT IGNORE INTO `da_auth_item_child` (`parent`, `child`) VALUES ('dev', 'list_object_101')"); $this->execute("UPDATE `da_object` SET `id_object`='103', `name`='Виджеты сайта', `id_field_order`='542', `order_type`=1, `table_name`='da_site_module', `id_field_caption`='542', `object_type`=1, `folder_name`='content/modules', `parent_object`=102, `sequence`=8, `use_domain_isolation`=0, `field_caption`='name', `yii_model`='SiteModule' WHERE `da_object`.`id_object`='103'"); $this->execute("INSERT IGNORE INTO `da_auth_item_child` (`parent`, `child`) VALUES ('dev', 'list_object_103')"); $this->execute("UPDATE `da_object_view` SET `id_object_view`='57', `id_object`='103', `name`='Виджеты » Виджеты сайта', `order_no`=1, `visible`=1, `sql_select`=NULL, `sql_from`=NULL, `sql_where`=NULL, `sql_order_by`='name ASC', `count_data`=50, `icon_class`=NULL, `id_parent`=NULL WHERE `da_object_view`.`id_object_view`='57'"); $this->execute("UPDATE `da_object_view` SET `id_object_view`='55', `id_object`='101', `name`='Виджеты » Наборы виджетов', `order_no`=1, `visible`=1, `sql_select`=NULL, `sql_from`=NULL, `sql_where`=NULL, `sql_order_by`='id_module_template ASC', `count_data`=50, `icon_class`=NULL, `id_parent`=NULL WHERE `da_object_view`.`id_object_view`='55'"); $this->execute("UPDATE `da_object_parameters` SET `id_object`='101', `id_parameter`='13', `id_parameter_type`=2, `sequence`=8, `widget`=NULL, `caption`='Название набора', `field_name`='name', `add_parameter`='0', `default_value`=NULL, `not_null`=1, `sql_parameter`=NULL, `is_unique`=0, `group_type`=0, `need_locale`=0, `search`=0, `is_additional`=0, `hint`='' WHERE `da_object_parameters`.`id_object`='101' AND `da_object_parameters`.`id_parameter`='13'"); $this->execute("UPDATE `da_object_parameters` SET `id_object`='101', `id_parameter`='16', `id_parameter_type`=9, `sequence`=8, `widget`=NULL, `caption`='Использовать по умолчанию', `field_name`='is_default_template', `add_parameter`='0', `default_value`='0', `not_null`=1, `sql_parameter`=NULL, `is_unique`=0, `group_type`=0, `need_locale`=0, `search`=0, `is_additional`=0, `hint`='' WHERE `da_object_parameters`.`id_object`='101' AND `da_object_parameters`.`id_parameter`='16'"); $this->execute("UPDATE `da_object_parameters` SET `id_object`='101', `id_parameter`='14', `id_parameter_type`=10, `sequence`=10, `widget`='menu.backend.widgets.manageModule.ManageModuleWidget', `caption`='Виджеты', `field_name`=NULL, `add_parameter`='2', `default_value`=NULL, `not_null`=0, `sql_parameter`='SiteModuleTemplateListOfModule', `is_unique`=0, `group_type`=0, `need_locale`=0, `search`=0, `is_additional`=0, `hint`='' WHERE `da_object_parameters`.`id_object`='101' AND `da_object_parameters`.`id_parameter`='14'"); $this->execute("UPDATE `da_object_parameters` SET `id_object`='101', `id_parameter`='16', `id_parameter_type`=9, `sequence`=8, `widget`=NULL, `caption`='Использовать по умолчанию', `field_name`='is_default_template', `add_parameter`='0', `default_value`='0', `not_null`=1, `sql_parameter`=NULL, `is_unique`=0, `group_type`=0, `need_locale`=0, `search`=0, `is_additional`=0, `hint`='Набор виджетов будет применяться к новым пунктам Меню корневого уровня' WHERE `da_object_parameters`.`id_object`='101' AND `da_object_parameters`.`id_parameter`='16'"); $this->execute("UPDATE `da_object_parameters` SET `id_parameter`='15', `id_parameter_type`=7, `sequence`=13, `widget`=NULL, `caption`='Набор виджетов', `field_name`='id_module_template', `add_parameter`='101', `default_value`='SiteModuleTemplate::getIdDefaultTemplate();', `not_null`=0, `sql_parameter`=NULL, `is_unique`=0, `group_type`=1, `need_locale`=0, `search`=0, `is_additional`=1, `hint`='' WHERE `da_object_parameters`.`id_parameter`='15'"); $this->execute("UPDATE `da_object_parameters` SET `id_parameter`='127', `id_parameter_type`=2, `sequence`=3, `widget`=NULL, `caption`='В адресной строке', `field_name`='alias', `add_parameter`='0', `default_value`=NULL, `not_null`=0, `sql_parameter`=NULL, `is_unique`=1, `group_type`=0, `need_locale`=0, `search`=0, `is_additional`=0, `hint`='Обязательно на английском языке. Необходимо для формирования человекопонятных URLов.' WHERE `da_object_parameters`.`id_parameter`='127'"); $this->execute("UPDATE `da_object_parameters` SET `id_parameter`='330', `id_parameter_type`=9, `sequence`=21, `widget`=NULL, `caption`='Разрешить удаление', `field_name`='removable', `add_parameter`='0', `default_value`='1', `not_null`=1, `sql_parameter`=NULL, `is_unique`=0, `group_type`=0, `need_locale`=0, `search`=0, `is_additional`=1, `hint`='Актуально для динамических разделов, удаление которых приводит к возникновению критических ошибок.' WHERE `da_object_parameters`.`id_parameter`='330'"); $this->execute("UPDATE `da_object_view` SET `id_object_view`='2018', `id_object`='520', `name`='Витрина', `order_no`=1, `visible`=1, `sql_select`=NULL, `sql_from`=NULL, `sql_where`=NULL, `sql_order_by`='sequence ASC', `count_data`=50, `icon_class`='icon-retweet', `id_parent`=NULL WHERE `da_object_view`.`id_object_view`='2018'"); $this->execute("UPDATE `da_object_view` SET `id_object_view`='55', `id_object`='101', `name`='Виджеты » Наборы виджетов', `order_no`=1, `visible`=1, `sql_select`=NULL, `sql_from`=NULL, `sql_where`=NULL, `sql_order_by`='id_module_template ASC', `count_data`=50, `icon_class`='icon-list-alt', `id_parent`=NULL WHERE `da_object_view`.`id_object_view`='55'"); $this->execute("UPDATE `da_object_view` SET `id_object_view`='57', `id_object`='103', `name`='Виджеты » Виджеты сайта', `order_no`=1, `visible`=1, `sql_select`=NULL, `sql_from`=NULL, `sql_where`=NULL, `sql_order_by`='name ASC', `count_data`=50, `icon_class`='icon-list-alt', `id_parent`=NULL WHERE `da_object_view`.`id_object_view`='57'"); $this->execute("UPDATE `da_object_parameters` SET `id_object`='20', `id_parameter`='157', `id_parameter_type`=2, `sequence`=16, `widget`=NULL, `caption`='yii-модель', `field_name`='yii_model', `add_parameter`='0', `default_value`=NULL, `not_null`=0, `sql_parameter`=NULL, `is_unique`=0, `group_type`=0, `need_locale`=0, `search`=0, `is_additional`=0, `hint`='Например: ygin.models.File или просто Domain, если есть точная уверенность, что система уже знает о модели' WHERE `da_object_parameters`.`id_object`='20' AND `da_object_parameters`.`id_parameter`='157'"); $this->execute("UPDATE `da_object_parameters` SET `id_object`='20', `id_parameter`='155', `id_parameter_type`=2, `sequence`=7, `widget`=NULL, `caption`='Путь к документам', `field_name`='folder_name', `add_parameter`='0', `default_value`=NULL, `not_null`=0, `sql_parameter`=NULL, `is_unique`=0, `group_type`=0, `need_locale`=0, `search`=0, `is_additional`=0, `hint`='Путь к папке на сервере относительно корня сайта для хранения загружаемых файлов. Например, \"content/news\" для сохранения загрузки фотографий к новостям.' WHERE `da_object_parameters`.`id_object`='20' AND `da_object_parameters`.`id_parameter`='155'"); $this->execute("UPDATE `da_object_parameters` SET `id_object`='63', `id_parameter`='409', `id_parameter_type`=9, `sequence`=7, `widget`=NULL, `caption`='Видимость', `field_name`='visible', `add_parameter`='0', `default_value`='1', `not_null`=1, `sql_parameter`=NULL, `is_unique`=0, `group_type`=0, `need_locale`=0, `search`=0, `is_additional`=0, `hint`='Определяет видимость представления в меню системы управления. В случае отсутствия видимости, представление остаётся доступным по прямой ссылке.' WHERE `da_object_parameters`.`id_object`='63' AND `da_object_parameters`.`id_parameter`='409'"); $this->execute("UPDATE `da_object_parameters` SET `id_object`='63', `id_parameter`='407', `id_parameter_type`=1, `sequence`=12, `widget`=NULL, `caption`='Экземпляров на странице', `field_name`='count_data', `add_parameter`='0', `default_value`='50', `not_null`=1, `sql_parameter`=NULL, `is_unique`=0, `group_type`=0, `need_locale`=0, `search`=0, `is_additional`=0, `hint`='Определяет количество отображаемых экземпляров объекта на одной странице' WHERE `da_object_parameters`.`id_object`='63' AND `da_object_parameters`.`id_parameter`='407'"); $this->execute("UPDATE `da_object_parameters` SET `id_object`='66', `id_parameter`='418', `id_parameter_type`=2, `sequence`=4, `widget`=NULL, `caption`='Заголовок', `field_name`='caption', `add_parameter`='0', `default_value`=NULL, `not_null`=0, `sql_parameter`=NULL, `is_unique`=0, `group_type`=0, `need_locale`=0, `search`=0, `is_additional`=0, `hint`='' WHERE `da_object_parameters`.`id_object`='66' AND `da_object_parameters`.`id_parameter`='418'"); $this->execute("UPDATE `da_object_parameters` SET `id_object`='66', `id_parameter`='420', `id_parameter_type`=7, `sequence`=7, `widget`='backend.backend.objectParameter.selectObjectParameterWidget.SelectObjectParameterWidget', `caption`='Свойство объекта', `field_name`='id_object_parameter', `add_parameter`='21', `default_value`=NULL, `not_null`=0, `sql_parameter`=NULL, `is_unique`=0, `group_type`=0, `need_locale`=0, `search`=0, `is_additional`=0, `hint`='' WHERE `da_object_parameters`.`id_object`='66' AND `da_object_parameters`.`id_parameter`='420'"); $this->execute("UPDATE `da_object_parameters` SET `id_object`='66', `id_parameter`='423', `id_parameter_type`=7, `sequence`=10, `widget`=NULL, `caption`='Обработчик', `field_name`='handler', `add_parameter`='80', `default_value`=NULL, `not_null`=0, `sql_parameter`='id_php_script_interface IN (6, 7)', `is_unique`=0, `group_type`=0, `need_locale`=0, `search`=0, `is_additional`=0, `hint`='Особый зарегистрированный в системе скрипт, который будет формировать колонку' WHERE `da_object_parameters`.`id_object`='66' AND `da_object_parameters`.`id_parameter`='423'"); $path = dirname(__FILE__) . "/../../assets/"; @HFile::removeDirectoryRecursive($path, false, false, false, array(".gitignore")); }
public function safeUp() { $this->execute("INSERT INTO `da_object_parameters` (`id_parameter_type`, `sequence`, `not_null`, `need_locale`, `search`, `is_additional`, `id_object`, `group_type`, `caption`, `field_name`, `id_parameter`, `widget`, `add_parameter`, `sql_parameter`, `default_value`, `is_unique`, `hint`) VALUES (9, 0, 1, 0, 0, 0, '21', 0, 'Видимость', 'visible', 'ygin-object-parameter-visible', NULL, NULL, NULL, '1', 0, 'Доступно ли свойство при редактировании экземпляра объекта')"); $this->execute("UPDATE da_object_parameters SET sequence = 288 WHERE id_parameter='ygin-object-parameter-visible'"); $path = dirname(__FILE__) . "/../../assets/"; @HFile::removeDirectoryRecursive($path, false, false, false, array(".gitignore")); }
public function afterSave($event) { if ($this->owner->isNewRecord && ($tmpId = $this->getTmpId())) { if ($this->owner instanceof DaInstance) { $finder = $this->owner; } else { $finder = $this->owner->model(); } if ($this->resetScope) { $finder->resetScope(); } $model = $finder->findByIdInstance($this->owner->getIdInstance()); foreach ($this->getFiles() as $files) { foreach ($files as $file) { $modelDir = $model->getDir(true); $file->file_path = $modelDir . $file->getName(); $file->id_instance = $model->getIdInstance(); $file->id_tmp = null; $file->save(false); } } if (count($this->getFiles()) > 0) { //переносим файлы $mpDir = Yii::getPathOfAlias('temp') . '/' . $this->getTmpId(); HFile::copyDirectory($mpDir, $model->getDir(true, true)); HFile::removeDirectoryRecursive($mpDir, true); } } }
public function safeUp() { $this->execute("UPDATE `da_object` SET `id_object_handler`=NULL, `id_instance_class`=NULL, `yii_model`='banners.models.BannerPlace' WHERE `da_object`.`id_object`=261"); $this->execute("UPDATE `da_object` SET `id_object_handler`=NULL, `id_instance_class`=NULL, `yii_model`='banners.models.Banner' WHERE `da_object`.`id_object`=260"); $path = dirname(__FILE__) . "/../../assets/"; HFile::removeDirectoryRecursive($path, false, false, false); }
public function safeUp() { $this->execute("UPDATE `da_object_parameters` SET `id_object`='20', `id_parameter`='63', `id_parameter_type`=11, `sequence`=1, `widget`=NULL, `caption`='id', `field_name`='id_object', `add_parameter`='1', `default_value`=NULL, `not_null`=1, `sql_parameter`=NULL, `is_unique`=0, `group_type`=0, `need_locale`=0, `search`=0, `is_additional`=0, `hint`='Уникальный ИД объекта в виде строки. Например для новостей ИД будет равен ygin-news Вместо ygin можно использовать название проекта или компании.' WHERE `da_object_parameters`.`id_object`='20' AND `da_object_parameters`.`id_parameter`='63'"); $this->execute("UPDATE `da_users` SET `id_user`=1, `name`='admin', `user_password`='91a399ceafc4f3ecb187932030b020e78d94952e', `mail`='*****@*****.**', `full_name`='Разработчик', `rid`=NULL, `create_date`=1178788080, `count_post`=1, `active`=1, `requires_new_password`=0, `salt`='73561e3259556005dd91739f0c54744829a245d7', `password_strategy`='sha1' WHERE `da_users`.`id_user`=1"); $this->execute("UPDATE `da_object_parameters` SET `id_object`='21', `id_parameter`='74', `id_parameter_type`=11, `sequence`=6, `widget`=NULL, `caption`='id', `field_name`='id_parameter', `add_parameter`='1', `default_value`=NULL, `not_null`=1, `sql_parameter`=NULL, `is_unique`=0, `group_type`=0, `need_locale`=0, `search`=0, `is_additional`=0, `hint`='Уникальный ИД свойства объекта в виде строки. Например для заголовка новостей ИД будет равен ygin-news-title Вместо ygin можно использовать название проекта или компании.' WHERE `da_object_parameters`.`id_object`='21' AND `da_object_parameters`.`id_parameter`='74'"); $this->execute("UPDATE `da_object_parameters` SET `id_object`='27', `id_parameter`='109', `id_parameter_type`=11, `sequence`=8, `widget`=NULL, `caption`='id', `field_name`='id_reference', `add_parameter`='1', `default_value`=NULL, `not_null`=1, `sql_parameter`=NULL, `is_unique`=0, `group_type`=0, `need_locale`=0, `search`=0, `is_additional`=0, `hint`='Уникальный ИД справочника. Например ygin-shop-reference-order_status Вместо ygin можно использовать название проекта или компании.' WHERE `da_object_parameters`.`id_object`='27' AND `da_object_parameters`.`id_parameter`='109'"); $this->execute("UPDATE `da_object_parameters` SET `id_object`='28', `id_parameter`='111', `id_parameter_type`=11, `sequence`=1, `widget`=NULL, `caption`='id', `field_name`='id_reference_element_instance', `add_parameter`='1', `default_value`=NULL, `not_null`=1, `sql_parameter`=NULL, `is_unique`=0, `group_type`=0, `need_locale`=0, `search`=0, `is_additional`=0, `hint`='Уникальный ИД элемента справочника. Например ygin-shop-reference-order_status-new Вместо ygin можно использовать название проекта или компании.' WHERE `da_object_parameters`.`id_object`='28' AND `da_object_parameters`.`id_parameter`='111'"); $this->execute("UPDATE `da_object_parameters` SET `id_object`='30', `id_parameter`='116', `id_parameter_type`=11, `sequence`=8, `widget`=NULL, `caption`='id', `field_name`='id_system_parameter', `add_parameter`='1', `default_value`=NULL, `not_null`=1, `sql_parameter`=NULL, `is_unique`=0, `group_type`=0, `need_locale`=0, `search`=0, `is_additional`=0, `hint`='Уникальный ИД системного параметра. Например ygin-parameter-phone Вместо ygin можно использовать название проекта или компании.' WHERE `da_object_parameters`.`id_object`='30' AND `da_object_parameters`.`id_parameter`='116'"); $this->execute("UPDATE `da_object_parameters` SET `id_object`='51', `id_parameter`='267', `id_parameter_type`=11, `sequence`=1, `widget`=NULL, `caption`='id', `field_name`='id_job', `add_parameter`='1', `default_value`=NULL, `not_null`=1, `sql_parameter`=NULL, `is_unique`=0, `group_type`=0, `need_locale`=0, `search`=0, `is_additional`=0, `hint`='Уникальный ИД задачи планировщика. Например для отправки уведомлений это будет ygin-send_mail Вместо ygin можно использовать название проекта или компании.' WHERE `da_object_parameters`.`id_object`='51' AND `da_object_parameters`.`id_parameter`='267'"); $this->execute("UPDATE `da_object_parameters` SET `id_object`='51', `id_parameter`='267', `id_parameter_type`=11, `sequence`=1, `widget`=NULL, `caption`='id', `field_name`='id_job', `add_parameter`='1', `default_value`=NULL, `not_null`=1, `sql_parameter`=NULL, `is_unique`=0, `group_type`=0, `need_locale`=0, `search`=0, `is_additional`=0, `hint`='Уникальный ИД задачи планировщика. Например для отправки уведомлений это будет ygin-sendMail Вместо ygin можно использовать название проекта или компании.' WHERE `da_object_parameters`.`id_object`='51' AND `da_object_parameters`.`id_parameter`='267'"); $this->execute("UPDATE `da_object_parameters` SET `id_object`='28', `id_parameter`='111', `id_parameter_type`=11, `sequence`=1, `widget`=NULL, `caption`='id', `field_name`='id_reference_element_instance', `add_parameter`='1', `default_value`=NULL, `not_null`=1, `sql_parameter`=NULL, `is_unique`=0, `group_type`=0, `need_locale`=0, `search`=0, `is_additional`=0, `hint`='Уникальный ИД элемента справочника. Например ygin-shop-reference-orderStatus-new Вместо ygin можно использовать название проекта или компании.' WHERE `da_object_parameters`.`id_object`='28' AND `da_object_parameters`.`id_parameter`='111'"); $this->execute("UPDATE `da_object_parameters` SET `id_object`='27', `id_parameter`='109', `id_parameter_type`=11, `sequence`=8, `widget`=NULL, `caption`='id', `field_name`='id_reference', `add_parameter`='1', `default_value`=NULL, `not_null`=1, `sql_parameter`=NULL, `is_unique`=0, `group_type`=0, `need_locale`=0, `search`=0, `is_additional`=0, `hint`='Уникальный ИД справочника. Например ygin-shop-reference-orderStatus Вместо ygin можно использовать название проекта или компании.' WHERE `da_object_parameters`.`id_object`='27' AND `da_object_parameters`.`id_parameter`='109'"); $this->execute("UPDATE `da_object_parameters` SET `id_object`='63', `id_parameter`='400', `id_parameter_type`=11, `sequence`=1, `widget`=NULL, `caption`='id', `field_name`='id_object_view', `add_parameter`='1', `default_value`=NULL, `not_null`=1, `sql_parameter`=NULL, `is_unique`=0, `group_type`=0, `need_locale`=0, `search`=0, `is_additional`=0, `hint`='Уникальный ИД представления объекта в виде строки. Обычно имеет имя ygin-news-view-main Вместо ygin можно использовать название проекта или компании' WHERE `da_object_parameters`.`id_object`='63' AND `da_object_parameters`.`id_parameter`='400'"); $this->execute("UPDATE `da_object_parameters` SET `id_object`='66', `id_parameter`='415', `id_parameter_type`=11, `sequence`=1, `widget`=NULL, `caption`='id', `field_name`='id_object_view_column', `add_parameter`='1', `default_value`=NULL, `not_null`=1, `sql_parameter`=NULL, `is_unique`=0, `group_type`=0, `need_locale`=0, `search`=0, `is_additional`=0, `hint`='Уникальный ИД колонки представления. Например для заголовка новости ИД будет равен ygin-news-view-main-title Вместо ygin можно использовать название проекта или компании.' WHERE `da_object_parameters`.`id_object`='66' AND `da_object_parameters`.`id_parameter`='415'"); $this->execute("UPDATE `da_object_parameters` SET `id_object`='80', `id_parameter`='338', `id_parameter_type`=11, `sequence`=1, `widget`=NULL, `caption`='id', `field_name`='id_php_script_type', `add_parameter`='1', `default_value`=NULL, `not_null`=1, `sql_parameter`=NULL, `is_unique`=0, `group_type`=0, `need_locale`=0, `search`=0, `is_additional`=0, `hint`='Уникальный ИД пхп обработчика. Например для модуля новостей это будет ygin-news-module-last Вместо ygin можно использовать название проекта или компании.' WHERE `da_object_parameters`.`id_object`='80' AND `da_object_parameters`.`id_parameter`='338'"); $this->execute("UPDATE da_object_parameters SET id_object=replace(id_object, '.', '-')"); $this->execute("UPDATE da_object_parameters SET add_parameter=replace(add_parameter, '.', '-') WHERE id_parameter_type=7"); $this->execute("UPDATE da_object_view SET id_object=replace(id_object, '.', '-')"); $this->execute("UPDATE da_object_view_column SET id_object=replace(id_object, '.', '-')"); $this->execute("UPDATE da_object_view SET id_object_view=replace(id_object_view, '.', '-')"); $this->execute("UPDATE da_object_view_column SET id_object_view=replace(id_object_view, '.', '-')"); $this->execute("UPDATE da_object_view_column SET id_object_view_column=replace(id_object_view_column, '.', '-')"); $this->execute("UPDATE da_object_parameters SET id_parameter=replace(id_parameter, '.', '-')"); $this->execute("UPDATE da_files SET id_parameter=replace(id_parameter, '.', '-')"); $this->execute("UPDATE da_object_view_column SET id_object_parameter=replace(id_object_parameter, '.', '-')"); $path = dirname(__FILE__) . "/../../assets/"; @HFile::removeDirectoryRecursive($path, false, false, false, array(".gitignore")); }
public function safeUp() { $this->execute("UPDATE `da_object_view` SET `icon_class`='glyphicon glyphicon-list-alt' WHERE `da_object_view`.`id_object_view`='ygin-menu-view-main'"); $this->execute("UPDATE `da_object_view` SET `icon_class`='glyphicon glyphicon-bullhorn' WHERE `da_object_view`.`id_object_view`='2002'"); $this->execute("UPDATE `da_object_view` SET `icon_class`='glyphicon glyphicon-picture' WHERE `da_object_view`.`id_object_view`='2000'"); $this->execute("UPDATE `da_object_view` SET `icon_class`='glyphicon glyphicon-share-alt' WHERE `da_object_view`.`id_object_view`='2016'"); $this->execute("UPDATE `da_object_view` SET `icon_class`='glyphicon glyphicon-retweet' WHERE `da_object_view`.`id_object_view`='2011'"); $this->execute("UPDATE `da_object_view` SET `icon_class`='glyphicon glyphicon-comment' WHERE `da_object_view`.`id_object_view`='67'"); $this->execute("UPDATE `da_object_view` SET `icon_class`='glyphicon glyphicon-fullscreen' WHERE `da_object_view`.`id_object_view`='2018'"); $this->execute("UPDATE `da_object_view` SET `icon_class`='glyphicon glyphicon-book' WHERE `da_object_view`.`id_object_view`='2025'"); $this->execute("UPDATE `da_object_view` SET `icon_class`='glyphicon glyphicon-tags' WHERE `da_object_view`.`id_object_view`='100'"); $this->execute("UPDATE `da_object_view` SET `icon_class`='glyphicon glyphicon-import' WHERE `da_object_view`.`id_object_view`='100'"); $this->execute("UPDATE `da_object_view` SET `icon_class`='glyphicon glyphicon-tags' WHERE `da_object_view`.`id_object_view`='55'"); $this->execute("UPDATE `da_object_view` SET `icon_class`='glyphicon glyphicon-tag' WHERE `da_object_view`.`id_object_view`='57'"); $this->execute("UPDATE `da_object_view` SET `icon_class`='glyphicon glyphicon-gift' WHERE `da_object_view`.`id_object_view`='2008'"); $this->execute("UPDATE `da_object_view` SET `icon_class`='glyphicon glyphicon-shopping-cart' WHERE `da_object_view`.`id_object_view`='2017'"); $this->execute("UPDATE `da_object_view` SET `icon_class`='glyphicon glyphicon-bookmark' WHERE `da_object_view`.`id_object_view`='2023'"); $this->execute("UPDATE `da_object_view` SET `icon_class`='glyphicon glyphicon-th-large' WHERE `da_object_view`.`id_object_view`='2'"); $this->execute("UPDATE `da_object_view` SET `icon_class`='glyphicon glyphicon-dashboard' WHERE `da_object_view`.`id_object_view`='33'"); $this->execute("UPDATE `da_object_view` SET `icon_class`='glyphicon glyphicon-user' WHERE `da_object_view`.`id_object_view`='6'"); $this->execute("UPDATE `da_object_view` SET `icon_class`='glyphicon glyphicon-pushpin' WHERE `da_object_view`.`id_object_view`='13'"); $this->execute("UPDATE `da_object_view` SET `icon_class`='glyphicon glyphicon-wrench' WHERE `da_object_view`.`id_object_view`='12'"); $this->execute("UPDATE `da_object_view` SET `icon_class`='glyphicon glyphicon-calendar' WHERE `da_object_view`.`id_object_view`='33'"); $this->execute("UPDATE `da_object_view` SET `icon_class`='glyphicon glyphicon-book' WHERE `da_object_view`.`id_object_view`='9'"); $this->execute("UPDATE `da_object_view` SET `icon_class`='glyphicon glyphicon-inbox' WHERE `da_object_view`.`id_object_view`='32'"); $this->execute("UPDATE `da_object_view` SET `icon_class`='glyphicon glyphicon-cog' WHERE `da_object_view`.`id_object_view`='12'"); $this->execute("UPDATE `da_object_view` SET `icon_class`='glyphicon glyphicon-envelope' WHERE `da_object_view`.`id_object_view`='16'"); $path = dirname(__FILE__) . "/../../assets/"; @HFile::removeDirectoryRecursive($path, false, false, false, array(".gitignore")); }
public function safeUp() { $this->execute("UPDATE `da_object_parameters` SET `id_object`='105', `id_parameter`='532', `id_parameter_type`=10, `sequence`=7, `widget`='vote.backend.widgets.answerList.AnswerListWidget', `caption`='Варианты ответов', `field_name`=NULL, `add_parameter`='2', `default_value`=NULL, `not_null`=0, `sql_parameter`='VoteAnswerVisualElement', `is_unique`=0, `group_type`=0, `need_locale`=0, `search`=0, `is_additional`=0, `hint`='' WHERE `da_object_parameters`.`id_object`='105' AND `da_object_parameters`.`id_parameter`='532'"); $this->execute("UPDATE `da_object` SET `yii_model`='vote.models.Voting' WHERE `da_object`.`id_object`='105'"); $path = dirname(__FILE__) . "/../../assets/"; @HFile::removeDirectoryRecursive($path, false, false, false, array(".gitignore")); }
public function safeUp() { $this->execute("ALTER TABLE `da_object_parameters` CHANGE `not_null` `not_null` TINYINT(1) default '1' COMMENT 'Обязательное'"); $this->execute("ALTER TABLE `da_object_parameters` CHANGE `is_unique` `is_unique` TINYINT(1) COMMENT 'Уникальное'"); $path = dirname(__FILE__) . "/../../assets/"; HFile::removeDirectoryRecursive($path, false, false, false); }
public function safeUp() { $this->execute("UPDATE `da_object_parameters` SET `id_object`=31, `id_parameter`=286, `id_parameter_type`=10, `sequence`=8, `name`='ngin.yiigin.DomainLocalizationVisualElement', `caption`='Доступные локализации', `field_name`='engine/admin/element/abstract/DomainLocalization.php', `add_parameter`=2, `default_value`=NULL, `not_null`=0, `sql_parameter`='DomainLocalization', `is_unique`=0, `group_type`=0, `need_locale`=0, `search`=0, `is_additional`=0, `hint`=NULL WHERE `da_object_parameters`.`id_object`=31 AND `da_object_parameters`.`id_parameter`=286"); $this->execute("UPDATE `da_object_parameters` SET `id_object`=21, `id_parameter`=76, `id_parameter_type`=7, `sequence`=1, `name`='ngin.yiigin.objectParameter.typeObjectParameterWidget.TypeObjectParameterWidget', `caption`='Тип свойства', `field_name`='id_parameter_type', `add_parameter`=22, `default_value`='2', `not_null`=1, `sql_parameter`=NULL, `is_unique`=0, `group_type`=0, `need_locale`=0, `search`=0, `is_additional`=0, `hint`=NULL WHERE `da_object_parameters`.`id_object`=21 AND `da_object_parameters`.`id_parameter`=76"); $this->execute("UPDATE `da_object_parameters` SET `id_object`=20, `id_parameter`=68, `id_parameter_type`=7, `sequence`=9, `name`='id_field_caption', `caption`='Свойство для отображения', `field_name`='id_field_caption', `add_parameter`=21, `default_value`='', `not_null`=0, `sql_parameter`='t.id_object=:id_instance', `is_unique`=0, `group_type`=0, `need_locale`=0, `search`=0, `is_additional`=0, `hint`='Значение данного свойства будет выводится в списке, когда экземпляр данного объекта будет выбираться в качестве свойства другого объекта' WHERE `da_object_parameters`.`id_object`=20 AND `da_object_parameters`.`id_parameter`=68"); $this->execute("UPDATE `da_object_parameters` SET `id_object`=20, `id_parameter`=65, `id_parameter_type`=7, `sequence`=10, `name`='id_field_order', `caption`='Свойство для порядка', `field_name`='id_field_order', `add_parameter`=21, `default_value`='', `not_null`=0, `sql_parameter`='t.id_object=:id_instance', `is_unique`=0, `group_type`=0, `need_locale`=0, `search`=0, `is_additional`=0, `hint`='По умолчанию выводимые в системе администрирования экземпляры данного объекта будут упорядочены по этому свойству' WHERE `da_object_parameters`.`id_object`=20 AND `da_object_parameters`.`id_parameter`=65"); $this->execute("UPDATE `da_object` SET `id_object`=21, `name`='Свойства объекта', `id_field_order`=77, `order_type`=1, `table_name`='da_object_parameters', `id_field_caption`=79, `object_type`=1, `folder_name`='', `parent_object`=20, `sequence`=2, `seq_start_value`=1500, `use_domain_isolation`=0, `id_object_handler`=NULL, `id_instance_class`=NULL, `field_caption`='caption', `yii_model`='ngin.models.object.ObjectParameter' WHERE `da_object`.`id_object`=21"); $this->execute("DELETE FROM `da_php_script_type` WHERE `da_php_script_type`.`id_php_script_type`=407"); $this->execute("UPDATE `da_object_parameters` SET `id_object`=66, `id_parameter`=420, `id_parameter_type`=7, `sequence`=7, `name`='ngin.yiigin.objectParameter.selectObjectParameterWidget.SelectObjectParameterWidget', `caption`='Параметр объекта', `field_name`='id_object_parameter', `add_parameter`=21, `default_value`='', `not_null`=0, `sql_parameter`='', `is_unique`=0, `group_type`=0, `need_locale`=0, `search`=0, `is_additional`=0, `hint`='' WHERE `da_object_parameters`.`id_object`=66 AND `da_object_parameters`.`id_parameter`=420"); $this->execute("UPDATE `da_object` SET `id_object`=66, `name`='Колонка представления', `id_field_order`=419, `order_type`=1, `table_name`='da_object_view_column', `id_field_caption`=NULL, `object_type`=1, `folder_name`='', `parent_object`=63, `sequence`=9, `seq_start_value`=6000, `use_domain_isolation`=0, `id_object_handler`=NULL, `id_instance_class`=NULL, `field_caption`=NULL, `yii_model`='ngin.models.object.DaObjectViewColumn' WHERE `da_object`.`id_object`=66"); $this->execute("DELETE FROM `da_php_script_type` WHERE `da_php_script_type`.`id_php_script_type`=421"); $this->execute("UPDATE `da_object` SET `id_object`=93, `name`='Настройка загрузки файлов', `id_field_order`=NULL, `order_type`=1, `table_name`='da_file_upload_settings', `id_field_caption`=NULL, `object_type`=1, `folder_name`='', `parent_object`=1, `sequence`=33, `seq_start_value`=1, `use_domain_isolation`=0, `id_object_handler`=NULL, `id_instance_class`=NULL, `field_caption`=NULL, `yii_model`=NULL WHERE `da_object`.`id_object`=93"); $this->execute("DELETE FROM `da_php_script_type` WHERE `da_php_script_type`.`id_php_script_type`=425"); $this->execute("DELETE FROM `da_php_script_interface` WHERE `da_php_script_interface`.`id_php_script_interface`=12"); $this->execute("DELETE FROM `da_php_script_interface` WHERE `da_php_script_interface`.`id_php_script_interface`=11"); $this->execute("DELETE FROM `da_php_script_interface` WHERE `da_php_script_interface`.`id_php_script_interface`=10"); $this->execute("UPDATE `da_object_parameters` SET `id_object`=20, `id_parameter`=151, `id_parameter_type`=10, `sequence`=19, `name`='perm', `caption`='Права доступа', `field_name`='ngin.yiigin.object.objectPermission.ObjectPermissionWidget', `add_parameter`=2, `default_value`='', `not_null`=0, `sql_parameter`='ObjectPermissionVisualElement', `is_unique`=0, `group_type`=0, `need_locale`=0, `search`=0, `is_additional`=0, `hint`='' WHERE `da_object_parameters`.`id_object`=20 AND `da_object_parameters`.`id_parameter`=151"); $this->execute("UPDATE `da_object_parameters` SET `id_object`=20, `id_parameter`=62, `id_parameter_type`=10, `sequence`=15, `name`='representation', `caption`='Создать представление', `field_name`='ngin.yiigin.object.objectManageView.ObjectManageViewWidget', `add_parameter`=2, `default_value`='', `not_null`=0, `sql_parameter`='ObjectRepresentationVisualElement', `is_unique`=0, `group_type`=0, `need_locale`=0, `search`=0, `is_additional`=1, `hint`='' WHERE `da_object_parameters`.`id_object`=20 AND `da_object_parameters`.`id_parameter`=62"); $this->execute("DELETE FROM `da_object_parameters` WHERE `da_object_parameters`.`id_object`=20 AND `da_object_parameters`.`id_parameter`=126"); $this->execute("UPDATE `da_object_parameters` SET `id_object`=101, `id_parameter`=14, `id_parameter_type`=10, `sequence`=10, `name`='modules', `caption`='Модули', `field_name`='menu.yiigin.widgets.manageModule.ManageModuleWidget', `add_parameter`=2, `default_value`='', `not_null`=0, `sql_parameter`='SiteModuleTemplateListOfModule', `is_unique`=0, `group_type`=0, `need_locale`=0, `search`=0, `is_additional`=0, `hint`='' WHERE `da_object_parameters`.`id_object`=101 AND `da_object_parameters`.`id_parameter`=14"); $this->execute("UPDATE `da_object` SET `id_object`=101, `name`='Наборы модулей', `id_field_order`=16, `order_type`=2, `table_name`='da_site_module_template', `id_field_caption`=13, `object_type`=1, `folder_name`='', `parent_object`=102, `sequence`=7, `seq_start_value`=1, `use_domain_isolation`=0, `id_object_handler`=NULL, `id_instance_class`=NULL, `field_caption`='name', `yii_model`='SiteModuleTemplate' WHERE `da_object`.`id_object`=101"); $this->execute("UPDATE `da_object` SET `id_object`=89, `name`='Очистить кэш', `id_field_order`=NULL, `order_type`=1, `table_name`='yiigin/special/clearCache', `id_field_caption`=NULL, `object_type`=3, `folder_name`='', `parent_object`=3, `sequence`=2, `seq_start_value`=1, `use_domain_isolation`=0, `id_object_handler`=NULL, `id_instance_class`=NULL, `field_caption`=NULL, `yii_model`='' WHERE `da_object`.`id_object`=89"); $this->execute("UPDATE `da_object` SET `id_object`=94, `name`='Логи', `id_field_order`=NULL, `order_type`=1, `table_name`='yiigin/special/logView', `id_field_caption`=NULL, `object_type`=3, `folder_name`='', `parent_object`=3, `sequence`=12, `seq_start_value`=1, `use_domain_isolation`=0, `id_object_handler`=NULL, `id_instance_class`=NULL, `field_caption`=NULL, `yii_model`='' WHERE `da_object`.`id_object`=94"); $this->execute("UPDATE `da_object` SET `id_object`=60, `name`='Проверка файлов', `id_field_order`=NULL, `order_type`=1, `table_name`='yiigin/special/clearPreview', `id_field_caption`=NULL, `object_type`=3, `folder_name`='', `parent_object`=3, `sequence`=4, `seq_start_value`=1, `use_domain_isolation`=0, `id_object_handler`=NULL, `id_instance_class`=NULL, `field_caption`=NULL, `yii_model`='' WHERE `da_object`.`id_object`=60"); $this->execute("UPDATE `da_object` SET `id_object`=91, `name`='Поисковый индекс', `id_field_order`=NULL, `order_type`=1, `table_name`='yiigin/special/recreateSearchIndex', `id_field_caption`=NULL, `object_type`=3, `folder_name`='', `parent_object`=3, `sequence`=3, `seq_start_value`=1, `use_domain_isolation`=0, `id_object_handler`=NULL, `id_instance_class`=NULL, `field_caption`=NULL, `yii_model`='' WHERE `da_object`.`id_object`=91"); $this->execute("DELETE FROM `da_object_parameters` WHERE `da_object_parameters`.`id_object`=261 AND `da_object_parameters`.`id_parameter`=1316"); $this->execute("DELETE FROM `da_object_parameters` WHERE `da_object_parameters`.`id_object`=260 AND `da_object_parameters`.`id_parameter`=1308"); $this->execute("UPDATE `da_object_parameters` SET `id_object`=260, `id_parameter`=1307, `id_parameter_type`=10, `sequence`=9, `name`='statBanner', `caption`='Статистика', `field_name`='banners.yiigin.widgets.bannerStatistic.BannerStatisticWidget', `add_parameter`=2, `default_value`='', `not_null`=0, `sql_parameter`='BannerStatisticVisualElement', `is_unique`=0, `group_type`=0, `need_locale`=0, `search`=0, `is_additional`=0, `hint`='' WHERE `da_object_parameters`.`id_object`=260 AND `da_object_parameters`.`id_parameter`=1307"); $path = dirname(__FILE__) . "/../../assets/"; HFile::removeDirectoryRecursive($path, false, false, false, array(".gitignore")); }
public function safeUp() { $this->execute("ALTER TABLE `da_object` CHANGE `id_object` `id_object` INT( 3 ) NOT NULL AUTO_INCREMENT"); $this->execute("ALTER TABLE `pr_photogallery_photo` CHANGE `id_photogallery_photo` `id_photogallery_photo` INT( 8 ) NOT NULL AUTO_INCREMENT"); $this->execute("ALTER TABLE `da_object_parameters` CHANGE `id_parameter` `id_parameter` INT( 8 ) NOT NULL AUTO_INCREMENT"); $this->execute("ALTER TABLE `da_job` CHANGE `id_job` `id_job` INT( 8 ) NOT NULL AUTO_INCREMENT"); $this->execute("ALTER TABLE `da_object_view` CHANGE `id_object_view` `id_object_view` INT( 8 ) NOT NULL AUTO_INCREMENT"); $this->execute("ALTER TABLE `da_object_view_column` CHANGE `id_object_view_column` `id_object_view_column` INT( 8 ) NOT NULL AUTO_INCREMENT"); $this->execute("ALTER TABLE `da_php_script_interface` CHANGE `id_php_script_interface` `id_php_script_interface` INT( 8 ) NOT NULL AUTO_INCREMENT"); $this->execute("ALTER TABLE `da_php_script_type` CHANGE `id_php_script_type` `id_php_script_type` INT( 8 ) NOT NULL AUTO_INCREMENT"); $this->execute("ALTER TABLE `da_references` CHANGE `id_reference` `id_reference` INT( 8 ) NOT NULL AUTO_INCREMENT"); $this->execute("ALTER TABLE `da_reference_element` CHANGE `id_reference_element_instance` `id_reference_element_instance` INT( 8 ) NOT NULL AUTO_INCREMENT"); // $this->execute("ALTER TABLE `da_reference_element` DROP INDEX `id_reference_2`"); $this->execute("ALTER TABLE `da_rss` CHANGE `id_rss` `id_rss` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT"); $this->execute("ALTER TABLE `da_site_module_template` CHANGE `id_module_template` `id_module_template` INT( 8 ) NOT NULL AUTO_INCREMENT"); $this->execute("ALTER TABLE `da_system_parameter` CHANGE `id_system_parameter` `id_system_parameter` INT( 8 ) NOT NULL AUTO_INCREMENT"); $this->execute("ALTER TABLE `pr_news` CHANGE `id_news` `id_news` INT( 8 ) NOT NULL AUTO_INCREMENT"); $this->execute("ALTER TABLE `pr_news_category` CHANGE `id_news_category` `id_news_category` INT( 8 ) NOT NULL AUTO_INCREMENT"); $this->execute("ALTER TABLE `pr_photogallery` CHANGE `id_photogallery` `id_photogallery` INT( 8 ) NOT NULL AUTO_INCREMENT"); $this->execute("ALTER TABLE `pr_product` CHANGE `id_product` `id_product` INT( 8 ) NOT NULL AUTO_INCREMENT"); $this->execute("ALTER TABLE `pr_product_brand` CHANGE `id_brand` `id_brand` INT( 8 ) NOT NULL AUTO_INCREMENT"); $this->execute("ALTER TABLE `pr_product_category` CHANGE `id_product_category` `id_product_category` INT( 8 ) NOT NULL AUTO_INCREMENT"); $this->execute("ALTER TABLE `pr_quiz` CHANGE `id_quiz` `id_quiz` INT( 8 ) NOT NULL AUTO_INCREMENT"); $this->execute("ALTER TABLE `pr_quiz_answer` CHANGE `id_quiz_answer` `id_quiz_answer` INT( 8 ) NOT NULL AUTO_INCREMENT"); $this->execute("ALTER TABLE `pr_quiz_question` CHANGE `id_quiz_question` `id_quiz_question` INT( 8 ) NOT NULL AUTO_INCREMENT"); $this->execute("ALTER TABLE `pr_vitrine` CHANGE `id_vitrine` `id_vitrine` INT( 8 ) NOT NULL AUTO_INCREMENT"); $this->execute("ALTER TABLE `pr_voting` CHANGE `id_voting` `id_voting` INT( 8 ) NOT NULL AUTO_INCREMENT"); $this->execute("ALTER TABLE `pr_voting_answer` CHANGE `id_voting_answer` `id_voting_answer` INT( 8 ) NOT NULL AUTO_INCREMENT"); // $this->execute("ALTER TABLE `da_site_theme` DROP `active`"); // $this->execute("ALTER TABLE `da_site_theme` DROP `id_site_theme`"); $this->execute("DROP TABLE IF EXISTS `da_site_theme`"); $path = dirname(__FILE__) . "/../../assets/"; HFile::removeDirectoryRecursive($path, false); }
public function safeUp() { $this->execute("UPDATE `da_php_script_type` SET `id_php_script_type`=401, `file_path`='engine/process_class/MenuProcessGlobal.php', `class_name`='MenuProcessGlobal', `description`='MenuProcessGlobal', `id_php_script_interface`=12 WHERE `da_php_script_type`.`id_php_script_type`=401"); $this->execute("UPDATE `da_php_script_type` SET `id_php_script_type`=404, `file_path`='engine/process_class/UserProcessGlobal.php', `class_name`='UserProcessGlobal', `description`='UserProcessGlobal', `id_php_script_interface`=12 WHERE `da_php_script_type`.`id_php_script_type`=404"); $path = dirname(__FILE__) . "/../../assets/"; HFile::removeDirectoryRecursive($path, false, false, false); }
public function safeUp() { $this->execute("UPDATE da_object SET sequence = '7', name = 'Данные агрегатора', object_type = '1', table_name = 'da_aggregator_data', folder_name = NULL, field_caption = 'create_date', id_field_caption = NULL, id_field_order = NULL, order_type = '1', seq_start_value = '1', yii_model = NULL, id_object_handler = NULL, id_instance_class = NULL, parent_object = '5', use_domain_isolation = '0' WHERE id_object=79"); $this->execute("DELETE FROM `da_auth_item` WHERE `da_auth_item`.`name` = 'create_object_81' LIMIT 1"); $path = dirname(__FILE__) . "/../../assets/"; HFile::removeDirectoryRecursive($path, false); }
public function safeUp() { $this->execute("ALTER TABLE `da_site_module` DROP `directory`"); $this->execute("ALTER TABLE `da_menu` DROP `directory`"); $path = dirname(__FILE__) . "/../../assets/"; @HFile::removeDirectoryRecursive($path, false, false, false, array(".gitignore")); }
public function safeUp() { $this->execute("ALTER TABLE `da_users` DROP `id_group`"); $this->execute("ALTER TABLE `da_users` CHANGE `mail` `mail` VARCHAR(255) NOT NULL"); $path = dirname(__FILE__) . "/../../assets/"; HFile::removeDirectoryRecursive($path, false, false, false); }
public function safeUp() { $this->execute("INSERT INTO `da_object_parameters` (`id_parameter_type`, `sequence`, `not_null`, `need_locale`, `search`, `is_additional`, `visible`, `id_object`, `group_type`, `caption`, `field_name`, `id_parameter`, `widget`, `add_parameter`, `sql_parameter`, `default_value`, `is_unique`, `hint`) VALUES (14, 0, 0, 0, 0, 0, 1, '63', 0, 'Описание представления', 'description', 'ygin-object-view-description', NULL, NULL, NULL, NULL, 0, 'Данное описание будет выводится в списке экземпляров сразу после заголовка представления. Служит для подробного описания назначения объекта и представления.')"); $this->execute("UPDATE da_object_parameters SET sequence = 292 WHERE id_parameter='ygin-object-view-description'"); $this->execute("UPDATE `da_object_view` SET `id_object_view`='43', `id_object`='63', `name`='Представление', `order_no`=1, `visible`=0, `sql_select`=NULL, `sql_from`=NULL, `sql_where`=NULL, `sql_order_by`='order_no ASC', `count_data`=50, `icon_class`=NULL, `id_parent`=NULL, `description`='<p>Для получения возможности редактирования экземпляров объекта (осуществления CRUD-операций) необходимо создать представление. Один объект может иметь множество представлений. Представление хранит информацию о свойствах объекта, отображаемых в списке экземпляров, а также о порядке их сортировки.</p> <p>Быстро создать представление для объекта и его колонки можно при редактировании объекта в блоке Создать представление. Подробнее читай в <a target=\"_blank\" href=\"http://www.ygin.ru/documentation/sozdanie-predstavlenii-obekta-17/\">документации</a> к системе.</p>' WHERE `da_object_view`.`id_object_view`='43'"); $path = dirname(__FILE__) . "/../../assets/"; @HFile::removeDirectoryRecursive($path, false, false, false, array(".gitignore")); }
public function safeUp() { $this->execute("UPDATE `da_object_parameters` SET `id_object`=100, `id_parameter`=549, `id_parameter_type`=10, `sequence`=6, `widget`='menu.yiigin.widgets.externalLink.ExternalLinkWidget', `caption`='Ссылка на страницу', `field_name`='external_link', `add_parameter`=2, `default_value`='', `not_null`=0, `sql_parameter`='MenuHref', `is_unique`=0, `group_type`=0, `need_locale`=0, `search`=0, `is_additional`=1, `hint`='При отображении в меню раздел будет иметь указанную ссылку. Используется для создания внешних ссылок в меню или прямых ссылок на файл (например, прайс).' WHERE `da_object_parameters`.`id_object`=100 AND `da_object_parameters`.`id_parameter`=549"); $this->execute("UPDATE `da_object_parameters` SET `id_object`=100, `id_parameter`=2, `id_parameter_type`=2, `sequence`=2, `widget`='menu.yiigin.widgets.menuName.MenuNameWidget', `caption`='Название в меню', `field_name`='name', `add_parameter`=0, `default_value`='Имя раздела', `not_null`=1, `sql_parameter`='', `is_unique`=0, `group_type`=0, `need_locale`=1, `search`=1, `is_additional`=0, `hint`='Краткое название раздела, отображаемое в меню сайта' WHERE `da_object_parameters`.`id_object`=100 AND `da_object_parameters`.`id_parameter`=2"); $this->execute("UPDATE `da_object_parameters` SET `id_object`=103, `id_parameter`=544, `id_parameter_type`=10, `sequence`=4, `widget`='menu.yiigin.widgets.phpScript.PhpScriptWidget', `caption`='Обработчик', `field_name`='link', `add_parameter`=2, `default_value`='', `not_null`=0, `sql_parameter`='', `is_unique`=0, `group_type`=0, `need_locale`=0, `search`=0, `is_additional`=0, `hint`='' WHERE `da_object_parameters`.`id_object`=103 AND `da_object_parameters`.`id_parameter`=544"); $path = dirname(__FILE__) . "/../../assets/"; @HFile::removeDirectoryRecursive($path, false, false, false, array(".gitignore")); }
public function safeUp() { $this->execute("UPDATE da_object SET name = 'Меню', folder_name = 'content/menu' WHERE id_object=100"); $this->execute("UPDATE da_object_parameters SET id_parameter_type = '2', caption = 'Спрашивающий', id_object = '512', sequence = '3', name = 'name', field_name = 'name', add_parameter = NULL, sql_parameter = NULL, default_value = NULL, not_null = '1', need_locale = '0', search = '0', is_unique = '0', group_type = '0', is_additional = '0', hint = NULL WHERE id_parameter=1580"); $this->execute("UPDATE da_object_parameters SET id_parameter_type = '14', caption = 'Вопрос', id_object = '512', sequence = '5', name = 'question', field_name = 'question', add_parameter = NULL, sql_parameter = NULL, default_value = NULL, not_null = '1', need_locale = '0', search = '1', is_unique = '0', group_type = '0', is_additional = '0', hint = NULL WHERE id_parameter=1581"); $path = dirname(__FILE__) . "/../../assets/"; HFile::removeDirectoryRecursive($path, false); }
public function safeUp() { $this->execute("DELETE FROM `da_object_view_column` WHERE `da_object_view_column`.`id_object_view_column`='108'"); $this->execute("DELETE FROM `da_object_parameters` WHERE `da_object_parameters`.`id_object`='80' AND `da_object_parameters`.`id_parameter`='340'"); $this->execute("UPDATE `da_object_parameters` SET `id_object`='80', `id_parameter`='339', `id_parameter_type`=2, `sequence`=5, `widget`=NULL, `caption`='Алиас', `field_name`='file_path', `add_parameter`=NULL, `default_value`=NULL, `not_null`=1, `sql_parameter`=NULL, `is_unique`=0, `group_type`=0, `need_locale`=0, `search`=0, `is_additional`=0, `hint`='' WHERE `da_object_parameters`.`id_object`='80' AND `da_object_parameters`.`id_parameter`='339'"); $path = dirname(__FILE__) . "/../../assets/"; @HFile::removeDirectoryRecursive($path, false, false, false, array(".gitignore")); }
public function safeUp() { $this->execute("ALTER TABLE `da_site_module_template` COMMENT='Наборы виджетов'"); $this->execute("ALTER TABLE `da_site_module` COMMENT='Виджеты сайта'"); $this->execute("ALTER TABLE `da_site_module_template` CHANGE `is_default_template` `is_default_template` TINYINT(1) NOT NULL default '0' COMMENT 'Использовать по умолчанию'"); $this->execute("ALTER TABLE `da_menu` CHANGE `removable` `removable` TINYINT(1) NOT NULL default '1' COMMENT 'Разрешить удаление'"); $path = dirname(__FILE__) . "/../../assets/"; @HFile::removeDirectoryRecursive($path, false, false, false, array(".gitignore")); }
public function safeUp() { $this->execute("UPDATE da_php_script_type SET file_path=replace(file_path, 'yiigin', 'backend')"); $this->execute("UPDATE da_object_parameters SET widget=replace(widget, 'yiigin', 'backend')"); $this->execute("UPDATE da_object SET table_name=replace(table_name, 'yiigin', 'backend')"); $this->execute("UPDATE da_object SET yii_model=replace(yii_model, 'yiigin', 'backend')"); $path = dirname(__FILE__) . "/../../assets/"; @HFile::removeDirectoryRecursive($path, false, false, false, array(".gitignore")); }
public function safeUp() { $this->execute("UPDATE `da_object` SET `id_object_handler`=NULL, `id_instance_class`=NULL WHERE `da_object`.`id_object`=503"); $this->execute("DELETE FROM `da_php_script_type` WHERE `da_php_script_type`.`id_php_script_type`=1022"); $this->execute("DELETE FROM `da_php_script_type` WHERE `da_php_script_type`.`id_php_script_type`=1023"); $this->execute("UPDATE `da_object_parameters` SET `id_object`=31, `id_parameter`=286, `id_parameter_type`=10, `sequence`=8, `name`='ngin.yiigin.DomainLocalizationVisualElement', `caption`='Доступные локализации', `field_name`='engine/admin/element/abstract/DomainLocalization.php', `add_parameter`=2, `default_value`=NULL, `not_null`=0, `sql_parameter`='DomainLocalization', `is_unique`=0, `group_type`=0, `need_locale`=0, `search`=0, `is_additional`=0, `hint`=NULL WHERE `da_object_parameters`.`id_object`=31 AND `da_object_parameters`.`id_parameter`=286"); $path = dirname(__FILE__) . "/../../assets/"; HFile::removeDirectoryRecursive($path, false, false, false); }
public function safeUp() { $this->execute("INSERT INTO `da_php_script_type` (`id_php_script_type`, `active`, `id_php_script_interface`, `description`, `file_path`, `class_name`) VALUES (1046, 1, 1, 'Текст без тегов и заменой nl на br', 'yiigin.components.column.abstract.StrippedColumn', 'StrippedColumn');"); $this->execute("UPDATE `da_php_script_type` SET `id_php_script_type`=1046, `file_path`='yiigin.components.column.abstract.StrippedColumn', `class_name`='StrippedColumn', `description`='Текст без тегов и заменой nl на br', `id_php_script_interface`=6, `active`=1 WHERE `da_php_script_type`.`id_php_script_type`=1046;"); $this->execute("INSERT INTO `da_object_view_column` (`id_object_view_column`, `order_no`, `id_data_type`, `visible`, `id_object_view`, `id_object`, `caption`, `id_object_parameter`, `field_name`, `handler`) VALUES (6093, 0, 10, 1, 67, 250, 'Комментарий', 1207, 'comment_text', 1046);"); $this->execute("UPDATE da_object_view_column SET order_no = 22 WHERE id_object_view_column='6093';"); $path = dirname(__FILE__) . "/../../assets/"; HFile::removeDirectoryRecursive($path, false, false, false, array(".gitignore")); }
public function safeUp() { $this->execute("UPDATE `da_system_parameter` SET `id_group_system_parameter`=1 WHERE `da_system_parameter`.`id_system_parameter`='6'"); $this->execute("UPDATE `da_system_parameter` SET `id_group_system_parameter`=1 WHERE `da_system_parameter`.`id_system_parameter`='31'"); $this->execute("UPDATE `da_system_parameter` SET `id_group_system_parameter`=1 WHERE `da_system_parameter`.`id_system_parameter`='32'"); $this->execute("UPDATE `da_system_parameter` SET `id_group_system_parameter`=1 WHERE `da_system_parameter`.`id_system_parameter`='101'"); $path = dirname(__FILE__) . "/../../assets/"; @HFile::removeDirectoryRecursive($path, false, false, false, array(".gitignore")); }
public function safeUp() { $this->execute("TRUNCATE TABLE `da_object_instance`"); $this->execute("DELETE FROM da_search_data WHERE id_object=66 AND id_instance='48'"); $this->execute("DELETE FROM `da_object_view_column` WHERE `da_object_view_column`.`id_object_view_column`='48'"); $this->execute("DELETE FROM da_search_data WHERE id_object=66 AND id_instance='49'"); $this->execute("DELETE FROM `da_object_view_column` WHERE `da_object_view_column`.`id_object_view_column`='49'"); $this->execute("DELETE FROM da_search_data WHERE id_object=66 AND id_instance='50'"); $this->execute("DELETE FROM `da_object_view_column` WHERE `da_object_view_column`.`id_object_view_column`='50'"); $this->execute("DELETE FROM da_search_data WHERE id_object=63 AND id_instance='24'"); $this->execute("DELETE FROM `da_object_view` WHERE `da_object_view`.`id_object_view`='24'"); $this->execute("UPDATE `da_object` SET `id_object`='42', `name`='RSS', `id_field_order`='', `order_type`=1, `table_name`='da_rss', `id_field_caption`='', `object_type`=1, `folder_name`=NULL, `parent_object`=1, `sequence`=13, `use_domain_isolation`=0, `field_caption`=NULL, `yii_model`=NULL WHERE `da_object`.`id_object`='42'"); $this->execute("DELETE FROM da_search_data WHERE id_object=21 AND id_instance='603'"); $this->execute("DELETE FROM `da_object_parameters` WHERE `da_object_parameters`.`id_object`='42' AND `da_object_parameters`.`id_parameter`='603'"); $this->execute("DELETE FROM da_search_data WHERE id_object=21 AND id_instance='604'"); $this->execute("DELETE FROM `da_object_parameters` WHERE `da_object_parameters`.`id_object`='42' AND `da_object_parameters`.`id_parameter`='604'"); $this->execute("DELETE FROM da_search_data WHERE id_object=21 AND id_instance='605'"); $this->execute("DELETE FROM `da_object_parameters` WHERE `da_object_parameters`.`id_object`='42' AND `da_object_parameters`.`id_parameter`='605'"); $this->execute("DELETE FROM da_search_data WHERE id_object=21 AND id_instance='607'"); $this->execute("DELETE FROM `da_object_parameters` WHERE `da_object_parameters`.`id_object`='42' AND `da_object_parameters`.`id_parameter`='607'"); $this->execute("DELETE FROM da_search_data WHERE id_object=21 AND id_instance='608'"); $this->execute("DELETE FROM `da_object_parameters` WHERE `da_object_parameters`.`id_object`='42' AND `da_object_parameters`.`id_parameter`='608'"); $this->execute("DELETE FROM da_search_data WHERE id_object=21 AND id_instance='609'"); $this->execute("DELETE FROM `da_object_parameters` WHERE `da_object_parameters`.`id_object`='42' AND `da_object_parameters`.`id_parameter`='609'"); $this->execute("DELETE FROM da_search_data WHERE id_object=21 AND id_instance='611'"); $this->execute("DELETE FROM `da_object_parameters` WHERE `da_object_parameters`.`id_object`='42' AND `da_object_parameters`.`id_parameter`='611'"); $this->execute("DELETE FROM da_search_data WHERE id_object=21 AND id_instance='612'"); $this->execute("DELETE FROM `da_object_parameters` WHERE `da_object_parameters`.`id_object`='42' AND `da_object_parameters`.`id_parameter`='612'"); $this->execute("DELETE FROM da_search_data WHERE id_object=21 AND id_instance='613'"); $this->execute("DELETE FROM `da_object_parameters` WHERE `da_object_parameters`.`id_object`='42' AND `da_object_parameters`.`id_parameter`='613'"); $this->execute("DELETE FROM da_search_data WHERE id_object=21 AND id_instance='614'"); $this->execute("DELETE FROM `da_object_parameters` WHERE `da_object_parameters`.`id_object`='42' AND `da_object_parameters`.`id_parameter`='614'"); $this->execute("DELETE FROM da_search_data WHERE id_object=21 AND id_instance='615'"); $this->execute("DELETE FROM `da_object_parameters` WHERE `da_object_parameters`.`id_object`='42' AND `da_object_parameters`.`id_parameter`='615'"); $this->execute("DELETE FROM da_search_data WHERE id_object=21 AND id_instance='635'"); $this->execute("DELETE FROM `da_object_parameters` WHERE `da_object_parameters`.`id_object`='42' AND `da_object_parameters`.`id_parameter`='635'"); $this->execute("DELETE FROM da_search_data WHERE id_object=21 AND id_instance='636'"); $this->execute("DELETE FROM `da_object_parameters` WHERE `da_object_parameters`.`id_object`='42' AND `da_object_parameters`.`id_parameter`='636'"); $this->execute("DELETE FROM da_search_data WHERE id_object=21 AND id_instance='637'"); $this->execute("DELETE FROM `da_object_parameters` WHERE `da_object_parameters`.`id_object`='42' AND `da_object_parameters`.`id_parameter`='637'"); $this->execute("DELETE FROM da_search_data WHERE id_object=21 AND id_instance='610'"); $this->execute("DELETE FROM `da_object_parameters` WHERE `da_object_parameters`.`id_object`='42' AND `da_object_parameters`.`id_parameter`='610'"); $this->execute("DELETE FROM da_search_data WHERE id_object=21 AND id_instance='602'"); $this->execute("DELETE FROM `da_object_parameters` WHERE `da_object_parameters`.`id_object`='42' AND `da_object_parameters`.`id_parameter`='602'"); $this->execute("DELETE FROM `da_auth_item` WHERE name='create_object_42'"); $this->execute("DELETE FROM `da_auth_item` WHERE name='edit_object_42'"); $this->execute("DELETE FROM `da_auth_item` WHERE name='list_object_42'"); $this->execute("DELETE FROM da_search_data WHERE id_object=20 AND id_instance='42'"); $this->execute("DELETE FROM `da_object` WHERE `da_object`.`id_object`='42'"); $this->execute("UPDATE `da_object_parameters` SET `id_object`='103', `id_parameter`='544', `id_parameter_type`=10, `sequence`=4, `widget`='menu.backend.widgets.phpScript.PhpScriptWidget', `caption`='Обработчик', `field_name`='id_php_script', `add_parameter`='2', `default_value`=NULL, `not_null`=0, `sql_parameter`=NULL, `is_unique`=0, `group_type`=0, `need_locale`=0, `search`=0, `is_additional`=0, `hint`='' WHERE `da_object_parameters`.`id_object`='103' AND `da_object_parameters`.`id_parameter`='544'"); $this->execute("UPDATE `da_object_parameters` SET `id_object`='ygin.menu', `id_parameter`='6', `id_parameter_type`=12, `sequence`=14, `widget`=NULL, `caption`='Смена родительского раздела', `field_name`='id_parent', `add_parameter`='1', `default_value`=NULL, `not_null`=0, `sql_parameter`=NULL, `is_unique`=0, `group_type`=0, `need_locale`=0, `search`=0, `is_additional`=1, `hint`='' WHERE `da_object_parameters`.`id_object`='ygin.menu' AND `da_object_parameters`.`id_parameter`='6'"); $this->execute("UPDATE `da_object` SET `id_object`='ygin.menu', `name`='Меню', `id_field_order`='', `order_type`=1, `table_name`='da_menu', `id_field_caption`='7', `object_type`=1, `folder_name`='content/menu', `parent_object`=4, `sequence`=1, `use_domain_isolation`=0, `field_caption`='name', `yii_model`='Menu' WHERE `da_object`.`id_object`='ygin.menu'"); $this->execute("UPDATE `da_object_view` SET `id_object_view`='ygin.menu.view.main', `id_object`='ygin.menu', `name`='Меню', `order_no`=1, `visible`=1, `sql_select`='external_link, go_to_type, alias, id_parent, content', `sql_from`=NULL, `sql_where`=NULL, `sql_order_by`='sequence ASC', `count_data`=50, `icon_class`='icon-list-alt', `id_parent`='id_parent' WHERE `da_object_view`.`id_object_view`='54'"); $this->execute("UPDATE `da_object_view_column` SET `id_object_view`='ygin.menu.view.main' WHERE id_object_view='54'"); $path = dirname(__FILE__) . "/../../assets/"; @HFile::removeDirectoryRecursive($path, false, false, false, array(".gitignore")); }
public function safeUp() { $this->execute("UPDATE `da_object` SET `id_object`='ygin.menu', `name`='Меню', `id_field_order`='', `order_type`=1, `table_name`='da_menu', `id_field_caption`='', `object_type`=1, `folder_name`='content/menu', `parent_object`=4, `sequence`=1, `use_domain_isolation`=0, `field_caption`='name', `yii_model`='Menu' WHERE `da_object`.`id_object`='100'"); $this->execute("DELETE FROM `da_auth_item` WHERE name='create_object_100'"); $this->execute("DELETE FROM `da_auth_item` WHERE name='delete_object_100'"); $this->execute("DELETE FROM `da_auth_item` WHERE name='edit_object_100'"); $this->execute("DELETE FROM `da_auth_item` WHERE name='list_object_100'"); $this->execute("INSERT INTO `da_auth_item` (`name`, `type`, `description`, `bizrule`, `data`) VALUES ('edit_object_ygin.menu', 0, 'Операция изменения для объекта Меню', NULL, 'N;')"); $this->execute("INSERT INTO `da_auth_item_child` (`parent`, `child`) VALUES ('dev', 'edit_object_ygin.menu')"); $this->execute("INSERT INTO `da_auth_item` (`name`, `type`, `description`, `bizrule`, `data`) VALUES ('delete_object_ygin.menu', 0, 'Операция удаления для объекта Меню', NULL, 'N;')"); $this->execute("INSERT INTO `da_auth_item_child` (`parent`, `child`) VALUES ('dev', 'delete_object_ygin.menu')"); $this->execute("INSERT INTO `da_auth_item` (`name`, `type`, `description`, `bizrule`, `data`) VALUES ('create_object_ygin.menu', 0, 'Операция создания для объекта Меню', NULL, 'N;')"); $this->execute("INSERT INTO `da_auth_item_child` (`parent`, `child`) VALUES ('dev', 'create_object_ygin.menu')"); $this->execute("INSERT INTO `da_auth_item_child` (`parent`, `child`) VALUES ('editor', 'edit_object_ygin.menu')"); $this->execute("INSERT INTO `da_auth_item_child` (`parent`, `child`) VALUES ('editor', 'delete_object_ygin.menu')"); $this->execute("INSERT INTO `da_auth_item_child` (`parent`, `child`) VALUES ('editor', 'create_object_ygin.menu')"); $this->execute("INSERT INTO `da_auth_item` (`name`, `type`, `description`, `bizrule`, `data`) VALUES ('list_object_ygin.menu', 0, 'Просмотр списка данных объекта Меню', NULL, 'N;')"); $this->execute("INSERT INTO `da_auth_item_child` (`parent`, `child`) VALUES ('dev', 'list_object_ygin.menu')"); $this->execute("INSERT INTO `da_auth_item_child` (`parent`, `child`) VALUES ('editor', 'list_object_ygin.menu')"); $this->execute("UPDATE `da_object_parameters` SET `id_object`='ygin.menu' WHERE id_object='100'"); $this->execute("UPDATE `da_object_parameters` SET `add_parameter`='ygin.menu' WHERE id_parameter_type=7 AND add_parameter='100'"); $this->execute("UPDATE `da_object_view` SET `id_object`='ygin.menu' WHERE id_object='100'"); $this->execute("UPDATE `da_object_view_column` SET `id_object`='ygin.menu' WHERE id_object='100'"); $this->execute("UPDATE `da_files` SET `id_object`='ygin.menu' WHERE id_object='100'"); $this->execute("UPDATE `da_object` SET `id_object`='22', `name`='Типы данных', `id_field_order`='105', `order_type`=1, `table_name`='da_object_parameter_type', `id_field_caption`='86', `object_type`=1, `folder_name`=NULL, `parent_object`=1, `sequence`=13, `use_domain_isolation`=0, `field_caption`='name', `yii_model`=NULL WHERE `da_object`.`id_object`='22'"); $this->execute("INSERT INTO `da_auth_item` (`name`, `type`, `description`, `bizrule`, `data`) VALUES ('edit_object_22', 0, 'Операция изменения для объекта Типы данных', NULL, 'N;')"); $this->execute("INSERT INTO `da_auth_item_child` (`parent`, `child`) VALUES ('dev', 'edit_object_22')"); $this->execute("INSERT INTO `da_auth_item` (`name`, `type`, `description`, `bizrule`, `data`) VALUES ('delete_object_22', 0, 'Операция удаления для объекта Типы данных', NULL, 'N;')"); $this->execute("INSERT INTO `da_auth_item_child` (`parent`, `child`) VALUES ('dev', 'delete_object_22')"); $this->execute("INSERT INTO `da_auth_item` (`name`, `type`, `description`, `bizrule`, `data`) VALUES ('create_object_22', 0, 'Операция создания для объекта Типы данных', NULL, 'N;')"); $this->execute("INSERT INTO `da_auth_item_child` (`parent`, `child`) VALUES ('dev', 'create_object_22')"); $this->execute("INSERT INTO `da_auth_item` (`name`, `type`, `description`, `bizrule`, `data`) VALUES ('list_object_22', 0, 'Просмотр списка данных объекта Типы данных', NULL, 'N;')"); $this->execute("INSERT INTO `da_auth_item_child` (`parent`, `child`) VALUES ('dev', 'list_object_22')"); $this->execute("UPDATE `da_object` SET `id_object`='22', `name`='Типы данных', `id_field_order`='105', `order_type`=1, `table_name`='da_object_parameter_type', `id_field_caption`='86', `object_type`=1, `folder_name`=NULL, `parent_object`=1, `sequence`=13, `use_domain_isolation`=0, `field_caption`='name', `yii_model`=NULL WHERE `da_object`.`id_object`='22'"); $this->execute("INSERT INTO `da_object_view` (`order_no`, `visible`, `count_data`, `id_object_view`, `name`, `id_object`, `sql_order_by`) VALUES (1, 1, 50, '22.view.main', 'Типы данных', '22', 'sequence')"); $this->execute("INSERT INTO `da_object_view_column` (`order_no`, `id_data_type`, `visible`, `id_object_view_column`, `id_object_view`, `id_object`, `id_object_parameter`, `caption`, `field_name`) VALUES (1, 2, 1, '22.view.main.name', '22.view.main', '22', '86', 'Название типа данных', 'name')"); $this->execute("INSERT INTO `da_object_parameters` (`id_parameter_type`, `sequence`, `not_null`, `need_locale`, `search`, `is_additional`, `id_object`, `group_type`, `id_parameter`, `caption`, `field_name`, `widget`, `add_parameter`, `sql_parameter`, `default_value`, `is_unique`, `hint`) VALUES (2, 0, 0, 0, 0, 0, '22', 0, 'ygin.objectParameterType.sqlType', 'sql тип', 'sql_type', NULL, '0', NULL, NULL, 0, '')"); $this->execute("UPDATE da_object_parameters SET sequence = 287 WHERE id_parameter='ygin.objectParameterType.sqlType'"); $this->execute("UPDATE `da_object_parameter_type` SET `id_parameter_type`=11, `sequence`=1, `name`='Первичный ключ', `sql_type`='INT(8)' WHERE `da_object_parameter_type`.`id_parameter_type`=11"); $this->execute("UPDATE `da_object_parameter_type` SET `id_parameter_type`=1, `sequence`=2, `name`='Число', `sql_type`='INT(8)' WHERE `da_object_parameter_type`.`id_parameter_type`=1"); $this->execute("UPDATE `da_object_parameter_type` SET `id_parameter_type`=2, `sequence`=3, `name`='Строка', `sql_type`='VARCHAR(255)' WHERE `da_object_parameter_type`.`id_parameter_type`=2"); $this->execute("UPDATE `da_object_parameter_type` SET `id_parameter_type`=4, `sequence`=4, `name`='Дата', `sql_type`='INT(10) UNSIGNED' WHERE `da_object_parameter_type`.`id_parameter_type`=4"); $this->execute("UPDATE `da_object_parameter_type` SET `id_parameter_type`=9, `sequence`=5, `name`='Логический (bool)', `sql_type`='TINYINT(1)' WHERE `da_object_parameter_type`.`id_parameter_type`=9"); $this->execute("UPDATE `da_object_parameter_type` SET `id_parameter_type`=14, `sequence`=6, `name`='Текст (text area)', `sql_type`='LONGTEXT' WHERE `da_object_parameter_type`.`id_parameter_type`=14"); $this->execute("UPDATE `da_object_parameter_type` SET `id_parameter_type`=3, `sequence`=7, `name`='HTML-редактор', `sql_type`='LONGTEXT' WHERE `da_object_parameter_type`.`id_parameter_type`=3"); $this->execute("UPDATE `da_object_parameter_type` SET `id_parameter_type`=8, `sequence`=8, `name`='Файл', `sql_type`='INT(8)' WHERE `da_object_parameter_type`.`id_parameter_type`=8"); $this->execute("UPDATE `da_object_parameter_type` SET `id_parameter_type`=6, `sequence`=10, `name`='Справочник', `sql_type`='INT(8)' WHERE `da_object_parameter_type`.`id_parameter_type`=6"); $this->execute("UPDATE `da_object_parameter_type` SET `id_parameter_type`=7, `sequence`=11, `name`='Внешний ключ (Объект)', `sql_type`='INT(8)' WHERE `da_object_parameter_type`.`id_parameter_type`=7"); $this->execute("UPDATE `da_object_parameter_type` SET `id_parameter_type`=12, `sequence`=14, `name`='Родительский ключ', `sql_type`='INT(8)' WHERE `da_object_parameter_type`.`id_parameter_type`=12"); $this->execute("UPDATE `da_object_parameter_type` SET `id_parameter_type`=16, `sequence`=15, `name`='Алиас для экземпляра', `sql_type`='VARCHAR(255)' WHERE `da_object_parameter_type`.`id_parameter_type`=16"); $this->execute("UPDATE `da_object_parameter_type` SET `id_parameter_type`=17, `sequence`=16, `name`='Скрытое поле', `sql_type`='VARCHAR(255)' WHERE `da_object_parameter_type`.`id_parameter_type`=17"); $this->execute("UPDATE `da_object_parameter_type` SET `id_parameter_type`=13, `sequence`=17, `name`='Последовательность', `sql_type`='INT(8)' WHERE `da_object_parameter_type`.`id_parameter_type`=13"); $this->execute("UPDATE `da_object_parameter_type` SET `id_parameter_type`=20, `sequence`=20, `name`='Новая дата', `sql_type`='DATETIME' WHERE `da_object_parameter_type`.`id_parameter_type`=20"); $path = dirname(__FILE__) . "/../../assets/"; @HFile::removeDirectoryRecursive($path, false, false, false, array(".gitignore")); }