- Implemented schema changes for GPDB based on previous meetings
- Dropped PDB_ from table names to make them shorter and more understandable
- Created all new tables and mapping tables. Adjusted sequencing
- Changed users table to use AXID for key. Associated changes to other tables
- Added synonyms where required
- Updated drop_all.sql to reflected all new tables, views and sequences
- Reorienting gpdb.pm for new database layout
- Initially dropped the projects_by_site view as the new data structures handle this in a different way. Later added the view back this time gathering information from 3 different tables.
- Got convertdb to be able to add users, sites and projects.
- Got gpdb_add_vobs.pl working again in new structure
- Started getting web pages to reveal data in new structures
- Working on gpdb_add_project.pl to accommodate new schema layout
- Changed gpdb_add_project.pl to use sites table instead of a sites file
- Changed -s parm for gpdb_add_project.pl to instead specify a site to process - default being all sites