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


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

0.80

05.02.2019

MySQL

ALTER TABLE `cams_streams` ADD COLUMN `type` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0;
 
ALTER TABLE `msgs_dispatch` ADD COLUMN `created_by` SMALLINT(1) UNSIGNED NOT NULL DEFAULT 0;
ALTER TABLE `msgs_dispatch` ADD COLUMN `start_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00';
ALTER TABLE `msgs_dispatch` ADD COLUMN `end_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00';
ALTER TABLE `msgs_dispatch` ADD COLUMN `actual_end_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00';
ALTER TABLE `msgs_dispatch_admins` ADD FOREIGN KEY (`dispatch_id`) REFERENCES `msgs_dispatch`(`id`) ON DELETE CASCADE;
 
CREATE TABLE `tp_geolocation`
(
  `tp_gid`       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
)
  COMMENT 'Geolocation of the tariff plan'
  ENGINE = InnoDB;
 
CREATE TABLE IF NOT EXISTS `employees_department` (
  `id` SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` char(60) NOT NULL DEFAULT '',
  `comments` TEXT,
  PRIMARY KEY (`id`)
)
  DEFAULT CHARSET = utf8
  COMMENT = 'Employees departments';
 
ALTER TABLE `admins` ADD COLUMN `department` SMALLINT(3) UNSIGNED NOT NULL DEFAULT '0';

10.01.2019

MySQL

CREATE TABLE IF NOT EXISTS `internet_users_pool` (
  `service_id`  SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
  `pool_id`   SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `comments`    VARCHAR(60) NOT NULL DEFAULT '',
  PRIMARY KEY (`service_id`)
)
  DEFAULT CHARSET = utf8
  COMMENT = 'Internet users ip pool';
 
CREATE TABLE IF NOT EXISTS `crm_bonus_types` (
  `id` SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` char(60) NOT NULL DEFAULT '',
  `amount` DOUBLE(6, 2) UNSIGNED NOT NULL DEFAULT '0.00',
  `comments` TEXT,
  PRIMARY KEY (`id`)
)
  DEFAULT CHARSET = utf8
  COMMENT = 'Bonust types for salaries';
 
CREATE TABLE IF NOT EXISTS `crm_salary_bonus` (
  `id` SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `aid` SMALLINT(6) UNSIGNED NOT NULL DEFAULT 0,
  `year` SMALLINT(4) UNSIGNED NOT NULL DEFAULT 0,
  `month` SMALLINT(2) UNSIGNED NOT NULL DEFAULT 0,
  `amount` DOUBLE(6, 2) UNSIGNED NOT NULL DEFAULT '0.00',
  `bonus_type_id` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
  `date` DATE NOT NULL DEFAULT '0000-00-00',
  PRIMARY KEY (`id`)
)
  DEFAULT CHARSET = utf8
  COMMENT = 'Bonust to salaries';
 
ALTER TABLE `ippools` MODIFY COLUMN `name` VARCHAR(50) NOT NULL DEFAULT '';
 
ALTER TABLE `cablecat_coil` ADD COLUMN `length` INT NOT NULL DEFAULT 30;
 
ALTER TABLE `cablecat_wells` MODIFY `name` VARCHAR(60) NOT NULL;
 
REPLACE INTO `admin_permits` (`aid`, `section`, `actions`) SELECT aid, 0, 28 FROM `admins` WHERE aid > 3;
REPLACE INTO `admin_permits` (`aid`, `section`, `actions`) SELECT aid, 0, 29 FROM `admins` WHERE aid > 3;
 
ALTER TABLE `crm_works` ADD COLUMN `work_done` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0';
 
ALTER TABLE `docs_invoice_orders` ADD COLUMN `type_fees_id` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0';

28.11.2018

13.11.2018

MySQL

ALTER TABLE internet_online CHANGE COLUMN acct_session_id acct_session_id varchar(36) NOT NULL DEFAULT '';
ALTER TABLE `msgs_chat` ADD COLUMN `reed` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE iptv_device RENAME TO iptv_devices;
 
ALTER TABLE `nas` ADD COLUMN `floor` VARCHAR(10) DEFAULT '' NOT NULL;
ALTER TABLE `nas` ADD COLUMN `entrance` VARCHAR(10) DEFAULT '' NOT NULL;
 
CREATE TABLE cablecat_coil (
  id int(11) unsigned NOT NULL AUTO_INCREMENT,
  name varchar(32) NOT NULL DEFAULT '',
  point_id int(11) unsigned NOT NULL DEFAULT 0,
  cable_id int(11) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Cablecat coil';
 
ALTER TABLE `notepad` MODIFY `text` TEXT;
ALTER TABLE msgs_chat CHANGE `reed` `msgs_unread` TINYINT(1);