数据库

Info Table

user

user_id (auto increment)	name	stu_number	password(两次sha1)	department	state	grade	QQ	mail	join_time	role	score	gmt_create	gmt_modified	top_rank	protected_time
						...			admin
					disabled	2017			member
					protected	2018			team
					normal	2019

Submit Table

submit

submit_id（auto increment）	user_id	mark(前三)	submit_time	submit_flag	correct	gmt_create	gmt_modified	callenge_id
		0
		1
		2
		3

challenge table

challenge

challenge_id (auto increment)	desciption	first_blood	second_blood	third_blood	state	gmt_create	gmt_modified
-------	------	------	-------	------	-------	--------

flag table

replica_alloc

replica_alloc_id (auto increment)	replica_id	user_id	gmt_create	gmt_modified
------	-------	-------	---------

replica

replica_id (auto increment)	gmt_create	gmt_modified	challenge_id	flag
---	---	---	-

bulletin

bulletin_id (auto increment)	gmt_create	gmt_modified	content	topping
---	---	---	---	---