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




--
-- Database: `banq`
--

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

--
-- Table structure for table `groups`
--

CREATE TABLE IF NOT EXISTS `groups` (
  `group_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`group_id`),
  UNIQUE KEY `groups_name_unique` (`name`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

--
-- Dumping data for table `groups`
--

INSERT INTO `groups` (`group_id`, `name`, `status`, `created_at`, `updated_at`) VALUES
(1, 'User', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(2, 'Administrator', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00');

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

--
-- Table structure for table `investments`
--

CREATE TABLE IF NOT EXISTS `investments` (
  `investment_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `offering_id` int(11) NOT NULL,
  `firstname` varchar(255) NOT NULL,
  `lastname` varchar(255) NOT NULL,
  `s2num` varchar(255) NOT NULL,
  `num_shares` int(11) NOT NULL,
  `price` double NOT NULL,
  `total_amount` double NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  PRIMARY KEY (`investment_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `investments`
--

INSERT INTO `investments` (`investment_id`, `user_id`, `offering_id`, `firstname`, `lastname`, `s2num`, `num_shares`, `price`, `total_amount`, `created_at`, `updated_at`, `is_active`) VALUES
(1, 4, 1, 'Ula', 'Test', '12312312', 65, 10, 650, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1);

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

--
-- Table structure for table `migrations`
--

CREATE TABLE IF NOT EXISTS `migrations` (
  `migration` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`migration`, `batch`) VALUES
('2013_10_04_170905_create_password_reminders_table', 1);

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

--
-- Table structure for table `offerings`
--

CREATE TABLE IF NOT EXISTS `offerings` (
  `offering_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `type_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `size` double NOT NULL,
  `per_share` double NOT NULL,
  `min_amount` double NOT NULL,
  `starts_at` datetime NOT NULL,
  `ends_at` datetime NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  PRIMARY KEY (`offering_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `offerings`
--

INSERT INTO `offerings` (`offering_id`, `user_id`, `type_id`, `name`, `description`, `size`, `per_share`, `min_amount`, `starts_at`, `ends_at`, `created_at`, `updated_at`, `is_active`) VALUES
(1, 3, 1, 'Test Company 3', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Duis semper, \r\nante at sollicitudin luctus, nulla lorem condimentum justo, sit amet \r\nhendrerit odio sem non erat. In vitae egestas risus. Mauris ligula ante,\r\n scelerisque ut adipiscing venenatis, pharetra vel sapien. Nam nec \r\npellentesque ipsum. Mauris eu ante interdum, feugiat eros vitae, congue \r\nlorem. Donec consectetur augue velit, sed semper nunc consequat ut.<br>', 1200000, 10, 500, '2013-10-01 08:00:00', '2013-12-31 16:00:00', '2013-10-14 21:12:57', '2013-10-14 22:00:43', 1);

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

--
-- Table structure for table `offering_library`
--

CREATE TABLE IF NOT EXISTS `offering_library` (
  `library_id` int(11) NOT NULL AUTO_INCREMENT,
  `offering_id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `name` varchar(255) NOT NULL,
  `file_name` varchar(255) NOT NULL,
  `file_path` varchar(255) NOT NULL,
  `file_size` varchar(255) NOT NULL,
  `file_type` varchar(255) NOT NULL,
  `sort_order` tinyint(4) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  PRIMARY KEY (`library_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `offering_summary`
--

CREATE TABLE IF NOT EXISTS `offering_summary` (
  `offering_id` int(11) NOT NULL,
  `library_id` int(11) DEFAULT NULL,
  `content` longtext NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`offering_id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

--
-- Dumping data for table `offering_summary`
--

INSERT INTO `offering_summary` (`offering_id`, `library_id`, `content`, `created_at`, `updated_at`) VALUES
(1, NULL, 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer eget \r\nfelis tincidunt enim tempor malesuada. Nullam malesuada nulla nec ante \r\nmalesuada, consectetur venenatis justo ullamcorper. Suspendisse et \r\nconsectetur ante, et rutrum lectus. Pellentesque quis placerat nisi, \r\nhendrerit vulputate nunc. In commodo sem iaculis lacinia elementum. \r\nCurabitur pellentesque mauris massa, sit amet vulputate mauris iaculis \r\nat. <br><br>Cras consectetur tortor lacus, et dictum felis sodales nec. Fusce \r\ncursus, sapien sit amet consequat eleifend, risus leo fringilla arcu, et\r\n posuere nulla tellus in augue. Curabitur tincidunt rutrum magna. Duis a\r\n nisl nec est posuere aliquet. Pellentesque id scelerisque ante. In vel \r\nultricies lectus. Aliquam vehicula odio vitae velit ultricies dignissim.\r\n Maecenas vitae enim turpis. Sed ullamcorper vestibulum est, sed \r\nadipiscing nibh cursus eget.\r\n\r\n\r\nIn porttitor purus dolor, eget suscipit diam scelerisque accumsan. Etiam\r\n sit amet porttitor enim. Morbi massa turpis, sollicitudin ac tortor \r\nvitae, posuere convallis nunc. <br><br>Vivamus dignissim elit nisi, vitae \r\ninterdum mi faucibus ac. Donec ac convallis velit. Maecenas luctus felis\r\n sit amet turpis fermentum, ut euismod est sodales. In in justo aliquet,\r\n bibendum purus sit amet, feugiat nulla. Pellentesque dapibus lobortis \r\ntincidunt. Vivamus non interdum nisl. Aenean placerat elit posuere quam \r\nullamcorper, a mollis ligula cursus. Etiam sed erat mauris.\r\n\r\n<span>\r\nCras fermentum nisi ut risus malesuada, suscipit lobortis velit \r\nvenenatis. Mauris ut eleifend urna. Duis massa est, tempus sed consequat\r\n eu, elementum eu nunc. Nunc fermentum dictum quam non auctor. Maecenas \r\nvarius auctor urna ac blandit. <br><br>Vestibulum ipsum erat, imperdiet sed diam\r\n et, lobortis ullamcorper est. Nulla facilisi. Maecenas bibendum \r\nfacilisis odio, vel pellentesque nibh luctus a. Integer id iaculis \r\ntellus, vel eleifend nisi. Curabitur adipiscing, tortor id hendrerit \r\nluctus, urna metus semper urna, eu congue augue neque id neque. Etiam \r\nelementum massa nisi. Fusce et hendrerit magna. Sed et bibendum urna. \r\nPellentesque habitant morbi tristique senectus et netus et malesuada \r\nfames ac turpis egestas. <br><br>Nam blandit elementum ligula, a elementum sem \r\nauctor eu.\r\n</span><br>', '2013-10-15 00:00:43', '2013-10-15 00:00:43');

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

--
-- Table structure for table `offering_types`
--

CREATE TABLE IF NOT EXISTS `offering_types` (
  `type_id` int(11) NOT NULL AUTO_INCREMENT,
  `type_name` varchar(255) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`type_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `offering_types`
--

INSERT INTO `offering_types` (`type_id`, `type_name`, `created_at`, `updated_at`) VALUES
(1, 'HEDGE FUNDS', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(2, 'PE FUNDS', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(3, 'PRIVATE COs', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(4, 'PUBLIC COs', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(5, 'IPOs', '0000-00-00 00:00:00', '0000-00-00 00:00:00');

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

--
-- Table structure for table `pages`
--

CREATE TABLE IF NOT EXISTS `pages` (
  `page_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `alias` varchar(255) NOT NULL,
  `content` longtext NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `meta_title` varchar(255) NOT NULL,
  `meta_description` text NOT NULL,
  `meta_keywords` text NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  PRIMARY KEY (`page_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` (`page_id`, `user_id`, `title`, `alias`, `content`, `created_at`, `updated_at`, `meta_title`, `meta_description`, `meta_keywords`, `is_active`) VALUES
(1, 1, 'Terms of use', 'terms-of-use', 'This is term of use', '0000-00-00 00:00:00', '2013-10-14 17:25:29', '', '', '', 1),
(2, 1, 'About Us', 'about-us', 'this is about us', '0000-00-00 00:00:00', '2013-10-14 17:25:41', '', '', '', 1),
(7, 3, 'Careers', 'careers', 'Coming Soon', '2013-10-14 17:25:58', '2013-10-14 17:25:58', '', '', '', 1),
(8, 3, 'Press', 'press', 'Coming Soon...', '2013-10-14 17:26:13', '2013-10-14 17:26:13', '', '', '', 1),
(9, 3, 'Privacy Policy', 'privacy-policy', 'Coming Soon...', '2013-10-14 17:26:22', '2013-10-14 17:26:22', '', '', '', 1),
(10, 3, 'Contact Us', 'contact-us', 'Coming Soon...', '2013-10-14 17:26:32', '2013-10-14 17:26:32', '', '', '', 1);

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

--
-- Table structure for table `users_autologin`
--

CREATE TABLE IF NOT EXISTS `users_autologin` (
  `autologin_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `user_agent` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `last_ip` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`autologin_id`),
  KEY `users_autologin_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `users_login_attempts`
--

CREATE TABLE IF NOT EXISTS `users_login_attempts` (
  `attempt_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ip_address` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`attempt_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

