Stuff

CREATE TABLE `Photos` (`PhotoID` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,`PhotoType` VARCHAR( 10 ) NOT NULL ,`MemberID` INT UNSIGNED NOT NULL ,`Exif_Data` BOOL NOT NULL DEFAULT '0',`Exif_Make` VARCHAR( 100 ) NULL ,`Exif_Model` VARCHAR( 100 ) NULL ,`Exif_ExposureTime` VARCHAR( 100 ) NULL ,`Exif_FNum` VARCHAR( 20 ) NULL ,`Exif_ISORating` VARCHAR( 20 ) NULL ,`Exif_Flash` VARCHAR( 20 ) NULL ,`CategoryID` SMALLINT UNSIGNED NOT NULL ,`HitCount` int UNSIGNED NOT NULL DEFAULT '0',`SaleCount` SMALLINT UNSIGNED NOT NULL DEFAULT '0',`Status` SMALLINT NOT NULL DEFAULT '0',);