-
Notifications
You must be signed in to change notification settings - Fork 0
/
dropschema.sql
36 lines (27 loc) · 1.31 KB
/
dropschema.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
DROP VIEW IF EXISTS Loops_ViewActive;
DROP INDEX IF EXISTS Loops_IndexTransactionId;
DROP TABLE IF EXISTS Loops;
DROP VIEW IF EXISTS LoopInfo_ViewIncludedInactiveHeuristicDesc;
DROP VIEW IF EXISTS LoopInfo_ViewIncludedInactiveHeuristicAsc;
DROP VIEW IF EXISTS LoopInfo_ViewIncludedInactive;
DROP VIEW IF EXISTS LoopInfo_ViewIncluded;
DROP VIEW IF EXISTS LoopInfo_ViewInactive;
DROP VIEW IF EXISTS LoopInfo_ViewActive;
DROP INDEX IF EXISTS LoopInfo_IndexActive;
DROP TABLE IF EXISTS LoopInfo;
DROP TABLE IF EXISTS CandidateTransactions;
DROP TABLE IF EXISTS BranchedTransactions;
DROP VIEW IF EXISTS CandidateTransactions_ViewIncludedHeuristicDesc;
DROP VIEW IF EXISTS CandidateTransactions_ViewIncludedHeuristicAsc;
DROP VIEW IF EXISTS CandidateTransactions_ViewIncluded;
DROP TABLE IF EXISTS Chains;
DROP TABLE IF EXISTS ChainInfo;
DROP TABLE IF EXISTS LastUserTransaction;
DROP VIEW IF EXISTS ProcessedTransactions_ViewIncludedHeuristicDesc;
DROP VIEW IF EXISTS ProcessedTransactions_ViewIncludedHeuristicAsc;
DROP VIEW IF EXISTS ProcessedTransactions_ViewIncluded;
DROP INDEX IF EXISTS ProcessedTransactions_IndexValue;
DROP INDEX IF EXISTS ProcessedTransactions_IndexToUserId;
DROP INDEX IF EXISTS ProcessedTransactions_IndexFromUserId;
DROP TABLE IF EXISTS ProcessedTransactions;
DROP TABLE IF EXISTS OriginalTransactions;