leksyib/iReporter

import { Client } from 'pg';
import dotenv from 'dotenv';

dotenv.config();

const client = new Client({
  connectionString: process.env.DATABASE_URL,
});

const creeateTables = async () => {
  await client.connect();
  await client.query('DROP TABLE IF EXISTS users;');
  await client.query('DROP TABLE IF EXISTS records;');
  await client.end();
  console.log('User and Record tables dropped successfully');
  process.exit(0);
};

creeateTables();