LocalLoop-Algorithm/dropschema.sql at master · Pear-Trading/LocalLoop-Algorithm · GitHub

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;