This repository was archived by the owner on Sep 3, 2024. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy pathnuke_db.sql
More file actions
24 lines (24 loc) · 1.24 KB
/
nuke_db.sql
File metadata and controls
24 lines (24 loc) · 1.24 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
DROP TABLE IF EXISTS "portfolio";
DROP TABLE IF EXISTS "transactions";
DROP TABLE IF EXISTS "position";
DROP TABLE IF EXISTS "transaction_type";
DROP TABLE IF EXISTS "historical_marginal_tax_rates";
DROP TABLE IF EXISTS "historical_capital_gains_tax_rates";
DROP TABLE IF EXISTS "daily_stock_data";
DROP TABLE IF EXISTS "portfolio_report";
DROP INDEX IF EXISTS "transactions_position_id_type_index";
DROP INDEX IF EXISTS "position_portfolio_id_index";
DROP INDEX IF EXISTS "transactions_portfolio_id_index";
DROP INDEX IF EXISTS "transactions_portfolio_id_type_index";
DROP INDEX IF EXISTS "transactions_position_id_index";
DROP INDEX IF EXISTS "historical_marginal_tax_rates_tax_year_bracket_threshold_tax_rate_index";
DROP INDEX IF EXISTS "historical_capital_gains_tax_rates_tax_year_bracket_threshold_tax_rate_index";
DROP TABLE IF EXISTS "cpi_data";
DROP INDEX IF EXISTS "daily_stock_data_dividend_amount_index";
DROP INDEX IF EXISTS "daily_stock_data_datetime_index";
DROP INDEX IF EXISTS "daily_stock_data_ticker_index";
DROP TRIGGER IF EXISTS "transactions_position_id_on_update";
DROP TRIGGER IF EXISTS "transactions_position_id_on_insert";
DROP VIEW IF EXISTS "portfolio_balance";
DROP VIEW IF EXISTS "closed_positions";
DROP VIEW IF EXISTS "open_positions";