DROP VIEW IF EXISTS "public"."Tracks";
CREATE VIEW "public"."Tracks" AS SELECT "public"."cc_music_dirs"."exists", "public"."cc_music_dirs"."directory", "public"."cc_files"."album_title", "public"."cc_files"."artist_name", "public"."cc_files"."file_exists", "public"."cc_files"."replay_gain", "public"."cc_files"."track_title", "public"."cc_files"."track_number", "public"."cc_files"."id", "public"."cc_files"."format", "public"."cc_files"."hidden", "public"."cc_files"."length", "public"."cc_files"."bit_rate", "public"."cc_files"."filepath", "public"."cc_files"."copyright", "public"."cc_files"."cuein", "public"."cc_files"."cueout", "public"."cc_files"."label" FROM "public"."cc_files" INNER JOIN "public"."cc_music_dirs" ON ("public"."cc_files"."directory" = "public"."cc_music_dirs"."id");
DROP ROLE IF EXISTS radio;

GRANT SELECT ON "public"."Tracks" TO radio;