Public feed #889649

Unnamed

public sql v1 · immutable
Raw Edit
·published 2008-02-03 01:42 UTC
rendered paste body
-- 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.5SET 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);