-- phpMyAdmin SQL Dump
-- version 3.4.9
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generato il: Apr 07, 2025 alle 00:50
-- Versione del server: 5.5.19
-- Versione PHP: 5.4.0RC4

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: `canili`
--

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

--
-- Struttura della tabella `cani`
--

CREATE TABLE IF NOT EXISTS `cani` (
  `idcane` int(11) NOT NULL AUTO_INCREMENT,
  `nome` varchar(30) DEFAULT NULL,
  `codrazza` int(11) DEFAULT NULL,
  `codcanile` int(11) DEFAULT NULL,
  `nascita` date DEFAULT NULL,
  `peso` double DEFAULT NULL,
  PRIMARY KEY (`idcane`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;

--
-- Dump dei dati per la tabella `cani`
--

INSERT INTO `cani` (`idcane`, `nome`, `codrazza`, `codcanile`, `nascita`, `peso`) VALUES
(1, 'fido', 8, 105, '2020-01-06', 20.3),
(2, 'rocky', 6, 110, '2020-02-18', 18.4),
(3, 'gerardo', 3, 107, '2020-02-01', 12.5),
(4, 'bruno', 7, 111, '2019-11-16', 22.7),
(5, 'simba', 5, 102, '2020-04-10', 32.3),
(6, 'toledo', 6, 109, '2019-12-27', 15.6),
(7, 'polly', 6, 104, '2019-12-20', 13.2),
(8, 'ambra', 5, 102, '2019-12-15', 28.1),
(9, 'polpetta', 2, 109, '2020-01-03', 25.4),
(10, 'sally', 1, 103, '2020-01-31', 27.2),
(11, 'ermes', 2, 105, '2020-04-01', 12.5),
(12, 'bomba', 6, 106, '2019-11-19', 22.8),
(13, 'gelso', 7, 108, '2020-05-10', 32.3),
(14, 'hummy', 3, 100, '2019-12-20', 15.9),
(15, 'cappero', 3, 104, '2019-10-20', 13.5);

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

--
-- Struttura della tabella `canili`
--

CREATE TABLE IF NOT EXISTS `canili` (
  `idcanile` int(11) NOT NULL,
  `canile` varchar(50) DEFAULT NULL,
  `indirizzo` varchar(50) DEFAULT NULL,
  `comune` varchar(50) DEFAULT NULL,
  `provincia` char(2) DEFAULT NULL,
  `tel` varchar(15) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`idcanile`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dump dei dati per la tabella `canili`
--

INSERT INTO `canili` (`idcanile`, `canile`, `indirizzo`, `comune`, `provincia`, `tel`, `email`) VALUES
(100, 'Dogs', 'Via Martiri 9', 'Novara', 'NO', '0321xxx', 'dogs@gmail.com'),
(101, 'Dylan Dogs', 'Via dei Fiori 17', 'Borgomanero', 'NO', '0322xxx', 'dylandogs@hotmail.com'),
(102, 'La casa del cane', 'Via Mazzini 108', 'Torino', 'TO', '011xxx', 'casadelcane@gmail.com'),
(103, 'A tutto cane', 'Via Bisceglie 34', 'Novara', 'NO', '0321xxx', 'atuttocane@hotmail.com'),
(104, 'Dog House', 'Via De Amicis 9', 'Alessandria', 'AL', '02xxx', 'info@doghouse.it'),
(105, 'dog 4 all', 'Via Palestro 27', 'Torino', 'TO', '011xxx', 'dog4all@hotmail.com'),
(106, 'CanCan', 'Via Scarpa 98', 'Arona', 'NO', '0322xxx', 'info@cancan.it'),
(107, 'Save the dog', 'Via Resega 76', 'Biella', 'BI', '017xxx', 'savethedog@gmail.com'),
(108, 'Hound dog', 'Via Odessa 45', 'Torino', 'TO', '011xxx', 'hounddog@gmail.com'),
(109, 'dog joy', 'Via Roma 138', 'Vercelli', 'VC', '015xxx', 'info@dogjoy.com'),
(110, 'dog''s paradise', 'Via Keplero 29', 'Verbania', 'VB', '0324xxx', 'dogsparadise@hotmail.com'),
(111, 'la canea', 'Via Torino 37', 'Asti', 'AT', '014xxx', 'info@lacanea.it'),
(112, 'Faccia di cane', 'Via Montenero 14', 'Arona', 'NO', '0322xxx', 'info@facciadicane.it');

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

--
-- Struttura della tabella `razze`
--

CREATE TABLE IF NOT EXISTS `razze` (
  `idrazza` int(11) NOT NULL AUTO_INCREMENT,
  `razza` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`idrazza`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

--
-- Dump dei dati per la tabella `razze`
--

INSERT INTO `razze` (`idrazza`, `razza`) VALUES
(1, 'Incrocio'),
(2, 'Alano'),
(3, 'Mastino'),
(4, 'Pit Bull'),
(5, 'Pinscher'),
(6, 'Cocker'),
(7, 'Collie'),
(8, 'Volpino'),
(9, 'Yorkshire'),
(10, 'Pastore'),
(11, 'Setter');

/*!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 */;