sanya-data-management-back/sql/pgsql/0_init.sql

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