Untitled

-- phpMyAdmin SQL Dump
-- version 3.3.9.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 12, 2011 at 10:41 PM
-- Server version: 5.5.9
-- PHP Version: 5.3.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `Cellphone`
--

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

--
-- Table structure for table `tblMembers`
--

CREATE TABLE `tblMembers` (
  `IDMember` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `Firstname` varchar(20) DEFAULT NULL,
  `Lastname` varchar(20) DEFAULT NULL,
  `UserName` varchar(8) DEFAULT NULL,
  `PassWord` varchar(20) CHARACTER SET latin1 COLLATE latin1_general_cs DEFAULT NULL,
  `Email` varchar(50) DEFAULT NULL,
  `SellAmount` float NOT NULL DEFAULT '0',
  `BuyAmount` float NOT NULL DEFAULT '0',
  `level` smallint(1) NOT NULL DEFAULT '2',
  PRIMARY KEY (`IDMember`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

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

--
-- Table structure for table `tblSellphones`
--

CREATE TABLE `tblSellphones` (
  `IDCellPhone` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(60) NOT NULL DEFAULT 'images/default.jpg',
  `Model` varchar(20) DEFAULT NULL,
  `Brand` varchar(20) DEFAULT NULL,
  `SellPrice` float DEFAULT NULL,
  `Color` varchar(10) DEFAULT NULL,
  `SellDate` date DEFAULT NULL,
  `Features` varchar(250) DEFAULT NULL,
  `Conditions` varchar(20) DEFAULT NULL,
  `IDMember` int(10) unsigned NOT NULL,
  `Cellstatus` varchar(10) NOT NULL DEFAULT 'Ready',
  `views` tinyint(6) NOT NULL DEFAULT '1',
  `BuyPrice` float DEFAULT NULL,
  `BuyDate` date DEFAULT NULL,
  PRIMARY KEY (`IDCellPhone`),
  KEY `IDMember` (`IDMember`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;