Mine

-- 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-gentooSET 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 ;