12345678910111213141516171819 |
- -- 20240703,发布现场,以后sql表变动记录
- base.t_fzss_hgxfx 表添加字段了,需重新建表
- ALTER TABLE "base"."t_fzss_fzxz" ADD COLUMN "is_delete" bool;
- COMMENT ON COLUMN "base"."t_fzss_fzxz"."is_delete" IS '是否删除';
- UPDATE t_fzss_fzxz SET is_delete=FALSE;
- --修改坐标系
- update vector."TB_TDGY_SJ" set geom= st_setsrid(geom,4326)
- -- vector新增表
- t_table
- t_table_conversion
- t_table_filed
- t_table_filed_relation
- t_table_inside_outside
- t_table_res_rule
- t_table_res_tabel
|