cQQNLSci

1CREATE TABLE IF NOT EXISTS `siedleratpreise` (
2  `id` int(4) NOT NULL AUTO_INCREMENT,
3  `weltid` varchar(4) COLLATE latin1_german2_ci NOT NULL,
4  `abenteuerid` varchar(4) COLLATE latin1_german2_ci NOT NULL,
5  `vonpreis` varchar(255) COLLATE latin1_german2_ci NOT NULL,
6  `bispreis` varchar(255) COLLATE latin1_german2_ci NOT NULL,
7  PRIMARY KEY (`id`)
8) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci AUTO_INCREMENT=38 ;
9
10--
11-- Daten für Tabelle `siedleratpreise`
12--
13
14INSERT INTO `siedleratpreise` (`id`, `weltid`, `abenteuerid`, `vonpreis`, `bispreis`) VALUES
15(1, '6', '19', '1200', '1400'),
16(2, '1', '19', '1000', '1350'),
17(3, '4', '19', '1300', '1600'),
18(4, '3', '19', '1250', '1300'),
19(5, '5', '8', '45', '70'),
20(6, '5', '22', '1222', '1122'),
21(7, '11', '17', '155', '300'),
22(8, '4', '12', '200', '300'),
23(9, '1', '5', '500', '600'),
24(10, '4', '3', '688', '555'),
25(11, '8', '19', '1600', '1700'),
26(12, '6', '19', '1250', '1300'),
27(13, '6', '19', '1300', '1350'),
28(14, '6', '19', '1350', '1400'),
29(15, '6', '19', '1400', '1450'),
30(16, '6', '20', '1600', '1800'),
31(17, '12', '19', '1600', '1950'),
32(18, '12', '19', '1750', '1800'),
33(37, '6', '14', '122', '2222'),
34(35, '1', '7', '1530', '1980'),
35(36, '3', '21', '6666', '2222'),
36(33, '1', '7', '122', '133');