CREATE TABLE mathima(
	maid MEDIUMINT NOT NULL AUTO_INCREMENT,
	titlos CHAR(50),
	etos CHAR(5),
	epilogis CHAR(5),
	askiseis CHAR(5),
	diagonisma CHAR(5),
	ergasia CHAR(5),
	PRIMARY KEY (maid));
	
	
	CREATE TABLE kathigites(
	user CHAR (20) NOT NULL,
	pass CHAR (20) NOT NULL,
	deleted CHAR (10) NOT NULL,
	admin CHAR (10) NOT NULL,
	kaid MEDIUMINT NOT NULL AUTO_INCREMENT,
	onoma CHAR (50),
	PRIMARY KEY (kaid));
	
	
		
	CREATE TABLE erotimatologio(
	eroid MEDIUMINT NOT NULL AUTO_INCREMENT,
	tropopoiisi CHAR(3),
	imerominia DATE,
	eisagwgi VARCHAR (500),
	titlos VARCHAR (50),
	deleted CHAR (12),
	PRIMARY KEY (eroid));
	
/* 	CREATE TABLE mathima(
	maid MEDIUMINT NOT NULL AUTO_INCREMENT,
	titlos CHAR(50),
	etos CHAR(5),
	epilogis CHAR(5),
	askiseis CHAR(5),
	diagonisma CHAR(5),
	ergasia CHAR(5),
	PRIMARY KEY (maid)); */
	
	
	CREATE TABLE didaskei(
	kaid INTEGER NOT NULL CHECK(kaid>=0),
	maid INTEGER NOT NULL CHECK(maid>=0),
	PRIMARY KEY (kaid,maid));
	
	
	CREATE TABLE siggramma(
	sigid MEDIUMINT NOT NULL AUTO_INCREMENT,
	titlos CHAR (50),
	PRIMARY KEY (sigid));
	
	
	
	CREATE TABLE exei_sig(
	maid INTEGER NOT NULL CHECK(maid>=0),
	sigid INTEGER NOT NULL CHECK(sigid>=0),
	PRIMARY KEY (maid,sigid));
	
	
	CREATE TABLE kefalaia(
	keid MEDIUMINT NOT NULL AUTO_INCREMENT,
	seira INTEGER NOT NULL CHECK(SEIRA>=0),
	titlos CHAR (50),
	PRIMARY KEY (keid));
	
	CREATE TABLE apoteleitai(
	maid INTEGER NOT NULL CHECK(maid>=0),
	keid INTEGER NOT NULL CHECK(keid>=0),
	PRIMARY KEY (maid,keid));
	
	
	
	CREATE TABLE erot_math(
	eromid MEDIUMINT NOT NULL AUTO_INCREMENT,
	plithos_kwd INTEGER CHECK(plith_kwd>=0),
	katastasi CHAR (10),
	proth_ypov DATE,
	PRIMARY KEY (eromid));
	
	CREATE TABLE dimiourgei(
	eromid INTEGER NOT NULL CHECK(eromid>=0),
	maid INTEGER NOT NULL CHECK(maid>=0),
	PRIMARY KEY (eromid,maid));
	
	
	
	CREATE TABLE exei_erotim(
	eroid INTEGER NOT NULL CHECK(eroid>=0),
	eromid INTEGER NOT NULL CHECK(eromid>=0),
	PRIMARY KEY (eroid,eromid));
	
	CREATE TABLE paragei(
	eromid INTEGER NOT NULL CHECK(eromid>=0),
	coid INTEGER NOT NULL CHECK(coid>=0),
	PRIMARY KEY (eromid,coid));
	
	
	CREATE TABLE kwdikoi(
	coid MEDIUMINT NOT NULL AUTO_INCREMENT,
	username CHAR (6),
	password Char(5),
	PRIMARY KEY (coid));
	
	
	
	CREATE TABLE typos_erotisis(
	teid MEDIUMINT NOT NULL AUTO_INCREMENT,
	typos VARCHAR(30),
	PRIMARY KEY (teid));
	
	
	
	CREATE TABLE exei_enot(
	enid INTEGER NOT NULL CHECK(enid>=0),
	eroid INTEGER NOT NULL CHECK(eroid>=0),
	seira INTEGER CHECK(seira>=0),
	PRIMARY KEY (enid,eroid));

	CREATE TABLE enotites(
	enid MEDIUMINT NOT NULL AUTO_INCREMENT,
	Epanalipsi CHAR(20),
	titlos VARCHAR(50),
	PRIMARY KEY (enid));
	
	
	CREATE TABLE periexei(
	erid INTEGER NOT NULL CHECK(erid>=0),
	enid INTEGER NOT NULL CHECK(enid>=0),
	PRIMARY KEY (erid,enid));
	
	
	CREATE TABLE erotisi(
	erid MEDIUMINT NOT NULL AUTO_INCREMENT,
	titlos VARCHAR(100),
	epanalispi VARCHAR(20),
	PRIMARY KEY (erid));
	
	CREATE TABLE exei_typo(
	erid INTEGER NOT NULL CHECK(erid>=0),
	teid INTEGER NOT NULL CHECK(teid>=0),
	PRIMARY KEY (erid,teid));
	
	
	CREATE TABLE exei_xar(
	erid INTEGER NOT NULL CHECK(erid>=0),
	xkid INTEGER NOT NULL CHECK(xkid>=0),
	PRIMARY KEY (erid,xkid));
	
	
	CREATE TABLE xar_klimakas(
	xkid MEDIUMINT NOT NULL AUTO_INCREMENT,
	pososto VARCHAR(20),
	dg_da VARCHAR (10),
	vima INTEGER,
	min INTEGER CHECK(min>=0),
	max INTEGER CHECK(max>=0),
	PRIMARY KEY (xkid));
	
	
	CREATE TABLE exei_epil(
	erid INTEGER NOT NULL CHECK(erid>=0), 
	epid INTEGER NOT NULL CHECK(epid>=0),
	PRIMARY KEY (erid,epid));
	
	
	CREATE TABLE epiloges(
	epid MEDIUMINT NOT NULL AUTO_INCREMENT,
	titlos VARCHAR(20),
	seira INTEGER CHECK(seira>=0),
	PRIMARY KEY (epid));
	
	
	create TABLE apantiseis(
	apid MEDIUMINT NOT NULL AUTO_INCREMENT,
	maid INTEGER NOT NULL CHECK(maid>=0),
	erid INTEGER NOT NULL CHECK(erid>=0),
	epanEnot INTEGER NOT NULL CHECK(epanEnot>=0),
	epanErot INTEGER NOT NULL CHECK(epanErot>=0),
	apantisi VARCHAR(500),
	PRIMARY KEY (apid));
	

	insert into typos_erotisis (teid,typos) values (1,"Κείμενο");
	insert into typos_erotisis (teid,typos) values (2,"Κλίμακας");
	insert into typos_erotisis (teid,typos) values (3,"Παρατηρήσεις");
	insert into typos_erotisis (teid,typos) values (4,"Εισ. Αριθμού");
	insert into typos_erotisis (teid,typos) values (5,"Ενα από πολλά");
	insert into typos_erotisis (teid,typos) values (6,"Πολλά από πολλά");
	
	insert into kathigites (user,pass,deleted,admin,kaid,onoma) values ('user','pass','No Deleted','admin',1,'Γιάννης Λατίφης');