Book creator
 Добавить страницу в книгу
Book creator
 Удалить страницу из книги  

 Показать или изменить шаблон книги (0 страниц(ы))
 Помощь

0.90

20.07.2021

MySQL

ALTER TABLE `crm_competitors` ADD COLUMN `color` VARCHAR(7) NOT NULL DEFAULT '';
ALTER TABLE msgs_quick_replys_tags ADD KEY `msg_id` (`msg_id`);
ALTER TABLE `equipment_pon_onu` ADD COLUMN `onu_billing_desc` VARCHAR(50) NOT NULL DEFAULT '' AFTER `onu_desc`;
 
CREATE TABLE IF NOT EXISTS `equipment_calculator`(
    `type` VARCHAR(20) NOT NULL,
    `name` VARCHAR(20) NOT NULL,
    `value` VARCHAR(255) NOT NULL
)
  DEFAULT CHARSET=utf8 COMMENT = 'Equipment calculator';
 
INSERT INTO equipment_calculator (type, name, value) VALUES
('olt', 'SFP B+', '1.5'),
('olt', 'SFP', '0'),
('olt', 'SFP C+', '3'),
('olt', 'SFP C++', '5'),
('divider', '1/4', '7.4'),
('divider', '1/8', '10.7'),
('splitter', '40/60', '4.01;2.34'),
('splitter', '10/90', '10.2;0.6'),
('splitter', '85/15', '0.76;8.16'),
('splitter', '70/30', '1.56;5.39'),
('splitter', '95/5', '0.32;13.7'),
('splitter', '75/25', '1.42;6.29'),
('splitter', '5/95', '13.7;0.32'),
('splitter', '45/55', '2.71;3.73'),
('splitter', '80/20', '1.6;7.11'),
('splitter', '15/85', '8.16;0.76'),
('splitter', '60/40', '2.34;4.01'),
('splitter', '30/70', '5.39;1.56'),
('splitter', '65/35', '1.93;4.56'),
('splitter', '90/10', '0.6;10.2'),
('splitter', '50/50', '3.17;3.19'),
('splitter', '25/75', '6.29;1.42'),
('splitter', '35/65', '4.56;1.93'),
('splitter', '20/80', '7.11;1.6'),
('splitter', '55/45', '3.73;2.71'),
('connector', 'SIGNAL_LOSS', '0');

30.06.2021

  • Cablecat. Добавлено отображение типа кабеля на печатной схеме.
  • Msgs. исправлена ошибка, когда поиск работал только по первому сообщению заявки.
  • Equipment. PON Grabber: теперь CPE_FILL/FORCE_FILL может заполнять VLAN / server VLAN абоненту (добавлен параметр VLANS=1).
  • Equipment. Теперь, при привязке ONU к абоненту у абонента автоматически заполняется поле CPE_MAC.
  • Поиск по абоненту. В поле «Регистрация» теперь можно искать по диапазону дат.
  • Авторизация через Facebook. Facebook требует возможность удалять данные по запросу пользователя - добавлена эта возможность.
  • Iptv. Microimpuls. Добавлено управление устройствами.
  • Internet. Список тарифных планов: добавлены вкладки для отображения отдельно активных или отключеных тарифных планов.
  • Maps. Добавлено поле «Название» делителям.
  • Sms. Websms: добавлена возможность получать статусы сообщений (billd-плагин sms_status).
  • Paysys. Тинькофф: добавлен автоплатеж.
  • Sorm. Добавлена поддержка Феникс.
  • Чеки онлайн. Добавлена возможность распечатки чека из биллинга.
  • Msgs. Добавлена возможность отправки сообщений в Viber bot.
  • Ureports. Добавлена возможность отправлять оповещения в Viber и Telegram.
  • Maps2. Заполнение координат. Добавлено альтернативное название.
  • Equipment. Добавлена возможность отслеживать флуд MAC адресов на портах.
  • Internet. Исправлен отчёт по статусам.

14.06.2021

MySQL

ALTER TABLE `cablecat_splitters` ADD COLUMN `name` VARCHAR(32) NOT NULL DEFAULT '';
 
ALTER TABLE `cablecat_splitters` MODIFY `commutation_x` DOUBLE(6, 2) NULL;
ALTER TABLE `cablecat_splitters` MODIFY `commutation_y` DOUBLE(6, 2) NULL;
ALTER TABLE `cablecat_commutation_equipment` MODIFY `commutation_x` DOUBLE(6, 2) NULL;
ALTER TABLE `cablecat_commutation_equipment` MODIFY `commutation_y` DOUBLE(6, 2) NULL;
ALTER TABLE `cablecat_commutation_crosses` MODIFY `commutation_x` DOUBLE(6, 2) NULL;
ALTER TABLE `cablecat_commutation_crosses` MODIFY `commutation_y` DOUBLE(6, 2) NULL;
ALTER TABLE `cablecat_commutations` ADD COLUMN `height` DOUBLE(6, 2) NULL;
 
ALTER TABLE `equipment_models` ADD COLUMN image_url VARCHAR(500) DEFAULT '';
UPDATE equipment_models SET image_url = 'https://www.edge-core.com/timthumb.php?src=_upload/images/1605181111021.png&h=357&w=490&zc=3' WHERE id = 158;
UPDATE equipment_models SET image_url = 'https://i.mt.lv/cdn/rb_images/1606_l.jpg' WHERE id = 161;
UPDATE equipment_models SET image_url = 'https://www.juniper.net/assets/img/products/image-library/mx-series/mx80/mx80-front-high.jpg' WHERE id = 162;
UPDATE equipment_models SET image_url = 'https://www.dlink.ru/up/prod_fotos/DGS-1100-06ME_A1_Front.jpg' WHERE id = 232;
UPDATE equipment_models SET image_url = 'https://eltex-co.ru/upload/iblock/32f/olt-ma4000_px_front.png' WHERE id = 262;
 
ALTER TABLE `extreceipts_api` ADD COLUMN `conf_name` VARCHAR(50) NOT NULL DEFAULT '' AFTER api_id;
 
ALTER TABLE `cablecat_commutations` ADD COLUMN `name` VARCHAR(64) NOT NULL DEFAULT '';
UPDATE equipment_models SET image_url = 'https://ecolan.com.ua/components/com_jshopping/files/img_products/full_zte_c300_3.jpg' WHERE id = 306;
ALTER TABLE equipment_mac_log MODIFY port VARCHAR(16) NOT NULL DEFAULT '';
 
ALTER TABLE `maps_points` MODIFY `name` VARCHAR(64) NOT NULL DEFAULT '';
 
CREATE TABLE IF NOT EXISTS `cablecat_import_presets` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `preset_name` varchar(64) NOT NULL DEFAULT '',
  `default_preset_name` varchar(64) NOT NULL DEFAULT '',
  `object_name` varchar(64) NOT NULL DEFAULT '',
  `type_id` varchar(64) NOT NULL DEFAULT '',
  `default_type_id` SMALLINT(6) NOT NULL,
  `object` varchar(64) NOT NULL DEFAULT '',
  `object_add` TINYINT(1) NOT NULL DEFAULT 0,
  `coordx` varchar(64) NOT NULL DEFAULT '',
  `coordy` varchar(64) NOT NULL DEFAULT '',
  `load_url` varchar(128) NOT NULL DEFAULT '',
  `json_path` varchar(64) NOT NULL DEFAULT '',
  `filters` varchar(128) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
)
  CHARSET = 'utf8'
  COMMENT = 'Presets for wells import';
ALTER TABLE equipment_extra_ports ADD COLUMN port_combo_with SMALLINT NOT NULL DEFAULT 0 AFTER port_type;
ALTER TABLE equipment_extra_ports DROP COLUMN state;

06.05.2021

MySQL

CREATE TABLE IF NOT EXISTS `crm_tp_info_fields` (
  `id`          TINYINT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name`        VARCHAR(60)          NOT NULL DEFAULT '',
  `sql_field`   VARCHAR(60)          NOT NULL DEFAULT '',
  `type`        TINYINT(2) UNSIGNED  NOT NULL DEFAULT 0,
  `priority`    TINYINT(1) UNSIGNED  NOT NULL DEFAULT 0,
  `comment`     VARCHAR(60)          NOT NULL DEFAULT '',
  `pattern`     VARCHAR(60)          NOT NULL DEFAULT '',
  `title`       VARCHAR(255)         NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY (`name`),
  UNIQUE KEY (`sql_field`)
)
  DEFAULT CHARSET = utf8
  COMMENT = 'Crm Tariff plans info fields';
 
RENAME TABLE `payments_spool` TO `payments_pool`;
 
ALTER TABLE `payments_pool` DROP COLUMN `date`;
ALTER TABLE `payments_pool` DROP COLUMN `sum`;
ALTER TABLE `payments_pool` DROP COLUMN `dsc`;
ALTER TABLE `payments_pool` DROP COLUMN `uid`;
ALTER TABLE `payments_pool` DROP COLUMN `method`;
ALTER TABLE `payments_pool` DROP COLUMN `ext_id`;
ALTER TABLE `payments_pool` DROP COLUMN `bill_id`;
ALTER TABLE `payments_pool` DROP COLUMN `currency`;
ALTER TABLE `payments_pool` ADD COLUMN `payment_id` varchar(28) NOT NULL DEFAULT '';
ALTER TABLE `payments_pool` ADD COLUMN  `status` TINYINT(1) UNSIGNED  NOT NULL DEFAULT '0';
ALTER TABLE `payments_pool` DROP KEY `date`;
ALTER TABLE `payments_pool` DROP KEY `uid`;
ALTER TABLE `payments_pool` DROP KEY `ext_id`;
ALTER TABLE `payments_pool` ADD KEY `payment_id` (`payment_id`);
 
 
ALTER TABLE equipment_mac_log ADD PRIMARY KEY(id);
ALTER TABLE equipment_mac_log DROP INDEX id;
 
ALTER TABLE `cablecat_commutation_cables` ADD COLUMN `commutation_x` double(6,2) DEFAULT NULL;
ALTER TABLE `cablecat_commutation_cables` ADD COLUMN `commutation_y` double(6,2) DEFAULT NULL;
ALTER TABLE `cablecat_commutation_cables` ADD COLUMN `id` INT(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY;
ALTER TABLE `cablecat_commutation_cables` ADD COLUMN `position` VARCHAR(10) NOT NULL DEFAULT '';
 
ALTER TABLE equipment_models ADD COLUMN epon_supported_onus SMALLINT(4) UNSIGNED;
ALTER TABLE equipment_models ADD COLUMN gpon_supported_onus SMALLINT(4) UNSIGNED;
ALTER TABLE equipment_models ADD COLUMN gepon_supported_onus SMALLINT(4) UNSIGNED;
UPDATE equipment_models SET gpon_supported_onus = 64 WHERE id = 262;
 
UPDATE equipment_models SET snmp_tpl = 'dlink.snmp' WHERE id = 123;
UPDATE equipment_models SET snmp_tpl = 'dlink.snmp' WHERE id = 149;
UPDATE equipment_models SET snmp_tpl = 'dlink_des_1210_28_me_b3.snmp' WHERE id = 205;

31.03.2021

MySQL

ALTER TABLE `crm_leads` ADD `competitor_id` INT(10) UNSIGNED NOT NULL DEFAULT 0;
ALTER TABLE `crm_leads` ADD `tp_id` INT(10) UNSIGNED NOT NULL DEFAULT 0;
ALTER TABLE `crm_leads` ADD `assessment` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0';
 
ALTER TABLE `crm_leads` ADD KEY competitor_id (`competitor_id`);
 
UPDATE equipment_models SET snmp_tpl = 'gcom.snmp' WHERE vendor_id = 33 AND snmp_tpl = '';
 
ALTER TABLE `paysys_main` ADD `order_id` varchar(24) NOT NULL DEFAULT '';
 
CREATE TABLE IF NOT EXISTS `tp_groups_users_groups` (
  `id`          SMALLINT(6) UNSIGNED NOT NULL AUTO_INCREMENT,
  `tp_gid`      SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
  `gid`         SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `tp_gid` (`tp_gid`),
  KEY `gid` (`gid`)
  )
  DEFAULT CHARSET = utf8
  COMMENT = 'Users groups for Tarif Plans Groups';
 
 

23.02.2021

MySQL

ALTER TABLE msgs_messages ADD send_type SMALLINT (6) UNSIGNED DEFAULT 0 NULL;
ALTER TABLE ureports_tp ADD last_active DATE DEFAULT '0000-00-00';
 
CREATE TABLE IF NOT EXISTS `crm_competitors` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(64) NOT NULL DEFAULT '',
  `connection_type` VARCHAR(32) NOT NULL DEFAULT '',
  `site` VARCHAR(150) NOT NULL DEFAULT '',
  `descr` TEXT NOT NULL,
  PRIMARY KEY (`id`)
)
  DEFAULT CHARSET=utf8 COMMENT = 'Crm Competitors';
 
CREATE TABLE IF NOT EXISTS `crm_competitors_tps` (
  `id`            INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name`          VARCHAR(64) NOT NULL DEFAULT '',
  `speed`         INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `month_fee`     DOUBLE(14, 2) UNSIGNED NOT NULL DEFAULT '0.00',
  `day_fee`       DOUBLE(14, 2) UNSIGNED NOT NULL DEFAULT '0.00',
  `competitor_id` INT(10) UNSIGNED NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `competitor_id` (`competitor_id`)
)
  DEFAULT CHARSET=utf8 COMMENT = 'Crm Competitors tps';
 
CREATE TABLE IF NOT EXISTS `crm_competitor_geolocation` (
  `competitor_id` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL,
  `district_id`   SMALLINT(6) UNSIGNED DEFAULT '0' NOT NULL,
  `street_id`     SMALLINT(6) UNSIGNED DEFAULT '0' NOT NULL,
  `build_id`      SMALLINT(6) UNSIGNED DEFAULT '0' NOT NULL
)
  DEFAULT CHARSET=utf8 COMMENT = 'Geolocation of competitor';
 
CREATE TABLE IF NOT EXISTS `crm_competitor_tps_geolocation` (
  `tp_id`       SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL,
  `district_id` SMALLINT(6) UNSIGNED DEFAULT '0' NOT NULL,
  `street_id`   SMALLINT(6) UNSIGNED DEFAULT '0' NOT NULL,
  `build_id`    SMALLINT(6) UNSIGNED DEFAULT '0' NOT NULL
)
  DEFAULT CHARSET=utf8 COMMENT = 'Geolocation of competitor tps';
 
 
CREATE TABLE `payments_spool` (
  `date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `sum` double(10,2) NOT NULL DEFAULT '0.00',
  `dsc` varchar(80) DEFAULT NULL,
  `uid` int(11) unsigned NOT NULL DEFAULT '0',
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `method` tinyint(4) unsigned NOT NULL DEFAULT '0',
  `ext_id` varchar(28) NOT NULL DEFAULT '',
  `bill_id` int(11) unsigned NOT NULL DEFAULT '0',
  `currency` smallint(5) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `date` (`date`),
  KEY `uid` (`uid`),
  KEY `ext_id` (`ext_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='Payments log spool';
 
ALTER TABLE `crm_leads` ADD `build_id` INTEGER(11) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `crm_leads` ADD `address_flat` VARCHAR(10) NOT NULL DEFAULT '';
 
ALTER TABLE `tags` ADD `color` VARCHAR(7) NOT NULL DEFAULT '';
ALTER TABLE `internet_log` ADD `guest` TINYINT(1) UNSIGNED  NOT NULL DEFAULT '0';
 
DELETE i FROM equipment_infos i LEFT JOIN nas n ON i.nas_id = n.id WHERE n.id IS NULL;
DELETE p FROM equipment_pon_ports p LEFT JOIN equipment_infos i ON p.nas_id = i.nas_id WHERE i.nas_id IS NULL;
DELETE onu FROM equipment_pon_onu onu LEFT JOIN equipment_pon_ports p ON onu.port_id = p.id WHERE p.id IS NULL;
DELETE tr_069 FROM equipment_tr_069_settings tr_069 LEFT JOIN equipment_pon_onu onu ON tr_069.onu_id = onu.id WHERE onu.id IS NULL;
DELETE p FROM equipment_ports p LEFT JOIN equipment_infos i ON p.nas_id = i.nas_id WHERE i.nas_id IS NULL;
UPDATE equipment_ports p LEFT JOIN equipment_infos i ON p.uplink = i.nas_id SET p.uplink = 0 WHERE i.nas_id IS NULL AND p.uplink <> 0;
DELETE ml FROM equipment_mac_log ml LEFT JOIN equipment_infos i ON ml.nas_id = i.nas_id WHERE i.nas_id IS NULL;
DELETE pl FROM equipment_ping_log pl LEFT JOIN equipment_infos i ON pl.nas_id = i.nas_id WHERE i.nas_id IS NULL;
DELETE g FROM equipment_graphs g LEFT JOIN equipment_infos i ON g.nas_id = i.nas_id WHERE i.nas_id IS NULL;
DELETE b FROM equipment_backup b LEFT JOIN equipment_infos i ON b.nas_id = i.nas_id WHERE i.nas_id IS NULL;

11.02.2021

MySQL

ALTER TABLE internet_log ADD guest TINYINT(1) UNSIGNED  NOT NULL DEFAULT '0';

20.01.2021

MySQL

ALTER TABLE `msgs_messages` ADD COLUMN `plan_interval` SMALLINT(6) DEFAULT 0;
ALTER TABLE `msgs_messages` ADD COLUMN `plan_position` SMALLINT(6) DEFAULT 0;
UPDATE equipment_models SET snmp_tpl = 'dlink.snmp' WHERE id = 101;
UPDATE equipment_models SET snmp_tpl = 'dlink_des_3526.snmp' WHERE id = 102;
UPDATE equipment_models SET snmp_tpl = 'dlink.snmp' WHERE id = 105;
UPDATE equipment_models SET snmp_tpl = 'dlink.snmp' WHERE id = 109;
UPDATE equipment_models SET snmp_tpl = 'dlink.snmp' WHERE id = 110;
UPDATE equipment_models SET snmp_tpl = 'dlink.snmp' WHERE id = 111;
UPDATE equipment_models SET snmp_tpl = 'dlink_dgs_3120_24sc.snmp' WHERE id = 124;
UPDATE equipment_models SET snmp_tpl = 'dlink_des_3200_28f.snmp' WHERE id = 148;
UPDATE equipment_models SET snmp_tpl = 'dlink.snmp' WHERE id = 210;
UPDATE equipment_models SET snmp_tpl = 'dlink_des_3200_28f.snmp' WHERE id = 258;
 
UPDATE equipment_models SET snmp_tpl = 'huawei_switch.snmp' WHERE id = 185;
 
UPDATE equipment_models SET snmp_tpl = 'cdata.snmp' WHERE id = 239;
UPDATE equipment_models SET snmp_tpl = 'cdata_fd1216s.snmp' WHERE id = 279;
 
UPDATE equipment_models SET snmp_tpl = 'edge_core.snmp' WHERE id = 113;
UPDATE equipment_models SET snmp_tpl = 'edge_core.snmp' WHERE id = 158;
 
UPDATE equipment_models SET auto_port_shift = 1 WHERE id = 185;
 
ALTER TABLE `equipment_models` ADD COLUMN `fdb_uses_port_number_index` TINYINT(1) NOT NULL DEFAULT 0 AFTER `auto_port_shift`;
UPDATE equipment_models SET fdb_uses_port_number_index = 1 WHERE id = 185;
UPDATE equipment_models SET fdb_uses_port_number_index = 1 WHERE id = 297;
 
ALTER TABLE `events`
  MODIFY COLUMN `extra` varchar(256) NOT NULL DEFAULT '';