Internal/LoginService: login.sql

-- MySQL dump 10.13  Distrib 5.1.41, for debian-linux-gnu (i486)
--
-- Host: localhost    Database: newScheduler
-- ------------------------------------------------------
-- Server version   5.1.41-3ubuntu12.10

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

DROP TABLE IF EXISTS `permission`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `permission` (
  `username` char(16) NOT NULL DEFAULT '',
  `machid` char(16) NOT NULL DEFAULT '',
  PRIMARY KEY (`username`,`machid`),
  KEY `per_memberid` (`username`),
  KEY `per_machid` (`machid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `reservation_users`
--

DROP TABLE IF EXISTS `reservation_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `reservation_users` (
  `resid` char(16) NOT NULL DEFAULT '',
  `username` char(16) NOT NULL DEFAULT '',
  `owner` smallint(1) DEFAULT NULL,
  `invited` smallint(1) DEFAULT NULL,
  `perm_modify` smallint(1) DEFAULT NULL,
  `perm_delete` smallint(1) DEFAULT NULL,
  `accept_code` char(16) DEFAULT NULL,
  PRIMARY KEY (`resid`,`username`),
  KEY `resusers_resid` (`resid`),
  KEY `resusers_memberid` (`username`),
  KEY `resusers_owner` (`owner`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `reservations`
--

DROP TABLE IF EXISTS `reservations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `reservations` (
  `resid` varchar(16) NOT NULL DEFAULT '',
  `machid` varchar(16) NOT NULL DEFAULT '',
  `start_date` int(11) NOT NULL DEFAULT '0',
  `end_date` int(11) NOT NULL DEFAULT '0',
  `startTime` int(11) NOT NULL DEFAULT '0',
  `endTime` int(11) NOT NULL DEFAULT '0',
  `created` int(11) NOT NULL DEFAULT '0',
  `modified` int(11) DEFAULT NULL,
  `parentid` varchar(16) DEFAULT NULL,
  `is_blackout` smallint(1) NOT NULL DEFAULT '0',
  `is_pending` smallint(1) NOT NULL DEFAULT '0',
  `summary` text,
  PRIMARY KEY (`resid`),
  KEY `res_resid` (`resid`),
  KEY `res_machid` (`machid`),
  KEY `reservations_startdate` (`start_date`),
  KEY `reservations_enddate` (`end_date`),
  KEY `res_startTime` (`startTime`),
  KEY `res_endTime` (`endTime`),
  KEY `res_created` (`created`),
  KEY `res_modified` (`modified`),
  KEY `res_parentid` (`parentid`),
  KEY `res_isblackout` (`is_blackout`),
  KEY `reservations_pending` (`is_pending`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `resources`
--

DROP TABLE IF EXISTS `resources`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `resources` (
  `machid` varchar(16) NOT NULL DEFAULT '',
  `name` varchar(75) NOT NULL DEFAULT '',
  `location` varchar(250) DEFAULT NULL,
  `rphone` varchar(16) DEFAULT NULL,
  `notes` text,
  `status` char(1) NOT NULL DEFAULT 'a',
  `minRes` int(11) NOT NULL DEFAULT '0',
  `maxRes` int(11) NOT NULL DEFAULT '0',
  `autoAssign` smallint(1) DEFAULT NULL,
  `approval` smallint(1) DEFAULT NULL,
  `allow_multi` smallint(1) DEFAULT NULL,
  `permission` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`machid`),
  KEY `rs_machid` (`machid`),
  KEY `rs_name` (`name`),
  KEY `rs_status` (`status`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tgroup`
--

DROP TABLE IF EXISTS `tgroup`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tgroup` (
  `username` text,
  `groupname` text,
  `isactive` int(11) DEFAULT NULL,
  `firstname` text,
  `lastname` text,
  `organization` text,
  `email` text,
  `phone` text,
  `address` text,
  `category` text,
  `destinationIndicator` text,
  `deleted` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tpassword`
--

DROP TABLE IF EXISTS `tpassword`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tpassword` (
  `username` text,
  `oldpassword` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tuser`
--

DROP TABLE IF EXISTS `tuser`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tuser` (
  `username` text,
  `isactive` int(11) DEFAULT NULL,
  `isadmin` int(11) DEFAULT NULL,
  `firstname` text,
  `lastname` text,
  `organization` text,
  `email` text,
  `phone` text,
  `groupname` text,
  `gidNumber` text,
  `admin` text,
  `destinationIndicator` text,
  `comment` text,
  `deleted` int(11) DEFAULT NULL,
  `enabled` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!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 2011-07-20 12:31:39