   `q113` varchar(100) DEFAULT 'NA',
   `positionnos` varchar(300) DEFAULT 'NONE',
   UNIQUE KEY `assmblyid` (`assmblyid`)
-) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=latin1;
 
 /*Data for the table `project_assembly` */
 
-insert  into `project_assembly`(`assmblyid`,`projectid`,`faintegration`,`assemblynotes`,`q101`,`q102`,`q103`,`q104`,`q105`,`q106`,`q107`,`q108`,`q109`,`q110`,`q112`,`q113`,`positionnos`) values (3,18,'NONE','','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NONE'),(4,19,'NONE',NULL,'NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NONE'),(5,20,'NONE',NULL,'NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NONE'),(11,32,'NONE',NULL,'NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NONE'),(12,33,'NONE',NULL,'NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NONE'),(13,34,'NONE',NULL,'NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NONE'),(14,35,'NONE',NULL,'NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NONE'),(15,36,'NONE',NULL,'NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NONE'),(16,37,'NONE',NULL,'NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NONE'),(17,38,'NONE',NULL,'NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NONE'),(18,39,'NONE',NULL,'NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NONE'),(19,40,'NONE',NULL,'NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NONE'),(20,41,'NONE',NULL,'NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NONE'),(21,42,'NONE',NULL,'NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NONE'),(22,43,'NONE',NULL,'NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NONE'),(23,44,'NONE',NULL,'NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NONE'),(24,45,'NONE',NULL,'NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NONE'),(25,46,'NONE',NULL,'NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NONE'),(26,47,'NONE',NULL,'NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NONE'),(27,48,'NONE',NULL,'NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NONE'),(28,44,'NONE',NULL,'NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NONE'),(29,45,'NONE',NULL,'NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NONE'),(30,46,'NONE',NULL,'NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NONE'),(31,47,'NONE',NULL,'NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NONE'),(32,48,'NONE',NULL,'NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NONE'),(33,49,'NONE',NULL,'NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NONE'),(34,50,'NONE',NULL,'NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NONE'),(35,51,'NONE',NULL,'NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NONE'),(36,52,'NONE',NULL,'NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NONE'),(37,53,'NONE',NULL,'NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NONE'),(38,54,'NONE1','adfasdf1111','NA','NA','YES','YES','NO','YES','YES','NO','YES','YES','NA','NA','444');
+insert  into `project_assembly`(`assmblyid`,`projectid`,`faintegration`,`assemblynotes`,`q101`,`q102`,`q103`,`q104`,`q105`,`q106`,`q107`,`q108`,`q109`,`q110`,`q112`,`q113`,`positionnos`) values (57,72,'NONE',NULL,'NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NA','NONE');
+
+/*Table structure for table `project_design` */
+
+DROP TABLE IF EXISTS `project_design`;
+
+CREATE TABLE `project_design` (
+  `designid` bigint(20) NOT NULL AUTO_INCREMENT,
+  `projectid` bigint(20) DEFAULT NULL,
+  `designname` varchar(500) DEFAULT 'NONE',
+  `q31` varchar(100) DEFAULT 'NA',
+  `q32` varchar(100) DEFAULT 'NA',
+  `q33` varchar(100) DEFAULT 'NA',
+  `designextra1` text,
+  `deq1` varchar(100) DEFAULT 'NA',
+  `designextra2` text,
+  `deq2` varchar(100) DEFAULT 'NA',
+  `designnotes` text,
+  PRIMARY KEY (`designid`)
+) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=latin1;
+
+/*Data for the table `project_design` */
+
+insert  into `project_design`(`designid`,`projectid`,`designname`,`q31`,`q32`,`q33`,`designextra1`,`deq1`,`designextra2`,`deq2`,`designnotes`) values (19,72,'NONE','NA','NA','NA',NULL,'NA',NULL,'NA',NULL);
 
 /*Table structure for table `project_incompletes` */
 

  `formdate` date DEFAULT NULL,
  `originator` varchar(300) DEFAULT NULL,
  PRIMARY KEY (`projectid`)
) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=latin1;

/*Data for the table `project` */

insert  into `project`(`projectid`,`projectname`,`projectnumber`,`projecttype`,`formdate`,`originator`) values (18,'Haywan 2','398438','Counter Smart','2016-11-27','Name Here'),(42,'Haywan Project','1133458','Honeywell','2016-12-30','Elvin Casem'),(43,'project sample','123456','Custom','2016-12-15','ME'),(53,'New Project','12345','Counter Smart','2017-01-07','Elvin Casem');

/*Table structure for table `project_assembly` */


  `pmexsolution` varchar(300) DEFAULT 'NONE',
  `pmexdate` date NOT NULL,
  PRIMARY KEY (`pdetailsqid`)
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=latin1;

/*Data for the table `project_incompletes_q` */

insert  into `project_incompletes_q`(`pdetailsqid`,`projectid`,`authshipment`,`authsolution`,`authdate`,`hardwarebox`,`authpackaged`,`pmsee`,`pmsolution`,`pmdate`,`pmexception`,`pmexsolution`,`pmexdate`) values (58,72,'NO','NONE','0000-00-00','NO','NO','NO','NONE','0000-00-00','NO','NONE','0000-00-00');

/*Table structure for table `project_notes` */

DROP TABLE IF EXISTS `project_notes`;

CREATE TABLE `project_notes` (
  `notesid` bigint(20) NOT NULL AUTO_INCREMENT,
  `projectid` bigint(20) DEFAULT NULL,
  `installernotes` text,
  `integrationrep` varchar(500) DEFAULT 'NONE',
  `packagingrep` varchar(500) DEFAULT 'NONE',
  `datetimerelease` datetime DEFAULT NULL,
  PRIMARY KEY (`notesid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

/*Data for the table `project_notes` */

insert  into `project_notes`(`notesid`,`projectid`,`installernotes`,`integrationrep`,`packagingrep`,`datetimerelease`) values (3,72,NULL,'NONE','NONE',NULL);

/*Table structure for table `project_packaging` */

DROP TABLE IF EXISTS `project_packaging`;

CREATE TABLE `project_packaging` (
  `packagingid` bigint(20) NOT NULL AUTO_INCREMENT,
  `projectid` bigint(20) DEFAULT NULL,
  `packagingname` varchar(500) DEFAULT 'NONE',
  `q51` varchar(100) DEFAULT 'NA',
  `q52` varchar(100) DEFAULT 'NA',
  `q53` varchar(100) DEFAULT 'NA',
  `q55` varchar(100) DEFAULT 'NA',
  `q56` varchar(100) DEFAULT 'NA',
  `q57` varchar(100) DEFAULT 'NA',
  `q58` varchar(100) DEFAULT 'NA',
  `q59` varchar(100) DEFAULT 'NA',
  `q60` varchar(100) DEFAULT 'NA',
  `packagingnotes` text,
  PRIMARY KEY (`packagingid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

/*Data for the table `project_packaging` */

insert  into `project_packaging`(`packagingid`,`projectid`,`packagingname`,`q51`,`q52`,`q53`,`q55`,`q56`,`q57`,`q58`,`q59`,`q60`,`packagingnotes`) values (3,72,'NONE','NA','NA','NA','NA','NA','NA','NA','NA','NA',NULL);

/*Table structure for table `project_qualityassurance` */

DROP TABLE IF EXISTS `project_qualityassurance`;

CREATE TABLE `project_qualityassurance` (
  `qaid` bigint(20) NOT NULL AUTO_INCREMENT,
  `projectid` bigint(20) DEFAULT NULL,
  `qaname` varchar(500) DEFAULT 'NONE',
  `q41` varchar(100) DEFAULT 'NA',
  `q42` varchar(100) DEFAULT 'NA',
  `q43` varchar(100) DEFAULT 'NA',
  `qanotes` text,
  PRIMARY KEY (`qaid`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;

/*Data for the table `project_qualityassurance` */

insert  into `project_qualityassurance`(`qaid`,`projectid`,`qaname`,`q41`,`q42`,`q43`,`qanotes`) values (17,72,'NONE','NA','NA','NA',NULL);

/*Table structure for table `project_regular` */

