-- -- Table structure for table `photos` -- CREATE TABLE `photos` ( `PhotoID` int(11) NOT NULL auto_increment, `FlickrID` int(11) NOT NULL default '0', `Title` varchar(250) NOT NULL, `Description` longtext NOT NULL, `DateTaken` datetime NOT NULL, `DateCreated` datetime NOT NULL, `File` varchar(100) NOT NULL, `Public` tinyint(1) NOT NULL default '1', `Longitude` decimal(16,8) NOT NULL default '0.00000000', `Latitude` decimal(16,8) NOT NULL default '0.00000000', PRIMARY KEY (`PhotoID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `tags` -- CREATE TABLE `tags` ( `TagID` int(11) NOT NULL auto_increment, `PhotoID` int(11) NOT NULL, `Tag` varchar(100) NOT NULL, `MachineTag` tinyint(1) NOT NULL default '0', PRIMARY KEY (`TagID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;