Changes between Version 3 and Version 4 of databaseSchema

Timestamp:

Nov 25, 2013, 2:29:32 PM (10 years ago)

Author:

casties

Comment:

--

databaseSchema

@@ -71 +71 @@
 }}}
 
+
+=== Adding coneids for all members with keys ===
+
+{{{
+insert into keys 
+  (select key, concat('http://pubman.mpiwg-berlin.mpg.de/cone/persons/resource/', key) 
+     from keys right outer join personal_www on key_main = key where key_main is null)
+}}}
+
 ----
 Der Anhang zeigt ein altes Schema