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列表（没在此表填写的，都为饼图）';

-- ***选址因子表结构，数据同步
-- t_fzss_fzxz_factor

-- 7.17
-- 表同步
-- t_fzss_fzxz_factor_use