X-Git-Url: http://shamusworld.gotdns.org/cgi-bin/gitweb.cgi?a=blobdiff_plain;f=schematic-schema.sql;fp=schematic-schema.sql;h=7c4c15f9a8c979c934fab45bb4f943b415b83547;hb=8eb70a8369511a54803410b9bc5918b3077bfb52;hp=d632f3b107a870526cc58ee6d889ce1a7943a7a9;hpb=4560acacef35db75a8bab4854d544d297f6c7cb9;p=schematic diff --git a/schematic-schema.sql b/schematic-schema.sql index d632f3b..7c4c15f 100644 --- a/schematic-schema.sql +++ b/schematic-schema.sql @@ -1,4 +1,4 @@ --- MySQL dump 10.13 Distrib 5.1.62, for pc-linux-gnu (x86_64) +-- MySQL dump 10.13 Distrib 5.5.28, for Linux (x86_64) -- -- Host: localhost Database: schematic -- ------------------------------------------------------ @@ -65,7 +65,7 @@ CREATE TABLE `Contact` ( 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; +) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -74,6 +74,7 @@ CREATE TABLE `Contact` ( LOCK TABLES `Contact` WRITE; /*!40000 ALTER TABLE `Contact` DISABLE KEYS */; +INSERT INTO `Contact` VALUES (2,4,1,'Jo Pesci','jo.pesci@samsung.com','Shanghai','48-3483-23848 x2177','',''),(3,5,2,'John Gearhead','jg@harleydavidson.com','OK City','732-133-1233','','732-133-1240'),(4,6,3,'','','','','',''); /*!40000 ALTER TABLE `Contact` ENABLE KEYS */; UNLOCK TABLES; @@ -88,7 +89,7 @@ CREATE TABLE `ContactType` ( `ctid` int(11) NOT NULL AUTO_INCREMENT, `description` varchar(100) DEFAULT NULL, PRIMARY KEY (`ctid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -97,6 +98,7 @@ CREATE TABLE `ContactType` ( LOCK TABLES `ContactType` WRITE; /*!40000 ALTER TABLE `ContactType` DISABLE KEYS */; +INSERT INTO `ContactType` VALUES (1,'Sales'),(2,'Engineer'),(3,'PR'); /*!40000 ALTER TABLE `ContactType` ENABLE KEYS */; UNLOCK TABLES; @@ -197,7 +199,7 @@ CREATE TABLE `Location` ( PRIMARY KEY (`lid`), KEY `vid` (`vid`), CONSTRAINT `Location_ibfk_1` FOREIGN KEY (`vid`) REFERENCES `Vendor` (`vid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -206,6 +208,7 @@ CREATE TABLE `Location` ( LOCK TABLES `Location` WRITE; /*!40000 ALTER TABLE `Location` DISABLE KEYS */; +INSERT INTO `Location` VALUES (1,4,'723 Pine Scent Way','Shanghai','','China','8W-94732'),(2,5,'1 Harley Way','Oklahoma City','Oklahoma','USA','24678'),(3,6,'','','','',''); /*!40000 ALTER TABLE `Location` ENABLE KEYS */; UNLOCK TABLES; @@ -218,9 +221,12 @@ DROP TABLE IF EXISTS `Notes`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `Notes` ( `nid` int(11) NOT NULL AUTO_INCREMENT, + `uid` int(11) NOT NULL, `poid` int(11) DEFAULT NULL, `note` varchar(200) DEFAULT NULL, - PRIMARY KEY (`nid`) + PRIMARY KEY (`nid`), + KEY `uid` (`uid`), + CONSTRAINT `Notes_ibfk_1` FOREIGN KEY (`uid`) REFERENCES `User` (`uid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; @@ -332,7 +338,7 @@ CREATE TABLE `Vendor` ( PRIMARY KEY (`vid`), KEY `vlid` (`vlid`), CONSTRAINT `Vendor_ibfk_1` FOREIGN KEY (`vlid`) REFERENCES `VendorLevel` (`vlid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -341,6 +347,7 @@ CREATE TABLE `Vendor` ( LOCK TABLES `Vendor` WRITE; /*!40000 ALTER TABLE `Vendor` DISABLE KEYS */; +INSERT INTO `Vendor` VALUES (1,1,0,'Sanford & Sons'),(2,3,0,'Haliburton'),(3,2,1,'Digikey'),(4,2,1,'Samsung'),(5,1,1,'Harley Davidson'),(6,1,0,'Amazing Scientific'); /*!40000 ALTER TABLE `Vendor` ENABLE KEYS */; UNLOCK TABLES; @@ -356,7 +363,7 @@ CREATE TABLE `VendorGroup` ( `seqNo` int(4) NOT NULL, `description` varchar(100) DEFAULT NULL, PRIMARY KEY (`vgid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -365,6 +372,7 @@ CREATE TABLE `VendorGroup` ( LOCK TABLES `VendorGroup` WRITE; /*!40000 ALTER TABLE `VendorGroup` DISABLE KEYS */; +INSERT INTO `VendorGroup` VALUES (1,1,'Machine'); /*!40000 ALTER TABLE `VendorGroup` ENABLE KEYS */; UNLOCK TABLES; @@ -381,7 +389,7 @@ CREATE TABLE `VendorLevel` ( `color` int(4) DEFAULT NULL, `description` varchar(100) DEFAULT NULL, PRIMARY KEY (`vlid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -390,9 +398,7 @@ CREATE TABLE `VendorLevel` ( LOCK TABLES `VendorLevel` WRITE; /*!40000 ALTER TABLE `VendorLevel` DISABLE KEYS */; -INSERT INTO `VendorLevel` VALUES (1,1,65280,'1;Trusted'); -INSERT INTO `VendorLevel` VALUES (2,1,255,'2;Caution Advised'); -INSERT INTO `VendorLevel` VALUES (3,0,16719904,'X;DO NOT USE'); +INSERT INTO `VendorLevel` VALUES (1,1,65280,'1;Trusted'),(2,1,255,'2;Caution Advised'),(3,0,16719904,'X;DO NOT USE'); /*!40000 ALTER TABLE `VendorLevel` ENABLE KEYS */; UNLOCK TABLES; @@ -419,6 +425,7 @@ CREATE TABLE `VendorSpecificTypes` ( LOCK TABLES `VendorSpecificTypes` WRITE; /*!40000 ALTER TABLE `VendorSpecificTypes` DISABLE KEYS */; +INSERT INTO `VendorSpecificTypes` VALUES (1,2),(1,3),(1,5),(3,1),(3,3),(3,4),(5,1),(5,2),(5,3),(5,4); /*!40000 ALTER TABLE `VendorSpecificTypes` ENABLE KEYS */; UNLOCK TABLES; @@ -437,7 +444,7 @@ CREATE TABLE `VendorType` ( PRIMARY KEY (`vtid`), KEY `vgid` (`vgid`), CONSTRAINT `VendorType_ibfk_1` FOREIGN KEY (`vgid`) REFERENCES `VendorGroup` (`vgid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -446,6 +453,7 @@ CREATE TABLE `VendorType` ( LOCK TABLES `VendorType` WRITE; /*!40000 ALTER TABLE `VendorType` DISABLE KEYS */; +INSERT INTO `VendorType` VALUES (1,1,2,'Cutter'),(2,1,3,'Sheet Metal'),(3,1,4,'EDM Wire'),(4,1,5,'CNC'),(5,1,6,'Casting'); /*!40000 ALTER TABLE `VendorType` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; @@ -458,4 +466,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2012-09-19 21:10:12 +-- Dump completed on 2012-12-05 10:13:50