-- MySQL dump 10.9
--
-- Host: asylum    Database: inventory
-- ------------------------------------------------------
-- Server version	4.1.22

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

DROP TABLE IF EXISTS `CDROMs`;
CREATE TABLE `CDROMs` (
  `CDROMID` tinyint(4) NOT NULL auto_increment,
  `HostID` tinyint(4) NOT NULL default '0',
  `Manufacturer` varchar(255) NOT NULL default '',
  `Model` varchar(255) NOT NULL default '',
  `Speed` tinyint(4) NOT NULL default '0',
  `Description` varchar(255) NOT NULL default '',
  `SerialNumber` varchar(255) NOT NULL default '',
  `Status` enum('InUse','spare','dead','InPieces','gone','dying') NOT NULL default 'InUse',
  `PurchasedDate` varchar(255) NOT NULL default '',
  `PurchasedFrom` varchar(255) NOT NULL default '',
  `Price` smallint(6) NOT NULL default '0',
  `Warranty` tinyint(4) NOT NULL default '0',
  `WasUsed` enum('Y','N','unknown') NOT NULL default 'Y',
  `IsInternal` enum('Y','N','N/A') NOT NULL default 'Y',
  `Interface` enum('IDE','SCSI','UWSCSI') NOT NULL default 'IDE',
  `Controller` tinyint(4) NOT NULL default '0',
  `Target` tinyint(4) NOT NULL default '0',
  `Type` enum('CAV','CLV','unknown') NOT NULL default 'CAV',
  `WriteSpeed` tinyint(4) NOT NULL default '0',
  `ReWriteSpeed` tinyint(4) NOT NULL default '0',
  `DVDSpeed` tinyint(4) NOT NULL default '0',
  `Loader` enum('tray','caddy','slot') NOT NULL default 'tray',
  `InvoiceURL` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`CDROMID`),
  KEY `HostID` (`HostID`)
) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `CDROMs`
--

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

--
-- Table structure for table `CPUs`
--

DROP TABLE IF EXISTS `CPUs`;
CREATE TABLE `CPUs` (
  `CPUID` tinyint(4) NOT NULL auto_increment,
  `HostID` tinyint(3) unsigned NOT NULL default '0',
  `Manufacturer` varchar(255) NOT NULL default '',
  `Model` varchar(255) NOT NULL default '',
  `Description` varchar(255) NOT NULL default '',
  `SerialNumber` varchar(255) NOT NULL default '',
  `Status` enum('InUse','spare','dying','dead','gone','InPieces') NOT NULL default 'InUse',
  `PurchasedDate` date NOT NULL default '0000-00-00',
  `PurchasedFrom` varchar(255) NOT NULL default '',
  `Price` smallint(6) NOT NULL default '0',
  `Warranty` tinyint(4) NOT NULL default '0',
  `WasUsed` enum('Y','N','unknown') NOT NULL default 'Y',
  `CPUArch` enum('x86','sun4c','sun4m','amd64') NOT NULL default 'x86',
  `CPUSlotType` varchar(255) NOT NULL default '',
  `Speed` smallint(5) unsigned NOT NULL default '0',
  `InvoiceURL` varchar(255) NOT NULL default '',
  `NumCores` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`CPUID`),
  KEY `HostID` (`HostID`)
) ENGINE=MyISAM AUTO_INCREMENT=34 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `CPUs`
--

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

--
-- Table structure for table `RAM`
--

DROP TABLE IF EXISTS `RAM`;
CREATE TABLE `RAM` (
  `RAMID` smallint(6) NOT NULL auto_increment,
  `HostID` tinyint(3) NOT NULL default '0',
  `DeviceID` smallint(6) NOT NULL default '0',
  `Manufacturer` varchar(255) NOT NULL default '',
  `Model` varchar(255) NOT NULL default '',
  `Description` varchar(255) NOT NULL default '',
  `SerialNumber` varchar(255) NOT NULL default '',
  `Status` enum('InUse','spare','dying','dead','gone','InPieces') NOT NULL default 'InUse',
  `PurchasedDate` date NOT NULL default '0000-00-00',
  `PurchasedFrom` varchar(255) NOT NULL default '',
  `Price` smallint(6) NOT NULL default '0',
  `Warranty` tinyint(4) NOT NULL default '0',
  `WasUsed` enum('Y','N','unknown') NOT NULL default 'Y',
  `Size` smallint(6) NOT NULL default '0',
  `Type` enum('30pin SIMM','72pin SIMM','PC66 DIMM','PC100 DIMM','PC133 DIMM','Sun DIMM','Laptop SIMM','unknown','PC2700 DIMM','PC3200 DIMM') NOT NULL default '30pin SIMM',
  `IsParity` enum('Y','N','unknown') NOT NULL default 'Y',
  `Speed` int(11) NOT NULL default '0',
  `InvoiceURL` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`RAMID`),
  KEY `HostID` (`HostID`)
) ENGINE=MyISAM AUTO_INCREMENT=81 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `RAM`
--

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

--
-- Table structure for table `cases`
--

DROP TABLE IF EXISTS `cases`;
CREATE TABLE `cases` (
  `CaseID` tinyint(4) NOT NULL auto_increment,
  `HostID` tinyint(3) unsigned NOT NULL default '0',
  `Manufacturer` varchar(255) NOT NULL default '',
  `Model` varchar(255) NOT NULL default '',
  `Description` varchar(255) NOT NULL default '',
  `SerialNumber` varchar(255) NOT NULL default '',
  `Status` enum('InUse','spare','dying','dead','gone','InPieces') NOT NULL default 'InUse',
  `PurchasedDate` date NOT NULL default '0000-00-00',
  `PurchasedFrom` varchar(255) NOT NULL default '',
  `Price` smallint(6) NOT NULL default '0',
  `Warranty` tinyint(4) NOT NULL default '0',
  `WasUsed` enum('Y','N','unknown') NOT NULL default 'Y',
  `Geometry` enum('Full Tower','Mid Tower','Mini Tower','Desktop','Pizza Box','Laptop','Lunch Box','proprietary') NOT NULL default 'Full Tower',
  `FormFactor` enum('ATX','Baby-AT','unknown','pizza box','laptop','lunch box','proprietary') NOT NULL default 'ATX',
  `PowerSupplyWatts` smallint(6) NOT NULL default '0',
  `NumPowerSupplies` tinyint(4) NOT NULL default '0',
  `Num5Bays` tinyint(4) NOT NULL default '0',
  `Num3bays` tinyint(4) NOT NULL default '0',
  `NumHBays` tinyint(4) NOT NULL default '0',
  `InvoiceURL` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`CaseID`),
  KEY `HostID` (`HostID`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cases`
--

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

--
-- Table structure for table `devices`
--

DROP TABLE IF EXISTS `devices`;
CREATE TABLE `devices` (
  `DeviceID` tinyint(4) NOT NULL auto_increment,
  `HostID` tinyint(4) NOT NULL default '0',
  `ParentDeviceID` tinyint(4) NOT NULL default '0',
  `Manufacturer` varchar(255) NOT NULL default '',
  `Model` varchar(255) NOT NULL default '',
  `Function` varchar(255) NOT NULL default '',
  `Description` varchar(255) NOT NULL default '',
  `SerialNumber` varchar(255) NOT NULL default '',
  `Status` enum('InUse','spare','dying','dead','gone') NOT NULL default 'InUse',
  `PurchasedDate` date NOT NULL default '0000-00-00',
  `PurchasedFrom` varchar(255) NOT NULL default '',
  `Price` smallint(6) NOT NULL default '0',
  `Warranty` tinyint(4) NOT NULL default '0',
  `WasUsed` enum('Y','N','unknown') NOT NULL default 'Y',
  `DeviceName` varchar(255) NOT NULL default '',
  `Bus` enum('ISA-8','ISA-16','VLB','PCI','AGP','PCMCIA','SBUS','MBUS','Parallel','Serial','USB','SCSI','UWSCSI','IDE') NOT NULL default 'ISA-8',
  `RAM` smallint(6) NOT NULL default '0',
  `LinuxSupported` enum('Y','N','unknown','partial') NOT NULL default 'Y',
  `OpenBSDSupported` enum('Y','N','unknown','partial') NOT NULL default 'Y',
  `IRQ` varchar(20) NOT NULL default '',
  `DMA` varchar(20) NOT NULL default '',
  `IO` varchar(20) NOT NULL default '',
  `MMAP` varchar(20) NOT NULL default '',
  `IsInternal` enum('Y','N','N/A') NOT NULL default 'Y',
  `InvoiceURL` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`DeviceID`),
  KEY `HostID` (`HostID`),
  KEY `ParentDeviceID` (`ParentDeviceID`)
) ENGINE=MyISAM AUTO_INCREMENT=101 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `devices`
--

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

--
-- Table structure for table `disks`
--

DROP TABLE IF EXISTS `disks`;
CREATE TABLE `disks` (
  `DiskID` tinyint(4) NOT NULL auto_increment,
  `HostID` tinyint(3) unsigned NOT NULL default '0',
  `Manufacturer` varchar(255) NOT NULL default '',
  `Model` varchar(255) NOT NULL default '',
  `Description` varchar(255) NOT NULL default '',
  `SerialNumber` varchar(255) NOT NULL default '',
  `Status` enum('InUse','spare','dead','InPieces','gone','dying') NOT NULL default 'InUse',
  `PurchasedDate` date NOT NULL default '0000-00-00',
  `PurchasedFrom` varchar(255) NOT NULL default '',
  `Price` smallint(6) NOT NULL default '0',
  `Warranty` tinyint(4) NOT NULL default '0',
  `WasUsed` enum('Y','N') NOT NULL default 'Y',
  `Capacity` float NOT NULL default '0',
  `Interface` enum('IDE','SCSI','UWSCSI','SCA','USB','FireWire','SATA') NOT NULL default 'IDE',
  `Size` enum('3.5','5.25','2.5') NOT NULL default '3.5',
  `Height` enum('Half','Full') NOT NULL default 'Half',
  `IsInternal` enum('Y','N','N/A') NOT NULL default 'Y',
  `Controller` tinyint(4) NOT NULL default '0',
  `Target` tinyint(4) NOT NULL default '0',
  `RPM` smallint(6) NOT NULL default '0',
  `InvoiceURL` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`DiskID`),
  KEY `HostID` (`HostID`)
) ENGINE=MyISAM AUTO_INCREMENT=95 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `disks`
--

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

--
-- Table structure for table `hosts`
--

DROP TABLE IF EXISTS `hosts`;
CREATE TABLE `hosts` (
  `hostid` tinyint(3) unsigned NOT NULL default '0',
  `HostName` varchar(255) NOT NULL default '',
  `Manufacturer` varchar(255) NOT NULL default '',
  `Model` varchar(255) NOT NULL default '',
  `Function` varchar(255) NOT NULL default '',
  `Description` varchar(255) NOT NULL default '',
  `SerialNumber` varchar(255) NOT NULL default '',
  `Status` enum('InUse','spare','dead','InPieces','gone','dying') NOT NULL default 'InUse',
  `PurchasedDate` date NOT NULL default '0000-00-00',
  `PurchasedFrom` varchar(255) NOT NULL default '',
  `Price` smallint(6) NOT NULL default '0',
  `Warranty` tinyint(4) NOT NULL default '0',
  `WasUsed` enum('Y','N','unknown') NOT NULL default 'Y',
  `ConsoleSource` varchar(255) NOT NULL default '',
  `Location` varchar(255) NOT NULL default '',
  `OSList` varchar(255) NOT NULL default '',
  `OSHostID` varchar(255) NOT NULL default '',
  `IsServer` enum('Y','N') NOT NULL default 'Y',
  `InvoiceURL` varchar(255) NOT NULL default '',
  `PicIDs` varchar(250) NOT NULL default '',
  PRIMARY KEY  (`hostid`),
  UNIQUE KEY `HostName` (`HostName`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `hosts`
--

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

--
-- Table structure for table `interfaces`
--

DROP TABLE IF EXISTS `interfaces`;
CREATE TABLE `interfaces` (
  `InterfaceID` tinyint(4) NOT NULL auto_increment,
  `DeviceID` tinyint(4) NOT NULL default '0',
  `Description` varchar(255) NOT NULL default '',
  `Name` varchar(255) NOT NULL default '',
  `Media` enum('10BaseT','10Base5','10Base2','100BaseT','POTS','loopback','dummy','virtual','tunnel','unused','bonded') NOT NULL default '10BaseT',
  `speed` float NOT NULL default '0',
  `Destination` varchar(255) NOT NULL default '',
  `IP` varchar(15) NOT NULL default '',
  `NetMask` varchar(15) NOT NULL default '',
  `Transceiver` enum('N','Y','N/A') NOT NULL default 'N',
  `ReverseDNS` varchar(255) NOT NULL default '',
  `MAC` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`InterfaceID`),
  KEY `DeviceID` (`DeviceID`)
) ENGINE=MyISAM AUTO_INCREMENT=35 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `interfaces`
--

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

--
-- Table structure for table `invoices`
--

DROP TABLE IF EXISTS `invoices`;
CREATE TABLE `invoices` (
  `InvoiceID` tinyint(3) unsigned NOT NULL auto_increment,
  `InvoiceFormat` enum('png','jpg','txt','html','pdf') default NULL,
  `Vendor` varchar(100) NOT NULL default '',
  `VendorInvoiceNum` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`InvoiceID`),
  UNIQUE KEY `invoice` (`Vendor`,`VendorInvoiceNum`)
) ENGINE=MyISAM AUTO_INCREMENT=64 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `invoices`
--

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

--
-- Table structure for table `mbs`
--

DROP TABLE IF EXISTS `mbs`;
CREATE TABLE `mbs` (
  `MBID` tinyint(4) NOT NULL auto_increment,
  `HostID` tinyint(4) NOT NULL default '0',
  `Manufacturer` varchar(255) NOT NULL default '',
  `Model` varchar(255) NOT NULL default '',
  `Description` varchar(255) NOT NULL default '',
  `SerialNumber` varchar(255) NOT NULL default '',
  `Status` enum('InUse','spare','dead','InPieces','gone','dying') NOT NULL default 'InUse',
  `PurchasedDate` date NOT NULL default '0000-00-00',
  `PurchasedFrom` varchar(255) NOT NULL default '',
  `Price` smallint(6) NOT NULL default '0',
  `Warranty` tinyint(4) NOT NULL default '0',
  `WasUsed` enum('Y','N') NOT NULL default 'Y',
  `FormFactor` enum('ATX','Baby-AT','pizza box','laptop','lunch box','proprietary') NOT NULL default 'ATX',
  `CPUType` enum('Socket7','Super Socket7','Slot 1','Slot 2','Socket 370','Socket A','Socket 462','MBUS','SPARC','unknown','Socket 939') NOT NULL default 'Socket7',
  `NumCPUSlots` tinyint(4) NOT NULL default '0',
  `NumISASlots` tinyint(4) NOT NULL default '0',
  `NumVLBSlots` tinyint(4) NOT NULL default '0',
  `NumPCISlots` tinyint(4) NOT NULL default '0',
  `NumAGPSlots` tinyint(4) NOT NULL default '0',
  `NumPCMCIASlots` tinyint(4) NOT NULL default '0',
  `NumSBUSSlots` tinyint(4) NOT NULL default '0',
  `NumRAMSlots` tinyint(4) NOT NULL default '0',
  `RAMType` enum('30pin SIMM','72pin SIMM','PC66 DIMM','PC100 DIMM','PC133 DIMM','Sun DIMM','Laptop SIMM','DDR DIMM','unknown') NOT NULL default '30pin SIMM',
  `NumIDEControllers` tinyint(4) NOT NULL default '0',
  `NumSCSIControllers` tinyint(4) NOT NULL default '0',
  `InvoiceURL` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`MBID`),
  KEY `HostID` (`HostID`)
) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `mbs`
--

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

--
-- Table structure for table `powersupplies`
--

DROP TABLE IF EXISTS `powersupplies`;
CREATE TABLE `powersupplies` (
  `PSUID` tinyint(3) unsigned NOT NULL auto_increment,
  `CaseID` tinyint(4) NOT NULL default '0',
  `Manufacturer` varchar(250) NOT NULL default '',
  `Model` varchar(250) NOT NULL default '',
  `Description` varchar(255) NOT NULL default '',
  `SerialNumber` varchar(250) NOT NULL default '',
  `Status` enum('InUse','spare','dying','dead','gone','InPieces') NOT NULL default 'InUse',
  `PurchasedDate` date NOT NULL default '0000-00-00',
  `PurchasedFrom` varchar(250) NOT NULL default '',
  `Price` smallint(6) NOT NULL default '0',
  `Warranty` tinyint(4) NOT NULL default '0',
  `WasUsed` enum('Y','N','unknown') NOT NULL default 'Y',
  `FormFactor` enum('AT','ATX','other') NOT NULL default 'AT',
  `MaxWatts` smallint(6) NOT NULL default '0',
  `MaxCombinedWatts` smallint(6) NOT NULL default '0',
  `NumATPowerConnectors` tinyint(4) NOT NULL default '0',
  `NumATXPowerConnectors` tinyint(4) NOT NULL default '0',
  `NumUniversalATXPowerConnectors` tinyint(4) NOT NULL default '0',
  `NumFDDPowerConnectors` tinyint(4) NOT NULL default '0',
  `NumHDDPowerConnectors` tinyint(4) NOT NULL default '0',
  `NumSATAPowerConnectors` tinyint(4) NOT NULL default '0',
  `NumFanConnectors` tinyint(4) NOT NULL default '0',
  `NumPCIXPowerConnectors` tinyint(4) NOT NULL default '0',
  `NumFans` tinyint(4) NOT NULL default '0',
  `FanSize` enum('none','80mm','92mm','120mm','other') NOT NULL default 'none',
  `InvoiceURL` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`PSUID`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `powersupplies`
--

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

--
-- Table structure for table `slices`
--

DROP TABLE IF EXISTS `slices`;
CREATE TABLE `slices` (
  `SliceID` smallint(5) unsigned NOT NULL auto_increment,
  `DiskID` tinyint(4) NOT NULL default '0',
  `Description` varchar(255) NOT NULL default '',
  `OSDeviceName` varchar(255) NOT NULL default '',
  `FSType` enum('ext2','swap','vfat','ufs','ffs','ntfs','msdos','RAID0','RAID1','RAID5','extended','metadb','unused','4.2','ext3','reiserfs','fatx','xfs') NOT NULL default 'ext2',
  `MountPoint` varchar(255) NOT NULL default '',
  `Begin` int(10) unsigned NOT NULL default '0',
  `End` int(10) unsigned NOT NULL default '0',
  `Capacity` int(11) NOT NULL default '0',
  `IsLogical` enum('N','Y') NOT NULL default 'N',
  `IsBootable` enum('N','Y') NOT NULL default 'N',
  `MetaMountPoint` varchar(255) NOT NULL default '',
  `MetaFSType` enum('ext2','swap','vfat','ufs','ffs','ntfs','msdos','unused','4.2','ext3','reiserfs','N/A','xfs') NOT NULL default 'ext2',
  `IsEncrypted` enum('N','Y') NOT NULL default 'N',
  PRIMARY KEY  (`SliceID`),
  KEY `DiskID` (`DiskID`)
) ENGINE=MyISAM AUTO_INCREMENT=403 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `slices`
--

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

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