-- MySQL dump 10.9
--
-- Host: localhost    Database: rt3regression
-- ------------------------------------------------------
-- Server version	4.1.19-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 */;
/*!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 `Users`
--

DROP TABLE IF EXISTS `Users`;
CREATE TABLE `Users` (
  `id` int(11) NOT NULL auto_increment,
  `Name` varchar(200) NOT NULL default '',
  `Password` varchar(40) default NULL,
  `Comments` blob,
  `Signature` blob,
  `EmailAddress` varchar(120) default NULL,
  `FreeformContactInfo` blob,
  `Organization` varchar(200) default NULL,
  `RealName` varchar(120) default NULL,
  `NickName` varchar(16) default NULL,
  `Lang` varchar(16) default NULL,
  `EmailEncoding` varchar(16) default NULL,
  `WebEncoding` varchar(16) default NULL,
  `ExternalContactInfoId` varchar(100) default NULL,
  `ContactInfoSystem` varchar(30) default NULL,
  `ExternalAuthId` varchar(100) default NULL,
  `AuthSystem` varchar(30) default NULL,
  `Gecos` varchar(16) default NULL,
  `HomePhone` varchar(30) default NULL,
  `WorkPhone` varchar(30) default NULL,
  `MobilePhone` varchar(30) default NULL,
  `PagerPhone` varchar(30) default NULL,
  `Address1` varchar(200) default NULL,
  `Address2` varchar(200) default NULL,
  `City` varchar(100) default NULL,
  `State` varchar(100) default NULL,
  `Zip` varchar(16) default NULL,
  `Country` varchar(50) default NULL,
  `Timezone` varchar(50) default NULL,
  `PGPKey` text,
  `Creator` int(11) NOT NULL default '0',
  `Created` datetime default NULL,
  `LastUpdatedBy` int(11) NOT NULL default '0',
  `LastUpdated` datetime default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `Users1` (`Name`),
  KEY `Users4` (`EmailAddress`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Users`
--


/*!40000 ALTER TABLE `Users` DISABLE KEYS */;
LOCK TABLES `Users` WRITE;
INSERT INTO `Users` VALUES (1,'RT_System','*NO-PASSWORD*','Do not delete or modify this user. It is integral to RT\'s internal database structures',NULL,NULL,NULL,NULL,'The RT System itself',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2006-05-31 15:57:36',1,'2006-05-31 15:57:36'),(10,'Nobody','*NO-PASSWORD*','Do not delete or modify this user. It is integral to RT\'s internal data structures',NULL,'',NULL,NULL,'Nobody in particular',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2006-05-31 15:57:37',1,'2006-05-31 15:57:37'),(12,'root','5f4dcc3b5aa765d61d8327deb882cf99','SuperUser',NULL,'root@localhost',NULL,NULL,'Enoch Root',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'root',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2006-05-31 15:57:37',1,'2006-05-31 15:57:37'),(59,'qwe','*NO-PASSWORD*','',NULL,'','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,'','','','','','','','','','','',NULL,NULL,12,'2006-05-31 22:23:52',12,'2006-05-31 22:23:52');
UNLOCK TABLES;
/*!40000 ALTER TABLE `Users` ENABLE KEYS */;

--
-- Table structure for table `Groups`
--

DROP TABLE IF EXISTS `Groups`;
CREATE TABLE `Groups` (
  `id` int(11) NOT NULL auto_increment,
  `Name` varchar(200) default NULL,
  `Description` varchar(255) default NULL,
  `Domain` varchar(64) default NULL,
  `Type` varchar(64) default NULL,
  `Instance` int(11) default NULL,
  PRIMARY KEY  (`id`),
  KEY `Groups1` (`Domain`,`Instance`,`Type`,`id`),
  KEY `Groups2` (`Type`,`Instance`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Groups`
--


/*!40000 ALTER TABLE `Groups` DISABLE KEYS */;
LOCK TABLES `Groups` WRITE;
INSERT INTO `Groups` VALUES (2,'User 1','ACL equiv. for user 1','ACLEquivalence','UserEquiv',1),(3,'','Pseudogroup for internal use','SystemInternal','Everyone',0),(4,'','Pseudogroup for internal use','SystemInternal','Privileged',0),(5,'','Pseudogroup for internal use','SystemInternal','Unprivileged',0),(6,'','SystemRolegroup for internal use','RT::System-Role','Owner',0),(7,'','SystemRolegroup for internal use','RT::System-Role','Requestor',0),(8,'','SystemRolegroup for internal use','RT::System-Role','Cc',0),(9,'','Pseudogroup for internal use','RT::System-Role','AdminCc',0),(11,'User 10','ACL equiv. for user 10','ACLEquivalence','UserEquiv',10),(13,'User 12','ACL equiv. for user 12','ACLEquivalence','UserEquiv',12),(14,NULL,NULL,'RT::Queue-Role','Cc',1),(15,NULL,NULL,'RT::Queue-Role','AdminCc',1),(16,NULL,NULL,'RT::Queue-Role','Requestor',1),(17,NULL,NULL,'RT::Queue-Role','Owner',1),(18,NULL,NULL,'RT::Queue-Role','Cc',2),(19,NULL,NULL,'RT::Queue-Role','AdminCc',2),(20,NULL,NULL,'RT::Queue-Role','Requestor',2),(21,NULL,NULL,'RT::Queue-Role','Owner',2),(22,'DutyTeam','Duty Team Members','UserDefined','Privileged',0),(23,NULL,NULL,'RT::Queue-Role','Cc',3),(24,NULL,NULL,'RT::Queue-Role','AdminCc',3),(25,NULL,NULL,'RT::Queue-Role','Requestor',3),(26,NULL,NULL,'RT::Queue-Role','Owner',3),(27,NULL,NULL,'RT::Queue-Role','Cc',4),(28,NULL,NULL,'RT::Queue-Role','AdminCc',4),(29,NULL,NULL,'RT::Queue-Role','Requestor',4),(30,NULL,NULL,'RT::Queue-Role','Owner',4),(31,NULL,NULL,'RT::Queue-Role','Cc',5),(32,NULL,NULL,'RT::Queue-Role','AdminCc',5),(33,NULL,NULL,'RT::Queue-Role','Requestor',5),(34,NULL,NULL,'RT::Queue-Role','Owner',5),(35,NULL,NULL,'RT::Queue-Role','Cc',6),(36,NULL,NULL,'RT::Queue-Role','AdminCc',6),(37,NULL,NULL,'RT::Queue-Role','Requestor',6),(38,NULL,NULL,'RT::Queue-Role','Owner',6),(39,NULL,NULL,'RT::Ticket-Role','Requestor',1),(40,NULL,NULL,'RT::Ticket-Role','Owner',1),(41,NULL,NULL,'RT::Ticket-Role','Cc',1),(42,NULL,NULL,'RT::Ticket-Role','AdminCc',1),(43,NULL,NULL,'RT::Ticket-Role','Requestor',2),(44,NULL,NULL,'RT::Ticket-Role','Owner',2),(45,NULL,NULL,'RT::Ticket-Role','Cc',2),(46,NULL,NULL,'RT::Ticket-Role','AdminCc',2),(47,NULL,NULL,'RT::Ticket-Role','Requestor',3),(48,NULL,NULL,'RT::Ticket-Role','Owner',3),(49,NULL,NULL,'RT::Ticket-Role','Cc',3),(50,NULL,NULL,'RT::Ticket-Role','AdminCc',3),(51,NULL,NULL,'RT::Ticket-Role','Requestor',4),(52,NULL,NULL,'RT::Ticket-Role','Owner',4),(53,NULL,NULL,'RT::Ticket-Role','Cc',4),(54,NULL,NULL,'RT::Ticket-Role','AdminCc',4),(55,NULL,NULL,'RT::Ticket-Role','Requestor',5),(56,NULL,NULL,'RT::Ticket-Role','Owner',5),(57,NULL,NULL,'RT::Ticket-Role','Cc',5),(58,NULL,NULL,'RT::Ticket-Role','AdminCc',5),(60,'User 59','ACL equiv. for user 59','ACLEquivalence','UserEquiv',59);
UNLOCK TABLES;
/*!40000 ALTER TABLE `Groups` ENABLE KEYS */;

--
-- Table structure for table `GroupMembers`
--

DROP TABLE IF EXISTS `GroupMembers`;
CREATE TABLE `GroupMembers` (
  `id` int(11) NOT NULL auto_increment,
  `GroupId` int(11) NOT NULL default '0',
  `MemberId` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `GroupMembers1` (`GroupId`,`MemberId`),
  KEY `GroupMembers2` (`MemberId`,`GroupId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `GroupMembers`
--


/*!40000 ALTER TABLE `GroupMembers` DISABLE KEYS */;
LOCK TABLES `GroupMembers` WRITE;
INSERT INTO `GroupMembers` VALUES (1,2,1),(3,3,10),(6,3,12),(15,3,59),(7,4,12),(4,5,10),(16,5,59),(2,11,10),(5,13,12),(9,40,12),(10,44,12),(11,48,12),(12,52,12),(13,56,12),(14,60,59);
UNLOCK TABLES;
/*!40000 ALTER TABLE `GroupMembers` ENABLE KEYS */;

/*!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 */;