-- http://www.phpmyadmin.net
--




--
-- Database: `tmiva_ejf2`
--

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

--
-- Table structure for table `clients`
--

CREATE TABLE IF NOT EXISTS `clients` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL DEFAULT '0',
  `first_name` varchar(60) DEFAULT NULL,
  `last_name` varchar(60) DEFAULT NULL,
  `company_name` varchar(100) DEFAULT NULL,
  `address_1` varchar(100) DEFAULT NULL,
  `address_2` varchar(100) DEFAULT NULL,
  `city` varchar(60) DEFAULT NULL,
  `state` char(2) DEFAULT NULL,
  `zip_code` mediumint(5) unsigned DEFAULT NULL,
  `phone` bigint(20) unsigned DEFAULT NULL,
  `phone_type` enum('Home','Work','Mobile','Other') NOT NULL DEFAULT 'Home',
  `fax` bigint(20) unsigned DEFAULT NULL,
  `email` varchar(60) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;

--
-- Dumping data for table `clients`
--

INSERT INTO `clients` (`id`, `user_id`, `first_name`, `last_name`, `company_name`, `address_1`, `address_2`, `city`, `state`, `zip_code`, `phone`, `phone_type`, `fax`, `email`) VALUES
(4, 2, 'Josh', 'West', 'Technology Management International', '901 N. Glebe Road', 'Suite 1010', 'Arlington', 'VA', 22202, 5402465674, 'Mobile', 7035677655, 'josh@tmiva.com'),
(5, 13, 'Joshua', 'West', 'TMI', '901 N. Glebe Road', 'Suite 1010', 'Arlington', 'VA', 22201, 7035054059, 'Mobile', 7035677655, 'josh@tmiva.com'),
(6, 15, NULL, NULL, NULL, NULL, NULL, NULL, 'AL', NULL, NULL, 'Home', NULL, NULL),
(7, 19, NULL, NULL, 'TMIVA', NULL, NULL, 'Arlington', 'WA', 22192, 2147483647, 'Home', 0, NULL),
(13, 32, NULL, NULL, NULL, NULL, NULL, NULL, 'AL', NULL, NULL, 'Home', NULL, NULL),
(8, 24, NULL, NULL, 'tmiva', NULL, NULL, NULL, 'AL', NULL, 5555055050, 'Home', NULL, NULL),
(9, 25, 'Levert', 'James', 'tmi', '12414 Everest Peak Ln.', NULL, 'Woodbridge', 'VA', 22192, 7032170905, 'Home', NULL, 'levert.james.jr@gmail.com'),
(10, 30, NULL, NULL, NULL, NULL, NULL, NULL, 'AL', NULL, NULL, 'Home', NULL, NULL),
(11, 31, NULL, NULL, NULL, NULL, NULL, NULL, 'AL', NULL, NULL, 'Home', NULL, NULL),
(12, 23, NULL, NULL, NULL, NULL, NULL, NULL, 'AL', NULL, NULL, 'Home', NULL, NULL),
(14, 36, NULL, NULL, NULL, NULL, NULL, NULL, 'AL', NULL, NULL, 'Home', NULL, NULL),
(15, 40, 'Levert', 'James', 'TMIVA', '1800 Wilson Blvd.', NULL, 'Arlington', 'VA', 22222, NULL, 'Home', NULL, NULL),
(16, 52, NULL, NULL, NULL, NULL, NULL, NULL, 'AL', NULL, NULL, 'Home', NULL, NULL),
(17, 61, NULL, NULL, NULL, NULL, NULL, NULL, 'AL', NULL, NULL, 'Home', NULL, NULL),
(18, 62, NULL, NULL, NULL, NULL, NULL, NULL, 'AL', NULL, NULL, 'Home', NULL, NULL);

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

--
-- Table structure for table `funds`
--

CREATE TABLE IF NOT EXISTS `funds` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL DEFAULT '',
  `description` text,
  `inception_date` int(11) NOT NULL DEFAULT '0',
  `as_of` int(11) DEFAULT NULL,
  `last_month` double DEFAULT NULL,
  `year_to_date` double DEFAULT NULL,
  `12_mos` double DEFAULT NULL,
  `24_mos` double DEFAULT NULL,
  `since_inception` double DEFAULT NULL,
  `minimum_investment` varchar(255) DEFAULT NULL,
  `management_fee` varchar(255) DEFAULT NULL,
  `incentive_allocation` varchar(255) DEFAULT NULL,
  `structure` varchar(100) DEFAULT NULL,
  `lockup` varchar(100) DEFAULT NULL,
  `redemption_fee` varchar(50) NOT NULL DEFAULT '',
  `hurdle_rate` varchar(50) NOT NULL DEFAULT '',
  `prime_broker` varchar(255) DEFAULT NULL,
  `legal_counsel_us` varchar(255) DEFAULT NULL,
  `legal_counsel_caymans` varchar(255) DEFAULT NULL,
  `auditor` varchar(255) DEFAULT NULL,
  `administrator` varchar(255) DEFAULT NULL,
  `open` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `funds`
--

INSERT INTO `funds` (`id`, `name`, `description`, `inception_date`, `as_of`, `last_month`, `year_to_date`, `12_mos`, `24_mos`, `since_inception`, `minimum_investment`, `management_fee`, `incentive_allocation`, `structure`, `lockup`, `redemption_fee`, `hurdle_rate`, `prime_broker`, `legal_counsel_us`, `legal_counsel_caymans`, `auditor`, `administrator`, `open`) VALUES
(1, 'EJF Long/Short Equity Fund, Ltd', 'EJF Long/Short Equity Fund mirrors the investment thought process of the EJF Opportunity Fund. In contrast to the EJF Opportunity Fund, however, the Long/Short Equity Fund employs a portfolio framework that imposes restrictions with respect to gross leverage, net market exposure, position and sector concentrations. The Fund also has portfolio and position level stop/loss disciplines.', 1214280000, 1214280000, 0.16, 2.7, 2.5, NULL, 2.5, ' $500,000 for Individuals, $1,000,000 for Institutions', '1.5% of Net Assets', '20% (with high water mark)', 'Master Feeder (Delaware/Caymans)', '6 months', '', '', 'Banc of America Securities, LLC', 'Fried, Frank, Harris, Shriver & Jacobson LLP', 'Conyers Dill & Pearman', 'Rothstein, Kass & Company, P.C.', 'Citi Hedge Fund Services North America, Inc.', 0),
(2, 'EJF Long/Short Equity Offshore Fund, Ltd', NULL, 1128139200, 1185940800, 0.38, 3, 6.6, NULL, 6.7, NULL, NULL, NULL, NULL, NULL, '', '', NULL, NULL, NULL, NULL, NULL, 0),
(3, 'EJF Opportunity Fund, L.P.', NULL, 1125547200, 1185940800, 0.15, 3.4, -2.1, NULL, -2.1, NULL, NULL, NULL, NULL, NULL, '', '', NULL, NULL, NULL, NULL, NULL, 0),
(4, 'EJF Opportunity Offshore Fund, Ltd', NULL, 1128139200, 1185940800, 0.18, 3.5, -2.1, NULL, -2.1, '2000', NULL, NULL, NULL, NULL, '', '', NULL, NULL, NULL, NULL, NULL, 1);

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

--
-- Table structure for table `fund_files`
--

CREATE TABLE IF NOT EXISTS `fund_files` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `fund_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;

--
-- Dumping data for table `fund_files`
--

INSERT INTO `fund_files` (`id`, `fund_id`, `name`) VALUES
(15, 1, 'Long Short Equity Fund'),
(16, 1, 'NY City');

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

--
-- Table structure for table `investor_documents`
--

CREATE TABLE IF NOT EXISTS `investor_documents` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '',
  `url` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;

--
-- Dumping data for table `investor_documents`
--

INSERT INTO `investor_documents` (`id`, `name`, `url`) VALUES
(7, 'New Document', 'http://www.yahoo.com');

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

--
-- Table structure for table `products`
--

CREATE TABLE IF NOT EXISTS `products` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `description` text,
  `minimum_investment` varchar(255) DEFAULT NULL,
  `management_fee` varchar(255) DEFAULT NULL,
  `incentive_allocation` varchar(255) DEFAULT NULL,
  `structure` varchar(100) DEFAULT NULL,
  `lockup` varchar(100) DEFAULT NULL,
  `prime_broker` varchar(255) DEFAULT NULL,
  `legal_counsel_us` varchar(255) DEFAULT NULL,
  `legal_counsel_caymans` varchar(255) DEFAULT NULL,
  `auditor` varchar(255) DEFAULT NULL,
  `administrator` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `products`
--

INSERT INTO `products` (`id`, `name`, `description`, `minimum_investment`, `management_fee`, `incentive_allocation`, `structure`, `lockup`, `prime_broker`, `legal_counsel_us`, `legal_counsel_caymans`, `auditor`, `administrator`) VALUES
(1, 'EJF Long / Short Equity Fund', 'EJF Long/Short Equity Fund mirrors the investment thought process of the EJF Opportunity Fund. In contrast to the EJF Opportunity Fund, however, the Long/Short Equity Fund employs a portfolio framework that imposes restrictions with respect to gross leverage, net market exposure, position and sector concentrations. The Fund also has portfolio and position level stop/loss disciplines.', '$500,000 for Individuals, $1,000,000 for Institutions', '1.5% of Net Assets', '20% (with high water mark)', 'Master Feeder (Delaware/Caymans)', '6 months', 'Banc of America Securities, LLC', 'Fried, Frank, Harris, Shriver & Jacobson LLP', 'Conyers Dill & Pearman', 'Rothstein, Kass & Company, P.C.', 'Citi Hedge Fund Services North America, Inc.'),
(2, 'EJF Opportunity Fund', 'EJF Opportunity Fund is a long/short equity hedge fund that is traded in the same fashion as a fund with twelve year track record that Emanuel Friedman and his five member portfolio team managed at Friedman, Billings, Ramsey. The Fund may opportunistically invest across all sectors, but may have a slight bias toward financial services given the expertise of Emanuel Friedman and his portfolio team.', '$500,000 for Individuals, $1,000,000 for Institutions', '1.5% of Net Assets', '20% (with high water mark)', 'Master Feeder (Delaware/Caymans)', '6 months with penalty; 1 year no penalty', 'Banc of America Securities, LLC', 'Fried, Frank, Harris, Shriver & Jacobson LLP', 'Conyers Dill & Pearman', 'Rothstein, Kass & Company, P.C.', 'Citi Hedge Fund Services North America, Inc.'),
(3, 'EJF Crossover Fund', 'EJF Crossover Fund is a hedge fund which invests in both private and public securities. On the private side of the portfolio, the Fund will generally invest in newly created or existing late-stage private companies with attractive valuations and a defined path to an investment exit. The Fund will also invest in private securities eligible for resale pursuant to SEC Rule 144A. Within the private investment portion of the portfolio, the Fund may invest across all sectors, but intends to have an emphasis on asset backed, cash flow paying companies. On the public side of the portfolio, the Fund seeks to generate alpha by making concentrated investments in public securities offering unique return opportunities.', '$500,000 for Individuals, $1,000,000 for Institutions', '1.5% of Net Assets', '20% (with high water mark)', 'Master Feeder (Delaware/Caymans)', '2 Years', 'Banc of America Securities, LLC', 'Fried, Frank, Harris, Shriver & Jacobson LLP', 'Conyers Dill & Pearman', 'Rothstein, Kass & Company, P.C.', 'Citi Hedge Fund Services North America, Inc.'),
(5, 'Testing', 'this is the description.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `statementIds`
--

CREATE TABLE IF NOT EXISTS `statementIds` (
  `userId` int(11) NOT NULL DEFAULT '0',
  `statementId` varchar(30) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `statementIds`
--

INSERT INTO `statementIds` (`userId`, `statementId`) VALUES
(40, 'DEF'),
(19, 'ABC'),
(32, 'abc');

