| | |
|---|
| | | ALTER TABLE stream_proxy ADD status bit(1) not null; |
|---|
| | | |
|---|
| | | # 去除子查询优化查询速度 |
|---|
| | | alter table stream_push |
|---|
| | | add serverId varchar(50) not null; |
|---|
| | | alter table device |
|---|
| | | add geoCoordSys varchar(50) not null; |
|---|
| | | update device set device.geoCoordSys='WGS84'; |
|---|
| | | alter table device_channel |
|---|
| | | add subCount int default 0 null; |
|---|
| | | add longitudeGcj02 double default null; |
|---|
| | | alter table device_channel |
|---|
| | | add latitudeGcj02 double default null; |
|---|
| | | alter table device_channel |
|---|
| | | add longitudeWgs84 double default null; |
|---|
| | | alter table device_channel |
|---|
| | | add latitudeWgs84 double 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) |
|---|
| | | |
|---|
| | | |
|---|
