tables.sql

/*DROP TABLE personnes
DROP TABLE candidats*/

CREATE TABLE personnes(
	L_name VARCHAR2(30) NOT NULL,
	F_NAME VARCHAR2(30) NOT NULL,
	LOGIN VARCHAR2(5) NOT NULL,
	PASSWORD VARCHAR2(40) NOT NULL,
	STATUS VARCHAR2(3) NOT NULL
);
ALTER TABLE personnes
ADD CONSTRAINT pk_personnes
PRIMARY KEY(LOGIN);

CREATE TABLE candidats(
	CODE VARCHAR2(3) NOT NULL, 
	F_NAME VARCHAR2(30) NOT NULL,
	L_name VARCHAR2(30) NOT NULL
);
ALTER TABLE candidats
ADD CONSTRAINT pk_candidats
PRIMARY KEY(CODE);


CREATE TABLE stats(
	CODE VARCHAR2(3) NOT NULL, 
	POINTS NUMBER(3) NOT NULL,
	STATUS VARCHAR2(3)
);
ALTER TABLE stats
ADD (CONSTRAINT pk_stats
PRIMARY KEY(CODE),
CONSTRAINT fk_stats
FOREIGN Key (CODE) 
REFERENCES candidats(CODE)
ON DELETE CASCADE);



/*
INSERT INTO candidats
VALUES('C1','YAHYA','KHARBANE');
INSERT INTO candidats
VALUES('C2','MOHCINE','OUCHEN');
INSERT INTO candidats
VALUES('C3','FATIMA','EL JAMILI');
INSERT INTO candidats
VALUES('C4','blanc','blanc');*/





/*
DELETE from personnes;
DELETE from candidats;

INSERT INTO personnes
VALUES('C1','YAHYA','KHARBANE');
INSERT INTO candidats
VALUES('C2','MOHCINE','OUCHEN');


ZKARA:SALAH EDDINE:E001:a345418ea0edfdf807e7b9564c1b9daf:NO
TEST:TEST:E002:ef594392b54a739c8167d899bc8a235b:OK
TEST:TSET:E003:59b14c43447108c6809f26278698bbd6:OK*/