ctfd_1.2.0_to_2.0.0.sql

insert into ctfd.users (id,name,email,password,created)
select id,name,email,password,joined from bak.teams;

update ctfd.users set type = "user",bracket = NULL,hidden=0,verified=0,banned=0;

insert into ctfd.challenges(id,name,description,max_attempts,value,category,type,state)
select id,name,description,max_attempts,value,category,"dynamic","visible" from bak.challenges;

insert into dynamic_challenge (id,initial,minimum,decay)
	select id,value,value/10,15 from ctfd.challenges;

insert into ctfd.files (id,type,location,challenge_id)
	select id,"challenge",location,chal from bak.files;

insert into ctfd.flags (id,challenge_id,type,content) 
	select id,chal,type,flag from bak.keys;

insert into ctfd.hints (id,type,challenge_id,content,cost)
	select id,"standard",chal,hint,cost from bak.hints;

insert into ctfd.sibmissions (id,challenge_id,user_id,ip,date)
	select id,chalid,teamid,"127.0.0.1",date from bak.solves;

insert into ctfd.solves (id,challenge_id,user_id)
	select id,chalid,teamid from bak.solves;