-- phpMyAdmin SQL Dump
-- version 3.4.10.1deb1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Sep 05, 2013 at 09:50 PM
-- Server version: 5.5.32
-- PHP Version: 5.3.10-1ubuntu3.7

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `tesifer`
--

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

--
-- Table structure for table `Collegamento`
--

CREATE TABLE IF NOT EXISTS `Collegamento` (
  `IdCalling` int(11) NOT NULL,
  `IdCalled` int(11) NOT NULL,
  `Latitude` double NOT NULL,
  `Longitude` double NOT NULL,
  `LatitudeOnLoad` double NOT NULL,
  `LongitudeOnLoad` double NOT NULL,
  PRIMARY KEY (`IdCalling`,`IdCalled`),
  KEY `IdCalled` (`IdCalled`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collegamento`
--

INSERT INTO `Collegamento` (`IdCalling`, `IdCalled`, `Latitude`, `Longitude`, `LatitudeOnLoad`, `LongitudeOnLoad`) VALUES
(1, 2, 0, 284, -6, 50),
(2, 1, -1, 229, -2, 106),
(2, 3, -6, 50, 2, 171),
(3, 2, -5, 349, -1, 229),
(3, 4, 2, 171, 4, 51),
(4, 3, -10, 229, 0, 346),
(4, 5, 4, 51, 1, 50),
(5, 4, -9, 233, 0, 219),
(5, 6, 1, 50, 6, 234),
(6, 5, -3, 45, 5, 230),
(6, 7, 3, 233, 9, 228),
(7, 6, 1, 42, 5, 45),
(7, 8, 9, 228, 2, 43),
(8, 7, 2, 226, 5, 36),
(8, 9, 2, 43, -1, 272),
(9, 8, 2, 96, 3, 220),
(9, 10, 0, 277, -1, 163),
(10, 9, 3, 348, 4, 102),
(10, 11, 1, 171, 3, 194),
(11, 10, 3, 5, 2, 351),
(11, 12, 3, 194, 12, 319),
(12, 11, 2, 127, 0, 0);

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

--
-- Table structure for table `Immagine`
--

CREATE TABLE IF NOT EXISTS `Immagine` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Image` varchar(300) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `Immagine`
--

INSERT INTO `Immagine` (`ID`, `Image`) VALUES
(1, 'corrimano.jpg'),
(2, 'mobile.jpg'),
(3, 'pulpito.jpg');

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

--
-- Table structure for table `ImmaginePerOggetto`
--

CREATE TABLE IF NOT EXISTS `ImmaginePerOggetto` (
  `IdObject` int(11) NOT NULL,
  `IdImage` int(11) NOT NULL,
  PRIMARY KEY (`IdObject`,`IdImage`),
  KEY `IdImage` (`IdImage`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ImmaginePerOggetto`
--

INSERT INTO `ImmaginePerOggetto` (`IdObject`, `IdImage`) VALUES
(1, 1),
(2, 2),
(3, 3);

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

--
-- Table structure for table `Oggetto`
--

CREATE TABLE IF NOT EXISTS `Oggetto` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Object` varchar(300) NOT NULL,
  `MTL` varchar(300) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `Oggetto`
--

INSERT INTO `Oggetto` (`ID`, `Object`, `MTL`) VALUES
(1, 'corrimano.obj', 'corrimano.mtl'),
(2, 'mobile.obj', 'mobile.mtl'),
(3, 'pulpito1.obj', 'pulpito1.mtl');

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

--
-- Table structure for table `OggettoNelPanorama`
--

CREATE TABLE IF NOT EXISTS `OggettoNelPanorama` (
  `IdPanorama` int(11) NOT NULL,
  `IdObject` int(11) NOT NULL,
  `xPosition` double NOT NULL,
  `yPosition` double NOT NULL,
  `zPosition` double NOT NULL,
  PRIMARY KEY (`IdPanorama`,`IdObject`),
  KEY `IdObject` (`IdObject`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `OggettoNelPanorama`
--

INSERT INTO `OggettoNelPanorama` (`IdPanorama`, `IdObject`, `xPosition`, `yPosition`, `zPosition`) VALUES
(1, 1, 0, 3, 10),
(1, 2, -5, -3, 0),
(2, 3, 0, 3, 10);

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

--
-- Table structure for table `Panorama`
--

CREATE TABLE IF NOT EXISTS `Panorama` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Panorama` varchar(300) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;

--
-- Dumping data for table `Panorama`
--

INSERT INTO `Panorama` (`ID`, `Panorama`) VALUES
(1, 'pano1.jpg'),
(2, 'pano2.jpg'),
(3, 'pano3.jpg'),
(4, 'pano4.jpg'),
(5, 'pano5.jpg'),
(6, 'pano6.jpg'),
(7, 'pano7.jpg'),
(8, 'pano8.jpg'),
(9, 'pano9.jpg'),
(10, 'pano10.jpg'),
(11, 'pano11.jpg'),
(12, 'pano12.jpg');

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

--
-- Table structure for table `Testo`
--

CREATE TABLE IF NOT EXISTS `Testo` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Text` varchar(300) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `Testo`
--

INSERT INTO `Testo` (`ID`, `Text`) VALUES
(1, 'DescrizioneCorrimano.txt'),
(2, 'DescrizioneMobile.txt'),
(3, 'DescrizionePulpito.txt');

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

--
-- Table structure for table `TestoPerOggetto`
--

CREATE TABLE IF NOT EXISTS `TestoPerOggetto` (
  `IdObject` int(11) NOT NULL,
  `IdText` int(11) NOT NULL,
  PRIMARY KEY (`IdObject`,`IdText`),
  KEY `IdText` (`IdText`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `TestoPerOggetto`
--

INSERT INTO `TestoPerOggetto` (`IdObject`, `IdText`) VALUES
(1, 1),
(2, 2),
(3, 3);

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
