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
	);
	
	
	
