----------------------------------------------------------------------
TestLink Open Source Project - http://testlink.sourceforge.net/
$Id: SCHEMA_CHANGES,v 1.8 2008/06/27 08:37:50 franciscom Exp $ 
Author: franciscom
----------------------------------------------------------------------

Schema Changes on TL 1.7.x / 1.8.x 

TL 1.8.0 development - Database version DB 1.2 - 20080102
new tables: api_developer_keys
			events
			transactions
table: executions
       added field execution_type
       added tcversion_number        

table: db_version
       added field notes


TL 1.7.1/1.8.0 development - Database version DB 1.1 - 20071018
column open changed to is_open to avoid reserved word problem in MSSQL
tables: builds, tcversions, testplans

TL 1.7.0 RC 2 - 20070414
table: requirements
       added node_order field

TL 1.7.0 Beta 5 - 20070204
table: priorities
table: risk_assignment
       

TL 1.7.0 Beta 4 - 20070131
table: requirements
       field req_doc_id size increased to 32
       index changed UNIQUE KEY req_doc_id ("srs_id","req_doc_id")


TL 1.7.0 Beta 3 - 20070121
table: builds
       added active and open columns
       see sql scripts for details