-- version 3.4.9

-- http://www.phpmyadmin.net

--

-- Host: localhost

-- Generation Time: Mar 21, 2012 at 02:44 PM

-- Server version: 5.5.20

-- PHP Version: 5.3.8

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

--

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

--

-- Table structure for table `ad_feedback`

--

CREATE TABLE IF NOT EXISTS `ad_feedback` (

  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Index of the table',

  `form` int(11) NOT NULL COMMENT 'The ID of the feedback form',

  `order_id` int(11) NOT NULL,

  `order_name` varchar(2000) NOT NULL,

  `ad_id` int(11) NOT NULL,

  `creative_id` int(11) NOT NULL,

  `product_type` varchar(40) NOT NULL,

  `email` varchar(50) NOT NULL,

  `reason` varchar(400) NOT NULL,

  `comments` varchar(4000) NOT NULL,

  `site_name` varchar(200) NOT NULL,

  `referrer` varchar(2000) NOT NULL,

  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

  PRIMARY KEY (`id`)

) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--

-- Dumping data for table `ad_feedback`

--

INSERT INTO `ad_feedback` (`id`, `form`, `order_id`, `order_name`, `ad_id`, `creative_id`, `product_type`, `email`, `reason`, `comments`, `site_name`, `referrer`, `time`) VALUES

(1, 33, 6371979, 'Sandro SocialFlex v1.4 Test Harness', 253944794, 46821763, 'socialFlex', 'adsfa', 'Uninteresting', 'asdf', 'mbrix.testsocialflexv1_4', 'http://ad.doubleclick.net/adi/mbrix.testsocialflexv1_4/sandro;camp=socialflex_v1_4_modal_vast_direct_iframe_sandro;sz=650x500;ord=1234567890?', '2012-03-21 18:40:57'),

(2, 33, 6371979, 'Sandro SocialFlex v1.4 Test Harness', 253944794, 46821763, 'socialFlex', 'me@mine.com', 'Against my views', 'Testing', 'mbrix.testsocialflexv1_4', 'http://ad.doubleclick.net/adi/mbrix.testsocialflexv1_4/sandro;camp=socialflex_v1_4_modal_vast_direct_iframe_sandro;sz=650x500;ord=1234567890?', '2012-03-21 18:43:56');

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