-- phpMyAdmin SQL Dump
-- version 2.11.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 03, 2008 at 02:41 AM
-- Server version: 5.0.51
-- PHP Version: 5.2.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `isklep2`
--

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

--
-- Table structure for table `country`
--

DROP TABLE IF EXISTS `country`;
CREATE TABLE `country` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  `currency_id` int(10) unsigned NOT NULL,
  `language_id` int(10) unsigned NOT NULL,
  `symbol` varchar(10) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=14 ;

--
-- Dumping data for table `country`
--

INSERT INTO `country` (`id`, `name`, `currency_id`, `language_id`, `symbol`) VALUES
(1, 'Polska', 2, 1, 'pl'),
(4, 'USA', 1, 5, 'us'),
(5, 'zambia', 2, 1, 'zm'),
(6, 'Koread', 1, 3, 'kraas'),
(9, 'Wielka Brytania', 6, 3, 'GB'),
(10, 'Holandia', 2, 3, 'asd');

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

--
-- Table structure for table `country_transport_method`
--

DROP TABLE IF EXISTS `country_transport_method`;
CREATE TABLE `country_transport_method` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `country_id` int(10) unsigned NOT NULL,
  `transport_method_id` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `ctr_tr_m_uniq_ct` (`country_id`,`transport_method_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=67 ;

--
-- Dumping data for table `country_transport_method`
--

INSERT INTO `country_transport_method` (`id`, `country_id`, `transport_method_id`) VALUES
(22, 4, 57),
(23, 1, 58),
(24, 5, 58),
(52, 10, 59),
(49, 4, 65),
(48, 1, 65),
(47, 6, 65),
(46, 10, 65),
(60, 1, 64),
(59, 6, 64),
(58, 10, 64),
(50, 9, 65),
(51, 5, 65),
(53, 6, 59),
(54, 1, 59),
(55, 4, 59),
(56, 9, 59),
(57, 5, 59),
(61, 10, 66),
(62, 6, 66),
(63, 1, 66),
(64, 4, 66),
(65, 9, 66),
(66, 5, 66);

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

--
-- Table structure for table `currency`
--

DROP TABLE IF EXISTS `currency`;
CREATE TABLE `currency` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `symbol` varchar(10) NOT NULL,
  `name` varchar(127) NOT NULL,
  `value` decimal(20,4) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1114 ;

--
-- Dumping data for table `currency`
--

INSERT INTO `currency` (`id`, `symbol`, `name`, `value`) VALUES
(2, 'USD', 'Dolar Hamerykański', 2.5600),
(1, 'PLN', 'Polski zloty', 1.0000),
(1113, 'DD', 'Dpa', 33333.0000),
(6, 'GPB', 'Funt brytyjski', 6.5000),
(7, 'FF', 'Frank Francuski', 0.5435);

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

--
-- Table structure for table `language`
--

DROP TABLE IF EXISTS `language`;
CREATE TABLE `language` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `symbol` varchar(8) NOT NULL,
  `name` varchar(127) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `language`
--

INSERT INTO `language` (`id`, `symbol`, `name`) VALUES
(1, 'PL', 'Poilski'),
(3, 'EN', 'Angielski'),
(5, 'chr', 'Chorwacki');

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

--
-- Table structure for table `payment_method`
--

DROP TABLE IF EXISTS `payment_method`;
CREATE TABLE `payment_method` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(255) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=20 ;

--
-- Dumping data for table `payment_method`
--

INSERT INTO `payment_method` (`id`, `name`) VALUES
(13, 'PayPal'),
(11, 'Allpay'),
(12, 'Platnosc przy odbiorze'),
(17, 'Gotowka');

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

--
-- Table structure for table `transaction_finalization`
--

DROP TABLE IF EXISTS `transaction_finalization`;
CREATE TABLE `transaction_finalization` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `transport_weight_id` int(10) unsigned NOT NULL,
  `payment_method_id` int(10) unsigned NOT NULL,
  `discount` int(10) unsigned NOT NULL,
  `price` decimal(10,4) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `transaction_finalization_idx_payment` (`payment_method_id`),
  KEY `transaction_finalization_idx_transportweight` (`transport_weight_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=33 ;

--
-- Dumping data for table `transaction_finalization`
--

INSERT INTO `transaction_finalization` (`id`, `transport_weight_id`, `payment_method_id`, `discount`, `price`) VALUES
(7, 29, 11, 0, 8.0000),
(8, 30, 11, 1, 9.0000),
(26, 35, 11, 0, 10.0000),
(24, 33, 17, 0, 234.0000),
(25, 33, 13, 3, 34234.0000),
(13, 32, 11, 3, 34.0000),
(23, 33, 11, 0, 32342.0000),
(27, 35, 17, 0, 321.0000),
(28, 35, 13, 0, 22.0000),
(29, 35, 12, 0, 123.0000),
(30, 36, 11, 0, 10.0000),
(31, 36, 13, 0, 20.0000),
(32, 37, 13, 0, 200.0000);

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

--
-- Table structure for table `transport_method`
--

DROP TABLE IF EXISTS `transport_method`;
CREATE TABLE `transport_method` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `visible` tinyint(1) NOT NULL default '0',
  `name` varchar(255) NOT NULL,
  `shipment_time` varchar(255) NOT NULL,
  `free_when_order_above` decimal(20,4) NOT NULL default '0.0000',
  `vat` int(11) NOT NULL,
  `label` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=67 ;

--
-- Dumping data for table `transport_method`
--

INSERT INTO `transport_method` (`id`, `visible`, `name`, `shipment_time`, `free_when_order_above`, `vat`, `label`) VALUES
(66, 0, 'Ukryty ninja', '123123', 1234.0000, 22, ''),
(64, 1, 'Na zadupie', '23dsf', 234.0000, 0, ''),
(59, 1, 'Na piechotę', '5 dni', 5000.0000, 22, 'okolice'),
(65, 1, 'Poczta Polska', '2', 2.0000, 22, 'dsffsdf');

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

--
-- Table structure for table `transport_weight`
--

DROP TABLE IF EXISTS `transport_weight`;
CREATE TABLE `transport_weight` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `min_weight` decimal(10,4) NOT NULL,
  `max_weight` decimal(10,4) NOT NULL,
  `transport_method_id` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `transport_weight_indx_transport_id` (`transport_method_id`),
  KEY `transport_weight_indx_min_w` (`min_weight`),
  KEY `transport_weight_indx_max_w` (`max_weight`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=38 ;

--
-- Dumping data for table `transport_weight`
--

INSERT INTO `transport_weight` (`id`, `min_weight`, `max_weight`, `transport_method_id`) VALUES
(30, 0.5000, 1.0000, 64),
(29, 0.0000, 0.5000, 64),
(33, 5.0000, 10.0000, 64),
(32, 1.0000, 5.0000, 64),
(35, 0.0000, 1.0000, 59),
(34, 1.0000, 2.0000, 59),
(37, 0.0000, 100.0000, 66),
(36, 0.0000, 10.0000, 65);