From Openflyers

Contents 1 current SVN 1.1 Introduction 1.2 New/update field check-list 1.3 SQL 2 TODO 2.1 Here are the waiting modification to apply to SVN and database 2.2 Here are the queries to execute to update correctly database

current SVN

Introduction

Here are database modifications not yet implemented in the update 1.3->2.0. and which are compulsory for a correct use of the current SVN release.

New/update field check-list

• ask to the mailing-list the agreement for the new field: name, type (unless it is obvious)
• inform to the mailing-list the creation of the new field with the SQL query to apply (for local bases)
• add new creation/update fields in the update_db.php file and comment the line (to wait)
• add below the SQL query
• add fields modification in the corresponding class file
• DO NOT update local database via à phpymadmin modification, but use update_db.php to do it (in order to validate the update_db.php script)
• WHEN (and not before, not after) the waiting queries are applied in databases, uncomment the update_db.php file new lines

SQL

TODO

Here are the waiting modification to apply to SVN and database

• rename flight_pilot.num to flight_pilot.position
• rename authentication.name to authentication.login

Here are the queries to execute to update correctly database