会议室.sql 617 B

12345678
  1. ALTER TABLE tb_organization ADD mettingClient VARCHAR(10) DEFAULT '';
  2. alter table tb_floor add COLUMN isHaveMeeting varchar(2) DEFAULT '' COMMENT '是否有会议室';
  3. ALTER TABLE tb_virtualarchitecture MODIFY COLUMN remainderTime decimal(10,2) DEFAULT '0.00' COMMENT '剩余时长';
  4. ALTER TABLE tb_virtualarchitecture MODIFY COLUMN freeLenTime decimal(10,2) DEFAULT '0.00' COMMENT '免费总时长';
  5. ALTER TABLE tb_wxpublicno
  6. ADD COLUMN sslcertPath VARCHAR(100) NULL COMMENT '商户证书地址' AFTER getAccessTokenUrl,
  7. ADD COLUMN sslcertPassword VARCHAR(100) NULL COMMENT '证书密码' AFTER sslcertPath;