[Summary view] [Print] [Text view]

   1  -- $Id: se3_internet_tables.sql 4824 2009-11-16 12:38:40Z dbo $
   2  -- MySQL dump 10.11
   3  --
   4  -- Host: localhost    Database: se3db
   5  -- ------------------------------------------------------
   6  -- Server version    5.0.32-Debian_7etch8-log
   7  
   8  
   9  Use se3db;
  10  
  11  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  12  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  13  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  14  /*!40101 SET NAMES utf8 */;
  15  /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  16  /*!40103 SET TIME_ZONE='+00:00' */;
  17  /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  18  /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  19  /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  20  /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  21  
  22  --
  23  -- Table structure for table `squid_plages`
  24  --
  25  
  26  DROP TABLE IF EXISTS `squid_plages`;
  27  CREATE TABLE `squid_plages` (
  28    `id` int(11) NOT NULL auto_increment,
  29    `nom` varchar(50) NOT NULL,
  30    PRIMARY KEY  (`id`)
  31  ) ENGINE=MyISAM AUTO_INCREMENT=82 DEFAULT CHARSET=latin1;
  32  
  33  --
  34  -- Dumping data for table `squid_plages`
  35  --
  36  
  37  INSERT INTO `squid_plages` VALUES (1,'pause'),(4,'cours2'),(5,'cours3'),(6,'cours4'),(7,'cours5'),(8,'soir'),(78,'cours6'),(81,'cours1');
  38  
  39  --
  40  -- Table structure for table `squid_horaire`
  41  --
  42  
  43  DROP TABLE IF EXISTS `squid_horaire`;
  44  CREATE TABLE `squid_horaire` (
  45    `id` int(11) NOT NULL auto_increment,
  46    `id_plage` int(11) NOT NULL,
  47    `de` varchar(5) default NULL,
  48    `a` varchar(5) default NULL,
  49    `jours` varchar(50) NOT NULL,
  50    PRIMARY KEY  (`id`)
  51  ) ENGINE=MyISAM AUTO_INCREMENT=60 DEFAULT CHARSET=latin1;
  52  
  53  --
  54  -- Dumping data for table `squid_horaire`
  55  --
  56  
  57  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 *');
  58  /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
  59  
  60  /*!40000 ALTER TABLE `params` DISABLE KEYS */;
  61  REPLACE INTO `params` VALUES ('','ipProxySe3Internet','x.x.x.x',0,'adresse IP du proxy','11');
  62  /*!40000 ALTER TABLE `params` ENABLE KEYS */;
  63  /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
  64  
  65  
  66  /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  67  /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  68  /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  69  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  70  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  71  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  72  /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  73  
  74  -- Dump completed on 2009-01-07 13:07:10