Skip to:
Content

bbPress.org

Ticket #2194: wp_sfposts.sql

File wp_sfposts.sql, 2.4 KB (added by vegasgeek, 8 years ago)

export of single post

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 06:46 PM
7-- Server version: 5.0.96
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: `wpaffili_affmanager`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `wp_sfposts`
27--
28
29CREATE TABLE IF NOT EXISTS `wp_sfposts` (
30  `post_id` bigint(20) NOT NULL auto_increment,
31  `post_content` text,
32  `post_date` datetime NOT NULL,
33  `topic_id` bigint(20) NOT NULL,
34  `user_id` bigint(20) unsigned 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  PRIMARY KEY  (`post_id`),
45  KEY `topicp_idx` (`topic_id`),
46  KEY `forump_idx` (`forum_id`),
47  FULLTEXT KEY `post_content` (`post_content`)
48) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=208 ;
49
50--
51-- Dumping data for table `wp_sfposts`
52--
53
54INSERT INTO `wp_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`) VALUES
55(199, 'Kathy,\r\n\r\n&nbsp;\r\n\r\nAt the moment, affiliates <em>must</em> view (and accept) the terms and conditions as part of the process.  This is also where they indicate their payment information (paypal / check) and enter that information.  \r\n\r\nYou technically could complete this step for them by logging in as them and accepting the terms and entering their payment information - but this is really suited to being completed by the affiliate themselves.\r\n\r\n&nbsp;\r\n\r\nJustin\r\n', '2013-01-20 11:33:43', 59, 15, 3, '', '', 0, 0, 2, NULL, '98.191.181.14', NULL);
56
57/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
58/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
59/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;