- https://help.nextcloud.com/t/missing-column-calanderdata-in-database/45020/2
- Ejecutar
--
-- Table structure for table `oc_calendar_appt_bookings`
--
DROP TABLE IF EXISTS `oc_calendar_appt_bookings`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `oc_calendar_appt_bookings` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`appt_config_id` bigint unsigned NOT NULL,
`created_at` int NOT NULL,
`token` varchar(32) COLLATE utf8mb4_bin NOT NULL,
`display_name` varchar(128) COLLATE utf8mb4_bin NOT NULL,
`description` longtext COLLATE utf8mb4_bin,
`email` varchar(128) COLLATE utf8mb4_bin NOT NULL,
`start` int NOT NULL,
`end` int NOT NULL,
`timezone` varchar(32) COLLATE utf8mb4_bin NOT NULL,
`confirmed` tinyint(1) DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `cal_appt_bk_token_uniq_idx` (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `oc_calendar_appt_bookings`
--
LOCK TABLES `oc_calendar_appt_bookings` WRITE;
/*!40000 ALTER TABLE `oc_calendar_appt_bookings` DISABLE KEYS */;
/*!40000 ALTER TABLE `oc_calendar_appt_bookings` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `oc_calendar_appt_configs`
--
DROP TABLE IF EXISTS `oc_calendar_appt_configs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `oc_calendar_appt_configs` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`token` varchar(128) COLLATE utf8mb4_bin NOT NULL,
`name` varchar(128) COLLATE utf8mb4_bin NOT NULL,
`description` longtext COLLATE utf8mb4_bin,
`location` longtext COLLATE utf8mb4_bin,
`visibility` varchar(10) COLLATE utf8mb4_bin NOT NULL,
`user_id` varchar(64) COLLATE utf8mb4_bin NOT NULL,
`target_calendar_uri` varchar(255) COLLATE utf8mb4_bin NOT NULL,
`calendar_freebusy_uris` longtext COLLATE utf8mb4_bin,
`availability` longtext COLLATE utf8mb4_bin,
`start` int DEFAULT NULL,
`end` int DEFAULT NULL,
`length` int NOT NULL,
`increment` int NOT NULL,
`preparation_duration` int NOT NULL DEFAULT '0',
`followup_duration` int NOT NULL DEFAULT '0',
`time_before_next_slot` int DEFAULT NULL,
`daily_max` int DEFAULT NULL,
`future_limit` int DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `cal_appt_token_uniq_idx` (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `oc_calendar_appt_configs`
--
LOCK TABLES `oc_calendar_appt_configs` WRITE;
/*!40000 ALTER TABLE `oc_calendar_appt_configs` DISABLE KEYS */;
/*!40000 ALTER TABLE `oc_calendar_appt_configs` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `oc_calendar_invitations`
--
DROP TABLE IF EXISTS `oc_calendar_invitations`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `oc_calendar_invitations` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`uid` varchar(255) COLLATE utf8mb4_bin NOT NULL,
`recurrenceid` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`attendee` varchar(255) COLLATE utf8mb4_bin NOT NULL,
`organizer` varchar(255) COLLATE utf8mb4_bin NOT NULL,
`sequence` bigint unsigned DEFAULT NULL,
`token` varchar(60) COLLATE utf8mb4_bin NOT NULL,
`expiration` bigint unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `calendar_invitation_tokens` (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `oc_calendar_invitations`
--
LOCK TABLES `oc_calendar_invitations` WRITE;
/*!40000 ALTER TABLE `oc_calendar_invitations` DISABLE KEYS */;
/*!40000 ALTER TABLE `oc_calendar_invitations` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `oc_calendar_reminders`
--
DROP TABLE IF EXISTS `oc_calendar_reminders`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `oc_calendar_reminders` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`calendar_id` bigint NOT NULL,
`object_id` bigint NOT NULL,
`is_recurring` smallint DEFAULT NULL,
`uid` varchar(255) COLLATE utf8mb4_bin NOT NULL,
`recurrence_id` bigint unsigned DEFAULT NULL,
`is_recurrence_exception` smallint NOT NULL,
`event_hash` varchar(255) COLLATE utf8mb4_bin NOT NULL,
`alarm_hash` varchar(255) COLLATE utf8mb4_bin NOT NULL,
`type` varchar(255) COLLATE utf8mb4_bin NOT NULL,
`is_relative` smallint NOT NULL,
`notification_date` bigint unsigned NOT NULL,
`is_repeat_based` smallint NOT NULL,
PRIMARY KEY (`id`),
KEY `calendar_reminder_objid` (`object_id`),
KEY `calendar_reminder_uidrec` (`uid`,`recurrence_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `oc_calendar_reminders`
--
LOCK TABLES `oc_calendar_reminders` WRITE;
/*!40000 ALTER TABLE `oc_calendar_reminders` DISABLE KEYS */;
/*!40000 ALTER TABLE `oc_calendar_reminders` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `oc_calendar_resources`
--
DROP TABLE IF EXISTS `oc_calendar_resources`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `oc_calendar_resources` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`backend_id` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL,
`resource_id` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL,
`email` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`displayname` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`group_restrictions` varchar(4000) COLLATE utf8mb4_bin DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `calendar_resources_bkdrsc` (`backend_id`,`resource_id`),
KEY `calendar_resources_email` (`email`),
KEY `calendar_resources_name` (`displayname`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `oc_calendar_resources`
--
LOCK TABLES `oc_calendar_resources` WRITE;
/*!40000 ALTER TABLE `oc_calendar_resources` DISABLE KEYS */;
/*!40000 ALTER TABLE `oc_calendar_resources` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `oc_calendar_resources_md`
--
DROP TABLE IF EXISTS `oc_calendar_resources_md`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `oc_calendar_resources_md` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`resource_id` bigint unsigned NOT NULL,
`key` varchar(255) COLLATE utf8mb4_bin NOT NULL,
`value` varchar(4000) COLLATE utf8mb4_bin DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `calendar_resources_md_idk` (`resource_id`,`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `oc_calendar_resources_md`
--
LOCK TABLES `oc_calendar_resources_md` WRITE;
/*!40000 ALTER TABLE `oc_calendar_resources_md` DISABLE KEYS */;
/*!40000 ALTER TABLE `oc_calendar_resources_md` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `oc_calendar_rooms`
--
DROP TABLE IF EXISTS `oc_calendar_rooms`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `oc_calendar_rooms` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`backend_id` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL,
`resource_id` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL,
`email` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`displayname` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`group_restrictions` varchar(4000) COLLATE utf8mb4_bin DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `calendar_rooms_bkdrsc` (`backend_id`,`resource_id`),
KEY `calendar_rooms_email` (`email`),
KEY `calendar_rooms_name` (`displayname`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `oc_calendar_rooms`
--
LOCK TABLES `oc_calendar_rooms` WRITE;
/*!40000 ALTER TABLE `oc_calendar_rooms` DISABLE KEYS */;
/*!40000 ALTER TABLE `oc_calendar_rooms` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `oc_calendar_rooms_md`
--
DROP TABLE IF EXISTS `oc_calendar_rooms_md`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `oc_calendar_rooms_md` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`room_id` bigint unsigned NOT NULL,
`key` varchar(255) COLLATE utf8mb4_bin NOT NULL,
`value` varchar(4000) COLLATE utf8mb4_bin DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `calendar_rooms_md_idk` (`room_id`,`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `oc_calendar_rooms_md`
--
LOCK TABLES `oc_calendar_rooms_md` WRITE;
/*!40000 ALTER TABLE `oc_calendar_rooms_md` DISABLE KEYS */;
/*!40000 ALTER TABLE `oc_calendar_rooms_md` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `oc_calendarchanges`
--
DROP TABLE IF EXISTS `oc_calendarchanges`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `oc_calendarchanges` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`uri` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`synctoken` int unsigned NOT NULL DEFAULT '1',
`calendarid` bigint NOT NULL,
`operation` smallint NOT NULL,
`calendartype` int NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `calid_type_synctoken` (`calendarid`,`calendartype`,`synctoken`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `oc_calendarchanges`
--
LOCK TABLES `oc_calendarchanges` WRITE;
/*!40000 ALTER TABLE `oc_calendarchanges` DISABLE KEYS */;
/*!40000 ALTER TABLE `oc_calendarchanges` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `oc_calendarobjects`
--
DROP TABLE IF EXISTS `oc_calendarobjects`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `oc_calendarobjects` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`calendardata` longblob,
`uri` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`calendarid` bigint unsigned NOT NULL,
`lastmodified` int unsigned DEFAULT NULL,
`etag` varchar(32) COLLATE utf8mb4_bin DEFAULT NULL,
`size` bigint unsigned NOT NULL,
`componenttype` varchar(8) COLLATE utf8mb4_bin DEFAULT NULL,
`firstoccurence` bigint unsigned DEFAULT NULL,
`lastoccurence` bigint unsigned DEFAULT NULL,
`uid` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`classification` int DEFAULT '0',
`calendartype` int NOT NULL DEFAULT '0',
`deleted_at` int unsigned DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `calobjects_index` (`calendarid`,`calendartype`,`uri`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `oc_calendarobjects`
--
LOCK TABLES `oc_calendarobjects` WRITE;
/*!40000 ALTER TABLE `oc_calendarobjects` DISABLE KEYS */;
/*!40000 ALTER TABLE `oc_calendarobjects` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `oc_calendarobjects_props`
--
DROP TABLE IF EXISTS `oc_calendarobjects_props`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `oc_calendarobjects_props` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`calendarid` bigint NOT NULL DEFAULT '0',
`objectid` bigint unsigned NOT NULL DEFAULT '0',
`name` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL,
`parameter` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL,
`value` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`calendartype` int NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `calendarobject_index` (`objectid`,`calendartype`),
KEY `calendarobject_name_index` (`name`,`calendartype`),
KEY `calendarobject_value_index` (`value`,`calendartype`),
KEY `calendarobject_calid_index` (`calendarid`,`calendartype`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `oc_calendarobjects_props`
--
LOCK TABLES `oc_calendarobjects_props` WRITE;
/*!40000 ALTER TABLE `oc_calendarobjects_props` DISABLE KEYS */;
/*!40000 ALTER TABLE `oc_calendarobjects_props` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `oc_calendars`
--
DROP TABLE IF EXISTS `oc_calendars`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `oc_calendars` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`principaluri` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`displayname` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`uri` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`synctoken` int unsigned NOT NULL DEFAULT '1',
`description` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`calendarorder` int unsigned NOT NULL DEFAULT '0',
`calendarcolor` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`timezone` longtext COLLATE utf8mb4_bin,
`components` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL,
`transparent` smallint NOT NULL DEFAULT '0',
`deleted_at` int unsigned DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `calendars_index` (`principaluri`,`uri`),
KEY `cals_princ_del_idx` (`principaluri`,`deleted_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `oc_calendars`
--
LOCK TABLES `oc_calendars` WRITE;
/*!40000 ALTER TABLE `oc_calendars` DISABLE KEYS */;
/*!40000 ALTER TABLE `oc_calendars` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `oc_calendarsubscriptions`
--
DROP TABLE IF EXISTS `oc_calendarsubscriptions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `oc_calendarsubscriptions` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`uri` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`principaluri` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`displayname` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL,
`refreshrate` varchar(10) COLLATE utf8mb4_bin DEFAULT NULL,
`calendarorder` int unsigned NOT NULL DEFAULT '0',
`calendarcolor` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`striptodos` smallint DEFAULT NULL,
`stripalarms` smallint DEFAULT NULL,
`stripattachments` smallint DEFAULT NULL,
`lastmodified` int unsigned DEFAULT NULL,
`synctoken` int unsigned NOT NULL DEFAULT '1',
`source` longtext COLLATE utf8mb4_bin,
PRIMARY KEY (`id`),
UNIQUE KEY `calsub_index` (`principaluri`,`uri`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `oc_calendarsubscriptions`
--
LOCK TABLES `oc_calendarsubscriptions` WRITE;
/*!40000 ALTER TABLE `oc_calendarsubscriptions` DISABLE KEYS */;
/*!40000 ALTER TABLE `oc_calendarsubscriptions` ENABLE KEYS */;
UNLOCK TABLES;
ED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
CREATE TABLE oc_calendar_resources (
id bigint(20) UNSIGNED NOT NULL,
backend_id varchar(64) COLLATE utf8_bin DEFAULT NULL,
resource_id varchar(64) COLLATE utf8_bin DEFAULT NULL,
email varchar(255) COLLATE utf8_bin DEFAULT NULL,
displayname varchar(255) COLLATE utf8_bin DEFAULT NULL,
group_restrictions varchar(4000) COLLATE utf8_bin DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
CREATE TABLE oc_calendar_rooms (
id bigint(20) UNSIGNED NOT NULL,
backend_id varchar(64) COLLATE utf8_bin DEFAULT NULL,
resource_id varchar(64) COLLATE utf8_bin DEFAULT NULL,
email varchar(255) COLLATE utf8_bin DEFAULT NULL,
displayname varchar(255) COLLATE utf8_bin DEFAULT NULL,
group_restrictions varchar(4000) COLLATE utf8_bin DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;