Ticket #2194: sp_sfposts.sql

-- phpMyAdmin SQL Dump
-- version 3.4.11.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 03, 2013 at 05:12 PM
-- Server version: 5.1.65
-- PHP Version: 5.2.6

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: `ntwb_simprs`
--

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

--
-- Table structure for table `sp_sfposts`
--

CREATE TABLE IF NOT EXISTS `sp_sfposts` (
  `post_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `post_content` longtext,
  `post_date` datetime NOT NULL,
  `topic_id` bigint(20) NOT NULL,
  `user_id` bigint(20) DEFAULT NULL,
  `forum_id` bigint(20) NOT NULL,
  `guest_name` varchar(20) DEFAULT NULL,
  `guest_email` varchar(50) DEFAULT NULL,
  `post_status` int(4) NOT NULL DEFAULT '0',
  `post_pinned` smallint(1) NOT NULL DEFAULT '0',
  `post_index` mediumint(8) DEFAULT '0',
  `post_edit` mediumtext,
  `poster_ip` varchar(39) NOT NULL,
  `comment_id` bigint(20) DEFAULT NULL,
  `source` smallint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`post_id`),
  KEY `topicp_idx` (`topic_id`),
  KEY `forump_idx` (`forum_id`),
  KEY `user_idx` (`user_id`),
  KEY `guest_name_idx` (`guest_name`),
  KEY `comment_idx` (`comment_id`),
  KEY `post_date_idx` (`post_date`),
  FULLTEXT KEY `post_content` (`post_content`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=128797 ;

--
-- Dumping data for table `sp_sfposts`
--

INSERT INTO `sp_sfposts` (`post_id`, `post_content`, `post_date`, `topic_id`, `user_id`, `forum_id`, `guest_name`, `guest_email`, `post_status`, `post_pinned`, `post_index`, `post_edit`, `poster_ip`, `comment_id`, `source`) VALUES
(128796, 'Dear Unicode,\r\n\r\n\r\nI am not finding this carriage return no break space regex matching much fun.\r\n\r\n\r\nCheers,\r\n\r\nStephen\r\n\r\nDebugNBSPTopicContentLINE1\r\nDebugNBSPTopicContentLINE2\r\n\r\n\r\nDebugNBSPTopicContentLINE3\r\nDebugNBSPTopicContentLINE4', '2013-02-03 01:29:13', 128773, 1, 128612, '', '', 0, 0, 1, 'a:1:{i:0;a:2:{s:2:"by";s:25:"display_name_admin_simprs";s:2:"at";i:1359933072;}}', '123.45.6.789', NULL, 0);

/*!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 */;