Skip to:
Content

bbPress.org

Ticket #2194: sp_sfposts.sql

File sp_sfposts.sql, 2.5 KB (added by netweb, 8 years ago)

Example _sfposts.sql export

Line 
1-- phpMyAdmin SQL Dump
2-- version 3.4.11.1
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Feb 03, 2013 at 05:12 PM
7-- Server version: 5.1.65
8-- PHP Version: 5.2.6
9
10SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `ntwb_simprs`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `sp_sfposts`
27--
28
29CREATE TABLE IF NOT EXISTS `sp_sfposts` (
30  `post_id` bigint(20) NOT NULL AUTO_INCREMENT,
31  `post_content` longtext,
32  `post_date` datetime NOT NULL,
33  `topic_id` bigint(20) NOT NULL,
34  `user_id` bigint(20) DEFAULT NULL,
35  `forum_id` bigint(20) NOT NULL,
36  `guest_name` varchar(20) DEFAULT NULL,
37  `guest_email` varchar(50) DEFAULT NULL,
38  `post_status` int(4) NOT NULL DEFAULT '0',
39  `post_pinned` smallint(1) NOT NULL DEFAULT '0',
40  `post_index` mediumint(8) DEFAULT '0',
41  `post_edit` mediumtext,
42  `poster_ip` varchar(39) NOT NULL,
43  `comment_id` bigint(20) DEFAULT NULL,
44  `source` smallint(1) NOT NULL DEFAULT '0',
45  PRIMARY KEY (`post_id`),
46  KEY `topicp_idx` (`topic_id`),
47  KEY `forump_idx` (`forum_id`),
48  KEY `user_idx` (`user_id`),
49  KEY `guest_name_idx` (`guest_name`),
50  KEY `comment_idx` (`comment_id`),
51  KEY `post_date_idx` (`post_date`),
52  FULLTEXT KEY `post_content` (`post_content`)
53) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=128797 ;
54
55--
56-- Dumping data for table `sp_sfposts`
57--
58
59INSERT 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
60(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);
61
62/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
63/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
64/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;