+-- MySQL dump 10.13 Distrib 5.1.62, for pc-linux-gnu (x86_64)
+--
+-- Host: localhost Database: schematic
+-- ------------------------------------------------------
+-- Server version 5.1.62-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 `Alerts`
+--
+
+DROP TABLE IF EXISTS `Alerts`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `Alerts` (
+ `aid` int(11) NOT NULL AUTO_INCREMENT,
+ `uid` int(11) DEFAULT NULL,
+ `nid` int(11) DEFAULT NULL,
+ `date` date DEFAULT NULL,
+ `description` varchar(200) DEFAULT NULL,
+ PRIMARY KEY (`aid`),
+ KEY `uid` (`uid`),
+ CONSTRAINT `Alerts_ibfk_1` FOREIGN KEY (`uid`) REFERENCES `User` (`uid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `Alerts`
+--
+
+LOCK TABLES `Alerts` WRITE;
+/*!40000 ALTER TABLE `Alerts` DISABLE KEYS */;
+/*!40000 ALTER TABLE `Alerts` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `Contact`
+--
+
+DROP TABLE IF EXISTS `Contact`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `Contact` (
+ `cid` int(11) NOT NULL AUTO_INCREMENT,
+ `vid` int(11) DEFAULT NULL,
+ `CTID` int(11) DEFAULT NULL,
+ `name` varchar(64) DEFAULT NULL,
+ `email` varchar(64) DEFAULT NULL,
+ `address` varchar(200) DEFAULT NULL,
+ `phone1` varchar(32) DEFAULT NULL,
+ `phone2` varchar(32) DEFAULT NULL,
+ `fax` varchar(32) DEFAULT NULL,
+ PRIMARY KEY (`cid`),
+ KEY `vid` (`vid`),
+ KEY `CTID` (`CTID`),
+ CONSTRAINT `Contact_ibfk_1` FOREIGN KEY (`vid`) REFERENCES `Vendor` (`vid`),
+ CONSTRAINT `Contact_ibfk_2` FOREIGN KEY (`CTID`) REFERENCES `ContactType` (`ctid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `Contact`
+--
+
+LOCK TABLES `Contact` WRITE;
+/*!40000 ALTER TABLE `Contact` DISABLE KEYS */;
+/*!40000 ALTER TABLE `Contact` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `ContactType`
+--
+
+DROP TABLE IF EXISTS `ContactType`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `ContactType` (
+ `ctid` int(11) NOT NULL AUTO_INCREMENT,
+ `description` varchar(100) DEFAULT NULL,
+ PRIMARY KEY (`ctid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `ContactType`
+--
+
+LOCK TABLES `ContactType` WRITE;
+/*!40000 ALTER TABLE `ContactType` DISABLE KEYS */;
+/*!40000 ALTER TABLE `ContactType` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `DocumentType`
+--
+
+DROP TABLE IF EXISTS `DocumentType`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `DocumentType` (
+ `dtid` int(11) NOT NULL AUTO_INCREMENT,
+ `description` varchar(100) DEFAULT NULL,
+ PRIMARY KEY (`dtid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `DocumentType`
+--
+
+LOCK TABLES `DocumentType` WRITE;
+/*!40000 ALTER TABLE `DocumentType` DISABLE KEYS */;
+/*!40000 ALTER TABLE `DocumentType` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `Documents`
+--
+
+DROP TABLE IF EXISTS `Documents`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `Documents` (
+ `did` int(11) NOT NULL AUTO_INCREMENT,
+ `dtid` int(11) DEFAULT NULL,
+ `vid` int(11) DEFAULT NULL,
+ `poid` int(11) DEFAULT NULL,
+ `document` longblob,
+ PRIMARY KEY (`did`),
+ KEY `dtid` (`dtid`),
+ KEY `vid` (`vid`),
+ KEY `poid` (`poid`),
+ CONSTRAINT `Documents_ibfk_1` FOREIGN KEY (`dtid`) REFERENCES `DocumentType` (`dtid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `Documents`
+--
+
+LOCK TABLES `Documents` WRITE;
+/*!40000 ALTER TABLE `Documents` DISABLE KEYS */;
+/*!40000 ALTER TABLE `Documents` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `History`
+--
+
+DROP TABLE IF EXISTS `History`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `History` (
+ `uid` int(11) DEFAULT NULL,
+ `date` datetime DEFAULT NULL,
+ `note` varchar(100) DEFAULT NULL,
+ KEY `uid` (`uid`),
+ CONSTRAINT `History_ibfk_1` FOREIGN KEY (`uid`) REFERENCES `User` (`uid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `History`
+--
+
+LOCK TABLES `History` WRITE;
+/*!40000 ALTER TABLE `History` DISABLE KEYS */;
+/*!40000 ALTER TABLE `History` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `Notes`
+--
+
+DROP TABLE IF EXISTS `Notes`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `Notes` (
+ `nid` int(11) NOT NULL AUTO_INCREMENT,
+ `poid` int(11) DEFAULT NULL,
+ `note` varchar(200) DEFAULT NULL,
+ PRIMARY KEY (`nid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `Notes`
+--
+
+LOCK TABLES `Notes` WRITE;
+/*!40000 ALTER TABLE `Notes` DISABLE KEYS */;
+/*!40000 ALTER TABLE `Notes` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `PurchaseOrder`
+--
+
+DROP TABLE IF EXISTS `PurchaseOrder`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `PurchaseOrder` (
+ `poid` int(11) NOT NULL AUTO_INCREMENT,
+ `vid` int(11) DEFAULT NULL,
+ `closed` tinyint(1) NOT NULL DEFAULT '0',
+ `description` varchar(200) DEFAULT NULL,
+ PRIMARY KEY (`poid`),
+ KEY `vid` (`vid`),
+ CONSTRAINT `PurchaseOrder_ibfk_1` FOREIGN KEY (`vid`) REFERENCES `Vendor` (`vid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `PurchaseOrder`
+--
+
+LOCK TABLES `PurchaseOrder` WRITE;
+/*!40000 ALTER TABLE `PurchaseOrder` DISABLE KEYS */;
+/*!40000 ALTER TABLE `PurchaseOrder` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `User`
+--
+
+DROP TABLE IF EXISTS `User`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `User` (
+ `uid` int(11) NOT NULL AUTO_INCREMENT,
+ `ucid` int(11) DEFAULT NULL,
+ `name` varchar(64) DEFAULT NULL,
+ `login` varchar(32) DEFAULT NULL,
+ `password` varchar(64) DEFAULT NULL,
+ PRIMARY KEY (`uid`),
+ KEY `ucid` (`ucid`),
+ CONSTRAINT `User_ibfk_1` FOREIGN KEY (`ucid`) REFERENCES `UserClass` (`ucid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `User`
+--
+
+LOCK TABLES `User` WRITE;
+/*!40000 ALTER TABLE `User` DISABLE KEYS */;
+/*!40000 ALTER TABLE `User` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `UserClass`
+--
+
+DROP TABLE IF EXISTS `UserClass`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `UserClass` (
+ `ucid` int(11) NOT NULL AUTO_INCREMENT,
+ `privilegeLevel` int(11) NOT NULL DEFAULT '0',
+ `description` varchar(100) DEFAULT NULL,
+ PRIMARY KEY (`ucid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `UserClass`
+--
+
+LOCK TABLES `UserClass` WRITE;
+/*!40000 ALTER TABLE `UserClass` DISABLE KEYS */;
+/*!40000 ALTER TABLE `UserClass` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `Vendor`
+--
+
+DROP TABLE IF EXISTS `Vendor`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `Vendor` (
+ `vid` int(11) NOT NULL AUTO_INCREMENT,
+ `vlid` int(11) DEFAULT NULL,
+ `name` varchar(100) DEFAULT NULL,
+ PRIMARY KEY (`vid`),
+ KEY `vlid` (`vlid`),
+ CONSTRAINT `Vendor_ibfk_1` FOREIGN KEY (`vlid`) REFERENCES `VendorLevel` (`vlid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `Vendor`
+--
+
+LOCK TABLES `Vendor` WRITE;
+/*!40000 ALTER TABLE `Vendor` DISABLE KEYS */;
+/*!40000 ALTER TABLE `Vendor` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `VendorGroup`
+--
+
+DROP TABLE IF EXISTS `VendorGroup`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `VendorGroup` (
+ `vgid` int(11) NOT NULL AUTO_INCREMENT,
+ `description` varchar(100) DEFAULT NULL,
+ PRIMARY KEY (`vgid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `VendorGroup`
+--
+
+LOCK TABLES `VendorGroup` WRITE;
+/*!40000 ALTER TABLE `VendorGroup` DISABLE KEYS */;
+/*!40000 ALTER TABLE `VendorGroup` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `VendorLevel`
+--
+
+DROP TABLE IF EXISTS `VendorLevel`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `VendorLevel` (
+ `vlid` int(11) NOT NULL AUTO_INCREMENT,
+ `vendorUsable` tinyint(1) NOT NULL DEFAULT '0',
+ `color` int(4) DEFAULT NULL,
+ `description` varchar(100) DEFAULT NULL,
+ PRIMARY KEY (`vlid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `VendorLevel`
+--
+
+LOCK TABLES `VendorLevel` WRITE;
+/*!40000 ALTER TABLE `VendorLevel` DISABLE KEYS */;
+/*!40000 ALTER TABLE `VendorLevel` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `VendorSpecificTypes`
+--
+
+DROP TABLE IF EXISTS `VendorSpecificTypes`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `VendorSpecificTypes` (
+ `vid` int(11) DEFAULT NULL,
+ `vtid` int(11) DEFAULT NULL,
+ KEY `vid` (`vid`),
+ KEY `vtid` (`vtid`),
+ CONSTRAINT `VendorSpecificTypes_ibfk_1` FOREIGN KEY (`vid`) REFERENCES `Vendor` (`vid`),
+ CONSTRAINT `VendorSpecificTypes_ibfk_2` FOREIGN KEY (`vtid`) REFERENCES `VendorType` (`vtid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `VendorSpecificTypes`
+--
+
+LOCK TABLES `VendorSpecificTypes` WRITE;
+/*!40000 ALTER TABLE `VendorSpecificTypes` DISABLE KEYS */;
+/*!40000 ALTER TABLE `VendorSpecificTypes` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `VendorType`
+--
+
+DROP TABLE IF EXISTS `VendorType`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `VendorType` (
+ `vtid` int(11) NOT NULL AUTO_INCREMENT,
+ `vgid` int(11) DEFAULT NULL,
+ `description` varchar(100) DEFAULT NULL,
+ PRIMARY KEY (`vtid`),
+ KEY `vgid` (`vgid`),
+ CONSTRAINT `VendorType_ibfk_1` FOREIGN KEY (`vgid`) REFERENCES `VendorGroup` (`vgid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `VendorType`
+--
+
+LOCK TABLES `VendorType` WRITE;
+/*!40000 ALTER TABLE `VendorType` DISABLE KEYS */;
+/*!40000 ALTER TABLE `VendorType` ENABLE KEYS */;
+UNLOCK TABLES;
+/*!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 2012-09-18 19:39:04