-- phpMyAdmin SQL Dump
-- version 3.4.3.1
-- http://www.phpmyadmin.net
--
-- Host: funspec.ccbr.utoronto.ca
-- Generation Time: Apr 27, 2015 at 10:59 AM
-- Server version: 5.1.73
-- PHP Version: 5.3.2-1ubuntu4.30

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `cisbp_1.02`
--

-- --------------------------------------------------------

--
-- Table structure for table `tf_sources`
--

CREATE TABLE IF NOT EXISTS `tf_sources` (
  `TSource_ID` varchar(11) NOT NULL,
  `TfSource_Name` varchar(40) DEFAULT NULL,
  `TfSource_URL` text,
  `TfSource_Year` int(11) DEFAULT NULL,
  `TfSource_Month` varchar(3) DEFAULT NULL,
  `TfSource_Day` int(11) DEFAULT NULL,
  PRIMARY KEY (`TSource_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tf_sources`
--

INSERT INTO `tf_sources` (`TSource_ID`, `TfSource_Name`, `TfSource_URL`, `TfSource_Year`, `TfSource_Month`, `TfSource_Day`) VALUES
('TS01_1.02', 'Broad', 'http://www.broadinstitute.org/', 2010, 'Dec', 7),
('TS02_1.02', 'Broad', 'http://www.broadinstitute.org/', 2010, 'Oct', 20),
('TS03_1.02', 'Broad', 'http://www.broadinstitute.org/', 2010, 'Oct', 27),
('TS04_1.02', 'Broad', 'http://www.broadinstitute.org/', 2011, 'Nov', 22),
('TS05_1.02', 'Broad', 'http://www.broadinstitute.org/', 2011, 'Oct', 20),
('TS06_1.02', 'Broad', 'http://www.broadinstitute.org/', 2011, 'Oct', 22),
('TS07_1.02', 'Broad', 'http://www.broadinstitute.org/', 2011, 'Oct', 27),
('TS08_1.02', 'Cannabis sativa genome', 'http://genome.ccbr.utoronto.ca/', 2012, 'Feb', 20),
('TS09_1.02', 'Cyanidioschyzon merolae Genome Project', 'http://merolae.biol.s.u-tokyo.ac.jp/', 2008, 'Jan', 18),
('TS10_1.02', 'DroSpeGe', 'http://insects.eugenes.org/', 2008, 'Aug', 12),
('TS11_1.02', 'DroSpeGe', 'http://insects.eugenes.org/', 2008, 'Aug', 8),
('TS12_1.02', 'DroSpeGe', 'http://insects.eugenes.org/', 2008, 'Jul', 18),
('TS13_1.02', 'Ensembl', 'http://www.ensembl.org/', 2010, 'Aug', 24),
('TS14_1.02', 'Ensembl', 'http://www.ensembl.org/', 2010, 'Aug', 26),
('TS15_1.02', 'Ensembl', 'http://www.ensembl.org/', 2010, 'Aug', 27),
('TS16_1.02', 'Ensembl', 'http://www.ensembl.org/', 2010, 'Jul', 29),
('TS17_1.02', 'Ensembl', 'http://www.ensembl.org/', 2010, 'Mar', 3),
('TS18_1.02', 'Ensembl', 'http://www.ensembl.org/', 2011, 'Oct', 13),
('TS19_1.02', 'Ensembl', 'http://www.ensembl.org/', 2011, 'Oct', 26),
('TS20_1.02', 'EuPathDB', 'http://eupathdb.org/', 2010, 'Aug', 1),
('TS21_1.02', 'EuPathDB', 'http://eupathdb.org/', 2010, 'Aug', 30),
('TS22_1.02', 'EuPathDB', 'http://eupathdb.org/', 2010, 'Aug', 6),
('TS23_1.02', 'EuPathDB', 'http://eupathdb.org/', 2010, 'Jan', 4),
('TS24_1.02', 'EuPathDB', 'http://eupathdb.org/', 2010, 'Jul', 26),
('TS25_1.02', 'EuPathDB', 'http://eupathdb.org/', 2010, 'Jul', 31),
('TS26_1.02', 'EuPathDB', 'http://eupathdb.org/', 2010, 'Sep', 1),
('TS27_1.02', 'EuPathDB', 'http://eupathdb.org/', 2010, 'Sep', 21),
('TS28_1.02', 'Genoscope', 'http://www.genoscope.cns.fr/', 2014, 'Aug', 4),
('TS29_1.02', 'HughesLab', 'http://hugheslab.ccbr.utoronto.ca/', 2013, 'Jun', 13),
('TS30_1.02', 'HughesLab', 'http://hugheslab.ccbr.utoronto.ca/', 2013, 'Jun', 29),
('TS31_1.02', 'HughesLab', 'http://hugheslab.ccbr.utoronto.ca/', 2014, 'Aug', 4),
('TS32_1.02', 'JGI', 'http://genome.jgi-psf.org/', 2005, 'Dec', 8),
('TS33_1.02', 'JGI', 'http://genome.jgi-psf.org/', 2005, 'May', 31),
('TS34_1.02', 'JGI', 'http://genome.jgi-psf.org/', 2006, 'Aug', 29),
('TS35_1.02', 'JGI', 'http://genome.jgi-psf.org/', 2006, 'Dec', 22),
('TS36_1.02', 'JGI', 'http://genome.jgi-psf.org/', 2006, 'Dec', 5),
('TS37_1.02', 'JGI', 'http://genome.jgi-psf.org/', 2006, 'Mar', 2),
('TS38_1.02', 'JGI', 'http://genome.jgi-psf.org/', 2006, 'Nov', 28),
('TS39_1.02', 'JGI', 'http://genome.jgi-psf.org/', 2006, 'Oct', 20),
('TS40_1.02', 'JGI', 'http://genome.jgi-psf.org/', 2007, 'Apr', 24),
('TS41_1.02', 'JGI', 'http://genome.jgi-psf.org/', 2007, 'Aug', 18),
('TS42_1.02', 'JGI', 'http://genome.jgi-psf.org/', 2007, 'Dec', 17),
('TS43_1.02', 'JGI', 'http://genome.jgi-psf.org/', 2007, 'Dec', 21),
('TS44_1.02', 'JGI', 'http://genome.jgi-psf.org/', 2007, 'Feb', 8),
('TS45_1.02', 'JGI', 'http://genome.jgi-psf.org/', 2007, 'Jan', 17),
('TS46_1.02', 'JGI', 'http://genome.jgi-psf.org/', 2007, 'Jan', 22),
('TS47_1.02', 'JGI', 'http://genome.jgi-psf.org/', 2007, 'Jul', 12),
('TS48_1.02', 'JGI', 'http://genome.jgi-psf.org/', 2007, 'Jul', 5),
('TS49_1.02', 'JGI', 'http://genome.jgi-psf.org/', 2007, 'Jun', 18),
('TS50_1.02', 'JGI', 'http://genome.jgi-psf.org/', 2007, 'May', 31),
('TS51_1.02', 'JGI', 'http://genome.jgi-psf.org/', 2007, 'Sep', 24),
('TS52_1.02', 'JGI', 'http://genome.jgi-psf.org/', 2008, 'Apr', 18),
('TS53_1.02', 'JGI', 'http://genome.jgi-psf.org/', 2008, 'Aug', 6),
('TS54_1.02', 'JGI', 'http://genome.jgi-psf.org/', 2008, 'Dec', 19),
('TS55_1.02', 'JGI', 'http://genome.jgi-psf.org/', 2008, 'Feb', 27),
('TS56_1.02', 'JGI', 'http://genome.jgi-psf.org/', 2008, 'Jun', 26),
('TS57_1.02', 'JGI', 'http://genome.jgi-psf.org/', 2008, 'Jun', 9),
('TS58_1.02', 'JGI', 'http://genome.jgi-psf.org/', 2008, 'Mar', 10),
('TS59_1.02', 'JGI', 'http://genome.jgi-psf.org/', 2008, 'Mar', 19),
('TS60_1.02', 'JGI', 'http://genome.jgi-psf.org/', 2008, 'Mar', 20),
('TS61_1.02', 'JGI', 'http://genome.jgi-psf.org/', 2008, 'May', 22),
('TS62_1.02', 'JGI', 'http://genome.jgi-psf.org/', 2008, 'Nov', 7),
('TS63_1.02', 'JGI', 'http://genome.jgi-psf.org/', 2008, 'Sep', 10),
('TS64_1.02', 'JGI', 'http://genome.jgi-psf.org/', 2009, 'Apr', 10),
('TS65_1.02', 'JGI', 'http://genome.jgi-psf.org/', 2009, 'Apr', 7),
('TS66_1.02', 'JGI', 'http://genome.jgi-psf.org/', 2009, 'Apr', 9),
('TS67_1.02', 'JGI', 'http://genome.jgi-psf.org/', 2009, 'Dec', 7),
('TS68_1.02', 'JGI', 'http://genome.jgi-psf.org/', 2009, 'Feb', 27),
('TS69_1.02', 'JGI', 'http://genome.jgi-psf.org/', 2009, 'Jan', 30),
('TS70_1.02', 'JGI', 'http://genome.jgi-psf.org/', 2009, 'Mar', 24),
('TS71_1.02', 'JGI', 'http://genome.jgi-psf.org/', 2009, 'Mar', 6),
('TS72_1.02', 'JGI', 'http://genome.jgi-psf.org/', 2009, 'May', 22),
('TS73_1.02', 'JGI', 'http://genome.jgi-psf.org/', 2009, 'May', 8),
('TS74_1.02', 'JGI', 'http://genome.jgi-psf.org/', 2009, 'Nov', 19),
('TS75_1.02', 'JGI', 'http://genome.jgi-psf.org/', 2009, 'Oct', 6),
('TS76_1.02', 'JGI', 'http://genome.jgi-psf.org/', 2010, 'Aug', 5),
('TS77_1.02', 'JGI', 'http://genome.jgi-psf.org/', 2010, 'Feb', 23),
('TS78_1.02', 'JGI', 'http://genome.jgi-psf.org/', 2010, 'Feb', 24),
('TS79_1.02', 'JGI', 'http://genome.jgi-psf.org/', 2010, 'Jan', 20),
('TS80_1.02', 'JGI', 'http://genome.jgi-psf.org/', 2010, 'Jan', 8),
('TS81_1.02', 'MaizeSequence', 'http://maizesequence.org/', 2014, 'Aug', 11),
('TS82_1.02', 'MaizeSequence', 'http://maizesequence.org/', 2014, 'Aug', 4),
('TS83_1.02', 'NCBI', 'http://www.ncbi.nlm.nih.gov/guide/proteins/', 2010, 'Oct', 26),
('TS84_1.02', 'NCBI', 'http://www.ncbi.nlm.nih.gov/guide/proteins/', 2011, 'Jan', 10),
('TS85_1.02', 'NCBI', 'http://www.ncbi.nlm.nih.gov/guide/proteins/', 2014, 'Aug', 4),
('TS86_1.02', 'OxyDB', 'http://oxy.ciliate.org/', 2014, 'Oct', 14),
('TS87_1.02', 'PlantGDB', 'http://www.plantgdb.org/', 2010, 'Oct', 15),
('TS88_1.02', 'Pneumocystis Genome Project', 'http://pgp.cchmc.org/', 2010, 'Oct', 5),
('TS89_1.02', 'SDSPB', 'http://lifecenter.sgst.cn/main/en/index.do/', 2008, 'Sep', 5),
('TS90_1.02', 'SGD', 'http://yeastgenome.org/', 2003, 'Oct', 3),
('TS91_1.02', 'SilkDB', 'http://www.silkdb.org/silkdb/', 2008, 'Apr', 11),
('TS92_1.02', 'Superfamily', 'http://supfam.cs.bris.ac.uk/SUPERFAMILY/', 2011, 'Oct', 25),
('TS93_1.02', 'Superfamily', 'http://supfam.cs.bris.ac.uk/SUPERFAMILY/', 2011, 'Oct', 26),
('TS94_1.02', 'UniProt', 'http://www.uniprot.org/', 2013, 'Jan', 11),
('TS95_1.02', 'Xenbase', 'http://www.xenbase.org/common/', 2010, 'Oct', 22);

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
