DROP DATABASE IF EXISTS `SGC`; CREATE DATABASE `SGC` ; USE `SGC`; DROP TABLE IF EXISTS `allele`; CREATE TABLE `allele` ( `pkey` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`pkey`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; LOCK TABLES `allele` WRITE; INSERT INTO `allele` VALUES (1); UNLOCK TABLES;