Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --
- -- Tabellenstruktur für Tabelle `mm_pim_depots`
- --
- CREATE TABLE IF NOT EXISTS `mm_pim_depots` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `pid` int(10) unsigned NOT NULL,
- `sorting` int(10) unsigned NOT NULL DEFAULT '0',
- `tstamp` int(10) unsigned NOT NULL DEFAULT '0',
- `name` varchar(255) NOT NULL DEFAULT '',
- `alias` varchar(255) NOT NULL DEFAULT '',
- `depotnr` int(10) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
- --
- -- Daten für Tabelle `mm_pim_depots`
- --
- INSERT INTO `mm_pim_depots` (`id`, `pid`, `sorting`, `tstamp`, `name`, `alias`, `depotnr`) VALUES
- (1, 0, 0, 0, 'Wien-Landstraße', 'wien-landstrasse', 3),
- (2, 0, 0, 0, 'Salzburg', 'salzburg', 81),
- (3, 0, 0, 0, 'Graz', 'graz', 82),
- (4, 0, 0, 0, 'Telfs', 'telfs', 86);
- --
- -- Tabellenstruktur für Tabelle `mm_pim_lagerdaten`
- --
- CREATE TABLE IF NOT EXISTS `mm_pim_lagerdaten` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `pid` int(10) unsigned NOT NULL,
- `sorting` int(10) unsigned NOT NULL DEFAULT '0',
- `tstamp` int(10) unsigned NOT NULL DEFAULT '0',
- `artikelnummer` int(10) DEFAULT NULL,
- `var` int(10) DEFAULT NULL,
- `meldebestand` int(10) DEFAULT NULL,
- `depot` int(10) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7738 ;
- --
- -- Daten für Tabelle `mm_pim_lagerdaten`
- --
- INSERT INTO `mm_pim_lagerdaten` (`id`, `pid`, `sorting`, `tstamp`, `artikelnummer`, `var`, `meldebestand`, `depot`) VALUES
- (1, 0, 0, 1425285744, 9700013, 0, 1980, 82),
- (2, 0, 0, 1425285744, 901008, 0, 1500, 3),
- (3, 0, 0, 1425285744, 44022, 0, 1080, 82),
- (4, 0, 0, 1425285744, 48022, 0, 1080, 82),
- (5, 0, 0, 1425285744, 360008, 0, 1000, 3),
- (6, 0, 0, 1425285744, 561008, 0, 1000, 3),
- (7, 0, 0, 1425285744, 9010000, 0, 1000, 3),
- (8, 0, 0, 1425285744, 48010, 0, 840, 82),
- (9, 0, 0, 1425285744, 901055, 0, 800, 3),
- (10, 0, 0, 1425285744, 9010018, 0, 800, 3),
- (11, 0, 0, 1425285744, 9700009, 0, 792, 82),
- (12, 0, 0, 1425285744, 901062, 998, 720, 3),
- (13, 0, 0, 1425285744, 59022, 0, 648, 82),
- (14, 0, 0, 1425285744, 2102022, 0, 648, 82),
- (15, 0, 0, 1425285744, 2115022, 0, 648, 82),
- (16, 0, 0, 1425285744, 901050, 0, 640, 3),
- (17, 0, 0, 1425285744, 9700009, 0, 603, 3),
- (18, 0, 0, 1425285744, 44010, 0, 588, 82),
- (19, 0, 0, 1425285744, 9700007, 0, 576, 82),
- (20, 0, 0, 1425285744, 9700253, 0, 560, 82),
- (21, 0, 0, 1425285744, 901009, 0, 510, 3),
- (22, 0, 0, 1425285744, 981008, 0, 500, 3),
- (23, 0, 0, 1425285744, 8370015, 0, 500, 86),
- (24, 0, 0, 1425285744, 8370016, 0, 500, 86),
- (25, 0, 0, 1425285744, 9010002, 0, 500, 3),
- (26, 0, 0, 1425285744, 9010009, 0, 500, 3),
- (27, 0, 0, 1425285744, 9102803, 0, 500, 3),
- (28, 0, 0, 1425285744, 9903055, 0, 500, 3),
- (29, 0, 0, 1425285744, 44016, 0, 480, 82),
- (30, 0, 0, 1425285744, 48016, 0, 480, 82),
- (31, 0, 0, 1425285744, 48190, 0, 480, 82)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement