diff options
Diffstat (limited to 'dbinit')
| -rw-r--r-- | dbinit/makefile | 4 | ||||
| -rw-r--r-- | dbinit/procedures.sql | 0 | ||||
| -rw-r--r-- | dbinit/views.sql | 28 |
3 files changed, 30 insertions, 2 deletions
diff --git a/dbinit/makefile b/dbinit/makefile index 0e335b7..d412570 100644 --- a/dbinit/makefile +++ b/dbinit/makefile @@ -23,7 +23,7 @@ full: full.sql base.sql: reset.sql init.sql cat $^ > $@ -full.sql: reset.sql init.sql data.sql procedures.sql +full.sql: reset.sql init.sql demo.sql views.sql procedures.sql cat $^ > $@ data.sql: @@ -31,7 +31,7 @@ data.sql: # grant all database permissions (development only) permissions: - echo "grant all privileges on formula1.* to '$(USER)'@'$(HOST)';" | sudo $(SQL) + echo "grant all privileges on formula1.* to '$(USER)'@'$(HOST)';" # delete generated sql files clean: diff --git a/dbinit/procedures.sql b/dbinit/procedures.sql new file mode 100644 index 0000000..e69de29 --- /dev/null +++ b/dbinit/procedures.sql diff --git a/dbinit/views.sql b/dbinit/views.sql new file mode 100644 index 0000000..a995ee6 --- /dev/null +++ b/dbinit/views.sql @@ -0,0 +1,28 @@ +CREATE +VIEW `formula1`.`vwcalendar` AS +SELECT + `calendar`.`year` AS `year`, + `racedate`.`week` AS `week`, + `racedate`.`date` AS `date`, + `circuit`.`name` AS `name` +FROM + (((`calendar` + JOIN `racedate` ON ((`calendar`.`ID` = `racedate`.`calendarID`))) + JOIN `racedatecircuit` ON ((`racedate`.`ID` = `racedatecircuit`.`raceDateID`))) + JOIN `circuit` ON ((`racedatecircuit`.`circuitID` = `circuit`.`ID`))); + + +CREATE +VIEW `formula1`.`vwteamcoureurs` AS +SELECT + `calendar`.`ID` AS `ID`, + `teams`.`teamNumber` AS `teamNumber`, + `teams`.`teamName` AS `teamName`, + `member`.`firstName` AS `firstName`, + `member`.`middleName` AS `middleName`, + `member`.`lastName` AS `lastName` +FROM + (((`calendar` + JOIN `teams` ON ((`calendar`.`ID` = `teams`.`calendarID`))) + JOIN `teamsmember` ON ((`teams`.`ID` = `teamsmember`.`teamsID`))) + JOIN `member` ON ((`teamsmember`.`memberID` = `member`.`ID`))); |