-- Dumping structure for table cert.tsupply
DROP TABLE IF EXISTS `tsupply`;
CREATE TABLE IF NOT EXISTS `tsupply` (
  `RNUM` int(11) NOT NULL,
  `SNO` varchar(2) DEFAULT NULL,
  `PNO` varchar(2) DEFAULT NULL,
  `JNO` varchar(2) DEFAULT NULL,
  `QTY` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Dumping data for table cert.tsupply: ~24 rows (approximately)
/*!40000 ALTER TABLE `tsupply` DISABLE KEYS */;
INSERT INTO `tsupply` (`RNUM`, `SNO`, `PNO`, `JNO`, `QTY`) VALUES
	(0, 'S1', 'P1', 'J1', 200),
	(1, 'S1', 'P1', 'J4', 700),
	(2, 'S2', 'P3', 'J1', 400),
	(3, 'S2', 'P3', 'J2', 200),
	(4, 'S2', 'P3', 'J3', 200),
	(5, 'S2', 'P3', 'J4', 500),
	(6, 'S2', 'P3', 'J5', 600),
	(7, 'S2', 'P3', 'J6', 400),
	(8, 'S2', 'P3', 'J7', 800),
	(9, 'S2', 'P5', 'J2', 100),
	(10, 'S3', 'P3', 'J1', 200),
	(11, 'S3', 'P4', 'J2', 500),
	(12, 'S4', 'P6', 'J3', 300),
	(13, 'S4', 'P6', 'J7', 300),
	(14, 'S5', 'P2', 'J2', 200),
	(15, 'S5', 'P2', 'J4', 100),
	(16, 'S5', 'P5', 'J5', 500),
	(17, 'S5', 'P5', 'J7', 100),
	(18, 'S5', 'P6', 'J2', 200),
	(19, 'S5', 'P1', 'J4', 100),
	(20, 'S5', 'P3', 'J4', 200),
	(21, 'S5', 'P4', 'J4', 800),
	(22, 'S5', 'P5', 'J4', 400),
	(23, 'S5', 'P6', 'J4', 500);
/*!40000 ALTER TABLE `tsupply` ENABLE KEYS */;

-- Dumping structure for table cert.tparts
DROP TABLE IF EXISTS `tparts`;
CREATE TABLE IF NOT EXISTS `tparts` (
  `RNUM` int(11) NOT NULL,
  `PNO` varchar(2) DEFAULT NULL,
  `PNAME` varchar(10) DEFAULT NULL,
  `COLOR` varchar(8) DEFAULT NULL,
  `WEIGHT` int(11) DEFAULT NULL,
  `CITY` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Dumping data for table cert.tparts: ~7 rows (approximately)
/*!40000 ALTER TABLE `tparts` DISABLE KEYS */;
INSERT INTO `tparts` (`RNUM`, `PNO`, `PNAME`, `COLOR`, `WEIGHT`, `CITY`) VALUES
	(0, 'P1', 'Nut', 'Red', 12, 'London'),
	(1, 'P2', 'Bolt', 'Green', 17, 'Paris'),
	(2, 'P3', 'Screw', 'Blue', 17, 'Rome'),
	(3, 'P4', 'Screw', 'Red', 14, 'London'),
	(4, 'P5', 'Cam', 'Blue', 12, 'Paris'),
	(5, 'P6', 'Cog', 'Red', 19, 'London'),
	(6, 'P7', 'Shaft', NULL, NULL, NULL);
/*!40000 ALTER TABLE `tparts` ENABLE KEYS */;