-- $Id: se3_internet_tables.sql 4824 2009-11-16 12:38:40Z dbo $
-- MySQL dump 10.11
--
-- Host: localhost    Database: se3db
-- ------------------------------------------------------
-- Server version	5.0.32-Debian_7etch8-log


Use se3db;

/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `squid_plages`
--

DROP TABLE IF EXISTS `squid_plages`;
CREATE TABLE `squid_plages` (
  `id` int(11) NOT NULL auto_increment,
  `nom` varchar(50) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=82 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `squid_plages`
--

INSERT INTO `squid_plages` VALUES (1,'pause'),(4,'cours2'),(5,'cours3'),(6,'cours4'),(7,'cours5'),(8,'soir'),(78,'cours6'),(81,'cours1');

--
-- Table structure for table `squid_horaire`
--

DROP TABLE IF EXISTS `squid_horaire`;
CREATE TABLE `squid_horaire` (
  `id` int(11) NOT NULL auto_increment,
  `id_plage` int(11) NOT NULL,
  `de` varchar(5) default NULL,
  `a` varchar(5) default NULL,
  `jours` varchar(50) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=60 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `squid_horaire`
--

INSERT INTO `squid_horaire` VALUES (59,81,'08:00','09:00','weekly mtwhf'),(2,4,'08:00','12:00','weekly mtwhf'),(3,5,'08:00','13:30','weekly mtwhf'),(4,6,'08:00','15:20','weekly mtwhf'),(5,7,'08:00','17:30','weekly mtwhf'),(6,8,'17:30','23:00','weekly mtwhf'),(7,8,'06:00','08:00','weekly *'),(8,8,'08:00','24:00','weekly saturday'),(9,8,'08:00','23:00','weekly sunday'),(10,1,'09:50','10:10','weekly mtwhf'),(11,1,'12:00','13:30','weekly mtwhf'),(12,1,'15:20','15:40','weekly mtwhf'),(13,1,'17:30','23:00','weekly *'),(14,1,'06:00','08:00','weekly *'),(15,1,'06:00','24:00','weekly saturday'),(16,1,'06:00','23:00','weekly sunday'),(55,78,'08:00','23:00','weekly *');
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40000 ALTER TABLE `params` DISABLE KEYS */;
REPLACE INTO `params` VALUES ('','ipProxySe3Internet','x.x.x.x',0,'adresse IP du proxy','11');
/*!40000 ALTER TABLE `params` ENABLE KEYS */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;


/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2009-01-07 13:07:10