CREATE TABLE cv1step 
(
	cv1stepid INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
	profileid INT,
	firstname varchar(100),
	fathername VARCHAR(100),
	latname VARCHAR(100),
	gender INT,
	mstatus int,
	birthyear int,
	address varchar(255),
	email varchar(100),
	phone varchar(100),
	mobile varchar(100),
	fax varchar(100),
	nationality varchar(100),
	ldriver int,
	timestamp TIMESTAMP(8)
)ENGINE=InnoDB;

CREATE TABLE institution 
(
	institutionid INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
	profileid INT,
	institutname varchar(100),
	institutcountry VARCHAR(100),
	institutgradyear int,
	institutmajor varchar(100),
	timestamp TIMESTAMP(8)
)ENGINE=InnoDB;

CREATE TABLE language 
(
	languageid INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
	profileid INT,
	langname varchar(100),
	langspoken int,
	langwritten int,
	timestamp TIMESTAMP(8)
)ENGINE=InnoDB;



CREATE TABLE skill 
(
	skillid INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
	profileid INT,
	skillprog varchar(100),
	skilllevel int,
	timestamp TIMESTAMP(8)
)ENGINE=InnoDB;

CREATE TABLE experience 
(
	experienceid INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
	profileid INT,
	experiecenb int,
	cname varchar(100),
	clocation varchar(100),
	cacttype varchar(100),
	expfrom varchar(100),
	expto varchar(100),
	jobtitle varchar(100),
	jobcategory varchar(100),
	tel varchar(100),
	reasonforleaving varchar(255),
	workdescription varchar(255),
	timestamp TIMESTAMP(8)
)ENGINE=InnoDB;

CREATE TABLE planing 
(
	planingid INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
	profileid INT,
	plan int,
	plancourse varchar(100),
	planstartyear int,
	planstartmonth int,
	timestamp TIMESTAMP(8)
)ENGINE=InnoDB;

CREATE TABLE reference 
(
	referenceid INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
	profileid INT,
	name varchar(100),
	phone varchar(100),
	yearsknown int,
	company varchar(100),
	position varchar(100),
	relation varchar(100),
	address varchar(255),
	timestamp TIMESTAMP(8)
)ENGINE=InnoDB;

CREATE TABLE relevant 
(
	relevantid INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
	profileid INT,
	swcompany int(100),
	swname varchar(100),
	swrelation int,
	fathername varchar(100),
	fatherbirthyear int,
	fatheroccupation varchar(100),
	fathereducation varchar(100),
	mothername varchar(100),
	motherbirthyear int,
	motheroccupation varchar(100),
	mothereducation varchar(100),	
	spousename varchar(100),
	spousebirthyear int,
	spouseoccupation varchar(100),
	spouseeducation varchar(100),	
	pemergencyname varchar(100),
	pemergencyphone varchar(100),
	familybusiness int,
	nbsisters int,
	nbbrotheres int,
	jobobjective varchar(255),
	interesthobbies varchar(255),
	otherskills varchar(255),
	suitableforjob varchar(255),
	sourceknewjob varchar(100),
	timestamp TIMESTAMP(8)
)ENGINE=InnoDB;

CREATE TABLE password 
(
	passwordid INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
	email varchar(100),
	timestamp TIMESTAMP(8)
)ENGINE=InnoDB;

CREATE TABLE travelrequest
(
	travelrequestid INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
	profileid int,
	depyear int,
	depmonth int,
	depday int,
	retyear int,
	retmonth int,
	retday int,
	businessjust1 varchar(255),
	businessjust2 varchar (255),
	businessjust3 varchar(255),
	budget int,
	advpayement int,
	passport int,
	hometoair int,
	airtohotel int,
	hoteltoair int,
	airtohome int,
	timestamp TIMESTAMP(8)
)ENGINE=InnoDB;


CREATE TABLE approve
(
	approveid INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
	profileid int,
	taskid int,
	status int,
	timestamp TIMESTAMP(8)
)ENGINE=InnoDB;

CREATE TABLE homedisplay
(
	homedisplayid INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
	title varchar(250),
	shortdescription varchar(250),
	longdescription text,
	link varchar(250),
	active int,
	timestamp TIMESTAMP(8)
)ENGINE=InnoDB;

CREATE TABLE polandproc
(
	polandprocid INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
	title varchar(250),
	shortdescription varchar(250),
	longdescription text,
	link varchar(250),
	active int,
	polandprocorder int default 0,
	ppolandprocid int default -1,
	timestamp TIMESTAMP(8)
)ENGINE=InnoDB;

CREATE TABLE polandprocattach
(
	polandprocattachid INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
	polandprocid int,
	name varchar(250),
	timestamp TIMESTAMP(8)
)ENGINE=InnoDB;