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

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

Это старая версия документа.

0.90

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 '';