+----------+-------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------+ | Table | Create Table | +----------+-------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------+ | absences | CREATE TABLE `absences` ( `AbsencesID` int(8) NOT NULL default '0', `StuID` int(8) NOT NULL default '0', `AbsenceDate` datetime NOT NULL default '0000-00-00 00:00:00', `ClassID` int(8) NOT NULL default '0', `AbsenceType` char(1) NOT NULL default '', `AbsenceExcuseID` int(8) NOT NULL default '0', `MinutesLate` int(8) NOT NULL default '0', `TempAbsence` smallint(1) NOT NULL default '0', `ProcessedByEmpID` int(8) default '0', PRIMARY KEY (`AbsencesID`), KEY `StudentId` (`StuID`), KEY `AbsenceExc` (`AbsenceExcuseID`), KEY `FK_Classes` (`ClassID`) ) TYPE=MyISAM | +----------+-------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------+