Guest User

Untitled

a guest
Mar 4th, 2015
218
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. --
  2. -- Tabellenstruktur für Tabelle `mm_pim_depots`
  3. --
  4.  
  5. CREATE TABLE IF NOT EXISTS `mm_pim_depots` (
  6.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  7.   `pid` int(10) unsigned NOT NULL,
  8.   `sorting` int(10) unsigned NOT NULL DEFAULT '0',
  9.   `tstamp` int(10) unsigned NOT NULL DEFAULT '0',
  10.   `name` varchar(255) NOT NULL DEFAULT '',
  11.   `alias` varchar(255) NOT NULL DEFAULT '',
  12.   `depotnr` int(10) DEFAULT NULL,
  13.   PRIMARY KEY (`id`)
  14. ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
  15.  
  16. --
  17. -- Daten für Tabelle `mm_pim_depots`
  18. --
  19.  
  20. INSERT INTO `mm_pim_depots` (`id`, `pid`, `sorting`, `tstamp`, `name`, `alias`, `depotnr`) VALUES
  21. (1, 0, 0, 0, 'Wien-Landstraße', 'wien-landstrasse', 3),
  22. (2, 0, 0, 0, 'Salzburg', 'salzburg', 81),
  23. (3, 0, 0, 0, 'Graz', 'graz', 82),
  24. (4, 0, 0, 0, 'Telfs', 'telfs', 86);
  25.  
  26.  
  27. --
  28. -- Tabellenstruktur für Tabelle `mm_pim_lagerdaten`
  29. --
  30.  
  31. CREATE TABLE IF NOT EXISTS `mm_pim_lagerdaten` (
  32.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  33.   `pid` int(10) unsigned NOT NULL,
  34.   `sorting` int(10) unsigned NOT NULL DEFAULT '0',
  35.   `tstamp` int(10) unsigned NOT NULL DEFAULT '0',
  36.   `artikelnummer` int(10) DEFAULT NULL,
  37.   `var` int(10) DEFAULT NULL,
  38.   `meldebestand` int(10) DEFAULT NULL,
  39.   `depot` int(10) DEFAULT NULL,
  40.   PRIMARY KEY (`id`)
  41. ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7738 ;
  42.  
  43. --
  44. -- Daten für Tabelle `mm_pim_lagerdaten`
  45. --
  46.  
  47. INSERT INTO `mm_pim_lagerdaten` (`id`, `pid`, `sorting`, `tstamp`, `artikelnummer`, `var`, `meldebestand`, `depot`) VALUES
  48. (1, 0, 0, 1425285744, 9700013, 0, 1980, 82),
  49. (2, 0, 0, 1425285744, 901008, 0, 1500, 3),
  50. (3, 0, 0, 1425285744, 44022, 0, 1080, 82),
  51. (4, 0, 0, 1425285744, 48022, 0, 1080, 82),
  52. (5, 0, 0, 1425285744, 360008, 0, 1000, 3),
  53. (6, 0, 0, 1425285744, 561008, 0, 1000, 3),
  54. (7, 0, 0, 1425285744, 9010000, 0, 1000, 3),
  55. (8, 0, 0, 1425285744, 48010, 0, 840, 82),
  56. (9, 0, 0, 1425285744, 901055, 0, 800, 3),
  57. (10, 0, 0, 1425285744, 9010018, 0, 800, 3),
  58. (11, 0, 0, 1425285744, 9700009, 0, 792, 82),
  59. (12, 0, 0, 1425285744, 901062, 998, 720, 3),
  60. (13, 0, 0, 1425285744, 59022, 0, 648, 82),
  61. (14, 0, 0, 1425285744, 2102022, 0, 648, 82),
  62. (15, 0, 0, 1425285744, 2115022, 0, 648, 82),
  63. (16, 0, 0, 1425285744, 901050, 0, 640, 3),
  64. (17, 0, 0, 1425285744, 9700009, 0, 603, 3),
  65. (18, 0, 0, 1425285744, 44010, 0, 588, 82),
  66. (19, 0, 0, 1425285744, 9700007, 0, 576, 82),
  67. (20, 0, 0, 1425285744, 9700253, 0, 560, 82),
  68. (21, 0, 0, 1425285744, 901009, 0, 510, 3),
  69. (22, 0, 0, 1425285744, 981008, 0, 500, 3),
  70. (23, 0, 0, 1425285744, 8370015, 0, 500, 86),
  71. (24, 0, 0, 1425285744, 8370016, 0, 500, 86),
  72. (25, 0, 0, 1425285744, 9010002, 0, 500, 3),
  73. (26, 0, 0, 1425285744, 9010009, 0, 500, 3),
  74. (27, 0, 0, 1425285744, 9102803, 0, 500, 3),
  75. (28, 0, 0, 1425285744, 9903055, 0, 500, 3),
  76. (29, 0, 0, 1425285744, 44016, 0, 480, 82),
  77. (30, 0, 0, 1425285744, 48016, 0, 480, 82),
  78. (31, 0, 0, 1425285744, 48190, 0, 480, 82)
RAW Paste Data