-- --------------------------------------------------------
-- Host:                         localhost
-- Server Version:               5.5.47-0+deb7u1 - (Debian)
-- Server Betriebssystem:        debian-linux-gnu
-- HeidiSQL Version:             9.5.0.5196
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

-- Exportiere Struktur von Tabelle tofriends.mod_shop_payment
CREATE TABLE IF NOT EXISTS `mod_shop_payment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL DEFAULT '',
  `active` enum('Y','N') NOT NULL DEFAULT 'Y',
  `description` blob NOT NULL,
  `price` decimal(10,2) NOT NULL DEFAULT '0.00',
  `shipping` enum('Y','N') NOT NULL DEFAULT 'Y',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

-- Exportiere Daten aus Tabelle tofriends.mod_shop_payment: 3 rows
/*!40000 ALTER TABLE `mod_shop_payment` DISABLE KEYS */;
INSERT INTO `mod_shop_payment` (`id`, `title`, `active`, `description`, `price`, `shipping`) VALUES
	(1, 'Nachnahme', 'Y', _binary 0x5769722073656E64656E2049686E656E206469652062657374656C6C74656E20417274696B656C20706572204E6163686E61686D65207A752E, 3.00, 'Y'),
	(2, 'Vorauskasse', 'Y', _binary 0x426974746520FC62657277656973656E205369652064656E204265747261672061756620756E736572204B6F6E746F20233132333435363720424C5A20383530203132332034352C20537069656C67656C6462616E6B20456E74656E68617573656E2E20536F62616C6420646572204265747261672061756620756E736572656D204B6F6E746F2065696E676567616E67656E206973742C2073656E64656E207769722049686E656E206469652062657374656C6C74656E20417274696B656C207A752E, 0.00, 'Y'),
	(3, 'Abholung', 'Y', _binary 0x446965205761726520776972642066FC722053696520726573657276696572742C20536965206BF66E6E656E20736965206A656465727A6569742062656920756E73206162686F6C656E2E, 0.00, 'N');
/*!40000 ALTER TABLE `mod_shop_payment` ENABLE KEYS */;

/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
