-- MySQL dump 10.11
--
-- Host: localhost    Database: reserva
-- ------------------------------------------------------
-- Server version	5.0.32-Debian_7etch10-log

/*!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 `adescam_area`
--

DROP TABLE IF EXISTS `adescam_area`;
CREATE TABLE `adescam_area` (
  `id` int(11) NOT NULL auto_increment,
  `area_name` varchar(30) default NULL,
  `area_admin_email` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `adescam_area`
--

LOCK TABLES `adescam_area` WRITE;
/*!40000 ALTER TABLE `adescam_area` DISABLE KEYS */;
INSERT INTO `adescam_area` VALUES (1,'Adescam',NULL);
/*!40000 ALTER TABLE `adescam_area` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `adescam_entry`
--

DROP TABLE IF EXISTS `adescam_entry`;
CREATE TABLE `adescam_entry` (
  `id` int(11) NOT NULL auto_increment,
  `start_time` int(11) NOT NULL default '0',
  `end_time` int(11) NOT NULL default '0',
  `entry_type` int(11) NOT NULL default '0',
  `repeat_id` int(11) NOT NULL default '0',
  `room_id` int(11) NOT NULL default '1',
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `create_by` varchar(80) NOT NULL default '',
  `name` varchar(80) NOT NULL default '',
  `type` char(1) NOT NULL default 'E',
  `description` text,
  PRIMARY KEY  (`id`),
  KEY `idxStartTime` (`start_time`),
  KEY `idxEndTime` (`end_time`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `adescam_entry`
--

LOCK TABLES `adescam_entry` WRITE;
/*!40000 ALTER TABLE `adescam_entry` DISABLE KEYS */;
INSERT INTO `adescam_entry` VALUES (1,1229247000,1229333400,0,0,1,'2008-11-10 16:00:50','leonello','ConfraternizaÃ§Ã£o Fecilcam dia Todo','I','InformaÃ§Coes com a Bety que esta organizando tudo.'),(2,1228649400,1228653000,0,0,1,'2008-11-14 13:26:58','leonello','AlmoÃ§o Cristina','I',''),(3,1230802200,1230805800,0,0,1,'2008-11-14 13:28:38','leonello','ConfraternizaÃ§Ã£o Igreja Maranata','I',''),(4,1228469400,1228473000,0,0,1,'2008-11-14 13:29:14','leonello','ConfraternizaÃ§Ã£o Universidade Sem Fronteiras','I',''),(5,1229164200,1229167800,0,0,1,'2008-11-14 13:35:51','leonello','Jantar Beneficiente Cristina','I',''),(8,1240155000,1240173000,0,0,1,'2009-03-06 12:54:26','jesus','Marina FranÃ§a Leite','I','Festa de Aniversario CrianÃ§a'),(9,1242559800,1242592200,0,0,1,'2009-05-11 11:40:41','jesus','Alugado Sandra ','I','AlmoÃ§o pessoal mercado carreira'),(10,1242505800,1242534600,0,0,1,'2009-05-11 14:03:45','Jesus','Levina Luis alves','I','Jantar de casamento '),(11,1245501000,1245533400,0,0,1,'2009-05-12 14:14:07','jesus','AlmoÃ§o','I','Professor Rocha Departamento de geografia.'),(12,1246134600,1246156200,0,0,1,'2009-06-15 12:48:52','Jesus','Reserva para aniversario','I','FEsta de aniversario poucas pessoas, periodo noturno, reservado por Beatriz.'),(13,1247257800,1247279400,0,0,1,'2009-07-07 17:27:13','jesus','Festa da Matematica','I','Aprox 40 pessoas, festa junina'),(14,1248546600,1248582600,0,0,1,'2009-07-24 12:20:44','jesus','Reserva para Matematica','I','ConfraternizaÃ§Ã£o departamento de matematica'),(15,1249749000,1249785000,0,0,1,'2009-07-24 12:22:49','jesus','Festa de aniversario ','I','Prof Rosangela Economia festa de aniveersario'),(16,1249821000,1249849800,0,0,1,'2009-07-24 12:24:16','jesus','AlmoÃ§o Prof   Rosangela','I','AlmoÃ§o com familia prof rosangela Economia'),(17,1253979000,1254015000,0,0,1,'2009-09-14 19:04:15','jesus','REservado paea Elias FECILCAM','I','Fest6a de Aniversario');
/*!40000 ALTER TABLE `adescam_entry` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `adescam_repeat`
--

DROP TABLE IF EXISTS `adescam_repeat`;
CREATE TABLE `adescam_repeat` (
  `id` int(11) NOT NULL auto_increment,
  `start_time` int(11) NOT NULL default '0',
  `end_time` int(11) NOT NULL default '0',
  `rep_type` int(11) NOT NULL default '0',
  `end_date` int(11) NOT NULL default '0',
  `rep_opt` varchar(32) NOT NULL default '',
  `room_id` int(11) NOT NULL default '1',
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `create_by` varchar(80) NOT NULL default '',
  `name` varchar(80) NOT NULL default '',
  `type` char(1) NOT NULL default 'E',
  `description` text,
  `rep_num_weeks` smallint(6) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `adescam_repeat`
--

LOCK TABLES `adescam_repeat` WRITE;
/*!40000 ALTER TABLE `adescam_repeat` DISABLE KEYS */;
/*!40000 ALTER TABLE `adescam_repeat` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `adescam_room`
--

DROP TABLE IF EXISTS `adescam_room`;
CREATE TABLE `adescam_room` (
  `id` int(11) NOT NULL auto_increment,
  `area_id` int(11) NOT NULL default '0',
  `room_name` varchar(25) NOT NULL default '',
  `description` varchar(60) default NULL,
  `capacity` int(11) NOT NULL default '0',
  `room_admin_email` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `adescam_room`
--

LOCK TABLES `adescam_room` WRITE;
/*!40000 ALTER TABLE `adescam_room` DISABLE KEYS */;
INSERT INTO `adescam_room` VALUES (1,1,'SalÃ£o de Festas','',0,NULL);
/*!40000 ALTER TABLE `adescam_room` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping routines for database 'reserva'
--
DELIMITER ;;
DELIMITER ;
/*!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 2025-01-21 11:21:49
