Revision: 613
http://treebase.svn.sourceforge.net/treebase/?rev=613&view=rev
Author: vgapeyev
Date: 2010-03-16 20:19:32 +0000 (Tue, 16 Mar 2010)
Log Message:
-----------
Set all remaining null phylotree.treetype_id to be the code for 'single' tree.
Modified Paths:
--------------
trunk/treebase-core/db/tb1load/zzFixTreeTypes/scripts/all.sql
Added Paths:
-----------
trunk/treebase-core/db/tb1load/zzFixTreeTypes/scripts/fill_orphan_nulls.sql
Modified: trunk/treebase-core/db/tb1load/zzFixTreeTypes/scripts/all.sql
===================================================================
--- trunk/treebase-core/db/tb1load/zzFixTreeTypes/scripts/all.sql 2010-03-16 20:03:30 UTC (rev 612)
+++ trunk/treebase-core/db/tb1load/zzFixTreeTypes/scripts/all.sql 2010-03-16 20:19:32 UTC (rev 613)
@@ -4,5 +4,6 @@
\i upload_tmp.sql
\i update_treetypes.sql
\i drop_tmp.sql
+\i fill_orphan_nulls.sql
end transaction;
\ No newline at end of file
Added: trunk/treebase-core/db/tb1load/zzFixTreeTypes/scripts/fill_orphan_nulls.sql
===================================================================
--- trunk/treebase-core/db/tb1load/zzFixTreeTypes/scripts/fill_orphan_nulls.sql (rev 0)
+++ trunk/treebase-core/db/tb1load/zzFixTreeTypes/scripts/fill_orphan_nulls.sql 2010-03-16 20:19:32 UTC (rev 613)
@@ -0,0 +1,7 @@
+-- This is a fix to Bill's request to fill all remaining
+-- phylotree.treetype_ids with the code for 'single'
+
+update phylotree
+ set treetype_id = 1
+where treetype_id is null
+returning phylotree_id, tb1_treeid, treetype_id;
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
