Da

✏️ Editing: webmail_5.sql

/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.5.26-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: webmail_5
-- ------------------------------------------------------
-- Server version	10.5.26-MariaDB

/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Current Database: `webmail_5`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `webmail_5` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci */;

USE `webmail_5`;

--
-- Table structure for table `au_activity_history`
--

DROP TABLE IF EXISTS `au_activity_history`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `au_activity_history` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) DEFAULT NULL,
  `resource_type` varchar(255) DEFAULT NULL,
  `resource_id` varchar(255) DEFAULT NULL,
  `ip_address` varchar(255) DEFAULT NULL,
  `action` varchar(255) DEFAULT NULL,
  `time` int(11) DEFAULT NULL,
  `guest_public_id` varchar(255) DEFAULT NULL,
  KEY `id` (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `au_activity_history`
--

LOCK TABLES `au_activity_history` WRITE;
/*!40000 ALTER TABLE `au_activity_history` DISABLE KEYS */;
/*!40000 ALTER TABLE `au_activity_history` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `au_adav_addressbookchanges`
--

DROP TABLE IF EXISTS `au_adav_addressbookchanges`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `au_adav_addressbookchanges` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uri` varbinary(255) NOT NULL,
  `synctoken` int(11) unsigned NOT NULL,
  `addressbookid` int(11) unsigned NOT NULL,
  `operation` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `addressbookid_synctoken` (`addressbookid`,`synctoken`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `au_adav_addressbookchanges`
--

LOCK TABLES `au_adav_addressbookchanges` WRITE;
/*!40000 ALTER TABLE `au_adav_addressbookchanges` DISABLE KEYS */;
/*!40000 ALTER TABLE `au_adav_addressbookchanges` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `au_adav_addressbooks`
--

DROP TABLE IF EXISTS `au_adav_addressbooks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `au_adav_addressbooks` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `principaluri` varbinary(255) DEFAULT NULL,
  `displayname` varchar(255) DEFAULT NULL,
  `uri` varbinary(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `synctoken` int(11) unsigned NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  UNIQUE KEY `principaluri` (`principaluri`(100),`uri`(100))
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `au_adav_addressbooks`
--

LOCK TABLES `au_adav_addressbooks` WRITE;
/*!40000 ALTER TABLE `au_adav_addressbooks` DISABLE KEYS */;
/*!40000 ALTER TABLE `au_adav_addressbooks` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `au_adav_cache`
--

DROP TABLE IF EXISTS `au_adav_cache`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `au_adav_cache` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` varchar(255) DEFAULT NULL,
  `calendaruri` varchar(255) DEFAULT NULL,
  `type` tinyint(4) DEFAULT NULL,
  `time` int(11) DEFAULT NULL,
  `starttime` int(11) DEFAULT NULL,
  `eventid` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `au_adav_cache`
--

LOCK TABLES `au_adav_cache` WRITE;
/*!40000 ALTER TABLE `au_adav_cache` DISABLE KEYS */;
/*!40000 ALTER TABLE `au_adav_cache` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `au_adav_calendarchanges`
--

DROP TABLE IF EXISTS `au_adav_calendarchanges`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `au_adav_calendarchanges` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uri` varbinary(255) NOT NULL,
  `synctoken` int(11) unsigned NOT NULL,
  `calendarid` int(11) unsigned NOT NULL,
  `operation` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `calendarid_synctoken` (`calendarid`,`synctoken`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `au_adav_calendarchanges`
--

LOCK TABLES `au_adav_calendarchanges` WRITE;
/*!40000 ALTER TABLE `au_adav_calendarchanges` DISABLE KEYS */;
/*!40000 ALTER TABLE `au_adav_calendarchanges` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `au_adav_calendarinstances`
--

DROP TABLE IF EXISTS `au_adav_calendarinstances`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `au_adav_calendarinstances` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `calendarid` int(10) unsigned NOT NULL,
  `principaluri` varbinary(100) DEFAULT NULL,
  `access` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1 = owner, 2 = read, 3 = readwrite',
  `displayname` varchar(100) DEFAULT NULL,
  `uri` varbinary(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `calendarorder` int(11) unsigned NOT NULL DEFAULT 0,
  `calendarcolor` varbinary(10) DEFAULT NULL,
  `timezone` text DEFAULT NULL,
  `transparent` tinyint(1) NOT NULL DEFAULT 0,
  `share_href` varbinary(100) DEFAULT NULL,
  `share_displayname` varchar(100) DEFAULT NULL,
  `share_invitestatus` tinyint(1) NOT NULL DEFAULT 2 COMMENT '1 = noresponse, 2 = accepted, 3 = declined, 4 = invalid',
  `public` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `principaluri` (`principaluri`,`uri`),
  UNIQUE KEY `calendarid` (`calendarid`,`principaluri`),
  UNIQUE KEY `calendarid_2` (`calendarid`,`share_href`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `au_adav_calendarinstances`
--

LOCK TABLES `au_adav_calendarinstances` WRITE;
/*!40000 ALTER TABLE `au_adav_calendarinstances` DISABLE KEYS */;
/*!40000 ALTER TABLE `au_adav_calendarinstances` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `au_adav_calendarobjects`
--

DROP TABLE IF EXISTS `au_adav_calendarobjects`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `au_adav_calendarobjects` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `calendardata` mediumblob DEFAULT NULL,
  `uri` varbinary(255) DEFAULT NULL,
  `calendarid` int(10) unsigned NOT NULL,
  `lastmodified` int(11) unsigned DEFAULT NULL,
  `etag` varbinary(32) DEFAULT NULL,
  `size` int(11) unsigned NOT NULL,
  `componenttype` varbinary(8) DEFAULT NULL,
  `firstoccurence` int(11) unsigned DEFAULT NULL,
  `lastoccurence` int(11) unsigned DEFAULT NULL,
  `uid` varbinary(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `calendarid` (`calendarid`,`uri`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `au_adav_calendarobjects`
--

LOCK TABLES `au_adav_calendarobjects` WRITE;
/*!40000 ALTER TABLE `au_adav_calendarobjects` DISABLE KEYS */;
/*!40000 ALTER TABLE `au_adav_calendarobjects` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `au_adav_calendars`
--

DROP TABLE IF EXISTS `au_adav_calendars`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `au_adav_calendars` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `synctoken` int(10) unsigned NOT NULL DEFAULT 1,
  `components` varbinary(21) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `au_adav_calendars`
--

LOCK TABLES `au_adav_calendars` WRITE;
/*!40000 ALTER TABLE `au_adav_calendars` DISABLE KEYS */;
/*!40000 ALTER TABLE `au_adav_calendars` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `au_adav_calendarsubscriptions`
--

DROP TABLE IF EXISTS `au_adav_calendarsubscriptions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `au_adav_calendarsubscriptions` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uri` varbinary(255) NOT NULL,
  `principaluri` varbinary(100) NOT NULL,
  `source` text DEFAULT NULL,
  `displayname` varchar(100) DEFAULT NULL,
  `refreshrate` varchar(10) DEFAULT NULL,
  `calendarorder` int(11) unsigned NOT NULL DEFAULT 0,
  `calendarcolor` varbinary(10) DEFAULT NULL,
  `striptodos` tinyint(1) DEFAULT NULL,
  `stripalarms` tinyint(1) DEFAULT NULL,
  `stripattachments` tinyint(1) DEFAULT NULL,
  `lastmodified` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `principaluri` (`principaluri`,`uri`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `au_adav_calendarsubscriptions`
--

LOCK TABLES `au_adav_calendarsubscriptions` WRITE;
/*!40000 ALTER TABLE `au_adav_calendarsubscriptions` DISABLE KEYS */;
/*!40000 ALTER TABLE `au_adav_calendarsubscriptions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `au_adav_cards`
--

DROP TABLE IF EXISTS `au_adav_cards`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `au_adav_cards` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `addressbookid` int(11) unsigned NOT NULL,
  `carddata` mediumblob DEFAULT NULL,
  `uri` varbinary(255) DEFAULT NULL,
  `lastmodified` int(11) unsigned DEFAULT NULL,
  `etag` varbinary(32) DEFAULT NULL,
  `size` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `au_adav_cards`
--

LOCK TABLES `au_adav_cards` WRITE;
/*!40000 ALTER TABLE `au_adav_cards` DISABLE KEYS */;
/*!40000 ALTER TABLE `au_adav_cards` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `au_adav_groupmembers`
--

DROP TABLE IF EXISTS `au_adav_groupmembers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `au_adav_groupmembers` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `principal_id` int(11) unsigned NOT NULL,
  `member_id` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `au_ADAV_GROUPMEMBERS_MEMBER_ID_PRINCIPAL_ID_INDEX` (`principal_id`,`member_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `au_adav_groupmembers`
--

LOCK TABLES `au_adav_groupmembers` WRITE;
/*!40000 ALTER TABLE `au_adav_groupmembers` DISABLE KEYS */;
/*!40000 ALTER TABLE `au_adav_groupmembers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `au_adav_locks`
--

DROP TABLE IF EXISTS `au_adav_locks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `au_adav_locks` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `owner` varchar(100) DEFAULT NULL,
  `timeout` int(10) unsigned DEFAULT NULL,
  `created` int(11) DEFAULT NULL,
  `token` varbinary(100) DEFAULT NULL,
  `scope` tinyint(4) DEFAULT NULL,
  `depth` tinyint(4) DEFAULT NULL,
  `uri` varbinary(1000) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `token` (`token`),
  KEY `uri` (`uri`(100))
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `au_adav_locks`
--

LOCK TABLES `au_adav_locks` WRITE;
/*!40000 ALTER TABLE `au_adav_locks` DISABLE KEYS */;
/*!40000 ALTER TABLE `au_adav_locks` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `au_adav_propertystorage`
--

DROP TABLE IF EXISTS `au_adav_propertystorage`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `au_adav_propertystorage` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `path` varbinary(1024) NOT NULL,
  `name` varbinary(100) NOT NULL,
  `valuetype` int(10) unsigned DEFAULT NULL,
  `value` mediumblob DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `path_property` (`path`(600),`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `au_adav_propertystorage`
--

LOCK TABLES `au_adav_propertystorage` WRITE;
/*!40000 ALTER TABLE `au_adav_propertystorage` DISABLE KEYS */;
/*!40000 ALTER TABLE `au_adav_propertystorage` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `au_adav_reminders`
--

DROP TABLE IF EXISTS `au_adav_reminders`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `au_adav_reminders` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user` varchar(100) NOT NULL,
  `calendaruri` varchar(255) DEFAULT NULL,
  `eventid` varchar(255) DEFAULT NULL,
  `time` int(11) DEFAULT NULL,
  `starttime` int(11) DEFAULT NULL,
  `allday` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `au_adav_reminders`
--

LOCK TABLES `au_adav_reminders` WRITE;
/*!40000 ALTER TABLE `au_adav_reminders` DISABLE KEYS */;
/*!40000 ALTER TABLE `au_adav_reminders` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `au_adav_schedulingobjects`
--

DROP TABLE IF EXISTS `au_adav_schedulingobjects`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `au_adav_schedulingobjects` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `principaluri` varbinary(255) DEFAULT NULL,
  `calendardata` mediumblob DEFAULT NULL,
  `uri` varbinary(255) DEFAULT NULL,
  `lastmodified` int(11) unsigned DEFAULT NULL,
  `etag` varbinary(32) DEFAULT NULL,
  `size` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `au_adav_schedulingobjects`
--

LOCK TABLES `au_adav_schedulingobjects` WRITE;
/*!40000 ALTER TABLE `au_adav_schedulingobjects` DISABLE KEYS */;
/*!40000 ALTER TABLE `au_adav_schedulingobjects` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `au_eav_attributes_bigint`
--

DROP TABLE IF EXISTS `au_eav_attributes_bigint`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `au_eav_attributes_bigint` (
  `id` bigint(64) unsigned NOT NULL AUTO_INCREMENT,
  `id_entity` bigint(64) unsigned DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `value` bigint(64) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_unique` (`id_entity`,`name`),
  KEY `idx_value` (`value`),
  KEY `idx_name` (`name`),
  KEY `fk_id_entity_idx` (`id_entity`),
  CONSTRAINT `au_fk_eav_attributes_bigint_id_entity` FOREIGN KEY (`id_entity`) REFERENCES `au_eav_entities` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `au_eav_attributes_bigint`
--

LOCK TABLES `au_eav_attributes_bigint` WRITE;
/*!40000 ALTER TABLE `au_eav_attributes_bigint` DISABLE KEYS */;
/*!40000 ALTER TABLE `au_eav_attributes_bigint` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `au_eav_attributes_bool`
--

DROP TABLE IF EXISTS `au_eav_attributes_bool`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `au_eav_attributes_bool` (
  `id` bigint(64) unsigned NOT NULL AUTO_INCREMENT,
  `id_entity` bigint(64) unsigned DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `value` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_unique` (`id_entity`,`name`),
  KEY `idx_value` (`value`),
  KEY `idx_name` (`name`),
  KEY `fk_id_entity_idx` (`id_entity`),
  CONSTRAINT `au_fk_eav_attributes_bool_id_entity` FOREIGN KEY (`id_entity`) REFERENCES `au_eav_entities` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `au_eav_attributes_bool`
--

LOCK TABLES `au_eav_attributes_bool` WRITE;
/*!40000 ALTER TABLE `au_eav_attributes_bool` DISABLE KEYS */;
INSERT INTO `au_eav_attributes_bool` VALUES (1,2,'IsDisabled',0),(3,3,'IncomingUseSsl',0),(4,3,'OutgoingUseSsl',0),(5,3,'EnableSieve',0),(6,3,'EnableThreading',0),(7,3,'UseFullEmailAddressAsLogin',1),(8,3,'SetExternalAccessServers',0),(9,4,'IncomingUseSsl',0),(10,4,'OutgoingUseSsl',0),(11,4,'EnableSieve',0),(12,4,'EnableThreading',0),(13,4,'UseFullEmailAddressAsLogin',1),(14,4,'SetExternalAccessServers',0),(15,8,'IncomingUseSsl',0),(16,8,'OutgoingUseSsl',0),(17,8,'EnableSieve',0),(18,8,'EnableThreading',0),(19,8,'UseFullEmailAddressAsLogin',1),(20,8,'SetExternalAccessServers',0);
/*!40000 ALTER TABLE `au_eav_attributes_bool` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `au_eav_attributes_datetime`
--

DROP TABLE IF EXISTS `au_eav_attributes_datetime`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `au_eav_attributes_datetime` (
  `id` bigint(64) unsigned NOT NULL AUTO_INCREMENT,
  `id_entity` bigint(64) unsigned DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `value` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_unique` (`id_entity`,`name`),
  KEY `idx_value` (`value`),
  KEY `idx_name` (`name`),
  KEY `fk_id_entity_idx` (`id_entity`),
  CONSTRAINT `au_fk_eav_attributes_datetime_id_entity` FOREIGN KEY (`id_entity`) REFERENCES `au_eav_entities` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `au_eav_attributes_datetime`
--

LOCK TABLES `au_eav_attributes_datetime` WRITE;
/*!40000 ALTER TABLE `au_eav_attributes_datetime` DISABLE KEYS */;
/*!40000 ALTER TABLE `au_eav_attributes_datetime` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `au_eav_attributes_double`
--

DROP TABLE IF EXISTS `au_eav_attributes_double`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `au_eav_attributes_double` (
  `id` bigint(64) unsigned NOT NULL AUTO_INCREMENT,
  `id_entity` bigint(64) unsigned DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `value` double DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_unique` (`id_entity`,`name`),
  KEY `idx_name` (`name`),
  KEY `fk_id_entity_idx` (`id_entity`),
  CONSTRAINT `au_fk_eav_attributes_double_id_entity` FOREIGN KEY (`id_entity`) REFERENCES `au_eav_entities` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `au_eav_attributes_double`
--

LOCK TABLES `au_eav_attributes_double` WRITE;
/*!40000 ALTER TABLE `au_eav_attributes_double` DISABLE KEYS */;
/*!40000 ALTER TABLE `au_eav_attributes_double` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `au_eav_attributes_int`
--

DROP TABLE IF EXISTS `au_eav_attributes_int`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `au_eav_attributes_int` (
  `id` bigint(64) unsigned NOT NULL AUTO_INCREMENT,
  `id_entity` bigint(64) unsigned DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `value` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_unique` (`id_entity`,`name`),
  KEY `idx_value` (`value`),
  KEY `idx_name` (`name`),
  KEY `fk_id_entity_idx` (`id_entity`),
  CONSTRAINT `au_fk_eav_attributes_int_id_entity` FOREIGN KEY (`id_entity`) REFERENCES `au_eav_entities` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `au_eav_attributes_int`
--

LOCK TABLES `au_eav_attributes_int` WRITE;
/*!40000 ALTER TABLE `au_eav_attributes_int` DISABLE KEYS */;
INSERT INTO `au_eav_attributes_int` VALUES (1,2,'IdChannel',1),(3,3,'TenantId',0),(4,3,'IncomingPort',143),(5,3,'OutgoingPort',25),(6,3,'SievePort',0),(7,4,'TenantId',0),(8,4,'IncomingPort',143),(9,4,'OutgoingPort',25),(10,4,'SievePort',0),(11,5,'ErrorLoginsCount',1),(12,5,'Time',1691811144),(13,6,'ErrorLoginsCount',1),(14,6,'Time',1691814293),(15,7,'ErrorLoginsCount',1),(16,7,'Time',1691814312),(17,8,'TenantId',0),(18,8,'IncomingPort',143),(19,8,'OutgoingPort',25),(20,8,'SievePort',0);
/*!40000 ALTER TABLE `au_eav_attributes_int` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `au_eav_attributes_mediumblob`
--

DROP TABLE IF EXISTS `au_eav_attributes_mediumblob`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `au_eav_attributes_mediumblob` (
  `id` bigint(64) unsigned NOT NULL AUTO_INCREMENT,
  `id_entity` bigint(64) unsigned DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `value` mediumblob DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_unique` (`id_entity`,`name`),
  KEY `idx_name` (`name`),
  KEY `fk_id_entity_idx` (`id_entity`),
  CONSTRAINT `au_fk_eav_attributes_mediumblob_id_entity` FOREIGN KEY (`id_entity`) REFERENCES `au_eav_entities` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `au_eav_attributes_mediumblob`
--

LOCK TABLES `au_eav_attributes_mediumblob` WRITE;
/*!40000 ALTER TABLE `au_eav_attributes_mediumblob` DISABLE KEYS */;
/*!40000 ALTER TABLE `au_eav_attributes_mediumblob` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `au_eav_attributes_string`
--

DROP TABLE IF EXISTS `au_eav_attributes_string`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `au_eav_attributes_string` (
  `id` bigint(64) unsigned NOT NULL AUTO_INCREMENT,
  `id_entity` bigint(64) unsigned DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `value` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_unique` (`id_entity`,`name`),
  KEY `idx_value` (`value`),
  KEY `idx_name` (`name`),
  KEY `fk_id_entity_idx` (`id_entity`),
  CONSTRAINT `au_fk_eav_attributes_string_id_entity` FOREIGN KEY (`id_entity`) REFERENCES `au_eav_entities` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `au_eav_attributes_string`
--

LOCK TABLES `au_eav_attributes_string` WRITE;
/*!40000 ALTER TABLE `au_eav_attributes_string` DISABLE KEYS */;
INSERT INTO `au_eav_attributes_string` VALUES (1,1,'Login','Default'),(2,1,'Password','4b1c1aa7c5c68e5481ffbbb3a5c52d8d'),(3,2,'Name','Default'),(4,2,'Description',''),(5,2,'WebDomain',''),(9,3,'Name','localhost'),(10,3,'IncomingServer','127.0.0.1'),(11,3,'OutgoingServer','127.0.0.1'),(12,3,'SmtpAuthType','2'),(13,3,'SmtpLogin',''),(14,3,'SmtpPassword',''),(15,3,'OwnerType','superadmin'),(16,4,'Name','localhost'),(17,4,'IncomingServer','127.0.0.1'),(18,4,'OutgoingServer','127.0.0.1'),(19,4,'SmtpAuthType','2'),(20,4,'SmtpLogin',''),(21,4,'SmtpPassword',''),(22,4,'OwnerType','superadmin'),(23,5,'Email','nanoncom'),(24,5,'IpAddress','2403:6200:88a2:47a6:1d23:c3ef:247e:979b'),(25,6,'Email','nanon'),(26,6,'IpAddress','2403:6200:88a2:47a6:1d23:c3ef:247e:979b'),(27,7,'Email','ekkarat@nanon.com'),(28,7,'IpAddress','2403:6200:88a2:47a6:1d23:c3ef:247e:979b'),(29,8,'Name','localhost'),(30,8,'IncomingServer','127.0.0.1'),(31,8,'OutgoingServer','127.0.0.1'),(32,8,'SmtpAuthType','2'),(33,8,'SmtpLogin',''),(34,8,'SmtpPassword',''),(35,8,'OwnerType','superadmin');
/*!40000 ALTER TABLE `au_eav_attributes_string` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `au_eav_attributes_text`
--

DROP TABLE IF EXISTS `au_eav_attributes_text`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `au_eav_attributes_text` (
  `id` bigint(64) unsigned NOT NULL AUTO_INCREMENT,
  `id_entity` bigint(64) unsigned DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `value` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_unique` (`id_entity`,`name`),
  KEY `idx_name` (`name`),
  KEY `fk_id_entity_idx` (`id_entity`),
  CONSTRAINT `au_fk_eav_attributes_text_id_entity` FOREIGN KEY (`id_entity`) REFERENCES `au_eav_entities` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `au_eav_attributes_text`
--

LOCK TABLES `au_eav_attributes_text` WRITE;
/*!40000 ALTER TABLE `au_eav_attributes_text` DISABLE KEYS */;
INSERT INTO `au_eav_attributes_text` VALUES (1,3,'Domains','*'),(2,4,'Domains','*'),(3,8,'Domains','*');
/*!40000 ALTER TABLE `au_eav_attributes_text` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `au_eav_entities`
--

DROP TABLE IF EXISTS `au_eav_entities`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `au_eav_entities` (
  `id` bigint(64) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` char(36) NOT NULL,
  `parent_uuid` char(36) NOT NULL,
  `entity_type` varchar(255) DEFAULT NULL,
  `module_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_uuid` (`uuid`),
  KEY `idx_parent_uuid` (`parent_uuid`),
  KEY `idx_entity_type` (`entity_type`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `au_eav_entities`
--

LOCK TABLES `au_eav_entities` WRITE;
/*!40000 ALTER TABLE `au_eav_entities` DISABLE KEYS */;
INSERT INTO `au_eav_entities` VALUES (1,'f849422d-f572-4efa-8b17-d850c2687d0e','','Aurora\\Modules\\Core\\Classes\\Channel','Core'),(2,'554fa64d-deb0-42cb-b163-e458d75d494d','','Aurora\\Modules\\Core\\Classes\\Tenant','Core'),(3,'f30f9333-95aa-4019-a10d-98c849a79299','','Aurora\\Modules\\Mail\\Classes\\Server','Mail'),(4,'98baa5e1-ed4a-4c31-94bb-1bbfcad85cc0','','Aurora\\Modules\\Mail\\Classes\\Server','Mail'),(5,'8d958bda-2eda-4ead-a2a7-dbba12c6fd6b','','Aurora\\Modules\\Core\\Classes\\UserBlock',''),(6,'bcf966e7-ed5f-4b2b-b97a-6177abb23fbf','','Aurora\\Modules\\Core\\Classes\\UserBlock',''),(7,'5cb4e6bf-d73c-4a6e-80cd-b26327d7647e','','Aurora\\Modules\\Core\\Classes\\UserBlock',''),(8,'ade9ee12-1475-41f5-9d31-f32d7a9080c9','','Aurora\\Modules\\Mail\\Classes\\Server','Mail');
/*!40000 ALTER TABLE `au_eav_entities` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `au_min_hashes`
--

DROP TABLE IF EXISTS `au_min_hashes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `au_min_hashes` (
  `hash_id` varchar(32) NOT NULL DEFAULT '',
  `user_id` bigint(64) DEFAULT NULL,
  `hash` varchar(20) NOT NULL DEFAULT '',
  `data` text DEFAULT NULL,
  `expire_date` int(11) DEFAULT NULL,
  KEY `au_min_hash_index` (`hash`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `au_min_hashes`
--

LOCK TABLES `au_min_hashes` WRITE;
/*!40000 ALTER TABLE `au_min_hashes` DISABLE KEYS */;
/*!40000 ALTER TABLE `au_min_hashes` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2025-10-22 17:15:35

📁 Sid Gifari File Manager