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%';


-- t_fzss_fzxz 表添加字段了
ALTER TABLE "base"."t_fzss_fzxz" ADD COLUMN "is_multiple" varchar(50) COLLATE "pg_catalog"."default";

COMMENT ON COLUMN "base"."t_fzss_fzxz"."is_multiple" IS '是否允许多地块';

ALTER TABLE "base"."t_fzss_fzxz" ADD COLUMN "multiple_length" int4;

COMMENT ON COLUMN "base"."t_fzss_fzxz"."multiple_length" IS '多地块间最大距离';

ALTER TABLE "base"."t_fzss_fzxz" ADD COLUMN "is_ydxz" bool;

COMMENT ON COLUMN "base"."t_fzss_fzxz"."is_ydxz" IS '是否与控规用地性质一致';

ALTER TABLE "base"."t_fzss_fzxz" DROP COLUMN "kddk";


ALTER TABLE base.t_fzss_hgxfx_scx_sortation ADD "style" int2 NULL;
COMMENT ON COLUMN base.t_fzss_hgxfx_scx_sortation."style" IS '样式，0饼状 1列表（没在此表填写的，都为饼图）';