-- phpMyAdmin SQL Dump
-- version 3.2.0.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 11, 2010 at 11:07 AM
-- Server version: 5.1.36
-- PHP Version: 5.2.11

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `stack_overflow`
--

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

--
-- Table structure for table `field`
--

CREATE TABLE IF NOT EXISTS `field` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `FieldAttributeId` int(11) DEFAULT '0',
  `FieldSetId` int(11) DEFAULT '0',
  `FormId` int(11) NOT NULL,
  `LookupFieldTypeId` int(11) NOT NULL,
  `Description` char(255) DEFAULT NULL,
  `DisplayOrder` int(11) NOT NULL,
  `IsDeleted` tinyint(1) DEFAULT '1',
  `Label` char(45) DEFAULT NULL,
  `Name` char(45) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=104 ;

--
-- Dumping data for table `field`
--

INSERT INTO `field` (`Id`, `FieldAttributeId`, `FieldSetId`, `FormId`, `LookupFieldTypeId`, `Description`, `DisplayOrder`, `IsDeleted`, `Label`, `Name`) VALUES
(102, 0, 0, 1, 6, 'First Name Description', 0, 0, 'First Name Label', 'first_name'),
(103, 0, 0, 1, 6, 'Last Name Description', 0, 0, 'Last Name Label', 'last_name'),
(100, 0, 1, 1, 6, 'Item Name Description', 0, 0, 'Item Name Label', 'item_name'),
(101, 0, 1, 1, 6, 'Item Price Description', 0, 0, 'Item Price Label', 'item_price');

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

--
-- Table structure for table `fielddata`
--

CREATE TABLE IF NOT EXISTS `fielddata` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `DataSourceId` int(11) NOT NULL,
  `FieldId` int(11) NOT NULL,
  `Value` mediumtext,
  PRIMARY KEY (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `fielddata`
--

INSERT INTO `fielddata` (`Id`, `DataSourceId`, `FieldId`, `Value`) VALUES
(1, 15, 100, 'camera'),
(2, 15, 101, '100'),
(3, 15, 100, 'computer'),
(4, 15, 101, '200'),
(5, 15, 102, 'Little'),
(6, 15, 103, 'Timmy');

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

--
-- Table structure for table `fieldset`
--

CREATE TABLE IF NOT EXISTS `fieldset` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `FormId` int(11) DEFAULT NULL,
  `Description` char(255) DEFAULT NULL,
  `IsRepeating` tinyint(1) DEFAULT NULL,
  `Label` char(45) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `fieldset`
--

INSERT INTO `fieldset` (`Id`, `FormId`, `Description`, `IsRepeating`, `Label`) VALUES
(1, 1, 'Wish List Description', 1, 'Wish List');