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,
  `person` varchar(30) DEFAULT substring_index(user(),'@',1),
  PRIMARY KEY (`pkey`)
 
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;


LOCK TABLES `allele` WRITE;

INSERT INTO `allele` VALUES (1,null);

UNLOCK TABLES;