aboutsummaryrefslogtreecommitdiff
path: root/dbinit/reset.sql
diff options
context:
space:
mode:
authorlonkaars <loek@pipeframe.xyz>2023-03-07 19:50:24 +0100
committerlonkaars <loek@pipeframe.xyz>2023-03-07 20:12:44 +0100
commit2528bcaf1f76e4a6c40c6aa4d6c72a16d37f9177 (patch)
treea815537a3b3708491b61f30b2dfa7ade21d44e90 /dbinit/reset.sql
parentee88077eb90bc7f7f800fa04e78bf055fc552cd9 (diff)
WIP import script
Diffstat (limited to 'dbinit/reset.sql')
-rw-r--r--dbinit/reset.sql17
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`;