Changes between Version 5 and Version 6 of DatabaseCleanup

Timestamp:

Aug 3, 2016, 9:34:07 AM (8 years ago)

Author:

casties

Comment:

--

DatabaseCleanup

@@ -75 +75 @@
 order by rel.id;
 }}}
+
+The number of attributes without source_id (where a different version has a source_id) grouped by source object type.
+{{{
+select count(*), source_obj_class from openmind.node
+where 
+node_type = 'ATTRIBUTE'
+and 
+source_id is not null
+and id in
+(select distinct id from openmind.node
+where source_id is null
+and node_type = 'ATTRIBUTE')
+group by source_obj_class
+}}}