-- phpMyAdmin SQL Dump
-- version 3.1.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Mar 11, 2011 at 03:52 AM
-- Server version: 5.1.36
-- PHP Version: 5.2.11

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!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: `hegl`
--

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

--
-- Table structure for table `productinout`
--

DROP TABLE IF EXISTS `productinout`;
CREATE TABLE IF NOT EXISTS `productinout` (
  `id` varchar(36) NOT NULL DEFAULT '',
  `date_entered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `date_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_user_id` varchar(36) DEFAULT NULL,
  `created_by` varchar(36) DEFAULT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  `name` varchar(255) DEFAULT NULL,
  `product_id` varchar(36) DEFAULT NULL,
  `category` varchar(16) DEFAULT NULL,
  `price` decimal(20,2) NOT NULL DEFAULT '0.00',
  `date_buy_sell` date DEFAULT NULL,
  `quantity` int(5) NOT NULL DEFAULT '0',
  `school_id` varchar(36) DEFAULT NULL,
  `description` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `productinout`
--

INSERT INTO `productinout` (`id`, `date_entered`, `date_modified`, `modified_user_id`, `created_by`, `deleted`, `name`, `product_id`, `category`, `price`, `date_buy_sell`, `quantity`, `school_id`, `description`) VALUES
('0001', '2011-03-09 10:00:00', '2011-03-10 17:28:24', '1', '1', 0, '仕入れ・3月', '9002', '1', '2000.00', '2011-03-01', 60, 'sssssss-1111', '仕入れメモです。'),
('0002', '2011-03-01 10:00:00', '2011-03-10 17:28:41', '1', '1', 0, '大量販売・3月', '9001', '-1', '3000.00', '2011-03-05', 15, 'sssssss-1111', '大量販売のメモです。'),
('b74c2166-1dd9-9906-de4a-4d790aaf3598', '2011-03-10 17:30:42', '2011-03-10 17:30:42', '1', '1', 0, 'テスト仕入れ', '9001', '1', '1000.00', '2011-03-10', 12, 'sssssss-1111', 'テスト１\r\nテスト２');
