| | |
|---|
| | | ALTER TABLE stream_proxy ADD status bit(1) not null; |
|---|
| | | alter table wvp.media_server |
|---|
| | | drop column streamNoneReaderDelayMS; |
|---|
| | | |
|---|
| | | # 去除子查询优化查询速度 |
|---|
| | | alter table device_channel |
|---|
| | | add subCount int default 0 null; |
|---|
| | | alter table stream_proxy |
|---|
| | | add enable_disable_none_reader bit(1) default null; |
|---|
| | | |
|---|
| | | update device_channel dc set dc.subCount = (select te.count from (SELECT count(0) as count FROM device_channel WHERE parentId = dc.channelId) te) |
|---|
| | | alter table device |
|---|
| | | add mediaServerId varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'auto'; |
|---|
