diff options
author | lonkaars <loek@pipeframe.xyz> | 2023-03-07 19:50:24 +0100 |
---|---|---|
committer | lonkaars <loek@pipeframe.xyz> | 2023-03-07 20:12:44 +0100 |
commit | 2528bcaf1f76e4a6c40c6aa4d6c72a16d37f9177 (patch) | |
tree | a815537a3b3708491b61f30b2dfa7ade21d44e90 /dbinit/reset.sql | |
parent | ee88077eb90bc7f7f800fa04e78bf055fc552cd9 (diff) |
WIP import script
Diffstat (limited to 'dbinit/reset.sql')
-rw-r--r-- | dbinit/reset.sql | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/dbinit/reset.sql b/dbinit/reset.sql new file mode 100644 index 0000000..b11d723 --- /dev/null +++ b/dbinit/reset.sql @@ -0,0 +1,17 @@ +drop schema if exists `formula1`; +drop table if exists `formula1`.`calendar`; +drop table if exists `formula1`.`circuit`; +drop table if exists `formula1`.`function`; +drop table if exists `formula1`.`member`; +drop table if exists `formula1`.`specialposition`; +drop table if exists `formula1`.`endposition`; +drop table if exists `formula1`.`fastestlap`; +drop table if exists `formula1`.`racetype`; +drop table if exists `formula1`.`racedate`; +drop table if exists `formula1`.`race`; +drop table if exists `formula1`.`endpositionrace`; +drop table if exists `formula1`.`nationality`; +drop table if exists `formula1`.`membernationality`; +drop table if exists `formula1`.`racedatecircuit`; +drop table if exists `formula1`.`teams`; +drop table if exists `formula1`.`teamsmember`; |