-- phpMyAdmin SQL Dump
-- version 3.2.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Czas wygenerowania: 10 Lis 2012, 14:54
-- Wersja serwera: 5.1.41
-- Wersja PHP: 5.3.1

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

--
-- Baza danych: `breadbread`
--

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

--
-- Struktura tabeli dla  `itemqueue`
--

CREATE TABLE IF NOT EXISTS `itemqueue` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `count` tinyint(3) unsigned DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `item_id` int(11) unsigned DEFAULT NULL,
  `address_id` int(11) unsigned DEFAULT NULL,
  `state` tinyint(3) unsigned DEFAULT NULL,
  `startdate` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `index_foreignkey_itemqueue_item` (`item_id`),
  KEY `index_foreignkey_itemqueue_address` (`address_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=32 ;

--
-- Zrzut danych tabeli `itemqueue`
--

INSERT INTO `itemqueue` (`id`, `count`, `date`, `item_id`, `address_id`, `state`, `startdate`) VALUES
(1, 2, '2012-11-14 00:00:00', 21, 47, 3, '2012-11-09 00:00:00'),
(2, 1, '2012-11-15 00:00:00', 45, 47, 3, '2012-11-09 00:00:00'),
(3, 1, '2012-11-14 00:00:00', 57, 43, 3, '2012-11-09 00:00:00'),
(4, 7, '2012-11-14 00:00:00', 60, 43, 3, '2012-11-09 00:00:00'),
(5, 4, '2012-11-15 00:00:00', 45, 46, 3, '2012-11-09 00:00:00'),
(6, 4, '2012-11-14 00:00:00', 52, 9, 3, '2012-11-09 00:00:00'),
(7, 2, '2012-11-14 00:00:00', 57, 9, 3, '2012-11-09 00:00:00'),
(8, 0, '2012-11-14 00:00:00', 60, 9, 3, '2012-11-09 00:00:00'),
(9, 1, '2012-11-14 00:00:00', 21, 38, 3, '2012-11-09 00:00:00'),
(10, 2, '2012-11-14 00:00:00', 57, 38, 3, '2012-11-09 00:00:00'),
(11, 1, '2012-11-15 00:00:00', 45, 38, 3, '2012-11-09 00:00:00'),
(12, 3, '2012-11-14 00:00:00', 57, 37, 3, '2012-11-09 00:00:00'),
(13, 3, '2012-11-15 00:00:00', 45, 37, 3, '2012-11-09 00:00:00'),
(14, 2, '2012-11-14 00:00:00', 21, 32, 3, '2012-11-09 00:00:00'),
(15, 5, '2012-11-14 00:00:00', 57, 32, 3, '2012-11-09 00:00:00'),
(16, 1, '2012-11-15 00:00:00', 45, 26, 3, '2012-11-09 00:00:00'),
(17, 3, '2012-11-14 00:00:00', 57, 24, 3, '2012-11-09 00:00:00'),
(18, 1, '2012-11-14 00:00:00', 63, 24, 3, '2012-11-09 00:00:00'),
(19, 2, '2012-11-14 00:00:00', 57, 23, 3, '2012-11-09 00:00:00'),
(20, 5, '2012-11-14 00:00:00', 57, 12, 3, '2012-11-09 00:00:00'),
(21, 2, '2012-11-14 00:00:00', 21, 20, 3, '2012-11-09 00:00:00'),
(22, 1, '2012-11-14 00:00:00', 57, 20, 3, '2012-11-09 00:00:00'),
(23, 1, '2012-11-14 00:00:00', 60, 20, 3, '2012-11-09 00:00:00'),
(24, 3, '2012-11-15 00:00:00', 45, 19, 3, '2012-11-09 00:00:00'),
(25, 2, '2012-11-15 00:00:00', 45, 13, 3, '2012-11-09 00:00:00'),
(26, 4, '2012-11-14 00:00:00', 21, 8, 3, '2012-11-09 00:00:00'),
(27, 18, '2012-11-14 00:00:00', 57, 8, 3, '2012-11-09 00:00:00'),
(28, 2, '2012-11-14 00:00:00', 60, 8, 3, '2012-11-09 00:00:00'),
(29, 1, '2012-11-14 00:00:00', 63, 8, 3, '2012-11-09 00:00:00'),
(30, 2, '2012-11-14 00:00:00', 60, 23, 3, '2012-11-09 00:00:00'),
(31, 2, '2012-11-14 00:00:00', 22, 9, 3, '2012-11-09 00:00:00');

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