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

0.80

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