57 lines
2.3 KiB
SQL
57 lines
2.3 KiB
SQL
|
|
DELETE FROM FXKH_TXL.ORGANIZATION;
|
|
SET IDENTITY_INSERT FXKH_TXL.ORGANIZATION ON;
|
|
insert into "FXKH_TXL"."ORGANIZATION"("ID", "NAME") VALUES
|
|
('1','国家防汛抗旱总指挥部办公室' ),
|
|
('2','长江防汛抗旱总指挥部办公室' ),
|
|
('3','省防办' ),
|
|
('4','省防指成员单位' ),
|
|
('5','市、州、县防指（防办）' ),
|
|
('6','湖北省大型水库安全管理责任人' ),
|
|
('7','湖北省3级及以上河道堤防防汛行政责任人名单' ),
|
|
('8','湖北省蓄滞洪区防汛行政责任人名单' ),
|
|
('9','湖北省湖堤堤防防汛行政责任人名单' ),
|
|
('10','湖北省重点排涝泵站责任人名单' ),
|
|
('11','湖北省大中型涵闸防汛责任人名单' );
|
|
SET IDENTITY_INSERT FXKH_TXL.ORGANIZATION Off;
|
|
COMMIT;
|
|
|
|
insert into "FXKH_TXL"."USERS"("USERNAME", "PASSWORD", "SALT", "ROLE", "AB_ID")
|
|
VALUES ('superadmin','0d36b3ff219df5a7f7d2d3961588f50c','3517548df1ac46198dbfec4f1176ec93','99',0)
|
|
,('admin','0d36b3ff219df5a7f7d2d3961588f50c','3517548df1ac46198dbfec4f1176ec93','1',1)
|
|
,('user','0d36b3ff219df5a7f7d2d3961588f50c','3517548df1ac46198dbfec4f1176ec93','0',2);
|
|
|
|
insert into "FXKH_TXL"."ADDRESS_BOOK"("NAME", "PHONE", "ORGANIZATION", "POSITION") VALUES
|
|
('超级管理员','18891233883','1','巡视员')
|
|
,('政区管理员','18891233883','2','巡视员')
|
|
,('普通用户','18891233883','3','巡视员');
|
|
|
|
|
|
alter table "FXKH_TXL"."AB_INFO" add column("ADCD" VARCHAR(50));
|
|
|
|
comment on column "FXKH_TXL"."AB_INFO"."ADCD" is '行政区划';
|
|
|
|
alter table "FXKH_TXL"."ADDRESS_BOOK" add column("OPENID" VARCHAR(50));
|
|
|
|
comment on column "FXKH_TXL"."ADDRESS_BOOK"."OPENID" is 'openid';
|
|
|
|
alter table "FXKH_TXL"."ADDRESS_BOOK" add column("IS_PASS" TINYINT default (FALSE));
|
|
|
|
comment on column "FXKH_TXL"."ADDRESS_BOOK"."IS_PASS" is '是否放行, 放行:true,拦截:false';
|
|
|
|
|
|
# 2024年6月13日15:18:35
|
|
alter table "FXKH_TXL"."ADDRESS_BOOK_OLD" add column("SALT" VARCHAR(50));
|
|
|
|
comment on column "FXKH_TXL"."ADDRESS_BOOK_OLD"."SALT" is '盐';
|
|
|
|
alter table "FXKH_TXL"."QXWARNING" modify "PUBLISH_TIME" DATETIME(0);
|
|
|
|
alter table "FXKH_TXL"."QXWARNING" modify "START_TIME" DATETIME(0);
|
|
|
|
alter table "FXKH_TXL"."QXWARNING" modify "END_TIME" DATETIME(0);
|
|
|
|
|
|
ALTER TABLE FXKH_TXL.QXWARNING
|
|
ADD CONSTRAINT WARNID UNIQUE (WARNID);
|