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;