-- 创建库
create database if not exists onlinejudge;

-- 切换库
use onlinejudge;

create table question_submit
(
	id bigint not null
		primary key,
	language varchar(50) null,
	code varchar(5000) null,
	judge_info varchar(500) null,
	status int null,
	question_id bigint null,
	user_id bigint null,
	create_time datetime null,
	update_time datetime null,
	user_cases varchar(5000) null,
	output varchar(5000) null,
	judge_mode int null,
	is_delete int null
);

create table user
(
	id bigint auto_increment
		primary key,
	username varchar(100) not null,
	password varchar(100) not null
);