ALTER TABLE Objects
ADD PRIMARY KEY (PrimaryKey_Object_Table),
ADD INDEX (Accession_Full_ID),
ADD INDEX (ItemType),
ADD INDEX (ItemName),
ADD INDEX (SourceName);
ALTER TABLE Sources
ADD PRIMARY KEY (SourceID),
ADD INDEX (SourceName);

ALTER TABLE LocationHistory
ADD PRIMARY KEY (LocationHistoryID),
ADD INDEX (PrimaryKey_Object_Table),
ADD INDEX (LocationStatus),
ADD INDEX (LocationDate);

ALTER TABLE Objects
ADD PRIMARY KEY (PrimaryKey_Object_Table),
ADD INDEX (Accession_Full_ID),
ADD INDEX (ItemType),
ADD INDEX (ItemName),
ADD INDEX (SourceName),
ADD INDEX (VisualCondition),
ADD INDEX (PhysicalCondition),
ADD INDEX (ConditionOnReceipt);

ALTER TABLE Sources
ADD PRIMARY KEY (SourceID),
ADD INDEX (SourceName);

ALTER TABLE LocationHistory
ADD PRIMARY KEY (LocationHistoryID),
ADD INDEX (PrimaryKey_Object_Table),
ADD INDEX (LocationStatus),
ADD INDEX (LocationDate);

ALTER TABLE ReceiptConditions
ADD PRIMARY KEY (SequenceOnForm),
ADD INDEX (`Condition`),
ADD INDEX (`ConditionDescription`);

Add indexes to speed up condition lookups
Add indexes to speed up condition lookups
