InfMos Database, Draft #1

--
-- Database: `infmos`
--

-- --------------------------------------------------------

--
-- Table structure for table `infmos`
--

CREATE TABLE IF NOT EXISTS `infmos` (
  `infmosId` int(11) NOT NULL auto_increment,
  `photosetId` int(11) NOT NULL,
  `mosaicId` int(11) NOT NULL,
  `levels` int(2) NOT NULL,
  PRIMARY KEY  (`infmosId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `mosaic`
--

CREATE TABLE IF NOT EXISTS `mosaic` (
  `mosaicId` int(11) NOT NULL auto_increment,
  `photoId` int(11) NOT NULL,
  `photosetId` int(11) NOT NULL,
  PRIMARY KEY  (`mosaicId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `mosaic-photos`
--

CREATE TABLE IF NOT EXISTS `mosaic-photos` (
  `mosaicId` int(11) NOT NULL,
  `position` int(4) NOT NULL,
  `photoId` int(11) NOT NULL,
  UNIQUE KEY `mosaicId` (`mosaicId`,`position`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `photo`
--

CREATE TABLE IF NOT EXISTS `photo` (
  `photoId` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`photoId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `photoset`
--

CREATE TABLE IF NOT EXISTS `photoset` (
  `photosetId` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`photosetId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `photoset-photos`
--

CREATE TABLE IF NOT EXISTS `photoset-photos` (
  `photosetId` int(11) NOT NULL,
  `photoId` int(11) NOT NULL,
  PRIMARY KEY  (`photosetId`),
  UNIQUE KEY `photosetId` (`photosetId`,`photoId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;