SQL Tuto Pagseguro
-- phpMyAdmin SQL Dump
-- version 3.3.10deb1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jun 29, 2012 at 07:30 PM
-- Server version: 5.1.63
-- PHP Version: 5.3.5-1ubuntu7.10
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `tutorialpagseguro`
--
-- --------------------------------------------------------
--
-- Table structure for table `compras`
--
CREATE TABLE IF NOT EXISTS `compras` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`produto` int(11) NOT NULL,
`transacao` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`status` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`quantidade` int(11) NOT NULL,
`valor` double NOT NULL,
`formapagamento` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;
-- --------------------------------------------------------
--
-- Table structure for table `log`
--
CREATE TABLE IF NOT EXISTS `log` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`data` text COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `produtos`
--
CREATE TABLE IF NOT EXISTS `produtos` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`nome` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`valor` double NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;