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
|
DELETE FROM PatientTable
\g
DELETE FROM StudyTable
\g
DELETE FROM StudyCmpTable
\g
DELETE FROM StudyCmpSeriesTable
\g
DELETE FROM StudyCmpImageTable
\g
DELETE FROM ResultsTable
\g
DELETE FROM InterpretationTable
\g
DELETE FROM StorageCommitReq
\g
DELETE FROM CommitSOPRef
\g
DELETE FROM WorkQueue
\g
DELETE FROM UniqueNumbers
\g
INSERT INTO UniqueNumbers(NumberName, UniqueNumber) VALUES ('PatientID', 1000000)
\g
INSERT INTO UniqueNumbers(NumberName, UniqueNumber) VALUES ('AccessionNumber', 2000000)
\g
INSERT INTO UniqueNumbers(NumberName, UniqueNumber) VALUES ('StudyID', 3000000)
\g
INSERT INTO UniqueNumbers(NumberName, UniqueNumber) VALUES ('ResultsID', 4000000)
\g
INSERT INTO UniqueNumbers(NumberName, UniqueNumber) VALUES ('InterpretationID', 5000000)
\g
|
