1.9.1 DB Migration - Message to manually drop columns?

[Unhandled]

Redhat 5.4
XAMPP 1.7.3a

To anyone familiar with upgrading to 1.9.1,

I've been playing with upgrading my TestLink 1.8.5 installation to 1.9.0 or 1.9.1
(1.8.5 -> 1.9.0 (Prague)) No problems.
(1.8.5 -> 1.9.1 (Prague)) One problem:

Here is the output of the webpage that performs the DB migration (URL: /testlink-1.9.1/install/installNewDB.php)

Code: Select all

TestLink setup will now attempt to setup the database:

Creating connection to Database Server:OK!

Connecting to database `testlink`:OK!
Creating Testlink DB user `admin`:OK! (ok - user_exists ok - grant assignment) 
Processing:sql/alter_tables/1.9/mysql/DB.1.3/step1/db_schema_update.sql

-------------------------------------
Data Migration Process STARTED
-------------------------------------
Step - Requirements Migration - STARTED 
Working - Requirements Migration 


Step - Requirements Migration - Finished !!! 

Step - Requirements Specification Migration - STARTED
Working - Requirements Specification Migration
Step - Requirements Migration - Finished !!! 

Step - Test Case Migration - STARTED 
Working - Test Case Migration 
Step - Test Case Migration - Finished !! 

Step - Test Project Options Migration - STARTED
Working - Test Project Options Migration 


**********************************************************************************
******* ATTENTION!!!! *** 
testprojects 
Please DROP Manually COLUMNS with it's constraints (I'm sorry )
'option_reqs','option_priority','option_automation'
**********************************************************************************
Step - Test Project Options Migration - Finished !!! 

Step - User Execution Assignment Migration - STARTED 
Working - User Execution Assignment Migration 
Step - User Execution Assignment Migration - Finished 

Step - Custom Fields (DESIGN TIME) Migration - STARTED 
Working - Custom Fields Migration - Records to process:719
Step - Custom Fields (DESIGN TIME) Migration - Finished !! 


-------------------------------------
Data Migration Process Finished
-------------------------------------

The following message makes me concerned (from output shown above):

Code: Select all

******* ATTENTION!!!! *** 
testprojects 
Please DROP Manually COLUMNS with it's constraints (I'm sorry )
'option_reqs','option_priority','option_automation'

Does this mean I should drop those three columns from the 'testprojects' table? Is it safe for me to do this? Why is this not automated?

Here is the mysql command I use to drop the columns. Please could anyone tell me is this command safe for my TestLink database?

Code: Select all

mysql> ALTER TABLE testprojects DROP COLUMN option_reqs, DROP COLUMN option_priority, DROP COLUMN option_automation;

Thank you!

[fman]

>> Why is this not automated?
Because on other DBMS is not possibile to do this, thane we have asked user to do this simple work manually.

[jenny]

Is the code for dropping the columns this thread provided right?

[Unhandled]

It is correct for a MYSQL database.