You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
81 lines
1.5 KiB
81 lines
1.5 KiB
create database xinguan default character set = utf8 collate utf8_general_ci;
|
|
|
|
use database xinguan;
|
|
|
|
create table ForeignCountry(
|
|
id int primary key auto_increment,
|
|
confirmed int,
|
|
died int,
|
|
crued int,
|
|
country varchar(30),
|
|
curConfirm int,
|
|
confirmedRelative int,
|
|
pub_date DATETIME not null
|
|
);
|
|
|
|
create table InsideChina(
|
|
id int primary key auto_increment,
|
|
curConfirm int,
|
|
curConfirmRelative int,
|
|
asymptomatic int,
|
|
asymptomaticRelative int,
|
|
unconfirmed int,
|
|
unconfirmedRelative int,
|
|
icu int,
|
|
icuRelative int,
|
|
confirmed int,
|
|
confirmedRelative int,
|
|
overseasInput int,
|
|
overseasInputRelative int,
|
|
cured int,
|
|
curedRelative int,
|
|
died int,
|
|
diedRelative int,
|
|
updateTime DATETIME not null
|
|
);
|
|
|
|
create table OutsideChina(
|
|
id int primary key auto_increment,
|
|
confirmed int,
|
|
curConfirmed int,
|
|
curConfirmRelative int,
|
|
confirmedRelative int,
|
|
cured int,
|
|
curedRelative int,
|
|
died int,
|
|
diedRelative int,
|
|
updateTime char(30) not null
|
|
);
|
|
|
|
create table CityTable(
|
|
id int primary key auto_increment,
|
|
cityName varchar(20) not null,
|
|
provinceName varchar(10),
|
|
confirmed int,
|
|
died int,
|
|
cured int,
|
|
confirmedRelative int,
|
|
curConfirm int,
|
|
pub_date DATETIME,
|
|
);
|
|
|
|
create table ProvinceTable(
|
|
id int primary key auto_increment,
|
|
confirmed int,
|
|
died int,
|
|
crued int,
|
|
confirmedRelative int,
|
|
diedRelative int,
|
|
curedRelative int,
|
|
asymptomatic int,
|
|
asymptomaticRelative int,
|
|
curConfirm int,
|
|
curConfirmRelative int,
|
|
icuDisable int,
|
|
area varchar(10),
|
|
pub_date DATETIME not null
|
|
);
|
|
|
|
|
|
|