Login
jblu

jblu / Unmanic database file scripts

Last active 6 months ago

Like 0

jblu revised this gist 2 years ago · 17147c6

No changes

jblu revised this gist 2 years ago · e2c1560

2 files changed, 20 insertions

delete.sql (file created)
@@ -0,0 +1,10 @@
1 + DELETE FROM historictaskprobe
2 + WHERE EXISTS (
3 + SELECT 1 FROM historictaskprobe p2
4 + WHERE historictaskprobe.size = p2.size
5 + AND historictaskprobe.basename = p2.basename
6 + AND historictaskprobe.abspath = p2.abspath
7 + AND historictaskprobe.size = p2.size
8 + AND historictaskprobe.type = p2.type
9 + AND historictaskprobe.historictask_id > p2.historictask_id
10 + );
select.sql (file created)
@@ -0,0 +1,10 @@
1 + SELECT * FROM historictaskprobe
2 + WHERE EXISTS (
3 + SELECT 1 FROM historictaskprobe p2
4 + WHERE historictaskprobe.size = p2.size
5 + AND historictaskprobe.basename = p2.basename
6 + AND historictaskprobe.abspath = p2.abspath
7 + AND historictaskprobe.size = p2.size
8 + AND historictaskprobe.type = p2.type
9 + AND historictaskprobe.historictask_id > p2.historictask_id
10 + );