Schulprojekt 2019 SVEN - Supermarkt Verwaltung mit Simulation und etwaigen Features
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
 
 
 
 
 

1899 lines
56 KiB

-- phpMyAdmin SQL Dump
-- version 4.5.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Erstellungszeit: 16. Feb 2018 um 12:14
-- Server-Version: 10.1.16-MariaDB
-- PHP-Version: 5.6.24
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @[email protected]@CHARACTER_SET_CLIENT */;
/*!40101 SET @[email protected]@CHARACTER_SET_RESULTS */;
/*!40101 SET @[email protected]@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Datenbank: `rechnungssystem`
--
CREATE DATABASE IF NOT EXISTS `rechnungssystem` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `rechnungssystem`;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `t_artikel`
--
CREATE TABLE `t_artikel` (
`ID` int(11) NOT NULL,
`Marke` varchar(30) NOT NULL,
`Name` varchar(30) NOT NULL,
`Einkaufspreis` float NOT NULL,
`Verkaufspreis` float NOT NULL,
`Lieferzeit` int(11) NOT NULL,
`Anzahl_pro_Palette` int(11) NOT NULL,
`MHK in Tagen` int(11) NOT NULL,
`Gekühlt` tinyint(1) NOT NULL,
`Getränk` tinyint(4) NOT NULL,
`Rohgewinn` float NOT NULL,
`Sollbestand` int(11) NOT NULL,
`Sicherheitsbestand` int(11) DEFAULT '0',
`QR` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Daten für Tabelle `t_artikel`
--
INSERT INTO `t_artikel` (`ID`, `Marke`, `Name`, `Einkaufspreis`, `Verkaufspreis`, `Lieferzeit`, `Anzahl_pro_Palette`, `MHK in Tagen`, `Gekühlt`, `Getränk`, `Rohgewinn`, `Sollbestand`, `Sicherheitsbestand`, `QR`) VALUES
(1, 'Magnolia', 'Haselnuß-Waffeln ', 0.16, 0.424227, 10, 300, 350, 0, 0, 62.3863, -1, 0, 3183),
(2, 'Back Shop', 'Berliner mit Mehrfrucht', 0.3, 0.795426, 5, 400, 170, 1, 0, 155.966, -1, 0, 2643),
(3, 'Funny Frisch', 'Chipsfrisch Ungarisch', 0.35, 0.927997, 4, 2160, 75, 0, 0, 982.585, -1, 0, 2090),
(4, 'Drinkfit', 'Milch Erdbeer', 0.55, 1.31123, 4, 1344, 180, 1, 1, 960.75, -1, 0, 3318),
(5, 'Ferrero', 'Kinder-Bueno', 0.64, 1.69691, 4, 7020, 150, 0, 0, 5839.36, 14040, 0, 2453),
(6, 'Mars Incorporated', 'Bounty', 0.64, 1.69691, 10, 3402, 150, 0, 0, 2829.84, -1, 0, 2931),
(7, 'Monster', 'Energy', 0.92, 2.19333, 4, 1440, 700, 0, 1, 1721.86, -1, 0, 2311),
(8, 'Ültje', 'Studentenfutter', 0.58, 1.53782, 4, 3780, 350, 0, 0, 2849.5, -1, 0, 3749),
(9, 'Aquintell', 'Mineralwasser Classic 1l', 0.16, 0.381448, 4, 480, 320, 0, 1, 99.8181, -1, 0, 3792),
(10, 'Nabisco', 'Oreo', 0.66, 1.74994, 4, 2520, 270, 0, 0, 2161.69, -1, 0, 2222),
(11, 'Capri-Sun', 'Capri-Sun ', 0.34, 0.810577, 4, 3240, 400, 0, 1, 1431.77, -1, 0, 195),
(12, 'Bifi', 'Bifi', 0.47, 1.24617, 4, 12920, 100, 0, 0, 7892.39, -1, 0, 1411),
(13, 'Huober', 'Brezel BIO', 0.25, 0.662855, 4, 5760, 190, 0, 0, 1871.59, -1, 0, 2632),
(14, 'Mentos', 'Mentos Mint', 0.41, 1.08708, 4, 4096, 800, 0, 0, 2182.69, -1, 0, 2712),
(15, 'Ferrero', 'Nutella Bready', 0.28, 0.742397, 7, 3630, 200, 0, 0, 1321.03, 7260, 0, 1659),
(16, 'Willis', 'Kirsch Kuchen', 0.57, 1.51131, 4, 3360, 60, 0, 0, 2489.21, 6720, 0, 1787),
(17, 'Cortijero', 'Olivenöl 250ml', 1.95, 5.17027, 6, 630, 420, 0, 0, 1596.7, -1, 0, 3366),
(18, 'Turm', 'Kaffeesahne', 0.03, 0.0715215, 4, 38400, 180, 0, 1, 1497.27, -1, 0, 3535),
(19, 'Buss', 'Jägertopf', 1.32, 3.49987, 10, 1080, 660, 0, 0, 1852.87, 2160, 1, 3506),
(20, 'LEO', 'Becher to go 0.2l.', 0.08, 0.212114, 4, 18000, 860, 0, 0, 1871.59, -1, 0, 800),
(21, 'Jack Daniels', 'Whiskey', 12, 28.6086, 15, 60, -1, 0, 1, 935.795, -1, 0, 563),
(22, 'Jacobs', 'Incup gef. m. Krönung schwarz', 0.28, 0.742397, 4, 7488, 420, 0, 0, 2725.03, -1, 0, 2125),
(23, 'Leibniz', 'Butterkeks', 0.43, 1.14011, 4, 4840, 330, 0, 0, 2704.97, -1, 0, 3456),
(24, 'Heineken', 'Bier 500ml. Dose', 0.25, 0.596012, 14, 480, 150, 0, 1, 155.966, -1, 0, 4009),
(25, 'Tic-Tac', 'Tic-Tac', 1.02, 2.70445, 10, 5568, 140, 0, 0, 7381.55, -1, 0, 1311),
(26, 'Cotto di Pin', 'Italienischer Kochschinken', 2.78, 7.37094, 3, 500, 150, 1, 0, 1806.6, -1, 0, 139),
(27, 'Powerade', 'Mountain Blast 0.5L.', 0.91, 2.16948, 4, 1296, 140, 0, 1, 1532.83, -1, 0, 507),
(28, 'CocaCola', 'Cola', 0.42, 1.0013, 4, 2376, 680, 0, 1, 1297.01, -1, 0, 3385),
(29, 'Yes', 'Black&White', 0.4, 1.06057, 10, 5760, 65, 0, 0, 2994.54, -1, 0, 1352),
(30, 'Buss', 'Grünkohleintop', 1.32, 3.49987, 10, 1080, 660, 0, 0, 1852.87, 2160, 1, 78),
(31, 'Vit-almen', 'Mandelgetränk BIO', 1.91, 4.55353, 0, 180, 60, 1, 1, 446.842, -1, 0, 1079),
(32, 'Willis', 'Frisch Kakao Waffel', 0.36, 0.954511, 4, 4800, 45, 0, 0, 2245.91, 9600, 0, 2683),
(33, 'Canela Rama', 'Zimt Gewürz', 1.03, 2.73096, 9, 24, 400, 0, 0, 32.129, -1, 0, 3865),
(34, 'Oronules', 'Mandarinen', 0.12, 0.31817, 0, 100, 30, 0, 0, 15.5966, -1, 0, 1065),
(35, 'VIDIFOOD', 'Mermelade de Higo Fig Jam', 1.2, 3.1817, 7, 25, 230, 0, 0, 38.9915, -1, 0, 124),
(36, 'Nutrilon', 'Baby Pulver', 3, 7.95426, 0, 40, 180, 0, 0, 155.966, -1, 0, 3186),
(37, 'Nestle', 'Nido 400g', 1, 2.65142, 3, 450, 200, 0, 0, 584.872, -1, 0, 2196),
(38, 'Jaima Alkazar', 'Himalaya-Salz fein', 1.97, 5.2233, 12, 24, 700, 0, 0, 61.4505, -1, 0, 1938),
(39, 'Halal', 'Kebap Hähnchen gebraten', 1, 2.65142, 12, 50, 60, 1, 0, 64.9858, 100, 1, 1343),
(40, 'Knorr', 'sman', 0.34, 0.901482, 4, 24, 73, 0, 0, 10.6057, -1, 0, 2525),
(41, 'Halal', 'Hähnchen Flügel', 2, 5.30284, 6, 34, 190, 1, 0, 88.3806, 68, 1, 4049),
(42, 'Ferrero ', 'Rocher', 1.11, 2.94308, 7, 450, 94, 0, 0, 649.208, 900, 1, 2294),
(43, 'Ferrero', 'Überraschungs Ei', 0.65, 1.72342, 7, 480, 120, 0, 0, 405.511, 960, 1, 2154),
(44, 'Milram', 'Zaziki', 0.36, 0.954511, 4, 65, 70, 1, 0, 30.4133, -1, 0, 1893),
(45, 'Knack und Back', '6 Sonntagsbrötchen', 0.65, 1.72342, 12, 120, 113, 1, 0, 101.378, -1, 0, 3500),
(46, 'Hüldenhof', 'Obazada Thunfisch Creme', 0.29, 0.768911, 6, 67, 211, 1, 0, 25.2535, -1, 0, 3943),
(47, 'Heinz', 'Ketchup', 0.18, 0.477255, 21, 357, 67, 0, 0, 83.5197, -1, 0, 108),
(48, 'Brunch', 'Sahneaufstrich', 0.49, 1.2992, 12, 60, 90, 1, 0, 38.2116, -1, 0, 2246),
(49, 'The Bremen Beer Company', 'Red Girl 3.9%', 0.15, 0.357607, 21, 680, 200, 0, 1, 132.571, -1, 0, 756),
(50, 'Whiskas', 'Katzenfutter 100g', 1.1, 2.91656, 7, 480, 230, 0, 0, 686.25, -1, 0, 4027);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `t_benutzer`
--
CREATE TABLE `t_benutzer` (
`ID` int(11) NOT NULL,
`Name` varchar(50) NOT NULL,
`Passwort` text NOT NULL COMMENT 'hash',
`banned` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Daten für Tabelle `t_benutzer`
--
INSERT INTO `t_benutzer` (`ID`, `Name`, `Passwort`, `banned`) VALUES
(1, 'hallo', '$2y$12$kwtpyoXi4RLzZ9icX3.Bz..4ak4y..gcqwRkMShkCaw78J4sYfgSO', 0),
(2, 'hallo_2', '$2y$12$kwtpyoXi4RLzZ9icX3.Bz..4ak4y..gcqwRkMShkCaw78J4sYfgSO', 0);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `t_bestellungen`
--
CREATE TABLE `t_bestellungen` (
`ID` int(11) NOT NULL,
`f_Artikel_ID` int(11) NOT NULL,
`Menge` int(11) NOT NULL,
`Ankunftsdatum` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Daten für Tabelle `t_bestellungen`
--
INSERT INTO `t_bestellungen` (`ID`, `f_Artikel_ID`, `Menge`, `Ankunftsdatum`) VALUES
(703, 21, 14, '2018-03-06'),
(709, 47, 77, '2018-03-12'),
(710, 49, 168, '2018-03-12'),
(712, 1, 59, '2018-03-08'),
(714, 6, 547, '2018-03-08'),
(721, 21, 11, '2018-03-13'),
(722, 24, 159, '2018-03-12'),
(725, 45, 23, '2018-03-10'),
(727, 47, 83, '2018-03-19'),
(728, 49, 213, '2018-03-19'),
(729, 1, 66, '2018-03-15'),
(730, 2, 94, '2018-03-10'),
(731, 3, 428, '2018-03-09'),
(732, 4, 212, '2018-03-09'),
(733, 11, 514, '2018-03-09'),
(734, 18, 6792, '2018-03-09'),
(735, 24, 174, '2018-03-19'),
(736, 28, 616, '2018-03-09'),
(737, 29, 1249, '2018-03-15'),
(738, 46, 14, '2018-03-11'),
(739, 47, 90, '2018-03-26'),
(740, 48, 20, '2018-03-17'),
(741, 49, 236, '2018-03-26');
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `t_lager`
--
CREATE TABLE `t_lager` (
`Lagerplatz` int(11) NOT NULL,
`Paletten_ID` int(11) NOT NULL,
`f_Artikel_ID` int(11) NOT NULL,
`Ankunft` date NOT NULL,
`Menge` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Daten für Tabelle `t_lager`
--
INSERT INTO `t_lager` (`Lagerplatz`, `Paletten_ID`, `f_Artikel_ID`, `Ankunft`, `Menge`) VALUES
(1, 664, 1, '2018-02-08', 12),
(2, 700, 1, '2018-02-15', 38),
(3, 738, 1, '2018-03-01', 42),
(4, 500, 2, '2018-01-13', 7),
(5, 594, 2, '2018-01-27', 15),
(6, 636, 2, '2018-02-03', 46),
(7, 672, 2, '2018-02-10', 114),
(8, 709, 2, '2018-02-17', 94),
(9, 444, 3, '2018-01-05', 6),
(10, 535, 3, '2018-01-19', 83),
(11, 637, 3, '2018-02-02', 35),
(12, 673, 3, '2018-02-09', 412),
(13, 710, 3, '2018-02-16', 168),
(14, 730, 3, '2018-02-23', 382),
(15, 445, 4, '2018-01-05', 5),
(16, 502, 4, '2018-01-12', 5),
(17, 573, 4, '2018-01-26', 50),
(18, 596, 4, '2018-01-26', 5),
(19, 674, 4, '2018-02-09', 1),
(20, 731, 4, '2018-02-23', 80),
(21, 745, 4, '2018-03-02', 168),
(22, 446, 5, '2018-01-05', 7020),
(23, 447, 5, '2018-01-05', 6873),
(24, 639, 5, '2018-02-02', 147),
(25, 486, 6, '2018-01-11', 4),
(26, 526, 6, '2018-01-18', 5),
(27, 563, 6, '2018-01-25', 74),
(28, 620, 6, '2018-02-01', 149),
(29, 629, 6, '2018-02-01', 238),
(30, 665, 6, '2018-02-08', 120),
(31, 701, 6, '2018-02-15', 430),
(32, 724, 6, '2018-02-22', 504),
(33, 739, 6, '2018-03-01', 591),
(34, 448, 7, '2018-01-05', 4),
(35, 503, 7, '2018-01-12', 4),
(36, 538, 7, '2018-01-19', 52),
(37, 574, 7, '2018-01-26', 99),
(38, 597, 7, '2018-01-26', 50),
(39, 640, 7, '2018-02-02', 153),
(40, 675, 7, '2018-02-09', 268),
(41, 711, 7, '2018-02-16', 185),
(42, 449, 8, '2018-01-05', 5),
(43, 504, 8, '2018-01-12', 5),
(44, 539, 8, '2018-01-19', 80),
(45, 575, 8, '2018-01-26', 164),
(46, 598, 8, '2018-01-26', 257),
(47, 641, 8, '2018-02-02', 337),
(48, 676, 8, '2018-02-09', 391),
(49, 712, 8, '2018-02-16', 540),
(50, 450, 9, '2018-01-05', 10),
(51, 540, 9, '2018-01-19', 37),
(52, 576, 9, '2018-01-26', 46),
(53, 599, 9, '2018-01-26', 54),
(54, 677, 9, '2018-02-09', 82),
(55, 746, 9, '2018-03-02', 100),
(56, 451, 10, '2018-01-05', 4),
(57, 505, 10, '2018-01-12', 5),
(58, 541, 10, '2018-01-19', 54),
(59, 577, 10, '2018-01-26', 98),
(60, 600, 10, '2018-01-26', 153),
(61, 642, 10, '2018-02-02', 197),
(62, 678, 10, '2018-02-09', 342),
(63, 732, 10, '2018-02-23', 349),
(64, 452, 11, '2018-01-05', 7),
(65, 506, 11, '2018-01-12', 7),
(66, 542, 11, '2018-01-19', 68),
(67, 578, 11, '2018-01-26', 108),
(68, 601, 11, '2018-01-26', 154),
(69, 643, 11, '2018-02-02', 189),
(70, 679, 11, '2018-02-09', 318),
(71, 747, 11, '2018-03-02', 476),
(72, 453, 12, '2018-01-05', 5),
(73, 507, 12, '2018-01-12', 5),
(74, 543, 12, '2018-01-19', 167),
(75, 579, 12, '2018-01-26', 420),
(76, 602, 12, '2018-01-26', 752),
(77, 644, 12, '2018-02-02', 1050),
(78, 680, 12, '2018-02-09', 1885),
(79, 713, 12, '2018-02-16', 1765),
(80, 454, 13, '2018-01-05', 7),
(81, 508, 13, '2018-01-12', 7),
(82, 544, 13, '2018-01-19', 113),
(83, 580, 13, '2018-01-26', 195),
(84, 603, 13, '2018-01-26', 298),
(85, 645, 13, '2018-02-02', 378),
(86, 681, 13, '2018-02-09', 644),
(87, 748, 13, '2018-03-02', 645),
(88, 455, 14, '2018-01-05', 6),
(89, 509, 14, '2018-01-12', 6),
(90, 545, 14, '2018-01-19', 85),
(91, 581, 14, '2018-01-26', 154),
(92, 604, 14, '2018-01-26', 235),
(93, 646, 14, '2018-02-02', 301),
(94, 682, 14, '2018-02-09', 505),
(95, 714, 14, '2018-02-16', 459),
(96, 456, 15, '2018-01-08', 3630),
(97, 457, 15, '2018-01-08', 3630),
(98, 458, 16, '2018-01-05', 3360),
(99, 459, 16, '2018-01-05', 3360),
(100, 460, 17, '2018-01-07', 2),
(101, 510, 17, '2018-01-14', 3),
(102, 546, 17, '2018-01-21', 19),
(103, 582, 17, '2018-01-28', 32),
(104, 605, 17, '2018-01-28', 47),
(105, 647, 17, '2018-02-04', 59),
(106, 683, 17, '2018-02-11', 103),
(107, 715, 17, '2018-02-18', 89),
(108, 733, 17, '2018-02-25', 64),
(109, 749, 17, '2018-03-04', 136),
(110, 461, 18, '2018-01-05', 23),
(111, 547, 18, '2018-01-19', 723),
(112, 583, 18, '2018-01-26', 1257),
(113, 606, 18, '2018-01-26', 1867),
(114, 648, 18, '2018-02-02', 2359),
(115, 684, 18, '2018-02-09', 4062),
(116, 750, 18, '2018-03-02', 5470),
(117, 487, 19, '2018-01-11', 1080),
(118, 488, 19, '2018-01-11', 1080),
(119, 462, 20, '2018-01-05', 13),
(120, 548, 20, '2018-01-19', 324),
(121, 584, 20, '2018-01-26', 609),
(122, 607, 20, '2018-01-26', 900),
(123, 649, 20, '2018-02-02', 1149),
(124, 685, 20, '2018-02-09', 1967),
(125, 716, 20, '2018-02-16', 1824),
(126, 751, 20, '2018-03-02', 2673),
(127, 735, 21, '2018-02-27', 10),
(128, 721, 21, '2018-02-20', 12),
(129, 697, 21, '2018-02-13', 7),
(130, 658, 21, '2018-02-06', 4),
(131, 616, 21, '2018-01-30', 3),
(132, 559, 21, '2018-01-23', 1),
(133, 522, 21, '2018-01-16', 1),
(134, 661, 21, '2018-02-06', 6),
(135, 463, 22, '2018-01-05', 7),
(136, 511, 22, '2018-01-12', 7),
(137, 549, 22, '2018-01-19', 115),
(138, 585, 22, '2018-01-26', 258),
(139, 608, 22, '2018-01-26', 420),
(140, 650, 22, '2018-02-02', 558),
(141, 686, 22, '2018-02-09', 1004),
(142, 717, 22, '2018-02-16', 905),
(143, 464, 23, '2018-01-05', 5),
(144, 512, 23, '2018-01-12', 6),
(145, 550, 23, '2018-01-19', 122),
(146, 586, 23, '2018-01-26', 267),
(147, 609, 23, '2018-01-26', 436),
(148, 651, 23, '2018-02-02', 584),
(149, 687, 23, '2018-02-09', 1056),
(150, 718, 23, '2018-02-16', 979),
(151, 489, 24, '2018-01-15', 8),
(152, 527, 24, '2018-01-22', 8),
(153, 564, 24, '2018-01-29', 45),
(154, 621, 24, '2018-02-05', 60),
(155, 630, 24, '2018-02-05', 77),
(156, 666, 24, '2018-02-12', 88),
(157, 702, 24, '2018-02-19', 142),
(158, 725, 24, '2018-02-26', 119),
(159, 740, 24, '2018-03-05', 133),
(160, 490, 25, '2018-01-11', 3),
(161, 528, 25, '2018-01-18', 4),
(162, 565, 25, '2018-01-25', 83),
(163, 622, 25, '2018-02-01', 203),
(164, 631, 25, '2018-02-01', 357),
(165, 667, 25, '2018-02-08', 495),
(166, 703, 25, '2018-02-15', 856),
(167, 726, 25, '2018-02-22', 819),
(168, 741, 25, '2018-03-01', 981),
(169, 465, 26, '2018-01-04', 2),
(170, 513, 26, '2018-01-11', 2),
(171, 551, 26, '2018-01-18', 17),
(172, 587, 26, '2018-01-25', 31),
(173, 610, 26, '2018-01-25', 48),
(174, 652, 26, '2018-02-01', 61),
(175, 688, 26, '2018-02-08', 106),
(176, 466, 27, '2018-01-05', 4),
(177, 514, 27, '2018-01-12', 4),
(178, 552, 27, '2018-01-19', 47),
(179, 588, 27, '2018-01-26', 90),
(180, 611, 27, '2018-01-26', 138),
(181, 653, 27, '2018-02-02', 178),
(182, 689, 27, '2018-02-09', 310),
(183, 467, 28, '2018-01-05', 6),
(184, 515, 28, '2018-01-12', 6),
(185, 553, 28, '2018-01-19', 66),
(186, 589, 28, '2018-01-26', 134),
(187, 612, 28, '2018-01-26', 206),
(188, 654, 28, '2018-02-02', 265),
(189, 690, 28, '2018-02-09', 408),
(190, 752, 28, '2018-03-02', 513),
(191, 491, 29, '2018-01-11', 6),
(192, 529, 29, '2018-01-18', 6),
(193, 566, 29, '2018-01-25', 123),
(194, 623, 29, '2018-02-01', 257),
(195, 632, 29, '2018-02-01', 421),
(196, 668, 29, '2018-02-08', 561),
(197, 704, 29, '2018-02-15', 1020),
(198, 727, 29, '2018-02-22', 912),
(199, 742, 29, '2018-03-01', 1081),
(200, 492, 30, '2018-01-11', 1080),
(201, 493, 30, '2018-01-11', 1080),
(202, 468, 31, '2018-01-01', 2),
(203, 753, 32, '2018-03-02', 4800),
(204, 754, 32, '2018-03-02', 4800),
(205, 494, 33, '2018-01-10', 3),
(206, 530, 33, '2018-01-17', 4),
(207, 567, 33, '2018-01-24', 6),
(208, 624, 33, '2018-01-31', 7),
(209, 705, 33, '2018-02-14', 10),
(210, 743, 33, '2018-02-28', 8),
(211, 719, 34, '2018-02-12', 21),
(212, 472, 35, '2018-01-08', 3),
(213, 516, 35, '2018-01-15', 3),
(214, 554, 35, '2018-01-22', 5),
(215, 590, 35, '2018-01-29', 6),
(216, 613, 35, '2018-01-29', 7),
(217, 655, 35, '2018-02-05', 8),
(218, 691, 35, '2018-02-12', 12),
(219, 473, 36, '2018-01-01', 2),
(220, 474, 37, '2018-01-04', 3),
(221, 517, 37, '2018-01-11', 4),
(222, 555, 37, '2018-01-18', 27),
(223, 591, 37, '2018-01-25', 43),
(224, 614, 37, '2018-01-25', 61),
(225, 656, 37, '2018-02-01', 75),
(226, 692, 37, '2018-02-08', 127),
(227, 495, 38, '2018-01-13', 2),
(228, 531, 38, '2018-01-20', 3),
(229, 568, 38, '2018-01-27', 4),
(230, 625, 38, '2018-02-03', 5),
(231, 633, 38, '2018-02-03', 6),
(232, 669, 38, '2018-02-10', 7),
(233, 706, 38, '2018-02-17', 11),
(234, 728, 38, '2018-02-24', 9),
(235, 744, 38, '2018-03-03', 10),
(236, 496, 39, '2018-01-13', 50),
(237, 497, 39, '2018-01-13', 50),
(238, 475, 40, '2018-01-05', 6),
(239, 518, 40, '2018-01-12', 6),
(240, 556, 40, '2018-01-19', 9),
(241, 693, 40, '2018-02-09', 13),
(242, 476, 41, '2018-01-07', 34),
(243, 477, 41, '2018-01-07', 34),
(244, 478, 42, '2018-01-08', 450),
(245, 479, 42, '2018-01-08', 450),
(246, 480, 43, '2018-01-08', 480),
(247, 481, 43, '2018-01-08', 480),
(248, 482, 44, '2018-01-05', 6),
(249, 519, 44, '2018-01-12', 6),
(250, 557, 44, '2018-01-19', 13),
(251, 592, 44, '2018-01-26', 15),
(252, 694, 44, '2018-02-09', 24),
(253, 498, 45, '2018-01-13', 4),
(254, 532, 45, '2018-01-20', 5),
(255, 569, 45, '2018-01-27', 9),
(256, 626, 45, '2018-02-03', 10),
(257, 634, 45, '2018-02-03', 12),
(258, 670, 45, '2018-02-10', 13),
(259, 707, 45, '2018-02-17', 20),
(260, 729, 45, '2018-02-24', 22),
(261, 483, 46, '2018-01-07', 7),
(262, 520, 46, '2018-01-14', 7),
(263, 695, 46, '2018-02-11', 9),
(264, 755, 46, '2018-03-04', 12),
(265, 722, 47, '2018-02-26', 89),
(266, 698, 47, '2018-02-19', 57),
(267, 659, 47, '2018-02-12', 35),
(268, 523, 47, '2018-01-22', 9),
(269, 560, 47, '2018-01-29', 9),
(270, 617, 47, '2018-02-05', 37),
(271, 662, 47, '2018-02-12', 52),
(272, 736, 47, '2018-03-05', 70),
(273, 499, 48, '2018-01-13', 5),
(274, 533, 48, '2018-01-20', 5),
(275, 570, 48, '2018-01-27', 10),
(276, 627, 48, '2018-02-03', 11),
(277, 635, 48, '2018-02-03', 13),
(278, 671, 48, '2018-02-10', 14),
(279, 708, 48, '2018-02-17', 21),
(280, 723, 49, '2018-02-26', 150),
(281, 660, 49, '2018-02-12', 71),
(282, 524, 49, '2018-01-22', 10),
(283, 561, 49, '2018-01-29', 10),
(284, 618, 49, '2018-02-05', 56),
(285, 663, 49, '2018-02-12', 88),
(286, 699, 49, '2018-02-19', 99),
(287, 737, 49, '2018-03-05', 121),
(288, 484, 50, '2018-01-08', 3),
(289, 521, 50, '2018-01-15', 4),
(290, 558, 50, '2018-01-22', 25),
(291, 593, 50, '2018-01-29', 40),
(292, 615, 50, '2018-01-29', 57),
(293, 657, 50, '2018-02-05', 70),
(294, 696, 50, '2018-02-12', 118),
(295, 720, 50, '2018-02-19', 102),
(296, 734, 50, '2018-02-26', 118);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `t_lagerstatistik`
--
CREATE TABLE `t_lagerstatistik` (
`Woche` int(11) NOT NULL,
`Wert` float NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Daten für Tabelle `t_lagerstatistik`
--
INSERT INTO `t_lagerstatistik` (`Woche`, `Wert`) VALUES
(1, 1000),
(2, 1100),
(3, 1200),
(4, 1300),
(5, 1400),
(6, 3000),
(7, 3500),
(8, 4000),
(9, 4500),
(10, 5000),
(11, 5500),
(12, 6000),
(13, 6500),
(14, 7000),
(15, 7500),
(16, 8000),
(17, 8500),
(18, 9000),
(19, 9500),
(20, 10000),
(21, 10500),
(22, 11000),
(23, 11500),
(24, 12000),
(25, 12500),
(26, 13000),
(27, 13500),
(28, 14000),
(29, 14500),
(30, 15000),
(31, 15500),
(32, 16000),
(33, 16500),
(34, 17000),
(35, 17500),
(36, 18000),
(37, 18500),
(38, 19000),
(39, 19500),
(40, 20000),
(41, 20500),
(42, 21000),
(43, 21500),
(44, 22000),
(45, 22500),
(46, 23000),
(47, 23500),
(48, 24000),
(49, 0),
(50, 53392),
(51, 68754.7),
(52, 70907.6),
(53, 80199.5),
(54, 90386.6),
(55, 105373),
(56, 117264),
(57, 114100),
(58, 130659),
(59, 35946),
(60, 40336.3),
(61, 44846.3),
(62, 49846.3),
(63, 53738.7),
(64, 59730.3),
(65, 52479.2),
(66, 60084.1),
(67, 78463.8),
(68, 103564);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `t_mindesthaltbarkeit`
--
CREATE TABLE `t_mindesthaltbarkeit` (
`ID` int(11) NOT NULL,
`f_ProduktID` int(11) NOT NULL,
`Haltbarkeit` date NOT NULL,
`Menge` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Daten für Tabelle `t_mindesthaltbarkeit`
--
INSERT INTO `t_mindesthaltbarkeit` (`ID`, `f_ProduktID`, `Haltbarkeit`, `Menge`) VALUES
(444, 3, '2018-03-24', 6),
(445, 4, '2018-07-07', 5),
(446, 5, '2018-06-07', 7020),
(447, 5, '2018-06-07', 6873),
(448, 7, '2019-12-09', 4),
(449, 8, '2018-12-24', 5),
(450, 9, '2018-11-24', 10),
(451, 10, '2018-10-05', 4),
(452, 11, '2019-02-12', 7),
(453, 12, '2018-04-18', 5),
(454, 13, '2018-07-17', 7),
(455, 14, '2020-03-18', 6),
(456, 15, '2018-07-27', 3630),
(457, 15, '2018-07-27', 3630),
(458, 16, '2018-03-09', 3360),
(459, 16, '2018-03-09', 3360),
(460, 17, '2019-03-04', 2),
(461, 18, '2018-07-07', 23),
(462, 20, '2020-05-17', 13),
(463, 22, '2019-03-04', 7),
(464, 23, '2018-12-04', 5),
(465, 26, '2018-06-07', 2),
(466, 27, '2018-05-28', 4),
(467, 28, '2019-11-19', 6),
(468, 31, '2018-03-09', 2),
(472, 35, '2018-08-26', 3),
(473, 36, '2018-07-07', 2),
(474, 37, '2018-07-27', 3),
(475, 40, '2018-03-22', 6),
(476, 41, '2018-07-17', 34),
(477, 41, '2018-07-17', 34),
(478, 42, '2018-04-12', 450),
(479, 42, '2018-04-12', 450),
(480, 43, '2018-05-08', 480),
(481, 43, '2018-05-08', 480),
(482, 44, '2018-03-19', 6),
(483, 46, '2018-08-07', 7),
(484, 50, '2018-08-26', 3),
(486, 6, '2018-06-14', 4),
(487, 19, '2019-11-06', 1080),
(488, 19, '2019-11-06', 1080),
(489, 24, '2018-06-14', 8),
(490, 25, '2018-06-04', 3),
(491, 29, '2018-03-21', 6),
(492, 30, '2019-11-06', 1080),
(493, 30, '2019-11-06', 1080),
(494, 33, '2019-02-19', 3),
(495, 38, '2019-12-16', 2),
(496, 39, '2018-03-16', 50),
(497, 39, '2018-03-16', 50),
(498, 45, '2018-05-08', 4),
(499, 48, '2018-04-15', 5),
(500, 2, '2018-07-04', 7),
(502, 4, '2018-07-14', 5),
(503, 7, '2019-12-16', 4),
(504, 8, '2018-12-31', 5),
(505, 10, '2018-10-12', 5),
(506, 11, '2019-02-19', 7),
(507, 12, '2018-04-25', 5),
(508, 13, '2018-07-24', 7),
(509, 14, '2020-03-25', 6),
(510, 17, '2019-03-11', 3),
(511, 22, '2019-03-11', 7),
(512, 23, '2018-12-11', 6),
(513, 26, '2018-06-14', 2),
(514, 27, '2018-06-04', 4),
(515, 28, '2019-11-26', 6),
(516, 35, '2018-09-02', 3),
(517, 37, '2018-08-03', 4),
(518, 40, '2018-03-29', 6),
(519, 44, '2018-03-26', 6),
(520, 46, '2018-08-14', 7),
(521, 50, '2018-09-02', 4),
(522, 21, '9999-12-31', 1),
(523, 47, '2018-03-30', 9),
(524, 49, '2018-08-10', 10),
(526, 6, '2018-06-21', 5),
(527, 24, '2018-06-21', 8),
(528, 25, '2018-06-11', 4),
(529, 29, '2018-03-28', 6),
(530, 33, '2019-02-26', 4),
(531, 38, '2019-12-23', 3),
(532, 45, '2018-05-15', 5),
(533, 48, '2018-04-22', 5),
(535, 3, '2018-04-07', 83),
(538, 7, '2019-12-23', 52),
(539, 8, '2019-01-07', 80),
(540, 9, '2018-12-08', 37),
(541, 10, '2018-10-19', 54),
(542, 11, '2019-02-26', 68),
(543, 12, '2018-05-02', 167),
(544, 13, '2018-07-31', 113),
(545, 14, '2020-04-01', 85),
(546, 17, '2019-03-18', 19),
(547, 18, '2018-07-21', 723),
(548, 20, '2020-05-31', 324),
(549, 22, '2019-03-18', 115),
(550, 23, '2018-12-18', 122),
(551, 26, '2018-06-21', 17),
(552, 27, '2018-06-11', 47),
(553, 28, '2019-12-03', 66),
(554, 35, '2018-09-09', 5),
(555, 37, '2018-08-10', 27),
(556, 40, '2018-04-05', 9),
(557, 44, '2018-04-02', 13),
(558, 50, '2018-09-09', 25),
(559, 21, '9999-12-31', 1),
(560, 47, '2018-04-06', 9),
(561, 49, '2018-08-17', 10),
(563, 6, '2018-06-28', 74),
(564, 24, '2018-06-28', 45),
(565, 25, '2018-06-18', 83),
(566, 29, '2018-04-04', 123),
(567, 33, '2019-03-05', 6),
(568, 38, '2019-12-30', 4),
(569, 45, '2018-05-22', 9),
(570, 48, '2018-04-29', 10),
(573, 4, '2018-07-28', 50),
(574, 7, '2019-12-30', 99),
(575, 8, '2019-01-14', 164),
(576, 9, '2018-12-15', 46),
(577, 10, '2018-10-26', 98),
(578, 11, '2019-03-05', 108),
(579, 12, '2018-05-09', 420),
(580, 13, '2018-08-07', 195),
(581, 14, '2020-04-08', 154),
(582, 17, '2019-03-25', 32),
(583, 18, '2018-07-28', 1257),
(584, 20, '2020-06-07', 609),
(585, 22, '2019-03-25', 258),
(586, 23, '2018-12-25', 267),
(587, 26, '2018-06-28', 31),
(588, 27, '2018-06-18', 90),
(589, 28, '2019-12-10', 134),
(590, 35, '2018-09-16', 6),
(591, 37, '2018-08-17', 43),
(592, 44, '2018-04-09', 15),
(593, 50, '2018-09-16', 40),
(594, 2, '2018-07-18', 15),
(596, 4, '2018-07-28', 5),
(597, 7, '2019-12-30', 50),
(598, 8, '2019-01-14', 257),
(599, 9, '2018-12-15', 54),
(600, 10, '2018-10-26', 153),
(601, 11, '2019-03-05', 154),
(602, 12, '2018-05-09', 752),
(603, 13, '2018-08-07', 298),
(604, 14, '2020-04-08', 235),
(605, 17, '2019-03-25', 47),
(606, 18, '2018-07-28', 1867),
(607, 20, '2020-06-07', 900),
(608, 22, '2019-03-25', 420),
(609, 23, '2018-12-25', 436),
(610, 26, '2018-06-28', 48),
(611, 27, '2018-06-18', 138),
(612, 28, '2019-12-10', 206),
(613, 35, '2018-09-16', 7),
(614, 37, '2018-08-17', 61),
(615, 50, '2018-09-16', 57),
(616, 21, '9999-12-31', 3),
(617, 47, '2018-04-13', 37),
(618, 49, '2018-08-24', 56),
(620, 6, '2018-07-05', 149),
(621, 24, '2018-07-05', 60),
(622, 25, '2018-06-25', 203),
(623, 29, '2018-04-11', 257),
(624, 33, '2019-03-12', 7),
(625, 38, '2020-01-06', 5),
(626, 45, '2018-05-29', 10),
(627, 48, '2018-05-06', 11),
(629, 6, '2018-07-05', 238),
(630, 24, '2018-07-05', 77),
(631, 25, '2018-06-25', 357),
(632, 29, '2018-04-11', 421),
(633, 38, '2020-01-06', 6),
(634, 45, '2018-05-29', 12),
(635, 48, '2018-05-06', 13),
(636, 2, '2018-07-25', 46),
(637, 3, '2018-04-21', 35),
(639, 5, '2018-07-05', 147),
(640, 7, '2020-01-06', 153),
(641, 8, '2019-01-21', 337),
(642, 10, '2018-11-02', 197),
(643, 11, '2019-03-12', 189),
(644, 12, '2018-05-16', 1050),
(645, 13, '2018-08-14', 378),
(646, 14, '2020-04-15', 301),
(647, 17, '2019-04-01', 59),
(648, 18, '2018-08-04', 2359),
(649, 20, '2020-06-14', 1149),
(650, 22, '2019-04-01', 558),
(651, 23, '2019-01-01', 584),
(652, 26, '2018-07-05', 61),
(653, 27, '2018-06-25', 178),
(654, 28, '2019-12-17', 265),
(655, 35, '2018-09-23', 8),
(656, 37, '2018-08-24', 75),
(657, 50, '2018-09-23', 70),
(658, 21, '9999-12-31', 4),
(659, 47, '2018-04-20', 35),
(660, 49, '2018-08-31', 71),
(661, 21, '9999-12-31', 6),
(662, 47, '2018-04-20', 52),
(663, 49, '2018-08-31', 88),
(664, 1, '2019-01-28', 12),
(665, 6, '2018-07-12', 120),
(666, 24, '2018-07-12', 88),
(667, 25, '2018-07-02', 495),
(668, 29, '2018-04-18', 561),
(669, 38, '2020-01-13', 7),
(670, 45, '2018-06-05', 13),
(671, 48, '2018-05-13', 14),
(672, 2, '2018-08-01', 114),
(673, 3, '2018-04-28', 412),
(674, 4, '2018-08-11', 1),
(675, 7, '2020-01-13', 268),
(676, 8, '2019-01-28', 391),
(677, 9, '2018-12-29', 82),
(678, 10, '2018-11-09', 342),
(679, 11, '2019-03-19', 318),
(680, 12, '2018-05-23', 1885),
(681, 13, '2018-08-21', 644),
(682, 14, '2020-04-22', 505),
(683, 17, '2019-04-08', 103),
(684, 18, '2018-08-11', 4062),
(685, 20, '2020-06-21', 1967),
(686, 22, '2019-04-08', 1004),
(687, 23, '2019-01-08', 1056),
(688, 26, '2018-07-12', 106),
(689, 27, '2018-07-02', 310),
(690, 28, '2019-12-24', 408),
(691, 35, '2018-09-30', 12),
(692, 37, '2018-08-31', 127),
(693, 40, '2018-04-26', 13),
(694, 44, '2018-04-23', 24),
(695, 46, '2018-09-11', 9),
(696, 50, '2018-09-30', 118),
(697, 21, '9999-12-31', 7),
(698, 47, '2018-04-27', 57),
(699, 49, '2018-09-07', 99),
(700, 1, '2019-02-04', 38),
(701, 6, '2018-07-19', 430),
(702, 24, '2018-07-19', 142),
(703, 25, '2018-07-09', 856),
(704, 29, '2018-04-25', 1020),
(705, 33, '2019-03-26', 10),
(706, 38, '2020-01-20', 11),
(707, 45, '2018-06-12', 20),
(708, 48, '2018-05-20', 21),
(709, 2, '2018-08-08', 94),
(710, 3, '2018-05-05', 168),
(711, 7, '2020-01-20', 185),
(712, 8, '2019-02-04', 540),
(713, 12, '2018-05-30', 1765),
(714, 14, '2020-04-29', 459),
(715, 17, '2019-04-15', 89),
(716, 20, '2020-06-28', 1824),
(717, 22, '2019-04-15', 905),
(718, 23, '2019-01-15', 979),
(719, 34, '2018-03-21', 21),
(720, 50, '2018-10-07', 102),
(721, 21, '9999-12-31', 12),
(722, 47, '2018-05-04', 89),
(723, 49, '2018-09-14', 150),
(724, 6, '2018-07-26', 504),
(725, 24, '2018-07-26', 119),
(726, 25, '2018-07-16', 819),
(727, 29, '2018-05-02', 912),
(728, 38, '2020-01-27', 9),
(729, 45, '2018-06-19', 22),
(730, 3, '2018-05-12', 382),
(731, 4, '2018-08-25', 80),
(732, 10, '2018-11-23', 349),
(733, 17, '2019-04-22', 64),
(734, 50, '2018-10-14', 118),
(735, 21, '9999-12-31', 10),
(736, 47, '2018-05-11', 70),
(737, 49, '2018-09-21', 121),
(738, 1, '2019-02-18', 42),
(739, 6, '2018-08-02', 591),
(740, 24, '2018-08-02', 133),
(741, 25, '2018-07-23', 981),
(742, 29, '2018-05-09', 1081),
(743, 33, '2019-04-09', 8),
(744, 38, '2020-02-03', 10),
(745, 4, '2018-09-01', 168),
(746, 9, '2019-01-19', 100),
(747, 11, '2019-04-09', 476),
(748, 13, '2018-09-11', 645),
(749, 17, '2019-04-29', 136),
(750, 18, '2018-09-01', 5470),
(751, 20, '2020-07-12', 2673),
(752, 28, '2020-01-14', 513),
(753, 32, '2018-04-19', 4800),
(754, 32, '2018-04-19', 4800),
(755, 46, '2018-10-02', 12);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `t_statistik`
--
CREATE TABLE `t_statistik` (
`ID` int(11) NOT NULL,
`f_Artikel_ID` int(11) NOT NULL,
`Woche` int(10) NOT NULL,
`Menge` int(11) NOT NULL COMMENT 'verkaufte Menge',
`Verkaufspreis` float NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Daten für Tabelle `t_statistik`
--
INSERT INTO `t_statistik` (`ID`, `f_Artikel_ID`, `Woche`, `Menge`, `Verkaufspreis`) VALUES
(38526, 1, 1, 5, 0.424227),
(38527, 2, 1, 31, 0.795426),
(38528, 3, 1, 143, 0.927997),
(38529, 4, 1, 31, 1.31123),
(38530, 5, 1, 382, 1.69691),
(38531, 6, 1, 188, 1.69691),
(38532, 7, 1, 107, 2.19333),
(38533, 8, 1, 197, 1.53782),
(38534, 9, 1, 15, 0.381448),
(38535, 10, 1, 102, 1.74994),
(38536, 11, 1, 81, 0.810577),
(38537, 12, 1, 744, 1.24617),
(38538, 13, 1, 203, 0.662855),
(38539, 14, 1, 166, 1.08708),
(38540, 15, 1, 209, 0.742397),
(38541, 16, 1, 189, 1.51131),
(38542, 17, 1, 30, 5.17027),
(38543, 18, 1, 1159, 0.0715215),
(38544, 19, 1, 52, 3.49987),
(38545, 20, 1, 665, 0.212114),
(38546, 21, 1, 3, 28.6086),
(38547, 22, 1, 227, 0.742397),
(38548, 23, 1, 364, 1.14011),
(38549, 24, 1, 28, 0.596012),
(38550, 25, 1, 342, 2.70445),
(38551, 26, 1, 34, 7.37094),
(38552, 27, 1, 89, 2.16948),
(38553, 28, 1, 93, 1.0013),
(38554, 29, 1, 345, 1.06057),
(38555, 30, 1, 19, 3.49987),
(38556, 31, 1, 13, 4.55353),
(38557, 32, 1, 354, 0.954511),
(38558, 33, 1, 2, 2.73096),
(38559, 34, 1, 7, 0.31817),
(38560, 35, 1, 2, 3.1817),
(38561, 36, 1, 2, 7.95426),
(38562, 37, 1, 36, 2.65142),
(38563, 38, 1, 2, 5.2233),
(38564, 39, 1, 2, 2.65142),
(38565, 40, 1, 2, 0.901482),
(38566, 41, 1, 2, 5.30284),
(38567, 42, 1, 32, 2.94308),
(38568, 43, 1, 21, 1.72342),
(38569, 44, 1, 4, 0.954511),
(38570, 45, 1, 3, 1.72342),
(38571, 46, 1, 1, 0.768911),
(38572, 47, 1, 16, 0.477255),
(38573, 48, 1, 3, 1.2992),
(38574, 49, 1, 28, 0.357607),
(38575, 50, 1, 33, 2.91656),
(38576, 1, 2, 5, 0.424227),
(38577, 2, 2, 31, 0.795426),
(38578, 3, 2, 143, 0.927997),
(38579, 4, 2, 31, 1.31123),
(38580, 5, 2, 374, 1.69691),
(38581, 6, 2, 188, 1.69691),
(38582, 7, 2, 105, 2.19333),
(38583, 8, 2, 211, 1.53782),
(38584, 9, 2, 16, 0.381448),
(38585, 10, 2, 105, 1.74994),
(38586, 11, 2, 81, 0.810577),
(38587, 12, 2, 736, 1.24617),
(38588, 13, 2, 194, 0.662855),
(38589, 14, 2, 166, 1.08708),
(38590, 15, 2, 208, 0.742397),
(38591, 16, 2, 189, 1.51131),
(38592, 17, 2, 31, 5.17027),
(38593, 18, 2, 1128, 0.0715215),
(38594, 19, 2, 52, 3.49987),
(38595, 20, 2, 683, 0.212114),
(38596, 21, 2, 3, 28.6086),
(38597, 22, 2, 341, 0.742397),
(38598, 23, 2, 381, 1.14011),
(38599, 24, 2, 28, 0.596012),
(38600, 25, 2, 343, 2.70445),
(38601, 26, 2, 33, 7.37094),
(38602, 27, 2, 93, 2.16948),
(38603, 28, 2, 134, 1.0013),
(38604, 29, 2, 345, 1.06057),
(38605, 30, 2, 19, 3.49987),
(38606, 31, 2, 13, 4.55353),
(38607, 32, 2, 368, 0.954511),
(38608, 33, 2, 2, 2.73096),
(38609, 34, 2, 7, 0.31817),
(38610, 35, 2, 2, 3.1817),
(38611, 36, 2, 1, 7.95426),
(38612, 37, 2, 36, 2.65142),
(38613, 38, 2, 2, 5.2233),
(38614, 39, 2, 2, 2.65142),
(38615, 40, 2, 2, 0.901482),
(38616, 41, 2, 2, 5.30284),
(38617, 42, 2, 32, 2.94308),
(38618, 43, 2, 19, 1.72342),
(38619, 44, 2, 4, 0.954511),
(38620, 45, 2, 3, 1.72342),
(38621, 46, 2, 1, 0.768911),
(38622, 47, 2, 10, 0.477255),
(38623, 48, 2, 3, 1.2992),
(38624, 49, 2, 28, 0.357607),
(38625, 50, 2, 33, 2.91656),
(38626, 1, 3, 6, 0.424227),
(38627, 2, 3, 31, 0.795426),
(38628, 3, 3, 142, 0.927997),
(38629, 4, 3, 26, 1.31123),
(38630, 5, 3, 147, 1.69691),
(38631, 6, 3, 187, 1.69691),
(38632, 7, 3, 106, 2.19333),
(38633, 8, 3, 199, 1.53782),
(38634, 9, 3, 15, 0.381448),
(38635, 10, 3, 109, 1.74994),
(38636, 11, 3, 80, 0.810577),
(38637, 12, 3, 740, 1.24617),
(38638, 13, 3, 201, 0.662855),
(38639, 14, 3, 164, 1.08708),
(38640, 15, 3, 198, 0.742397),
(38641, 16, 3, 182, 1.51131),
(38642, 17, 3, 30, 5.17027),
(38643, 18, 3, 1106, 0.0715215),
(38644, 19, 3, 53, 3.49987),
(38645, 20, 3, 621, 0.212114),
(38646, 21, 3, 3, 28.6086),
(38647, 22, 3, 341, 0.742397),
(38648, 23, 3, 366, 1.14011),
(38649, 24, 3, 28, 0.596012),
(38650, 25, 3, 342, 2.70445),
(38651, 26, 3, 34, 7.37094),
(38652, 27, 3, 90, 2.16948),
(38653, 28, 3, 133, 1.0013),
(38654, 29, 3, 346, 1.06057),
(38655, 30, 3, 19, 3.49987),
(38656, 31, 3, 13, 4.55353),
(38657, 32, 3, 356, 0.954511),
(38658, 33, 3, 1, 2.73096),
(38659, 34, 3, 7, 0.31817),
(38660, 35, 3, 2, 3.1817),
(38661, 36, 3, 1, 7.95426),
(38662, 37, 3, 36, 2.65142),
(38663, 38, 3, 2, 5.2233),
(38664, 39, 3, 2, 2.65142),
(38665, 40, 3, 2, 0.901482),
(38666, 41, 3, 2, 5.30284),
(38667, 42, 3, 32, 2.94308),
(38668, 43, 3, 21, 1.72342),
(38669, 44, 3, 4, 0.954511),
(38670, 45, 3, 3, 1.72342),
(38671, 46, 3, 1, 0.768911),
(38672, 47, 3, 16, 0.477255),
(38673, 48, 3, 3, 1.2992),
(38674, 49, 3, 28, 0.357607),
(38675, 50, 3, 33, 2.91656),
(38676, 1, 4, 5, 0.424227),
(38677, 2, 4, 31, 0.795426),
(38678, 3, 4, 142, 0.927997),
(38679, 4, 4, 35, 1.31123),
(38680, 5, 4, 370, 1.69691),
(38681, 6, 4, 189, 1.69691),
(38682, 7, 4, 105, 2.19333),
(38683, 8, 4, 202, 1.53782),
(38684, 9, 4, 15, 0.381448),
(38685, 10, 4, 113, 1.74994),
(38686, 11, 4, 80, 0.810577),
(38687, 12, 4, 724, 1.24617),
(38688, 13, 4, 191, 0.662855),
(38689, 14, 4, 163, 1.08708),
(38690, 15, 4, 205, 0.742397),
(38691, 16, 4, 186, 1.51131),
(38692, 17, 4, 33, 5.17027),
(38693, 18, 4, 1122, 0.0715215),
(38694, 19, 4, 55, 3.49987),
(38695, 20, 4, 557, 0.212114),
(38696, 21, 4, 3, 28.6086),
(38697, 22, 4, 349, 0.742397),
(38698, 23, 4, 366, 1.14011),
(38699, 24, 4, 28, 0.596012),
(38700, 25, 4, 276, 2.70445),
(38701, 26, 4, 33, 7.37094),
(38702, 27, 4, 90, 2.16948),
(38703, 28, 4, 133, 1.0013),
(38704, 29, 4, 364, 1.06057),
(38705, 30, 4, 20, 3.49987),
(38706, 31, 4, 15, 4.55353),
(38707, 32, 4, 356, 0.954511),
(38708, 33, 4, 2, 2.73096),
(38709, 34, 4, 5, 0.31817),
(38710, 35, 4, 2, 3.1817),
(38711, 36, 4, 1, 7.95426),
(38712, 37, 4, 36, 2.65142),
(38713, 38, 4, 2, 5.2233),
(38714, 39, 4, 2, 2.65142),
(38715, 40, 4, 2, 0.901482),
(38716, 41, 4, 2, 5.30284),
(38717, 42, 4, 32, 2.94308),
(38718, 43, 4, 20, 1.72342),
(38719, 44, 4, 5, 0.954511),
(38720, 45, 4, 3, 1.72342),
(38721, 46, 4, 1, 0.768911),
(38722, 47, 4, 16, 0.477255),
(38723, 48, 4, 3, 1.2992),
(38724, 49, 4, 27, 0.357607),
(38725, 50, 4, 33, 2.91656),
(38726, 1, 4, 5, 0.424227),
(38727, 2, 4, 31, 0.795426),
(38728, 3, 4, 139, 0.927997),
(38729, 4, 4, 31, 1.31123),
(38730, 5, 4, 359, 1.69691),
(38731, 6, 4, 189, 1.69691),
(38732, 7, 4, 107, 2.19333),
(38733, 8, 4, 204, 1.53782),
(38734, 9, 4, 15, 0.381448),
(38735, 10, 4, 105, 1.74994),
(38736, 11, 4, 79, 0.810577),
(38737, 12, 4, 709, 1.24617),
(38738, 13, 4, 201, 0.662855),
(38739, 14, 4, 145, 1.08708),
(38740, 15, 4, 207, 0.742397),
(38741, 16, 4, 196, 1.51131),
(38742, 17, 4, 30, 5.17027),
(38743, 18, 4, 1100, 0.0715215),
(38744, 19, 4, 58, 3.49987),
(38745, 20, 4, 660, 0.212114),
(38746, 21, 4, 3, 28.6086),
(38747, 22, 4, 356, 0.742397),
(38748, 23, 4, 390, 1.14011),
(38749, 24, 4, 28, 0.596012),
(38750, 25, 4, 343, 2.70445),
(38751, 26, 4, 34, 7.37094),
(38752, 27, 4, 90, 2.16948),
(38753, 28, 4, 75, 1.0013),
(38754, 29, 4, 363, 1.06057),
(38755, 30, 4, 19, 3.49987),
(38756, 31, 4, 13, 4.55353),
(38757, 32, 4, 388, 0.954511),
(38758, 33, 4, 2, 2.73096),
(38759, 34, 4, 7, 0.31817),
(38760, 35, 4, 2, 3.1817),
(38761, 36, 4, 1, 7.95426),
(38762, 37, 4, 36, 2.65142),
(38763, 38, 4, 2, 5.2233),
(38764, 39, 4, 2, 2.65142),
(38765, 40, 4, 2, 0.901482),
(38766, 41, 4, 2, 5.30284),
(38767, 42, 4, 32, 2.94308),
(38768, 43, 4, 21, 1.72342),
(38769, 44, 4, 4, 0.954511),
(38770, 45, 4, 3, 1.72342),
(38771, 46, 4, 1, 0.768911),
(38772, 47, 4, 16, 0.477255),
(38773, 48, 4, 3, 1.2992),
(38774, 49, 4, 24, 0.357607),
(38775, 50, 4, 33, 2.91656),
(38776, 1, 5, 5, 0.424227),
(38777, 2, 5, 31, 0.795426),
(38778, 3, 5, 140, 0.927997),
(38779, 4, 5, 31, 1.31123),
(38780, 5, 5, 267, 1.69691),
(38781, 6, 5, 190, 1.69691),
(38782, 7, 5, 107, 2.19333),
(38783, 8, 5, 202, 1.53782),
(38784, 9, 5, 10, 0.381448),
(38785, 10, 5, 106, 1.74994),
(38786, 11, 5, 80, 0.810577),
(38787, 12, 5, 733, 1.24617),
(38788, 13, 5, 182, 0.662855),
(38789, 14, 5, 163, 1.08708),
(38790, 15, 5, 205, 0.742397),
(38791, 16, 5, 187, 1.51131),
(38792, 17, 5, 30, 5.17027),
(38793, 18, 5, 957, 0.0715215),
(38794, 19, 5, 56, 3.49987),
(38795, 20, 5, 665, 0.212114),
(38796, 21, 5, 3, 28.6086),
(38797, 22, 5, 346, 0.742397),
(38798, 23, 5, 389, 1.14011),
(38799, 24, 5, 28, 0.596012),
(38800, 25, 5, 338, 2.70445),
(38801, 26, 5, 34, 7.37094),
(38802, 27, 5, 91, 2.16948),
(38803, 28, 5, 133, 1.0013),
(38804, 29, 5, 349, 1.06057),
(38805, 30, 5, 19, 3.49987),
(38806, 31, 5, 14, 4.55353),
(38807, 32, 5, 236, 0.954511),
(38808, 33, 5, 1, 2.73096),
(38809, 34, 5, 7, 0.31817),
(38810, 35, 5, 2, 3.1817),
(38811, 36, 5, 1, 7.95426),
(38812, 37, 5, 36, 2.65142),
(38813, 38, 5, 2, 5.2233),
(38814, 39, 5, 2, 2.65142),
(38815, 40, 5, 2, 0.901482),
(38816, 41, 5, 2, 5.30284),
(38817, 42, 5, 33, 2.94308),
(38818, 43, 5, 16, 1.72342),
(38819, 44, 5, 4, 0.954511),
(38820, 45, 5, 6, 1.72342),
(38821, 46, 5, 1, 0.768911),
(38822, 47, 5, 15, 0.477255),
(38823, 48, 5, 3, 1.2992),
(38824, 49, 5, 25, 0.357607),
(38825, 50, 5, 33, 2.91656),
(38826, 1, 6, 13, 0.424227),
(38827, 2, 6, 29, 0.795426),
(38828, 3, 6, 141, 0.927997),
(38829, 4, 6, 31, 1.31123),
(38830, 5, 6, 363, 1.69691),
(38831, 6, 6, 190, 1.69691),
(38832, 7, 6, 106, 2.19333),
(38833, 8, 6, 205, 1.53782),
(38834, 9, 6, 15, 0.381448),
(38835, 10, 6, 142, 1.74994),
(38836, 11, 6, 80, 0.810577),
(38837, 12, 6, 718, 1.24617),
(38838, 13, 6, 178, 0.662855),
(38839, 14, 6, 156, 1.08708),
(38840, 15, 6, 148, 0.742397),
(38841, 16, 6, 185, 1.51131),
(38842, 17, 6, 30, 5.17027),
(38843, 18, 6, 1057, 0.0715215),
(38844, 19, 6, 45, 3.49987),
(38845, 20, 6, 602, 0.212114),
(38846, 21, 6, 4, 28.6086),
(38847, 22, 6, 344, 0.742397),
(38848, 23, 6, 369, 1.14011),
(38849, 24, 6, 28, 0.596012),
(38850, 25, 6, 343, 2.70445),
(38851, 26, 6, 33, 7.37094),
(38852, 27, 6, 95, 2.16948),
(38853, 28, 6, 133, 1.0013),
(38854, 29, 6, 354, 1.06057),
(38855, 30, 6, 20, 3.49987),
(38856, 31, 6, 14, 4.55353),
(38857, 32, 6, 362, 0.954511),
(38858, 33, 6, 2, 2.73096),
(38859, 34, 6, 6, 0.31817),
(38860, 35, 6, 2, 3.1817),
(38861, 36, 6, 1, 7.95426),
(38862, 37, 6, 36, 2.65142),
(38863, 38, 6, 2, 5.2233),
(38864, 39, 6, 2, 2.65142),
(38865, 40, 6, 2, 0.901482),
(38866, 41, 6, 2, 5.30284),
(38867, 42, 6, 18, 2.94308),
(38868, 43, 6, 21, 1.72342),
(38869, 44, 6, 4, 0.954511),
(38870, 45, 6, 3, 1.72342),
(38871, 46, 6, 1, 0.768911),
(38872, 47, 6, 15, 0.477255),
(38873, 48, 6, 3, 1.2992),
(38874, 49, 6, 39, 0.357607),
(38875, 50, 6, 33, 2.91656),
(38876, 1, 7, 21, 0.424227),
(38877, 2, 7, 28, 0.795426),
(38878, 3, 7, 145, 0.927997),
(38879, 4, 7, 119, 1.31123),
(38880, 5, 7, 447, 1.69691),
(38881, 6, 7, 125, 1.69691),
(38882, 7, 7, 51, 2.19333),
(38883, 8, 7, 222, 1.53782),
(38884, 9, 7, 31, 0.381448),
(38885, 10, 7, 83, 1.74994),
(38886, 11, 7, 226, 0.810577),
(38887, 12, 7, 627, 1.24617),
(38888, 13, 7, 241, 0.662855),
(38889, 14, 7, 143, 1.08708),
(38890, 15, 7, 180, 0.742397),
(38891, 16, 7, 207, 1.51131),
(38892, 17, 7, 39, 5.17027),
(38893, 18, 7, 2465, 0.0715215),
(38894, 19, 7, 14, 3.49987),
(38895, 20, 7, 1004, 0.212114),
(38896, 21, 7, 2, 28.6086),
(38897, 22, 7, 223, 0.742397),
(38898, 23, 7, 224, 1.14011),
(38899, 24, 7, 31, 0.596012),
(38900, 25, 7, 147, 2.70445),
(38901, 26, 7, 37, 7.37094),
(38902, 27, 7, 59, 2.16948),
(38903, 28, 7, 207, 1.0013),
(38904, 29, 7, 127, 1.06057),
(38905, 30, 7, 64, 3.49987),
(38906, 31, 7, 7, 4.55353),
(38907, 32, 7, 193, 0.954511),
(38908, 33, 7, 2, 2.73096),
(38909, 34, 7, 6, 0.31817),
(38910, 35, 7, 2, 3.1817),
(38911, 36, 7, 3, 7.95426),
(38912, 37, 7, 14, 2.65142),
(38913, 38, 7, 2, 5.2233),
(38914, 39, 7, 4, 2.65142),
(38915, 40, 7, 2, 0.901482),
(38916, 41, 7, 3, 5.30284),
(38917, 42, 7, 29, 2.94308),
(38918, 43, 7, 28, 1.72342),
(38919, 44, 7, 2, 0.954511),
(38920, 45, 7, 5, 1.72342),
(38921, 46, 7, 3, 0.768911),
(38922, 47, 7, 14, 0.477255),
(38923, 48, 7, 3, 1.2992),
(38924, 49, 7, 48, 0.357607),
(38925, 50, 7, 28, 2.91656),
(38926, 1, 8, 21, 0.424227),
(38927, 2, 8, 28, 0.795426),
(38928, 3, 8, 158, 0.927997),
(38929, 4, 8, 118, 1.31123),
(38930, 5, 8, 432, 1.69691),
(38931, 6, 8, 130, 1.69691),
(38932, 7, 8, 51, 2.19333),
(38933, 8, 8, 222, 1.53782),
(38934, 9, 8, 31, 0.381448),
(38935, 10, 8, 77, 1.74994),
(38936, 11, 8, 168, 0.810577),
(38937, 12, 8, 301, 1.24617),
(38938, 13, 8, 240, 0.662855),
(38939, 14, 8, 172, 1.08708),
(38940, 15, 8, 159, 0.742397),
(38941, 16, 8, 205, 1.51131),
(38942, 17, 8, 37, 5.17027),
(38943, 18, 8, 2470, 0.0715215),
(38944, 19, 8, 17, 3.49987),
(38945, 20, 8, 1024, 0.212114),
(38946, 21, 8, 2, 28.6086),
(38947, 22, 8, 224, 0.742397),
(38948, 23, 8, 228, 1.14011),
(38949, 24, 8, 30, 0.596012),
(38950, 25, 8, 151, 2.70445),
(38951, 26, 8, 37, 7.37094),
(38952, 27, 8, 57, 2.16948),
(38953, 28, 8, 201, 1.0013),
(38954, 29, 8, 338, 1.06057),
(38955, 30, 8, 55, 3.49987),
(38956, 31, 8, 8, 4.55353),
(38957, 32, 8, 198, 0.954511),
(38958, 33, 8, 2, 2.73096),
(38959, 34, 8, 6, 0.31817),
(38960, 35, 8, 2, 3.1817),
(38961, 36, 8, 3, 7.95426),
(38962, 37, 8, 14, 2.65142),
(38963, 38, 8, 2, 5.2233),
(38964, 39, 8, 4, 2.65142),
(38965, 40, 8, 2, 0.901482),
(38966, 41, 8, 3, 5.30284),
(38967, 42, 8, 25, 2.94308),
(38968, 43, 8, 27, 1.72342),
(38969, 44, 8, 2, 0.954511),
(38970, 45, 8, 3, 1.72342),
(38971, 46, 8, 3, 0.768911),
(38972, 47, 8, 14, 0.477255),
(38973, 48, 8, 4, 1.2992),
(38974, 49, 8, 46, 0.357607),
(38975, 50, 8, 28, 2.91656),
(38976, 1, 9, 16, 0.424227),
(38977, 2, 9, 28, 0.795426),
(38978, 3, 9, 158, 0.927997),
(38979, 4, 9, 119, 1.31123),
(38980, 5, 9, 399, 1.69691),
(38981, 6, 9, 126, 1.69691),
(38982, 7, 9, 49, 2.19333),
(38983, 8, 9, 229, 1.53782),
(38984, 9, 9, 36, 0.381448),
(38985, 10, 9, 104, 1.74994),
(38986, 11, 9, 169, 0.810577),
(38987, 12, 9, 596, 1.24617),
(38988, 13, 9, 205, 0.662855),
(38989, 14, 9, 135, 1.08708),
(38990, 15, 9, 179, 0.742397),
(38991, 16, 9, 213, 1.51131),
(38992, 17, 9, 38, 5.17027),
(38993, 18, 9, 2395, 0.0715215),
(38994, 19, 9, 13, 3.49987),
(38995, 20, 9, 1264, 0.212114),
(38996, 21, 9, 2, 28.6086),
(38997, 22, 9, 211, 0.742397),
(38998, 23, 9, 219, 1.14011),
(38999, 24, 9, 36, 0.596012),
(39000, 25, 9, 130, 2.70445),
(39001, 26, 9, 37, 7.37094),
(39002, 27, 9, 45, 2.16948),
(39003, 28, 9, 201, 1.0013),
(39004, 29, 9, 110, 1.06057),
(39005, 30, 9, 62, 3.49987),
(39006, 31, 9, 8, 4.55353),
(39007, 32, 9, 175, 0.954511),
(39008, 33, 9, 2, 2.73096),
(39009, 34, 9, 6, 0.31817),
(39010, 35, 9, 2, 3.1817),
(39011, 36, 9, 3, 7.95426),
(39012, 37, 9, 13, 2.65142),
(39013, 38, 9, 2, 5.2233),
(39014, 39, 9, 4, 2.65142),
(39015, 40, 9, 2, 0.901482),
(39016, 41, 9, 1, 5.30284),
(39017, 42, 9, 25, 2.94308),
(39018, 43, 9, 28, 1.72342),
(39019, 44, 9, 2, 0.954511),
(39020, 45, 9, 5, 1.72342),
(39021, 46, 9, 3, 0.768911),
(39022, 47, 9, 13, 0.477255),
(39023, 48, 9, 3, 1.2992),
(39024, 49, 9, 45, 0.357607),
(39025, 50, 9, 31, 2.91656),
(39026, 1, 10, 19, 0.424227),
(39027, 2, 10, 28, 0.795426),
(39028, 3, 10, 158, 0.927997),
(39029, 4, 10, 46, 1.31123),
(39030, 5, 10, 250, 1.69691),
(39031, 6, 10, 194, 1.69691),
(39032, 7, 10, 50, 2.19333),
(39033, 8, 10, 208, 1.53782),
(39034, 9, 10, 32, 0.381448),
(39035, 10, 10, 152, 1.74994),
(39036, 11, 10, 171, 0.810577),
(39037, 12, 10, 627, 1.24617),
(39038, 13, 10, 193, 0.662855),
(39039, 14, 10, 142, 1.08708),
(39040, 15, 10, 175, 0.742397),
(39041, 16, 10, 219, 1.51131),
(39042, 17, 10, 39, 5.17027),
(39043, 18, 10, 2273, 0.0715215),
(39044, 19, 10, 14, 3.49987),
(39045, 20, 10, 1075, 0.212114),
(39046, 21, 10, 2, 28.6086),
(39047, 22, 10, 228, 0.742397),
(39048, 23, 10, 233, 1.14011),
(39049, 24, 10, 31, 0.596012),
(39050, 25, 10, 148, 2.70445),
(39051, 26, 10, 37, 7.37094),
(39052, 27, 10, 60, 2.16948),
(39053, 28, 10, 208, 1.0013),
(39054, 29, 10, 119, 1.06057),
(39055, 30, 10, 62, 3.49987),
(39056, 31, 10, 8, 4.55353),
(39057, 32, 10, 204, 0.954511),
(39058, 33, 10, 2, 2.73096),
(39059, 34, 10, 6, 0.31817),
(39060, 35, 10, 2, 3.1817),
(39061, 36, 10, 3, 7.95426),
(39062, 37, 10, 13, 2.65142),
(39063, 38, 10, 2, 5.2233),
(39064, 39, 10, 4, 2.65142),
(39065, 40, 10, 2, 0.901482),
(39066, 41, 10, 1, 5.30284),
(39067, 42, 10, 29, 2.94308),
(39068, 43, 10, 29, 1.72342),
(39069, 44, 10, 2, 0.954511),
(39070, 45, 10, 5, 1.72342),
(39071, 46, 10, 3, 0.768911),
(39072, 47, 10, 18, 0.477255),
(39073, 48, 10, 3, 1.2992),
(39074, 49, 10, 45, 0.357607),
(39075, 50, 10, 28, 2.91656);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `t_verkaufszahlen`
--
CREATE TABLE `t_verkaufszahlen` (
`ID` int(11) NOT NULL,
`f_Artikel_ID` int(11) NOT NULL,
`Woche` int(11) NOT NULL,
`Menge` int(11) NOT NULL,
`Verkaufspreis` float NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Daten für Tabelle `t_verkaufszahlen`
--
INSERT INTO `t_verkaufszahlen` (`ID`, `f_Artikel_ID`, `Woche`, `Menge`, `Verkaufspreis`) VALUES
(1, 1, 1, 5, 0.424227),
(2, 2, 1, 31, 0.795426),
(3, 3, 1, 143, 0.927997),
(4, 4, 1, 31, 1.31123),
(5, 5, 1, 382, 1.69691),
(6, 6, 1, 188, 1.69691),
(7, 7, 1, 107, 2.19333),
(8, 8, 1, 197, 1.53782),
(9, 9, 1, 15, 0.381448),
(10, 10, 1, 102, 1.74994),
(11, 11, 1, 81, 0.810577),
(12, 12, 1, 744, 1.24617),
(13, 13, 1, 203, 0.662855),
(14, 14, 1, 166, 1.08708),
(15, 15, 1, 209, 0.742397),
(16, 16, 1, 189, 1.51131),
(17, 17, 1, 30, 5.17027),
(18, 18, 1, 1159, 0.0715215),
(19, 19, 1, 52, 3.49987),
(20, 20, 1, 665, 0.212114),
(21, 21, 1, 3, 28.6086),