Made changes to Kings db
Posted by mholmes on 05 Jul 2011 in Activity log
Made the preliminary changes to the Kings db following the project meeting today. This is the SQL:
/** * Changes to Kings DB made July 2011. **/ /* Add the new field to three tables. */ ALTER TABLE monarchs ADD mn_dateInfo VARCHAR(128) AFTER mn_notAfter; ALTER TABLE refs ADD rf_dateInfo VARCHAR(128) AFTER rf_notAfter; ALTER TABLE sources ADD sc_dateInfo VARCHAR(128) AFTER sc_notAfter; /* Delete the old datePrecision field from the three tables, along with its associated table. */ ALTER TABLE monarchs DROP FOREIGN KEY mn_datePrecision_fk; ALTER TABLE monarchs DROP mn_datePrecision; ALTER TABLE refs DROP FOREIGN KEY rf_datePrecision_fk; ALTER TABLE refs DROP rf_datePrecision; ALTER TABLE sources DROP FOREIGN KEY sc_datePrecision_fk; ALTER TABLE sources DROP sc_datePrecision; DROP TABLE datePrecisions;
Parallel changes were made to local_classes.php.