
/* Creare la vista FileOrd che restituisce la tabella dei file
  ordinari (non directory) */

DROP VIEW IF EXISTS FileOrd;

CREATE VIEW FileOrd AS
       SELECT *
       FROM   File 
       WHERE  Id NOT IN (SELECT * FROM Directory);

SELECT * FROM FileOrd;
       
