Changes between Version 2 and Version 3 of databaseSchema

Timestamp:

Oct 24, 2013, 5:27:52 PM (11 years ago)

Author:

casties

Comment:

--

databaseSchema

@@ -22 +22 @@
 
 
+=== Updating to new keys ===
+
+{{{
+update personal_www set id = null
+-- <import ids from xml in Zope>
+-- <use list of additional ids for very old keys>
+create temp table newids (newid text, oldkey text);
+COPY newids FROM '/tmp/additional-ids.txt' delimiter ',';
+update personal_www set id = new.newid from newids "new" where key = new.oldkey;
+
+select key, id from personal_www where id is null or key is null
+
+update personal_www set key = id, id = key;
+
+select pw.key, pw.id, al.link from personal_www "pw", additionallink "al" where pw.key = al.key_main
+
+update additionallink "tbl" set key_main = pw.key 
+ from personal_www "pw" 
+ where lower(pw.id) = lower(tbl.key_main) and pw.key is not null;
+
+update pubmanbiblio "tbl" set key_main = pw.key 
+ from personal_www "pw" 
+ where lower(pw.id) = lower(tbl.key_main) and pw.key is not null;
+
+update talks "tbl" set key_main = pw.key 
+ from personal_www "pw" 
+ where lower(pw.id) = lower(tbl.key_main) and pw.key is not null;
+
+update teaching "tbl" set key_main = pw.key 
+ from personal_www "pw" 
+ where lower(pw.id) = lower(tbl.key_main) and pw.key is not null;
+
+update keys "tbl" set key_main = pw.key 
+ from personal_www "pw" 
+ where lower(pw.id) = lower(tbl.key_main) and pw.key is not null;
+
+update projects_members "tbl" set member_key = pw.key 
+ from personal_www "pw" 
+ where lower(pw.id) = lower(tbl.member_key) and pw.key is not null;
+
+update current_work "tbl" set key_main = pw.key 
+ from personal_www "pw" 
+ where lower(pw.id) = lower(tbl.key_main) and pw.key is not null;
+
+update research_interest "tbl" set key_main = pw.key 
+ from personal_www "pw" 
+ where lower(pw.id) = lower(tbl.key_main) and pw.key is not null;
+}}}
+
 ----
 Der Anhang zeigt ein altes Schema