database schema

Document Preview:

CREATE TABLE IF NOT EXISTS `User` ( `UserId` mediumint(11) NOT NULL AUTO_INCREMENT, `UserName` varchar(50) NOT NULL, `UserPassword` varchar(50) NOT NULL, `UserEmail` varchar(32) NOT NULL, `UserFirstName` varchar(35) NOT NULL, `UserLastName` varchar(35) NOT NULL, `UserToken` varchar(40) NOT NULL DEFAULT '0', `UserRoleType` varchar(32) NOT NULL, `UserGroup` tinyint(1) NOT NULL DEFAULT '1', `UserCreated` datetime DEFAULT '0000-00-00 00:00:00', `UserLastLogin` datetime DEFAULT '0000-00-00 00:00:00', `UserLastIP` varchar(12) DEFAULT '0', `UserActive` enum('y','n','t','b') NOT NULL DEFAULT 'n', PRIMARY KEY (`UserId`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `Image` ( `ImageId` mediumint(11) NOT NULL auto_increment, `ImageName` varchar(35) NOT NULL, `ImageFileSize` int(11) unsigned NOT NULL default '0', `ImagePath` varchar(255) NOT NULL default '', `ImageTag` varchar(255) NOT NULL default '', `ImageTakenBy` varchar(35) NOT NULL, `ImageDateStamp` datetime DEFAULT '0000-00-00 00:00:00', `ImageNote` varchar(100) NOT NULL, `ImageRes_X` int(5) NOT NULL default '0', `ImageRes_Y` int(5) NOT NULL default '0', `ImageStatus` char(1) NOT NULL default 'n', PRIMARY KEY (`ImageId`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `Instrument` ( `InstrumentId` mediumint(11) NOT NULL auto_increment, `InstrumentModel` varchar(50) NOT NULL, `InstrumentSoftware` varchar(50) NOT NULL, `InstrumentExifVersion` varchar(50) NOT NULL, `InstrumentShutterSpeed` varchar(50) NOT NULL, `InstrumentCompression` mediumint(10) NOT NULL, `InstrumentFlashMode` mediumint(32) NOT NULL, `InstrumentISO` varchar(50) NOT NULL, `InstrumentDateStamp` datetime DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`InstrumentId`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;