From 944091a18721ccd38a7c583acf2a6c68fa457990 Mon Sep 17 00:00:00 2001 From: 13693261870 <252740454@qq.com> Date: 星期三, 16 十一月 2022 10:05:36 +0800 Subject: [PATCH] 1 --- data/db_tab.sql | 52 +++++++++++++++++++++++++++++++++++++++++++++++++++- 1 files changed, 51 insertions(+), 1 deletions(-) diff --git a/data/db_tab.sql b/data/db_tab.sql index c75b534..248e1b2 100644 --- a/data/db_tab.sql +++ b/data/db_tab.sql @@ -950,4 +950,54 @@ comment on column lf.sys_domain.bak is '澶囨敞'; select * from lf.sys_domain order by dom_name,orderid; ------------------------------------------------------------------------------------------------------ +----------------------------------------------------------------------------------------------------- 鍏冩暟鎹祴璇曡〃 * +-- drop table if exists md.md_zxcg; +create table md.md_zxcg( + id serial primary key, + zh varchar(50), + zj float8, + lc float8, + x float8, + y float8, + z float8, + pid integer, + create_user integer, + create_time timestamp(6) without time zone default now(), + update_user integer, + update_time timestamp(6) without time zone +); +comment on table md.md_zxcg is '涓嚎鎴愭灉琛�'; + +select * from md.md_zxcg; + +-- drop table if exists md.md_gdcg; +create table md.md_gdcg( + id serial primary key, + bh varchar(100), + gxdh varchar(100), + ljdh varchar(100), + msfs varchar(100), + gxcl varchar(100), + gjcc varchar(100), + tz varchar(100), + fsw varchar(100), + x float8, + y float8, + dm float8, + gd float8, + gnd float8, + ms float8, + dngs varchar(100), + gkpl varchar(100), + dldy varchar(100), + bz varchar(100), + pid integer, + create_user integer, + create_time timestamp(6) without time zone default now(), + update_user integer, + update_time timestamp(6) without time zone +); +comment on table md.md_gdcg is '绠¢亾鎴愭灉琛�'; + +select * from md.md_gdcg; +----------------------------------------------------------------------------------------------------- -- Gitblit v1.9.3