-- https://www.phpmyadmin.net/
--
-- Erstellungszeit: 30. Okt 2021 um 15:10
-- Server-Version: 10.4.21-MariaDB
-- PHP-Version: 8.0.10

START TRANSACTION;



--
-- Datenbank: `qb`
--

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `qbbasic`
--

CREATE TABLE `qbbasic` (
  `IDX` int(11) NOT NULL,
  `QBN` varchar(10) NOT NULL,
  `REQ` varchar(50) NOT NULL,
  `SHOWREQ` int(11) NOT NULL DEFAULT 1,
  `REQINFO` varchar(50) NOT NULL,
  `MNR` varchar(50) NOT NULL,
  `MSTAT` varchar(2) NOT NULL DEFAULT 'NA',
  `SUPPLIER` varchar(50) NOT NULL,
  `DESCRIPTION` text NOT NULL,
  `CUSTOMER` varchar(100) NOT NULL,
  `SALESORG` varchar(5) NOT NULL,
  `LFS_NR` varchar(50) NOT NULL,
  `DEL_COUNT` int(11) NOT NULL,
  `TEST_COUNT` int(11) NOT NULL,
  `TEST_FAIL` int(11) NOT NULL,
  `CRITERIUM` varchar(1) NOT NULL,
  `PROD_DAT` date NOT NULL,
  `PROD_NR` varchar(100) NOT NULL,
  `BEST` varchar(20) NOT NULL,
  `REPREQ` varchar(1) NOT NULL DEFAULT 'N',
  `CLOSEMAIL` int(11) NOT NULL DEFAULT 0,
  `ACT` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `qbbasic_files`
--

CREATE TABLE `qbbasic_files` (
  `IDX` int(11) NOT NULL,
  `QBN` varchar(20) NOT NULL,
  `LINK` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `qbi`
--

CREATE TABLE `qbi` (
  `IDX` int(11) NOT NULL,
  `QBI` int(11) NOT NULL,
  `QBY` int(11) NOT NULL,
  `QBN` varchar(10) NOT NULL,
  `QBDATE` date NOT NULL,
  `QBREGDATE` date NOT NULL,
  `QBSTATUS` varchar(1) NOT NULL DEFAULT 'N' COMMENT 'N=new, O=open, S=solved, C=closed',
  `SVT` varchar(50) NOT NULL,
  `DELEGATE` varchar(50) NOT NULL DEFAULT '0',
  `BB` varchar(2) NOT NULL,
  `CC` varchar(2) NOT NULL,
  `DDDD` varchar(4) NOT NULL,
  `LIGHT` int(11) NOT NULL,
  `TOP` int(11) NOT NULL,
  `RTYPE` varchar(1) NOT NULL COMMENT 'QB criterium',
  `SVTI` datetime NOT NULL,
  `IC` int(11) NOT NULL DEFAULT 0,
  `TRACK` int(11) NOT NULL DEFAULT 0,
  `TRACKCOM` text NOT NULL,
  `LAST` datetime NOT NULL,
  `RATING` int(11) NOT NULL,
  `CLSS` varchar(1) NOT NULL,
  `ACT` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `qb_8d`
--

CREATE TABLE `qb_8d` (
  `IDX` int(11) NOT NULL,
  `QBN` varchar(10) NOT NULL,
  `8D_LINK` text NOT NULL,
  `8D_DATE` date NOT NULL,
  `TPE` varchar(1) NOT NULL DEFAULT 'F'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `qb_ccode`
--

CREATE TABLE `qb_ccode` (
  `IDX` int(11) NOT NULL,
  `CODE` varchar(5) NOT NULL,
  `COUNTRY` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Daten für Tabelle `qb_ccode`
--

INSERT INTO `qb_ccode` (`IDX`, `CODE`, `COUNTRY`) VALUES
(2, 'AF', 'Afghanistan'),
(3, 'AL', 'Albania'),
(4, 'DZ', 'Algeria'),
(5, 'AD', 'Andorra'),
(6, 'AO', 'Angola'),
(7, 'AG', 'Antigua and Barbuda'),
(8, 'AR', 'Argentina'),
(9, 'AM', 'Armenia'),
(10, 'AW', 'Aruba'),
(11, 'AU', 'Australia'),
(12, 'AT', 'Austria'),
(13, 'AZ', 'Azerbaijan'),
(14, 'BS', 'Bahamas'),
(15, 'BH', 'Bahrain'),
(16, 'BD', 'Bangladesh'),
(17, 'BB', 'Barbados'),
(18, 'BY', 'Belarus'),
(19, 'BE', 'Belgium'),
(20, 'BZ', 'Belize'),
(21, 'BJ', 'Benin'),
(22, 'BM', 'Bermuda'),
(23, 'BT', 'Bhutan'),
(24, 'BO', 'Bolivia'),
(25, 'BA', 'Bosnia-Herzegovina'),
(26, 'BW', 'Botswana'),
(27, 'BR', 'Brazil'),
(28, 'VG', 'British Virgin Islands'),
(29, 'BN', 'Brunei'),
(30, 'BG', 'Bulgaria'),
(31, 'BF', 'Burkina Faso'),
(32, 'BI', 'Burundi'),
(33, 'KH', 'Cambodia'),
(34, 'CM', 'Cameroon'),
(35, 'CA', 'Canada'),
(36, 'CV', 'Cape Verde'),
(37, 'KY', 'Cayman Islands'),
(38, 'CF', 'Central African Republic'),
(39, 'TD', 'Chad'),
(40, 'CL', 'Chile'),
(41, 'CN', 'China'),
(42, 'CO', 'Colombia'),
(43, 'KM', 'Comoros'),
(44, 'CG', 'Congo (Brazzaville)'),
(45, 'CD', 'Congo (Democratic Rep.)'),
(46, 'CR', 'Costa Rica'),
(47, 'CI', 'Cote d\'Ivoire'),
(48, 'HR', 'Croatia'),
(49, 'CU', 'Cuba'),
(50, 'CY', 'Cyprus'),
(51, 'CZ', 'Czech Republic'),
(52, 'DK', 'Denmark'),
(53, 'DJ', 'Djibouti'),
(54, 'DM', 'Dominica'),
(55, 'DO', 'Dominican Republic'),
(56, 'EC', 'Ecuador'),
(57, 'EG', 'Egypt'),
(58, 'SV', 'El Salvador'),
(59, 'GQ', 'Equatorial Guinea'),
(60, 'ER', 'Eritrea'),
(61, 'EE', 'Estonia'),
(62, 'ET', 'Ethiopia'),
(63, 'FK', 'Falkland Islands'),
(64, 'FO', 'Faroe Islands'),
(65, 'FJ', 'Fiji'),
(66, 'FI', 'Finland'),
(67, 'FR', 'France'),
(68, 'GF', 'French Guiana'),
(69, 'PF', 'French Polynesia'),
(70, 'GA', 'Gabon'),
(71, 'GM', 'Gambia'),
(72, 'GE', 'Georgia'),
(73, 'DE', 'Germany'),
(74, 'GH', 'Ghana'),
(75, 'GI', 'Gibraltar'),
(76, 'GR', 'Greece'),
(77, 'GL', 'Greenland'),
(78, 'GD', 'Grenada'),
(79, 'GP', 'Guadeloupe'),
(80, 'GT', 'Guatemala'),
(81, 'GG', 'Guernsey'),
(82, 'GN', 'Guinea'),
(83, 'GW', 'Guinea-Bissau'),
(84, 'GY', 'Guyana'),
(85, 'HT', 'Haiti'),
(86, 'HN', 'Honduras'),
(87, 'HK', 'Hong Kong'),
(88, 'HU', 'Hungary'),
(89, 'IS', 'Iceland'),
(90, 'IN', 'India'),
(91, 'ID', 'Indonesia'),
(92, 'IR', 'Iran'),
(93, 'IQ', 'Iraq'),
(94, 'IE', 'Ireland'),
(95, 'IM', 'Isle of Man'),
(96, 'IL', 'Israel'),
(97, 'IT', 'Italy'),
(98, 'JM', 'Jamaica'),
(99, 'JP', 'Japan'),
(100, 'JE', 'Jersey'),
(101, 'JO', 'Jordan'),
(102, 'KZ', 'Kazakhstan'),
(103, 'KE', 'Kenya'),
(104, 'KI', 'Kiribati'),
(105, 'KV', 'Kosovo'),
(106, 'KW', 'Kuwait'),
(107, 'KG', 'Kyrgyzstan'),
(108, 'LA', 'Laos'),
(109, 'LV', 'Latvia'),
(110, 'LB', 'Lebanon'),
(111, 'LS', 'Lesotho'),
(112, 'LR', 'Liberia'),
(113, 'LY', 'Libya'),
(114, 'LI', 'Liechtenstein'),
(115, 'LT', 'Lithuania'),
(116, 'LU', 'Luxembourg'),
(117, 'MO', 'Macau'),
(118, 'MK', 'Macedonia'),
(119, 'MG', 'Madagascar'),
(120, 'MW', 'Malawi'),
(121, 'MY', 'Malaysia'),
(122, 'MV', 'Maldives'),
(123, 'ML', 'Mali'),
(124, 'MT', 'Malta'),
(125, 'MH', 'Marshall Islands'),
(126, 'MQ', 'Martinique'),
(127, 'MR', 'Mauritania'),
(128, 'MU', 'Mauritius'),
(129, 'YT', 'Mayotte'),
(130, 'MX', 'Mexico'),
(131, 'FM', 'Micronesia'),
(132, 'MD', 'Moldova'),
(133, 'MC', 'Monaco'),
(134, 'MN', 'Mongolia'),
(135, 'ME', 'Montenegro'),
(136, 'MA', 'Morocco'),
(137, 'MZ', 'Mozambique'),
(138, 'MM', 'Myanmar'),
(139, 'NA', 'Namibia'),
(140, 'NR', 'Nauru'),
(141, 'NP', 'Nepal'),
(142, 'NL', 'Netherlands'),
(143, 'NC', 'New Caledonia'),
(144, 'NZ', 'New Zealand'),
(145, 'NI', 'Nicaragua'),
(146, 'NE', 'Niger'),
(147, 'NG', 'Nigeria'),
(148, 'KP', 'North Korea'),
(149, 'NO', 'Norway'),
(150, 'OM', 'Oman'),
(151, 'PK', 'Pakistan'),
(152, 'PW', 'Palau'),
(153, 'PA', 'Panama'),
(154, 'PG', 'Papua New Guinea'),
(155, 'PY', 'Paraguay'),
(156, 'PE', 'Peru'),
(157, 'PH', 'Philippines'),
(158, 'PL', 'Poland'),
(159, 'PT', 'Portugal'),
(160, 'PR', 'Puerto Rico'),
(161, 'QA', 'Qatar'),
(162, 'RE', 'Reunion'),
(163, 'RO', 'Romania'),
(164, 'RU', 'Russia'),
(165, 'RW', 'Rwanda'),
(166, 'BL', 'Saint Barthelemy'),
(167, 'KN', 'Saint Kitts and Nevis'),
(168, 'LC', 'Saint Lucia'),
(169, 'MF', 'Saint Martin'),
(170, 'PM', 'Saint Pierre and Miquelon'),
(171, 'VC', 'Saint Vincent and the Grenadines'),
(172, 'WS', 'Samoa'),
(173, 'SM', 'San Marino'),
(174, 'ST', 'Sao Tome and Principe'),
(175, 'SA', 'Saudi Arabia'),
(176, 'SN', 'Senegal'),
(177, 'RS', 'Serbia'),
(178, 'SC', 'Seychelles'),
(179, 'SL', 'Sierra Leone'),
(180, 'SG', 'Singapore'),
(181, 'SK', 'Slovakia'),
(182, 'SI', 'Slovenia'),
(183, 'SB', 'Solomon Islands'),
(184, 'SO', 'Somalia'),
(185, 'ZA', 'South Africa'),
(186, 'KR', 'South Korea'),
(187, 'SS', 'South Sudan'),
(188, 'ES', 'Spain'),
(189, 'LK', 'Sri Lanka'),
(190, 'SD', 'Sudan'),
(191, 'SR', 'Suriname'),
(192, 'SJ', 'Svalbard'),
(193, 'SZ', 'Swaziland'),
(194, 'SE', 'Sweden'),
(195, 'CH', 'Switzerland'),
(196, 'SY', 'Syria'),
(197, 'TW', 'Taiwan'),
(198, 'TJ', 'Tajikistan'),
(199, 'TZ', 'Tanzania'),
(200, 'TH', 'Thailand'),
(201, 'TL', 'Timor-Leste'),
(202, 'TG', 'Togo'),
(203, 'TO', 'Tonga'),
(204, 'TT', 'Trinidad and Tobago'),
(205, 'TN', 'Tunisia'),
(206, 'TR', 'Turkey'),
(207, 'TM', 'Turkmenistan'),
(208, 'TC', 'Turks and Caicos'),
(209, 'TV', 'Tuvalu'),
(210, 'UG', 'Uganda'),
(211, 'UA', 'Ukraine'),
(212, 'AE', 'United Arab Emirates'),
(213, 'GB', 'United Kingdom'),
(214, 'US', 'United States'),
(215, 'UY', 'Uruguay'),
(216, 'UZ', 'Uzbekistan'),
(217, 'VU', 'Vanuatu'),
(218, 'VA', 'Vatican City'),
(219, 'VE', 'Venezuela'),
(220, 'VN', 'Vietnam'),
(221, 'WF', 'Wallis et Futuna'),
(222, 'EH', 'Western Sahara'),
(223, 'YE', 'Yemen'),
(224, 'ZM', 'Zambia'),
(225, 'ZW', 'Zimbabwe');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `qb_close`
--

CREATE TABLE `qb_close` (
  `IDX` int(11) NOT NULL,
  `QBN` varchar(20) NOT NULL,
  `FU` text NOT NULL,
  `VB` text NOT NULL,
  `LAF` text NOT NULL,
  `FFU` varchar(20) NOT NULL,
  `ST_DATE` date NOT NULL,
  `VG_DATE` date NOT NULL,
  `CL_DATE` date NOT NULL,
  `GQ_DATE` date NOT NULL,
  `PROCESS` int(11) NOT NULL,
  `INFO` date NOT NULL,
  `CLOSEDBY` varchar(50) NOT NULL,
  `CSTATUS` int(11) NOT NULL,
  `REJTEAM` int(11) NOT NULL,
  `REJSVT` int(11) NOT NULL,
  `REJGQ` int(11) NOT NULL,
  `OVERRULED` text NOT NULL,
  `ACT` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `qb_close_rej`
--

CREATE TABLE `qb_close_rej` (
  `IDX` int(11) NOT NULL,
  `QBN` varchar(20) NOT NULL,
  `REJLOGIN` varchar(50) NOT NULL,
  `REJDATE` datetime NOT NULL,
  `REJTEXT` text NOT NULL,
  `REJTYPE` varchar(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `qb_conf`
--

CREATE TABLE `qb_conf` (
  `IDX` int(11) NOT NULL,
  `REMINDER` int(11) NOT NULL DEFAULT 24,
  `REMINDER2` int(11) NOT NULL DEFAULT 1,
  `REMINDER3` int(11) NOT NULL,
  `REMINDER4` int(11) NOT NULL,
  `REMINDER5` int(11) NOT NULL,
  `DEFAULTPW` varchar(50) NOT NULL,
  `COMPANY` varchar(200) NOT NULL,
  `SENDERMAIL` varchar(100) NOT NULL,
  `COMPANYLOGO` varchar(256) NOT NULL,
  `SERVER` varchar(100) NOT NULL,
  `DEBUGGING` int(11) NOT NULL DEFAULT 0,
  `TIMEZONE` varchar(100) NOT NULL,
  `LASTRUN` int(11) NOT NULL,
  `CYCLE` int(11) NOT NULL,
  `VER` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Daten für Tabelle `qb_conf`
--

INSERT INTO `qb_conf` (`IDX`, `REMINDER`, `REMINDER2`, `REMINDER3`, `REMINDER4`, `REMINDER5`, `DEFAULTPW`, `COMPANY`, `SENDERMAIL`, `COMPANYLOGO`, `SERVER`, `DEBUGGING`, `TIMEZONE`, `LASTRUN`, `CYCLE`, `VER`) VALUES
(1, 48, 24, 2, 5, 5, 'Sadaja', 'QMMS', 'admin@qmms.com', 'qmms.png', 'localhost', 0, 'Europe/Zurich', 0, 1, '4.1.8');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `qb_dashboards`
--

CREATE TABLE `qb_dashboards` (
  `IDX` int(11) NOT NULL,
  `LOGIN` varchar(50) NOT NULL,
  `DASH` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `qb_def`
--

CREATE TABLE `qb_def` (
  `IDX` int(11) NOT NULL,
  `QBN` varchar(20) NOT NULL,
  `8D` int(11) NOT NULL,
  `8D_AN` date NOT NULL,
  `8D_ERH` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `qb_deputy`
--

CREATE TABLE `qb_deputy` (
  `IDX` int(11) NOT NULL,
  `SVT` varchar(50) NOT NULL,
  `DSVT` varchar(50) NOT NULL,
  `REP` varchar(1) NOT NULL DEFAULT '0',
  `EX` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `qb_doccom`
--

CREATE TABLE `qb_doccom` (
  `IDX` int(11) NOT NULL,
  `QBN` varchar(20) NOT NULL,
  `UID` varchar(16) NOT NULL,
  `WHN` date NOT NULL,
  `WHT` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `qb_doccom_files`
--

CREATE TABLE `qb_doccom_files` (
  `IDX` int(11) NOT NULL,
  `LUID` varchar(20) NOT NULL,
  `LINK` varchar(256) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `qb_doccost`
--

CREATE TABLE `qb_doccost` (
  `IDX` int(11) NOT NULL,
  `QBN` varchar(20) NOT NULL,
  `UID` varchar(20) NOT NULL,
  `GRUND` text NOT NULL,
  `ART` varchar(1) NOT NULL,
  `C_DATE` date NOT NULL,
  `MENGE` int(11) NOT NULL,
  `COST` double NOT NULL,
  `CURRENCY` varchar(3) NOT NULL,
  `FACTOR` double NOT NULL,
  `WHO` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `qb_doccost_files`
--

CREATE TABLE `qb_doccost_files` (
  `IDX` int(11) NOT NULL,
  `LUID` varchar(20) NOT NULL,
  `LINK` varchar(256) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `qb_docdef`
--

CREATE TABLE `qb_docdef` (
  `IDX` int(11) NOT NULL,
  `QBN` varchar(20) NOT NULL,
  `UID` varchar(20) NOT NULL,
  `WHT` text NOT NULL,
  `WHN` timestamp NOT NULL DEFAULT current_timestamp(),
  `REMINDER` date NOT NULL,
  `REMINDERINFO` date NOT NULL,
  `LUPDATE` datetime NOT NULL,
  `STAT` varchar(10) NOT NULL,
  `VISUM` varchar(50) NOT NULL,
  `UNTIL` date NOT NULL,
  `INFO` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `qb_docdef_files`
--

CREATE TABLE `qb_docdef_files` (
  `IDX` int(11) NOT NULL,
  `LUID` varchar(256) NOT NULL,
  `LINK` varchar(256) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `qb_docimm`
--

CREATE TABLE `qb_docimm` (
  `IDX` int(11) NOT NULL,
  `QBN` varchar(20) NOT NULL,
  `UID` varchar(20) NOT NULL,
  `WHT` text NOT NULL,
  `WHN` timestamp NOT NULL DEFAULT current_timestamp(),
  `REMINDER` date NOT NULL,
  `REMINDERINFO` date NOT NULL,
  `LUPDATE` datetime NOT NULL,
  `STAT` varchar(10) NOT NULL,
  `VISUM` varchar(50) NOT NULL,
  `UNTIL` date NOT NULL,
  `INFO` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `qb_docimm_files`
--

CREATE TABLE `qb_docimm_files` (
  `IDX` int(11) NOT NULL,
  `LUID` varchar(200) NOT NULL,
  `LINK` varchar(256) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `qb_docmet`
--

CREATE TABLE `qb_docmet` (
  `IDX` int(11) NOT NULL,
  `QBN` varchar(20) NOT NULL,
  `UID` varchar(20) NOT NULL,
  `WHN` date NOT NULL,
  `WHT` text NOT NULL,
  `VISUM` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `qb_docmet_files`
--

CREATE TABLE `qb_docmet_files` (
  `IDX` int(11) NOT NULL,
  `LUID` varchar(20) NOT NULL,
  `LINK` varchar(256) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `qb_fivewhy`
--

CREATE TABLE `qb_fivewhy` (
  `IDX` int(11) NOT NULL,
  `QBN` varchar(20) NOT NULL,
  `WHYARRAY` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `qb_imm`
--

CREATE TABLE `qb_imm` (
  `IDX` int(11) NOT NULL,
  `QBN` varchar(20) NOT NULL,
  `WES` int(11) NOT NULL,
  `ERSATZ` int(11) NOT NULL,
  `SONDERFREIGABE` int(11) NOT NULL,
  `CUS_BET` int(11) NOT NULL,
  `MIM` int(11) NOT NULL,
  `PUB` int(11) NOT NULL,
  `LUB` int(11) NOT NULL,
  `ASOR` int(11) NOT NULL,
  `LPSG48` int(11) NOT NULL,
  `LPSK48` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `qb_imp`
--

CREATE TABLE `qb_imp` (
  `IDX` int(11) NOT NULL,
  `QBN` varchar(20) NOT NULL,
  `DATE_REL_M` date NOT NULL,
  `PLANNED_C_DATE` date NOT NULL,
  `SEND_TO_SVT` date NOT NULL,
  `DATE_ACC_BY_SVT` date NOT NULL,
  `DESCRIPTION` text NOT NULL,
  `VFFU` varchar(20) NOT NULL,
  `REJECT` int(11) NOT NULL DEFAULT 0,
  `INFO` date NOT NULL,
  `TEAMAPP` int(11) NOT NULL,
  `OVERRULED` text NOT NULL,
  `ACT` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `qb_imp_rej`
--

CREATE TABLE `qb_imp_rej` (
  `IDX` int(11) NOT NULL,
  `QBN` varchar(20) NOT NULL,
  `REJLOGIN` varchar(50) NOT NULL,
  `REJDATE` datetime NOT NULL,
  `REJTEXT` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `qb_log`
--

CREATE TABLE `qb_log` (
  `IDX` int(11) NOT NULL,
  `QBN` varchar(20) NOT NULL,
  `DATE` date NOT NULL,
  `WHO` varchar(100) NOT NULL,
  `FORM` varchar(20) NOT NULL,
  `WHAT` text NOT NULL,
  `TXT` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `qb_mail`
--

CREATE TABLE `qb_mail` (
  `IDX` int(11) NOT NULL,
  `ADDRESS` varchar(50) NOT NULL,
  `EVENTS` text NOT NULL,
  `REGIONS` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `qb_man`
--

CREATE TABLE `qb_man` (
  `IDX` int(11) NOT NULL,
  `QBN` varchar(10) NOT NULL,
  `MANDARRAY` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `qb_mantrans`
--

CREATE TABLE `qb_mantrans` (
  `IDX` int(11) NOT NULL,
  `SHORT` varchar(3) NOT NULL,
  `DEPARTMENT` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `qb_material`
--

CREATE TABLE `qb_material` (
  `IDX` int(11) NOT NULL,
  `TGR` varchar(20) NOT NULL,
  `MSTATUS` varchar(10) NOT NULL,
  `TGRBZ_1` text NOT NULL,
  `TGRBZ_2` text NOT NULL,
  `WGR` varchar(20) NOT NULL,
  `ACTIVE` int(11) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `qb_meta`
--

CREATE TABLE `qb_meta` (
  `IDX` int(11) NOT NULL,
  `QBN` varchar(20) NOT NULL,
  `META` varchar(5) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `qb_metadata`
--

CREATE TABLE `qb_metadata` (
  `IDX` int(11) NOT NULL,
  `REF` varchar(3) NOT NULL,
  `TXT` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `qb_nacharbeit`
--

CREATE TABLE `qb_nacharbeit` (
  `IDX` int(11) NOT NULL,
  `QBN` varchar(20) NOT NULL,
  `ORDERNR` varchar(20) NOT NULL,
  `SUPPLIER` varchar(20) NOT NULL,
  `DELIVERED` int(11) NOT NULL,
  `RETURNED` int(11) NOT NULL,
  `DATE_OUT` date NOT NULL,
  `DATE_IN` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `qb_plchange`
--

CREATE TABLE `qb_plchange` (
  `IDX` int(11) NOT NULL,
  `CHANGEDATE` timestamp NOT NULL DEFAULT current_timestamp(),
  `QBN` varchar(20) NOT NULL,
  `OLDPL` varchar(50) NOT NULL,
  `NEWPL` varchar(50) NOT NULL,
  `CHANGER` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `qb_privatequery`
--

CREATE TABLE `qb_privatequery` (
  `IDX` int(11) NOT NULL,
  `LOGIN` varchar(50) NOT NULL,
  `PROFILE` varchar(50) NOT NULL,
  `FELDER` text NOT NULL,
  `FILTER` text NOT NULL,
  `FILTER2` text NOT NULL,
  `ACTIVE` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `qb_qbref`
--

CREATE TABLE `qb_qbref` (
  `IDX` int(11) NOT NULL,
  `QBN` varchar(20) NOT NULL,
  `QBREF` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `qb_respw`
--

CREATE TABLE `qb_respw` (
  `IDX` int(11) NOT NULL,
  `REQ` varchar(50) NOT NULL,
  `UID` varchar(50) NOT NULL,
  `CNTR` int(11) NOT NULL,
  `EXPIRES` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `qb_roles`
--

CREATE TABLE `qb_roles` (
  `IDX` int(11) NOT NULL,
  `ROLE` varchar(30) NOT NULL,
  `FLAGS` varchar(50) NOT NULL,
  `DFLT` varchar(50) NOT NULL,
  `MASTER` int(11) NOT NULL DEFAULT 0,
  `ORDR` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Daten für Tabelle `qb_roles`
--

INSERT INTO `qb_roles` (`IDX`, `ROLE`, `FLAGS`, `DFLT`, `MASTER`, `ORDR`) VALUES
(1, 'ADMIN', 'LGICKTSWXZY', 'GILTWYZ', 2, 0),
(2, 'RESPONSIBLE', 'V', 'V', 2, 2),
(3, 'LEADER', 'F', 'F', 2, 3),
(4, 'USER', '', '', 2, 4),
(6, 'QUALITY', 'LGICWXZ', 'GILWXZ', 2, 1);

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `qb_sessions`
--

CREATE TABLE `qb_sessions` (
  `id` varchar(32) NOT NULL,
  `access` int(10) UNSIGNED DEFAULT NULL,
  `data` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `qb_supplier`
--

CREATE TABLE `qb_supplier` (
  `IDX` int(11) NOT NULL,
  `SUPPLIERNR` varchar(6) NOT NULL,
  `SUPPLIERNAME` varchar(50) NOT NULL,
  `ACTIVE` int(11) NOT NULL DEFAULT 1,
  `LAND` varchar(2) NOT NULL,
  `TRACK` int(11) NOT NULL,
  `SCLASS` varchar(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `qb_svtchange`
--

CREATE TABLE `qb_svtchange` (
  `IDX` int(11) NOT NULL,
  `CHANGEDATE` timestamp NOT NULL DEFAULT current_timestamp(),
  `QBN` varchar(20) NOT NULL,
  `OLDSVT` varchar(50) NOT NULL,
  `NEWSVT` varchar(50) NOT NULL,
  `CHANGER` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `qb_svtmail`
--

CREATE TABLE `qb_svtmail` (
  `IDX` int(11) NOT NULL,
  `SVT` varchar(50) NOT NULL,
  `EVENTS` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `qb_team`
--

CREATE TABLE `qb_team` (
  `IDX` int(11) NOT NULL,
  `QBN` varchar(20) NOT NULL,
  `NAME` varchar(50) NOT NULL,
  `ROLLE` varchar(20) NOT NULL,
  `INFORMED` datetime NOT NULL,
  `NOMINATED` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `qb_trackmail`
--

CREATE TABLE `qb_trackmail` (
  `IDX` int(11) NOT NULL,
  `QBN` varchar(20) NOT NULL,
  `EMAIL` varchar(100) NOT NULL,
  `EVENTS` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `qb_val`
--

CREATE TABLE `qb_val` (
  `IDX` int(11) NOT NULL,
  `QBN` varchar(20) NOT NULL,
  `CHECK_NEXT_WE` int(11) NOT NULL,
  `WE_OK` int(11) NOT NULL,
  `WE_DATE` date NOT NULL,
  `DOOT` int(11) NOT NULL,
  `OTHER_TEST` text NOT NULL,
  `TEST_OK` int(11) NOT NULL,
  `V_DATE` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `qb_widgets`
--

CREATE TABLE `qb_widgets` (
  `IDX` int(11) NOT NULL,
  `WIDGET` varchar(50) NOT NULL,
  `LNG` varchar(20) NOT NULL,
  `DEFS` text NOT NULL,
  `INIT` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Indizes der exportierten Tabellen
--

--
-- Indizes für die Tabelle `qbbasic`
--
ALTER TABLE `qbbasic`
  ADD UNIQUE KEY `IDX` (`IDX`),
  ADD KEY `QBN` (`QBN`),
  ADD KEY `LFS_NR` (`LFS_NR`);

--
-- Indizes für die Tabelle `qbbasic_files`
--
ALTER TABLE `qbbasic_files`
  ADD PRIMARY KEY (`IDX`);

--
-- Indizes für die Tabelle `qbi`
--
ALTER TABLE `qbi`
  ADD PRIMARY KEY (`IDX`),
  ADD UNIQUE KEY `QBN` (`QBN`);

--
-- Indizes für die Tabelle `qb_8d`
--
ALTER TABLE `qb_8d`
  ADD PRIMARY KEY (`IDX`),
  ADD KEY `QBN` (`QBN`);

--
-- Indizes für die Tabelle `qb_close`
--
ALTER TABLE `qb_close`
  ADD PRIMARY KEY (`IDX`),
  ADD KEY `QBN` (`QBN`);

--
-- Indizes für die Tabelle `qb_close_rej`
--
ALTER TABLE `qb_close_rej`
  ADD PRIMARY KEY (`IDX`),
  ADD KEY `QBN` (`QBN`);

--
-- Indizes für die Tabelle `qb_conf`
--
ALTER TABLE `qb_conf`
  ADD UNIQUE KEY `IDX` (`IDX`);

--
-- Indizes für die Tabelle `qb_dashboards`
--
ALTER TABLE `qb_dashboards`
  ADD PRIMARY KEY (`IDX`),
  ADD KEY `LOGIN` (`LOGIN`);

--
-- Indizes für die Tabelle `qb_def`
--
ALTER TABLE `qb_def`
  ADD PRIMARY KEY (`IDX`),
  ADD KEY `QBN` (`QBN`);

--
-- Indizes für die Tabelle `qb_deputy`
--
ALTER TABLE `qb_deputy`
  ADD PRIMARY KEY (`IDX`);

--
-- Indizes für die Tabelle `qb_doccom`
--
ALTER TABLE `qb_doccom`
  ADD PRIMARY KEY (`IDX`),
  ADD KEY `QBN` (`QBN`);

--
-- Indizes für die Tabelle `qb_doccom_files`
--
ALTER TABLE `qb_doccom_files`
  ADD PRIMARY KEY (`IDX`),
  ADD KEY `LUID` (`LUID`);

--
-- Indizes für die Tabelle `qb_doccost`
--
ALTER TABLE `qb_doccost`
  ADD PRIMARY KEY (`IDX`),
  ADD KEY `QBN` (`QBN`);

--
-- Indizes für die Tabelle `qb_doccost_files`
--
ALTER TABLE `qb_doccost_files`
  ADD PRIMARY KEY (`IDX`),
  ADD KEY `LUID` (`LUID`);

--
-- Indizes für die Tabelle `qb_docdef`
--
ALTER TABLE `qb_docdef`
  ADD PRIMARY KEY (`IDX`),
  ADD KEY `QBN` (`QBN`);

--
-- Indizes für die Tabelle `qb_docdef_files`
--
ALTER TABLE `qb_docdef_files`
  ADD PRIMARY KEY (`IDX`),
  ADD KEY `LUID` (`LUID`);

--
-- Indizes für die Tabelle `qb_docimm`
--
ALTER TABLE `qb_docimm`
  ADD PRIMARY KEY (`IDX`),
  ADD KEY `QBN` (`QBN`);

--
-- Indizes für die Tabelle `qb_docimm_files`
--
ALTER TABLE `qb_docimm_files`
  ADD PRIMARY KEY (`IDX`),
  ADD KEY `LUID` (`LUID`);

--
-- Indizes für die Tabelle `qb_docmet`
--
ALTER TABLE `qb_docmet`
  ADD PRIMARY KEY (`IDX`),
  ADD KEY `QBN` (`QBN`);

--
-- Indizes für die Tabelle `qb_docmet_files`
--
ALTER TABLE `qb_docmet_files`
  ADD PRIMARY KEY (`IDX`),
  ADD KEY `LUID` (`LUID`);

--
-- Indizes für die Tabelle `qb_fivewhy`
--
ALTER TABLE `qb_fivewhy`
  ADD PRIMARY KEY (`IDX`);

--
-- Indizes für die Tabelle `qb_imm`
--
ALTER TABLE `qb_imm`
  ADD PRIMARY KEY (`IDX`),
  ADD KEY `QBN` (`QBN`);

--
-- Indizes für die Tabelle `qb_imp`
--
ALTER TABLE `qb_imp`
  ADD PRIMARY KEY (`IDX`),
  ADD KEY `QBN` (`QBN`);

--
-- Indizes für die Tabelle `qb_imp_rej`
--
ALTER TABLE `qb_imp_rej`
  ADD PRIMARY KEY (`IDX`),
  ADD KEY `QBN` (`QBN`);

--
-- Indizes für die Tabelle `qb_log`
--
ALTER TABLE `qb_log`
  ADD PRIMARY KEY (`IDX`);

--
-- Indizes für die Tabelle `qb_mail`
--
ALTER TABLE `qb_mail`
  ADD UNIQUE KEY `IDX` (`IDX`);

--
-- Indizes für die Tabelle `qb_man`
--
ALTER TABLE `qb_man`
  ADD PRIMARY KEY (`IDX`),
  ADD KEY `QBN` (`QBN`);

--
-- Indizes für die Tabelle `qb_mantrans`
--
ALTER TABLE `qb_mantrans`
  ADD PRIMARY KEY (`IDX`);

--
-- Indizes für die Tabelle `qb_material`
--
ALTER TABLE `qb_material`
  ADD PRIMARY KEY (`IDX`),
  ADD UNIQUE KEY `IDX` (`IDX`),
  ADD KEY `TGR` (`TGR`);

--
-- Indizes für die Tabelle `qb_meta`
--
ALTER TABLE `qb_meta`
  ADD PRIMARY KEY (`IDX`);

--
-- Indizes für die Tabelle `qb_metadata`
--
ALTER TABLE `qb_metadata`
  ADD PRIMARY KEY (`IDX`),
  ADD UNIQUE KEY `REF` (`REF`);

--
-- Indizes für die Tabelle `qb_nacharbeit`
--
ALTER TABLE `qb_nacharbeit`
  ADD PRIMARY KEY (`IDX`);

--
-- Indizes für die Tabelle `qb_plchange`
--
ALTER TABLE `qb_plchange`
  ADD PRIMARY KEY (`IDX`);

--
-- Indizes für die Tabelle `qb_privatequery`
--
ALTER TABLE `qb_privatequery`
  ADD PRIMARY KEY (`IDX`),
  ADD KEY `LOGIN` (`LOGIN`);

--
-- Indizes für die Tabelle `qb_qbref`
--
ALTER TABLE `qb_qbref`
  ADD UNIQUE KEY `IDX` (`IDX`);

--
-- Indizes für die Tabelle `qb_respw`
--
ALTER TABLE `qb_respw`
  ADD PRIMARY KEY (`IDX`);

--
-- Indizes für die Tabelle `qb_roles`
--
ALTER TABLE `qb_roles`
  ADD PRIMARY KEY (`IDX`);

--
-- Indizes für die Tabelle `qb_sessions`
--
ALTER TABLE `qb_sessions`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `qb_supplier`
--
ALTER TABLE `qb_supplier`
  ADD PRIMARY KEY (`IDX`),
  ADD KEY `SUPPLIERNR` (`SUPPLIERNR`);

--
-- Indizes für die Tabelle `qb_svtchange`
--
ALTER TABLE `qb_svtchange`
  ADD PRIMARY KEY (`IDX`);

--
-- Indizes für die Tabelle `qb_svtmail`
--
ALTER TABLE `qb_svtmail`
  ADD UNIQUE KEY `IDX` (`IDX`);

--
-- Indizes für die Tabelle `qb_team`
--
ALTER TABLE `qb_team`
  ADD UNIQUE KEY `IDX` (`IDX`),
  ADD KEY `QBN` (`QBN`);

--
-- Indizes für die Tabelle `qb_trackmail`
--
ALTER TABLE `qb_trackmail`
  ADD PRIMARY KEY (`IDX`);

--
-- Indizes für die Tabelle `qb_val`
--
ALTER TABLE `qb_val`
  ADD PRIMARY KEY (`IDX`),
  ADD KEY `QBN` (`QBN`);

--
-- Indizes für die Tabelle `qb_widgets`
--
ALTER TABLE `qb_widgets`
  ADD PRIMARY KEY (`IDX`);

--
-- AUTO_INCREMENT für exportierte Tabellen
--

--
-- AUTO_INCREMENT für Tabelle `qbbasic`
--
ALTER TABLE `qbbasic`
  MODIFY `IDX` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `qbbasic_files`
--
ALTER TABLE `qbbasic_files`
  MODIFY `IDX` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `qbi`
--
ALTER TABLE `qbi`
  MODIFY `IDX` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `qb_8d`
--
ALTER TABLE `qb_8d`
  MODIFY `IDX` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `qb_close`
--
ALTER TABLE `qb_close`
  MODIFY `IDX` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `qb_close_rej`
--
ALTER TABLE `qb_close_rej`
  MODIFY `IDX` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `qb_conf`
--
ALTER TABLE `qb_conf`
  MODIFY `IDX` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `qb_dashboards`
--
ALTER TABLE `qb_dashboards`
  MODIFY `IDX` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `qb_def`
--
ALTER TABLE `qb_def`
  MODIFY `IDX` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `qb_deputy`
--
ALTER TABLE `qb_deputy`
  MODIFY `IDX` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `qb_doccom`
--
ALTER TABLE `qb_doccom`
  MODIFY `IDX` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `qb_doccom_files`
--
ALTER TABLE `qb_doccom_files`
  MODIFY `IDX` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `qb_doccost`
--
ALTER TABLE `qb_doccost`
  MODIFY `IDX` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `qb_doccost_files`
--
ALTER TABLE `qb_doccost_files`
  MODIFY `IDX` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `qb_docdef`
--
ALTER TABLE `qb_docdef`
  MODIFY `IDX` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `qb_docdef_files`
--
ALTER TABLE `qb_docdef_files`
  MODIFY `IDX` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `qb_docimm`
--
ALTER TABLE `qb_docimm`
  MODIFY `IDX` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `qb_docimm_files`
--
ALTER TABLE `qb_docimm_files`
  MODIFY `IDX` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `qb_docmet`
--
ALTER TABLE `qb_docmet`
  MODIFY `IDX` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `qb_docmet_files`
--
ALTER TABLE `qb_docmet_files`
  MODIFY `IDX` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `qb_fivewhy`
--
ALTER TABLE `qb_fivewhy`
  MODIFY `IDX` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `qb_imm`
--
ALTER TABLE `qb_imm`
  MODIFY `IDX` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `qb_imp`
--
ALTER TABLE `qb_imp`
  MODIFY `IDX` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `qb_imp_rej`
--
ALTER TABLE `qb_imp_rej`
  MODIFY `IDX` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `qb_log`
--
ALTER TABLE `qb_log`
  MODIFY `IDX` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `qb_mail`
--
ALTER TABLE `qb_mail`
  MODIFY `IDX` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `qb_man`
--
ALTER TABLE `qb_man`
  MODIFY `IDX` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `qb_mantrans`
--
ALTER TABLE `qb_mantrans`
  MODIFY `IDX` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `qb_material`
--
ALTER TABLE `qb_material`
  MODIFY `IDX` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `qb_meta`
--
ALTER TABLE `qb_meta`
  MODIFY `IDX` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `qb_metadata`
--
ALTER TABLE `qb_metadata`
  MODIFY `IDX` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `qb_nacharbeit`
--
ALTER TABLE `qb_nacharbeit`
  MODIFY `IDX` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `qb_plchange`
--
ALTER TABLE `qb_plchange`
  MODIFY `IDX` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `qb_privatequery`
--
ALTER TABLE `qb_privatequery`
  MODIFY `IDX` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `qb_qbref`
--
ALTER TABLE `qb_qbref`
  MODIFY `IDX` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `qb_respw`
--
ALTER TABLE `qb_respw`
  MODIFY `IDX` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `qb_roles`
--
ALTER TABLE `qb_roles`
  MODIFY `IDX` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `qb_supplier`
--
ALTER TABLE `qb_supplier`
  MODIFY `IDX` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `qb_svtchange`
--
ALTER TABLE `qb_svtchange`
  MODIFY `IDX` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `qb_svtmail`
--
ALTER TABLE `qb_svtmail`
  MODIFY `IDX` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `qb_team`
--
ALTER TABLE `qb_team`
  MODIFY `IDX` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `qb_trackmail`
--
ALTER TABLE `qb_trackmail`
  MODIFY `IDX` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `qb_val`
--
ALTER TABLE `qb_val`
  MODIFY `IDX` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `qb_widgets`
--
ALTER TABLE `qb_widgets`
  MODIFY `IDX` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

