#!/bin/bash
awk '/^CREATE TABLE IF NOT EXISTS/ { print "DROP TABLE " $6 ";" }' $(dirname $0)/tables.sql
awk '/^CREATE INDEX/ { print "DROP INDEX " $3 ";" }' $(dirname $0)/indexes.sql

#!/bin/bash
awk '/^CREATE TABLE IF NOT EXISTS/ { print "DROP TABLE IF EXISTS " $6 ";" }' $(dirname $0)/tables.sql
awk '/^CREATE INDEX/ { print "DROP INDEX IF EXISTS " $3 ";" }' $(dirname $0)/indexes.sql

Add "if exists" check to drop table and index script
Add "if exists" check to drop table and index script
