Missing table oc_dav_cal_proxy

ℹ️ Support
1

Hello !

I got an error in logs : Table ‘cloud.oc_dav_cal_proxy’ doesn’t exist
Anyone can give me the code create for this table ? That was accidently deleted…

Thanks !

2 
--
-- Table structure for table `oc_dav_cal_proxy`
--

CREATE TABLE `oc_dav_cal_proxy` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `owner_id` varchar(64) COLLATE utf8_bin NOT NULL,
  `proxy_id` varchar(64) COLLATE utf8_bin NOT NULL,
  `permissions` int(10) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Indexes for table `oc_dav_cal_proxy`
--
ALTER TABLE `oc_dav_cal_proxy`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `dav_cal_proxy_uidx` (`owner_id`,`proxy_id`,`permissions`),
  ADD KEY `dav_cal_proxy_ioid` (`owner_id`),
  ADD KEY `dav_cal_proxy_ipid` (`proxy_id`);

--
-- AUTO_INCREMENT for table `oc_dav_cal_proxy`
--
ALTER TABLE `oc_dav_cal_proxy`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
COMMIT;
3

Thanks @hartmut001 ! This error is solved.
I got the same problem for the table oc_dav_shares :
Table ‘cloud.oc_dav_shares’ doesn’t exist

Anyone can give me the code create ?

4

Ist das die letzte? :smirk:

--
-- Table structure for table `oc_dav_shares`
--

CREATE TABLE `oc_dav_shares` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `principaluri` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `type` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `access` smallint(6) DEFAULT NULL,
  `resourceid` bigint(20) UNSIGNED NOT NULL,
  `publicuri` varchar(255) COLLATE utf8_bin DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Indexes for table `oc_dav_shares`
--
ALTER TABLE `oc_dav_shares`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `dav_shares_index` (`principaluri`,`resourceid`,`type`,`publicuri`);

--
-- AUTO_INCREMENT for table `oc_dav_shares`
--
ALTER TABLE `oc_dav_shares`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
COMMIT;
5

Thanks ! This problem is solved :slight_smile: