Hallo
anbei die Abfrage:
-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Erstellungszeit: 13. Feb 2023 um 16:24
-- Server-Version: 10.10.3-MariaDB-1:10.10.3+maria~deb11
-- PHP-Version: 8.1.15
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Datenbank: `lc-backup`
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `PERMISSIONS`
--
CREATE TABLE `PERMISSIONS` (
`P_ID` int(11) NOT NULL,
`P_IDLEFT` int(11) NOT NULL,
`P_IDRIGHT` int(11) NOT NULL,
`P_IDLEVEL` int(11) NOT NULL,
`P_TYPE` int(11) NOT NULL,
`P_GROUPING` int(11) NOT NULL,
`P_MODULEID` int(11) NOT NULL,
`P_PERMISSIONID` int(11) NOT NULL,
`P_KEY` varchar(30) DEFAULT NULL,
`P_NAME` varchar(30) NOT NULL,
`P_ICON` varchar(30) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
--
-- Daten für Tabelle `PERMISSIONS`
--
INSERT INTO `PERMISSIONS` (`P_ID`, `P_IDLEFT`, `P_IDRIGHT`, `P_IDLEVEL`, `P_PERMISSIONID`, `P_KEY`) VALUES
(1, 1, 8, 0, 0, NULL),
(2, 2, 3, 1, 1, 'CORE_LOGIN'),
(3, 4, 5, 1, 2, 'CORE_SOAP'),
(4, 6, 7, 1, 3, 'CORE_LOG'),
(5, 9, 16, 0, 0, NULL),
(6, 10, 11, 1, 4, 'CORE_PASSWORD'),
(7, 12, 13, 1, 5, 'CORE_LANGUAGE'),
(8, 14, 15, 1, 9, 'CORE_RESELLERSETTINGS'),
(9, 17, 28, 0, 0, NULL),
(10, 18, 19, 1, 6, 'CORE_USERS'),
(11, 20, 21, 1, 7, 'CORE_CUSTOMERS'),
(12, 22, 23, 1, 8, 'CORE_LIVECONFIG'),
(13, 24, 25, 1, 1, 'IFR_CUSTOMLINKS'),
(14, 26, 27, 1, 10, 'CORE_REPORTS'),
(15, 29, 62, 0, 0, NULL),
(16, 30, 31, 1, 1, 'HST_ADM_HOSTING'),
(17, 32, 33, 1, 2, 'HST_ADM_PLANS'),
(18, 34, 35, 1, 12, 'HST_ADM_SSLCERTS'),
(19, 36, 37, 1, 13, 'HST_ADM_PHPTEMPLATES'),
(20, 38, 61, 1, 0, NULL),
(21, 39, 40, 2, 3, 'HST_OBJ_WEBSPACE'),
(22, 41, 42, 2, 4, 'HST_OBJ_LOGFILES'),
(23, 43, 44, 2, 5, 'HST_OBJ_FTP'),
(24, 45, 46, 2, 6, 'HST_OBJ_DB'),
(25, 47, 48, 2, 7, 'HST_OBJ_EMAIL');
--
-- Indizes der exportierten Tabellen
--
--
-- Indizes für die Tabelle `PERMISSIONS`
--
ALTER TABLE `PERMISSIONS`
ADD PRIMARY KEY (`P_ID`),
ADD KEY `P_IDLEFT_IDX` (`P_IDLEFT`),
ADD KEY `P_IDRIGHT_IDX` (`P_IDRIGHT`),
ADD KEY `P_MODULEID_IDX` (`P_MODULEID`);
--
-- AUTO_INCREMENT für exportierte Tabellen
--
--
-- AUTO_INCREMENT für Tabelle `PERMISSIONS`
--
ALTER TABLE `PERMISSIONS`
MODIFY `P_ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
COMMIT;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Mit freundlichen Grüßen
Martin Krüger
