Move DB access to NoteDialog class, new AlertDialog class.

[schematic] / schematic-schema.sql

diff --git a/schematic-schema.sql b/schematic-schema.sql
index 4d1a59d9d70e1153d4474a5a7020b7153de1659c..7c4c15f9a8c979c934fab45bb4f943b415b83547 100644 (file)
--- 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,6 +398,7 @@ CREATE TABLE `VendorLevel` (
 
 LOCK TABLES `VendorLevel` WRITE;
 /*!40000 ALTER TABLE `VendorLevel` DISABLE KEYS */;
+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;
 
@@ -416,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;
 
@@ -434,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 */;
 
 --
@@ -443,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 */;
@@ -455,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