;On the [Unwanted] section, we specify files that must be DELETED,
;for example, old .VAL files, or old index files.
;
;If such files happen to exist, for example from old installations
;we will get ".VAL out of date" or "index out of date" errors

[Unwanted]
Files=2
File1=Patient.VAL
File2=CartAnamnestica.Val


[Tables] 
Count=70
;File1=Patient.DB
;File2=LastPat.DB
;File3=CartAnamnestica.DB
;File4=Sessions.DB
;File5=LastSession.DB
;File6=History.DB
;File7=LastHist.DB
;File8=PatEconomics.DB
;File9=LastPatEconom.DB
;File10=DentEconomics.DB
;File11=LastDentEconom.DB
;File12=Endo.DB
;File13=LastEndo.DB
;File14=Photos.DB
;File15=LastPhoto.DB
;File16=Peri.DB
;File17=LastPeri.DB
;File18=PeriItem.DB
;File19=LastPeriItem.DB
;File20=ToothColor.DB
;File21=ToothNotes.DB
;File22=Suppliers.DB
;File23=LastSupl.DB
;File24=MaterialDB.DB
;File25=MaterialOrders.DB
;File26=LastMaterialOrder.DB
;File27=MaterialOrderItems.DB
;File28=LastMaterialOrderItem.DB
;File29=DentalLabDB.DB
;File30=LabOrders.DB
;File31=LastLabOrder.DB
;File32=LabOrderItems.DB
;File33=LastLabOrderItem.DB
;File34=Doctors.DB
;File35=Medicines.DB
;File36=LastMedicines.DB
;File37=Prescriptions.DB
;File38=LastPrescription.DB
;File39=PrescrItems.DB
;File40=LastPrescrItem.DB
;File41=Cities.DB
;File42=LastCity.DB
;File43=InsurCompanies.DB
;File44=LastInsCompanies.DB
;File45=NameDays.DB
;File46=LastNameDay.DB
;File47=Phones.DB
;File48=LastPhone.DB
;File49=Reminders.DB
;File50=LastReminder.DB
;File51=Operations.DB
;File52=LastOper.DB
;File53=Appointments.DB
;File54=LastApp.DB
;File55=SuppliersPerMaterial.DB
;File56=LastSupPerMaterial.DB
;File57=Families.DB
;File58=QuestTemplate.DB
;File59=QuestAnswer.DB
;File60=BSLog.DB
;File61=LastBSLog.DB
;File62=Recalls.DB
;File63=LastRecalls.DB

File1=Appointments.DB
File2=AppointmentTypes.DB
File3=BSLog.DB
File4=CartAnamnestica.DB
File5=Cities.DB
File6=DentalLabDB.DB
File7=DentEconomics.DB
File8=Doctors.DB
File9=Endo.DB
File10=Families.DB
File11=History.DB
File12=InsurCompanies.DB
File13=LabOrderItems.DB
File14=LabOrders.DB
File15=LastApp.DB
File16=LastBSLog.DB
File17=LastCity.DB
File18=LastDentEconom.DB
File19=LastDentLab.db
File20=LastDoctor.db
File21=LastEndo.DB
File22=LastHist.DB
File23=LastInsCompanies.DB
File24=LastLabOrder.DB
File25=LastLabOrderItem.DB
File26=LastMaterial.DB
File27=LastMaterialOrder.DB
File28=LastMaterialOrderItem.DB
File29=LastMedicines.DB
File30=LastNameDay.DB
File31=LastOper.DB
File32=LastPat.DB
File33=LastPatEconom.DB
File34=LastPeri.DB
File35=LastPeriItem.DB
File36=LastPhone.DB
File37=LastPhoto.DB
File38=LastPrescription.DB
File39=LastPrescrItem.DB
File40=LastRecalls.DB
File41=LastReminder.DB
File42=LastSession.DB
File43=LastSupl.DB
File44=LastSupPerMaterial.DB
File45=MaterialDB.DB
File46=MaterialOrderItems.DB
File47=MaterialOrders.DB
File48=Medicines.DB
File49=NameDays.DB
File50=Operations.DB
File51=PatBook.DB
File52=PatEconomics.DB
File53=Patient.DB
File54=Peri.DB
File55=PeriItem.DB
File56=Phones.DB
File57=Photos.DB
File58=PhysSystems.DB
File59=Prescriptions.DB
File60=PrescrItems.DB
File61=ProgNotes.DB
File62=QuestAnswer.DB
File63=QuestTemplate.DB
File64=Recalls.DB
File65=Reminders.DB
File66=Sessions.DB
File67=Suppliers.DB
File68=SuppliersPerMaterial.DB
File69=ToothColor.DB
File70=ToothNotes.DB

;
;Index Sections Format:
;
;[File<filename.DB>]   <-- An entry for this filename MUST exist in the [Tables] section
;Primary= 1 or 0       <--- Does this table have a primary Index?
;P=<indexfield1>;...;<indexfieldm> <--This is optional. Only if you want to specify your 
;                                     Primary Key. OtherWise, the primary key consists only 
;                                     of the first field.
;Secondaries= n        <--- number of secondary indexes  
;S1=<indexname>:<indexfield1>;...;<indexfieldm>:<indexoption1>;...;<indexoptionk>
;S2=...
;...
;Sn=...
; 
;Index options can be:
;  ixUnique             -- The index must be unique for each record
;  ixDescending		-- The records are indexed in descending order
;  ixNonMaintained	-- Index is not maintained
;  ixCaseInsensitive	-- Index is case insensitive.Should usually exist
;
;

[FilePatient.DB]
Primary=1
Secondaries=2
S1=LastNames:LastName;FirstName:ixCaseInsensitive
S2=PatCategoryIdx:PatientCategory:ixCaseInsensitive

[FileLastPat.DB]
Primary=1
Secondaries=0

[FileCartAnamnestica.DB]
Primary=1
Secondaries=0

[FileSessions.DB]
Primary=1
Secondaries=1
S1=byPatient:PatientID;SessionNum:ixCaseInsensitive;ixDescending

[FileLastSession.DB]
Primary=1
Secondaries=0

[FileHistory.DB]
Primary=1
Secondaries=5
S1=PatToothIDs:PatientID;ToothNum;Date;ID:ixCaseInsensitive
S2=PatIDs:PatientID:ixCaseInsensitive
S3=homer:PatientID;Date;ID:ixCaseInsensitive;ixDescending
s4=by Lab:DentalLabID;DentistID;Date;PatientID:ixCaseInsensitive
S5=By Session:TherapySessionID;DentistID;Date:ixCaseInsensitive

[FileLastHist.DB]
Primary=1
Secondaries=0

[FilePatEconomics.DB]
Primary=1
Secondaries=3
S1=By Session:SessionID;Date:ixCaseInsensitive
S2=homer:PatientID;Date;EconomID:ixCaseInsensitive;ixDescending
S3=customerids:PatientID;Date:ixCaseInsensitive;ixDescending

[FileLastPatEconom.DB]
Primary=1
Secondaries=0

[FileDentEconomics.DB]
Primary=1
Secondaries=4
S1=By Supplier:SupplierID;Date:ixCaseInsensitive
S2=By Lab:LabID;Date:ixCaseInsensitive
s3=By Date:Date:ixCaseInsensitive
s4=DescIdx:Description:ixCaseInsensitive

[FileLastDentEconom.DB]
Primary=1
Secondaries=0

[FileEndo.DB]
Primary=1
Secondaries=2
S1=By Patient:PatientID;Date:ixCaseInsensitive
S2=By Session:SessionID:ixCaseInsensitive

[FileLastEndo.DB]
Primary=1
Secondaries=0

[FilePhotos.DB]
Primary=1
Secondaries=3
S1=By Session:SessionID:ixCaseInsensitive
S2=PatIDs:PatID:ixCaseInsensitive
S3=Complex:PatID;ID:ixCaseInsensitive

[FileLastPhoto.DB]
Primary=1
Secondaries=0

[FilePeri.DB]
Primary=1
Secondaries=1
S1=By Session:SessionID;Date:ixCaseInsensitive
S2=By Patient:PatientID:ixCaseInsensitive

[FileLastPeri.DB]
Primary=1
Secondaries=0

[FilePeriItem.DB]
Primary=1
Secondaries=1
S1=By Peri:PeriID:ixCaseInsensitive

[FileLastPeriItem.DB]
Primary=1
Secondaries=0

[FileToothColor.DB]
Primary=1
P=SessionID;ToothNum
Secondaries=1
S1=By Patient:PatientID:ixCaseInsensitive

[FileToothNotes.DB]
Primary=1
P=SessionID;ToothNum
Secondaries=0

[FileSuppliers.DB]
Primary=1
Secondaries=1
S1=By Name:Company:ixCaseInsensitive

[FileLastSupl.DB]
Primary=1
Secondaries=0

[FileMaterialDB.DB]
Primary=1
Secondaries=1
S1=DescIdx:Description:ixCaseInsensitive

[FileMaterialOrders.DB]
Primary=1
Secondaries=1
S1=By Supplier:SupplierID;Date:ixCaseInsensitive

[FileLastMaterialOrder.DB]
Primary=1
Secondaries=0

[FileMaterialOrderItems.DB]
Primary=1
Secondaries=1
S1=by Order:OrderID;ItemID:ixCaseInsensitive

[FileLastMaterialOrderItem.DB]
Primary=1
Secondaries=0

[FileDentalLabDB.DB]
Primary=1
Secondaries=0

[FileLabOrders.DB]
Primary=1
Secondaries=1
S1=By Lab:LabID;Date:ixCaseInsensitive

[FileLastLabOrder.DB]
Primary=1
Secondaries=0

[FileLabOrderItems.DB]
Primary=1
Secondaries=1
S1=By Order:OrderID:ixCaseInsensitive

[FileLastLabOrderItem.DB]
Primary=1
Secondaries=0

[FileDoctors.DB]
Primary=1
Secondaries=0

[FileMedicines.DB]
Primary=1
Secondaries=0

[FileLastMedicines.DB]
Primary=1
Secondaries=0

[FilePrescriptions.DB]
Primary=1
Secondaries=1
S1=PrescriptionsPatID:PatientID:ixCaseInsensitive

[FileLastPrescription.DB]
Primary=1
Secondaries=0

[FilePrescrItems.DB]
Primary=1
Secondaries=1
S1=By Prescription:PrescriptionID;PrescrItemID:ixCaseInsensitive

[FileLastPrescrItem.DB]
Primary=1
Secondaries=0

[FileCities.DB]
Primary=1
Secondaries=0

[FileLastCity.DB]
Primary=1
Secondaries=0

[FileInsurCompanies.DB]
Primary=1
Secondaries=0

[FileLastInsCompanies.DB]
Primary=1
Secondaries=0

[FileNameDays.DB]
Primary=1
Secondaries=0

[FileLastNameDay.DB]
Primary=1
Secondaries=0

[FilePhones.DB]
Primary=1
Secondaries=1
S1=By Name:LastName;FirstName;FatherName:ixCaseInsensitive

[FileLastPhone.DB]
Primary=1
Secondaries=0

[FileReminders.DB]
Primary=1
Secondaries=0

[FileLastReminder.DB]
Primary=1
Secondaries=0

[FileOperations.DB]
Primary=1
Secondaries=1
S1=DescIdx:Description:ixCaseInsensitive

[FileLastOper.DB]
Primary=1
Secondaries=0

[FileAppointments.DB]
Primary=1
Secondaries=0

[FileLastApp.DB]
Primary=1
Secondaries=0

[FileSuppliersPerMaterial.DB]
Primary=1
Secondaries=2
S1=By Supplier:SupplierID:ixCaseInsensitive
S2=By Material:MaterialID:ixCaseInsensitive

[FileLastSupPerMaterial.DB]
Primary=1
Secondaries=0

[FileFamilies.DB]
Primary=1
P=FatherID;ChildID
Secondaries=2
S1=By Child:ChildID:ixCaseInsensitive
S2=By Father:FatherID:ixCaseInsensitive

[FileQuestTemplate.DB]
Primary=1
P=FatherQuestionID;QuestionID
Secondaries=1
s1=By FatherQuestion:FatherQuestionID:ixCaseInsensitive

[FileQuestAnswer.DB]
Primary=1
P=PatientID;QuestionID;FatherQuestionID
Secondaries=1
S1=By FatherQuestion:FatherQuestionID:ixCaseInsensitive

[FileBSLog.DB]
Primary=1
Secondaries=0

[FileLastBSLog.DB]
Primary=1
Secondaries=0

[FileRecalls.DB]
Primary=1
Secondaries=1
S1=ByPatient:PatientID;RecallDate:ixCaseInsensitive

[FileLastRecalls.DB]
Primary=1
Secondaries=0

[FileDentalLab.DB]
Primary=0
Secondaries=0

[FileLastDentLab.DB]
Primary=1
Secondaries=0

[FileLastDoctor.DB]
Primary=1
Secondaries=0

[FileLastMaterial.DB]
Primary=1
Secondaries=0

[FileLastRecalls.DB]
Primary=0
Secondaries=0

[FileAppointmentTypes.DB]
Primary=1
Secondaries=0

[FileLastDoctor.DB]
Primary=1
Secondaries=0

[FilePatBook.DB]
Primary=1
Secondaries=1
s1=PatIdx:PatientID:ixCaseInsensitive

[FilePhysSystems.DB]
Primary=1
Secondaries=0

[FileProgNotes.DB]
Primary=1
Secondaries=1
s1=ProgNotes_PatSesIdx:PatientID;SessionID:ixCaseInsensitive


