From 2528bcaf1f76e4a6c40c6aa4d6c72a16d37f9177 Mon Sep 17 00:00:00 2001
From: lonkaars <loek@pipeframe.xyz>
Date: Tue, 7 Mar 2023 19:50:24 +0100
Subject: WIP import script

---
 dbinit/reset.sql | 17 +++++++++++++++++
 1 file changed, 17 insertions(+)
 create mode 100644 dbinit/reset.sql

(limited to 'dbinit/reset.sql')

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`;
-- 
cgit v1.2.3