 				ELSE
 					act:='deshonorer';
 				END IF;
-			INSERT INTO HISTORIQUE_ARTICLE(id, art, aDate, login, aAction ) VALUES (nextval('idauto_his_art'), NEW.id ,current_timestamp,'$currentLogin',act);
+			INSERT INTO HISTORIQUE_ARTICLE(id, art, aDate, login, aAction ) VALUES (nextval('idauto_his_art'), NEW.id ,current_timestamp, NEW.modi,act);
 			END IF;
 			
         ELSIF (TG_OP = 'INSERT') THEN

	title VARCHAR(200) NOT NULL,
	texte TEXT,
	image_uml VARCHAR(200),
	CHECK((texte IS NOT NULL) OR (image_uml IS NOT NULL) ),
	PRIMARY KEY(art, aOrder)
);

CREATE TABLE NOTE(
	login CHAR(7) REFERENCES TUSER(login),
	art INTEGER REFERENCES ARTICLE(id),
	note INTEGER NOT NULL,
	PRIMARY KEY(login, art),
	CHECK((note>0) AND (note<=10))
);

CREATE TABLE COMMENTAIRE(

CREATE TABLE TIE_ARTICLE(
	firstArticle INTEGER REFERENCES ARTICLE(id),
	secondArticle INTEGER REFERENCES ARTICLE(id),
	modi CHAR(7) REFERENCES TUSER(login),
	CHECK(firstArticle!=secondArticle),
	UNIQUE(secondArticle,firstArticle), --(1,2) et (2,1) sont pareils
	PRIMARY KEY(firstArticle, secondArticle)
