This page is meant to document the changes in the database scheme between FlightPath 5 and FlightPath 6.

user_settings

• This table has completely changed it's column count and schema.  The new layout (as of the time of this writing) is as follows:
  • CREATE TABLE `user_settings` (
      `user_id` int(11) NOT NULL,
      `timezone` varchar(255) DEFAULT NULL,
      `hide_charts` varchar(255) DEFAULT NULL,
      `default_student_load_tab` varchar(255) DEFAULT NULL,
      `default_notification_method` varchar(255) DEFAULT NULL,
      `image_url` varchar(255) DEFAULT NULL,
      `updated` int(10) unsigned DEFAULT NULL,
      PRIMARY KEY (`user_id`),
      KEY `timezone` (`timezone`),
      KEY `hide_charts` (`hide_charts`),
      KEY `updated` (`updated`),
      KEY `default_student_load_tab` (`default_student_load_tab`),
      KEY `default_notification_method` (`default_notification_method`)
    )

group_requirements and draft_group_requirements

• We have added a new column, named "attributes" varchar (255) after the course_repeats column in both tables.  Default ''  (empty string)

groups and draft_groups

• In both tables, we have added a new column after the "title" column.  It is called "public_notes" and it is a TEXT field, default NULL.

users

• add a new column "last_login" int(10) unsigned default '0' after 'is_disabled' (at the very end)

Schools and school_id 

• One major new change to FlightPath 6 is that many pieces of data now have a "school_id" which can be associated with them.  This allows courses, degrees, users, etc., to be associated with a particular "school".  This can either be a different campus, or a different "school" on campus, like Grad vs. Undergrad.
• The easiest way to prepare your FP5 database (adding these fields and keys), is by making use of the built-in schools module.  
  • Enable the schools module
  • Go to admin console -> Execute PHP
  • Enter:    __schools_add_school_id_to_fp5_tables();
  • Save the form.  This will execute all the queries needed to add the school_id and needed keys to the various tables in FP5.