CREATE TABLE IF NOT EXISTS `Rates_Heading` ( `Rates_Heading_ID` int(11) NOT NULL auto_increment, `Rates_Heading` varchar(100) NOT NULL default '', `Rates_Heading_Desc` text NOT NULL, PRIMARY KEY (`Rates_Heading_ID`) ) TYPE=MyISAM; CREATE TABLE IF NOT EXISTS `Rates_Class` ( `Rates_Class_ID` int(11) NOT NULL auto_increment, `Rates_Class` varchar(100) NOT NULL default '', PRIMARY KEY (`Rates_Class_ID`) ) TYPE=MyISAM; CREATE TABLE IF NOT EXISTS `Rates` ( `Rate_ID` int(11) NOT NULL auto_increment, `Rates_Heading_ID` int(11) NOT NULL default '0', `Rates_Class_ID` int(11) NOT NULL default '0', `Number_of_Sessions` varchar(100) NOT NULL default '', `Price` varchar(100) NOT NULL default '', PRIMARY KEY (`Rate_ID`) ) TYPE=MyISAM; CREATE TABLE IF NOT EXISTS `Classes` ( `Class_ID` int(11) NOT NULL auto_increment, `Class_Name` varchar(100) NOT NULL default '', `Description` longtext NOT NULL, PRIMARY KEY (`Class_ID`) ) TYPE=MyISAM; CREATE TABLE IF NOT EXISTS `Continuing_Education` ( `Continuing_Education_ID` int(11) NOT NULL auto_increment, `Workshop_Name` varchar(100) NOT NULL default '', `Description` longtext NOT NULL, PRIMARY KEY (`Continuing_Education_ID`) ) TYPE=MyISAM; CREATE TABLE IF NOT EXISTS `images` ( `imageID` int(11) NOT NULL auto_increment, `Teacher_ID` int(11) NOT NULL default '0', PRIMARY KEY (`imageID`) ) TYPE=MyISAM; CREATE TABLE IF NOT EXISTS `Teachers` ( `Teacher_ID` int(11) NOT NULL auto_increment, `Teacher_Name` varchar(100) NOT NULL default '', `Classes` longtext NOT NULL, `Bio` longtext NOT NULL, PRIMARY KEY (`Teacher_ID`) ) TYPE=MyISAM;