E9DpG7zz

1--
2-- Database: `infmos`
3--
4
5-- --------------------------------------------------------
6
7--
8-- Table structure for table `infmos`
9--
10
11CREATE TABLE IF NOT EXISTS `infmos` (
12  `infmosId` int(11) NOT NULL auto_increment,
13  `photosetId` int(11) NOT NULL,
14  `mosaicId` int(11) NOT NULL,
15  `levels` int(2) NOT NULL,
16  PRIMARY KEY  (`infmosId`)
17) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
18
19-- --------------------------------------------------------
20
21--
22-- Table structure for table `mosaic`
23--
24
25CREATE TABLE IF NOT EXISTS `mosaic` (
26  `mosaicId` int(11) NOT NULL auto_increment,
27  `photoId` int(11) NOT NULL,
28  `photosetId` int(11) NOT NULL,
29  PRIMARY KEY  (`mosaicId`)
30) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
31
32-- --------------------------------------------------------
33
34--
35-- Table structure for table `mosaic-photos`
36--
37
38CREATE TABLE IF NOT EXISTS `mosaic-photos` (
39  `mosaicId` int(11) NOT NULL,
40  `position` int(4) NOT NULL,
41  `photoId` int(11) NOT NULL,
42  UNIQUE KEY `mosaicId` (`mosaicId`,`position`)
43) ENGINE=MyISAM DEFAULT CHARSET=latin1;
44
45-- --------------------------------------------------------
46
47--
48-- Table structure for table `photo`
49--
50
51CREATE TABLE IF NOT EXISTS `photo` (
52  `photoId` int(11) NOT NULL auto_increment,
53  PRIMARY KEY  (`photoId`)
54) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
55
56-- --------------------------------------------------------
57
58--
59-- Table structure for table `photoset`
60--
61
62CREATE TABLE IF NOT EXISTS `photoset` (
63  `photosetId` int(11) NOT NULL auto_increment,
64  PRIMARY KEY  (`photosetId`)
65) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
66
67-- --------------------------------------------------------
68
69--
70-- Table structure for table `photoset-photos`
71--
72
73CREATE TABLE IF NOT EXISTS `photoset-photos` (
74  `photosetId` int(11) NOT NULL,
75  `photoId` int(11) NOT NULL,
76  PRIMARY KEY  (`photosetId`),
77  UNIQUE KEY `photosetId` (`photosetId`,`photoId`)
78) ENGINE=MyISAM DEFAULT CHARSET=latin1;