-- -- Table structure for table `notes` -- CREATE TABLE `notes` ( `NoteID` int(11) NOT NULL auto_increment, `PhotoID` int(11) NOT NULL, `FlickrID` bigint(20) NOT NULL, `UserNSID` varchar(15) NOT NULL, `UserName` varchar(100) NOT NULL, `X` int(11) NOT NULL, `Y` int(11) NOT NULL, `Width` int(11) NOT NULL, `Height` int(11) NOT NULL, `NoteBody` longtext NOT NULL, PRIMARY KEY (`NoteID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;