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',

);