   KEY `FKSales_order` (`SalesNo`),
   KEY `CustomerNo` (`CustomerNo`),
   CONSTRAINT `tblorder_ibfk_1` FOREIGN KEY (`CustomerNo`) REFERENCES `customer` (`CustomerNo`) ON DELETE SET NULL ON UPDATE CASCADE
-) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
 /*Data for the table `tblorder` */
 

  `Description` text,
  `ImageFile` text,
  PRIMARY KEY (`Level1No`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=latin1;

/*Data for the table `level1` */

insert  into `level1`(`Level1No`,`Name1`,`Description`,`ImageFile`) values (26,'Building Materials',NULL,NULL),(27,'Door',NULL,NULL),(28,'Electrical',NULL,NULL),(29,'Hardware',NULL,NULL);

/*Table structure for table `level2` */


  `Description` text,
  `Level1No` int(11) DEFAULT NULL,
  PRIMARY KEY (`Level2No`)
) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=latin1;

/*Data for the table `level2` */

insert  into `level2`(`Level2No`,`Name2`,`Description`,`Level1No`) values (42,'Roofing',NULL,26),(43,'Building Supplies',NULL,26),(44,'Ligthning',NULL,28),(45,'Electrical supplies',NULL,28),(46,'Door Essentials',NULL,29),(47,'Pipe',NULL,29),(48,'Hardware Accessories',NULL,29),(49,'Chemicals',NULL,30),(50,'Equipment/Materials',NULL,30),(51,'Faucets',NULL,31),(52,'Kitchen Sink',NULL,31),(53,'Shower',NULL,31),(54,'Hand Tools',NULL,32),(55,'Power Tools',NULL,32);

/*Table structure for table `level3` */

