-- phpMyAdmin SQL Dump
-- version 2.10.1
-- http://www.phpmyadmin.net
-- 
-- Host: mysql50-5
-- Generation Time: Apr 10, 2008 at 10:42 AM
-- Server version: 5.0.45
-- PHP Version: 5.2.4-pl2-gentoo

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

-- 
-- Database: `tradeking_prod`
-- 

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

-- 
-- Table structure for table `members`
-- 

DROP TABLE IF EXISTS `members`;
CREATE TABLE `members` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `member_since` date default NULL,
  `city` varchar(255) default NULL,
  `last_active` datetime default NULL,
  `description` text,
  `login` varchar(40) character set latin1 collate latin1_bin default NULL,
  `email` varchar(255) default NULL,
  `crypted_password` varchar(40) default NULL,
  `salt` varchar(40) default NULL,
  `created_at` datetime default NULL,
  `updated_at` datetime default NULL,
  `remember_token` varchar(255) default NULL,
  `remember_token_expires_at` datetime default NULL,
  `mtype` varchar(6) default NULL,
  `avatar_id` int(11) default NULL,
  `banned_at` datetime default NULL,
  `scivantage_id` varchar(255) default NULL,
  `member_url` varchar(255) default NULL,
  `member_url_customized` tinyint(1) default '0',
  `hide_address` tinyint(1) default '0',
  `only_messages_from_followed` tinyint(1) default '0',
  `publish_trades` tinyint(1) default '0',
  `publish_historical_trades` tinyint(1) default '0',
  `publish_trade_quantity` tinyint(1) default '0',
  `investment_experience_id` int(11) default NULL,
  `investment_amount_id` int(11) default NULL,
  `trading_account` varchar(8) default NULL,
  `occupation` varchar(255) default NULL,
  `state` varchar(255) default NULL,
  `country` varchar(255) default NULL,
  `alert_message_id` int(11) default NULL,
  `publish_portfolio` tinyint(1) default '0',
  `email_private_message` tinyint(1) default '1',
  `email_comment` tinyint(1) default '1',
  `email_trade_note_request` tinyint(1) default '1',
  `email_new_subscriber` tinyint(1) default '1',
  `featured` tinyint(1) default NULL,
  `age_group_id` int(11) default NULL,
  `publish_portfolio_quantity` tinyint(1) default NULL,
  `trade_count` int(11) NOT NULL default '0',
  `public_profile` tinyint(1) default '0',
  `display_roi` tinyint(1) default '0',
  PRIMARY KEY  (`id`),
  KEY `index_members_on_login` (`login`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=20293 ;

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

-- 
-- Table structure for table `postings`
-- 

DROP TABLE IF EXISTS `postings`;
CREATE TABLE `postings` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(254) default NULL,
  `trade_id` int(11) default NULL,
  `body` text,
  `votes` int(11) default '0',
  `created_at` datetime default NULL,
  `updated_at` datetime default NULL,
  `member_id` int(11) default NULL,
  `type` varchar(255) default NULL,
  `topic_id` int(11) default NULL,
  `equity_id` int(11) default NULL,
  `ip_address` varchar(255) default NULL,
  `hidden_at` datetime default NULL,
  `view_count` int(11) default '0',
  `comments_count` int(11) default '0',
  `import_guid` varchar(255) default NULL,
  `updated_by` int(11) default NULL,
  `version` int(11) default NULL,
  `hidden_by` int(11) default NULL,
  `published_at` datetime default NULL,
  `featured` tinyint(1) default '0',
  PRIMARY KEY  (`id`),
  KEY `index_postings_on_member_id` (`member_id`),
  KEY `index_postings_on_trade_id` (`trade_id`),
  KEY `index_postings_on_topic_id` (`topic_id`),
  KEY `index_postings_on_equity_id` (`equity_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7396 ;