数据库设计

数据库

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				member
					protected				team
					normal

Submit Table

submit

submit_id（auto increment）	user_id	mark(前三)	submit_time	submit_flag	correct	gmt_create	gmt_modified
		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

flag

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

replica_alloc

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

replica

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

bulletin

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