create tables

void createTables() throws SQLException {

		/* Create Globals Store Stack */
		String createStore = new String(
				"CREATE TABLE Globals (" +
			    "id int NOT NULL,"+
				"Basic_Teacher_Wage float(2),"+
				"Basic_Admin_Wage float(2),"+
				"Teacher_Rise_Percentage float(2),"+
				"Admin_Rise_Percentage float(2),"+
				"Member_Percentage float(2),"+
				"Reasearch_Bonus float(2),"+
				"Library_Bonus float(2),"+
				"Basic_Temp_Teacher_Wage float(2),"+
				"Basic_Temp_Admin_Wage float(2),"+
				"DBdate DATE" +
				");");

		Statement stmt =  connection.con.createStatement();
		stmt.executeUpdate(createStore);

		/* Creates Teaching_Stuff table */
		String createTeachers = new String(
				"CREATE TABLE Teaching_Stuff ("+
					    "id_Stuff int NOT NULL,"+
					    "FirstName varchar(100) NOT NULL,"+
					    "LastName varchar(100) NOT NULL,"+
					    "FatherName varchar(100) NOT NULL,"+
					    "Gender char(1) NOT NULL,"+
					    "DateOfBirth DATE NOT NULL,"+
					    "AMKA varchar(11) NOT NULL,"+
					    "AFM varchar(9) NOT NULL,"+
					    "Department varchar(255) NOT NULL,"+
					    "Marital_Status char(1) NOT NULL,"+
					    "Address varchar(255) NOT NULL,"+
					    "Bank varchar(100) NOT NULL,"+
					    "IBAN varchar(33) NOT NULL,"+
					    "Active char(1) NOT NULL,"+
					    "Prof_Title varchar(100),"+
					    "Telephone varchar(16),"+
					    "PRIMARY KEY (id_Stuff)"+
					");");

		stmt = connection.con.createStatement();
		stmt.executeUpdate(createTeachers);

		/* Creates Admin_Stuff table */
		String createAdmin = new String(
				"CREATE TABLE Admin_Stuff ("+
					    "id_Stuff int NOT NULL,"+
					    "FirstName varchar(100) NOT NULL,"+
					    "LastName varchar(100) NOT NULL,"+
					    "FatherName varchar(100) NOT NULL,"+
					    "Gender char(1) NOT NULL,"+
					    "DateOfBirth DATE NOT NULL,"+
					    "AMKA varchar(11) NOT NULL,"+
					    "AFM varchar(9) NOT NULL,"+
					    "Department varchar(255) NOT NULL,"+
					    "Marital_Status char(1) NOT NULL,"+
					    "Address varchar(255) NOT NULL,"+
					    "Bank varchar(100) NOT NULL,"+
					    "IBAN varchar(33) NOT NULL,"+
					    "Active char(1) NOT NULL,"+
					    "Admin_Title varchar(100)," +
					    "Duty varchar(255)," +
					    "Telephone varchar(16),"+
					    "PRIMARY KEY (id_Stuff)"+
					");");

		stmt =  connection.con.createStatement();
		stmt.executeUpdate(createAdmin);

		/* Creates Contract_Inf table */
		String createInf = new String(
				"CREATE TABLE Contract_Inf (" +
				"id_Contract int NOT NULL," +
				"Date_Begin DATE NOT NULL," +
				"Hours_Week int NOT NULL," +
				"Days_Leave int NOT NULL," +
				"In_Effect char(1) NOT NULL," +
				"Termination DATE,"+
				"id_Stuff int NOT NULL," +
				"PRIMARY KEY (id_Contract)"+
				");");

		stmt =  connection.con.createStatement();
		stmt.executeUpdate(createInf);

		/* Creates Contract_Fin table */
		String createFin = new String(
				"CREATE TABLE Contract_Fin (" +
				"id_Contract int NOT NULL," +
				"Date_Begin DATE NOT NULL," +
				"Hours_Week int NOT NULL," +
				"Days_Leave int NOT NULL," +
				"In_Effect char(1) NOT NULL," +
				"Date_End DATE NOT NULL,"+
				"Termination DATE,"+
				"id_Stuff int NOT NULL," +
				"PRIMARY KEY (id_Contract)"+
				");");

		stmt =  connection.con.createStatement();
		stmt.executeUpdate(createFin);

		/* Creates Family_Member table */
		String createMember = new String(
				"CREATE TABLE Family_Member (" +
				"id_Member int NOT NULL," +
				"FirstName varchar(100) NOT NULL," +
				"LastName varchar(100) NOT NULL," +
				"Relation char(1) NOT NULL," +
				"Gender char(1) NOT NULL," +
				"DateOfBirth DATE NOT NULL," +
				"AMKA varchar(11) NOT NULL," +
				"id_Stuff int NOT NULL," +
				"PRIMARY KEY (id_Member)" +
				");");

		stmt =  connection.con.createStatement();
		stmt.executeUpdate(createMember);

		/* Creates Edu_Degree table */
		String createDegree = new String(
				"CREATE TABLE Edu_Degree (" +
				"id_Degree int NOT NULL," +
				"Title varchar(255) NOT NULL," +
				"Year int NOT NULL," +
				"Mark float(2) NOT NULL," +
				"University varchar(255) NOT NULL," +
				"id_Stuff int NOT NULL," +
				"PRIMARY KEY (id_Degree)" +
				");");

		stmt =  connection.con.createStatement();
		stmt.executeUpdate(createDegree);

		/* Creates Payment table */
		String createPayment = new String(
				"CREATE TABLE Payment (" +
				"id_Payment int NOT NULL," +
				"id_Stuff int NOT NULL," +
				"TypeOfPay varchar(100) NOT NULL," +
				"DateOfPay DATE NOT NULL," +
				"ValueOfPay float(2) NOT NULL," +
			    "Basic_Wage float(2) NOT NULL," +
			    "Family_bonus float(2) NOT NULL," +
			    "Benefits float(2) NOT NULL," +
			    "Comment varchar(255)," +
			    "PRIMARY KEY (id_Payment)" +
				");");

		stmt =  connection.con.createStatement();
		stmt.executeUpdate(createPayment);

		/* Creates Course table */
		String createCourse = new String(
				"CREATE TABLE Course (" +
				"id_Course int NOT NULL," +
				"Title varchar(255) NOT NULL," +
				"id_Stuff int NOT NULL," +
				"PRIMARY KEY (id_Course)" +
				");");

		stmt =  connection.con.createStatement();
		stmt.executeUpdate(createCourse);

		/* Creates Participates_In table */
		String createParticipates_In = new String(
				"CREATE TABLE Participates_In (" +
				"id_Project int NOT NULL," +
				"Date_In DATE NOT NULL," +
				"Date_Out DATE," + 			// corrected
				"id_Stuff int NOT NULL," +
				"PRIMARY KEY (id_Project,id_Stuff)" +
				");");

		stmt =  connection.con.createStatement();
		stmt.executeUpdate(createParticipates_In);

		/* Creates Project table */
		String createProject = new String(
				"CREATE TABLE Project (" +
				"id_Project int NOT NULL," +
				"Name varchar(255) NOT NULL," +
				"PRIMARY KEY (id_Project)" +
				");");

		stmt =  connection.con.createStatement();
		stmt.executeUpdate(createProject);


	}