--
-- Host: localhost    Database: hgFixed
-- ------------------------------------------------------


--
-- Table structure for table `encodeExp`
--

CREATE TABLE `encodeExp` (
  `ix` int(11) NOT NULL AUTO_INCREMENT,
  `organism` varchar(255) NOT NULL,
  `lab` varchar(255) NOT NULL,
  `dataType` varchar(255) NOT NULL,
  `cellType` varchar(255) NOT NULL,
  `expVars` varchar(255) DEFAULT NULL,
  `accession` varchar(255) DEFAULT NULL,
  `updateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`ix`)
) ENGINE=MyISAM AUTO_INCREMENT=3504 DEFAULT CHARSET=latin1;



--
-- WARNING: old server version. The following dump may be incomplete.
--
DELIMITER ;;
/*!50003 SET SESSION SQL_MODE="" */;;
/*!50003 CREATE */ /*!50017 DEFINER=`hgcat`@`localhost` */ /*!50003 TRIGGER `encodeExp_insert` AFTER INSERT ON `encodeExp` FOR EACH ROW INSERT INTO encodeExpHistory VALUES 
(NEW.ix, NEW.organism, NEW.lab, NEW.dataType, NEW.cellType, NEW.expVars, NEW.accession, NOW(), 'I', USER(), '') */;;
DELIMITER ;
--
-- WARNING: old server version. The following dump may be incomplete.
--
DELIMITER ;;
/*!50003 SET SESSION SQL_MODE="" */;;
/*!50003 CREATE */ /*!50017 DEFINER=`hgcat`@`localhost` */ /*!50003 TRIGGER `encodeExp_update` AFTER UPDATE ON `encodeExp` FOR EACH ROW INSERT INTO encodeExpHistory VALUES 
(NEW.ix, NEW.organism, NEW.lab, NEW.dataType, NEW.cellType, NEW.expVars, NEW.accession, NOW(), 'U', USER(), '') */;;
DELIMITER ;
--
-- WARNING: old server version. The following dump may be incomplete.
--
DELIMITER ;;
/*!50003 SET SESSION SQL_MODE="" */;;
/*!50003 CREATE */ /*!50017 DEFINER=`hgcat`@`localhost` */ /*!50003 TRIGGER `encodeExp_delete` AFTER DELETE ON `encodeExp` FOR EACH ROW INSERT INTO encodeExpHistory VALUES 
(OLD.ix, OLD.organism, OLD.lab, OLD.dataType, OLD.cellType, OLD.expVars, OLD.accession, NOW(), 'D', USER(), '') */;;
DELIMITER ;
