Skip to content

Latest commit

 

History

History
113 lines (84 loc) · 4.19 KB

changelogdb.md

File metadata and controls

113 lines (84 loc) · 4.19 KB

#update 26/08/2021 ALTER TABLE vaccom.t_catiemchung CHANGE COLUMN GioHenTien GioHenTiem VARCHAR(6) NULL DEFAULT NULL ;

ALTER TABLE vaccom.t_cosoyte ADD COLUMN MaQR VARCHAR(128) DEFAULT NULL;

#update 28/08/2021

ALTER TABLE vaccom.t_nguoidung CHANGE COLUMN VaiTro QuanTriHeThong TINYINT(1) NULL DEFAULT '0' ;

ALTER TABLE vaccom.t_lichtiemchung CHANGE COLUMN TongSoMuiTiem TongSoMuiTiem INT(8) NOT NULL ,CHANGE COLUMN SoCaTiem SoCaTiem INT(8) NOT NULL ,CHANGE COLUMN SoMuiMotCa SoMuiMotCa INT(8) NOT NULL ;

ALTER TABLE vaccom.t_catiemchung CHANGE COLUMN SoMuiTiem SoMuiTiem INT(8) NULL DEFAULT NULL ,CHANGE COLUMN SoPhieuHen SoPhieuHen INT(8) NOT NULL ;

ALTER TABLE vaccom.t_nguoidung ADD COLUMN UyBanNhanDanID BIGINT(20) NULL DEFAULT 0;

ALTER TABLE vaccom.t_nguoitiemchung ADD COLUMN CoSoYTeID BIGINT(20) NULL DEFAULT 0;

update t_nguoidung set QuanTriHeThong = 0 where QuanTriHeThong != 1;

#update 01/09/2021 ALTER TABLE vaccom. t_diabancoso ADD COLUMN UyBanNhanDanID bigint(20) DEFAULT 0;

CREATE TABLE IF NOT EXISTS vaccom.t_uybannhandan ( ID bigint(20) NOT NULL AUTO_INCREMENT, TenCoQuan varchar(512) DEFAULT NULL, MaDinhDanh varchar(30) DEFAULT NULL, UyBanNhanDanChaID bigint(20) DEFAULT 0, TinhThanhMa varchar(30) DEFAULT NULL, TinhThanhTen varchar(128) DEFAULT NULL, QuanHuyenMa varchar(30) DEFAULT NULL, QuanHuyenTen varchar(128) DEFAULT NULL, PhuongXaMa varchar(30) DEFAULT NULL, PhuongXaTen varchar(128) DEFAULT NULL, DiaChiHoatDong text DEFAULT NULL, NguoiDaiDien varchar(256) DEFAULT NULL, SoDienThoai varchar(20) DEFAULT NULL, PRIMARY KEY (ID) ) ;

ALTER TABLE vaccom.t_cosoyte ADD COLUMN CoSoYTeChaId bigint(20) DEFAULT NULL;

ALTER TABLE vaccom.t_cosoyte ADD COLUMN UyBanNhanDanID bigint(20) DEFAULT NULL;

ALTER TABLE vaccom.t_phieuhentiem ADD COLUMN GhiChuLyDo text DEFAULT NULL;

CREATE TABLE IF NOT EXISTS t_giaydiduong ( ID bigint(20) NOT NULL AUTO_INCREMENT, MaQR varchar(128) DEFAULT NULL, HoVaTen varchar(128) NOT NULL, CMTCCCD varchar(20) DEFAULT NULL, SoDienThoai varchar(20) DEFAULT NULL, Email varchar(64) DEFAULT NULL, NoiCtTenCoQuan varchar(512) DEFAULT NULL, NoiCtDiaChi varchar(512) DEFAULT NULL, NoiCtTinhThanhMa varchar(30) DEFAULT NULL, NoiCtTinhThanhTen varchar(128) DEFAULT NULL, NoiCtQuanHuyenMa varchar(30) DEFAULT NULL, NoiCtQuanHuyenTen varchar(128) DEFAULT NULL, NoiCtPhuongXaMa varchar(30) DEFAULT NULL, NoiCtPhuongXaTen varchar(128) DEFAULT NULL, NoiODiaChi text DEFAULT NULL, NoiOTinhThanhMa varchar(30) DEFAULT NULL, NoiOTinhThanhTen varchar(128) DEFAULT NULL, NoiOQuanHuyenMa varchar(30) DEFAULT NULL, NoiOQuanHuyenTen varchar(128) DEFAULT NULL, NoiOPhuongXaMa varchar(30) DEFAULT NULL, NoiOPhuongXaTen varchar(128) DEFAULT NULL, LichLamViec text DEFAULT NULL, UyBanNhanDanID bigint(20) DEFAULT 0, NgayCap varchar(8) DEFAULT NULL, ThoiHan varchar(8) DEFAULT NULL, CheckSum text DEFAULT NULL, GhiChu text DEFAULT NULL, Status tinyint(1) DEFAULT 0, PRIMARY KEY (ID) ) ;

create table IF NOT EXISTS t_hangchothongbao (

`ID` bigint not null auto_increment,

`LoaiThongBao` varchar(255),

`isSent` bit,

`isReady` bit,

`payload` varchar(1024),

`toEmail` varchar(255),

`toTelNo` varchar(255),

primary key (ID)

);

#update 02/09/2021 ALTER TABLE t_cosoyte modify UyBanNhanDanID bigint(20) DEFAULT 0; ALTER TABLE t_cosoyte modify CoSoYTeChaId bigint(20) DEFAULT 0; update t_cosoyte set CoSoYTeChaId = 0; update t_cosoyte set UyBanNhanDanID = 0;

#update 03/09/2021 ALTER TABLE t_giaydiduong modify NgayCap varchar(20) DEFAULT NULL; ALTER TABLE t_giaydiduong modify ThoiHan varchar(20) DEFAULT NULL;