Create Index PrsUsrAccess On AdnPersons (PrsUsrAccess);
Create Index PcsUsrAccess On AdnPictures (PcsUsrAccess);
Create Index MpsUsrAccess On AdnMaps (MpsUsrAccess);
Create Index DcsUsrAccess On AdnDocs (DcsUsrAccess);
Create Index ObjUsrAccess On AdnObjects (ObjUsrAccess);

Create Index PrsGrpAccess On AdnPersons (PrsGrpAccess);
Create Index PcsGrpAccess On AdnPictures (PcsGrpAccess);
Create Index MpsGrpAccess On AdnMaps (MpsGrpAccess);
Create Index DcsGrpAccess On AdnDocs (DcsGrpAccess);
Create Index ObjGrpAccess On AdnObjects (ObjGrpAccess);

Create Index PrsSignature On AdnPersons (PrsSignature);
Create Index PcsSignature On AdnPictures (PcsSignature);
Create Index MpsSignature On AdnMaps (MpsSignature);
Create Index DcsSignature On AdnDocs (DcsSignature);
Create Index ObjSignature On AdnObjects (ObjSignature);

Create Index PrsSurname On AdnPersons (PrsSurName);
Create Index PcsOldSignature On AdnPictures (PcsOldSignature);
Create Index MpsOldSignature On AdnMaps (MpsOldSignature);
Create Index DcsOldSignature On AdnDocs (DcsOldSignature);
Create Index ObjOldSignature On AdnObjects (ObjOldSignature);

Create Index PrsFirstName On AdnPersons (PrsFirstName);
Create Index PcsSorting On AdnPictures (PcsSorting);
Create Index MpsSorting On AdnMaps (MpsSorting);
Create Index DcsSorting On AdnDocs (DcsSorting);
Create Index ObjSorting On AdnObjects (ObjSorting);


Create Index  ObjTitle On AdnObjects (ObjTitle);
Create Index  ObjContains On AdnObjects (ObjContains);
Create Index  ObjContainsAlso On AdnObjects (ObjContainsAlso);
Create Index  ObjAutograph On AdnObjects (ObjAutograph);

Create Index  DcsLocation On AdnDocs (DcsLocation);
Create Index  DcsWhitness On AdnDocs (DcsWhitness);
Create Index  DcsContent On AdnDocs (DcsContent);
Create Index  DcsProofSign On AdnDocs (DcsProofSign);
Create Index  DcsSealDescript On AdnDocs (DcsSealDescript);
Create Index  DcsRegisterHint On AdnDocs (DcsRegisterHint);
Create Index  DcsRemarks On AdnDocs (DcsRemarks);

Create Index  PcsRemarks On AdnPictures (PcsRemarks);
Create Index  PcsSubjects On AdnPictures (PcsSubjects);
Create Index  PcsObjects On AdnPictures (PcsObjects);
Create Index  PcsPhotograph On AdnPictures (PcsPhotograph);
Create Index  PcsOrigin On AdnPictures (PcsOrigin);
Create Index  PcsAbout On AdnPictures (PcsAbout);

Create Index  MpsTitle On AdnMaps (MpsTitle);
Create Index  MpsRemarks On AdnMaps (MpsRemarks);
Create Index  MpsMapKind On AdnMaps (MpsMapKind);
Create Index  MpsCreator On AdnMaps (MpsCreator);
Create Index  MpsLocCreation On AdnMaps (MpsLocCreation);
Create Index  MpsContains On AdnMaps (MpsContains);

Create Index  PrsInstitute On AdnPersons (PrsInstitute);
Create Index  PrsRank On AdnPersons (PrsRank);
Create Index  PrsRemarks On AdnPersons (PrsRemarks);
Create Index  PrsOrigin On AdnPersons (PrsOrigin);

Create Index  PcsSubjects On AdnPictures (PcsSubjects);
Create Index  PcsObjects On AdnPictures (PcsObjects);
Create Index StcTitle On AdnStockDirectory (StcTitle);
Create Index StcTectonix On AdnStockDirectory (StcTectonix);
Create Index StcRepository On AdnStockDirectory (StcRepository);
Create Index StcPrevCreator On AdnStockDirectory (StcPrevCreator);
Create Index StcNextCreator On AdnStockDirectory (StcNextCreator);
Create Index StcCreator On AdnStockDirectory (StcCreator);
Create Index ClsTitle On AdnClasses (ClsTitle);

Alter Table AdnPersons Change column PrsSignature PrsSignature varchar(64);
Alter Table AdnObjects Change column ObjSignature ObjSignature varchar(64);
Alter Table AdnDocs Change Column DcsSignature DcsSignature varchar(64);
Alter Table AdnMaps Change Column MpsSignature MpsSignature varchar(64);
Alter Table AdnPictures Change Column PcsSignature PcsSignature varchar(64);

Alter Table AdnPersons Change column PrsUsrAccess PrsUsrAccess varchar(64);
Alter Table AdnObjects Change column ObjUsrAccess ObjUsrAccess varchar(64);
Alter Table AdnDocs Change Column DcsUsrAccess DcsUsrAccess varchar(64);
Alter Table AdnMaps Change Column MpsUsrAccess MpsUsrAccess varchar(64);
Alter Table AdnPictures Change Column PcsUsrAccess PcsUsrAccess varchar(64);

Alter Table AdnObjects Change column ObjSignature ObjSignature varchar(64);
Alter Table AdnDocs Change Column DcsSignature DcsSignature varchar(64);
Alter Table AdnMaps Change Column MpsSignature MpsSignature varchar(64);
Alter Table AdnPictures Change Column PcsSignature PcsSignature varchar(64);

Alter Table AdnPersons Change column PrsGrpAccess PrsGrpAccess varchar(64);
Alter Table AdnObjects Change column ObjGrpAccess ObjGrpAccess varchar(64);
Alter Table AdnDocs Change Column DcsGrpAccess DcsGrpAccess varchar(64);
Alter Table AdnMaps Change Column MpsGrpAccess MpsGrpAccess varchar(64);
Alter Table AdnPictures Change Column PcsGrpAccess PcsGrpAccess varchar(64);

Alter Table AdnObjects Change column ObjSorting ObjSorting varchar(64);
Alter Table AdnDocs Change Column DcsSorting DcsSorting varchar(64);
Alter Table AdnMaps Change Column MpsSorting MpsSorting varchar(64);
Alter Table AdnPictures Change Column PcsSorting PcsSorting varchar(64);


Optimize Table AdnStockDirectory;
Optimize Table AdnClasses;
Optimize Table AdnObjects;
Optimize Table AdnPersons;
Optimize Table AdnMaps;
Optimize Table AdnDocs;
Optimize Table AdnPictures;

/* --- starten morgen früh  ------*/
Alter Table AdnObjects Change column ObjUsrAccess ObjUsrAccess varchar(64);
Alter Table AdnDocs Change Column DcsUsrAccess DcsUsrAccess varchar(64);
Alter Table AdnMaps Change Column MpsUsrAccess MpsUsrAccess varchar(64);
Alter Table AdnPictures Change Column PcsUsrAccess PcsUsrAccess varchar(64);