-- phpMyAdmin SQL Dump
-- version 2.8.1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generato il: 29 Gen, 2007 at 11:25 
-- Versione MySQL: 5.0.21
-- Versione PHP: 4.4.2
-- 
-- Database: `bed_and_breakfast`
-- 

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

-- 
-- Struttura della tabella `services`
-- 

DROP TABLE IF EXISTS `services`;
CREATE TABLE IF NOT EXISTS `services` (
  `service_id` int(11) NOT NULL auto_increment,
  `languages_id` int(11) NOT NULL default '4',
  `service_name` varchar(100) NOT NULL,
  `service_img` varchar(100) NOT NULL,
  PRIMARY KEY  (`service_id`,`languages_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;

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

INSERT INTO `services` (`service_id`, `languages_id`, `service_name`, `service_img`) VALUES (1, 4, 'Accesso disabili', 'services_icons/hndcp.gif'),
(2, 4, 'Parcheggio', 'services_icons/park.gif'),
(3, 4, 'Locale climatizzato', 'services_icons/clima.gif'),
(4, 4, 'Giardino', 'services_icons/giardino.gif'),
(5, 4, 'Angolo cottura', 'services_icons/angolo_cottura.gif'),
(6, 4, 'TV in camera', 'services_icons/tv.gif'),
(7, 4, 'Frigo Bar', 'services_icons/frigo.gif'),
(8, 4, 'Internet', 'services_icons/internet.gif');