| | |
|---|
| | | ALTER TABLE stream_proxy ADD status bit(1) not null; |
|---|
| | | alter table parent_platform |
|---|
| | | add startOfflinePush int default 0 null; |
|---|
| | | |
|---|
| | | # 去除子查询优化查询速度 |
|---|
| | | alter table device_channel |
|---|
| | | add subCount int default 0 null; |
|---|
| | | alter table parent_platform |
|---|
| | | add administrativeDivision varchar(50) not 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 parent_platform |
|---|
| | | add catalogGroup int default 1 null; |
|---|
| | | |
|---|
| | | alter table device |
|---|
| | | add ssrcCheck int default 0 null; |
|---|
| | | |
|---|
