Тут показані розбіжності між вибраною ревізією та поточною версією сторінки.
Порівняння попередніх версій Попередня ревізія | Попередня ревізія Наступна ревізія По сторонах наступні версії | ||
relnotes [2020/08/08 15:39] |
relnotes [2024/04/25 19:34] nightfly |
||
---|---|---|---|
Рядок 1: | Рядок 1: | ||
+ | **Всі рекомендації (а точніше - суворі вимоги) нижче, слід розуміти як " | ||
+ | у разі ігнорування цих рекомендацій та отриманні після цього вкрай негативних ефектів - ССЗБ. | ||
+ | |||
+ | ====== 1.4.6 ====== | ||
+ | |||
+ | Зміни в структурі БД: | ||
+ | <code sql> | ||
+ | ALTER TABLE `zte_cards` MODIFY COLUMN `card_name` varchar(7) NOT NULL; | ||
+ | </ | ||
+ | |||
+ | ====== 1.4.5 ====== | ||
+ | |||
+ | В конфіг alter.ini необхідно додати наступні опції | ||
+ | <code ini> | ||
+ | ONUAUTO_CONFIG_DLP=0 | ||
+ | ONUAUTO_CONFIG_ELP=0 | ||
+ | OPHANIM_DIMENSIONS="" | ||
+ | CUD_ONLY_TAGID=0 | ||
+ | </ | ||
+ | |||
+ | Зміни в структурі БД: | ||
+ | <code sql> | ||
+ | ALTER TABLE `vservices` ADD `archived` TINYINT(1) NOT NULL DEFAULT 0; | ||
+ | </ | ||
+ | |||
+ | ====== 1.4.4 ====== | ||
+ | |||
+ | Наразі без різких рухів... та що ж таке, знову: | ||
+ | |||
+ | В конфіг alter.ini необхідно додати наступні опції | ||
+ | <code ini> | ||
+ | WAREHOUSE_INCOP_SEARCHBL=0 | ||
+ | </ | ||
+ | |||
+ | |||
+ | Зміни в структурі БД: | ||
+ | <code sql> | ||
+ | ALTER TABLE `vservices` ADD `exclude_tags` VARCHAR(255) NOT NULL DEFAULT ''; | ||
+ | </ | ||
+ | |||
+ | ====== 1.4.3 ====== | ||
+ | |||
+ | видихаємо | ||
+ | |||
+ | В конфіг alter.ini необхідно додати наступні опції | ||
+ | <code ini> | ||
+ | OPHANIMFLOW_ENABLED=0 | ||
+ | OPHANIMFLOW_URLS="" | ||
+ | PHOTOSTORAGE_POSTPROCESSING=0 | ||
+ | PHOTOSTORAGE_WATERMARK=1 | ||
+ | PHOTOSTORAGE_RECOMPRESS=1 | ||
+ | PHOTOSTORAGE_AUTORESIZE=1 | ||
+ | PHOTOSTORAGE_DRAWIMGINFO=1 | ||
+ | ONDEMAND_CHARTS=0 | ||
+ | </ | ||
+ | |||
+ | В конфіг userstats.ini необхідно додати наступні опції | ||
+ | <code ini> | ||
+ | OPHANIM_ENABLED=0 | ||
+ | </ | ||
+ | |||
+ | |||
+ | Зміни в структурі БД: | ||
+ | <code sql> | ||
+ | ALTER TABLE `envydevices` ADD `port` INT NULL DEFAULT NULL AFTER `cutend`; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `ophtraff` ( | ||
+ | `id` INT(11) NOT NULL AUTO_INCREMENT, | ||
+ | `login` VARCHAR(50) NOT NULL, | ||
+ | `month` tinyint(4) NOT NULL, | ||
+ | `year` SMALLINT(6) NOT NULL, | ||
+ | `U0` BIGINT(20) DEFAULT NULL, | ||
+ | `D0` BIGINT(20) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `login` (`login`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; | ||
+ | </ | ||
+ | |||
+ | |||
+ | ====== 1.4.2 ====== | ||
+ | |||
+ | < | ||
+ | Ні хвилини спОкою | ||
+ | Ні секунди спОкою | ||
+ | Бо апдейти Ubilling | ||
+ | І у снах із тобою... | ||
+ | Ця маленька пісенька-експромт буде тепер переслідувать всіх тих, хто досі робить оцеє всеє руками і змушує оцейво всьо писать... | ||
+ | |||
+ | |||
+ | В конфіг billing.ini необхідно додати наступні опції | ||
+ | <code ini> | ||
+ | REGFROZEN=0 | ||
+ | </ | ||
+ | |||
+ | В конфіг alter.ini необхідно додати наступні опції | ||
+ | <code ini> | ||
+ | WAREHOUSE_INEDT_ENABLED=0 | ||
+ | TASKMAN_EMPLOYEE_TAGID_FILTER=0 | ||
+ | TASKMAN_EMPLOYEE_APPOINTMENT_FILTER="" | ||
+ | TASKMAN_EMPDONESEL_SEARCHBL=0 | ||
+ | PSEUDOCRM_ACT_PROTECTED=0 | ||
+ | TASKMAN_DEPTH_LIMIT=6 | ||
+ | VSERVICES_CONSIDER_CREDIT=0 | ||
+ | </ | ||
+ | |||
+ | Зміни в структурі БД: | ||
+ | <code sql> | ||
+ | ALTER TABLE `contrahens_extinfo` ADD `paysys_token` VARCHAR(255) NOT NULL DEFAULT ''; | ||
+ | ALTER TABLE `contrahens_extinfo` ADD `paysys_secret_key` VARCHAR(255) NOT NULL DEFAULT ''; | ||
+ | ALTER TABLE `contrahens_extinfo` ADD `paysys_password` VARCHAR(255) NOT NULL DEFAULT ''; | ||
+ | </ | ||
+ | |||
+ | ====== 1.4.1 ====== | ||
+ | |||
+ | В конфіг alter.ini необхідно додати наступні опції | ||
+ | <code ini> | ||
+ | VISOR_USERSEL_SEARCHBL=1 | ||
+ | PSEUDOCRM_ENABLED=0 | ||
+ | PSEUDOCRM_ACT_CUSTSTATES="" | ||
+ | STEALTH_TARIFFS_ENABLED=0 | ||
+ | OPENPAYZ_STATIC_ID=0 | ||
+ | OPENPAYZ_STATIC_ID_PREFIX="" | ||
+ | MEACULPA_ENABLED=0 | ||
+ | </ | ||
+ | |||
+ | |||
+ | В конфіг userstats.ini необхідно додати наступні опції | ||
+ | <code ini> | ||
+ | POWERTARIFFS_MAXDAY=26 | ||
+ | </ | ||
+ | Зміни в структурі БД: | ||
+ | <code sql> | ||
+ | CREATE TABLE IF NOT EXISTS `crm_leads` ( | ||
+ | `id` INT(11) NOT NULL AUTO_INCREMENT, | ||
+ | `address` varchar(255) NOT NULL, | ||
+ | `realname` varchar(255) NOT NULL, | ||
+ | `phone` varchar(32) DEFAULT NULL, | ||
+ | `mobile` varchar(32) NOT NULL, | ||
+ | `extmobile` varchar(32) DEFAULT NULL, | ||
+ | `email` varchar(64) DEFAULT NULL, | ||
+ | `branch` int(11) DEFAULT NULL, | ||
+ | `tariff` varchar(64) DEFAULT NULL, | ||
+ | `login` varchar(64) DEFAULT NULL, | ||
+ | `employeeid` int(11) DEFAULT NULL, | ||
+ | `notes` varchar(255) DEFAULT NULL, | ||
+ | | ||
+ | KEY `login` (`login`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `crm_activities` ( | ||
+ | `id` INT(11) NOT NULL AUTO_INCREMENT, | ||
+ | `leadid` INT(11) NOT NULL, | ||
+ | `date` datetime NOT NULL, | ||
+ | `admin` varchar(64) DEFAULT NULL, | ||
+ | `employeeid` int(11) DEFAULT NULL, | ||
+ | `state` tinyint(1) DEFAULT 0, | ||
+ | `notes` varchar(255) DEFAULT NULL, | ||
+ | | ||
+ | KEY `leadid` (`leadid`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | |||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `crm_stateslog` ( | ||
+ | `id` INT(11) NOT NULL AUTO_INCREMENT, | ||
+ | `date` datetime NOT NULL, | ||
+ | `admin` varchar(64) DEFAULT NULL, | ||
+ | `scope` varchar(64) DEFAULT NULL, | ||
+ | `itemid` varchar(128) NOT NULL, | ||
+ | `action` varchar(32) DEFAULT NULL, | ||
+ | `state` varchar(255) DEFAULT NULL, | ||
+ | | ||
+ | KEY `scope` (`scope`), | ||
+ | KEY `itemid` (`itemid`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `stealthtariffs` ( | ||
+ | `id` INT(11) NOT NULL AUTO_INCREMENT, | ||
+ | `tariff` varchar(64) DEFAULT NULL, | ||
+ | | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `op_static` ( | ||
+ | `id` int(11) NOT NULL auto_increment, | ||
+ | `realid` varchar(255) NOT NULL, | ||
+ | `virtualid` varchar(255) NOT NULL, | ||
+ | | ||
+ | KEY `realid` (`realid`), | ||
+ | KEY `virtualid` (`virtualid`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `mlg_culpas` ( | ||
+ | `id` INT(11) NOT NULL AUTO_INCREMENT, | ||
+ | `login` varchar(64) NOT NULL, | ||
+ | `culpa` varchar(255) DEFAULT NULL, | ||
+ | | ||
+ | KEY `login` (`login`), | ||
+ | KEY `culpa` (`culpa`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | </ | ||
+ | |||
+ | |||
+ | ====== 1.4.0 ====== | ||
+ | |||
+ | В конфіг alter.ini необхідно додати наступні опції | ||
+ | <code ini> | ||
+ | BUILDLOCATOR_EXTENDED=0 | ||
+ | BRANCHES_ONUVIEW=0 | ||
+ | BRANCHES_ONUVIEW_BATCHREG=0 | ||
+ | </ | ||
+ | |||
+ | Зміни в структурі БД: | ||
+ | <code sql> | ||
+ | ALTER TABLE `banksta2_presets` ADD `sum_in_coins` tinyint(3) DEFAULT 0 AFTER `col_paysum`; | ||
+ | ALTER TABLE `banksta2_presets` ADD `noesc_inet_srv_keywords` tinyint(3) DEFAULT 0 AFTER `inet_srv_keywords`; | ||
+ | ALTER TABLE `banksta2_presets` ADD `noesc_ukv_srv_keywords` tinyint(3) DEFAULT 0 AFTER `ukv_srv_keywords`; | ||
+ | ALTER TABLE `banksta2_presets` ADD `noesc_skip_row_keywords` tinyint(3) DEFAULT 0 AFTER `skip_row_keywords`; | ||
+ | ALTER TABLE `banksta2_presets` ADD `noesc_replace_keywords` tinyint(3) DEFAULT 0 AFTER `replacements_cnt`; | ||
+ | ALTER TABLE `banksta2_presets` ADD `noesc_remove_keywords` tinyint(3) DEFAULT 0 AFTER `strs_to_remove`; | ||
+ | </ | ||
+ | |||
+ | ====== 1.3.9 ====== | ||
+ | |||
+ | а хто сказав, | ||
+ | |||
+ | В конфіг alter.ini додаємо: | ||
+ | <code ini> | ||
+ | VSERVICES_AS_PAYMENTS=1 | ||
+ | VISOR_CACHED_USERDATA=1 | ||
+ | BTRX24_POLLS_URL=" | ||
+ | BTRX24_POLLS_VAR=" | ||
+ | DEFERRED_SALE_ENABLED=0 | ||
+ | </ | ||
+ | |||
+ | ====== 1.3.8 ====== | ||
+ | |||
+ | Ще рано для паніки | ||
+ | |||
+ | В конфіг alter.ini додаємо: | ||
+ | <code ini> | ||
+ | BTRX24_ENABLED=0 | ||
+ | BTRX24_EXPORT_LAT=0 | ||
+ | BTRX24_EXPORT_URL=" | ||
+ | BTRX24_EXPORT_VAR=" | ||
+ | WOLFRECORDER_ENABLED=0 | ||
+ | </ | ||
+ | |||
+ | З структурою БД теж ні хвилини спокою | ||
+ | <code sql> | ||
+ | ALTER TABLE `visor_dvrs` ADD `apiurl` VARCHAR(255) NULL DEFAULT NULL AFTER `password`; | ||
+ | </ | ||
+ | |||
+ | ====== 1.3.7 ====== | ||
+ | |||
+ | В конфіг alter.ini додаємо: | ||
+ | <code ini> | ||
+ | ONUREG_PONIZER_ONU_REPLACE=1 | ||
+ | </ | ||
+ | |||
+ | Ну ось знову... зміни в структурі БД | ||
+ | |||
+ | <code sql> | ||
+ | ALTER TABLE `exhorse` ADD `a_outtotalcalls` INT NULL DEFAULT NULL; | ||
+ | ALTER TABLE `exhorse` ADD `a_outtotalanswered` INT NULL DEFAULT NULL; | ||
+ | ALTER TABLE `exhorse` ADD `a_outtotalcallsduration` INT NULL DEFAULT NULL; | ||
+ | ALTER TABLE `exhorse` ADD `a_outaveragecallduration` INT NULL DEFAULT NULL; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `paynetuz_transactions` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `date_create` datetime NOT NULL, | ||
+ | `transact_id` varchar(255) NOT NULL, | ||
+ | `op_transact_id` varchar(255) NOT NULL, | ||
+ | `op_customer_id` varchar(255) NOT NULL, | ||
+ | `amount` double NOT NULL DEFAULT 0, | ||
+ | `state` tinyint(2) NOT NULL DEFAULT 0, | ||
+ | `paynet_transact_timestamp` datetime NOT NULL, | ||
+ | `create_timestamp` datetime NOT NULL, | ||
+ | `perform_timestamp` datetime NOT NULL, | ||
+ | `cancel_timestamp` datetime NOT NULL, | ||
+ | `cancel_reason` varchar(255) NOT NULL DEFAULT '', | ||
+ | `receivers` text DEFAULT '', | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `date_create` (`date_create`), | ||
+ | UNIQUE KEY `transact_id` (`transact_id`), | ||
+ | UNIQUE KEY `op_transact_id` (`op_transact_id`), | ||
+ | KEY `op_customer_id` (`op_customer_id`), | ||
+ | KEY `paynet_transact_timestamp` (`paynet_transact_timestamp`), | ||
+ | KEY `create_timestamp` (`create_timestamp`), | ||
+ | KEY `perform_timestamp` (`perform_timestamp`), | ||
+ | KEY `cancel_timestamp` (`cancel_timestamp`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; | ||
+ | </ | ||
+ | |||
+ | ====== 1.3.6 ====== | ||
+ | |||
+ | А ви думали, | ||
+ | |||
+ | В конфіг alter.ini додаємо: | ||
+ | <code ini> | ||
+ | CORPSEL_SEARCHBL=0 | ||
+ | ONUREG_ALWAYS_SHOW_UNREGISTERED=1 | ||
+ | </ | ||
+ | |||
+ | ====== 1.3.5 ====== | ||
+ | |||
+ | А ви як думали? | ||
+ | |||
+ | В конфіг alter.ini додаємо: | ||
+ | <code ini> | ||
+ | MULTI_ENVY_PROC=0 | ||
+ | </ | ||
+ | |||
+ | В конфіг billing.ini додаємо: | ||
+ | <code ini> | ||
+ | XHPROF=0 | ||
+ | </ | ||
+ | |||
+ | Апдейт на БД: | ||
+ | <code sql> | ||
+ | ALTER TABLE `condet` ADD `term` INT NULL AFTER `price`; | ||
+ | |||
+ | ALTER TABLE `cfitems` ADD INDEX(`login`); | ||
+ | |||
+ | ALTER TABLE `contractdates` ADD `from` DATE NULL AFTER `date`, ADD `till` DATE NULL AFTER `from`; | ||
+ | |||
+ | ALTER TABLE `contrahens` ADD `agnameabbr` VARCHAR(255) NULL AFTER `contrname`, | ||
+ | |||
+ | ALTER TABLE `corp_data` ADD `corpnameabbr` VARCHAR(255) NULL AFTER `notes`, ADD `corpsignatory` VARCHAR(255) NULL AFTER `corpnameabbr`, | ||
+ | </ | ||
+ | |||
+ | ====== 1.3.4 ====== | ||
+ | |||
+ | Зараз буде трішки складніше, | ||
+ | |||
+ | В конфіг alter.ini додаємо: | ||
+ | <code ini> | ||
+ | DISCOUNT_DAILY=0 | ||
+ | FEES_HARVESTER=1 | ||
+ | </ | ||
+ | |||
+ | Апдейт на БД: | ||
+ | <code sql> | ||
+ | CREATE TABLE IF NOT EXISTS `discounts` ( | ||
+ | `id` INT(11) NOT NULL AUTO_INCREMENT, | ||
+ | `login` VARCHAR(64) NOT NULL, | ||
+ | `percent` DOUBLE DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `login` (`login`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `fees` ( | ||
+ | `id` INT(11) NOT NULL AUTO_INCREMENT, | ||
+ | `hash` VARCHAR(42) NOT NULL, | ||
+ | `login` VARCHAR(64) NOT NULL, | ||
+ | `date` datetime NOT NULL, | ||
+ | `admin` VARCHAR(64) DEFAULT NULL, | ||
+ | `from` DOUBLE DEFAULT NULL, | ||
+ | `to` DOUBLE DEFAULT NULL, | ||
+ | `summ` DOUBLE DEFAULT NULL, | ||
+ | `note` VARCHAR(200) DEFAULT NULL, | ||
+ | `cashtype` INT(11) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `login` (`login`), | ||
+ | KEY `date` (`date`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | </ | ||
+ | |||
+ | **А тепер неочікуване(!)** | ||
+ | |||
+ | Зробіть [[https:// | ||
+ | < | ||
+ | ubapi " | ||
+ | </ | ||
+ | |||
+ | (перший запуск може тривати деякий час - не лякайтесь - дайте йому завершитись) | ||
+ | |||
+ | та додайте в налаштуваннях вашого crontab наступний виклик: | ||
+ | < | ||
+ | 10 0 * * * /bin/ubapi " | ||
+ | </ | ||
+ | |||
+ | ====== 1.3.3 ====== | ||
+ | |||
+ | В конфіг alter.ini додаємо: | ||
+ | <code ini> | ||
+ | POWMAP_ENABLED=0 | ||
+ | FPING_PATH="/ | ||
+ | FASTPING_ENABLED=0 | ||
+ | USERBYNUM_ENABLED=0 | ||
+ | </ | ||
+ | |||
+ | ====== 1.3.2 ====== | ||
+ | |||
+ | Без паніки. | ||
+ | |||
+ | В конфіг alter.ini додаємо: | ||
+ | <code ini> | ||
+ | TAGSEL_SEARCHBL=0 | ||
+ | TAG_MULTPOWER_DELIMITER="" | ||
+ | TAG_NEWLINE_PZDTS=0 | ||
+ | </ | ||
+ | |||
+ | Апдейт на БД: | ||
+ | <code sql> | ||
+ | ALTER TABLE `extcontras_money` ADD `date_payment` date DEFAULT NULL AFTER `summ_payment`; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `wh_salesreports` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `name` varchar(255) NOT NULL, | ||
+ | | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `wh_salesitems` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `reportid` int(11) NOT NULL, | ||
+ | `itemtypeid` int(11) NOT NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `reportid` (`reportid`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | </ | ||
+ | |||
+ | ====== 1.3.1 ====== | ||
+ | |||
+ | В конфіг alter.ini додаємо: | ||
+ | <code ini> | ||
+ | QINQ_SWITCH_AUTOREPLACE=0 | ||
+ | SWITCHUPL_SEARCHBL=0 | ||
+ | VISOR_PROTUSERIDS="" | ||
+ | </ | ||
+ | |||
+ | ====== 1.3.0 ====== | ||
+ | |||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | PON_OLT_ORDER=" | ||
+ | MULTIGEN_AUTOCLEANUP_ENABLED=1 | ||
+ | MULTIGEN_AUTOCLEANUP_TIME=" | ||
+ | MULTIGEN_AUTOCLEANUP_ACCTDAYS=30 | ||
+ | MULTIGEN_AUTOCLEANUP_UNF=1 | ||
+ | CITYSEL_SEARCHBL=0 | ||
+ | STREETSEL_SEARCHBL=0 | ||
+ | BUILDSEL_SEARCHBL=0 | ||
+ | APTSEL_SEARCHBL=0 | ||
+ | USER_SWITCHPORT_AUTOREPLACE=0 | ||
+ | </ | ||
+ | |||
+ | ====== 1.2.9 ====== | ||
+ | |||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | TELEPONY_ENABLED=0 | ||
+ | TELEPONY_CDR="" | ||
+ | PBXMON_ENABLED=0 | ||
+ | PBXMON_RECORDS_PATH="/ | ||
+ | PBXMON_ARCHIVE_PATH="/ | ||
+ | PBXMON_FFMPG_PATH="/ | ||
+ | WDYC_ENABLED=0 | ||
+ | </ | ||
+ | |||
+ | ====== 1.2.8 ====== | ||
+ | |||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | VLAN_MANAGEMENT_ONU_GUEST_VLANS="" | ||
+ | REMINDER_FORCE_TRANSLIT=1 | ||
+ | PPP_ENABLED=0 | ||
+ | PONIZER_NO_IP_COLUMN=0 | ||
+ | </ | ||
+ | |||
+ | В конфиг billing.ini добавить: | ||
+ | <code ini> | ||
+ | IPACL_ENABLED=1 | ||
+ | </ | ||
+ | |||
+ | |||
+ | А вот апдейт на базу: | ||
+ | <code sql> | ||
+ | CREATE TABLE IF NOT EXISTS `mlg_nascustom` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `ip` varchar(32) NOT NULL, | ||
+ | `name` varchar(64) NOT NULL, | ||
+ | `secret` varchar(64) NOT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | CREATE OR REPLACE VIEW `mlg_clients` (`nasname`, `shortname`, | ||
+ | SELECT DISTINCT | ||
+ | COALESCE(mlg_nascustom.ip, | ||
+ | COALESCE(mlg_nascustom.name, | ||
+ | ' | ||
+ | NULL AS `ports`, | ||
+ | COALESCE(mlg_nascustom.secret, | ||
+ | NULL AS `server` | ||
+ | from `nas` | ||
+ | left join mlg_nascustom on (nas.nasip = mlg_nascustom.ip) | ||
+ | GROUP BY nasname | ||
+ | UNION SELECT DISTINCT | ||
+ | `ip` AS `nasname`, | ||
+ | `name` AS `shortname`, | ||
+ | ' | ||
+ | NULL AS `ports`, | ||
+ | `secret` as `secret`, | ||
+ | NULL as `server` | ||
+ | from `mlg_nascustom` | ||
+ | LEFT JOIN nas ON (mlg_nascustom.ip = nas.nasip) | ||
+ | where nasname is null | ||
+ | GROUP BY `ip`; | ||
+ | |||
+ | UPDATE `sms_services` SET `api_file_name` = ' | ||
+ | |||
+ | ALTER TABLE `mlg_acct` CHANGE `nasportid` `nasportid` VARCHAR(120) NULL DEFAULT NULL; | ||
+ | </ | ||
+ | |||
+ | ====== 1.2.7 ====== | ||
+ | |||
+ | Не. Реально уже надоело это писать. | ||
+ | |||
+ | |||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | SIGREP_CITYRENDER=0 | ||
+ | PON_OLT_ALIVE_PING_CHECK=0 | ||
+ | AERIAL_ALERTS_ENABLED=0 | ||
+ | AERIAL_ALERTS_NOTIFY="" | ||
+ | DHCP_ENABLED=1 | ||
+ | SYSLOAD_DISKS="" | ||
+ | USERALLDATA_CACHETIME=1440 | ||
+ | USERLISTS_USE_CACHE=1 | ||
+ | </ | ||
+ | |||
+ | В конфиг userstats.ini добавить: | ||
+ | <code ini> | ||
+ | TRINITYTV_NOUSERSUB=0 | ||
+ | AIR_RAID_ALERT_ENABLED=0 | ||
+ | </ | ||
+ | |||
+ | В конфиг mysql.ini добавить: | ||
+ | <code ini> | ||
+ | debug=0 | ||
+ | </ | ||
+ | |||
+ | Апдейт БД: | ||
+ | <code sql> | ||
+ | CREATE TABLE IF NOT EXISTS `olt_qinq` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `swid` int(11) NOT NULL, | ||
+ | `port` int(4) NOT NULL, | ||
+ | `svlan_id` int(11) NOT NULL, | ||
+ | `cvlan` int(4) NOT NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `svlan_id` (`svlan_id`), | ||
+ | KEY `cvlan` (`cvlan`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `op_sms_notifications` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `payment_id` int(11) NOT NULL, | ||
+ | `date` datetime NOT NULL, | ||
+ | `login` varchar(255) NOT NULL, | ||
+ | `balance` double NOT NULL DEFAULT 0, | ||
+ | `summ` double NOT NULL DEFAULT 0, | ||
+ | `processed` tinyint(1) UNSIGNED DEFAULT 0, | ||
+ | PRIMARY KEY (`id`), | ||
+ | UNIQUE KEY `payment_id` (`payment_id`), | ||
+ | KEY `login` (`login`), | ||
+ | KEY `date` (`date`), | ||
+ | KEY `summ` (`summ`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | </ | ||
+ | |||
+ | ====== 1.2.6 ====== | ||
+ | |||
+ | Это кто либо вообще читает? | ||
+ | |||
+ | В конфиг userstats.ini добавить: | ||
+ | <code ini> | ||
+ | POWERTARIFFS_ENABLED=0 | ||
+ | </ | ||
+ | |||
+ | |||
+ | ====== 1.2.5 ====== | ||
+ | |||
+ | Тихо-тихо, | ||
+ | |||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | TB_REPORTMASTER=1 | ||
+ | PHOTOSTORAGE_DIRECTORY="" | ||
+ | PHOTOSTORAGE_URL_PREFIX="" | ||
+ | PHOTOSTORAGE_PROXY_MODE=0 | ||
+ | </ | ||
+ | |||
+ | А вот апдейт на базу: | ||
+ | <code sql> | ||
+ | ALTER TABLE `buildpassport` ADD `anthill` TINYINT NULL; | ||
+ | </ | ||
+ | |||
+ | ====== 1.2.4 ====== | ||
+ | |||
+ | |||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | PON_DEFERRED_LOADING=0 | ||
+ | PON_ONU_CACHING=0 | ||
+ | TASKMAN_ANYONE_EMPLOYEEID=0 | ||
+ | SWITCHSONIC_ENABLED=1 | ||
+ | SWITCHSONIC_TIMEOUT=2 | ||
+ | </ | ||
+ | |||
+ | ====== 1.2.3 ====== | ||
+ | |||
+ | Пока что ничего страшного не произошло. | ||
+ | Всё. Произошло. | ||
+ | |||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | SNMP_DEBUG_MODE=0 | ||
+ | ANNOYANCE_ENABLED=0 | ||
+ | TRASSIR_DEBUG=0 | ||
+ | OLLTV_ENABLED=0 | ||
+ | OLLTV_LOGIN="" | ||
+ | OLLTV_PASSWORD="" | ||
+ | OLLTV_DOMAIN="" | ||
+ | OLLTV_DEBUG=0 | ||
+ | </ | ||
+ | |||
+ | В конфиг userstats.ini добавить: | ||
+ | <code ini> | ||
+ | OLLTV_ENABLED=0 | ||
+ | </ | ||
+ | |||
+ | Изменения в структуре БД: | ||
+ | <code sql> | ||
+ | CREATE TABLE IF NOT EXISTS `paymeuz_transactions` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `date_create` datetime NOT NULL, | ||
+ | `transact_id` varchar(255) NOT NULL, | ||
+ | `op_transact_id` varchar(255) NOT NULL, | ||
+ | `op_customer_id` varchar(255) NOT NULL, | ||
+ | `amount` double NOT NULL DEFAULT 0, | ||
+ | `state` tinyint(2) NOT NULL DEFAULT 0, | ||
+ | `payme_transact_timestamp` bigint(15) UNSIGNED NOT NULL DEFAULT 0, | ||
+ | `create_timestamp` bigint(15) UNSIGNED NOT NULL DEFAULT 0, | ||
+ | `perform_timestamp` bigint(15) UNSIGNED NOT NULL DEFAULT 0, | ||
+ | `cancel_timestamp` bigint(15) UNSIGNED NOT NULL DEFAULT 0, | ||
+ | `cancel_reason` varchar(255) NOT NULL DEFAULT '', | ||
+ | `receivers` text DEFAULT '', | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `date_create` (`date_create`), | ||
+ | KEY `transact_id` (`transact_id`), | ||
+ | KEY `op_transact_id` (`op_transact_id`), | ||
+ | KEY `op_customer_id` (`op_customer_id`), | ||
+ | KEY `payme_transact_timestamp` (`payme_transact_timestamp`), | ||
+ | KEY `create_timestamp` (`create_timestamp`), | ||
+ | KEY `perform_timestamp` (`perform_timestamp`), | ||
+ | KEY `cancel_timestamp` (`cancel_timestamp`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; | ||
+ | |||
+ | ALTER TABLE `buildpassport` ADD `contract` TINYINT NULL , ADD `mediator` TINYINT NULL ; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `ot_users` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `date` datetime NOT NULL, | ||
+ | `remoteid` int(11) NOT NULL, | ||
+ | `login` varchar(64) NOT NULL, | ||
+ | `email` varchar(64) DEFAULT NULL, | ||
+ | `phone` varchar(32) DEFAULT NULL, | ||
+ | `code` varchar(64) DEFAULT NULL, | ||
+ | `tariffid` int(11) DEFAULT NULL, | ||
+ | `active` tinyint(1) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `login` (`login`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | |||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `ot_tariffs` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `name` varchar(128) NOT NULL, | ||
+ | `alias` varchar(128) NOT NULL, | ||
+ | `fee` DOUBLE NOT NULL, | ||
+ | `period` varchar(8) DEFAULT NULL, | ||
+ | `percent` DOUBLE DEFAULT NULL, | ||
+ | `main` tinyint(1) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | |||
+ | ALTER TABLE `ot_users` ADD `addtariffid` INT NULL DEFAULT NULL AFTER `tariffid`; | ||
+ | </ | ||
+ | |||
+ | |||
+ | ====== 1.2.2 ====== | ||
+ | |||
+ | Может пора уже забыть о ручном накатывании апдейтов на базу и конфиги? | ||
+ | |||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | SENDDOG_PARALLEL_MODE=1 | ||
+ | USERREG_NO_BRANCH_DEFAULT=1 | ||
+ | SENDDOG_SMS_SERVICES_ENABLED="" | ||
+ | TASKMAN_SMS_PROFILE_CHECK=0 | ||
+ | </ | ||
+ | |||
+ | ====== 1.2.1 ====== | ||
+ | |||
+ | Просто обновляемся обновлятором и живем счастливо. Да-да - нет - любителей мануального хардкора мы не забыли... | ||
+ | |||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | TASKMAN_BRANCHES_CONSIDER_ON=0 | ||
+ | TASKMAN_ADV_FILTERS_BRANCHES_ON=0 | ||
+ | WAREHOUSE_TASKOUTEMPLOYEE=0 | ||
+ | TASKMAN_WAREHOUSE_HLPR=0 | ||
+ | PHOTOSTORAGE_GALLERY=1 | ||
+ | WAREHOUSE_RETURNS_ENABLED=0 | ||
+ | FULL_BILLING_URL="" | ||
+ | TASKMAN_SEND_TASKURL=0 | ||
+ | </ | ||
+ | |||
+ | Изменения в структуре БД: | ||
+ | <code sql> | ||
+ | CREATE TABLE IF NOT EXISTS `wh_returns` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `outid` int(11) NOT NULL, | ||
+ | `storageid` int(11) NOT NULL, | ||
+ | `itemtypeid` int(11) NOT NULL, | ||
+ | `count` DOUBLE NOT NULL, | ||
+ | `price` DOUBLE NOT NULL, | ||
+ | `date` datetime NOT NULL, | ||
+ | `admin` varchar(64) DEFAULT NULL, | ||
+ | `note` varchar(255) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `outid` (`outid`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | </ | ||
+ | |||
+ | ====== 1.2.0 ====== | ||
+ | |||
+ | Пока что ничего страшного не произошло... а не-не - уже всьо, да...уже, | ||
+ | |||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | EXTCONTRAS_FINANCE_ON=0 | ||
+ | PONBOXES_NAME_ORDER=0 | ||
+ | IDENC_ENABLED=0 | ||
+ | EASY_FREEZE=0 | ||
+ | DDT_ANTIFREEZE=0 | ||
+ | TASKRANKS_ENABLED=0 | ||
+ | TASKWHATIDO_ENABLED=0 | ||
+ | CALENDAR_TITLES_SEARCH_ON=0 | ||
+ | CALENDAR_DRAG_AND_DROP_ON=0 | ||
+ | CALENDAR_DRAG_AND_DROP_CONFIRM_ON=0 | ||
+ | </ | ||
+ | |||
+ | |||
+ | Изменения в структуре БД: | ||
+ | <code sql> | ||
+ | CREATE TABLE IF NOT EXISTS `stigma` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `scope` varchar(64) DEFAULT NULL, | ||
+ | `itemid` varchar(128) NOT NULL, | ||
+ | `state` varchar(255) NOT NULL, | ||
+ | `date` datetime NOT NULL, | ||
+ | `admin` varchar(64) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `extcontras` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `contras_id` int(11) NOT NULL, | ||
+ | `contract_id` int(11) NOT NULL, | ||
+ | `address_id` int(11) NOT NULL, | ||
+ | `period_id` int(11) NOT NULL, | ||
+ | `payday` tinyint(3) DEFAULT NULL, | ||
+ | `date_create` datetime NOT NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `contras_id` (`contras_id`), | ||
+ | KEY `contract_id` (`contract_id`), | ||
+ | KEY `address_id` (`address_id`), | ||
+ | KEY `period_id` (`period_id`), | ||
+ | KEY `payday` (`payday`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `extcontras_profiles` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `name` varchar(255) NOT NULL, | ||
+ | `edrpo` varchar(100) DEFAULT NULL, | ||
+ | `contact` varchar(255) DEFAULT NULL, | ||
+ | `email` varchar(255) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `name` (`name`), | ||
+ | KEY `edrpo` (`edrpo`), | ||
+ | KEY `contact` (`contact`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `extcontras_contracts` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `contract` varchar(150) DEFAULT NULL, | ||
+ | `date_start` date NOT NULL, | ||
+ | `date_end` date DEFAULT NULL, | ||
+ | `subject` varchar(255) DEFAULT NULL, | ||
+ | `full_sum` double DEFAULT 0, | ||
+ | `autoprolong` tinyint(3) DEFAULT 1, | ||
+ | `notes` varchar(255) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `contract` (`contract`), | ||
+ | KEY `date_start` (`date_start`), | ||
+ | KEY `date_end` (`date_end`), | ||
+ | KEY `subject` (`subject`), | ||
+ | KEY `full_sum` (`full_sum`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `extcontras_address` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `address` varchar(255) NOT NULL, | ||
+ | `summ` | ||
+ | `contract_notes` varchar(255) DEFAULT NULL, | ||
+ | `notes` varchar(255) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `extcontras_periods` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `period_name` varchar(100) NOT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `extcontras_invoices` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `contras_rec_id` int(11) NOT NULL, | ||
+ | `internal_number` varchar(150) DEFAULT '', | ||
+ | `invoice_number` varchar(150) NOT NULL, | ||
+ | `date` date NOT NULL, | ||
+ | `summ` double DEFAULT 0, | ||
+ | `summ_vat` double DEFAULT 0, | ||
+ | `notes` varchar(250) DEFAULT '', | ||
+ | `incoming` tinyint(1) DEFAULT 0, | ||
+ | `outgoing` tinyint(1) DEFAULT 0, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `contras_rec_id` (`contras_rec_id`), | ||
+ | KEY `invoice_number` (`invoice_number`), | ||
+ | KEY `date` (`date`), | ||
+ | KEY `summ` (`summ`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `extcontras_money` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `profile_id` int(11) NOT NULL, | ||
+ | `contract_id` int(11) DEFAULT NULL, | ||
+ | `address_id` int(11) DEFAULT NULL, | ||
+ | `accrual_id` int(11) DEFAULT NULL, | ||
+ | `invoice_id` int(11) DEFAULT NULL, | ||
+ | `purpose` varchar(255) NOT NULL DEFAULT '', | ||
+ | `date` datetime NOT NULL, | ||
+ | `date_edit` datetime NOT NULL, | ||
+ | `summ_accrual` double DEFAULT 0, | ||
+ | `summ_payment` double DEFAULT 0, | ||
+ | `incoming` tinyint(1) DEFAULT 0, | ||
+ | `outgoing` tinyint(1) DEFAULT 0, | ||
+ | `paynotes` varchar(255) NOT NULL DEFAULT '', | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `profile_id` (`profile_id`), | ||
+ | KEY `contract_id` (`contract_id`), | ||
+ | KEY `address_id` (`address_id`), | ||
+ | KEY `accrual_id` (`accrual_id`), | ||
+ | KEY `purpose` (`purpose`), | ||
+ | KEY `date` (`date`), | ||
+ | KEY `date_edit` (`date_edit`), | ||
+ | KEY `summ_accrual` (`summ_accrual`), | ||
+ | KEY `summ_payment` (`summ_payment`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `extcontras_missed_payms` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `contras_rec_id` int(11) NOT NULL, | ||
+ | `profile_id` int(11) NOT NULL, | ||
+ | `contract_id` int(11) DEFAULT NULL, | ||
+ | `address_id` int(11) DEFAULT NULL, | ||
+ | `period_id` int(11) NOT NULL, | ||
+ | `payday` tinyint(3) DEFAULT NULL, | ||
+ | `date_payment` date NOT NULL, | ||
+ | `date_expired` datetime NOT NULL, | ||
+ | `date_payed` datetime DEFAULT NULL, | ||
+ | `summ_payment` double DEFAULT 0, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `contras_rec_id` (`contras_rec_id`), | ||
+ | KEY `profile_id` (`profile_id`), | ||
+ | KEY `contract_id` (`contract_id`), | ||
+ | KEY `address_id` (`address_id`), | ||
+ | KEY `period_id` (`period_id`), | ||
+ | KEY `date_payment` (`date_payment`), | ||
+ | KEY `date_payed` (`date_payed`), | ||
+ | KEY `summ_payment` (`summ_payment`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; | ||
+ | |||
+ | ALTER TABLE `stigma` ADD INDEX(`scope`); | ||
+ | |||
+ | ALTER TABLE `stigma` ADD INDEX(`itemid`); | ||
+ | </ | ||
+ | ====== 1.1.9 ====== | ||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | CONTRACT_GEN_TEMPLATE="" | ||
+ | CONTRACT_GEN_TEMPLATE_LEADING_ZEROES=1 | ||
+ | TASKMAN_SHOW_USERTAGS=0 | ||
+ | </ | ||
+ | |||
+ | |||
+ | Изменения в структуре БД: | ||
+ | <code sql> | ||
+ | ALTER TABLE `callmeback` ADD `statedate` DATETIME NULL DEFAULT NULL AFTER `state`; | ||
+ | ALTER TABLE `callmeback` ADD `admin` VARCHAR(200) NULL DEFAULT NULL AFTER `statedate`; | ||
+ | </ | ||
+ | |||
+ | ====== 1.1.8 ====== | ||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | DHCP_DDNS_ENABLED=0 | ||
+ | </ | ||
+ | |||
+ | Изменения в структуре БД: | ||
+ | <code sql> | ||
+ | CREATE TABLE IF NOT EXISTS `mg_credentials` ( | ||
+ | `id` INT(11) NOT NULL AUTO_INCREMENT, | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `ipauth_denied` ( | ||
+ | `id` INT(11) NOT NULL AUTO_INCREMENT, | ||
+ | `login` VARCHAR(200) NOT NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `login` (`login`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | </ | ||
+ | |||
+ | |||
+ | ====== 1.1.7 ====== | ||
+ | |||
+ | Есть давно менеджер обновлений, | ||
+ | |||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | INSURANCE_ENABLED=0 | ||
+ | YOUTV_ENABLED=0 | ||
+ | YOUTV_LOGIN="" | ||
+ | YOUTV_PASSWORD="" | ||
+ | YOUTV_DEALER_ID="" | ||
+ | PON_ONU_OFFLINE_SIGNAL=-9000 | ||
+ | WAREHOUSE_TASKOUTDATE=0 | ||
+ | </ | ||
+ | |||
+ | В конфиг userstats.ini добавить: | ||
+ | <code ini> | ||
+ | INSURANCE_ENABLED=0 | ||
+ | TG_BOTNAME="" | ||
+ | YOUTV_ENABLED=0 | ||
+ | YOUTV_PROTECTION=1 | ||
+ | </ | ||
+ | |||
+ | Изменения в структуре БД: | ||
+ | <code sql> | ||
+ | CREATE TABLE IF NOT EXISTS `ins_homereq` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `date` datetime NOT NULL, | ||
+ | `login` varchar(64) DEFAULT NULL, | ||
+ | `address` varchar(200) NOT NULL, | ||
+ | `realname` varchar(200) NOT NULL, | ||
+ | `mobile` varchar(64) NOT NULL, | ||
+ | `email` varchar(64) NOT NULL, | ||
+ | `state` tinyint(1) NOT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `youtv_subscribers` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `date` datetime NOT NULL, | ||
+ | `active` tinyint(1) DEFAULT NULL, | ||
+ | `subscriberid` int(11) NOT NULL, | ||
+ | `login` varchar(64) NOT NULL, | ||
+ | `maintariff` int(11) DEFAULT NULL, | ||
+ | `addtariffs` varchar(255) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | |||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `youtv_tariffs` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `serviceid` int(11) NOT NULL, | ||
+ | `main` tinyint(1) NOT NULL, | ||
+ | `name` varchar(64) NOT NULL, | ||
+ | `chans` varchar(42) DEFAULT NULL, | ||
+ | `fee` double NOT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | </ | ||
+ | |||
+ | ====== 1.1.6 ====== | ||
+ | |||
+ | Серьезно? | ||
+ | |||
+ | |||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | ONU_BURIAL_ENABLED=0 | ||
+ | PTV_ENABLED=0 | ||
+ | PTV_LOGIN="" | ||
+ | PTV_PASSWORD="" | ||
+ | HERD_OF_PONIES=0 | ||
+ | HORDE_OF_SWITCHES=0 | ||
+ | </ | ||
+ | |||
+ | В конфиг userstats.ini добавить: | ||
+ | <code ini> | ||
+ | PASSWORD_CHANGE=0 | ||
+ | PROSTOTV_ENABLED=0 | ||
+ | OM_MAXDEV=3 | ||
+ | </ | ||
+ | |||
+ | Изменения в структуре БД: | ||
+ | <code sql> | ||
+ | CREATE TABLE IF NOT EXISTS `ptv_subscribers` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `date` datetime NOT NULL, | ||
+ | `active` tinyint(1) DEFAULT NULL, | ||
+ | `subscriberid` int(11) NOT NULL, | ||
+ | `login` varchar(64) NOT NULL, | ||
+ | `maintariff` int(11) DEFAULT NULL, | ||
+ | `addtariffs` varchar(255) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `ptv_tariffs` ( | ||
+ | `id` INT(11) NOT NULL AUTO_INCREMENT, | ||
+ | `serviceid` INT(11) NOT NULL, | ||
+ | `main` tinyint(1) NOT NULL, | ||
+ | `name` VARCHAR(64) NOT NULL, | ||
+ | `chans` VARCHAR(42) DEFAULT NULL, | ||
+ | `fee` DOUBLE NOT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `ponboxes_splitters` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `boxid` int(11) NOT NULL, | ||
+ | `splitter` varchar(200) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | |||
+ | ALTER TABLE `ponboxes` MODIFY `name` varchar(200) NULL DEFAULT NULL; | ||
+ | ALTER TABLE `ponboxes` ADD `exten_info` varchar(250) NULL DEFAULT NULL AFTER `name`; | ||
+ | |||
+ | ALTER TABLE sms_history ADD INDEX (srvmsgself_id) USING BTREE; | ||
+ | ALTER TABLE sms_history ADD INDEX (srvmsgself_id) USING BTREE; | ||
+ | ALTER TABLE sms_history ADD INDEX (date_statuschk) USING BTREE; | ||
+ | </ | ||
+ | |||
+ | ====== 1.1.5 ====== | ||
+ | |||
+ | Нам действительно непонятно, | ||
+ | |||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | GRAVATAR_CACHETIME=1 | ||
+ | COBAINS_SHOTGUN=0 | ||
+ | OPT82_ENABLED=0 | ||
+ | DEAD_HIDE_USERSIDE=0 | ||
+ | NMREVERSE=0 | ||
+ | </ | ||
+ | |||
+ | Изменения в структуре БД: | ||
+ | <code sql> | ||
+ | ALTER TABLE `fdbarchive` ADD `datavlan` longtext NULL DEFAULT NULL AFTER `data`; | ||
+ | ALTER TABLE `fdbarchive` ADD `dataportdescr` longtext NULL DEFAULT NULL AFTER `datavlan`; | ||
+ | </ | ||
+ | ====== 1.1.4 ====== | ||
+ | |||
+ | Если вы все еще, до сих пор, по какой-то причине не пользуетесь " | ||
+ | |||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | PT_MAXDAY=26 | ||
+ | PT_CHARGEONREG=1 | ||
+ | DSTAT_ENABLED=0 | ||
+ | </ | ||
+ | |||
+ | |||
+ | Изменения в структуре БД: | ||
+ | <code sql> | ||
+ | ALTER TABLE `envydevices` ADD `cutstart` INT NULL DEFAULT NULL , ADD `cutend` INT NULL DEFAULT NULL ; | ||
+ | |||
+ | ALTER TABLE `visor_dvrs` ADD `customurl` VARCHAR(255) NULL DEFAULT NULL AFTER `camlimit`; | ||
+ | |||
+ | ALTER TABLE `stickyrevelations` ADD `dayweek` INT NULL DEFAULT NULL AFTER `dayto`; | ||
+ | </ | ||
+ | |||
+ | ====== 1.1.3 ====== | ||
+ | |||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | RFCORPS=0 | ||
+ | EASY_CHARGE_CREDIT_DAYS=0 | ||
+ | CUD_OPERATION=" | ||
+ | MG_FREEPERIOD_DAYS=14 | ||
+ | </ | ||
+ | |||
+ | Изменения в структуре БД: | ||
+ | <code sql> | ||
+ | CREATE TABLE IF NOT EXISTS `garage_cars` ( | ||
+ | `id` INT(11) NOT NULL AUTO_INCREMENT, | ||
+ | `vendor` VARCHAR(40) NOT NULL, | ||
+ | `model` VARCHAR(40) NOT NULL, | ||
+ | `number` VARCHAR(20) DEFAULT NULL, | ||
+ | `vin` VARCHAR(40) DEFAULT NULL, | ||
+ | `year` INT(11) DEFAULT NULL, | ||
+ | `power` INT(11) DEFAULT NULL, | ||
+ | `engine` INT(11) DEFAULT NULL, | ||
+ | `fuelconsumption` DOUBLE DEFAULT NULL, | ||
+ | `fueltype` VARCHAR(16) DEFAULT NULL, | ||
+ | `gastank` INT(11) DEFAULT NULL, | ||
+ | `weight` INT(11) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `garage_drivers` ( | ||
+ | `id` INT(11) NOT NULL AUTO_INCREMENT, | ||
+ | `employeeid` INT(11) NOT NULL, | ||
+ | `carid` INT(11) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `garage_mileage` ( | ||
+ | `id` INT(11) NOT NULL AUTO_INCREMENT, | ||
+ | `date` DATETIME NOT NULL, | ||
+ | `carid` INT(11) NOT NULL, | ||
+ | `mileage` INT(11) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `garage_mapon` ( | ||
+ | `id` INT(11) NOT NULL AUTO_INCREMENT, | ||
+ | `carid` INT(11) NOT NULL, | ||
+ | `unitid` INT(11) NOT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | |||
+ | ALTER TABLE `banksta2_presets` ADD `col_srvidents` varchar(20) DEFAULT '' | ||
+ | ALTER TABLE `banksta2_presets` ADD `srvidents_preffered` tinyint(3) DEFAULT 0 AFTER `guess_contract`; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `user_dataexport_allowed` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `login` varchar(100) NOT NULL, | ||
+ | `export_allowed` tinyint(3) DEFAULT 0, | ||
+ | PRIMARY KEY (`id`), | ||
+ | UNIQUE KEY (`login`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `contrahens_extinfo` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `agentid` int(11) NOT NULL, | ||
+ | `service_type` varchar(50) NOT NULL DEFAULT '', | ||
+ | `internal_paysys_name` varchar(50) | ||
+ | `internal_paysys_id` varchar(50) | ||
+ | `internal_paysys_srv_id` varchar(50) | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; | ||
+ | </ | ||
+ | |||
+ | ====== 1.1.2 ====== | ||
+ | |||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | FUNDSFLOW_EXTCOLORING="" | ||
+ | ONUREG_DHCP_SNOOPING_DEFAULT=0 | ||
+ | ONUREG_LOOPDETECT_DEFAULT=0 | ||
+ | PRINCESS_LIST="" | ||
+ | BANDWIDTHD_PROXY=0 | ||
+ | KARMA_CONTROL=0 | ||
+ | TRASSIRHLS_ENABLED=0 | ||
+ | PINGCHARTS_DEFAULT=1 | ||
+ | </ | ||
+ | |||
+ | Изменения в структуре БД: | ||
+ | <code sql> | ||
+ | ALTER TABLE `passportdata` ADD `pinn` VARCHAR(15) NULL DEFAULT NULL; | ||
+ | </ | ||
+ | |||
+ | ====== 1.1.1 ====== | ||
+ | |||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | PON_ONU_SEARCH_ENABLED=0 | ||
+ | TASKSTATES_ENABLED=0 | ||
+ | SMS_SERVICES_ADVANCED_PHPMAILER_ON=0 | ||
+ | OPENPAYZ_PALETTE="" | ||
+ | </ | ||
+ | |||
+ | Изменения в структуре БД: | ||
+ | <code sql> | ||
+ | CREATE TABLE IF NOT EXISTS `taskstates` ( | ||
+ | `id` INT(11) NOT NULL AUTO_INCREMENT, | ||
+ | `taskid` INT(11) NOT NULL, | ||
+ | `state` VARCHAR(42) NOT NULL, | ||
+ | `date` datetime NOT NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `taskid` (`taskid`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `op_denied` ( | ||
+ | `id` INT(11) NOT NULL AUTO_INCREMENT, | ||
+ | `login` VARCHAR(200) NOT NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `login` (`login`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | |||
+ | |||
+ | </ | ||
+ | |||
+ | ====== 1.1.0 ====== | ||
+ | |||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | TASKMAN_DUPLICATE_CHECK=0 | ||
+ | FILESTORAGE_ENABLED=0 | ||
+ | SW_CASH_ENABLED=0 | ||
+ | </ | ||
+ | |||
+ | В конфиг userstats.ini добавить: | ||
+ | <code ini> | ||
+ | UBA_XML_ADDRESS_STRUCT=0 | ||
+ | </ | ||
+ | |||
+ | Изменения в структуре БД: | ||
+ | <code sql> | ||
+ | CREATE TABLE IF NOT EXISTS `filestorage` ( | ||
+ | `id` INT(11) NOT NULL AUTO_INCREMENT, | ||
+ | `scope` VARCHAR(255) NOT NULL, | ||
+ | `item` VARCHAR(255) NOT NULL, | ||
+ | `date` datetime NOT NULL, | ||
+ | `admin` VARCHAR(40) NOT NULL, | ||
+ | `filename` VARCHAR(255) NOT NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `scope` (`scope`), | ||
+ | KEY `item` (`item`), | ||
+ | KEY `date` (`date`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `swcash` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `switchid` int(11) NOT NULL, | ||
+ | `placecontract` varchar(200) DEFAULT NULL, | ||
+ | `placeprice` double NOT NULL DEFAULT ' | ||
+ | `powercontract` varchar(200) DEFAULT NULL, | ||
+ | `powerprice` double NOT NULL DEFAULT ' | ||
+ | `transportcontract` varchar(200) DEFAULT NULL, | ||
+ | `transportprice` double NOT NULL DEFAULT ' | ||
+ | `switchprice` double NOT NULL DEFAULT ' | ||
+ | `switchdate` date DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `switchid` (`switchid`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | </ | ||
+ | |||
+ | ====== 1.0.9 ====== | ||
+ | |||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | MG_DOMAIN="" | ||
+ | TASKMAN_GULAG=0 | ||
+ | BLITZORTUNG_URL="" | ||
+ | USERREG_FREEIP_STATS=0 | ||
+ | </ | ||
+ | |||
+ | Изменения в структуре БД: | ||
+ | <code sql> | ||
+ | CREATE TABLE IF NOT EXISTS `switchuplinks` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `switchid` int(11) NOT NULL, | ||
+ | `media` varchar(10) DEFAULT NULL, | ||
+ | `port` int (11) DEFAULT NULL, | ||
+ | `speed` varchar(10) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | |||
+ | ALTER TABLE `switchuplinks` ADD INDEX(`switchid`); | ||
+ | </ | ||
+ | |||
+ | ====== 1.0.8 ====== | ||
+ | |||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | PT_ENABLED=0 | ||
+ | PON_IFDESC=0 | ||
+ | SEARCH_NOTES=0 | ||
+ | PONBOXES_ENABLED=0 | ||
+ | </ | ||
+ | |||
+ | Изменения в структуре БД: | ||
+ | <code sql> | ||
+ | ALTER TABLE `banksta2_presets` ADD `payment_type_id` int(11) NOT NULL DEFAULT 0; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `pt_users` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `login` varchar(64) NOT NULL, | ||
+ | `day` int(11) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | |||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `pt_tariffs` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `tariff` varchar(40) NOT NULL, | ||
+ | `fee` double DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `pt_log` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `date` datetime NOT NULL, | ||
+ | `login` varchar(64) NOT NULL, | ||
+ | `tariff` varchar(40) NOT NULL, | ||
+ | `day` int(11) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `ponifdesc` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `oltid` int(11) NOT NULL, | ||
+ | `iface` varchar(64) DEFAULT NULL, | ||
+ | `desc` varchar(200) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY (`oltid`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `ponboxes` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `name` varchar(64) NOT NULL, | ||
+ | `geo` varchar(64) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `ponboxeslinks` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `boxid` int(11) NOT NULL, | ||
+ | `login` varchar(64) DEFAULT NULL, | ||
+ | `address` varchar(200) DEFAULT NULL, | ||
+ | `onuid` int(11) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | </ | ||
+ | |||
+ | |||
+ | ====== 1.0.7 ====== | ||
+ | Если вы ожидаете, | ||
+ | |||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | AUTOCREDIT_CFID=0 | ||
+ | CAN_TOUCH_MONEY="" | ||
+ | VCASH_ENABLED=0 | ||
+ | </ | ||
+ | |||
+ | В конфиг userstats.ini добавить: | ||
+ | <code ini> | ||
+ | SC_REMOTE=0 | ||
+ | </ | ||
+ | |||
+ | Изменения в структуре БД: | ||
+ | <code sql> | ||
+ | CREATE TABLE IF NOT EXISTS `address_extended` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `login` varchar(50) NOT NULL, | ||
+ | `postal_code` varchar(10) NOT NULL DEFAULT '', | ||
+ | `town_district` varchar(150) NOT NULL DEFAULT '', | ||
+ | `address_exten` varchar(250) NOT NULL DEFAULT '', | ||
+ | PRIMARY KEY (`id`), | ||
+ | UNIQUE KEY (`login`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | |||
+ | ALTER TABLE `payments` MODIFY `note` varchar(200) NULL DEFAULT NULL; | ||
+ | ALTER TABLE `paymentscorr` MODIFY `note` varchar(200) NULL DEFAULT NULL; | ||
+ | </ | ||
+ | |||
+ | ====== 1.0.6 ====== | ||
+ | |||
+ | Обновляемся обновлятором, | ||
+ | |||
+ | В конфиг alter.ini добавить: | ||
+ | |||
+ | <code ini> | ||
+ | ONUAUTO_CONFIG_DELETE=0 | ||
+ | ONUAUTO_CONFIG_DEREGISTER=0 | ||
+ | </ | ||
+ | |||
+ | |||
+ | Изменения в структуре БД: | ||
+ | <code sql> | ||
+ | ALTER TABLE `vservices` MODIFY `price` double NOT NULL DEFAULT 0; | ||
+ | ALTER TABLE `vservices` ADD `charge_period_days` tinyint(3) NOT NULL DEFAULT 0; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `invoices` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `login` varchar(50) NOT NULL, | ||
+ | `invoice_num` varchar(40) NOT NULL DEFAULT '', | ||
+ | `invoice_date` datetime NOT NULL, | ||
+ | `invoice_sum` double NOT NULL DEFAULT 0, | ||
+ | `invoice_body` text NOT NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | UNIQUE KEY (`invoice_num`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | </ | ||
+ | ====== 1.0.5 ====== | ||
+ | |||
+ | Обновляемся обновлятором, | ||
+ | |||
+ | |||
+ | В конфиг alter.ini добавить: | ||
+ | |||
+ | <code ini> | ||
+ | TRASSIRMGR_ENABLED=0 | ||
+ | OMEGATV_TARIFFSBUNDLE="" | ||
+ | </ | ||
+ | |||
+ | В конфиг userstats.ini добавить: | ||
+ | |||
+ | <code ini> | ||
+ | OM_TARIFFSDENIED="" | ||
+ | OM_TARIFFSBUNDLE="" | ||
+ | </ | ||
+ | |||
+ | Изменения в структуре БД: | ||
+ | <code sql> | ||
+ | CREATE TABLE IF NOT EXISTS `visor_chans` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `visorid` int(11) NOT NULL, | ||
+ | `dvrid` int(11) NOT NULL, | ||
+ | `chan` varchar(255) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `visor_secrets` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `visorid` int(11) NOT NULL, | ||
+ | `login` varchar(64) NOT NULL, | ||
+ | `password` varchar(64) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | |||
+ | ALTER TABLE `frozen_charge_days` ADD `last_freeze_charge_dt` datetime NOT NULL AFTER `freeze_days_used`; | ||
+ | ALTER TABLE `frozen_charge_days` ADD `last_workdays_upd_dt` datetime NOT NULL; | ||
+ | |||
+ | ALTER TABLE `visor_dvrs` ADD `camlimit` int(11) NULL DEFAULT 0 AFTER `type`; | ||
+ | </ | ||
+ | ====== 1.0.4 ====== | ||
+ | Просто обновляемся автообновлятором. Нажимаем кнопочки в менеджере обновлений. | ||
+ | |||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | VISOR_IN_PROFILE=0 | ||
+ | SMARTUP_ENABLED=0 | ||
+ | ENVY_ENABLED=0 | ||
+ | </ | ||
+ | |||
+ | Изменения в структуре БД: | ||
+ | <code sql> | ||
+ | CREATE TABLE IF NOT EXISTS `envyscripts` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `modelid` int(11) NOT NULL, | ||
+ | `data` TEXT DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | |||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `envydevices` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `switchid` int(11) NOT NULL, | ||
+ | `login` varchar(255) DEFAULT NULL, | ||
+ | `password` varchar(255) DEFAULT NULL, | ||
+ | `enablepassword` varchar(255) DEFAULT NULL, | ||
+ | `custom1` varchar(255) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `envydata` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `switchid` int(11) NOT NULL, | ||
+ | `date` datetime NOT NULL, | ||
+ | `config` mediumtext, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `switchid` (`switchid`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | ALTER TABLE `envydevices` ADD `active` TINYINT NULL DEFAULT ' | ||
+ | </ | ||
+ | |||
+ | ====== 1.0.3 ====== | ||
+ | |||
+ | Просто обновляемся автообновлятором. Нажимаем кнопочки в менеджере обновлений. | ||
+ | |||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | ONUREG_HUAWEI_NATIVE_VLAN=0 | ||
+ | PONMAP_ENABLED=0 | ||
+ | ITSATRAP_ENABLED=0 | ||
+ | PAYMENTCARDS_UNIQUE_MODE=1 | ||
+ | </ | ||
+ | |||
+ | Изменения в структуре БД: | ||
+ | |||
+ | <code sql> | ||
+ | CREATE TABLE IF NOT EXISTS `zte_qinq` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `swid` int(11) NOT NULL, | ||
+ | `slot_number` int(11) NOT NULL, | ||
+ | `port` int(4) NOT NULL, | ||
+ | `svlan_id` int(11) NOT NULL, | ||
+ | `cvlan` int(4) NOT NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY (`svlan_id`), | ||
+ | KEY (`cvlan`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | |||
+ | ALTER TABLE `banksta2_presets` CHANGE `col_skiprow` col_skiprow varchar(100) DEFAULT ''; | ||
+ | ALTER TABLE `banksta2_presets` ADD `replace_strs` tinyint(3) DEFAULT 0; | ||
+ | ALTER TABLE `banksta2_presets` ADD `col_replace_strs` varchar(100) DEFAULT ''; | ||
+ | ALTER TABLE `banksta2_presets` ADD `strs_to_replace` varchar(200) DEFAULT ''; | ||
+ | ALTER TABLE `banksta2_presets` ADD `strs_to_replace_with` varchar(200) DEFAULT ''; | ||
+ | ALTER TABLE `banksta2_presets` ADD `replacements_cnt` tinyint(3) DEFAULT 1; | ||
+ | ALTER TABLE `banksta2_presets` ADD `remove_strs` tinyint(3) DEFAULT 0; | ||
+ | ALTER TABLE `banksta2_presets` ADD `col_remove_strs` varchar(100) DEFAULT ''; | ||
+ | ALTER TABLE `banksta2_presets` ADD `strs_to_remove` varchar(200) DEFAULT ''; | ||
+ | |||
+ | ALTER TABLE `visor_dvrs` ADD `apikey` VARCHAR(255) NULL DEFAULT NULL AFTER `password`; | ||
+ | ALTER TABLE `visor_dvrs` ADD `name` VARCHAR(255) NULL DEFAULT NULL AFTER `apikey`; | ||
+ | ALTER TABLE `visor_dvrs` ADD `type` VARCHAR(40) NULL DEFAULT NULL AFTER `name`; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `traptypes` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `match` varchar(255) NOT NULL, | ||
+ | `name` varchar(255) NOT NULL, | ||
+ | `color` varchar(20) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | |||
+ | ALTER TABLE `cardbank` ADD KEY `serial` (`serial`); | ||
+ | |||
+ | ALTER TABLE `cardbank` ADD KEY `part` (`part`); | ||
+ | |||
+ | ALTER TABLE `cardbank` ADD KEY `serial_part` (`serial`, | ||
+ | |||
+ | </ | ||
+ | ====== 1.0.2 ====== | ||
+ | |||
+ | Просто обновляемся автообновлятором. Нажимаем кнопочки в менеджере обновлений. | ||
+ | |||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | IBAN_ENABLED=0 | ||
+ | UNIVERSAL_QINQ_USER_EXIST=0 | ||
+ | VLAN_MANAGEMENT_ENABLED=0 | ||
+ | REMOTEDHCP_ENABLED=0 | ||
+ | QINQ_IN_PROFILE=0 | ||
+ | USERNAS_IN_PROFILE=0 | ||
+ | </ | ||
+ | |||
+ | Изменения в структуре БД: | ||
+ | |||
+ | <code sql> | ||
+ | ALTER TABLE `qinq` ADD `svlan_id` int(10) NOT NULL AFTER `svlan`; | ||
+ | |||
+ | ALTER TABLE `qinq` DROP `svlan`; | ||
+ | |||
+ | RENAME TABLE `qinq` TO `qinq_bindings`; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `realms` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `realm` varchar(255) NOT NULL, | ||
+ | `description` varchar(255) NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY (`realm`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | |||
+ | INSERT INTO `realms` (`id`, | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `qinq_svlan` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `realm_id` int(11) NOT NULL, | ||
+ | `svlan` int(4) NOT NULL, | ||
+ | `description` varchar(255) NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY (`realm_id`), | ||
+ | KEY (`svlan`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | |||
+ | INSERT INTO `qinq_svlan` (`id`, `realm_id`, `svlan`, `description`) VALUES (NULL, 1, 0, 'Use it for untagged VLAN' | ||
+ | |||
+ | INSERT INTO `qinq_svlan` (`id`, `realm_id`, `svlan`) SELECT DISTINCT NULL, 1, `svlan` FROM `switches_qinq`; | ||
+ | |||
+ | ALTER TABLE `switches_qinq` ADD `svlan_id` int(11) NOT NULL AFTER `switchid`; | ||
+ | |||
+ | ALTER TABLE `switches_qinq` ADD KEY `svlan_id` (`svlan_id`); | ||
+ | |||
+ | UPDATE `switches_qinq` AS `swq`, `qinq_svlan` AS `qsv` SET `swq`.`svlan_id` = `qsv`.`id` WHERE `swq`.`svlan` = `qsv`.`svlan` AND `qsv`.`realm_id` =1; | ||
+ | |||
+ | ALTER TABLE `switches_qinq` DROP `svlan`; | ||
+ | </ | ||
+ | ====== 1.0.1 ====== | ||
+ | |||
+ | Просто обновляемся автообновлятором. Нажимаем кнопочки в менеджере обновлений. | ||
+ | |||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | DREAMKAS_ENABLED=0 | ||
+ | DREAMKAS_AUTH_TOKEN="" | ||
+ | CALLMEBACK_ENABLED=0 | ||
+ | UNIVERSAL_QINQ_ENABLED=0 | ||
+ | ONUREG_QINQ_ENABLED=0 | ||
+ | </ | ||
+ | |||
+ | |||
+ | |||
+ | |||
+ | Изменения в структуре БД: | ||
+ | <code sql> | ||
+ | CREATE TABLE IF NOT EXISTS `dreamkas_operations` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `operation_id` varchar(255) NOT NULL, | ||
+ | `date_create` datetime NOT NULL, | ||
+ | `date_finish` datetime NOT NULL, | ||
+ | `date_resend` datetime NOT NULL, | ||
+ | `status` varchar(255) NOT NULL, | ||
+ | `error_code` varchar(255) NOT NULL, | ||
+ | `error_message` varchar(255) NOT NULL, | ||
+ | `receipt_id` varchar(255) NOT NULL, | ||
+ | `operation_body` TEXT NOT NULL, | ||
+ | `repeat_count` tinyint(3) NOT NULL DEFAULT 0, | ||
+ | PRIMARY KEY (`id`), | ||
+ | UNIQUE KEY (`operation_id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `dreamkas_services_relations` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `service` varchar(42) NOT NULL, | ||
+ | `goods_id` varchar(255) NOT NULL, | ||
+ | `goods_name` varchar(255) NOT NULL, | ||
+ | `goods_type` varchar(255) NOT NULL, | ||
+ | `goods_price` double NOT NULL, | ||
+ | `goods_tax` varchar(255) NOT NULL, | ||
+ | `goods_vendorcode` varchar(255) NOT NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | UNIQUE KEY (`service`, `goods_id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `dreamkas_banksta2_relations` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `bs2_rec_id` int(11) NOT NULL, | ||
+ | `operation_id` varchar(255) NOT NULL, | ||
+ | `receipt_id` varchar(255) NOT NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | UNIQUE KEY (bs2_rec_id), | ||
+ | UNIQUE KEY (`operation_id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `callmeback` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `date` datetime NOT NULL, | ||
+ | `number` varchar(250) DEFAULT NULL, | ||
+ | `state` varchar(40) DEFAULT NULL, | ||
+ | | ||
+ | ) ENGINE=MyISAM | ||
+ | |||
+ | ALTER TABLE `salary_jobprices` CHANGE `time` `time` FLOAT NULL DEFAULT NULL; | ||
+ | |||
+ | ALTER TABLE `dreamkas_operations` ADD `repeated_fiscop_id` varchar(255) NOT NULL AFTER `operation_body`; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `qinq` ( | ||
+ | `id` INT NOT NULL AUTO_INCREMENT, | ||
+ | `login` VARCHAR(45) NULL, | ||
+ | `svlan` INT(4) NULL, | ||
+ | `cvlan` INT(4) NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | UNIQUE KEY (`login`) | ||
+ | ) ENGINE = MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=UTF8; | ||
+ | </ | ||
+ | ====== 1.0.0 ====== | ||
+ | |||
+ | Просто обновляемся автообновлятором и нажимаем кнопочки в менеджере обновлений. | ||
+ | |||
+ | |||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | BACKUPS_MAX_AGE=7 | ||
+ | DARKVOID_CACHETIME=10 | ||
+ | VISOR_CHARGE_MODE=1 | ||
+ | TRINITYTV_RDEVS=0 | ||
+ | REMOTEAPI_DISABLE_CALLS="" | ||
+ | FDBARCHIVE_MAX_AGE=3 | ||
+ | </ | ||
+ | |||
+ | |||
+ | В конфиг userstats.ini добавить: | ||
+ | <code ini> | ||
+ | VISOR_ENABLED=0 | ||
+ | TRINITYTV_CHANLIST_URL="" | ||
+ | </ | ||
+ | |||
+ | В конфиг ymaps.ini добавить: | ||
+ | <code ini> | ||
+ | LEAFLET_TILE_LAYER="" | ||
+ | </ | ||
+ | |||
+ | |||
+ | |||
+ | Изменения в структуре БД: | ||
+ | <code sql> | ||
+ | ALTER TABLE `visor_users` ADD `primarylogin` VARCHAR(255) NULL AFTER `chargecams`, | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `fdbarchive` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `date` datetime NOT NULL, | ||
+ | `devid` int(11) DEFAULT NULL, | ||
+ | `devip` varchar(64) DEFAULT NULL, | ||
+ | `data` longtext, | ||
+ | `pon` tinyint(4) DEFAULT ' | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `devid` (`devid`, | ||
+ | KEY `pon` (`pon`) | ||
+ | ) ENGINE=MyISAM | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `askcalls` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `filename` varchar(250) DEFAULT NULL, | ||
+ | `login` varchar(250) DEFAULT NULL, | ||
+ | | ||
+ | ) ENGINE=MyISAM | ||
+ | </ | ||
+ | |||
+ | ====== 0.9.9 ====== | ||
+ | |||
+ | Просто обновляемся автообновлятором и нажимаем кнопочки в менеджере обновлений, | ||
+ | |||
+ | Ну, а для закоренелых мануальнорежимников: | ||
+ | |||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | BANKSTA2_ENABLED=0 | ||
+ | BANKSTA2_PAYMENTID_INET=24 | ||
+ | BANKSTA2_PAYMENTID_UKV=25 | ||
+ | VISOR_ENABLED=0 | ||
+ | </ | ||
+ | |||
+ | В конфиг userstats.ini добавить: | ||
+ | <code ini> | ||
+ | SWEETTV_ENABLED=0 | ||
+ | TRINITYTV_GUIDE_URL="" | ||
+ | </ | ||
+ | |||
+ | И, конечно же, изменения в структуре БД: | ||
+ | <code sql> | ||
+ | CREATE TABLE IF NOT EXISTS `banksta2` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `date` datetime NOT NULL, | ||
+ | `hash` varchar(255) NOT NULL, | ||
+ | `filename` varchar(255) DEFAULT NULL, | ||
+ | `admin` varchar(255) NOT NULL, | ||
+ | `contract` varchar(255) DEFAULT NULL, | ||
+ | `summ` varchar(42) NOT NULL, | ||
+ | `address` varchar(255) DEFAULT NULL, | ||
+ | `realname` varchar(255) DEFAULT NULL, | ||
+ | `notes` varchar(255) DEFAULT NULL, | ||
+ | `pdate` varchar(42) DEFAULT NULL, | ||
+ | `ptime` varchar(42) DEFAULT NULL, | ||
+ | `processed` tinyint(4) NOT NULL, | ||
+ | `canceled` tinyint(4) NOT NULL, | ||
+ | `service_type` varchar(100) NOT NULL DEFAULT '', | ||
+ | `payid` int(11) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `banksta2_presets` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `presetname` varchar(80) NOT NULL, | ||
+ | `col_realname` varchar(20) DEFAULT '', | ||
+ | `col_address` varchar(20) DEFAULT '', | ||
+ | `col_paysum` varchar(20) DEFAULT '', | ||
+ | `col_paypurpose` varchar(20) DEFAULT '', | ||
+ | `col_paydate` varchar(20) DEFAULT '', | ||
+ | `col_paytime` varchar(20) DEFAULT '', | ||
+ | `col_contract` varchar(20) DEFAULT '', | ||
+ | `guess_contract` tinyint(3) DEFAULT 0, | ||
+ | `contract_delim_start` varchar(40) DEFAULT '', | ||
+ | `contract_delim_end` varchar(40) DEFAULT '', | ||
+ | `contract_min_len` tinyint(3) DEFAULT 0, | ||
+ | `contract_max_len` tinyint(3) DEFAULT 0, | ||
+ | `service_type` varchar(100) NOT NULL DEFAULT '', | ||
+ | `inet_srv_start_delim` varchar(40) DEFAULT '', | ||
+ | `inet_srv_end_delim` varchar(40) DEFAULT '', | ||
+ | `inet_srv_keywords` varchar(200) DEFAULT '', | ||
+ | `ukv_srv_start_delim` varchar(40) DEFAULT '', | ||
+ | `ukv_srv_end_delim` varchar(40) DEFAULT '', | ||
+ | `ukv_srv_keywords` varchar(200) DEFAULT '', | ||
+ | `skip_row` tinyint(3) DEFAULT 0, | ||
+ | `col_skiprow` varchar(20) DEFAULT '', | ||
+ | `skip_row_keywords` varchar(200) DEFAULT '', | ||
+ | PRIMARY KEY (`id`), | ||
+ | UNIQUE KEY (`presetname`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `visor_users` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `regdate` datetime NOT NULL, | ||
+ | `realname` varchar(250) DEFAULT NULL, | ||
+ | `phone` varchar(40) DEFAULT NULL, | ||
+ | `chargecams` tinyint(4) NOT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `visor_cams` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `visorid` int(11) NOT NULL, | ||
+ | `login` varchar(250) NOT NULL, | ||
+ | `primary` tinyint(4) NOT NULL, | ||
+ | `camlogin` varchar(250) DEFAULT NULL, | ||
+ | `campassword` varchar(250) DEFAULT NULL, | ||
+ | `port` int(11) DEFAULT NULL, | ||
+ | `dvrid` int(11) DEFAULT NULL, | ||
+ | `dvrlogin` varchar(250) DEFAULT NULL, | ||
+ | `dvrpassword` varchar(250) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `visor_dvrs` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `ip` varchar(250) NOT NULL, | ||
+ | `port` int(11) DEFAULT NULL, | ||
+ | `login` varchar(250) DEFAULT NULL, | ||
+ | `password` varchar(250) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | </ | ||
+ | |||
+ | ====== 0.9.8 ====== | ||
+ | |||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | PRINT_RECEIPTS_ENABLED=0 | ||
+ | MULTIGEN_POD_ON_IP_CHANGE=0 | ||
+ | </ | ||
+ | |||
+ | Опять изменения в структуре БД, но вы уже должно быть привыкли всё руками накатывать, | ||
+ | <code sql> | ||
+ | ALTER TABLE `pononu` ADD KEY login (`login`); | ||
+ | </ | ||
+ | |||
+ | ====== 0.9.7 ====== | ||
+ | Просто обновляемся обновлятором и нажимаем полторы кнопки в " | ||
+ | Но если Вы недостаточно ленивы: | ||
+ | |||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | NMLEASES_EXTEND=0 | ||
+ | IGNORE_PASSWORD_UNIQUE=0 | ||
+ | WAREHOUSE_RECPRICE=0 | ||
+ | EASY_CHARGE=0 | ||
+ | DDT_ENABLED=0 | ||
+ | MULTIGEN_POD_ON_MAC_CHANGE=0 | ||
+ | </ | ||
+ | |||
+ | В конфиг userstats.ini добавить: | ||
+ | <code ini> | ||
+ | PC_SERIES_AND_SN=0 | ||
+ | PC_SERIES_LENGTH=4 | ||
+ | </ | ||
+ | |||
+ | Ну и как без изменений структуры БД? Да никак. | ||
+ | <code sql> | ||
+ | CREATE TABLE IF NOT EXISTS `capabhist` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `capabid` int(11) NOT NULL, | ||
+ | `admin` varchar(40) NOT NULL, | ||
+ | `date` datetime NOT NULL, | ||
+ | `type` varchar(40) NOT NULL, | ||
+ | `event` varchar(255) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | ALTER TABLE `ddt_options` ADD `setcredit` TINYINT NULL AFTER `chargeuntilday`; | ||
+ | </ | ||
+ | |||
+ | |||
+ | ====== 0.9.6 ====== | ||
+ | Просто обновляемся обновлятором и нажимаем полторы кнопки в " | ||
+ | Но если Вам религия не позволяет или просто страаааашно: | ||
+ | |||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | SIGMON_WCPE_AP_LIST_SORT=" | ||
+ | DEVICES_LISTS_SORT_BY_MODELNAME=0 | ||
+ | PON_UI_USE_TABS=0 | ||
+ | ANDROID_ENABLED=1 | ||
+ | MAPON_ENABLED=0 | ||
+ | MAPON_APIKEY="" | ||
+ | </ | ||
+ | |||
+ | Ого, еще и патчи на БД | ||
+ | <code sql> | ||
+ | CREATE TABLE IF NOT EXISTS `ddt_options` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `tariffname` varchar(40) NOT NULL, | ||
+ | `period` varchar(10) NOT NULL, | ||
+ | `startnow` tinyint(4) NOT NULL, | ||
+ | `duration` int(11) NOT NULL, | ||
+ | `chargefee` tinyint(4) NOT NULL, | ||
+ | `chargeuntilday` int(11) DEFAULT NULL, | ||
+ | `tariffmove` varchar(40) NOT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `ddt_users` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `login` varchar(32) NOT NULL, | ||
+ | `active` tinyint(4) NOT NULL, | ||
+ | `startdate` datetime NOT NULL, | ||
+ | `curtariff` varchar(40) NOT NULL, | ||
+ | `enddate` date NOT NULL, | ||
+ | `nexttariff` varchar(40) NOT NULL, | ||
+ | `dwiid` int(11) NOT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `switch_groups` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `groupname` varchar(255) NOT NULL, | ||
+ | `groupdescr` varchar(500) NOT NULL DEFAULT '', | ||
+ | PRIMARY KEY (`id`), | ||
+ | UNIQUE KEY (`groupname`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `switch_groups_relations` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `switch_id` int(11) NOT NULL, | ||
+ | `sw_group_id` int(11) NOT NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | UNIQUE KEY (`switch_id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | </ | ||
+ | |||
+ | ====== 0.9.5 ====== | ||
+ | Не поверите, | ||
+ | |||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | FWTBT_ENABLED=0 | ||
+ | FWTBT_ANYWHERE=0 | ||
+ | FWTBT_ADMINS="" | ||
+ | FWTBT_INTERVAL=7 | ||
+ | FWTBT_TIMER=10 | ||
+ | FWTBT_DESKTOP=0 | ||
+ | CALLSHIST_ENABLED=0 | ||
+ | STICKY_REVELATIONS_ENABLED=0 | ||
+ | IPCHANGE_ARP_CLEANUP=0 | ||
+ | ISHIMURA_ENABLED=0 | ||
+ | PONCPE_CONTROLS_ENABLED=0 | ||
+ | </ | ||
+ | |||
+ | В конфиг userstats.ini добавить: | ||
+ | <code ini> | ||
+ | ISHIMURA_ENABLED=0 | ||
+ | </ | ||
+ | |||
+ | И что-то произошло с базой, да. | ||
+ | <code sql> | ||
+ | ALTER TABLE `employee` ADD `amountLimit` VARCHAR(45) NOT NULL DEFAULT ' | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `callshist` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `date` datetime NOT NULL, | ||
+ | `number` varchar(120) NOT NULL, | ||
+ | `login` varchar(255) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `login` (`login`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `stickyrevelations` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `owner` varchar(255) NOT NULL, | ||
+ | `showto` text, | ||
+ | `createdate` datetime NOT NULL, | ||
+ | `dayfrom` int(11) DEFAULT NULL, | ||
+ | `dayto` int(11) DEFAULT NULL, | ||
+ | `active` tinyint(1) NOT NULL DEFAULT ' | ||
+ | `text` text, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `owner` (`owner`), | ||
+ | KEY `dayfrom` (`dayfrom`), | ||
+ | KEY `dayto` (`dayto`), | ||
+ | KEY `active` (`active`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | ALTER TABLE `trinitytv_tariffs` ADD `description` VARCHAR(128) NULL DEFAULT NULL AFTER `name`; | ||
+ | |||
+ | ALTER TABLE `wh_reshist` ADD `resid` INT NULL AFTER `id`; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `mlg_ishimura` ( | ||
+ | `login` varchar(50) DEFAULT NULL, | ||
+ | `month` tinyint(4) DEFAULT NULL, | ||
+ | `year` smallint(6) DEFAULT NULL, | ||
+ | `U0` bigint(20) DEFAULT NULL, | ||
+ | `D0` bigint(20) DEFAULT NULL, | ||
+ | `cash` double DEFAULT NULL, | ||
+ | KEY `login` (`login`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; | ||
+ | </ | ||
+ | |||
+ | ====== 0.9.4 ====== | ||
+ | А двайте вы наконец будете использовать менеджер обновлений для всего этого? | ||
+ | |||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | TRINITYTV_ENABLED=0 | ||
+ | TRINITYTV_PARTNER_ID="" | ||
+ | TRINITYTV_SALT="" | ||
+ | TRINITYTV_DEBUG=0 | ||
+ | SALARY_TELEGRAM=0 | ||
+ | WAREHOUSE_TELEGRAM=0 | ||
+ | </ | ||
+ | |||
+ | В конфиг userstats.ini добавить: | ||
+ | <code ini> | ||
+ | TRINITYTV_ENABLED=0 | ||
+ | TRINITYTV_PROTECTION=1 | ||
+ | </ | ||
+ | |||
+ | А еще тут зверский патч на базу | ||
+ | <code sql> | ||
+ | CREATE TABLE IF NOT EXISTS `trinitytv_devices` ( | ||
+ | `id` int(11) NOT NULL, | ||
+ | `login` varchar(255) DEFAULT NULL, | ||
+ | `subscriber_id` int(11) DEFAULT NULL, | ||
+ | `mac` varchar(128) NOT NULL, | ||
+ | `created_at` datetime DEFAULT NULL | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; | ||
+ | |||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `trinitytv_subscribers` ( | ||
+ | `id` int(11) NOT NULL, | ||
+ | `login` varchar(255) NOT NULL, | ||
+ | `contracttrinity` bigint(20) DEFAULT NULL, | ||
+ | `tariffid` int(11) NOT NULL, | ||
+ | `actdate` datetime NOT NULL, | ||
+ | `active` tinyint(1) NOT NULL DEFAULT ' | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; | ||
+ | |||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `trinitytv_suspend` ( | ||
+ | `id` int(11) NOT NULL, | ||
+ | `login` varchar(255) NOT NULL | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; | ||
+ | |||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `trinitytv_tariffs` ( | ||
+ | `id` int(11) NOT NULL, | ||
+ | `name` varchar(255) NOT NULL, | ||
+ | `fee` double DEFAULT ' | ||
+ | `serviceid` varchar(45) DEFAULT NULL | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; | ||
+ | |||
+ | |||
+ | ALTER TABLE `trinitytv_devices` | ||
+ | ALTER TABLE `trinitytv_subscribers` | ||
+ | ALTER TABLE `trinitytv_suspend` | ||
+ | ALTER TABLE `trinitytv_tariffs` | ||
+ | ALTER TABLE `trinitytv_devices` | ||
+ | ALTER TABLE `trinitytv_subscribers` | ||
+ | ALTER TABLE `trinitytv_suspend` | ||
+ | ALTER TABLE `trinitytv_tariffs` | ||
+ | |||
+ | ALTER TABLE `sms_history` MODIFY `msg_text` varchar(500) NOT NULL DEFAULT ''; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `pononuextusers` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `onuid` int(11) NOT NULL, | ||
+ | `login` VARCHAR(255) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | |||
+ | ALTER TABLE `corp_persons` ADD COLUMN `notes` TEXT NULL AFTER `appointment`; | ||
+ | </ | ||
+ | |||
+ | ====== 0.9.3 ====== | ||
+ | Вы еще не научились пользоваться для этого менеджером обновлений? | ||
+ | |||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | QINQ_ENABLED=0 | ||
+ | SMS_SERVICES_ADVANCED_ENABLED=0 | ||
+ | BANKSTAMD_ENABLED=0 | ||
+ | </ | ||
+ | |||
+ | В конфиг userstats.ini добавить: | ||
+ | <code ini> | ||
+ | PC_QUEUED=0 | ||
+ | </ | ||
+ | |||
+ | а еще, вы не поверите - такие вот патчи на БД | ||
+ | <code sql> | ||
+ | ALTER TABLE `ukv_users` ADD `tariffnmid` INT NULL AFTER `tariffid`; | ||
+ | ALTER TABLE `sms_history` ADD `smssrvid` INT(11) NOT NULL DEFAULT 0 AFTER `id`; | ||
+ | ALTER TABLE `sms_history` ADD INDEX(`smssrvid`); | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `sms_services` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `name` varchar(255) NOT NULL, | ||
+ | `login` varchar(255) NOT NULL, | ||
+ | `passwd` varchar(255) NOT NULL, | ||
+ | `url_addr` varchar(255) NOT NULL, | ||
+ | `api_key` varchar(255) NOT NULL, | ||
+ | `alpha_name` varchar(40) NOT NULL, | ||
+ | `default_service` tinyint(1) UNSIGNED DEFAULT 0, | ||
+ | `api_file_name` varchar(255) NOT NULL DEFAULT '', | ||
+ | PRIMARY KEY (`id`), | ||
+ | UNIQUE KEY (`name`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `sms_services_relations` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `sms_srv_id` int(11) NOT NULL, | ||
+ | `user_login` varchar(255) DEFAULT NULL, | ||
+ | `employee_id` varchar(255) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | UNIQUE KEY (`user_login`), | ||
+ | UNIQUE KEY (`employee_id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `switches_qinq` ( | ||
+ | `switchid` int(11) NOT NULL, | ||
+ | `svlan` int(11) NOT NULL, | ||
+ | `cvlan` int(11) NOT NULL, | ||
+ | PRIMARY KEY (`switchid`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `bankstamd` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `date` datetime NOT NULL, | ||
+ | `hash` varchar(255) NOT NULL, | ||
+ | `filename` varchar(255) DEFAULT NULL, | ||
+ | `admin` varchar(255) NOT NULL, | ||
+ | `contract` varchar(255) DEFAULT NULL, | ||
+ | `summ` varchar(42) NOT NULL, | ||
+ | `address` varchar(255) DEFAULT NULL, | ||
+ | `realname` varchar(255) DEFAULT NULL, | ||
+ | `notes` varchar(255) DEFAULT NULL, | ||
+ | `pdate` varchar(42) DEFAULT NULL, | ||
+ | `ptime` varchar(42) DEFAULT NULL, | ||
+ | `processed` tinyint(4) NOT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; | ||
+ | </ | ||
+ | |||
+ | ====== 0.9.2 ====== | ||
+ | Кто вам запрещает использовать менеджер обновлений, | ||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | ROUTEROS_VERSION_TELEPATHY=1 | ||
+ | ROUTEROS_VERSION_GET_WEB_PORT=" | ||
+ | ROUTEROS_VERSION_GET_SNMP_COMMUNITY=" | ||
+ | DROPDOWN_LISTS_IPSERVICE_ORDER_BY_DESCR=0 | ||
+ | USERREG_MAC_INPUT_ENABLED=0 | ||
+ | SPHINX_SEARCH_ENABLED=0 | ||
+ | SPHINX_SEARCH_HOST=" | ||
+ | SPHINX_SEARCH_SQL_PORT=" | ||
+ | SPHINX_SEARCH_USER="" | ||
+ | SPHINX_SEARCH_PASSWORD="" | ||
+ | SPHINX_SEARCH_DB="" | ||
+ | PONIZER_LEGACY_VIEW=0 | ||
+ | WHITEBOARD_ENABLED=0 | ||
+ | OMEGATV_ENABLED=0 | ||
+ | OMEGATV_PUBLIC_KEY="" | ||
+ | OMEGATV_PRIVATE_KEY="" | ||
+ | </ | ||
+ | |||
+ | В конфиг userstats.ini добавить: | ||
+ | <code ini> | ||
+ | SC_HACKCONTROL=0 | ||
+ | OM_ENABLED=0 | ||
+ | OM_PROTECTION=1 | ||
+ | </ | ||
+ | |||
+ | Ух ты, в базе тоже что-то поменялось | ||
+ | <code sql> | ||
+ | CREATE TABLE IF NOT EXISTS `whiteboard` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `categoryid` int(11) NOT NULL, | ||
+ | `admin` varchar(255) NOT NULL, | ||
+ | `employeeid` int(11) DEFAULT NULL, | ||
+ | `createdate` datetime NOT NULL, | ||
+ | `donedate` datetime DEFAULT NULL, | ||
+ | `priority` int(11) NOT NULL, | ||
+ | `name` varchar(255) NOT NULL, | ||
+ | `text` text, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `taskmanlogs` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `taskid` int(11) NOT NULL, | ||
+ | `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, | ||
+ | `admin` varchar(45) DEFAULT NULL, | ||
+ | `ip` varchar(64) DEFAULT NULL, | ||
+ | `event` varchar(255) NOT NULL, | ||
+ | `logs` text, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `taskid` (`taskid`) USING BTREE, | ||
+ | KEY `date` (`date`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `om_tariffs` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `tariffid` int(11) NOT NULL, | ||
+ | `tariffname` varchar(255) NOT NULL, | ||
+ | `type` varchar(64) NOT NULL, | ||
+ | `fee` DOUBLE DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `om_users` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `login` varchar(255) NOT NULL, | ||
+ | `customerid` bigint(20) NOT NULL, | ||
+ | `basetariffid` int(11) DEFAULT NULL, | ||
+ | `bundletariffs` varchar(255) DEFAULT NULL, | ||
+ | `active` int(11) DEFAULT NULL, | ||
+ | `actdate` datetime NOT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `om_queue` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `customerid` bigint(20) NOT NULL, | ||
+ | `tariffid` int(11) DEFAULT NULL, | ||
+ | `action` varchar(64) NOT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `om_suspend` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `login` varchar(255) NOT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | </ | ||
+ | |||
+ | ====== 0.9.1 ====== | ||
+ | Кто вам запрещает использовать менеджер обновлений, | ||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | SMS_HISTORY_ON=0 | ||
+ | SMS_CHECKSTATUS_EXPIRE_DAYS=7 | ||
+ | USERPROFILE_APINFO_AUTOLOAD=0 | ||
+ | TASKMAN_ADV_FILTERS=0 | ||
+ | ONEPUNCH_ENABLED=1 | ||
+ | </ | ||
+ | |||
+ | В конфиг **userstats.ini** добавить: | ||
+ | <code ini> | ||
+ | DOCX_DENY_SELFGEN=0 | ||
+ | </ | ||
+ | |||
+ | Патч на структуру БД: | ||
+ | |||
+ | <code sql> | ||
+ | ALTER TABLE `dealwithithist` ADD `datetimedone` DATETIME NULL DEFAULT NULL AFTER `date`; | ||
+ | |||
+ | UPDATE `dealwithithist` as `C` INNER JOIN (SELECT `mtime`, | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `taskmandone` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `taskid` int(11) DEFAULT NULL, | ||
+ | `date` datetime NOT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | | ||
+ | CREATE TABLE IF NOT EXISTS `sms_history` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `login` varchar(255) NOT NULL, | ||
+ | `phone` varchar(255) NOT NULL, | ||
+ | `srvmsgself_id` varchar(255) NOT NULL, | ||
+ | `srvmsgpack_id` varchar(255) NOT NULL, | ||
+ | `date_send` datetime NOT NULL, | ||
+ | `date_statuschk` datetime NOT NULL, | ||
+ | `delivered` tinyint(1) UNSIGNED DEFAULT 0, | ||
+ | `no_statuschk` tinyint(1) UNSIGNED DEFAULT 0, | ||
+ | `send_status` varchar(255) NOT NULL DEFAULT '', | ||
+ | `msg_text` varchar(255) NOT NULL DEFAULT '', | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `login` (`login`) USING BTREE, | ||
+ | KEY `phone` (`phone`) USING BTREE, | ||
+ | KEY `date_send` (`date_send`) USING BTREE | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `punchscripts` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `alias` varchar(255) NOT NULL, | ||
+ | `name` varchar(255) NOT NULL, | ||
+ | `content` text, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `alias` (`alias`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | </ | ||
+ | |||
+ | ====== 0.9.0 ====== | ||
+ | И все еще не все научились пользоваться менеджером обновлений? | ||
+ | |||
+ | В конфиг **alter.ini** добавить: | ||
+ | <code ini> | ||
+ | FREEZE_DAYS_CHARGE_ENABLED=0 | ||
+ | FREEZE_DAYS_INITIAL_AMOUNT=365 | ||
+ | FREEZE_DAYS_WORK_TO_RESTORE=120 | ||
+ | UKV_SHOW_REG_DATA=0 | ||
+ | ONLINE_SHOW_CONTRACT_FIELD=0 | ||
+ | ONLINE_SHOW_CONTRACT_DATE=0 | ||
+ | MULTIGEN_ENABLED=0 | ||
+ | DISTRICTS_ENABLED=0 | ||
+ | DISRTICTS_IN_PROFILE=0 | ||
+ | SWITCHES_SNMP_MAC_EXORCISM=0 | ||
+ | </ | ||
+ | |||
+ | В конфиг **userstats.ini** добавить: | ||
+ | <code ini> | ||
+ | FREEZE_DAYS_CHARGE_ENABLED=0 | ||
+ | FREEZE_DAYS_INITIAL_AMOUNT=365 | ||
+ | FREEZE_DAYS_WORK_TO_RESTORE=120 | ||
+ | FREEZE_ALLOW_ON_NEGATIVE_BALANCE=0 | ||
+ | </ | ||
+ | |||
+ | |||
+ | Патч на структуру БД: | ||
+ | |||
+ | <code sql> | ||
+ | CREATE TABLE IF NOT EXISTS `frozen_charge_days` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `login` varchar(255) NOT NULL, | ||
+ | `freeze_days_amount` smallint(3) NOT NULL DEFAULT 0, | ||
+ | `freeze_days_used` | ||
+ | `work_days_restore` smallint(3) NOT NULL DEFAULT 0, | ||
+ | `days_worked` smallint(3) NOT NULL DEFAULT 0, | ||
+ | PRIMARY KEY (`id`), | ||
+ | UNIQUE KEY (`login`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | |||
+ | ALTER TABLE `wdycinfo` ADD `totaltrytime` INT NULL DEFAULT NULL ; | ||
+ | |||
+ | ALTER TABLE `exhorse` ADD `a_recallunsuccess` DOUBLE NULL DEFAULT NULL , | ||
+ | ADD `a_recalltrytime` INT NULL DEFAULT NULL , | ||
+ | ADD `e_deadswintervals` INT NULL DEFAULT NULL , | ||
+ | ADD `t_sigreq` INT NULL DEFAULT NULL , | ||
+ | ADD `t_tickets` INT NULL DEFAULT NULL , | ||
+ | ADD `t_tasks` INT NULL DEFAULT NULL , | ||
+ | ADD `t_capabtotal` INT NULL DEFAULT NULL , | ||
+ | ADD `t_capabundone` INT NULL DEFAULT NULL ; | ||
+ | |||
+ | ALTER TABLE `nethosts` ADD UNIQUE `net-ip` (`netid`, `ip`); | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `districtnames` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `name` varchar(255) NOT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `districtdata` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `districtid` int(11) NOT NULL, | ||
+ | `cityid` int(11) DEFAULT NULL, | ||
+ | `streetid` int(11) DEFAULT NULL, | ||
+ | `buildid` int(11) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | </ | ||
+ | |||
+ | ====== 0.8.9 ====== | ||
+ | |||
+ | Вы все еще не научились пользоваться менеджером обновлений, | ||
+ | |||
+ | В конфиг **userstats.ini** добавить: | ||
+ | <code ini> | ||
+ | SHOW_EXT_MOBILES=0 | ||
+ | </ | ||
+ | |||
+ | В конфиг **alter.ini** добавить: | ||
+ | <code ini> | ||
+ | PON_QUICK_OLT_LINKS=1 | ||
+ | PON_OLT_INDIVIDUAL_REPOLL_AJAX=1 | ||
+ | PON_ONU_CHARTS_SPOILER_CLOSED=0 | ||
+ | </ | ||
+ | ====== 0.8.8 ====== | ||
+ | Можете просто нажать две с половиной кнопки в " | ||
+ | |||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | SMSZILLA_ENABLED=0 | ||
+ | MTSIGMON_QUICK_AP_LINKS=1 | ||
+ | LDAPMGR_ENABLED=0 | ||
+ | MTSIGMON_CPE_AUTOPOLL=0 | ||
+ | </ | ||
+ | |||
+ | Патч на структуру БД: | ||
+ | |||
+ | <code sql> | ||
+ | CREATE TABLE IF NOT EXISTS `smz_templates` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `name` varchar(255) NOT NULL, | ||
+ | `text` varchar(255) NOT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | | ||
+ | CREATE TABLE IF NOT EXISTS `smz_filters` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `name` varchar(255) NOT NULL, | ||
+ | `filters` TEXT NOT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | | ||
+ | | ||
+ | CREATE TABLE IF NOT EXISTS `smz_lists` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `name` varchar(255) NOT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `smz_nums` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `numid` int(11) NOT NULL, | ||
+ | `mobile` varchar(40) NOT NULL, | ||
+ | `notes` varchar(255) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | | ||
+ | CREATE TABLE IF NOT EXISTS `smz_excl` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `mobile` varchar(40) NOT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | | ||
+ | | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `login` varchar(255) NOT NULL, | ||
+ | `password` varchar(255) NOT NULL, | ||
+ | `groups` TEXT DEFAULT NULL, | ||
+ | `changed` TINYINT(1) | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | | ||
+ | CREATE TABLE IF NOT EXISTS `ldap_groups` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `name` varchar(255) NOT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | | ||
+ | CREATE TABLE IF NOT EXISTS `ldap_queue` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `task` varchar(255) NOT NULL, | ||
+ | `param` TEXT DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | | ||
+ | ALTER TABLE `wcpedevices` ADD `snmp` VARCHAR(45) NULL DEFAULT NULL AFTER `mac`; | ||
+ | </ | ||
+ | |||
+ | ====== 0.8.7 ====== | ||
+ | |||
+ | Можете просто нажать две с половиной кнопки в " | ||
+ | |||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | MOBILES_EXT=0 | ||
+ | </ | ||
+ | |||
+ | Патч на структуру БД: | ||
+ | |||
+ | <code sql> | ||
+ | CREATE TABLE IF NOT EXISTS `mobileext` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `login` varchar(64) NOT NULL, | ||
+ | `mobile` varchar(64) NOT NULL, | ||
+ | `notes` varchar(255) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `login` (`login`, | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | </ | ||
+ | |||
+ | ====== 0.8.6 ====== | ||
+ | Можете просто нажать две с половиной кнопки в " | ||
+ | |||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | POLLS_ENABLED=0 | ||
+ | ONUMODELS_FILTER=0 | ||
+ | SORM_ENABLED=0 | ||
+ | ONUREG_ZTE=0 | ||
+ | ONU_MASTER_ENABLED=0 | ||
+ | </ | ||
+ | |||
+ | В конфиг userstats.ini добавить: | ||
+ | <code ini> | ||
+ | POLLS_ENABLED=0 | ||
+ | </ | ||
+ | |||
+ | В конфиг billing.ini добавить: | ||
+ | <code ini> | ||
+ | EXPECT_PATH="/ | ||
+ | </ | ||
+ | |||
+ | Патч на структуру БД: | ||
+ | |||
+ | <code sql> | ||
+ | ALTER TABLE `salary_jobs` ADD INDEX(`taskid`); | ||
+ | |||
+ | ALTER TABLE `wh_out` ADD INDEX(`desttype`); | ||
+ | |||
+ | ALTER TABLE `wh_out` ADD INDEX(`destparam`); | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `polls` ( | ||
+ | `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, | ||
+ | `title` varchar(255) NOT NULL DEFAULT '', | ||
+ | `enabled` tinyint(1) NOT NULL DEFAULT ' | ||
+ | `start_date` datetime NOT NULL DEFAULT ' | ||
+ | `end_date` datetime DEFAULT ' | ||
+ | `params` text NOT NULL, | ||
+ | `admin` varchar(255) NOT NULL DEFAULT '', | ||
+ | `voting` VARCHAR(255) NOT NULL DEFAULT ' | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `polls_options` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `poll_id` int(11) NOT NULL DEFAULT ' | ||
+ | `text` text NOT NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | UNIQUE KEY `poll_id` (`id`, | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `polls_votes` ( | ||
+ | `id` bigint(20) NOT NULL AUTO_INCREMENT, | ||
+ | `date` datetime NOT NULL DEFAULT ' | ||
+ | `option_id` int(11) NOT NULL DEFAULT ' | ||
+ | `poll_id` int(11) NOT NULL DEFAULT ' | ||
+ | `login` varchar(255) NOT NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | UNIQUE KEY `login_poll` (`poll_id`, | ||
+ | UNIQUE KEY `login_poll_option` (`option_id`, | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `zbsannhist` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `date` datetime NOT NULL, | ||
+ | `annid` int(11) NOT NULL, | ||
+ | `login` varchar(255) NOT NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `annid` (`annid`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | |||
+ | ALTER TABLE `vservices` ADD `fee_charge_always` TINYINT(1) NOT NULL DEFAULT 1; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `zte_cards` ( | ||
+ | `id` INT NOT NULL AUTO_INCREMENT, | ||
+ | `swid` INT NOT NULL, | ||
+ | `slot_number` INT NOT NULL, | ||
+ | `card_name` VARCHAR(5) NOT NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY (`swid`) ) | ||
+ | ENGINE = MyISAM DEFAULT CHARSET=UTF8; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `zte_vlan_bind` ( | ||
+ | `id` INT NOT NULL AUTO_INCREMENT, | ||
+ | `swid` INT NOT NULL, | ||
+ | `slot_number` INT NOT NULL, | ||
+ | `port_number` INT(2) NOT NULL, | ||
+ | `vlan` INT(4) NOT NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY (`swid`) ) | ||
+ | ENGINE = MyISAM DEFAULT CHARSET=UTF8; | ||
+ | |||
+ | ALTER TABLE `zte_cards` ADD COLUMN `chasis_number` INT (1) NOT NULL; | ||
+ | </ | ||
+ | |||
+ | ====== 0.8.5 ====== | ||
+ | |||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | PON_USERLINK_CHECK=0 | ||
+ | WIFICPE_ENABLED=0 | ||
+ | MACVEN_CACHE=1 | ||
+ | RESETHARD=0 | ||
+ | </ | ||
+ | |||
+ | В конфиг billing.ini добавить: | ||
+ | <code ini> | ||
+ | WGET_PATH="/ | ||
+ | TAR_PATH="/ | ||
+ | GZIP_PATH="/ | ||
+ | </ | ||
+ | |||
+ | А вот и патч на БД. | ||
+ | <code sql> | ||
+ | CREATE TABLE IF NOT EXISTS `wcpedevices` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `modelid` int(11) NOT NULL, | ||
+ | `ip` varchar(45) DEFAULT NULL, | ||
+ | `mac` varchar(45) DEFAULT NULL, | ||
+ | `location` varchar(255) DEFAULT NULL, | ||
+ | `bridge` tinyint(4) NOT NULL DEFAULT ' | ||
+ | `uplinkapid` int(11) DEFAULT NULL, | ||
+ | `uplinkcpeid` int(11) DEFAULT NULL, | ||
+ | `geo` varchar(255) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `wcpeusers` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `cpeid` int(11) NOT NULL, | ||
+ | `login` varchar(255) NOT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | </ | ||
+ | |||
+ | ====== 0.8.4 ====== | ||
+ | |||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | ONLINE_SHOW_FREEZE=0 | ||
+ | JUNGEN_ENABLED=0 | ||
+ | EASY_SMS=0 | ||
+ | NASMON_ENABLED=0 | ||
+ | ONUAUTO_USERREG=0 | ||
+ | </ | ||
+ | |||
+ | В конфиг userstats.ini добавить: | ||
+ | <code ini> | ||
+ | SP_TYPE=1 | ||
+ | INTRO_MODE=0 | ||
+ | </ | ||
+ | |||
+ | При помощи SQL консоли последовательно выполнить следующие запросы. Ну либо можете вспомнить, | ||
+ | <code sql> | ||
+ | ALTER TABLE `switches` ADD `snmpwrite` VARCHAR(45) NULL AFTER `swid`; | ||
+ | |||
+ | ALTER TABLE `phones` ADD INDEX (`login`); | ||
+ | |||
+ | ALTER TABLE `print_card` ADD UNIQUE (`title`); | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `dealwithithist` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | </ | ||
+ | |||
+ | |||
+ | ====== 0.8.3 ====== | ||
+ | |||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | DEALWITHIT_IN_PROFILE=0 | ||
+ | STREETS_ALIAS_AUTOGEN=1 | ||
+ | TASKMAN_TELEGRAM_PROFILE_CHECK=0 | ||
+ | TASKMAN_NEWTASK_AUTOTIME=0 | ||
+ | TASKMAN_NEWTASK_EMPSORT=0 | ||
+ | </ | ||
+ | |||
+ | В конфиг ymaps.ini добавить: | ||
+ | <code ini> | ||
+ | MAPS_SERVICE=" | ||
+ | GMAPS_APIKEY=" | ||
+ | </ | ||
+ | |||
+ | При помощи SQL консоли последовательно выполнить следующие запросы. Ну либо можете вспомнить, | ||
+ | <code sql> | ||
+ | CREATE TABLE IF NOT EXISTS `wdycinfo` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `date` date NOT NULL, | ||
+ | `missedcount` int(11) DEFAULT NULL, | ||
+ | `recallscount` int(11) DEFAULT NULL, | ||
+ | `unsucccount` int(11) DEFAULT NULL, | ||
+ | `missednumbers` text, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | ALTER TABLE `taskman` ADD `change_admin` VARCHAR(255) NULL DEFAULT NULL; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `wh_reshist` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `date` datetime NOT NULL, | ||
+ | `type` varchar(40) NOT NULL, | ||
+ | `storageid` int(11) DEFAULT NULL, | ||
+ | `itemtypeid` int(11) DEFAULT NULL, | ||
+ | `count` double DEFAULT NULL, | ||
+ | `employeeid` int(11) DEFAULT NULL, | ||
+ | `admin` varchar(100) NOT NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `date` (`date`, | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | ALTER TABLE `wh_in` ADD `admin` VARCHAR(100) NULL DEFAULT NULL AFTER `notes`; | ||
+ | |||
+ | ALTER TABLE `wh_out` ADD `admin` VARCHAR(100) NULL DEFAULT NULL AFTER `notes`; | ||
+ | |||
+ | ALTER TABLE `employee` ADD `tagid` INT(11) NULL DEFAULT NULL; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `admannouncements` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `title` varchar(255) DEFAULT NULL, | ||
+ | `text` text NOT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `admacquainted` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `date` datetime NOT NULL, | ||
+ | `admin` varchar(40) NOT NULL, | ||
+ | `annid` int(11) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `date` (`date`, | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | </ | ||
+ | |||
+ | ====== 0.8.2 ====== | ||
+ | |||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | BRANCHES_ENABLED=0 | ||
+ | ONUAUTO_CONFIG_REBOOT=0 | ||
+ | ONUAUTO_CONFIG_DESCRIBE=0 | ||
+ | CAP_PENALTY_PERCENT=0 | ||
+ | BURST_ENABLED=0 | ||
+ | </ | ||
+ | |||
+ | При помощи SQL консоли последовательно выполнить следующие запросы (19 штук). Ну либо можете попробовать после обновления воспользоваться новым модулем " | ||
+ | <code sql> | ||
+ | ALTER TABLE `stickynotes` ADD `remindtime` TIME DEFAULT NULL AFTER `reminddate`, | ||
+ | |||
+ | ALTER TABLE `employee` ADD `telegram` VARCHAR(40) NULL DEFAULT NULL AFTER `mobile`; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `branches` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `name` varchar(40) NOT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `branchesadmins` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `branchid` int(11) NOT NULL, | ||
+ | `admin` varchar(40) NOT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `branchesusers` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `branchid` int(11) NOT NULL, | ||
+ | `login` varchar(50) NOT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `branchescities` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `branchid` int(11) NOT NULL, | ||
+ | `cityid` int(11) NOT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `branchestariffs` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `branchid` int(11) NOT NULL, | ||
+ | `tariff` varchar(50) NOT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `branchesservices` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `branchid` int(11) NOT NULL, | ||
+ | `serviceid` int(11) NOT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | CREATE | ||
+ | `id` INT NOT NULL AUTO_INCREMENT , | ||
+ | `name` VARCHAR(255) NOT NULL , | ||
+ | `address` VARCHAR(255) NULL , | ||
+ | `geo` VARCHAR(255) NULL , | ||
+ | `contact` VARCHAR(255) NULL , | ||
+ | `count_cards` int(11) NULL , | ||
+ | `comment` TEXT NULL , | ||
+ | PRIMARY KEY (`id`) ) | ||
+ | ENGINE = MyISAM DEFAULT CHARSET=UTF8; | ||
+ | |||
+ | ALTER TABLE `cardbank` ADD `part` VARCHAR(255) NULL; | ||
+ | |||
+ | ALTER TABLE `cardbank` ADD `receipt_date` DATETIME NULL; | ||
+ | |||
+ | ALTER TABLE `cardbank` ADD `selling_id` int(11) NULL; | ||
+ | |||
+ | CREATE | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `title` varchar(255) NOT NULL, | ||
+ | `field` varchar(255) NOT NULL, | ||
+ | `color` varchar(255) DEFAULT '', | ||
+ | `font_size` int(11) DEFAULT NULL, | ||
+ | `top` int(11) DEFAULT NULL, | ||
+ | `left` int(11) DEFAULT NULL, | ||
+ | `text` text, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE = MyISAM DEFAULT CHARSET=UTF8; | ||
+ | |||
+ | INSERT INTO | ||
+ | `print_card` (`title`, `field`, `color`, `font_size`, | ||
+ | VALUES | ||
+ | (' | ||
+ | (' | ||
+ | (' | ||
+ | (' | ||
+ | (' | ||
+ | |||
+ | ALTER TABLE `speeds` ADD `burstdownload` VARCHAR(45) DEFAULT NULL; | ||
+ | |||
+ | ALTER TABLE `speeds` ADD `burstupload` VARCHAR(45) DEFAULT NULL; | ||
+ | |||
+ | ALTER TABLE `speeds` ADD `bursttimedownload` VARCHAR(45) DEFAULT NULL; | ||
+ | |||
+ | ALTER TABLE `speeds` ADD `burstimetupload` VARCHAR(45) DEFAULT NULL; | ||
+ | |||
+ | ALTER TABLE `uhw_brute` ADD `login` VARCHAR(255) NOT NULL AFTER `password`; | ||
+ | </ | ||
+ | |||
+ | ====== 0.8.1 ====== | ||
+ | |||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | ADMIN_NAMES=1 | ||
+ | TASKREPORT_ENABLED=0 | ||
+ | TASKREPORT_JOBTYPES=19, | ||
+ | TASKREPORT_SIGNUPJOBTYPES=19, | ||
+ | TASKREPORT_NOTESTAGIDS=31, | ||
+ | TASKREPORT_SIGPAYID=3 | ||
+ | POLICEDOG_ENABLED=0 | ||
+ | </ | ||
+ | |||
+ | При помощи SQL консоли последовательно выполнить следующие запросы (3 штуки) | ||
+ | <code sql> | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `policedog` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `date` datetime NOT NULL, | ||
+ | `mac` varchar(40) NOT NULL, | ||
+ | `notes` varchar(255) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `date` (`date`, | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `policedogalerts` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `date` datetime NOT NULL, | ||
+ | `mac` varchar(40) NOT NULL, | ||
+ | `login` varchar(255) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `date` (`date`, | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `ukv_tags` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `tagtypeid` int(11) NOT NULL, | ||
+ | `userid` int(11) NOT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | </ | ||
+ | |||
+ | ====== 0.8.0 ====== | ||
+ | |||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | SENDDOG_ENABLED=0 | ||
+ | TSUPPORT_API=0 | ||
+ | </ | ||
+ | |||
+ | |||
+ | В случае, | ||
+ | |||
+ | |||
+ | ====== 0.7.9 ====== | ||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | SWITCHES_EXTENDED=0 | ||
+ | WORKING_HOURS=" | ||
+ | TARIFF_REPORT_FULL=0 | ||
+ | </ | ||
+ | |||
+ | В конфиг userstats.ini добавить: | ||
+ | <code ini> | ||
+ | SKIN=" | ||
+ | </ | ||
+ | |||
+ | При помощи SQL консоли последовательно выполнить следующие запросы (2 штуки) | ||
+ | <code sql> | ||
+ | ALTER TABLE `switches` ADD `swid` VARCHAR(32) DEFAULT NULL; | ||
+ | |||
+ | ALTER TABLE `exhorse` ADD `f_cashmoney` DOUBLE NULL DEFAULT NULL AFTER `f_paymentscount`, | ||
+ | </ | ||
+ | |||
+ | ====== 0.7.8 ====== | ||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | EXHORSE_ENABLED=0 | ||
+ | UKV_ILLEGAL_TARIFFID=10 | ||
+ | UKV_COMPLEX_TARIFFID=11 | ||
+ | UKV_SOCIAL_TARIFFID=1 | ||
+ | </ | ||
+ | |||
+ | |||
+ | При помощи SQL консоли выполнить следующий запрос | ||
+ | <code sql> | ||
+ | CREATE TABLE IF NOT EXISTS `exhorse` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `date` datetime NOT NULL, | ||
+ | `u_totalusers` int(11) DEFAULT NULL, | ||
+ | `u_activeusers` int(11) DEFAULT NULL, | ||
+ | `u_inactiveusers` int(11) DEFAULT NULL, | ||
+ | `u_frozenusers` int(11) DEFAULT NULL, | ||
+ | `u_complextotal` int(11) DEFAULT NULL, | ||
+ | `u_complexactive` int(11) DEFAULT NULL, | ||
+ | `u_complexinactive` int(11) DEFAULT NULL, | ||
+ | `u_signups` int(11) DEFAULT NULL, | ||
+ | `u_citysignups` text, | ||
+ | `f_totalmoney` double DEFAULT NULL, | ||
+ | `f_paymentscount` int(11) DEFAULT NULL, | ||
+ | `f_arpu` double DEFAULT NULL, | ||
+ | `f_arpau` double DEFAULT NULL, | ||
+ | `c_totalusers` int(11) DEFAULT NULL, | ||
+ | `c_activeusers` int(11) DEFAULT NULL, | ||
+ | `c_inactiveusers` int(11) DEFAULT NULL, | ||
+ | `c_illegal` int(11) DEFAULT NULL, | ||
+ | `c_complex` int(11) DEFAULT NULL, | ||
+ | `c_social` int(11) DEFAULT NULL, | ||
+ | `c_totalmoney` double DEFAULT NULL, | ||
+ | `c_paymentscount` int(11) DEFAULT NULL, | ||
+ | `c_arpu` double DEFAULT NULL, | ||
+ | `c_arpau` double DEFAULT NULL, | ||
+ | `c_totaldebt` double DEFAULT NULL, | ||
+ | `c_signups` int(11) DEFAULT NULL, | ||
+ | `a_totalcalls` int(11) DEFAULT NULL, | ||
+ | `a_totalanswered` int(11) DEFAULT NULL, | ||
+ | `a_totalcallsduration` int(11) DEFAULT NULL, | ||
+ | `a_averagecallduration` int(11) DEFAULT NULL, | ||
+ | `e_switches` int(11) DEFAULT NULL, | ||
+ | `e_pononu` int(11) DEFAULT NULL, | ||
+ | `e_docsis` int(11) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | </ | ||
+ | |||
+ | ====== 0.7.7 ====== | ||
+ | |||
+ | В конфиг userstats.ini добавить: | ||
+ | <code ini> | ||
+ | UKV_ENABLED=0 | ||
+ | </ | ||
+ | |||
+ | |||
+ | ====== 0.7.6 ====== | ||
+ | При обновлении ничего делать не нужно. Просто обновляемся обновлятором. | ||
+ | |||
+ | ====== 0.7.5 ====== | ||
+ | |||
+ | В конфиг userstats.ini добавить: | ||
+ | <code ini> | ||
+ | MG_PROTECTION=0 | ||
+ | MG_GUIDE_URL="" | ||
+ | </ | ||
+ | |||
+ | ====== 0.7.4 ====== | ||
+ | В конфиг userstats.ini добавить: | ||
+ | <code ini> | ||
+ | ADSERVICE_ENABLED=0 | ||
+ | ADSERVICE_DATE=" | ||
+ | ADSERVICE_NAMES=" | ||
+ | ADSERVICE_COST=" | ||
+ | </ | ||
+ | ====== 0.7.3 ====== | ||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | SIGNAL_IN_PROFILE=0 | ||
+ | DEALWITHIT_ENABLED=0 | ||
+ | MG_ENABLED=0 | ||
+ | MG_PARTNERID=" | ||
+ | MG_PREFIX=" | ||
+ | MG_SALT=" | ||
+ | MG_SPREAD=0 | ||
+ | MG_PERCENT=15 | ||
+ | </ | ||
+ | |||
+ | В конфиг userstats.ini добавить: | ||
+ | <code ini> | ||
+ | MG_ENABLED=0 | ||
+ | API_URL=" | ||
+ | API_KEY="" | ||
+ | </ | ||
+ | |||
+ | При помощи SQL консоли последовательно выполнить следующие запросы (5 штук) | ||
+ | <code sql> | ||
+ | CREATE TABLE IF NOT EXISTS `dealwithit` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `mg_tariffs` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | | ||
+ | `fee` double DEFAULT NULL, | ||
+ | | ||
+ | | ||
+ | | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `mg_subscribers` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `mg_history` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `mg_queue` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | </ | ||
+ | |||
+ | ====== 0.7.2 ====== | ||
+ | При помощи SQL консоли последовательно выполнить следующие запросы (всего 3 штучки) | ||
+ | <code sql> | ||
+ | ALTER TABLE `switch_login` ADD `snmptemplate` VARCHAR(32) DEFAULT NULL; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `vlan_mac_history` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `login` varchar(45) DEFAULT NULL, | ||
+ | `vlan` int(4) DEFAULT NULL, | ||
+ | `mac` varchar(45) DEFAULT NULL, | ||
+ | `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `taskmantrack` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `taskid` int(11) NOT NULL, | ||
+ | `admin` varchar(255) NOT NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `taskid` (`taskid`, | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | </ | ||
+ | |||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | FREEZEMONTH_CASHTYPE=1 | ||
+ | FREEZEMONTH_COST=0 | ||
+ | USERSIDE_API=0 | ||
+ | VLANMACHISTORY=0 | ||
+ | VLAN_ONLINE_IN_PROFILE=0 | ||
+ | </ | ||
+ | |||
+ | ====== 0.7.1 ====== | ||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | REMINDER_ENABLED=0 | ||
+ | REMINDER_TAGID=1 | ||
+ | REMINDER_DAYS_THRESHOLD=2 | ||
+ | REMINDER_PREFIX=" | ||
+ | REMINDER_TEMPLATE=" | ||
+ | FRIENDSHIP_ENABLED=0 | ||
+ | FRIENDSHIP_PERCENT=10 | ||
+ | FRIENDSHIP_CASHTYPEID=1 | ||
+ | </ | ||
+ | |||
+ | В конфиг userstats.ini добавить: | ||
+ | <code ini> | ||
+ | REMINDER_ENABLED=0 | ||
+ | REMINDER_PRICE=1 | ||
+ | REMINDER_TAGID=1 | ||
+ | REMINDER_NUMBER_LENGTH=9 | ||
+ | REMINDER_DAYS_THRESHOLD=2 | ||
+ | REMINDER_PREFIX=" | ||
+ | REMINDER_CHANGE_NUMBER=0 | ||
+ | REMINDER_FEE=1 | ||
+ | REMINDER_CASHTYPEID=1 | ||
+ | REMINDER_TURNOFF=1 | ||
+ | </ | ||
+ | |||
+ | При помощи SQL консоли последовательно выполнить следующие запросы (да, всего 4 штучки): | ||
+ | <code sql> | ||
+ | CREATE TABLE IF NOT EXISTS `wh_reserve` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `storageid` int(11) NOT NULL, | ||
+ | `itemtypeid` int(11) NOT NULL, | ||
+ | `count` double NOT NULL, | ||
+ | `employeeid` int(11) NOT NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `storageid` (`storageid`), | ||
+ | KEY `itemtypeid` (`itemtypeid`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `friendship` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `friend` varchar(255) NOT NULL, | ||
+ | `parent` varchar(255) NOT NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `friend` (`friend`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | ALTER TABLE `taskman` ADD INDEX(`address`); | ||
+ | |||
+ | ALTER TABLE `taskman` ADD INDEX(`startdate`); | ||
+ | </ | ||
+ | |||
+ | ====== 0.7.0 ====== | ||
+ | |||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | PHONEBOOK_ENABLED=0 | ||
+ | WAREHOUSE_ENABLED=0 | ||
+ | </ | ||
+ | |||
+ | |||
+ | При помощи SQL консоли последовательно выполнить следующие запросы (да все восемь штук): | ||
+ | <code sql> | ||
+ | CREATE TABLE IF NOT EXISTS `contacts` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `phone` varchar(255) NOT NULL, | ||
+ | `name` varchar(255) NOT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `wh_categories` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `name` varchar(255) NOT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `wh_itemtypes` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `categoryid` int(11) NOT NULL, | ||
+ | `name` varchar(255) NOT NULL, | ||
+ | `unit` varchar(40) NOT NULL, | ||
+ | `reserve` double DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `categoryid` (`categoryid`, | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `wh_storages` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `name` varchar(255) NOT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `wh_contractors` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `name` varchar(255) NOT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `wh_in` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `date` date NOT NULL, | ||
+ | `itemtypeid` int(11) NOT NULL, | ||
+ | `contractorid` int(11) NOT NULL, | ||
+ | `count` double NOT NULL, | ||
+ | `barcode` varchar(255) DEFAULT NULL, | ||
+ | `price` double DEFAULT NULL, | ||
+ | `storageid` int(11) NOT NULL, | ||
+ | `notes` varchar(255) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `date` (`date`, | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `wh_out` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `date` date NOT NULL, | ||
+ | `desttype` varchar(40) NOT NULL, | ||
+ | `destparam` varchar(255) NOT NULL, | ||
+ | `storageid` int(11) NOT NULL, | ||
+ | `itemtypeid` int(11) NOT NULL, | ||
+ | `count` double NOT NULL, | ||
+ | `price` double DEFAULT NULL, | ||
+ | `notes` varchar(255) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `date` (`date`, | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | ALTER TABLE `taskman` CHANGE `employeedone` `employeedone` INT(11) NULL; | ||
+ | </ | ||
+ | |||
+ | |||
+ | ====== 0.6.9 ====== | ||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | SALARY_ENABLED=0 | ||
+ | TB_TASKMANNOTIFY=0 | ||
+ | CEMETERY_ENABLED=0 | ||
+ | TARIFFINFO_IN_PROFILE=0 | ||
+ | </ | ||
+ | |||
+ | При помощи SQL консоли последовательно выполнить следующие запросы (ага, шесть штук): | ||
+ | <code sql> | ||
+ | CREATE TABLE IF NOT EXISTS `salary_jobs` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `date` datetime NOT NULL, | ||
+ | `state` tinyint(1) NOT NULL DEFAULT ' | ||
+ | `taskid` int(11) DEFAULT NULL, | ||
+ | `employeeid` int(11) NOT NULL, | ||
+ | `jobtypeid` int(11) NOT NULL, | ||
+ | `factor` double DEFAULT NULL, | ||
+ | `overprice` double DEFAULT NULL, | ||
+ | `note` varchar(255) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `salary_jobprices` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `jobtypeid` int(11) NOT NULL, | ||
+ | `price` double NOT NULL, | ||
+ | `unit` varchar(255) NOT NULL, | ||
+ | `time` int(11) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `salary_wages` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `employeeid` int(11) NOT NULL, | ||
+ | `wage` double NOT NULL, | ||
+ | `bounty` double NOT NULL, | ||
+ | `worktime` int(11) NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `salary_paid` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `jobid` int(11) NOT NULL, | ||
+ | `employeeid` int(11) NOT NULL, | ||
+ | `paid` double DEFAULT NULL, | ||
+ | `date` datetime NOT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `salary_timesheets` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `date` date NOT NULL, | ||
+ | `employeeid` int(11) NOT NULL, | ||
+ | `hours` int(11) NOT NULL DEFAULT ' | ||
+ | `holiday` tinyint(1) NOT NULL DEFAULT ' | ||
+ | `hospital` tinyint(1) NOT NULL DEFAULT ' | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `cemetery` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `login` varchar(255) NOT NULL, | ||
+ | `state` tinyint(1) NOT NULL DEFAULT ' | ||
+ | `date` datetime NOT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | </ | ||
+ | |||
+ | ====== 0.6.8 ====== | ||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | UBCACHE_STORAGE=files | ||
+ | ONUAUTO_CONFIG=0 | ||
+ | PER_CITY_ACTION=0 | ||
+ | </ | ||
+ | |||
+ | ====== 0.6.7 ====== | ||
+ | |||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | CUSTMAP_ENABLED=0 | ||
+ | PON_ENABLED=0 | ||
+ | CUD_ENABLED=0 | ||
+ | CUD_PULLDAYS=30 | ||
+ | CUD_PERCENT=1 | ||
+ | CUD_PERCENTLIMIT=10 | ||
+ | CUD_PAYID=1 | ||
+ | CUD_CFID="" | ||
+ | UKV_BSPB_PAYID=2 | ||
+ | CAP_ENABLED=0 | ||
+ | CAP_DAYLIMIT=30 | ||
+ | CAP_PENALTY=20 | ||
+ | CAP_PAYID=1 | ||
+ | CAP_IGNOREFROZEN=1 | ||
+ | </ | ||
+ | |||
+ | При помощи SQL консоли последовательно выполнить следующие запросы (да, все 6 штук): | ||
+ | <code sql> | ||
+ | CREATE TABLE IF NOT EXISTS `custmaps` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `name` varchar(255) NOT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `custmapsitems` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `mapid` int(11) DEFAULT NULL, | ||
+ | `type` varchar(40) DEFAULT NULL, | ||
+ | `geo` varchar(255) DEFAULT NULL, | ||
+ | `name` varchar(255) DEFAULT NULL, | ||
+ | `location` varchar(255) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `mapid` (`mapid`, | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `pononu` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `onumodelid` int(11) DEFAULT NULL, | ||
+ | `oltid` int(11) DEFAULT NULL, | ||
+ | `ip` varchar(20) DEFAULT NULL, | ||
+ | `mac` varchar(20) DEFAULT NULL, | ||
+ | `serial` varchar(255) DEFAULT NULL, | ||
+ | `login` varchar(255) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `cudiscounts` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `login` varchar(255) NOT NULL, | ||
+ | `discount` double DEFAULT NULL, | ||
+ | `date` datetime DEFAULT NULL, | ||
+ | `days` int(11) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `login` (`login`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | | ||
+ | | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `login` varchar(255) NOT NULL, | ||
+ | `date` datetime DEFAULT NULL, | ||
+ | `days` int(11) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `login` (`login`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | | ||
+ | ALTER TABLE `ukv_banksta` ADD `payid` INT NULL ; | ||
+ | </ | ||
+ | |||
+ | ====== 0.6.6 ====== | ||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | CONDET_ENABLED=0 | ||
+ | CONDET_IN_PROFILE=0 | ||
+ | </ | ||
+ | |||
+ | При помощи SQL консоли последовательно выполнить следующий запрос: | ||
+ | <code sql> | ||
+ | CREATE TABLE IF NOT EXISTS `condet` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `login` varchar(255) DEFAULT NULL, | ||
+ | `seal` varchar(40) DEFAULT NULL, | ||
+ | `length` varchar(40) DEFAULT NULL, | ||
+ | `price` varchar(40) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `login` (`login`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | </ | ||
+ | |||
+ | |||
+ | ====== 0.6.5 ====== | ||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | SWITCH_AUTOCONFIG=0 | ||
+ | SNMPSET_PATH="/ | ||
+ | SNMP_MODE=system | ||
+ | SNMPWALK_BACKGROUND=0 | ||
+ | </ | ||
+ | |||
+ | При помощи SQL консоли последовательно выполнить следующие запросы: | ||
+ | <code sql> | ||
+ | CREATE TABLE IF NOT EXISTS `switch_login` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `swid` int(5) DEFAULT NULL, | ||
+ | `swlogin` varchar(50) DEFAULT NULL, | ||
+ | `swpass` varchar(50) DEFAULT NULL, | ||
+ | `method` varchar(10) DEFAULT NULL, | ||
+ | `community` varchar(50) DEFAULT NULL, | ||
+ | `enable` varchar(3) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | ALTER TABLE `ukv_users` ADD `cableseal` VARCHAR(40) NULL AFTER `inetlogin`; | ||
+ | </ | ||
+ | ====== 0.6.4 ====== | ||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | VLAN_IN_PROFILE=0 | ||
+ | </ | ||
+ | При помощи SQL консоли последовательно выполнить следующий запрос: | ||
+ | <code sql> | ||
+ | ALTER TABLE `switches` ADD `parentid` INT NULL AFTER `geo`, ADD INDEX (`parentid`) ; | ||
+ | </ | ||
+ | |||
+ | ====== 0.6.3 ====== | ||
+ | |||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | PHOTOSTORAGE_ENABLED=0 | ||
+ | CAN_EDIT_PAYMENTS="" | ||
+ | GLOBALSEARCH_ENABLED=1 | ||
+ | GLOBALSEARCH_FIELDS=" | ||
+ | GLOBALSEARCH_CACHE=60 | ||
+ | </ | ||
+ | |||
+ | При помощи SQL консоли последовательно выполнить следующие запросы: | ||
+ | <code sql> | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `photostorage` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `scope` varchar(255) NOT NULL, | ||
+ | `item` varchar(255) NOT NULL, | ||
+ | `date` datetime NOT NULL, | ||
+ | `admin` varchar(40) NOT NULL, | ||
+ | `filename` varchar(255) NOT NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `scope` (`scope`), | ||
+ | KEY `item` (`item`), | ||
+ | KEY `date` (`date`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | </ | ||
+ | |||
+ | ====== 0.6.2 ====== | ||
+ | При обновлении от 0.6.1 делать ничего не нужно. В случае проблем с разъезжающимися элементами интерфейса - стоит нажать ctrl-R чтобы очистить кеш вашего браузера от останков старых стилей. | ||
+ | |||
+ | ====== 0.6.1 ====== | ||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | CONTRACTDATE_IN_PROFILE=0 | ||
+ | ADCOMMENTS_ENABLED=1 | ||
+ | MYSQLDUMP_PATH="/ | ||
+ | MYSQL_PATH="/ | ||
+ | VLANGEN_SUPPORT=0 | ||
+ | </ | ||
+ | |||
+ | При помощи SQL консоли последовательно выполнить следующие запросы (да, их тут 9 штук): | ||
+ | <code sql> | ||
+ | ALTER TABLE `jobtypes` ADD `jobcolor` VARCHAR(40) NULL AFTER `jobname`, ADD INDEX (`jobcolor`) ; | ||
+ | |||
+ | ALTER TABLE `taskman` ADD `login` VARCHAR(255) NULL AFTER `address`, ADD INDEX (`login`) ; | ||
+ | |||
+ | ALTER TABLE `taskman` ADD `starttime` TIME NULL AFTER `startdate`, | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `adcomments` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `scope` varchar(255) NOT NULL, | ||
+ | `item` varchar(255) NOT NULL, | ||
+ | `date` datetime NOT NULL, | ||
+ | `admin` varchar(40) NOT NULL, | ||
+ | `text` text NOT NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `scope` (`scope`), | ||
+ | KEY `item` (`item`), | ||
+ | KEY `date` (`date`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `ahenassignstrict` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `agentid` int(11) NOT NULL, | ||
+ | `login` varchar(255) NOT NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `login` (`login`) | ||
+ | ) ENGINE=MyISAM | ||
+ | | ||
+ | CREATE TABLE IF NOT EXISTS `vlan_pools` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `desc` varchar(32) DEFAULT " | ||
+ | `firstvlan` int(4) DEFAULT NULL, | ||
+ | `endvlan` int(4) DEFAULT NULL, | ||
+ | `qinq` int(1) DEFAULT NULL, | ||
+ | `svlan` int(4) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | |||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `vlanhosts` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `vlanpoolid` int(11) NOT NULL, | ||
+ | `login` varchar(32) DEFAULT " | ||
+ | `vlan` int(4) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `vlanhosts_qinq` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `vlanpoolid` int(11) NOT NULL, | ||
+ | `login` varchar(32) DEFAULT " | ||
+ | `svlan` int(4) DEFAULT NULL, | ||
+ | `cvlan` int(4) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `vlan_terminators` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `netid` int(4) DEFAULT NULL, | ||
+ | `vlanpoolid` int(4) DEFAULT NULL, | ||
+ | `ip` varchar(20) DEFAULT NULL, | ||
+ | `type` varchar (50) DEFAULT NULL, | ||
+ | `username` varchar(50) DEFAULT NULL, | ||
+ | `password` varchar(50) DEFAULT NULL, | ||
+ | `remote-id` varchar(50) DEFAULT NULL, | ||
+ | `interface` varchar(50) DEFAULT NULL, | ||
+ | `relay` varchar(50) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; | ||
+ | | ||
+ | </ | ||
+ | |||
+ | ====== 0.6.0 ====== | ||
+ | |||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | STICKY_NOTES_ENABLED=0 | ||
+ | </ | ||
+ | |||
+ | В конфиг userstats.ini добавить: | ||
+ | <code ini> | ||
+ | SC_TARIFFSALLOWED="" | ||
+ | </ | ||
+ | |||
+ | | ||
+ | <code sql> | ||
+ | CREATE TABLE IF NOT EXISTS `stickynotes` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `owner` varchar(255) NOT NULL, | ||
+ | `createdate` datetime NOT NULL, | ||
+ | `reminddate` date DEFAULT NULL, | ||
+ | `active` tinyint(1) NOT NULL DEFAULT ' | ||
+ | `text` text, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `owner` (`owner`), | ||
+ | KEY `reminddate` (`reminddate`), | ||
+ | KEY `active` (`active`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | </ | ||
+ | |||
+ | ====== 0.5.9 ====== | ||
+ | |||
+ | При помощи SQL консоли последовательно выполнить следующие запросы: | ||
+ | <code sql> | ||
+ | CREATE TABLE IF NOT EXISTS `sigreqconf` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `key` varchar(255) DEFAULT NULL, | ||
+ | `value` text, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `key` (`key`), | ||
+ | FULLTEXT KEY `value` (`value`) | ||
+ | ) ENGINE=MyISAM | ||
+ | </ | ||
+ | |||
+ | ====== 0.5.8 ====== | ||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | COLORIZE_PROFILE_CASH=0 | ||
+ | PROFILE_LAT=0 | ||
+ | ONLINE_SAVE_STATE=0 | ||
+ | </ | ||
+ | |||
+ | В конфиг userstats.ini добавить: | ||
+ | <code ini> | ||
+ | TRAFFIC_ENABLED=1 | ||
+ | </ | ||
+ | ====== 0.5.7 ====== | ||
+ | |||
+ | В конфиг userstats.ini добавить: | ||
+ | <code ini> | ||
+ | VSERVICES_SHOW=0 | ||
+ | </ | ||
+ | |||
+ | ====== 0.5.6 ====== | ||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | NETWORKS_EXT=0 | ||
+ | EASY_CREDIT=0 | ||
+ | </ | ||
+ | |||
+ | При помощи SQL консоли последовательно выполнить следующие запросы: | ||
+ | <code sql> | ||
+ | CREATE TABLE IF NOT EXISTS `netextpools` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `netid` int(11) NOT NULL, | ||
+ | `pool` varchar(255) NOT NULL, | ||
+ | `netmask` varchar(255) NOT NULL, | ||
+ | `gw` varchar(255) DEFAULT NULL, | ||
+ | `clientip` varchar(255) DEFAULT NULL, | ||
+ | `broadcast` varchar(255) DEFAULT NULL, | ||
+ | `vlan` varchar(255) DEFAULT NULL, | ||
+ | `login` varchar(255) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `netextips` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `poolid` int(11) NOT NULL, | ||
+ | `ip` varchar(40) | ||
+ | `nas` varchar(255) DEFAULT NULL, | ||
+ | `iface` varchar(40) DEFAULT NULL, | ||
+ | `mac` varchar(40) DEFAULT NULL, | ||
+ | `switchid` int(11) DEFAULT NULL, | ||
+ | `port` varchar(40) DEFAULT NULL, | ||
+ | `vlan` varchar(40) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | </ | ||
+ | |||
+ | ====== 0.5.5 ====== | ||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | AUTO_LOGOUT_IDLE=0 | ||
+ | AUTO_LOGOUT_EXCLUDE="" | ||
+ | VOLS_ENABLED=0 | ||
+ | CORPS_ENABLED=0 | ||
+ | FINREP_TARIFF=0 | ||
+ | </ | ||
+ | |||
+ | В конфиг userstats.ini добавить: | ||
+ | <code ini> | ||
+ | PAYMENTS_ENABLED=1 | ||
+ | </ | ||
+ | |||
+ | Если вы планируете использовать модуль [[vols|Карта ВОЛС]] - При помощи SQL консоли последовательно выполнить [[http:// | ||
+ | |||
+ | Если вы планируете использовать модуль [[corps|Работа с юридическими лицами]] - при помощи SQL консоли последовательно выполнить [[http:// | ||
+ | |||
+ | ====== 0.5.4 ====== | ||
+ | |||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | ANNOUNCEMENTS=0 | ||
+ | </ | ||
+ | |||
+ | |||
+ | В конфиг userstats.ini добавить: | ||
+ | <code ini> | ||
+ | ISP_LOGO="" | ||
+ | BACKGROUND=" | ||
+ | SC_MONTHCONTROL=0 | ||
+ | AN_ENABLED=0 | ||
+ | </ | ||
+ | |||
+ | При помощи SQL консоли последовательно выполнить следующие запросы: | ||
+ | <code sql> | ||
+ | CREATE TABLE IF NOT EXISTS `zbssclog` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `date` datetime NOT NULL, | ||
+ | `login` varchar(255) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `date` (`date`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `zbsannouncements` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `public` tinyint(4) DEFAULT ' | ||
+ | `type` varchar(20) NOT NULL, | ||
+ | `title` varchar(255) DEFAULT NULL, | ||
+ | `text` text NOT NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `public` (`public`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | </ | ||
+ | |||
+ | ====== 0.5.3 ====== | ||
+ | |||
+ | В конфиг userstats.ini добавить: | ||
+ | <code ini> | ||
+ | PAYMENTID_QR=0 | ||
+ | </ | ||
+ | |||
+ | При помощи SQL консоли последовательно выполнить следующие запросы: | ||
+ | <code sql> | ||
+ | ALTER TABLE `employee` ADD `admlogin` VARCHAR( 255 ) NULL DEFAULT NULL AFTER `mobile`; | ||
+ | </ | ||
+ | |||
+ | ====== 0.5.2 ====== | ||
+ | |||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | SWITCH_PING_CUSTOM_SCRIPT="" | ||
+ | </ | ||
+ | |||
+ | ====== 0.5.1 ====== | ||
+ | Собака наблюдака и модуль TurboSMS теперь хотят использовать шлюз 94.249.146.189\\ | ||
+ | |||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | BUILD_EXTENDED=0 | ||
+ | BUILD_OWNERS="" | ||
+ | BUILD_EXTOPTS=" | ||
+ | UKV_ENABLED=0 | ||
+ | UKV_BS_PAYID=3 | ||
+ | UKV_MONTH_DEBTLIMIT=2 | ||
+ | SIGNUP_PAYMENTS = 0 | ||
+ | SIGNUP_TYPEID = 7 | ||
+ | </ | ||
+ | |||
+ | При помощи SQL консоли последовательно выполнить следующие запросы: | ||
+ | <code sql> | ||
+ | ALTER TABLE `taskman` ADD `smsdata` TEXT NULL DEFAULT NULL ; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `buildpassport` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `buildid` int(11) NOT NULL, | ||
+ | `owner` varchar(255) DEFAULT NULL, | ||
+ | `ownername` varchar(255) DEFAULT NULL, | ||
+ | `ownerphone` varchar(255) DEFAULT NULL, | ||
+ | `ownercontact` varchar(255) DEFAULT NULL, | ||
+ | `keys` tinyint(4) DEFAULT NULL, | ||
+ | `accessnotices` varchar(255) DEFAULT NULL, | ||
+ | `floors` int(11) DEFAULT NULL, | ||
+ | `apts` int(11) DEFAULT NULL, | ||
+ | `entrances` int(11) DEFAULT NULL, | ||
+ | `notes` text, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `buildid` (`buildid`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `signup_prices_tariffs` ( | ||
+ | `tariff` varchar(40) NOT NULL, | ||
+ | `price` double NOT NULL, | ||
+ | PRIMARY KEY (`tariff`) | ||
+ | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `signup_prices_users` ( | ||
+ | `login` varchar(50) NOT NULL, | ||
+ | `price` double NOT NULL, | ||
+ | PRIMARY KEY (`login`) | ||
+ | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | ||
+ | |||
+ | </ | ||
+ | |||
+ | ====== 0.5.0 ====== | ||
+ | |||
+ | В конфиг alter.ini добавить: | ||
+ | <code ini> | ||
+ | DOCX_SUPPORT=0 | ||
+ | DOCX_CHECK=0 | ||
+ | DOCX_NDS=20 | ||
+ | DOCX_SERVICES="" | ||
+ | ADDRESS_CACHE_TIME=30 | ||
+ | CAN_DELETE_PAYMENTS="" | ||
+ | </ | ||
+ | |||
+ | В конфиг userstats.ini добавить: | ||
+ | <code ini> | ||
+ | DOCX_SUPPORT=0 | ||
+ | DOCX_STORAGE=" | ||
+ | DOCX_NDS=20 | ||
+ | DOCX_SERVICES="" | ||
+ | PAYMENTSTIMEHIDE=0 | ||
+ | </ | ||
+ | |||
+ | | ||
+ | <code sql> | ||
+ | CREATE TABLE IF NOT EXISTS `docxtemplates` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `date` datetime NOT NULL, | ||
+ | `admin` varchar(255) DEFAULT NULL, | ||
+ | `public` tinyint(4) DEFAULT NULL, | ||
+ | `name` varchar(255) DEFAULT NULL, | ||
+ | `path` varchar(255) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `name` (`name`), | ||
+ | KEY `path` (`path`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `docxdocuments` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `date` datetime NOT NULL, | ||
+ | `login` varchar(255) DEFAULT NULL, | ||
+ | `public` tinyint(4) DEFAULT NULL, | ||
+ | `templateid` int(11) DEFAULT NULL, | ||
+ | `path` varchar(255) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `public` (`public`), | ||
+ | KEY `path` (`path`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | </ | ||
+ | ====== 0.4.9 ====== | ||
+ | |||
+ | В конфиг alter.ini добавить | ||
+ | <code ini> | ||
+ | COMPLEX_ENABLED=0 | ||
+ | COMPLEX_MASKS="" | ||
+ | COMPLEX_CFIDS="" | ||
+ | DN_FULLHOSTSCAN=0 | ||
+ | </ | ||
+ | |||
+ | ====== 0.4.8 ====== | ||
+ | В конфиг alter.ini добавить | ||
+ | <code ini> | ||
+ | CAPABDIR_ENABLED=0 | ||
+ | SCREP_ENABLED=0 | ||
+ | </ | ||
+ | |||
+ | При помощи SQL консоли последовательно выполнить следующие запросы: | ||
+ | <code sql> | ||
+ | CREATE TABLE IF NOT EXISTS `capab` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `date` datetime NOT NULL, | ||
+ | `address` varchar(255) DEFAULT NULL, | ||
+ | `phone` varchar(255) DEFAULT NULL, | ||
+ | `stateid` int(11) NOT NULL DEFAULT ' | ||
+ | `notes` text, | ||
+ | `price` varchar(255) DEFAULT NULL, | ||
+ | `employeeid` int(11) DEFAULT NULL, | ||
+ | `donedate` datetime DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `date` (`date`), | ||
+ | KEY `state` (`stateid`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `capabstates` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `state` varchar(255) NOT NULL, | ||
+ | `color` varchar(40) NOT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | ALTER TABLE `employee` ADD `mobile` VARCHAR( 50 ) NULL DEFAULT NULL AFTER `appointment`; | ||
+ | </ | ||
+ | |||
+ | ====== 0.4.7 ====== | ||
+ | В конфиг alter.ini добавить | ||
+ | <code ini> | ||
+ | DSHAPER_ENABLED=0 | ||
+ | WATCHDOG_ENABLED=0 | ||
+ | AUTOFREEZE_CASH_LIMIT=" | ||
+ | CONTRACT_SAME_AS_LOGIN=0 | ||
+ | </ | ||
+ | |||
+ | При помощи SQL консоли выполнить следующий запрос: | ||
+ | <code sql> | ||
+ | CREATE TABLE IF NOT EXISTS `watchdog` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `active` TINYINT(1) NOT NULL DEFAULT ' | ||
+ | `name` varchar(255) NOT NULL, | ||
+ | `checktype` varchar(255) NOT NULL, | ||
+ | `param` varchar(255) NOT NULL, | ||
+ | `operator` varchar(255) NOT NULL, | ||
+ | `condition` varchar(255) DEFAULT NULL, | ||
+ | `action` varchar(255) NOT NULL, | ||
+ | `oldresult` varchar(255) DEFAULT NULL, | ||
+ | PRIMARY KEY (`id`), | ||
+ | KEY `active` (`active`), | ||
+ | KEY `name` (`name`), | ||
+ | KEY `oldresult` (`oldresult`), | ||
+ | KEY `param` (`param`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | </ | ||
+ | ====== 0.4.6 ====== | ||
+ | В конфиг alter.ini добавить | ||
+ | <code ini> | ||
+ | SEARCH_CUSTOM_CONTRACT=0 | ||
+ | ASTERISK_ENABLED=0 | ||
+ | NMAP_PATH="/ | ||
+ | FREERADIUS_ENABLED=0 | ||
+ | SETCASH_ONLY_ROOT=0 | ||
+ | </ | ||
+ | |||
+ | При помощи SQL консоли последовательно выполнить следующие запросы: | ||
+ | <code sql> | ||
+ | ALTER TABLE `build` ADD `geo` VARCHAR( 255 ) DEFAULT NULL ; | ||
+ | |||
+ | ALTER TABLE `networks` ADD `use_radius` TINYINT(1) NOT NULL DEFAULT ' | ||
+ | </ | ||
+ | |||
+ | ====== 0.4.5 ====== | ||
+ | В конфиг alter.ini добавить | ||
+ | <code ini> | ||
+ | SEARCHADDR_AUTOCOMPLETE=1 | ||
+ | ASKOZIA_ENABLED=0 | ||
+ | </ | ||
+ | |||
+ | ====== 0.4.4 ====== | ||
+ | Никаких особых рекомендаций. Просто обновляемся обновлятором. | ||
+ | |||
+ | ====== 0.4.3 ====== | ||
+ | В конфиг alter.ini добавить | ||
+ | <code ini> | ||
+ | ROUND_PROFILE_CASH=0 | ||
+ | SWITCHPORT_IN_PROFILE=0 | ||
+ | PAYMENTCARDS_ENABLED=1 | ||
+ | </ | ||
+ | |||
+ | В конфиг userstats.ini добавить | ||
+ | <code ini> | ||
+ | ROUND_PROFILE_CASH=0 | ||
+ | ISP_NAME="" | ||
+ | ISP_URL="" | ||
+ | </ | ||
+ | |||
+ | При помощи SQL консоли последовательно выполнить следующие запросы: | ||
+ | <code sql> | ||
+ | ALTER TABLE `nas` ADD `options` TEXT DEFAULT NULL; | ||
+ | |||
+ | CREATE TABLE IF NOT EXISTS `switchportassign` ( | ||
+ | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
+ | `login` varchar(255) NOT NULL, | ||
+ | `switchid` int(11) NOT NULL, | ||
+ | `port` int(11) NOT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; | ||
+ | </ |