[Treebase-guts] SF.net SVN: treebase:[520] trunk/treebase-core/db

[<vga...@us...>]

Revision: 520
          http://treebase.svn.sourceforge.net/treebase/?rev=520&view=rev
Author:   vgapeyev
Date:     2010-02-26 16:02:32 +0000 (Fri, 26 Feb 2010)

Log Message:
-----------
Patch to add taxonlabel.tb1legacyid field

Modified Paths:
--------------
    trunk/treebase-core/db/init_db_uptodate.pg

Added Paths:
-----------
    trunk/treebase-core/db/patches/0005_add-taxonabel-tb1legacyid.sql

Modified: trunk/treebase-core/db/init_db_uptodate.pg
===================================================================
--- trunk/treebase-core/db/init_db_uptodate.pg	2010-02-25 15:33:06 UTC (rev 519)
+++ trunk/treebase-core/db/init_db_uptodate.pg	2010-02-26 16:02:32 UTC (rev 520)
@@ -8,5 +8,7 @@
 \i patches/0002_drop-geospot_id_sequence.sql
 \i patches/0003_rename-stepmatrixelement-pk.sql
 \i patches/0004_create-indexes.sql
+\i patches/0005_add-taxonabel-tb1legacyid.sql
 
 
+

Added: trunk/treebase-core/db/patches/0005_add-taxonabel-tb1legacyid.sql
===================================================================
--- trunk/treebase-core/db/patches/0005_add-taxonabel-tb1legacyid.sql	                        (rev 0)
+++ trunk/treebase-core/db/patches/0005_add-taxonabel-tb1legacyid.sql	2010-02-26 16:02:32 UTC (rev 520)
@@ -0,0 +1,8 @@
+insert into versionhistory(patchnumber, patchlabel, patchdescription) 
+       values (5, 'add-taxonlabel-tb1legacyid', 
+       'Add tb1legacyid field to the taxonlabel table'); 
+
+alter table taxonlabel add column tb1legacyid varchar(20); 
+
+
+       
\ No newline at end of file


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.