| 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 | |
|---|
| 10 | SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; |
|---|
| 11 | SET 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 | |
|---|
| 29 | CREATE 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 | |
|---|
| 54 | INSERT 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 \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 \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 */; |
|---|