Содержание

Список запланированных изменений Todo List

В системе изменился тип ssh ключей для управления оборудованием с DSA на RSA. Для коректной работы обновите все ключи (/usr/abills/Certs/id_dsa.*) при помощи утилиты misc/certs_create.sh ssh [user_name]

0.78

17.09.2018

MySQL

ALTER TABLE `bonus_service_discount` ADD COLUMN `name` VARCHAR(100) NOT NULL default '';
ALTER TABLE `cablecat_splitters`  ADD COLUMN `color_scheme_id` INT(11) UNSIGNED NOT NULL DEFAULT '1';
 
ALTER TABLE `reports_wizard` ADD COLUMN `send_mail` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0';
 
INSERT INTO `admin_type_permits` (`type`, `section`, `actions`, `module`) VALUES
  ('$lang{ALL} $lang{PERMISSION}', 0, 12, ''),
  ('$lang{ALL} $lang{PERMISSION}', 0, 13, ''),
  ('$lang{ALL} $lang{PERMISSION}', 0, 18, ''),
  ('$lang{ALL} $lang{PERMISSION}', 3, 6, ''),
  ('$lang{ALL} $lang{PERMISSION}', 3, 7, '');
 
ALTER TABLE `paysys_connect` ADD COLUMN `priority` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0;
 
REPLACE INTO `admin_permits` (aid, section, actions) 
SELECT aid, 0, 13
FROM `admins`
WHERE aid > 3;
 
REPLACE INTO `admin_permits` (aid, section, actions) 
SELECT aid, 0, 12
FROM `admins`
WHERE aid > 3;

13.08.2018

MySQL

ALTER TABLE paysys_connect ADD COLUMN payment_method INT(11) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE bonus_service_discount ADD COLUMN onetime_payment_sum DOUBLE(10, 2) NOT NULL DEFAULT '0.00';
ALTER TABLE `bonus_service_discount` ADD COLUMN `name` VARCHAR(100) NOT NULL default '';

07.08.2018

MySQL

CREATE TABLE IF NOT EXISTS  `storage_property` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(30) NOT NULL DEFAULT '',
  `comments` VARCHAR(60) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
)
  DEFAULT CHARSET=utf8 COMMENT = 'Storage property table';
 
CREATE TABLE IF NOT EXISTS `storage_articles_property` (
  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `storage_incoming_articles_id` INT(10) UNSIGNED DEFAULT '0',
  `property_id` INT(10) UNSIGNED NOT NULL DEFAULT 0,
  `value` TEXT,
  PRIMARY KEY (`id`)
)
DEFAULT CHARSET=utf8 COMMENT = 'Storage items property table';
 
SET SQL_MODE = 'NO_ENGINE_SUBSTITUTION,NO_AUTO_VALUE_ON_ZERO';
CREATE TABLE IF NOT EXISTS  `storage_measure` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(30) NOT NULL DEFAULT '',
  `comments` VARCHAR(60) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
)
  DEFAULT CHARSET=utf8 COMMENT = 'Storage measuring';
 
REPLACE INTO `storage_measure` (`id`, `name`) VALUES (0, '$lang{UNIT}');
REPLACE INTO `storage_measure` (`id`, `name`) VALUES (1, '$lang{METERS}');
REPLACE INTO `storage_measure` (`id`, `name`) VALUES (2, '$lang{SM}');
REPLACE INTO `storage_measure` (`id`, `name`) VALUES (3, '$lang{MM}');
REPLACE INTO `storage_measure` (`id`, `name`) VALUES (4, '$lang{LITERS}');
REPLACE INTO `storage_measure` (`id`, `name`) VALUES (5, '$lang{BOXES}');

23.07.2018

MySQL

 

27.06.2018

MySQL

ALTER TABLE `equipment_pon_onu` ADD COLUMN `vlan` smallint(6) unsigned NOT NULL DEFAULT '0';
 
ALTER TABLE `crm_salaries_payed` DROP PRIMARY KEY;
ALTER TABLE `crm_salaries_payed` ADD COLUMN `id` INT UNSIGNED PRIMARY KEY NOT NULL AUTO_INCREMENT;
 
ALTER TABLE `crm_leads` ADD COLUMN `uid` INT(11) UNSIGNED NOT NULL DEFAULT '0';

0.77

31.05.2018

MySQL

ALTER TABLE `crm_actions` MODIFY COLUMN `name` char(60) NOT NULL DEFAULT '';
ALTER TABLE `iptv_calls` ADD COLUMN `service_id` INT(11) UNSIGNED NOT NULL DEFAULT '0';
 
ALTER TABLE `storage_sn` ADD COLUMN `sn_comments` TEXT;
 
ALTER TABLE `tasks_main` CHANGE COLUMN `resposible` `responsible` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `tasks_admins` CHANGE COLUMN `resposible` `responsible` TINYINT(2) UNSIGNED NOT NULL DEFAULT '0';
 
CREATE TABLE IF NOT EXISTS `tasks_plugins` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `enable` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
  `name` VARCHAR(60) NOT NULL DEFAULT '',
  `descr` TEXT NOT NULL,
  PRIMARY KEY (`id`)
)
  COMMENT = 'Tasks plugins';

26.04.2018

MySQL

ALTER TABLE `storage_installation` ADD COLUMN `monthes` SMALLINT(3) UNSIGNED NOT NULL DEFAULT 0;
ALTER TABLE `storage_installation` ADD COLUMN `amount_per_month` DOUBLE(10, 2) UNSIGNED NOT NULL DEFAULT '0.00';
ALTER TABLE `storage_incoming_articles` ADD COLUMN `in_installments_price` DOUBLE(10, 2) UNSIGNED NOT NULL DEFAULT '0.00';
ALTER TABLE `docs_invoice_orders` ADD COLUMN `fees_type` SMALLINT(6) UNSIGNED NOT NULL DEFAULT 0;
ALTER TABLE `abon_tariffs` ADD COLUMN `description` VARCHAR(240) NOT NULL DEFAULT '';
ALTER TABLE `filters` ADD COLUMN `params` VARCHAR(200) NOT NULL DEFAULT '';
 
CREATE TABLE IF NOT EXISTS `taxes` ( 
  `id`            SMALLINT(6) UNSIGNED  NOT NULL AUTO_INCREMENT,
  `ratecode`      VARCHAR(30)           NOT NULL DEFAULT '',
  `ratedescr`     VARCHAR(130)          NOT NULL DEFAULT '',
  `rateamount`    TINYINT(100) UNSIGNED NOT NULL DEFAULT '0',
  `current`       TINYINT(2) UNSIGNED   NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
)
  DEFAULT CHARSET = utf8
  COMMENT = 'Tax Magazine';

11.04.2018

MySQL

ALTER TABLE `users_contacts` ADD COLUMN `comments` TEXT NOT NULL;
ALTER TABLE `billd_plugins` ADD COLUMN  `last_end` DATETIME NOT NULL;
 
CREATE TABLE IF NOT EXISTS `equipment_tr_069_settings` (
  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `onu_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  `updatetime` DATETIME NOT NULL  DEFAULT CURRENT_TIMESTAMP,
  `changetime` DATETIME NOT NULL  DEFAULT CURRENT_TIMESTAMP,
  `settings` TEXT,
  PRIMARY KEY (`id`)
)   COMMENT='Equipment TR-069 Settings';
 
ALTER TABLE `builds` ADD COLUMN `schema` VARCHAR(150) NOT NULL DEFAULT '';
 
# Comment
 
ALTER TABLE `shedule` ADD KEY uid (uid);
 
CREATE TABLE IF NOT EXISTS `storage_inner_use` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `storage_incoming_articles_id` INT(10) UNSIGNED DEFAULT '0',
  `count` INT(10) UNSIGNED DEFAULT '0',
  `aid` INT(10) UNSIGNED DEFAULT '0',
  `date` DATETIME DEFAULT NULL,
  `sum` DOUBLE(10, 2) UNSIGNED NOT NULL DEFAULT '0.00',
  `comments` TEXT,
  PRIMARY KEY (`id`),
  KEY `storage_incoming_articles_id` (`storage_incoming_articles_id`)
);
 
CREATE TABLE IF NOT EXISTS `crm_actions` (
  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` char(40) NOT NULL DEFAULT '',
  `action` TEXT NOT NULL,
  PRIMARY KEY (`id`)
) COMMENT = 'Actions for leads';
 
ALTER TABLE `crm_progressbar_step_comments` ADD COLUMN `action_id` INT UNSIGNED NOT NULL DEFAULT 0;
ALTER TABLE `crm_progressbar_step_comments` ADD COLUMN `status` SMALLINT(2) UNSIGNED NOT NULL DEFAULT 0;
ALTER TABLE `crm_progressbar_step_comments` ADD COLUMN `aid` SMALLINT(6) UNSIGNED NOT NULL DEFAULT 0;
ALTER TABLE `crm_progressbar_step_comments` ADD COLUMN `planned_date` DATE NOT NULL DEFAULT '0000-00-00';
 
ALTER TABLE `builds` ADD COLUMN `numbering_direction` tinyint(1) unsigned NOT NULL default '0';
 
ALTER TABLE `billd_plugins` ADD COLUMN `last_end` DATETIME NOT NULL;
ALTER TABLE `billd_plugins` ADD COLUMN `last_execute` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP;
 
ALTER TABLE `fees_types` ADD COLUMN `tax` DOUBLE(10, 2) NOT NULL DEFAULT '0.00';
ALTER TABLE `docs_invoice_orders` ADD COLUMN `fees_type` SMALLINT(6) UNSIGNED NOT NULL DEFAULT 0;
 
CREATE TABLE IF NOT EXISTS paysys_connect (
  `id` TINYINT UNSIGNED AUTO_INCREMENT,
  `paysys_id` TINYINT UNSIGNED NOT NULL DEFAULT 0,
  `name` VARCHAR(40) NOT NULL DEFAULT '',
  `module` VARCHAR(40) NOT NULL DEFAULT '',
  `status` TINYINT UNSIGNED NOT NULL DEFAULT 0,
  `paysys_ip` TEXT NOT NULL,
  UNIQUE KEY `id`(`id`)
) COMMENT = 'Paysys connected systems';

01.03.2018

MySQL

ALTER TABLE  `ippools`  ADD COLUMN `ipv6_mask` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0;
ALTER TABLE  `ippools`  ADD COLUMN `ipv6_template` VARBINARY(100) NOT NULL DEFAULT '';
ALTER TABLE  `ippools`  ADD COLUMN `ipv6_pd_mask` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0;
ALTER TABLE  `ippools`  ADD COLUMN `ipv6_pd_template` VARBINARY(100) NOT NULL DEFAULT '';
ALTER TABLE  `ippools`  ADD COLUMN `ipv6_pd` VARBINARY(16) NOT NULL DEFAULT '';
ALTER TABLE  `internet_online` ADD KEY nas_id (`nas_id`);
ALTER TABLE `equipment_mac_log` ADD COLUMN `rem_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00';
UPDATE internet_online, internet_main SET internet_online.service_id=internet_main.id WHERE  internet_online.uid=internet_main.uid AND internet_online.service_id=0;
INSERT INTO `config` (`param`, `value`, `domain_id`) VALUES ('UPDATE_SQL', '036.sql', 0);
ALTER TABLE `users_pi` ADD COLUMN `birth_date` DATE NOT NULL DEFAULT '0000-00-00';
ALTER TABLE `users_pi` ADD COLUMN `reg_address` TEXT;
 
ALTER TABLE  `equipment_infos` ADD COLUMN `internet_vlan` smallint(6) unsigned NOT NULL DEFAULT '0';
ALTER TABLE  `equipment_infos` ADD COLUMN `tr_069_vlan` smallint(6) unsigned NOT NULL DEFAULT '0';
ALTER TABLE  `equipment_infos` ADD COLUMN `iptv_vlan` smallint(6) unsigned NOT NULL DEFAULT '0';

20.02.2018

MySQL

ALTER TABLE equipment_models ADD COLUMN `height_units` SMALLINT(3) UNSIGNED NOT NULL DEFAULT 1;
ALTER TABLE equipment_models ADD COLUMN `width_units` SMALLINT(3) UNSIGNED NOT NULL DEFAULT 1;
ALTER TABLE equipment_models ADD COLUMN `rows` SMALLINT(3) UNSIGNED NOT NULL DEFAULT 1;
 
ALTER TABLE `ippools`ADD COLUMN `ipv6_mask` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0;
ALTER TABLE `ippools`ADD COLUMN `ipv6_template` VARBINARY(100) NOT NULL DEFAULT '';
 
CREATE TABLE IF NOT EXISTS equipment_models_custom(
  `nas_id` SMALLINT(6) UNSIGNED NOT NULL,
  `model_id` SMALLINT(6) UNSIGNED NOT NULL,
  `geometry_json` TEXT
);
 
ALTER TABLE `equipment_models` ADD COLUMN `geometry_json` TEXT;
CREATE TABLE IF NOT EXISTS equipment_plates (
  `id` SMALLINT(6) UNSIGNED NOT NULL DEFAULT 1,
  `height_units` SMALLINT(3) UNSIGNED NOT NULL DEFAULT 1,
  `width_units` SMALLINT(3) UNSIGNED NOT NULL DEFAULT 1,
  `ports` SMALLINT(3) UNSIGNED NOT NULL DEFAULT 1,
  `port_type` SMALLINT(3) UNSIGNED NOT NULL DEFAULT 1
);
 
CREATE TABLE IF NOT EXISTS equipment_model_plates (
  `model_id` SMALLINT(6) UNSIGNED NOT NULL,
  `plate_id` SMALLINT(6) UNSIGNED NOT NULL
);
 
ALTER TABLE `users_pi` ADD COLUMN `floor` SMALLINT(3) UNSIGNED NOT NULL;
ALTER TABLE `users_pi` ADD COLUMN `entrance` SMALLINT(3) UNSIGNED NOT NULL;
 
ALTER TABLE `internet_online` ADD COLUMN `delegated_ipv6_prefix` VARBINARY(16) NOT NULL DEFAULT '';
ALTER TABLE `internet_main` ADD COLUMN `ipv6_mask` tinyint(1) unsigned NOT NULL DEFAULT 0;
ALTER TABLE `internet_main` ADD COLUMN `ipv6_prefix_mask` tinyint(1) unsigned NOT NULL DEFAULT 0;
 
 
ALTER TABLE `bonus_service_discount` ADD COLUMN `comments` TEXT NOT NULL;
ALTER TABLE `bonus_service_discount` ADD COLUMN `tp_id` VARCHAR(200) NOT NULL DEFAULT '';

29.01.2018

MySQL

ALTER TABLE `hotspot_log` CHANGE COLUMN `id` `id` INT(8) UNSIGNED NOT NULL AUTO_INCREMENT;
 
CREATE TABLE IF NOT EXISTS `contracts_type` (
  `id` SMALLINT(5) unsigned NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(120) NOT NULL DEFAULT '',
  `template` VARCHAR(40) NOT NULL DEFAULT '',
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Contracts type';
 
DELETE FROM events_state WHERE id=4;
REPLACE INTO `events_state` VALUES
  (1, '_{NEW}_'),
  (2, '_{SEEN}_'),
  (3, '_{CLOSED}_')
;
 
REPLACE INTO `events_priority` VALUES
  (1, '_{VERY_LOW}_', 0),
  (2, '_{LOW}_', 1),
  (3, '_{NORMAL}_', 2),
  (4, '_{HIGH}_', 3),
  (5, '_{CRITICAL}_', 4);
 
REPLACE INTO `events_privacy` VALUES
  (1, '_{ALL}_', 0),
  (2, '_{ADMIN}_ _{GROUP}_', 1),
  (3, '_{ADMIN}_ _{USER}_ _{GROUP}_', 2),
  (4, '_{ADMIN}_ _{GEOZONE}_', 3);
 
ALTER TABLE `events` ADD COLUMN `aid` SMALLINT UNSIGNED NOT NULL DEFAULT 0;
 
ALTER TABLE `internet_main` ADD COLUMN   `ipv6` VARBINARY(16) NOT NULL DEFAULT '';
 
CREATE TABLE IF NOT EXISTS paysys_connect (
  `id` TINYINT UNSIGNED NOT NULL DEFAULT 0,
  `status` TINYINT UNSIGNED NOT NULL DEFAULT 0,
  UNIQUE KEY `id`(`id`)
) COMMENT = 'Paysys connected systems';
 
ALTER TABLE `events` ADD COLUMN `domain_id` SMALLINT NOT NULL DEFAULT 0;
 
ALTER TABLE `equipment_models` ADD COLUMN `port_shift` TINYINT(2) NOT NULL DEFAULT '0';
ALTER TABLE `equipment_models` ADD COLUMN `test_firmware` VARCHAR(20) NOT NULL DEFAULT '';

0.76

29.12.2017 

    UPDATE cablecat_links SET fiber_num_1 = (fiber_num_1 - 1);
    UPDATE cablecat_links SET fiber_num_2 = (fiber_num_2 - 1);

MySQL

ALTER TABLE `internet_main` ADD COLUMN   `ipv6` VARBINARY(16) NOT NULL DEFAULT '';
 
CREATE TABLE IF NOT EXISTS `paysys_groups_settings` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `gid` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
  `paysys_id` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
  UNIQUE KEY `id` (`id`)
)
  COMMENT = 'Settings for each group';
 
CREATE TABLE IF NOT EXISTS `users_contracts` (
  `id` SMALLINT(5) unsigned NOT NULL AUTO_INCREMENT,
  `parrent_id` SMALLINT(5) unsigned NOT NULL DEFAULT '0',
  `uid` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  `company_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  `number` VARCHAR(40) NOT NULL DEFAULT '',
  `name` VARCHAR(120) NOT NULL DEFAULT '',
  `date` DATE NOT NULL,
  `end_date` DATE NOT NULL,
  `type` SMALLINT(3) NOT NULL DEFAULT '0',
  `reg_date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `aid` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  `signature` TEXT,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Contracts';
 
ALTER TABLE equipment_mac_log ADD COLUMN port_name VARCHAR(50) NOT NULL DEFAULT '';
ALTER TABLE equipment_mac_log CHANGE COLUMN port port VARCHAR(50) COLLATE utf8_general_ci DEFAULT '';
 
CREATE TABLE IF NOT EXISTS `cablecat_commutation_crosses` (
  `commutation_id` INT(11) UNSIGNED REFERENCES `cablecat_commutations` (`id`)
    ON DELETE CASCADE,
  `cross_id` INT(11) UNSIGNED REFERENCES `cablecat_crosses` (`id`)
    ON DELETE CASCADE,
  `port_start` SMALLINT(6) UNSIGNED NOT NULL,
  `port_finish` SMALLINT(6) UNSIGNED NOT NULL,
  `commutation_x` DOUBLE(5, 2) NULL,
  `commutation_y` DOUBLE(5, 2) NULL,
  `commutation_rotation` SMALLINT NOT NULL DEFAULT 0,
  INDEX `_cross_commutation` (`commutation_id`, `cross_id`)
)
  COMMENT = 'Stores information about cross on commutation links and images';
 
CREATE TABLE IF NOT EXISTS `cablecat_cross_links` (
  `cross_id` INT(11) UNSIGNED REFERENCES `cablecat_crosses` (`id`)
    ON DELETE CASCADE,
  `cross_port` INT(6) UNSIGNED NOT NULL,
  `link_type` SMALLINT(3) UNSIGNED NOT NULL,
  `link_value` VARCHAR(32) NOT NULL DEFAULT '',
  UNIQUE `_cross_port` (`cross_id`, `cross_port`)
)
  COMMENT = 'Logical values for port connection';

18.12.2017

MySQL

ALTER TABLE `shedule` ADD COLUMN  `service_id` INT(11) UNSIGNED NOT NULL DEFAULT '0';
 
CREATE TABLE IF NOT EXISTS `admin_type_permits` (
  `type` varchar(60) NOT NULL DEFAULT '',
  `section` smallint(6) unsigned NOT NULL DEFAULT '0',
  `actions` smallint(6) unsigned NOT NULL DEFAULT '0',
  `module` varchar(12) NOT NULL DEFAULT ''
)
  COMMENT = 'Deferred tasks';
 
REPLACE INTO `admin_type_permits` (`type`, `section`, `actions`, `module`) VALUES
  ('$lang{ALL} $lang{PERMISSION}', 0,  0, ''),
  ('$lang{ALL} $lang{PERMISSION}', 0,  1, ''),
  ('$lang{ALL} $lang{PERMISSION}', 0,  2, ''),
  ('$lang{ALL} $lang{PERMISSION}', 0,  3, ''),
  ('$lang{ALL} $lang{PERMISSION}', 0,  4, ''),
  ('$lang{ALL} $lang{PERMISSION}', 0,  5, ''),
  ('$lang{ALL} $lang{PERMISSION}', 0,  6, ''),
  ('$lang{ALL} $lang{PERMISSION}', 0,  7, ''),
  ('$lang{ALL} $lang{PERMISSION}', 0,  8, ''),
  ('$lang{ALL} $lang{PERMISSION}', 0,  9, ''),
  ('$lang{ALL} $lang{PERMISSION}', 0,  10, ''),
  ('$lang{ALL} $lang{PERMISSION}', 0,  11, ''),
  ('$lang{ALL} $lang{PERMISSION}', 0,  14, ''),
  ('$lang{ALL} $lang{PERMISSION}', 0,  16, ''),
  ('$lang{ALL} $lang{PERMISSION}', 0,  17, ''),
  ('$lang{ALL} $lang{PERMISSION}', 1,  0, ''),
  ('$lang{ALL} $lang{PERMISSION}', 1,  1, ''),
  ('$lang{ALL} $lang{PERMISSION}', 1,  2, ''),
  ('$lang{ALL} $lang{PERMISSION}', 1,  3, ''),
  ('$lang{ALL} $lang{PERMISSION}', 1,  4, ''),
  ('$lang{ALL} $lang{PERMISSION}', 2,  0, ''),
  ('$lang{ALL} $lang{PERMISSION}', 2,  1, ''),
  ('$lang{ALL} $lang{PERMISSION}', 2,  2, ''),
  ('$lang{ALL} $lang{PERMISSION}', 2,  3, ''),
  ('$lang{ALL} $lang{PERMISSION}', 3,  0, ''),
  ('$lang{ALL} $lang{PERMISSION}', 3,  1, ''),
  ('$lang{ALL} $lang{PERMISSION}', 3,  2, ''),
  ('$lang{ALL} $lang{PERMISSION}', 3,  3, ''),
  ('$lang{ALL} $lang{PERMISSION}', 4,  0, ''),
  ('$lang{ALL} $lang{PERMISSION}', 4,  1, ''),
  ('$lang{ALL} $lang{PERMISSION}', 4,  2, ''),
  ('$lang{ALL} $lang{PERMISSION}', 4,  3, ''),
  ('$lang{ALL} $lang{PERMISSION}', 4,  4, ''),
  ('$lang{ALL} $lang{PERMISSION}', 4,  5, ''),
  ('$lang{ALL} $lang{PERMISSION}', 4,  6, ''),
  ('$lang{ALL} $lang{PERMISSION}', 5,  0, ''),
  ('$lang{ALL} $lang{PERMISSION}', 5,  1, ''),
  ('$lang{ALL} $lang{PERMISSION}', 5,  2, ''),
  ('$lang{ALL} $lang{PERMISSION}', 6,  0, ''),
  ('$lang{ALL} $lang{PERMISSION}', 7,  0, ''),
  ('$lang{ALL} $lang{PERMISSION}', 8,  0, ''),
 
  ('$lang{MANAGER}', 0,  0, ''),
  ('$lang{MANAGER}', 0,  1, ''),
  ('$lang{MANAGER}', 0,  2, ''),
  ('$lang{MANAGER}', 0,  3, ''),
  ('$lang{MANAGER}', 0,  4, ''),
  ('$lang{MANAGER}', 0,  5, ''),
  ('$lang{MANAGER}', 0,  6, ''),
  ('$lang{MANAGER}', 0,  7, ''),
  ('$lang{MANAGER}', 0,  8, ''),
  ('$lang{MANAGER}', 0,  9, ''),
  ('$lang{MANAGER}', 0,  10, ''),
  ('$lang{MANAGER}', 0,  11, ''),
  ('$lang{MANAGER}', 1,  0, ''),
  ('$lang{MANAGER}', 1,  1, ''),
  ('$lang{MANAGER}', 2,  0, ''),
  ('$lang{MANAGER}', 2,  1, ''),
  ('$lang{MANAGER}', 5,  0, ''),
  ('$lang{MANAGER}', 5,  1, ''),
  ('$lang{MANAGER}', 6,  0, ''),
  ('$lang{MANAGER}', 7,  0, ''),
  ('$lang{MANAGER}', 8,  0, ''),
 
  ('$lang{SUPPORT}', 0,  0, 'Msgs'),
  ('$lang{SUPPORT}', 0,  2, 'Maps'),
  ('$lang{SUPPORT}', 5,  0, 'Snmputils'),
  ('$lang{SUPPORT}', 5,  1, 'Notepad'),
  ('$lang{SUPPORT}', 6,  0, ''),
  ('$lang{SUPPORT}', 7,  0, ''),
  ('$lang{SUPPORT}', 8,  0, ''),
 
  ('$lang{ACCOUNTANT}', 0,  0, 'Docs'),
  ('$lang{ACCOUNTANT}', 0,  2, 'Paysys'),
  ('$lang{ACCOUNTANT}', 1,  0, 'Cards'),
  ('$lang{ACCOUNTANT}', 1,  1, 'Extfin'),
  ('$lang{ACCOUNTANT}', 1,  2, 'Notepad'),
  ('$lang{ACCOUNTANT}', 1,  3, ''),
  ('$lang{ACCOUNTANT}', 1,  4, ''),
  ('$lang{ACCOUNTANT}', 2,  0, ''),
  ('$lang{ACCOUNTANT}', 2,  1, ''),
  ('$lang{ACCOUNTANT}', 2,  2, ''),
  ('$lang{ACCOUNTANT}', 2,  3, ''),
  ('$lang{ACCOUNTANT}', 3,  0, ''),
  ('$lang{ACCOUNTANT}', 3,  1, ''),
  ('$lang{ACCOUNTANT}', 6,  0, ''),
  ('$lang{ACCOUNTANT}', 7,  0, ''),
  ('$lang{ACCOUNTANT}', 8,  0, '');
 
  ALTER TABLE `cablecat_cable_types` ADD COLUMN `can_be_splitted` TINYINT(1) NOT NULL DEFAULT 1;
  ALTER TABLE `streets` ADD COLUMN `type` TINYINT(1) NOT NULL DEFAULT '0';
 
  REPLACE INTO `service_status` (`id`, `name`, `color`, `type`, `get_fees`) VALUES (10, '$lang{TRAF_LIMIT}', '9F9F9F', 0, 0);
 
 
ALTER TABLE `equipment_models` ADD COLUMN `snmp_port_shift` tinyint(2) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `equipment_models` ADD COLUMN `test_firmvare` VARCHAR(20) NOT NULL DEFAULT '0';
 
DROP TABLE IF EXISTS `employees_profile_reply`;
CREATE TABLE IF NOT EXISTS `employees_profile_reply` (
  `question_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  `profile_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  `reply` text NOT NULL,
  KEY `question_id` (`question_id`),
  UNIQUE KEY(`question_id`, `profile_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Employees profile reply';
 
INSERT INTO `cablecat_links` (
  `commutation_id`, `geometry`, `attenuation`, `comments`, `direction`,
  `element_1_type`, `element_1_id`, `fiber_num_1`, `element_1_side`,
  `element_2_type`, `element_2_id`, `fiber_num_2`, `element_2_side`
)
  SELECT `commutation_id`, `geometry`, `attenuation`, `comments`, `direction`,
    'CABLE', cable_id_1, fiber_num_1, cable_side_1,
    'CABLE', cable_id_2, fiber_num_1, cable_side_2
  FROM cablecat_commutation_links;
 
DROP TABLE IF EXISTS `cablecat_commutation_links`;
 
ALTER TABLE `users_pi` ADD COLUMN `fio2` VARCHAR(40) NOT NULL DEFAULT '';
ALTER TABLE `users_pi` ADD COLUMN `fio3` VARCHAR(40) NOT NULL DEFAULT '';
 
ALTER TABLE `info_fields` ADD COLUMN `placeholder` VARCHAR(60) NOT NULL DEFAULT '';
 
ALTER TABLE equipment_mac_log ADD COLUMN port_name VARCHAR(50) NOT NULL DEFAULT '';
ALTER TABLE equipment_mac_log CHANGE COLUMN port port VARCHAR(50) COLLATE utf8_general_ci DEFAULT '';

24.11.2017

MySQL

ALTER TABLE `cablecat_splitters` ADD COLUMN `commutation_rotation` SMALLINT NOT NULL DEFAULT 0;
CREATE TABLE IF NOT EXISTS `callcenter_cdr` (
  `calldate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `clid` varchar(80) NOT NULL DEFAULT '',
  `src` varchar(80) NOT NULL DEFAULT '',
  `dst` varchar(80) NOT NULL DEFAULT '',
  `dcontext` varchar(80) NOT NULL DEFAULT '',
  `channel` varchar(80) NOT NULL DEFAULT '',
  `dstchannel` varchar(80) NOT NULL DEFAULT '',
  `lastapp` varchar(80) NOT NULL DEFAULT '',
  `lastdata` varchar(80) NOT NULL DEFAULT '',
  `duration` int(11) NOT NULL DEFAULT '0',
  `billsec` int(11) NOT NULL DEFAULT '0',
  `disposition` varchar(45) NOT NULL DEFAULT '',
  `amaflags` int(11) NOT NULL DEFAULT '0',
  `accountcode` varchar(20) NOT NULL DEFAULT '',
  `userfield` varchar(255) NOT NULL DEFAULT '',
  KEY `calldate` (`calldate`),
  KEY `dst` (`dst`),
  KEY `accountcode` (`accountcode`)
)
  COMMENT='Callcenter asterisk CDR';
 
CREATE TABLE IF NOT EXISTS `info_fields` (
  `id` TINYINT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(60) DEFAULT '',
  `sql_field` VARCHAR(60) DEFAULT '',
  `type` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
  `priority` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
  `abon_portal` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
  `user_chg` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
  `comment` VARCHAR(60) DEFAULT '',
  PRIMARY KEY (`id`)
)
COMMENT = 'Info_fields';
 
 
ALTER TABLE `equipment_pon_onu` ADD COLUMN `line_profile` VARCHAR(50) NOT NULL DEFAULT 'ONU';
ALTER TABLE `equipment_pon_onu` ADD COLUMN `srv_profile` VARCHAR(50) NOT NULL DEFAULT 'ALL';
ALTER TABLE `equipment_pon_onu` ADD COLUMN `deleted` INT(1) UNSIGNED NOT NULL DEFAULT '0';
CREATE TABLE IF NOT EXISTS `equipment_pon_service_ports` (
  `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `service_port_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  `nas_id` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
  `branch` VARCHAR(20) NOT NULL DEFAULT '',
  `onu_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
)
  COMMENT = 'Equipment PON service-ports';

13.11.2017

MySQL

ALTER TABLE `builds` ADD COLUMN `block` VARCHAR(20) NOT NULL DEFAULT '';
ALTER TABLE `builds` DROP KEY `street_id`;
ALTER TABLE `builds` ADD UNIQUE KEY `street_id` (`street_id`, `number`, `block`);

27.10.2017

MySQL

CREATE TABLE IF NOT EXISTS  `employees_duty` (
  `id` INT(11) UNSIGNED PRIMARY KEY AUTO_INCREMENT,
  `aid` SMALLINT(6) UNSIGNED NOT NULL DEFAULT 0,
  `start_date` DATE NOT NULL DEFAULT '0000-00-00',
  `duration` INT NOT NULL DEFAULT 0
)
  COMMENT = 'Employees duty';
 
ALTER TABLE `reports_wizard` ADD COLUMN `quick_report` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `abon_user_list` ADD COLUMN `fees_period` smallint(4) unsigned DEFAULT 0;
 
ALTER TABLE `ippools` ADD COLUMN `comments` TEXT;
 
ALTER TABLE `crm_leads` ADD COLUMN `country` VARCHAR(80) NOT NULL DEFAULT '';
 
ALTER TABLE `equipment_infos` ADD COLUMN `last_activity` DATETIME NOT NULL;
 
CREATE TABLE IF NOT EXISTS  `equipment_ping_log` (
  `id` INT(11) UNSIGNED PRIMARY KEY AUTO_INCREMENT,
  `date` DATETIME NOT NULL,
  `nas_id` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
  `status` TINYINT(2) UNSIGNED NOT NULL DEFAULT '0',
  `duration` DOUBLE(12, 4) NOT NULL DEFAULT '0.0000'
)
  COMMENT = 'Equipment ping';
 
CREATE TABLE IF NOT EXISTS `shedule_tasks` (
  `id` INT(8) UNSIGNED PRIMARY KEY AUTO_INCREMENT,
  `date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
  `module` VARCHAR(20) NOT NULL DEFAULT '',
  `fn` VARCHAR(30) NOT NULL DEFAULT '',
  `args` TEXT,
  `periodic_id` INT(8) UNSIGNED NOT NULL DEFAULT 0,
  `start_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00'
)
  COMMENT = 'Deferred tasks';
 
CREATE TABLE IF NOT EXISTS `periodic_tasks` (
  `id` INT(8) UNSIGNED PRIMARY KEY AUTO_INCREMENT,
  `minute` VARCHAR(20) NOT NULL DEFAULT '',
  `hour` VARCHAR(20) NOT NULL DEFAULT '',
  `day` VARCHAR(20) NOT NULL DEFAULT '',
  `month` VARCHAR(20) NOT NULL DEFAULT '',
  `wday` VARCHAR(20) NOT NULL DEFAULT '',
  `year` VARCHAR(20) NOT NULL DEFAULT '',
  `defer_type` TINYINT(2) NOT NULL DEFAULT 0,
  `module` VARCHAR(20) NOT NULL DEFAULT '',
  `fn` VARCHAR(30) NOT NULL DEFAULT '',
  `args` TEXT
)
  COMMENT = 'Periodic tasks';
 

19.09.2017

MySQL

ALTER TABLE `msgs_chapters` ADD COLUMN `autoclose` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `cablecat_cable_types` ADD COLUMN `attenuation` DOUBLE NOT NULL DEFAULT 0;
 
REPLACE INTO `events_group` (`id`, `name`, `modules`) VALUES (3, 'EQUIPMENT', 'Equipment, Cablecat');
 
CREATE TABLE IF NOT EXISTS `events_admin_group`(
  `aid` SMALLINT(6) UNSIGNED NOT NULL
    REFERENCES `admins`(`aid`),
  `group_id` SMALLINT(6) UNSIGNED NOT NULL
    REFERENCES `events_group` (`id`),
  UNIQUE `_aid_group` (`aid`, `group_id`)
);
 
ALTER TABLE internet_online ADD COLUMN `service_id` INT(11) UNSIGNED NOT NULL DEFAULT '0';
 
REPLACE INTO `maps_point_types` (`id`, `name`, `icon`) VALUES (8, '$lang{EQUIPMENT}', 'nas_green');
CREATE TABLE IF NOT EXISTS `employees_vacations` (
  `id` INT(11) UNSIGNED PRIMARY KEY AUTO_INCREMENT,
  `aid` SMALLINT(6) UNSIGNED NOT NULL DEFAULT 0,
  `start_date` DATE NOT NULL DEFAULT '0000-00-00',
  `end_date` DATE NOT NULL DEFAULT '0000-00-00'
)
  COMMENT = 'Employees vacations';
 
ALTER TABLE `hotspot_advert_pages` MODIFY COLUMN `action` VARCHAR(20) NOT NULL DEFAULT '';
ALTER TABLE `hotspot_log` ADD COLUMN `hotspot` VARCHAR(20) NOT NULL DEFAULT '';
 
ALTER TABLE `events` MODIFY COLUMN `comments` TEXT;
 
 
CREATE TABLE IF NOT EXISTS `sysinfo_remote_servers` (
  `id` SMALLINT(6) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `nas_id` SMALLINT(6) NOT NULL DEFAULT 0,
  `name` VARCHAR(64) NOT NULL DEFAULT '',
  `management` SMALLINT(2) NOT NULL DEFAULT 0,
  `ip` VARBINARY(11) NOT NULL DEFAULT 0,
  `port` SMALLINT(6) NOT NULL DEFAULT 0,
  `nat` TINYINT(1) NOT NULL DEFAULT 0,
  `private_key` TEXT,
  `comments` TEXT
)
  COMMENT = 'List of remote servers to control';
 
CREATE TABLE IF NOT EXISTS `sysinfo_server_services` (
  `id` SMALLINT(6) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `name` VARCHAR(64) NOT NULL DEFAULT '',
  `check_command` TEXT,
  `status` TINYINT(1) NOT NULL DEFAULT 0,
  `comments` TEXT
)
  COMMENT = 'List of services to control';
 
CREATE TABLE IF NOT EXISTS `sysinfo_remote_server_services` (
  `server_id` SMALLINT(6) NOT NULL,
  `service_id` SMALLINT(6) NOT NULL,
  UNIQUE (`server_id`, `service_id`)
)
  COMMENT = 'Bindings beetween server and services';
 
REPLACE INTO `sysinfo_remote_servers`(`id`, `name`, `management`, `ip`, `port`, `comments`) VALUES (
  1, 'localhost', 1, INET_ATON('127.0.0.1'), 19422, 'localhost'
);
 
REPLACE INTO `sysinfo_server_services`(`id`, `name`, `check_command`) VALUES
  (1, 'mysql', 'service mysql status'),
  (2, 'apache2', 'service apache2 status')
;
 
REPLACE INTO `sysinfo_remote_server_services` (`server_id`, `service_id`) VALUES
  (1, 1),
  (1, 2)
;
 
ALTER TABLE `sysinfo_server_services` ADD COLUMN `last_update` TIMESTAMP;
 
 
 
ALTER TABLE `docs_acts` ADD COLUMN `start_period` DATE NOT NULL DEFAULT '0000-00-00';
ALTER TABLE `docs_acts` ADD COLUMN `end_period` DATE NOT NULL DEFAULT '0000-00-00';

31.08.2017

MySQL

ALTER TABLE `crm_leads` ADD COLUMN `priority` SMALLINT(1) UNSIGNED NOT NULL DEFAULT 0;
 
ALTER TABLE `crm_progressbar_step_comments` ADD UNIQUE (`lead_id`, `date`);
 
ALTER TABLE `crm_leads` MODIFY `phone` VARCHAR(120) NOT NULL DEFAULT '';
 
ALTER TABLE `cashbox_coming` ADD COLUMN `aid` SMALLINT(6) UNSIGNED NOT NULL DEFAULT 0;
 
ALTER TABLE `cashbox_spending` ADD COLUMN `aid` SMALLINT(6) UNSIGNED NOT NULL DEFAULT 0;
 
 
ALTER TABLE msgs_unreg_requests ADD COLUMN `payment_sum` DOUBLE(14, 2) UNSIGNED NOT NULL DEFAULT '0.00';
ALTER TABLE msgs_unreg_requests ADD COLUMN `extra_sum` DOUBLE(14, 2) UNSIGNED NOT NULL DEFAULT '0.00';
ALTER TABLE msgs_unreg_requests ADD COLUMN `paid` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0';

24.07.2017

MySQL

ALTER TABLE `admin_settings` MODIFY COLUMN `object` VARCHAR(48) NOT NULL DEFAULT '';
ALTER TABLE `equipment_infos` ADD COLUMN `server_vlan` smallint(6) unsigned NOT NULL DEFAULT 0;
 
CREATE TABLE IF NOT EXISTS `employees_daily_notes` (
  `id` INT(11) UNSIGNED PRIMARY KEY AUTO_INCREMENT,
  `day` DATE NOT NULL DEFAULT '0000-00-00',
  `aid` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
  `comments` TEXT NOT NULL
)
  COMMENT = 'Admins daily notes';
 
CREATE TABLE IF NOT EXISTS `hotspot_advert_pages` (
  `id` SMALLINT(6) UNSIGNED NOT NULL AUTO_INCREMENT,
  `hostname` VARCHAR(20) NOT NULL DEFAULT '',
  `page` TEXT,
  `action` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
 
  PRIMARY KEY (`id`)
) 
  COMMENT = 'Hotspot advert pages';
 
  CREATE TABLE IF NOT EXISTS `admins_contacts` ( 
`id` int(11) unsigned NOT NULL AUTO_INCREMENT, 
`aid` int(11) unsigned NOT NULL, 
`type_id` smallint(6) DEFAULT NULL, 
`value` varchar(250) NOT NULL, 
`priority` smallint(6) unsigned DEFAULT NULL, 
PRIMARY KEY (`id`), 
KEY `_aid_contact` (`aid`) 
) 
COMMENT='Main admin contacts table';

05.07.2017

23.06.2017

0.75

26.05.2017

MySQL

ALTER TABLE `portal_articles` ADD COLUMN `domain_id` SMALLINT(4) NOT NULL DEFAULT 0;
 
ALTER TABLE `events` ADD COLUMN `title` VARCHAR(32) NOT NULL DEFAULT '';
 
CREATE TABLE IF NOT EXISTS `crm_progressbar_step_comments` (
  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `step_id` INT UNSIGNED NOT NULL DEFAULT 0,
  `lead_id` INT UNSIGNED NOT NULL DEFAULT 0,
  `message` TEXT NOT NULL,
  `date` DATETIME  NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) COMMENT = 'Comments for each step in progressbar';
 
ALTER TABLE `msgs_quick_replys` ADD COLUMN  `color` varchar(7) NOT NULL default '';
 
ALTER TABLE `equipment_ports`    ADD COLUMN `vlan` smallint(2) unsigned not null default 0;

04.05.2017

MySQL

ALTER TABLE `users_contacts` MODIFY COLUMN `value` VARCHAR(128) NOT NULL;
 
ALTER TABLE `admins_contacts` MODIFY COLUMN `value` VARCHAR(128) NOT NULL;
 
ALTER TABLE `companies` ADD COLUMN `location_id` int(11) unsigned NOT NULL DEFAULT '0';
 
ALTER TABLE `companies` ADD COLUMN `address_flat` varchar(10) NOT NULL DEFAULT '';
 
ALTER TABLE `ippools`    ADD COLUMN `vlan` smallint(2) unsigned not null default 0;
 
ALTER TABLE `equipment_ports`    ADD COLUMN `vlan` smallint(2) unsigned not null default 0;

18.04.2017

MySQL

REPLACE INTO `events_group` (`id`, `name`, `modules`) VALUES (2, 'CLIENTS', 'Events,Msgs,SYSTEM');
INSERT INTO `config` (`param`, `value`, `domain_id`) VALUES ('_ORGANIZATION_LOCATION_ID', '', 0);
 
ALTER TABLE `msgs_dispatch` ADD COLUMN `category` int(11) unsigned NOT NULL DEFAULT '0';
 
CREATE TABLE IF NOT EXISTS `msgs_dispatch_category` (
  `id`   int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
)
  COMMENT='Messages dispatch category';
 
CREATE TABLE IF NOT EXISTS `msgs_quick_replys_types` (
  `id`   SMALLINT(6) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(30) NOT NULL DEFAULT '',
  PRIMARY KEY(`id`)
)
COMMENT = 'Quick replys types';
 
CREATE TABLE IF NOT EXISTS `msgs_quick_replys` (
 `id`      SMALLINT(6)  UNSIGNED NOT NULL AUTO_INCREMENT,
 `reply`   VARCHAR(250) NOT NULL DEFAULT '',
 `type_id` SMALLINT(6),
  PRIMARY KEY(`id`)
)
COMMENT = 'Quick replys';
 
CREATE TABLE IF NOT EXISTS `msgs_quick_replys_tags` (
 `quick_reply_id` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
 `msg_id` INT(11) UNSIGNED NOT NULL DEFAULT '0'
)
COMMENT = 'Quick replys msgs tags';

04.04.2017

MySQL

  ALTER TABLE `msgs_status` ADD COLUMN `icon` VARCHAR(30) NOT NULL DEFAULT '';
 
  SET SESSION sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
  REPLACE INTO `msgs_status` (`id`, `name`, `readiness`, `task_closed`, `color`, `icon`) VALUES
    ('0', '$lang{OPEN}',                             '0',   '0', '#0000FF', 'fa fa-envelope-open text-aqua'),
    ('1', '$lang{CLOSED_UNSUCCESSFUL}',              '100', '1', '#ff0638', 'fa fa-warning text-red'),
    ('2', '$lang{CLOSED_SUCCESSFUL}',                '100', '1', '#009D00', 'fa fa-check text-green'),
    ('3', '$lang{IN_WORK}',                          '10',  '0', '#707070', 'fa fa-wrench'),
    ('4', '$lang{NEW_MESSAGE}',                      '0',   '0', '#FF8000', 'fa fa-reply text-blue'),
    ('5', '$lang{HOLD_UP}',                          '0',   '0', '0',       'fa fa-clock-o'),
    ('6', '$lang{ANSWER_WAIT}',                      '50',  '0', '',        'fa fa-envelope-open-o'),
    ('9', '$lang{NOTIFICATION_MSG}',                 '0',   '0', '',        'fa fa-flag text-red'),
    ('10', '$lang{NOTIFICATION_MSG}  $lang{READED}', '100', '0', '',        'fa fa-flag-o text-red'),
    ('11', '$lang{POTENTIAL_CLIENT}',                '0',   '0', '',        'fa fa-user-plus text-green');
  ALTER TABLE `msgs_proggress_bar` ADD COLUMN `user_notice` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0;
  ALTER TABLE `msgs_proggress_bar` ADD COLUMN `responsible_notice` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0;
  ALTER TABLE `msgs_proggress_bar` ADD COLUMN `follower_notice` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0;
  ALTER TABLE `msgs_chapters` ADD COLUMN `responsible` SMALLINT(6) UNSIGNED NOT NULL DEFAULT 0;

20.03.2017

MySQL

  ALTER TABLE `service_status` ADD COLUMN `get_fees` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0;
  ALTER TABLE `dhcphosts_leases` ADD COLUMN  `server_vlan` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0';

03.03.2017

16.02.2017

07.02.2017

MySQL

  ALTER TABLE `ippools` ADD COLUMN `guest` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0';
  ALTER TABLE `ippools` ADD COLUMN `domain_id` smallint(6) UNSIGNED NOT NULL DEFAULT '0';
  ALTER TABLE `dhcphosts_networks` ADD COLUMN `domain_id` smallint(6) UNSIGNED NOT NULL DEFAULT '0';
  ALTER TABLE `iptv_services` ADD COLUMN `subscribe_count` TINYINT(2) UNSIGNED NOT NULL DEFAULT 1;

16.01.2017

MySQL

  ALTER TABLE `groups` ADD COLUMN `bonus` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0;

04.01.2017

MySQL

  ALTER TABLE builds ADD COLUMN `zip` varchar(7) NOT NULL DEFAULT '';

15.12.2016

MySQL

  ALTER TABLE `iptv_main` ADD COLUMN  `service_id` tinyint(2) unsigned not null default 0;
  ALTER TABLE `iptv_main` CHANGE COLUMN `subscribe_id` `subscribe_id` VARCHAR(32) NOT NULL DEFAULT '';
 

05.12.2016

MySQL

  ALTER TABLE `tarif_plans` ADD COLUMN `service_id` tinyint(2) unsigned not null default 0;
  ALTER TABLE `paysys_main`  ADD COLUMN `external_user_ip` int(11) unsigned NOT NULL DEFAULT 0;
  ALTER TABLE `equipment_infos` ADD COLUMN revision VARCHAR(10) NOT NULL DEFAULT '';
 

21.11.2016

MySQL

  DROP TABLE `msgs_status`;
  CREATE TABLE `msgs_status` (
    `id` smallint(2) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(60) NOT NULL DEFAULT '',
    `readiness` tinyint(2) unsigned NOT NULL DEFAULT 0,
    `task_closed` tinyint(1) NOT NULL DEFAULT 0,
    `color` varchar(7) NOT NULL DEFAULT '',
    UNIQUE name (`name`),
    PRIMARY KEY (`id`)
  ) COMMENT 'Messages statuses';
 
  SET SESSION sql_mode='NO_AUTO_VALUE_ON_ZERO';
  REPLACE INTO msgs_status (id, name, readiness, task_closed, color) VALUE
    ('0', '$lang{OPEN}', 0, '0', '#0000FF'),
    ('1', '$lang{CLOSED_UNSUCCESSFUL}', 100, '1', '#ff0638'),
    ('2', '$lang{CLOSED_SUCCESSFUL}',  100, '1', '#009D00'),
    ('3', '$lang{IN_WORK}', 10, '0', '#707070'),
    ('4', '$lang{NEW_MESSAGE}', 0, '0', '#FF8000'),
    ('5', '$lang{HOLD_UP}', 0, 0, '0'),
    ('6', '$lang{ANSWER_WAIT}', 50, '0', ''),
    ('9', '$lang{NOTIFICATION_MSG}', 0, '0', ''),
    ('10', '$lang{NOTIFICATION_MSG}  $lang{READED}', 100, '0', ''),
    ('11', '$lang{POTENTIAL_CLIENT}', 0, '0', '');
  ALTER TABLE admins ADD COLUMN   `sip_number` varchar(15) NOT NULL default '';

16.11.2016

MySQL

  ALTER TABLE events MODIFY COLUMN `group_id` smallint(6) unsigned NOT NULL DEFAULT 1;
  ALTER TABLE builds ADD planned_to_connect tinyint(1) unsigned NOT NULL default '0';
  ALTER TABLE `cams_streams` ADD COLUMN `orientation` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0;
  CREATE TABLE `payments_type` (
    `id`      INT(11)     UNSIGNED PRIMARY KEY AUTO_INCREMENT,
    `name`    varchar(50) NOT NULL DEFAULT '',
    `color`   varchar(7)  NOT NULL default '',
   UNIQUE KEY `id` (`id`)
  ) COMMENT 'Add new payment type';
 
  ALTER TABLE cams_streams ADD COLUMN `zoneminder_id` INT(11) UNSIGNED NOT NULL DEFAULT 0;
  ALTER TABLE cams_streams CHANGE COLUMN `ip` `host` VARCHAR(255) NOT NULL DEFAULT '0.0.0.0';
  ALTER TABLE cams_streams ADD COLUMN `rtsp_path` TEXT;
  ALTER TABLE cams_streams ADD COLUMN `rtsp_port` SMALLINT(6) NOT NULL DEFAULT 554;
 
  REPLACE INTO maps_point_types (`id`, `name`, `icon`) VALUES (9, '$lang{PILLAR}', 'pillar_green');
  ALTER TABLE maps_points ADD COLUMN `parent_id` INT(11) REFERENCES maps_points (`id`) ON DELETE RESTRICT;
  ALTER TABLE maps_points ADD COLUMN `planned` TINYINT(1) NOT NULL DEFAULT 0;
  ALTER TABLE maps_points ADD COLUMN `location_id` INT(11) UNSIGNED;
  ALTER TABLE maps_points ADD COLUMN `created` DATETIME NOT NULL  DEFAULT CURRENT_TIMESTAMP;
  ALTER TABLE maps_points ADD CONSTRAINT point_build FOREIGN KEY location_id(`location_id`) REFERENCES builds(`id`) ON DELETE RESTRICT;
  CREATE INDEX `_points_location_id` ON maps_points(`location_id`);
  REPLACE INTO payments_type (id, name, color) VALUES
  (0, '$lang{CASH}', ''),
  (1, '$lang{BANK}', ''),
  (2, '$lang{EXTERNAL_PAYMENTS}', ''),
  (3, 'Credit Card', ''),
  (4, '$lang{BONUS}', ''),
  (5, '$lang{CORRECTION}', ''),
  (6, '$lang{COMPENSATION}', ''),
  (7, '$lang{MONEY_TRANSFER}', ''),
  (8, '$lang{RECALCULATE}', '');
 
  ALTER TABLE msgs_unreg_requests ADD last_contact datetime NOT NULL default '0000-00-00 00:00:00';
  ALTER TABLE msgs_unreg_requests ADD planned_contact datetime NOT NULL default '0000-00-00 00:00:00';
  ALTER TABLE msgs_unreg_requests ADD contact_note text NOT NULL;

02.11.2016

17.10.2016

MySQL

  ALTER TABLE equipment_infos ADD COLUMN  snmp_version tinyint(1) unsigned not null default 1;
  ALTER TABLE employees_positions ADD COLUMN  vacancy tinyint(2) UNSIGNED NOT NULL DEFAULT '0';
  ALTER TABLE admins ADD COLUMN  telegram_id varchar(15) NOT NULL DEFAULT '';

25.09.2016

MySQL

  ALTER TABLE `msgs_messages` ADD `rating` tinyint(4) unsigned NOT NULL DEFAULT '0';
  ALTER TABLE `msgs_messages` ADD `rating_comment` text not null;
  ALTER TABLE `storage_log` ADD COLUMN `uid` int(10) unsigned NOT NULL default '0';
  ALTER TABLE `s_detail` ADD COLUMN `uid` int(10) unsigned NOT NULL default '0';
  CREATE TABLE IF NOT EXISTS `equipment_pon_onu` (
    `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
    `port_id` smallint(6) unsigned NOT NULL DEFAULT '0',
    `onu_snmp_id` varchar(20) NOT NULL DEFAULT '',
    `onu_id` int(11) unsigned NOT NULL DEFAULT '0',
    `onu_mac_serial` varchar(20) NOT NULL DEFAULT '',
    `onu_desc` varchar(50) NOT NULL DEFAULT '',
    `olt_rx_power` double(10,2) NOT NULL DEFAULT '0.00',
    `onu_rx_power` double(10,2) NOT NULL DEFAULT '0.00',
    `onu_tx_power` double(10,2) NOT NULL DEFAULT '0.00',
    `onu_status` int(10) unsigned NOT NULL DEFAULT '0',
    `onu_in_byte` bigint(14) unsigned NOT NULL DEFAULT '0',
    `onu_out_byte` bigint(14) unsigned NOT NULL DEFAULT '0',
    `onu_dhcp_port` varchar(20) NOT NULL DEFAULT '',
    `onu_graph` varchar(50) NOT NULL DEFAULT 'SIGNAL,TEMPERATURE,SPEED',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Equipment ONU';
 
  CREATE TABLE `equipment_pon_ports` (
    `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
    `snmp_id` int(11) unsigned NOT NULL DEFAULT '0',
    `nas_id` smallint(6) unsigned NOT NULL DEFAULT '0',
    `pon_type` varchar(10) NOT NULL DEFAULT '',
    `branch` varchar(20) NOT NULL DEFAULT '',
    `branch_desc` varchar(30) NOT NULL DEFAULT '',
    `vlan_id` smallint(6) unsigned NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`)
  ) COMMENT='Equipment PON ports';
 
  CREATE TABLE `equipment_snmp_tpl` (
    `model_id` smallint(6) unsigned NOT NULL DEFAULT '0',
    `section` varchar(50) NOT NULL DEFAULT '',
    `parameters` varchar(500) NOT NULL DEFAULT '',
    PRIMARY KEY (`model_id`,`section`)
  ) COMMENT='Equipment snmp template';
 
  CREATE TABLE `equipment_info` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `info_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    `nas_id` smallint(6) unsigned NOT NULL DEFAULT '0',
    `section` varchar(50) NOT NULL DEFAULT '',
    `result` varchar(500) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) COMMENT='Equipment info';
 
  CREATE TABLE maps_layers (
    `id`        SMALLINT(6) PRIMARY KEY AUTO_INCREMENT,
    `name`      VARCHAR(30) NOT NULL,
    `type`      VARCHAR(32) NOT NULL DEFAULT 'build',
    `structure` VARCHAR(32) NOT NULL    DEFAULT 'MARKER',
    `module`    VARCHAR(32) NOT NULL DEFAULT 'Maps',
    `clustering` TINYINT(1) NOT NULL DEFAULT 1,
    `comments` TEXT
  ) AUTO_INCREMENT = 100, COMMENT = 'Map layers';
 
  REPLACE INTO maps_layers (`id`, `name`, `structure`, `type` ) VALUES (1, '$lang{BUILD}', 'MARKER', 'build');
  REPLACE INTO maps_layers (`id`, `name`, `structure`, `type` ) VALUES (2, '$lang{WIFI}', 'MARKER_CIRCLE', 'wifi');
  REPLACE INTO maps_layers (`id`, `name`, `structure`, `type` ) VALUES (3, '$lang{ROUTE}', 'MARKERS_POLYLINE', 'route');
  REPLACE INTO maps_layers (`id`, `name`, `structure`, `type` ) VALUES (4, '$lang{WELL}', 'MARKER', 'well');
  REPLACE INTO maps_layers (`id`, `name`, `structure`, `type` ) VALUES (5, '$lang{TRAFFIC}', 'MARKER', 'build');
  REPLACE INTO maps_layers (`id`, `name`, `structure`, `type` ) VALUES (6, '$lang{CUSTOM_POINT}', 'MULTIPLE', 'custom');
 
  CREATE TABLE maps_circles (
    `id`       INT(11) unsigned PRIMARY KEY,
    `layer_id` SMALLINT(6) REFERENCES maps_layers (`id`)  ON DELETE CASCADE,
    `coord_id` INT(11) REFERENCES maps_coords (`id`),
    `radius`   DOUBLE  NOT NULL,
    `name`     VARCHAR(32) NOT NULL,
    `comments` TEXT
  ) COMMENT = 'Custom drawed circles';
 
  CREATE TABLE maps_polylines (
    `id`       INT(11) PRIMARY KEY  AUTO_INCREMENT,
    `layer_id` SMALLINT(6) REFERENCES maps_layers (`id`) ON DELETE CASCADE,
    `name`     VARCHAR(32) NOT NULL DEFAULT '',
    `comments` TEXT
  ) COMMENT = 'Custom drawed polylines';
 
  CREATE TABLE maps_polyline_points (
    `id`          INT(11) PRIMARY KEY AUTO_INCREMENT,
    `polyline_id` SMALLINT(6) REFERENCES maps_polylines (`id`) ON DELETE CASCADE,
    `coord_id`    INT(11) REFERENCES maps_coords (`id`)  ON DELETE CASCADE
  ) COMMENT = 'Custom drawed polyline points';
 
  CREATE TABLE maps_polygons (
    `id`       INT(11) PRIMARY KEY  AUTO_INCREMENT,
    `layer_id` SMALLINT(6) REFERENCES maps_layers (`id`)  ON DELETE CASCADE,
    `name`     VARCHAR(32) NOT NULL,
    `color`    VARCHAR(32) NOT NULL DEFAULT 'silver',
    `comments` TEXT
  ) COMMENT = 'Custom drawed polygons';
 
  CREATE TABLE maps_polygon_points (
    `id`         INT(11) PRIMARY KEY AUTO_INCREMENT,
    `polygon_id` SMALLINT(6) REFERENCES maps_polygons (`id`)  ON DELETE CASCADE,
    `coord_id`   INT(11) REFERENCES maps_coords (`id`)  ON DELETE CASCADE
  ) COMMENT = 'Custom drawed polygons points';
 
  CREATE TABLE maps_text (
    `id`       INT(11) PRIMARY KEY AUTO_INCREMENT,
    `layer_id` SMALLINT(6) REFERENCES maps_layers (`id`) ON DELETE CASCADE,
    `coord_id` INT(11) REFERENCES maps_coords (`id`) ON DELETE CASCADE,
    `text`     TEXT
  ) COMMENT = 'Custom drawed text';
 
  CREATE TABLE `maps_route_types` (
    `id`           SMALLINT(6) NOT NULL AUTO_INCREMENT PRIMARY KEY,
    `name`         VARCHAR(50) NOT NULL DEFAULT '',
    `color`        VARCHAR(7)  NOT NULL DEFAULT '#FFFFFF',
    `fibers_count` SMALLINT(6) NOT NULL DEFAULT 1,
    `comments`     TEXT,
    UNIQUE KEY (`name`)
  ) COMMENT = 'Route types';
 
  CREATE TABLE IF NOT EXISTS `maps_route_groups` (
    `id`   SMALLINT(6) NOT NULL AUTO_INCREMENT PRIMARY KEY,
    `name` VARCHAR(50) NOT NULL DEFAULT '',
    `comments` TEXT,
    `parent_id` SMALLINT(6) NOT NULL DEFAULT 0 REFERENCES `maps_route_groups` (`id`) ON DELETE RESTRICT
  ) COMMENT = 'Route groups';
  REPLACE INTO `maps_route_types` (`id`, `name`, `color`) VALUES (1, '$lang{COAXIAL}',  '#FF0000');
  REPLACE INTO `maps_route_types` (`id`, `name`, `color`) VALUES (2, '$lang{FIBER_OPTIC}',  '#000000');
  REPLACE INTO `maps_route_types` (`id`, `name`, `color`) VALUES (3, '$lang{TWISTED_PAIR}',  '#0000FF');
 
  ALTER TABLE maps_routes ADD COLUMN `parent_id` INT(10) UNSIGNED NOT NULL DEFAULT 0 REFERENCES `maps_routes` (`id`);
  ALTER TABLE maps_routes MODIFY COLUMN `type` SMALLINT(6) UNSIGNED NOT NULL DEFAULT 0;
  ALTER TABLE maps_routes ADD COLUMN `group_id`  SMALLINT(6) NOT NULL DEFAULT 0 REFERENCES `maps_route_groups` (`id`) ON DELETE RESTRICT;
 
  CREATE TABLE `maps_route_types` (
    `id`           SMALLINT(6) NOT NULL AUTO_INCREMENT PRIMARY KEY,
    `name`         VARCHAR(50) NOT NULL DEFAULT '',
    `color`        VARCHAR(7)  NOT NULL DEFAULT '#FFFFFF',
    `fibers_count` SMALLINT(6) NOT NULL DEFAULT 1,
    `comments`     TEXT,
    UNIQUE KEY (`name`)
  ) COMMENT = 'Route types';
 
  CREATE TABLE IF NOT EXISTS `maps_route_groups` (
    `id`   SMALLINT(6) NOT NULL AUTO_INCREMENT PRIMARY KEY,
    `name` VARCHAR(50) NOT NULL DEFAULT '',
    `comments` TEXT,
    `parent_id` SMALLINT(6) NOT NULL DEFAULT 0 REFERENCES `maps_route_groups` (`id`) ON DELETE RESTRICT
  ) COMMENT = 'Route groups';
 
  REPLACE INTO `maps_route_types` (`id`, `name`, `color`) VALUES (1, '$lang{COAXIAL}',  '#FF0000');
  REPLACE INTO `maps_route_types` (`id`, `name`, `color`) VALUES (2, '$lang{FIBER_OPTIC}',  '#000000');
  REPLACE INTO `maps_route_types` (`id`, `name`, `color`) VALUES (3, '$lang{TWISTED_PAIR}',  '#0000FF');
 
  ALTER TABLE maps_routes ADD COLUMN `parent_id` INT(10) UNSIGNED NOT NULL DEFAULT 0 REFERENCES `maps_routes` (`id`);
  ALTER TABLE maps_routes MODIFY COLUMN `type` SMALLINT(6) UNSIGNED NOT NULL DEFAULT 0;
  ALTER TABLE maps_routes ADD COLUMN `group_id`  SMALLINT(6) NOT NULL DEFAULT 0 REFERENCES `maps_route_groups` (`id`) ON DELETE RESTRICT;

0.74

При переходе с 0.7х на 0.74 обязательно пересоздайте шаблоны и проверьте неофициальные модули

26.08.2016

MySQL

  ALTER TABLE `ippools` ADD COLUMN `netmask` int(11) unsigned NOT NULL default '4294967295';
  ALTER TABLE `ippools` ADD COLUMN `dns` varchar(32) NOT NULL default '';
  ALTER TABLE `ippools` ADD COLUMN `ntp` varchar(80) NOT NULL default '';
  ALTER TABLE `ippools` ADD COLUMN `gateway` int(11) unsigned NOT NULL default '0';

15.08.2016

MySQL

  ALTER TABLE `dhcphosts_leases` ADD COLUMN `dhcp_id` tinyint(2) NOT NULL DEFAULT '0';
  ALTER TABLE builds ADD COLUMN `public_comments` text;
  SET foreign_key_checks = 0;
 
  CREATE TABLE `events_group` (
    id      SMALLINT(6) UNSIGNED AUTO_INCREMENT,
    name    VARCHAR(40) NOT NULL,
    modules TEXT NOT NULL,
    PRIMARY KEY `event_groups_id` (`id`),
    UNIQUE `event_group_name` (`name`)
  ) COMMENT 'Events privacy settings';
 
  ALTER TABLE events ADD COLUMN group_id SMALLINT(6) UNSIGNED NOT NULL DEFAULT 0;
  ALTER TABLE events ADD FOREIGN KEY (`group_id`) REFERENCES events_group(`id`) ON DELETE RESTRICT;
  SET foreign_key_checks = 1;

25.07.2016

MySQL

  ALTER TABLE `ureports_tp_reports` ADD COLUMN `comments` text;
  ALTER TABLE `ureports_tp_reports` ADD COLUMN `module` VARCHAR(32) NOT NULL DEFAULT '';
  ALTER TABLE `ureports_tp_reports` ADD COLUMN `visual` tinyint(1) UNSIGNED NOT NULL DEFAULT '0';
  ALTER TABLE `service_status` change name `name` varchar(40) NOT NULL DEFAULT '';
  REPLACE INTO service_status (id, name, color, type) VALUES (0, '$lang{ENABLE}', '4CAF50', 0);
  REPLACE INTO service_status (id, name, color, type) VALUES (1, '$lang{DISABLE}', 'F44336', 0);
  REPLACE INTO service_status (id, name, color, type) VALUES (2, '$lang{NOT_ACTIVE}', 'FF9800', 0);
  REPLACE INTO service_status (id, name, color, type) VALUES (3, '$lang{HOLD_UP}', '2196F3', 0);
  REPLACE INTO service_status (id, name, color, type) VALUES (4, '$lang{DISABLE} $lang{NON_PAYMENT}', '607D8B', 0);
  REPLACE INTO service_status (id, name, color, type) VALUES (5, '$lang{ERR_SMALL_DEPOSIT}', '009688', 0);
  REPLACE INTO service_status (id, name, color, type) VALUES (6, '$lang{VIRUS_ALERT}', '9C27B0', 0);
  REPLACE INTO service_status (id, name, color, type) VALUES (7, '$lang{REPAIR}', '9E9E9E', 0);

16.07.2016

16.06.2016

MySQL

  CREATE TABLE users_contact_types
  (
    id         SMALLINT(6) PRIMARY KEY NOT NULL AUTO_INCREMENT,
    name       VARCHAR(30)             NOT NULL,
    is_default TINYINT(1)              NOT NULL DEFAULT 0,
    hidden     TINYINT(1)              NOT NULL DEFAULT 0
  )  COMMENT = 'Types of user contacts';
 
  REPLACE INTO users_contact_types (id, name, is_default, hidden) VALUES
  (1, 'CELL_PHONE', 0, 0),
  (2, 'PHONE', 1, 0),
  (3, 'Skype', 0, 0),
  (4, 'ICQ', 0, 0),
  (5, 'Viber', 0, 0),
  (6, 'Telegram', 0, 0),
  (7, 'Facebook', 0, 0),
  (8, 'VK', 0, 0),
  (9, 'EMail', 1, 0),
  (10, 'Google push', 0, 1);
 
  CREATE TABLE users_contacts
  (
  id       INT(11) UNSIGNED PRIMARY KEY AUTO_INCREMENT,
  uid      INT(11) UNSIGNED NOT NULL REFERENCES users (`uid`) ON DELETE CASCADE,
  type_id  SMALLINT(6) REFERENCES users_contact_types (`id`)  ON DELETE CASCADE,
  value    VARCHAR(250)     NOT NULL,
  priority SMALLINT(6) UNSIGNED,
  CONSTRAINT `_type_value` UNIQUE (`type_id`, `value`),
  INDEX `_uid_contact` (`uid`)
  )  COMMENT = 'Main user contacts table';
 
  DROP TABLE `paysys_main`;
  CREATE TABLE `paysys_main` (
    `uid`         int(11) unsigned NOT NULL default '0',
    `token`       tinytext,
    `sum`         double(10,2) NOT NULL default '0.00',
    `date`        date NOT NULL default '0000-00-00',
    `paysys_id`   smallint(5) unsigned NOT NULL default '0',
    `external_last_date` datetime NOT NULL default '0000-00-00 00:00:00',
    `attempts`    smallint(2) NOT NULL default 0,
    `closed`      smallint(1) NOT NULL DEFAULT 0,
    UNIQUE  (`uid`,`paysys_id`)
  ) COMMENT="Paysys user account";

0.73

25.04.2016

MySQL

  ALTER TABLE portal_articles ADD `tags`              smallint(4)      NOT NULL DEFAULT 0;

04.04.2016

MySQL

  ALTER TABLE dv_main ADD personal_tp double(14,2) unsigned NOT NULL DEFAULT '0.00';
 
  CREATE TABLE maps_coords (
    `id`       INT(11) PRIMARY KEY AUTO_INCREMENT,
    `coordx`   DOUBLE NOT NULL,
    `coordy`   DOUBLE NOT NULL,
    `altitude` DOUBLE NOT NULL DEFAULT 0.0
  )
  COMMENT 'Location data';
 
  CREATE TABLE maps_point_types (
    `id`       SMALLINT(6) PRIMARY KEY AUTO_INCREMENT,
    `name`     VARCHAR(60) NOT NULL UNIQUE,
    `icon`     VARCHAR(30) NOT NULL    DEFAULT 'default',
    `comments` TEXT
  )
  COMMENT 'Types of custom points';
 
  CREATE TABLE maps_points (
    `id`       INT(11) PRIMARY KEY AUTO_INCREMENT,
    `name`     VARCHAR(30) NOT NULL,
    `coord_id` INT(11) REFERENCES maps_coords (`id`)           ON DELETE CASCADE,
    `type_id`  SMALLINT(6) REFERENCES maps_point_types (`id`)  ON DELETE RESTRICT,
    `comments` TEXT
  )
  COMMENT 'Custom points';

15.03.2016

MySQL

  ALTER TABLE streets ADD second_name VARCHAR(50) NOT NULL DEFAULT '';
 
  CREATE TABLE `notepad_reminders` (
  `id`        INT(11) UNSIGNED NOT NULL REFERENCES `notepad` (`id`) ON DELETE CASCADE,
  `minute`    SMALLINT(2)      NOT NULL  DEFAULT '0',
  `hour`      SMALLINT(2)      NOT NULL  DEFAULT '0',
  `week_day`  SMALLINT(2)      NOT NULL  DEFAULT '0',
  `month_day` VARCHAR(30)      NOT NULL  DEFAULT '0',
  `month`     SMALLINT(2)      NOT NULL  DEFAULT '0',
  `year`      SMALLINT(6)      NOT NULL  DEFAULT '0',
  `holidays`  TINYINT(1)       NOT NULL  DEFAULT '0'
  )
  COMMENT = 'Periodic reminders';

01.03.2016

MySQL

  ALTER TABLE admins ADD position SMALLINT UNSIGNED NOT NULL DEFAULT 0 AFTER name;
 
  CREATE TABLE `equipment_extra_ports` (
  `model_id` SMALLINT UNSIGNED NOT NULL,
  `port_number` SMALLINT UNSIGNED NOT NULL,
  `port_type` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
  `state` TINYINT UNSIGNED NOT NULL DEFAULT '0',
  `row` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY `model_port` (`model_id`, `port_number`)
  ) COMMENT = 'Table for extra ports for equipment models';
  START TRANSACTION;
  INSERT INTO `equipment_extra_ports` (model_id, port_number, port_type)
  SELECT `id`, 1, `extra_port1`
  FROM `equipment_models`;
  INSERT INTO `equipment_extra_ports` (model_id, port_number, port_type)
  SELECT
  `id`, 2, `extra_port2`
  FROM `equipment_models`;
  INSERT INTO `equipment_extra_ports` (model_id, port_number, port_type)
  SELECT
  `id`, 3, `extra_port3`
  FROM `equipment_models`;
  INSERT INTO `equipment_extra_ports` (model_id, port_number, port_type)
  SELECT
  `id`, 4, `extra_port4`
  FROM `equipment_models`;
 
  UPDATE `equipment_extra_ports` SET row=1 WHERE port_number>2;
 
  ALTER TABLE `equipment_models` DROP COLUMN `extra_port1`;
  ALTER TABLE `equipment_models` DROP COLUMN `extra_port2`;
  ALTER TABLE `equipment_models` DROP COLUMN `extra_port3`;
  ALTER TABLE `equipment_models` DROP COLUMN `extra_port4`;
 
  COMMIT;

02.02.2016

MySQL

  CREATE TABLE `radtest_history` (
    `id` smallint UNSIGNED NOT NULL AUTO_INCREMENT,
    `datetime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
    `rad_query` TEXT NOT NULL,
    `comments` TEXT NOT NULL,
    PRIMARY KEY (`id`)
  ) COMMENT='Radtest history';
 
  CREATE TABLE `reports_groups` (
    `id` smallint unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(40) NOT NULL DEFAULT '',
    `comments` text NOT NULL,
    PRIMARY KEY (`id`)
  ) COMMENT='Reports Groups';
 
  ALTER TABLE `reports_wizard` ADD COLUMN `gid` smallint unsigned NOT NULL DEFAULT 0;

18.01.2016

MySQL

  ALTER TABLE `web_users_sessions` ADD COLUMN `coordx` DOUBLE(20,14) NOT NULL DEFAULT '0';
  ALTER TABLE `web_users_sessions` ADD COLUMN `coordy` DOUBLE(20,14) NOT NULL DEFAULT '0';
 
  CREATE TABLE `billd_plugins` (
    `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
    `plugin_name` varchar(100) NOT NULL DEFAULT '',
    `status` tinyint(1) unsigned NOT NULL DEFAULT '0',
    `threads` tinyint(1) unsigned NOT NULL DEFAULT '0',
    `make_lock` tinyint(1) unsigned NOT NULL DEFAULT '0',
    `period` int(10) unsigned NOT NULL DEFAULT '0',
    `priority` tinyint(1) unsigned NOT NULL DEFAULT '0',
    `last_execute` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    `last_status` tinyint(1) unsigned NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    UNIQUE KEY `plugin_name` (`plugin_name`)
  ) COMMENT='billd plugin orginizer';
 
  CREATE TABLE `paysys_terminals` (
    `id`          int(11) unsigned NOT NULL auto_increment,
    `type`        smallint(2) unsigned NOT NULL DEFAULT 0,
    `status`      smallint(1) unsigned NOT NULL DEFAULT 0,
    `location_id` int(11) unsigned NOT NULL DEFAULT 0,
    `comment`     text,
    UNIQUE KEY `id` (`id`)
  ) COMMENT="Table for paysys terminals";
 
  CREATE TABLE `service_status` (
    `id` tinyint(2) unsigned NOT NULL DEFAULT '0',
    `name` varchar(20) NOT NULL DEFAULT '',
    `color` varchar(6) NOT NULL DEFAULT '',
    `type` tinyint(1) unsigned NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    UNIQUE KEY `name` (`name`)
  ) COMMENT='System service status list';
 
  REPLACE INTO service_status (id, name, color, type) VALUES (0, '$_ENABLE', '4CAF50', 0);
  REPLACE INTO service_status (id, name, color, type) VALUES (1, '$_DISABLE', 'F44336', 0);
  REPLACE INTO service_status (id, name, color, type) VALUES (2, '$_NOT_ACTIVE', 'FF9800', 0);
  REPLACE INTO service_status (id, name, color, type) VALUES (3, '$_HOLD_UP', '2196F3', 0);
  REPLACE INTO service_status (id, name, color, type) VALUES (4, '$_DISABLE:$_NON_PAY', '607D8B', 0);
  REPLACE INTO service_status (id, name, color, type) VALUES (5, '$ERR_SMALL_DEPOSIT', '009688', 0);
  REPLACE INTO service_status (id, name, color, type) VALUES (6, '$_VIRUS_ALERT', '9C27B0', 0);
  REPLACE INTO service_status (id, name, color, type) VALUES (7, '$_REPAIR', '9E9E9E', 0);
 
  ALTER TABLE portal_articles ADD end_date DATETIME DEFAULT NULL;
  ALTER TABLE portal_articles ADD archive tinyint(1) NOT NULL DEFAULT 0;
  ALTER TABLE portal_articles ADD importance tinyint(1) NOT NULL DEFAULT 0;
  ALTER TABLE portal_articles ADD gid smallint(4) unsigned NOT NULL DEFAULT 0;
  ALTER TABLE portal_articles ADD district_id smallint(6) unsigned NOT NULL DEFAULT 0;
  ALTER TABLE portal_articles ADD street_id smallint(6) unsigned NOT NULL DEFAULT 0;
 
  ALTER TABLE `iptv_channels` ADD COLUMN `genre_id`  tinyint(1) unsigned NOT NULL DEFAULT '0';
  ALTER TABLE `iptv_channels` ADD COLUMN `stream` varchar(150) NOT NULL default '';
  ALTER TABLE `iptv_channels` ADD COLUMN `state`  tinyint(1) unsigned NOT NULL DEFAULT '0';
  ALTER TABLE `netlist_groups` ADD COLUMN `parent_id` smallint(6) unsigned NOT NULL DEFAULT 0;

0.72

24.12.2015

MySQL

  ALTER TABLE `equipment_models` ADD COLUMN `extra_port1` SMALLINT UNSIGNED DEFAULT 0;
  ALTER TABLE `equipment_models` ADD COLUMN `extra_port2` SMALLINT UNSIGNED DEFAULT 0;
  ALTER TABLE `equipment_models` ADD COLUMN `extra_port3` SMALLINT UNSIGNED DEFAULT 0;
  ALTER TABLE `equipment_models` ADD COLUMN `extra_port4` SMALLINT UNSIGNED DEFAULT 0;
  ALTER TABLE `equipment_models` MODIFY COLUMN `rows_count` INT UNSIGNED NOT NULL DEFAULT 1;
  ALTER TABLE `equipment_models` ADD COLUMN `ports_type` SMALLINT UNSIGNED DEFAULT 1;
 
  ALTER TABLE `admins` ADD COLUMN `gps_imei` varchar(15) NOT NULL default '';
  ALTER TABLE `admins` ADD COLUMN `start_work` DATE NOT NULL default '0000-00-00';
  ALTER TABLE `holidays` ADD file char(50) NOT NULL default '' AFTER day;

15.12.2015

MySQL

  ALTER TABLE `netlist_ips` ADD COLUMN `ipv6` varbinary(16) NULL DEFAULT 0;
  ALTER TABLE `netlist_ips` ADD COLUMN `ipv6_prefix` int(3) NULL;
  ALTER TABLE `netlist_ips` ADD COLUMN `ip_id` int(11) unsigned NULL;
  UPDATE `netlist_ips` SET `ip_id`=NULL WHERE `ip_id`=0;
  SET @a  = 0 ;
  UPDATE `netlist_ips` SET ip_id = @a:=@a+1 WHERE ip_id IS NULL;
  ALTER TABLE `netlist_ips` DROP PRIMARY KEY;
  ALTER TABLE `netlist_ips` DROP KEY `ip`;
  ALTER TABLE `netlist_ips` ADD CONSTRAINT PRIMARY KEY `ip_id` (`ip_id`);
  ALTER TABLE `netlist_ips` ADD CONSTRAINT UNIQUE `_key_ip_ipv6` (`ip`, `ipv6`);
  ALTER TABLE `netlist_ips` MODIFY COLUMN `ip_id` int(11) unsigned NOT NULL AUTO_INCREMENT;
  ALTER TABLE `netlist_ips` ADD CHECK (ip <> 0 OR ipv6 <> 0);
  ALTER TABLE `netlist_ips` ADD CHECK (netmask <> 0 OR ipv6_prefix <> 0);
 
  CREATE TABLE `voip_ivr_menu` (
    `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
    `main_id` smallint(5) unsigned NOT NULL DEFAULT '0',
    `number` smallint(5) unsigned NOT NULL DEFAULT '0',
    `name` varchar(100) NOT NULL DEFAULT '',
    `comments` text,
    `disable` tinyint(3) unsigned NOT NULL DEFAULT '0',
    `function` varchar(100) NOT NULL DEFAULT '',
    `domain_id` smallint(5) unsigned NOT NULL DEFAULT '0',
    `audio_file` varchar(200) NOT NULL DEFAULT '',
    PRIMARY KEY (`id`),
    UNIQUE KEY `name` (`name`)
  ) COMMENT='Voip IVR Menu';
  ALTER TABLE `equipment_models` ADD COLUMN `rows_count` int(11) UNSIGNED NULL DEFAULT 0;
  ALTER TABLE `equipment_models` ADD COLUMN `block_size` int(11) UNSIGNED NULL DEFAULT 0;
  ALTER TABLE `equipment_models` ADD COLUMN `port_numbering` TINYINT(1) UNSIGNED DEFAULT 0 COMMENT 'FALSE is ROWS, TRUE is COLUMNS';
  ALTER TABLE `equipment_models` ADD COLUMN `first_position` TINYINT(1) UNSIGNED DEFAULT 0 COMMENT 'FALSE is UP, TRUE is DOWN';

26.11.2015

MySQL

  ALTER TABLE abon_tariffs ADD COLUMN `service_link` VARCHAR(240) NOT NULL DEFAULT '';
  ALTER TABLE netlist_ips ADD COLUMN `mac` varchar(17) not null default 0;
  ALTER TABLE netlist_ips ADD COLUMN  `mac_auto_detect` tinyint(1) unsigned NOT NULL default '0';
  ALTER TABLE admins ADD COLUMN `api_key` varchar(100) NOT NULL default '';
  ALTER TABLE paysys_log ADD user_info varchar(200) NOT NULL default '';
 
  CREATE TABLE `admin_slides` (
    `slide_name` varchar(30) NOT NULL DEFAULT '',
    `field_id` varchar(30) NOT NULL DEFAULT '',
    `field_warning` varchar(130) NOT NULL DEFAULT '',
    `field_comments` varchar(200) NOT NULL DEFAULT '',
    `priority` tinyint(2) unsigned NOT NULL DEFAULT '0',
    `size` tinyint(2) unsigned NOT NULL DEFAULT '0',
    `aid` smallint(6) unsigned NOT NULL DEFAULT '0',
    `color` varchar(6) NOT NULL DEFAULT '',
    UNIQUE KEY `aid` (`aid`,`slide_name`,`field_id`)
  ) COMMENT='Admin slides';

10.11.2015

MySQL

  CREATE TABLE `iptv_screens` (
    `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
    `tp_id` smallint(6) unsigned NOT NULL DEFAULT '0',
    `num` tinyint(1) unsigned NOT NULL DEFAULT '0',
    `filter_id` varchar(60) NOT NULL DEFAULT '',
    `name` varchar(60) NOT NULL DEFAULT '',
    `month_fee` double(15,5) unsigned NOT NULL DEFAULT '0.00000',
    `day_fee` double(15,5) unsigned NOT NULL DEFAULT '0.00000',
    PRIMARY KEY (`id`),
    UNIQUE KEY `tp_id` (`tp_id`,`num`)
  ) COMMENT='IPTV Extra screens';
 
  CREATE TABLE `iptv_users_screens` (
    `service_id` int(10) unsigned NOT NULL DEFAULT '0',
    `screen_id` smallint(6) unsigned NOT NULL DEFAULT '0',
    `date` date NOT NULL DEFAULT '0000-00-00',
    `cid` varchar(60) NOT NULL DEFAULT '',
    `serial` varchar(60) NOT NULL DEFAULT '',
    `hardware_id` int(10) unsigned NOT NULL DEFAULT '0',
    UNIQUE KEY `service_id` (`service_id`,`screen_id`)
  ) COMMENT='IPTV Extra screens';

03.11.2015

MySQL

  CREATE TABLE `paysys_main` (
    `uid` int(11) unsigned NOT NULL default '0',
    `token` tinytext,
    `sum` double(10,2) NOT NULL default '0.00',
    `date` date NOT NULL default '0000-00-00',
    `paysys_id` smallint(5) unsigned NOT NULL default '0',
    UNIQUE KEY `uid` (`uid`,`paysys_id`)
  ) COMMENT="Paysys user account";

28.09.2015

MySQL

  ALTER TABLE `dv_main` ADD COLUMN  `detail_stats` tinyint(1) unsigned NOT NULL default '0';

22.09.2015

MySQL

  ALTER TABLE `msgs_attachments` ADD COLUMN `coordx` DOUBLE(20,14) NOT NULL DEFAULT '0';
  ALTER TABLE `msgs_attachments` ADD COLUMN `coordy` DOUBLE(20,14) NOT NULL DEFAULT '0';
 
  CREATE TABLE `msgs_proggress_bar` (
    `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
    `chapter_id` smallint(5) unsigned NOT NULL DEFAULT '0',
    `step_num` tinyint(3) unsigned NOT NULL DEFAULT '0',
    `step_name` varchar(100) NOT NULL DEFAULT '',
    `step_tip` text NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `chapter_id_name` (`chapter_id`,`step_num`)
  ) COMMENT='Messages progress bar';
 
  CREATE TABLE `msgs_message_pb` (
    `main_msg` int(11) unsigned NOT NULL DEFAULT 0,
    `step_num` tinyint(3) unsigned NOT NULL DEFAULT '0',
    `step_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    `coordx` DOUBLE(20,14) NOT NULL DEFAULT '0',
    `coordy` DOUBLE(20,14) NOT NULL DEFAULT '0',
    `aid` smallint unsigned NOT NULL DEFAULT 0,
    KEY (`main_msg`),
    UNIQUE KEY `msg_step` (`main_msg`, `step_num`)
  ) COMMENT='Messages message progress bar';
 
  CREATE TABLE `msgs_watch` (
    `main_msg` int(11) unsigned NOT NULL DEFAULT 0,
    `aid` smallint unsigned NOT NULL DEFAULT 0,
    `add_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    KEY (`main_msg`),
    UNIQUE KEY `msg_aid` (`aid`, `main_msg`)
  ) COMMENT="Message watch";

16.09.2015

MySQL

  ALTER TABLE `iptv_channels` ADD COLUMN `filter_id` varchar(100) NOT NULL default '';
 

04.09.2015

MySQL

  ALTER TABLE `iptv_users_channels` ADD COLUMN `id` INTEGER(10) UNSIGNED NOT NULL DEFAULT '0';
  ALTER TABLE `iptv_users_channels` DROP KEY `uid`;
  ALTER TABLE `iptv_users_channels` ADD KEY `id` (`id`, `channel_id`, `tp_id`);
  ALTER TABLE msgs_survey_subjects  ADD COLUMN  `tpl` text NOT NULL;
  ALTER TABLE msgs_survey_subjects  ADD COLUMN  `filename` varchar(250) NOT NULL DEFAULT '';
  ALTER TABLE msgs_survey_subjects  ADD COLUMN  `file_size` varchar(30) NOT NULL DEFAULT '';
  ALTER TABLE msgs_survey_subjects  ADD COLUMN  `file_content_type` varchar(250) NOT NULL DEFAULT '';
  ALTER TABLE msgs_survey_subjects  ADD COLUMN  `file_contents` longblob NOT NULL;
  ALTER TABLE msgs_survey_subjects  ADD COLUMN  `msg_type` tinyint(1) NOT NULL DEFAULT 0;
  ALTER TABLE msgs_survey_subjects  ADD COLUMN  `status` tinyint(1) NOT NULL DEFAULT 0;
  ALTER TABLE dhcphosts_leases CHANGE COLUMN `port` `port` varchar(11) NOT NULL DEFAULT '';
  ALTER TABLE `shedule` CHANGE COLUMN `action` `action` text NOT NULL;

0.71

24.08.2015

12.08.2015

MySQL

  ALTER TABLE docs_invoice_orders ADD KEY `fees_id` (`fees_id`);
  ALTER TABLE docs_receipt_orders ADD KEY `fees_id` (`fees_id`);
  ALTER TABLE `iptv_main` ADD COLUMN `email` varchar(100) NOT NULL default '';
  CREATE TABLE `location_media` (
    `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
    `location_id` int(11) unsigned NOT NULL DEFAULT '0',
    `comments` varchar(200) NOT NULL DEFAULT '',
    `filename` varchar(250) NOT NULL DEFAULT '',
    `content_size` varchar(30) NOT NULL DEFAULT '',
    `content_type` varchar(250) NOT NULL DEFAULT '',
    `content` longblob NOT NULL,
    `create_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    PRIMARY KEY (`id`)
  ) COMMENT='Location media';

20.07.2015

MySQL

  ALTER TABLE `trafic_tarifs` ADD COLUMN `burst_limit_dl` smallint unsigned not null default 0;
  ALTER TABLE `trafic_tarifs` ADD COLUMN `burst_limit_ul` smallint unsigned not null default 0;
  ALTER TABLE `trafic_tarifs` ADD COLUMN `burst_threshold_dl` smallint unsigned not null default 0;
  ALTER TABLE `trafic_tarifs` ADD COLUMN `burst_threshold_ul` smallint unsigned not null default 0;
  ALTER TABLE `trafic_tarifs` ADD COLUMN `burst_time_dl` smallint unsigned not null default 0;
  ALTER TABLE `trafic_tarifs` ADD COLUMN `burst_time_ul` smallint unsigned not null default 0;
  ALTER TABLE `dv_main` ADD COLUMN  `traf_detail` smallint(1) unsigned NOT NULL default '0';
  ALTER TABLE `msgs_survey_subjects` CHANGE `name` `name` varchar(60) NOT NULL DEFAULT '';
  ALTER TABLE `msgs_dispatch` CHANGE `plan_date` `plan_date` DATE NOT NULL DEFAULT '0000-00-00';
  ALTER TABLE `msgs_dispatch` CHANGE `closed_date` `closed_date` DATE NOT NULL DEFAULT '0000-00-00';
  ALTER TABLE `msgs_dispatch` CHANGE `resposible` `resposible` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0';
  ALTER TABLE `msgs_unreg_requests` CHANGE `closed_date` `closed_date` DATE NOT NULL DEFAULT '0000-00-00';
  ALTER TABLE `msgs_unreg_requests` CHANGE `connection_time` `connection_time` DATETIME NOT NULL DEFAULT '0000-00-00';
  ALTER TABLE `tags` ADD COLUMN   `priority` tinyint(4) unsigned NOT NULL default '0';

14.07.2015

MySQL

  ALTER TABLE equipment_models ADD COLUMN snmp_tpl varchar(50) NOT NULL default '';
 

02.06.2015

MySQL

  ALTER TABLE admins ADD COLUMN `full_log` tinyint(1) unsigned NOT NULL DEFAULT '0';
 
  CREATE TABLE `admins_full_log` (
    `function_index` smallint(5) unsigned NOT NULL DEFAULT '0',
    `aid` smallint(6) unsigned NOT NULL DEFAULT '0',
    `function_name` varchar(32) NOT NULL DEFAULT '',
    `datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    `ip` int unsigned not null default 0,
    `sid` varchar(32) NOT NULL default '',
    `params` text,
    KEY `aid` (`aid`)
  ) COMMENT='Admin full log';

18.05.2015

21.04.2015

MySQL

  CREATE TABLE `admins_access` (
    `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
    `aid` smallint(6) unsigned NOT NULL DEFAULT '0',
    `begin` time NOT NULL DEFAULT '00:00:00',
    `end` time NOT NULL DEFAULT '00:00:00',
    `day` tinyint(4) unsigned DEFAULT '0',
    `ip` int(11) unsigned NOT NULL DEFAULT '0',
    `bit_mask` tinyint(1) unsigned NOT NULL DEFAULT '0',
    `comments` text NOT NULL,
    `disable` tinyint(1) unsigned NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`)
  ) COMMENT='Admin access';

21.04.2015

23.03.2015

MySQL

  alter table iptv_main ADD COLUMN `subscribe_id` int(11) unsigned NOT NULL default 0;
 
  CREATE TABLE `iptv_subscribes` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `status` tinyint(3) unsigned NOT NULL DEFAULT '0',
    `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    `ext_id` varchar(20) NOT NULL DEFAULT '',
    `tp_id` smallint(5) unsigned NOT NULL DEFAULT '0',
    `expire` date NOT NULL DEFAULT '0000-00-00',
    `password` blob NOT NULL,
    PRIMARY KEY (`id`),
    KEY `ext_id` (`ext_id`)
  )  COMMENT='IPTV Subscribes';

03.03.2015

MySQL

  ALTER TABLE msgs_unreg_requests CHANGE responsible_admin resposible SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0';
  ALTER TABLE `iptv_main` DROP PRIMARY KEY;
  ALTER TABLE `iptv_main` ADD COLUMN `id` int(11) unsigned NOT NULL auto_increment primary key;

0.70

23.01.2014

MySQL

  UPDATE nas SET ip=INET_ATON(ip) WHERE INET_ATON(ip);
  ALTER TABLE nas change COLUMN ip ip int unsigned not null default 0;
  ALTER TABLE tarif_plans ADD COLUMN `user_credit_limit` double(10,2) unsigned NOT NULL DEFAULT '0.00';
  CREATE TABLE `admins_time_sheet` (
  `aid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `date` date NOT NULL DEFAULT '0000-00-00',
  `work_time` tinyint(2) NOT NULL DEFAULT '0',
  `overtime` tinyint(2) NOT NULL DEFAULT '0',
  `extra_fee` tinyint(2) NOT NULL DEFAULT '0',
  `day_type` tinyint(2) NOT NULL DEFAULT '0',
  UNIQUE KEY `aid_date` (`aid`,`date`)
  ) COMMENT='Admins time sheet';