* forcing view recreation

1 files changed, 3 insertions, 0 deletions

diff --git a/views/podiums.sql b/views/podiums.sql
index 6e677da..f9576f4 100644
--- a/views/podiums.sql
+++ b/views/podiums.sql
@@ -1,4 +1,5 @@
 -- podium for each race, in order of finishing position

+DROP VIEW IF EXISTS podium_sequences;

 CREATE VIEW podium_sequences AS

    SELECT races.*,

       GROUP_CONCAT(CONCAT(drivers.forename, " ", drivers.surname)

@@ -11,6 +12,7 @@ CREATE VIEW podium_sequences AS
    GROUP BY results.raceId;

 

 -- podium for each race, in alphabetical order

+DROP VIEW IF EXISTS podium_sets;

 CREATE VIEW podium_sets AS

    SELECT races.*,

       GROUP_CONCAT(CONCAT(drivers.forename, " ", drivers.surname)

@@ -25,6 +27,7 @@ CREATE VIEW podium_sets AS
 

 -- races in which the entire podium consisted of driver of nationality

 -- yet to produce a drivers' world champion

+DROP VIEW IF EXISTS non_champion_nationality_podiums;

 CREATE VIEW non_champion_nationality_podiums AS

    SELECT raceId, year, name, podium FROM podium_sequences

    WHERE raceId NOT IN (