0_init.sql 504 B

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