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)

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

-- vector新增表
-- 生成火葬场图斑
CREATE TABLE "TB_HZC" as SELECT * FROM "TB_GHDK" WHERE lbdm like '%1506%';