source: lliurex-owncloud/trunk/fuentes/install-files/usr/share/lliurex-owncloud/llx-data/owncloud.sql @ 3228

Last change on this file since 3228 was 3228, checked in by jrpelegrina, 4 years ago

Wip in new version of owncloud_9.1.3

File size: 53.5 KB
Line 
1-- MySQL dump 10.13  Distrib 5.7.15, for Linux (x86_64)
2--
3-- Host: localhost    Database: owncloud
4-- ------------------------------------------------------
5-- Server version       5.7.15-0ubuntu0.16.04.1
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `oc_activity`
20--
21
22DROP TABLE IF EXISTS `oc_activity`;
23/*!40101 SET @saved_cs_client     = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `oc_activity` (
26  `activity_id` int(11) NOT NULL AUTO_INCREMENT,
27  `timestamp` int(11) NOT NULL DEFAULT '0',
28  `priority` int(11) NOT NULL DEFAULT '0',
29  `type` varchar(255) COLLATE utf8_bin DEFAULT NULL,
30  `user` varchar(64) COLLATE utf8_bin DEFAULT NULL,
31  `affecteduser` varchar(64) COLLATE utf8_bin NOT NULL,
32  `app` varchar(255) COLLATE utf8_bin NOT NULL,
33  `subject` varchar(255) COLLATE utf8_bin NOT NULL,
34  `subjectparams` varchar(4000) COLLATE utf8_bin NOT NULL,
35  `message` varchar(255) COLLATE utf8_bin DEFAULT NULL,
36  `messageparams` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
37  `file` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
38  `link` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
39  `object_type` varchar(255) COLLATE utf8_bin DEFAULT NULL,
40  `object_id` int(11) NOT NULL DEFAULT '0',
41  PRIMARY KEY (`activity_id`),
42  KEY `activity_time` (`timestamp`),
43  KEY `activity_user_time` (`affecteduser`,`timestamp`),
44  KEY `activity_filter_by` (`affecteduser`,`user`,`timestamp`),
45  KEY `activity_filter_app` (`affecteduser`,`app`,`timestamp`),
46  KEY `activity_object` (`object_type`,`object_id`)
47) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
48/*!40101 SET character_set_client = @saved_cs_client */;
49
50--
51-- Dumping data for table `oc_activity`
52--
53
54LOCK TABLES `oc_activity` WRITE;
55/*!40000 ALTER TABLE `oc_activity` DISABLE KEYS */;
56/*!40000 ALTER TABLE `oc_activity` ENABLE KEYS */;
57UNLOCK TABLES;
58
59--
60-- Table structure for table `oc_activity_mq`
61--
62
63DROP TABLE IF EXISTS `oc_activity_mq`;
64/*!40101 SET @saved_cs_client     = @@character_set_client */;
65/*!40101 SET character_set_client = utf8 */;
66CREATE TABLE `oc_activity_mq` (
67  `mail_id` int(11) NOT NULL AUTO_INCREMENT,
68  `amq_timestamp` int(11) NOT NULL DEFAULT '0',
69  `amq_latest_send` int(11) NOT NULL DEFAULT '0',
70  `amq_type` varchar(255) COLLATE utf8_bin NOT NULL,
71  `amq_affecteduser` varchar(64) COLLATE utf8_bin NOT NULL,
72  `amq_appid` varchar(255) COLLATE utf8_bin NOT NULL,
73  `amq_subject` varchar(255) COLLATE utf8_bin NOT NULL,
74  `amq_subjectparams` varchar(4000) COLLATE utf8_bin NOT NULL,
75  PRIMARY KEY (`mail_id`),
76  KEY `amp_user` (`amq_affecteduser`),
77  KEY `amp_latest_send_time` (`amq_latest_send`),
78  KEY `amp_timestamp_time` (`amq_timestamp`)
79) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
80/*!40101 SET character_set_client = @saved_cs_client */;
81
82--
83-- Dumping data for table `oc_activity_mq`
84--
85
86LOCK TABLES `oc_activity_mq` WRITE;
87/*!40000 ALTER TABLE `oc_activity_mq` DISABLE KEYS */;
88/*!40000 ALTER TABLE `oc_activity_mq` ENABLE KEYS */;
89UNLOCK TABLES;
90
91--
92-- Table structure for table `oc_addressbookchanges`
93--
94
95DROP TABLE IF EXISTS `oc_addressbookchanges`;
96/*!40101 SET @saved_cs_client     = @@character_set_client */;
97/*!40101 SET character_set_client = utf8 */;
98CREATE TABLE `oc_addressbookchanges` (
99  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
100  `uri` varchar(255) COLLATE utf8_bin DEFAULT NULL,
101  `synctoken` int(10) unsigned NOT NULL DEFAULT '1',
102  `addressbookid` int(11) NOT NULL,
103  `operation` smallint(6) NOT NULL,
104  PRIMARY KEY (`id`),
105  KEY `addressbookid_synctoken` (`addressbookid`,`synctoken`)
106) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
107/*!40101 SET character_set_client = @saved_cs_client */;
108
109--
110-- Dumping data for table `oc_addressbookchanges`
111--
112
113LOCK TABLES `oc_addressbookchanges` WRITE;
114/*!40000 ALTER TABLE `oc_addressbookchanges` DISABLE KEYS */;
115/*!40000 ALTER TABLE `oc_addressbookchanges` ENABLE KEYS */;
116UNLOCK TABLES;
117
118--
119-- Table structure for table `oc_addressbooks`
120--
121
122DROP TABLE IF EXISTS `oc_addressbooks`;
123/*!40101 SET @saved_cs_client     = @@character_set_client */;
124/*!40101 SET character_set_client = utf8 */;
125CREATE TABLE `oc_addressbooks` (
126  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
127  `principaluri` varchar(255) COLLATE utf8_bin DEFAULT NULL,
128  `displayname` varchar(255) COLLATE utf8_bin DEFAULT NULL,
129  `uri` varchar(255) COLLATE utf8_bin DEFAULT NULL,
130  `description` varchar(255) COLLATE utf8_bin DEFAULT NULL,
131  `synctoken` int(10) unsigned NOT NULL DEFAULT '1',
132  PRIMARY KEY (`id`),
133  UNIQUE KEY `addressbook_index` (`principaluri`,`uri`)
134) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
135/*!40101 SET character_set_client = @saved_cs_client */;
136
137--
138-- Dumping data for table `oc_addressbooks`
139--
140
141LOCK TABLES `oc_addressbooks` WRITE;
142/*!40000 ALTER TABLE `oc_addressbooks` DISABLE KEYS */;
143/*!40000 ALTER TABLE `oc_addressbooks` ENABLE KEYS */;
144UNLOCK TABLES;
145
146--
147-- Table structure for table `oc_appconfig`
148--
149
150DROP TABLE IF EXISTS `oc_appconfig`;
151/*!40101 SET @saved_cs_client     = @@character_set_client */;
152/*!40101 SET character_set_client = utf8 */;
153CREATE TABLE `oc_appconfig` (
154  `appid` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
155  `configkey` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
156  `configvalue` longtext COLLATE utf8_bin,
157  PRIMARY KEY (`appid`,`configkey`),
158  KEY `appconfig_config_key_index` (`configkey`),
159  KEY `appconfig_appid_key` (`appid`)
160) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
161/*!40101 SET character_set_client = @saved_cs_client */;
162
163--
164-- Dumping data for table `oc_appconfig`
165--
166
167LOCK TABLES `oc_appconfig` WRITE;
168/*!40000 ALTER TABLE `oc_appconfig` DISABLE KEYS */;
169INSERT INTO `oc_appconfig` VALUES ('activity','enabled','yes'),('activity','installed_version','2.3.2'),('activity','types','filesystem'),('backgroundjob','lastjob','12'),('comments','enabled','yes'),('comments','installed_version','0.3.0'),('comments','types','logging'),('core','installedat','1483963185.0056'),('core','lastcron','1484051001'),('core','lastupdateResult','[]'),('core','lastupdatedat','1484035499'),('core','oc.integritycheck.checker','[]'),('core','public_files','files_sharing/public.php'),('core','public_webdav','dav/appinfo/v1/publicwebdav.php'),('dav','enabled','yes'),('dav','installed_version','0.2.7'),('dav','types','filesystem'),('federatedfilesharing','enabled','yes'),('federatedfilesharing','installed_version','0.3.0'),('federatedfilesharing','types',''),('federation','enabled','yes'),('federation','installed_version','0.1.0'),('federation','types','authentication'),('files','cronjob_scan_files','500'),('files','enabled','yes'),('files','installed_version','1.5.1'),('files','types','filesystem'),('files_pdfviewer','enabled','yes'),('files_pdfviewer','installed_version','0.8.1'),('files_pdfviewer','ocsid','166049'),('files_pdfviewer','types',''),('files_sharing','enabled','yes'),('files_sharing','installed_version','0.10.0'),('files_sharing','types','filesystem'),('files_texteditor','enabled','yes'),('files_texteditor','installed_version','2.1'),('files_texteditor','ocsid','166051'),('files_texteditor','types',''),('files_trashbin','enabled','yes'),('files_trashbin','installed_version','0.9.0'),('files_trashbin','types','filesystem'),('files_versions','enabled','yes'),('files_versions','installed_version','1.3.0'),('files_versions','types','filesystem'),('files_videoplayer','enabled','yes'),('files_videoplayer','installed_version','0.9.8'),('files_videoplayer','types',''),('firstrunwizard','enabled','yes'),('firstrunwizard','installed_version','1.1'),('firstrunwizard','ocsid','166055'),('firstrunwizard','types',''),('gallery','enabled','yes'),('gallery','installed_version','15.0.0'),('gallery','types',''),('notifications','enabled','yes'),('notifications','installed_version','0.3.0'),('notifications','types','logging'),('provisioning_api','enabled','yes'),('provisioning_api','installed_version','0.5.0'),('provisioning_api','types','prevent_group_restriction'),('systemtags','enabled','yes'),('systemtags','installed_version','0.3.0'),('systemtags','types','logging'),('templateeditor','enabled','yes'),('templateeditor','installed_version','0.1'),('templateeditor','types',''),('updatenotification','enabled','yes'),('updatenotification','installed_version','0.2.1'),('updatenotification','types',''),('user_ldap','enabled','yes'),('user_ldap','has_memberof_filter_support',''),('user_ldap','home_folder_naming_rule',''),('user_ldap','installed_version','0.9.0'),('user_ldap','last_jpegPhoto_lookup','0'),('user_ldap','ldap_agent_password',''),('user_ldap','ldap_attributes_for_group_search',''),('user_ldap','ldap_attributes_for_user_search',''),('user_ldap','ldap_backup_host',''),('user_ldap','ldap_backup_port',''),('user_ldap','ldap_base','{{LDAP_BASE_USER_TREE}}'),('user_ldap','ldap_base_groups','{{LDAP_BASE_GROUP_TREE}}'),('user_ldap','ldap_base_users','{{LDAP_BASE_USER_TREE}}'),('user_ldap','ldap_cache_ttl','600'),('user_ldap','ldap_configuration_active','1'),('user_ldap','ldap_display_name','cn'),('user_ldap','ldap_dn',''),('user_ldap','ldap_dynamic_group_member_url',''),('user_ldap','ldap_email_attr',''),('user_ldap','ldap_experienced_admin','0'),('user_ldap','ldap_expert_username_attr',''),('user_ldap','ldap_expert_uuid_group_attr','cn'),('user_ldap','ldap_expert_uuid_user_attr','uid'),('user_ldap','ldap_group_display_name','cn'),('user_ldap','ldap_group_filter','(objectclass=x-lliurex-group)'),('user_ldap','ldap_group_filter_mode','1'),('user_ldap','ldap_group_member_assoc_attribute','memberUid'),('user_ldap','ldap_groupfilter_groups',''),('user_ldap','ldap_groupfilter_objectclass',''),('user_ldap','ldap_host','ldap://localhost'),('user_ldap','ldap_login_filter','(&(|(objectclass=person))(uid=%uid))'),('user_ldap','ldap_login_filter_mode','0'),('user_ldap','ldap_loginfilter_attributes',''),('user_ldap','ldap_loginfilter_email','0'),('user_ldap','ldap_loginfilter_username','1'),('user_ldap','ldap_nested_groups','0'),('user_ldap','ldap_override_main_server',''),('user_ldap','ldap_paging_size','500'),('user_ldap','ldap_port','389'),('user_ldap','ldap_quota_attr',''),('user_ldap','ldap_quota_def',''),('user_ldap','ldap_tls','1'),('user_ldap','ldap_turn_off_cert_check','0'),('user_ldap','ldap_user_display_name_2',''),('user_ldap','ldap_user_filter_mode','1'),('user_ldap','ldap_userfilter_groups',''),('user_ldap','ldap_userfilter_objectclass','posixAccount'),('user_ldap','ldap_userlist_filter','(objectclass=*)'),('user_ldap','types','authentication'),('user_ldap','use_memberof_to_detect_membership','1');
170/*!40000 ALTER TABLE `oc_appconfig` ENABLE KEYS */;
171UNLOCK TABLES;
172
173--
174-- Table structure for table `oc_authtoken`
175--
176
177DROP TABLE IF EXISTS `oc_authtoken`;
178/*!40101 SET @saved_cs_client     = @@character_set_client */;
179/*!40101 SET character_set_client = utf8 */;
180CREATE TABLE `oc_authtoken` (
181  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
182  `uid` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
183  `login_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
184  `password` longtext COLLATE utf8_bin,
185  `name` longtext COLLATE utf8_bin NOT NULL,
186  `token` varchar(200) COLLATE utf8_bin NOT NULL DEFAULT '',
187  `type` smallint(5) unsigned NOT NULL DEFAULT '0',
188  `last_activity` int(10) unsigned NOT NULL DEFAULT '0',
189  `last_check` int(10) unsigned NOT NULL DEFAULT '0',
190  PRIMARY KEY (`id`),
191  UNIQUE KEY `authtoken_token_index` (`token`),
192  KEY `authtoken_last_activity_index` (`last_activity`)
193) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
194/*!40101 SET character_set_client = @saved_cs_client */;
195
196--
197-- Dumping data for table `oc_authtoken`
198--
199
200LOCK TABLES `oc_authtoken` WRITE;
201/*!40000 ALTER TABLE `oc_authtoken` DISABLE KEYS */;
202INSERT INTO `oc_authtoken` VALUES (1,'owncloud_admin','owncloud_admin','f5a6c14174072369af3e8c508407ad91|kv8NaZIuBwy/o6pv|f2a146fc8d205efc99649af3f297f078f30af0e95348588c2ec0fd3173ae5c9fb1f2b7b725793631e9b6e6951ed03ae9650f42620577ec942f55d2a87b021378','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:49.0) Gecko/20100101 Firefox/49.0','36c07888d583371a3e38c98406d0cc007446b241ff914ee011dfb504a6f6fdb4c13d5a72aee4e92e79bab66e238f1fdc3f19d030c46532c884219b875e74fc78',0,1483963362,1483963195),(3,'owncloud_admin','owncloud_admin','035261d6f12473e525d5c270df452d75|K652fuQ7DwrvULDL|ee76cc2fae49297babb25c713097bef5565aa8a429d4d80902c56bbefb2bbd38b5cdc6890fae0bac4b8c0a2eb7fe6839a823e6e72e1a5de50fffb3c59baa1512','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:48.0) Gecko/20100101 Firefox/48.0','84707555a9511e8fb309e011d9a619a8d8755acd95dde098b08bd2c6c5119f19cf785b14f217515e910e30f9ea3c743366a5872106c5c7925e3207477740070e',0,1484051451,1484051181);
203/*!40000 ALTER TABLE `oc_authtoken` ENABLE KEYS */;
204UNLOCK TABLES;
205
206--
207-- Table structure for table `oc_calendarchanges`
208--
209
210DROP TABLE IF EXISTS `oc_calendarchanges`;
211/*!40101 SET @saved_cs_client     = @@character_set_client */;
212/*!40101 SET character_set_client = utf8 */;
213CREATE TABLE `oc_calendarchanges` (
214  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
215  `uri` varchar(255) COLLATE utf8_bin DEFAULT NULL,
216  `synctoken` int(10) unsigned NOT NULL DEFAULT '1',
217  `calendarid` int(11) NOT NULL,
218  `operation` smallint(6) NOT NULL,
219  PRIMARY KEY (`id`),
220  KEY `calendarid_synctoken` (`calendarid`,`synctoken`)
221) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
222/*!40101 SET character_set_client = @saved_cs_client */;
223
224--
225-- Dumping data for table `oc_calendarchanges`
226--
227
228LOCK TABLES `oc_calendarchanges` WRITE;
229/*!40000 ALTER TABLE `oc_calendarchanges` DISABLE KEYS */;
230/*!40000 ALTER TABLE `oc_calendarchanges` ENABLE KEYS */;
231UNLOCK TABLES;
232
233--
234-- Table structure for table `oc_calendarobjects`
235--
236
237DROP TABLE IF EXISTS `oc_calendarobjects`;
238/*!40101 SET @saved_cs_client     = @@character_set_client */;
239/*!40101 SET character_set_client = utf8 */;
240CREATE TABLE `oc_calendarobjects` (
241  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
242  `calendardata` longblob,
243  `uri` varchar(255) COLLATE utf8_bin DEFAULT NULL,
244  `calendarid` int(10) unsigned NOT NULL,
245  `lastmodified` int(10) unsigned DEFAULT NULL,
246  `etag` varchar(32) COLLATE utf8_bin DEFAULT NULL,
247  `size` bigint(20) unsigned NOT NULL,
248  `componenttype` varchar(8) COLLATE utf8_bin DEFAULT NULL,
249  `firstoccurence` bigint(20) unsigned DEFAULT NULL,
250  `lastoccurence` bigint(20) unsigned DEFAULT NULL,
251  `uid` varchar(255) COLLATE utf8_bin DEFAULT NULL,
252  `classification` int(11) DEFAULT '0' COMMENT '0 - public, 1 - private, 2 - confidential',
253  PRIMARY KEY (`id`),
254  UNIQUE KEY `calobjects_index` (`calendarid`,`uri`)
255) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
256/*!40101 SET character_set_client = @saved_cs_client */;
257
258--
259-- Dumping data for table `oc_calendarobjects`
260--
261
262LOCK TABLES `oc_calendarobjects` WRITE;
263/*!40000 ALTER TABLE `oc_calendarobjects` DISABLE KEYS */;
264/*!40000 ALTER TABLE `oc_calendarobjects` ENABLE KEYS */;
265UNLOCK TABLES;
266
267--
268-- Table structure for table `oc_calendars`
269--
270
271DROP TABLE IF EXISTS `oc_calendars`;
272/*!40101 SET @saved_cs_client     = @@character_set_client */;
273/*!40101 SET character_set_client = utf8 */;
274CREATE TABLE `oc_calendars` (
275  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
276  `principaluri` varchar(255) COLLATE utf8_bin DEFAULT NULL,
277  `displayname` varchar(255) COLLATE utf8_bin DEFAULT NULL,
278  `uri` varchar(255) COLLATE utf8_bin DEFAULT NULL,
279  `synctoken` int(10) unsigned NOT NULL DEFAULT '1',
280  `description` varchar(255) COLLATE utf8_bin DEFAULT NULL,
281  `calendarorder` int(10) unsigned NOT NULL DEFAULT '0',
282  `calendarcolor` varchar(255) COLLATE utf8_bin DEFAULT NULL,
283  `timezone` longtext COLLATE utf8_bin,
284  `components` varchar(20) COLLATE utf8_bin DEFAULT NULL,
285  `transparent` smallint(6) NOT NULL DEFAULT '0',
286  PRIMARY KEY (`id`),
287  UNIQUE KEY `calendars_index` (`principaluri`,`uri`)
288) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
289/*!40101 SET character_set_client = @saved_cs_client */;
290
291--
292-- Dumping data for table `oc_calendars`
293--
294
295LOCK TABLES `oc_calendars` WRITE;
296/*!40000 ALTER TABLE `oc_calendars` DISABLE KEYS */;
297/*!40000 ALTER TABLE `oc_calendars` ENABLE KEYS */;
298UNLOCK TABLES;
299
300--
301-- Table structure for table `oc_calendarsubscriptions`
302--
303
304DROP TABLE IF EXISTS `oc_calendarsubscriptions`;
305/*!40101 SET @saved_cs_client     = @@character_set_client */;
306/*!40101 SET character_set_client = utf8 */;
307CREATE TABLE `oc_calendarsubscriptions` (
308  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
309  `uri` varchar(255) COLLATE utf8_bin DEFAULT NULL,
310  `principaluri` varchar(255) COLLATE utf8_bin DEFAULT NULL,
311  `source` varchar(255) COLLATE utf8_bin DEFAULT NULL,
312  `displayname` varchar(100) COLLATE utf8_bin DEFAULT NULL,
313  `refreshrate` varchar(10) COLLATE utf8_bin DEFAULT NULL,
314  `calendarorder` int(10) unsigned NOT NULL DEFAULT '0',
315  `calendarcolor` varchar(255) COLLATE utf8_bin DEFAULT NULL,
316  `striptodos` smallint(6) DEFAULT NULL,
317  `stripalarms` smallint(6) DEFAULT NULL,
318  `stripattachments` smallint(6) DEFAULT NULL,
319  `lastmodified` int(10) unsigned DEFAULT NULL,
320  PRIMARY KEY (`id`),
321  UNIQUE KEY `calsub_index` (`principaluri`,`uri`)
322) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
323/*!40101 SET character_set_client = @saved_cs_client */;
324
325--
326-- Dumping data for table `oc_calendarsubscriptions`
327--
328
329LOCK TABLES `oc_calendarsubscriptions` WRITE;
330/*!40000 ALTER TABLE `oc_calendarsubscriptions` DISABLE KEYS */;
331/*!40000 ALTER TABLE `oc_calendarsubscriptions` ENABLE KEYS */;
332UNLOCK TABLES;
333
334--
335-- Table structure for table `oc_cards`
336--
337
338DROP TABLE IF EXISTS `oc_cards`;
339/*!40101 SET @saved_cs_client     = @@character_set_client */;
340/*!40101 SET character_set_client = utf8 */;
341CREATE TABLE `oc_cards` (
342  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
343  `addressbookid` int(11) NOT NULL DEFAULT '0',
344  `carddata` longblob,
345  `uri` varchar(255) COLLATE utf8_bin DEFAULT NULL,
346  `lastmodified` bigint(20) unsigned DEFAULT NULL,
347  `etag` varchar(32) COLLATE utf8_bin DEFAULT NULL,
348  `size` bigint(20) unsigned NOT NULL,
349  PRIMARY KEY (`id`)
350) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
351/*!40101 SET character_set_client = @saved_cs_client */;
352
353--
354-- Dumping data for table `oc_cards`
355--
356
357LOCK TABLES `oc_cards` WRITE;
358/*!40000 ALTER TABLE `oc_cards` DISABLE KEYS */;
359/*!40000 ALTER TABLE `oc_cards` ENABLE KEYS */;
360UNLOCK TABLES;
361
362--
363-- Table structure for table `oc_cards_properties`
364--
365
366DROP TABLE IF EXISTS `oc_cards_properties`;
367/*!40101 SET @saved_cs_client     = @@character_set_client */;
368/*!40101 SET character_set_client = utf8 */;
369CREATE TABLE `oc_cards_properties` (
370  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
371  `addressbookid` bigint(20) NOT NULL DEFAULT '0',
372  `cardid` bigint(20) unsigned NOT NULL DEFAULT '0',
373  `name` varchar(64) COLLATE utf8_bin DEFAULT NULL,
374  `value` varchar(255) COLLATE utf8_bin DEFAULT NULL,
375  `preferred` int(11) NOT NULL DEFAULT '1',
376  PRIMARY KEY (`id`),
377  KEY `card_contactid_index` (`cardid`),
378  KEY `card_name_index` (`name`),
379  KEY `card_value_index` (`value`)
380) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
381/*!40101 SET character_set_client = @saved_cs_client */;
382
383--
384-- Dumping data for table `oc_cards_properties`
385--
386
387LOCK TABLES `oc_cards_properties` WRITE;
388/*!40000 ALTER TABLE `oc_cards_properties` DISABLE KEYS */;
389/*!40000 ALTER TABLE `oc_cards_properties` ENABLE KEYS */;
390UNLOCK TABLES;
391
392--
393-- Table structure for table `oc_comments`
394--
395
396DROP TABLE IF EXISTS `oc_comments`;
397/*!40101 SET @saved_cs_client     = @@character_set_client */;
398/*!40101 SET character_set_client = utf8 */;
399CREATE TABLE `oc_comments` (
400  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
401  `parent_id` int(10) unsigned NOT NULL DEFAULT '0',
402  `topmost_parent_id` int(10) unsigned NOT NULL DEFAULT '0',
403  `children_count` int(10) unsigned NOT NULL DEFAULT '0',
404  `actor_type` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
405  `actor_id` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
406  `message` longtext COLLATE utf8_bin,
407  `verb` varchar(64) COLLATE utf8_bin DEFAULT NULL,
408  `creation_timestamp` datetime DEFAULT NULL,
409  `latest_child_timestamp` datetime DEFAULT NULL,
410  `object_type` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
411  `object_id` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
412  PRIMARY KEY (`id`),
413  KEY `comments_parent_id_index` (`parent_id`),
414  KEY `comments_topmost_parent_id_idx` (`topmost_parent_id`),
415  KEY `comments_object_index` (`object_type`,`object_id`,`creation_timestamp`),
416  KEY `comments_actor_index` (`actor_type`,`actor_id`)
417) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
418/*!40101 SET character_set_client = @saved_cs_client */;
419
420--
421-- Dumping data for table `oc_comments`
422--
423
424LOCK TABLES `oc_comments` WRITE;
425/*!40000 ALTER TABLE `oc_comments` DISABLE KEYS */;
426/*!40000 ALTER TABLE `oc_comments` ENABLE KEYS */;
427UNLOCK TABLES;
428
429--
430-- Table structure for table `oc_comments_read_markers`
431--
432
433DROP TABLE IF EXISTS `oc_comments_read_markers`;
434/*!40101 SET @saved_cs_client     = @@character_set_client */;
435/*!40101 SET character_set_client = utf8 */;
436CREATE TABLE `oc_comments_read_markers` (
437  `user_id` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
438  `marker_datetime` datetime DEFAULT NULL,
439  `object_type` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
440  `object_id` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
441  UNIQUE KEY `comments_marker_index` (`user_id`,`object_type`,`object_id`),
442  KEY `comments_marker_object_index` (`object_type`,`object_id`)
443) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
444/*!40101 SET character_set_client = @saved_cs_client */;
445
446--
447-- Dumping data for table `oc_comments_read_markers`
448--
449
450LOCK TABLES `oc_comments_read_markers` WRITE;
451/*!40000 ALTER TABLE `oc_comments_read_markers` DISABLE KEYS */;
452/*!40000 ALTER TABLE `oc_comments_read_markers` ENABLE KEYS */;
453UNLOCK TABLES;
454
455--
456-- Table structure for table `oc_credentials`
457--
458
459DROP TABLE IF EXISTS `oc_credentials`;
460/*!40101 SET @saved_cs_client     = @@character_set_client */;
461/*!40101 SET character_set_client = utf8 */;
462CREATE TABLE `oc_credentials` (
463  `user` varchar(64) COLLATE utf8_bin NOT NULL,
464  `identifier` varchar(64) COLLATE utf8_bin NOT NULL,
465  `credentials` longtext COLLATE utf8_bin,
466  PRIMARY KEY (`user`,`identifier`),
467  KEY `credentials_user` (`user`)
468) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
469/*!40101 SET character_set_client = @saved_cs_client */;
470
471--
472-- Dumping data for table `oc_credentials`
473--
474
475LOCK TABLES `oc_credentials` WRITE;
476/*!40000 ALTER TABLE `oc_credentials` DISABLE KEYS */;
477/*!40000 ALTER TABLE `oc_credentials` ENABLE KEYS */;
478UNLOCK TABLES;
479
480--
481-- Table structure for table `oc_dav_shares`
482--
483
484DROP TABLE IF EXISTS `oc_dav_shares`;
485/*!40101 SET @saved_cs_client     = @@character_set_client */;
486/*!40101 SET character_set_client = utf8 */;
487CREATE TABLE `oc_dav_shares` (
488  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
489  `principaluri` varchar(255) COLLATE utf8_bin DEFAULT NULL,
490  `type` varchar(255) COLLATE utf8_bin DEFAULT NULL,
491  `access` smallint(6) DEFAULT NULL,
492  `resourceid` int(10) unsigned NOT NULL,
493  PRIMARY KEY (`id`),
494  UNIQUE KEY `dav_shares_index` (`principaluri`,`resourceid`,`type`)
495) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
496/*!40101 SET character_set_client = @saved_cs_client */;
497
498--
499-- Dumping data for table `oc_dav_shares`
500--
501
502LOCK TABLES `oc_dav_shares` WRITE;
503/*!40000 ALTER TABLE `oc_dav_shares` DISABLE KEYS */;
504/*!40000 ALTER TABLE `oc_dav_shares` ENABLE KEYS */;
505UNLOCK TABLES;
506
507--
508-- Table structure for table `oc_federated_reshares`
509--
510
511DROP TABLE IF EXISTS `oc_federated_reshares`;
512/*!40101 SET @saved_cs_client     = @@character_set_client */;
513/*!40101 SET character_set_client = utf8 */;
514CREATE TABLE `oc_federated_reshares` (
515  `share_id` int(11) NOT NULL,
516  `remote_id` int(11) NOT NULL COMMENT 'share ID at the remote server',
517  UNIQUE KEY `share_id_index` (`share_id`)
518) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
519/*!40101 SET character_set_client = @saved_cs_client */;
520
521--
522-- Dumping data for table `oc_federated_reshares`
523--
524
525LOCK TABLES `oc_federated_reshares` WRITE;
526/*!40000 ALTER TABLE `oc_federated_reshares` DISABLE KEYS */;
527/*!40000 ALTER TABLE `oc_federated_reshares` ENABLE KEYS */;
528UNLOCK TABLES;
529
530--
531-- Table structure for table `oc_file_locks`
532--
533
534DROP TABLE IF EXISTS `oc_file_locks`;
535/*!40101 SET @saved_cs_client     = @@character_set_client */;
536/*!40101 SET character_set_client = utf8 */;
537CREATE TABLE `oc_file_locks` (
538  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
539  `lock` int(11) NOT NULL DEFAULT '0',
540  `key` varchar(64) COLLATE utf8_bin NOT NULL,
541  `ttl` int(11) NOT NULL DEFAULT '-1',
542  PRIMARY KEY (`id`),
543  UNIQUE KEY `lock_key_index` (`key`),
544  KEY `lock_ttl_index` (`ttl`)
545) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
546/*!40101 SET character_set_client = @saved_cs_client */;
547
548--
549-- Dumping data for table `oc_file_locks`
550--
551
552LOCK TABLES `oc_file_locks` WRITE;
553/*!40000 ALTER TABLE `oc_file_locks` DISABLE KEYS */;
554INSERT INTO `oc_file_locks` VALUES (5,0,'files/61ed1f9a7383795ed88817d445e1546b',1484039136),(6,0,'files/c31e581b3c2ec56f9b7b1dca2421b72e',1484039136),(7,0,'files/ef90c82ae6bd9d9a22ee5b7c93d77ca7',1484039136),(8,0,'files/cb6b4c11e5e5642185bd52f5896a8bf8',1484038979);
555/*!40000 ALTER TABLE `oc_file_locks` ENABLE KEYS */;
556UNLOCK TABLES;
557
558--
559-- Table structure for table `oc_filecache`
560--
561
562DROP TABLE IF EXISTS `oc_filecache`;
563/*!40101 SET @saved_cs_client     = @@character_set_client */;
564/*!40101 SET character_set_client = utf8 */;
565CREATE TABLE `oc_filecache` (
566  `fileid` int(11) NOT NULL AUTO_INCREMENT,
567  `storage` int(11) NOT NULL DEFAULT '0',
568  `path` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
569  `path_hash` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
570  `parent` int(11) NOT NULL DEFAULT '0',
571  `name` varchar(250) COLLATE utf8_bin DEFAULT NULL,
572  `mimetype` int(11) NOT NULL DEFAULT '0',
573  `mimepart` int(11) NOT NULL DEFAULT '0',
574  `size` bigint(20) NOT NULL DEFAULT '0',
575  `mtime` int(11) NOT NULL DEFAULT '0',
576  `storage_mtime` int(11) NOT NULL DEFAULT '0',
577  `encrypted` int(11) NOT NULL DEFAULT '0',
578  `unencrypted_size` bigint(20) NOT NULL DEFAULT '0',
579  `etag` varchar(40) COLLATE utf8_bin DEFAULT NULL,
580  `permissions` int(11) DEFAULT '0',
581  `checksum` varchar(255) COLLATE utf8_bin DEFAULT NULL,
582  PRIMARY KEY (`fileid`),
583  UNIQUE KEY `fs_storage_path_hash` (`storage`,`path_hash`),
584  KEY `fs_parent_name_hash` (`parent`,`name`),
585  KEY `fs_storage_mimetype` (`storage`,`mimetype`),
586  KEY `fs_storage_mimepart` (`storage`,`mimepart`),
587  KEY `fs_storage_size` (`storage`,`size`,`fileid`)
588) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
589/*!40101 SET character_set_client = @saved_cs_client */;
590
591--
592-- Dumping data for table `oc_filecache`
593--
594
595LOCK TABLES `oc_filecache` WRITE;
596/*!40000 ALTER TABLE `oc_filecache` DISABLE KEYS */;
597INSERT INTO `oc_filecache` VALUES (1,1,'','d41d8cd98f00b204e9800998ecf8427e',-1,'',2,1,4770198,1483963185,1483963185,0,0,'58737b31ddc9d',23,''),(2,1,'files','45b963397aa40d4a0063e0d85e4fe7a1',1,'files',2,1,4770198,1483963185,1483963185,0,0,'58737b31dab71',31,''),(3,1,'files/Photos','d01bb67e7b71dd49fd06bad922f521c9',2,'Photos',2,1,678556,1483963185,1483963185,0,0,'58737b319c3eb',31,''),(4,1,'files/Photos/San Francisco.jpg','9fc714efbeaafee22f7058e73d2b1c3b',3,'San Francisco.jpg',4,3,216071,1483963185,1483963185,0,0,'b22ee08e8a5360dc896a9f105356ca34',27,''),(5,1,'files/Photos/Squirrel.jpg','de85d1da71bcd6232ad893f959063b8c',3,'Squirrel.jpg',4,3,233724,1483963185,1483963185,0,0,'722332dbf123f5cd39de6299a54f7d33',27,''),(6,1,'files/Photos/Paris.jpg','a208ddedf08367bbc56963107248dda5',3,'Paris.jpg',4,3,228761,1483963185,1483963185,0,0,'89813fb83bfb35397c4547d638a5b09d',27,''),(7,1,'files/Documents','0ad78ba05b6961d92f7970b2b3922eca',2,'Documents',2,1,36227,1483963185,1483963185,0,0,'58737b31c2efd',31,''),(8,1,'files/Documents/Example.odt','c89c560541b952a435783a7d51a27d50',7,'Example.odt',6,5,36227,1483963185,1483963185,0,0,'7caf14fb4fa10e71a9f19aec00e8b760',27,''),(9,1,'files/ownCloud Manual.pdf','a73aa0f95f162297bbb7ffa3fb5ad709',2,'ownCloud Manual.pdf',7,5,4055415,1483963185,1483963185,0,0,'ebb8e17b20848fa991a805b5a99c1f6c',27,''),(10,2,'','d41d8cd98f00b204e9800998ecf8427e',-1,'',2,1,-1,1484035379,1484035379,0,0,'58749533089cf',23,''),(11,2,'files_external','c270928b685e7946199afdfb898d27ea',10,'files_external',2,1,0,1484035379,1484035379,0,0,'5874953306aa6',31,'');
598/*!40000 ALTER TABLE `oc_filecache` ENABLE KEYS */;
599UNLOCK TABLES;
600
601--
602-- Table structure for table `oc_files_trash`
603--
604
605DROP TABLE IF EXISTS `oc_files_trash`;
606/*!40101 SET @saved_cs_client     = @@character_set_client */;
607/*!40101 SET character_set_client = utf8 */;
608CREATE TABLE `oc_files_trash` (
609  `auto_id` int(11) NOT NULL AUTO_INCREMENT,
610  `id` varchar(250) COLLATE utf8_bin NOT NULL DEFAULT '',
611  `user` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
612  `timestamp` varchar(12) COLLATE utf8_bin NOT NULL DEFAULT '',
613  `location` varchar(512) COLLATE utf8_bin NOT NULL DEFAULT '',
614  `type` varchar(4) COLLATE utf8_bin DEFAULT NULL,
615  `mime` varchar(255) COLLATE utf8_bin DEFAULT NULL,
616  PRIMARY KEY (`auto_id`),
617  KEY `id_index` (`id`),
618  KEY `timestamp_index` (`timestamp`),
619  KEY `user_index` (`user`)
620) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
621/*!40101 SET character_set_client = @saved_cs_client */;
622
623--
624-- Dumping data for table `oc_files_trash`
625--
626
627LOCK TABLES `oc_files_trash` WRITE;
628/*!40000 ALTER TABLE `oc_files_trash` DISABLE KEYS */;
629/*!40000 ALTER TABLE `oc_files_trash` ENABLE KEYS */;
630UNLOCK TABLES;
631
632--
633-- Table structure for table `oc_group_admin`
634--
635
636DROP TABLE IF EXISTS `oc_group_admin`;
637/*!40101 SET @saved_cs_client     = @@character_set_client */;
638/*!40101 SET character_set_client = utf8 */;
639CREATE TABLE `oc_group_admin` (
640  `gid` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
641  `uid` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
642  PRIMARY KEY (`gid`,`uid`),
643  KEY `group_admin_uid` (`uid`)
644) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
645/*!40101 SET character_set_client = @saved_cs_client */;
646
647--
648-- Dumping data for table `oc_group_admin`
649--
650
651LOCK TABLES `oc_group_admin` WRITE;
652/*!40000 ALTER TABLE `oc_group_admin` DISABLE KEYS */;
653/*!40000 ALTER TABLE `oc_group_admin` ENABLE KEYS */;
654UNLOCK TABLES;
655
656--
657-- Table structure for table `oc_group_user`
658--
659
660DROP TABLE IF EXISTS `oc_group_user`;
661/*!40101 SET @saved_cs_client     = @@character_set_client */;
662/*!40101 SET character_set_client = utf8 */;
663CREATE TABLE `oc_group_user` (
664  `gid` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
665  `uid` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
666  PRIMARY KEY (`gid`,`uid`),
667  KEY `gu_uid_index` (`uid`)
668) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
669/*!40101 SET character_set_client = @saved_cs_client */;
670
671--
672-- Dumping data for table `oc_group_user`
673--
674
675LOCK TABLES `oc_group_user` WRITE;
676/*!40000 ALTER TABLE `oc_group_user` DISABLE KEYS */;
677INSERT INTO `oc_group_user` VALUES ('admin','{{ ADMIN_USER }}');
678/*!40000 ALTER TABLE `oc_group_user` ENABLE KEYS */;
679UNLOCK TABLES;
680
681--
682-- Table structure for table `oc_groups`
683--
684
685DROP TABLE IF EXISTS `oc_groups`;
686/*!40101 SET @saved_cs_client     = @@character_set_client */;
687/*!40101 SET character_set_client = utf8 */;
688CREATE TABLE `oc_groups` (
689  `gid` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
690  PRIMARY KEY (`gid`)
691) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
692/*!40101 SET character_set_client = @saved_cs_client */;
693
694--
695-- Dumping data for table `oc_groups`
696--
697
698LOCK TABLES `oc_groups` WRITE;
699/*!40000 ALTER TABLE `oc_groups` DISABLE KEYS */;
700INSERT INTO `oc_groups` VALUES ('admin');
701/*!40000 ALTER TABLE `oc_groups` ENABLE KEYS */;
702UNLOCK TABLES;
703
704--
705-- Table structure for table `oc_jobs`
706--
707
708DROP TABLE IF EXISTS `oc_jobs`;
709/*!40101 SET @saved_cs_client     = @@character_set_client */;
710/*!40101 SET character_set_client = utf8 */;
711CREATE TABLE `oc_jobs` (
712  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
713  `class` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
714  `argument` varchar(4000) COLLATE utf8_bin NOT NULL DEFAULT '',
715  `last_run` int(11) DEFAULT '0',
716  `last_checked` int(11) DEFAULT '0',
717  `reserved_at` int(11) DEFAULT '0',
718  PRIMARY KEY (`id`),
719  KEY `job_class_index` (`class`)
720) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
721/*!40101 SET character_set_client = @saved_cs_client */;
722
723--
724-- Dumping data for table `oc_jobs`
725--
726
727LOCK TABLES `oc_jobs` WRITE;
728/*!40000 ALTER TABLE `oc_jobs` DISABLE KEYS */;
729INSERT INTO `oc_jobs` VALUES (1,'OCA\\Files\\BackgroundJob\\ScanFiles','null',1483963198,1483963198,0),(2,'OCA\\Files\\BackgroundJob\\DeleteOrphanedItems','null',1483963212,1483963212,0),(3,'OCA\\Files\\BackgroundJob\\CleanupFileLocks','null',1484035352,1484035351,0),(4,'OCA\\Federation\\SyncJob','null',1484035362,1484035362,0),(5,'OCA\\Files_Trashbin\\BackgroundJob\\ExpireTrash','null',1484035378,1484035378,0),(6,'OCA\\UpdateNotification\\Notification\\BackgroundJob','null',1484035499,1484035499,0),(7,'OCA\\Files_Versions\\BackgroundJob\\ExpireVersions','null',1484035517,1484035517,0),(8,'OCA\\DAV\\CardDAV\\SyncJob','null',1484035535,1484035535,0),(9,'OCA\\Files_Sharing\\DeleteOrphanedSharesJob','null',1484044841,1484044841,0),(10,'OCA\\Files_Sharing\\ExpireSharesJob','null',1484044865,1484044865,0),(11,'OCA\\Activity\\BackgroundJob\\EmailNotification','null',1484047644,1484047644,0),(12,'OCA\\Activity\\BackgroundJob\\ExpireActivities','null',1484051001,1484051001,0),(13,'\\OC\\Authentication\\Token\\DefaultTokenCleanupJob','null',0,1483963186,0),(14,'OCA\\User_LDAP\\Jobs\\UpdateGroups','null',0,1484050995,0),(15,'OCA\\User_LDAP\\Jobs\\CleanUp','null',0,1484050995,0);
730/*!40000 ALTER TABLE `oc_jobs` ENABLE KEYS */;
731UNLOCK TABLES;
732
733--
734-- Table structure for table `oc_ldap_group_mapping`
735--
736
737DROP TABLE IF EXISTS `oc_ldap_group_mapping`;
738/*!40101 SET @saved_cs_client     = @@character_set_client */;
739/*!40101 SET character_set_client = utf8 */;
740CREATE TABLE `oc_ldap_group_mapping` (
741  `ldap_dn` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
742  `owncloud_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
743  `directory_uuid` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
744  PRIMARY KEY (`ldap_dn`),
745  UNIQUE KEY `owncloud_name_groups` (`owncloud_name`)
746) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
747/*!40101 SET character_set_client = @saved_cs_client */;
748
749--
750-- Dumping data for table `oc_ldap_group_mapping`
751--
752
753LOCK TABLES `oc_ldap_group_mapping` WRITE;
754/*!40000 ALTER TABLE `oc_ldap_group_mapping` DISABLE KEYS */;
755/*!40000 ALTER TABLE `oc_ldap_group_mapping` ENABLE KEYS */;
756UNLOCK TABLES;
757
758--
759-- Table structure for table `oc_ldap_group_members`
760--
761
762DROP TABLE IF EXISTS `oc_ldap_group_members`;
763/*!40101 SET @saved_cs_client     = @@character_set_client */;
764/*!40101 SET character_set_client = utf8 */;
765CREATE TABLE `oc_ldap_group_members` (
766  `owncloudname` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
767  `owncloudusers` longtext COLLATE utf8_bin NOT NULL,
768  PRIMARY KEY (`owncloudname`)
769) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
770/*!40101 SET character_set_client = @saved_cs_client */;
771
772--
773-- Dumping data for table `oc_ldap_group_members`
774--
775
776LOCK TABLES `oc_ldap_group_members` WRITE;
777/*!40000 ALTER TABLE `oc_ldap_group_members` DISABLE KEYS */;
778/*!40000 ALTER TABLE `oc_ldap_group_members` ENABLE KEYS */;
779UNLOCK TABLES;
780
781--
782-- Table structure for table `oc_ldap_user_mapping`
783--
784
785DROP TABLE IF EXISTS `oc_ldap_user_mapping`;
786/*!40101 SET @saved_cs_client     = @@character_set_client */;
787/*!40101 SET character_set_client = utf8 */;
788CREATE TABLE `oc_ldap_user_mapping` (
789  `ldap_dn` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
790  `owncloud_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
791  `directory_uuid` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
792  PRIMARY KEY (`owncloud_name`),
793  UNIQUE KEY `ldap_dn_users` (`ldap_dn`)
794) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
795/*!40101 SET character_set_client = @saved_cs_client */;
796
797--
798-- Dumping data for table `oc_ldap_user_mapping`
799--
800
801LOCK TABLES `oc_ldap_user_mapping` WRITE;
802/*!40000 ALTER TABLE `oc_ldap_user_mapping` DISABLE KEYS */;
803/*!40000 ALTER TABLE `oc_ldap_user_mapping` ENABLE KEYS */;
804UNLOCK TABLES;
805
806--
807-- Table structure for table `oc_mimetypes`
808--
809
810DROP TABLE IF EXISTS `oc_mimetypes`;
811/*!40101 SET @saved_cs_client     = @@character_set_client */;
812/*!40101 SET character_set_client = utf8 */;
813CREATE TABLE `oc_mimetypes` (
814  `id` int(11) NOT NULL AUTO_INCREMENT,
815  `mimetype` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
816  PRIMARY KEY (`id`),
817  UNIQUE KEY `mimetype_id_index` (`mimetype`)
818) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
819/*!40101 SET character_set_client = @saved_cs_client */;
820
821--
822-- Dumping data for table `oc_mimetypes`
823--
824
825LOCK TABLES `oc_mimetypes` WRITE;
826/*!40000 ALTER TABLE `oc_mimetypes` DISABLE KEYS */;
827INSERT INTO `oc_mimetypes` VALUES (5,'application'),(7,'application/pdf'),(6,'application/vnd.oasis.opendocument.text'),(1,'httpd'),(2,'httpd/unix-directory'),(3,'image'),(4,'image/jpeg');
828/*!40000 ALTER TABLE `oc_mimetypes` ENABLE KEYS */;
829UNLOCK TABLES;
830
831--
832-- Table structure for table `oc_mounts`
833--
834
835DROP TABLE IF EXISTS `oc_mounts`;
836/*!40101 SET @saved_cs_client     = @@character_set_client */;
837/*!40101 SET character_set_client = utf8 */;
838CREATE TABLE `oc_mounts` (
839  `id` int(11) NOT NULL AUTO_INCREMENT,
840  `storage_id` int(11) NOT NULL,
841  `root_id` int(11) NOT NULL,
842  `user_id` varchar(64) COLLATE utf8_bin NOT NULL,
843  `mount_point` varchar(4000) COLLATE utf8_bin NOT NULL,
844  PRIMARY KEY (`id`),
845  UNIQUE KEY `mounts_user_root_index` (`user_id`,`root_id`),
846  KEY `mounts_user_index` (`user_id`),
847  KEY `mounts_storage_index` (`storage_id`),
848  KEY `mounts_root_index` (`root_id`)
849) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
850/*!40101 SET character_set_client = @saved_cs_client */;
851
852--
853-- Dumping data for table `oc_mounts`
854--
855
856LOCK TABLES `oc_mounts` WRITE;
857/*!40000 ALTER TABLE `oc_mounts` DISABLE KEYS */;
858INSERT INTO `oc_mounts` VALUES (1,1,1,'owncloud_admin','/owncloud_admin/');
859/*!40000 ALTER TABLE `oc_mounts` ENABLE KEYS */;
860UNLOCK TABLES;
861
862--
863-- Table structure for table `oc_notifications`
864--
865
866DROP TABLE IF EXISTS `oc_notifications`;
867/*!40101 SET @saved_cs_client     = @@character_set_client */;
868/*!40101 SET character_set_client = utf8 */;
869CREATE TABLE `oc_notifications` (
870  `notification_id` int(11) NOT NULL AUTO_INCREMENT,
871  `app` varchar(32) COLLATE utf8_bin NOT NULL,
872  `user` varchar(64) COLLATE utf8_bin NOT NULL,
873  `timestamp` int(11) NOT NULL DEFAULT '0',
874  `object_type` varchar(64) COLLATE utf8_bin NOT NULL,
875  `object_id` varchar(64) COLLATE utf8_bin NOT NULL,
876  `subject` varchar(64) COLLATE utf8_bin NOT NULL,
877  `subject_parameters` longtext COLLATE utf8_bin,
878  `message` varchar(64) COLLATE utf8_bin DEFAULT NULL,
879  `message_parameters` longtext COLLATE utf8_bin,
880  `link` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
881  `actions` longtext COLLATE utf8_bin,
882  PRIMARY KEY (`notification_id`),
883  KEY `oc_notifications_app` (`app`),
884  KEY `oc_notifications_user` (`user`),
885  KEY `oc_notifications_timestamp` (`timestamp`),
886  KEY `oc_notifications_object` (`object_type`,`object_id`)
887) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
888/*!40101 SET character_set_client = @saved_cs_client */;
889
890--
891-- Dumping data for table `oc_notifications`
892--
893
894LOCK TABLES `oc_notifications` WRITE;
895/*!40000 ALTER TABLE `oc_notifications` DISABLE KEYS */;
896/*!40000 ALTER TABLE `oc_notifications` ENABLE KEYS */;
897UNLOCK TABLES;
898
899--
900-- Table structure for table `oc_preferences`
901--
902
903DROP TABLE IF EXISTS `oc_preferences`;
904/*!40101 SET @saved_cs_client     = @@character_set_client */;
905/*!40101 SET character_set_client = utf8 */;
906CREATE TABLE `oc_preferences` (
907  `userid` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
908  `appid` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
909  `configkey` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
910  `configvalue` longtext COLLATE utf8_bin,
911  PRIMARY KEY (`userid`,`appid`,`configkey`)
912) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
913/*!40101 SET character_set_client = @saved_cs_client */;
914
915--
916-- Dumping data for table `oc_preferences`
917--
918
919LOCK TABLES `oc_preferences` WRITE;
920/*!40000 ALTER TABLE `oc_preferences` DISABLE KEYS */;
921INSERT INTO `oc_preferences` VALUES  ('{{ ADMIN_USER }}','core','lang','es'),('{{ ADMIN_USER }}','firstrunwizard','show','0');
922/*!40000 ALTER TABLE `oc_preferences` ENABLE KEYS */;
923UNLOCK TABLES;
924
925--
926-- Table structure for table `oc_privatedata`
927--
928
929DROP TABLE IF EXISTS `oc_privatedata`;
930/*!40101 SET @saved_cs_client     = @@character_set_client */;
931/*!40101 SET character_set_client = utf8 */;
932CREATE TABLE `oc_privatedata` (
933  `keyid` int(10) unsigned NOT NULL AUTO_INCREMENT,
934  `user` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
935  `app` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
936  `key` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
937  `value` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
938  PRIMARY KEY (`keyid`)
939) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
940/*!40101 SET character_set_client = @saved_cs_client */;
941
942--
943-- Dumping data for table `oc_privatedata`
944--
945
946LOCK TABLES `oc_privatedata` WRITE;
947/*!40000 ALTER TABLE `oc_privatedata` DISABLE KEYS */;
948/*!40000 ALTER TABLE `oc_privatedata` ENABLE KEYS */;
949UNLOCK TABLES;
950
951--
952-- Table structure for table `oc_properties`
953--
954
955DROP TABLE IF EXISTS `oc_properties`;
956/*!40101 SET @saved_cs_client     = @@character_set_client */;
957/*!40101 SET character_set_client = utf8 */;
958CREATE TABLE `oc_properties` (
959  `id` int(11) NOT NULL AUTO_INCREMENT,
960  `userid` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
961  `propertypath` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
962  `propertyname` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
963  `propertyvalue` varchar(255) COLLATE utf8_bin NOT NULL,
964  PRIMARY KEY (`id`),
965  KEY `property_index` (`userid`)
966) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
967/*!40101 SET character_set_client = @saved_cs_client */;
968
969--
970-- Dumping data for table `oc_properties`
971--
972
973LOCK TABLES `oc_properties` WRITE;
974/*!40000 ALTER TABLE `oc_properties` DISABLE KEYS */;
975/*!40000 ALTER TABLE `oc_properties` ENABLE KEYS */;
976UNLOCK TABLES;
977
978--
979-- Table structure for table `oc_schedulingobjects`
980--
981
982DROP TABLE IF EXISTS `oc_schedulingobjects`;
983/*!40101 SET @saved_cs_client     = @@character_set_client */;
984/*!40101 SET character_set_client = utf8 */;
985CREATE TABLE `oc_schedulingobjects` (
986  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
987  `principaluri` varchar(255) COLLATE utf8_bin DEFAULT NULL,
988  `calendardata` longblob,
989  `uri` varchar(255) COLLATE utf8_bin DEFAULT NULL,
990  `lastmodified` int(10) unsigned DEFAULT NULL,
991  `etag` varchar(32) COLLATE utf8_bin DEFAULT NULL,
992  `size` bigint(20) unsigned NOT NULL,
993  PRIMARY KEY (`id`)
994) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
995/*!40101 SET character_set_client = @saved_cs_client */;
996
997--
998-- Dumping data for table `oc_schedulingobjects`
999--
1000
1001LOCK TABLES `oc_schedulingobjects` WRITE;
1002/*!40000 ALTER TABLE `oc_schedulingobjects` DISABLE KEYS */;
1003/*!40000 ALTER TABLE `oc_schedulingobjects` ENABLE KEYS */;
1004UNLOCK TABLES;
1005
1006--
1007-- Table structure for table `oc_share`
1008--
1009
1010DROP TABLE IF EXISTS `oc_share`;
1011/*!40101 SET @saved_cs_client     = @@character_set_client */;
1012/*!40101 SET character_set_client = utf8 */;
1013CREATE TABLE `oc_share` (
1014  `id` int(11) NOT NULL AUTO_INCREMENT,
1015  `share_type` smallint(6) NOT NULL DEFAULT '0',
1016  `share_with` varchar(255) COLLATE utf8_bin DEFAULT NULL,
1017  `uid_owner` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
1018  `uid_initiator` varchar(64) COLLATE utf8_bin DEFAULT NULL,
1019  `parent` int(11) DEFAULT NULL,
1020  `item_type` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
1021  `item_source` varchar(255) COLLATE utf8_bin DEFAULT NULL,
1022  `item_target` varchar(255) COLLATE utf8_bin DEFAULT NULL,
1023  `file_source` int(11) DEFAULT NULL,
1024  `file_target` varchar(512) COLLATE utf8_bin DEFAULT NULL,
1025  `permissions` smallint(6) NOT NULL DEFAULT '0',
1026  `stime` bigint(20) NOT NULL DEFAULT '0',
1027  `accepted` smallint(6) NOT NULL DEFAULT '0',
1028  `expiration` datetime DEFAULT NULL,
1029  `token` varchar(32) COLLATE utf8_bin DEFAULT NULL,
1030  `mail_send` smallint(6) NOT NULL DEFAULT '0',
1031  PRIMARY KEY (`id`),
1032  KEY `item_share_type_index` (`item_type`,`share_type`),
1033  KEY `file_source_index` (`file_source`),
1034  KEY `token_index` (`token`)
1035) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1036/*!40101 SET character_set_client = @saved_cs_client */;
1037
1038--
1039-- Dumping data for table `oc_share`
1040--
1041
1042LOCK TABLES `oc_share` WRITE;
1043/*!40000 ALTER TABLE `oc_share` DISABLE KEYS */;
1044/*!40000 ALTER TABLE `oc_share` ENABLE KEYS */;
1045UNLOCK TABLES;
1046
1047--
1048-- Table structure for table `oc_share_external`
1049--
1050
1051DROP TABLE IF EXISTS `oc_share_external`;
1052/*!40101 SET @saved_cs_client     = @@character_set_client */;
1053/*!40101 SET character_set_client = utf8 */;
1054CREATE TABLE `oc_share_external` (
1055  `id` int(11) NOT NULL AUTO_INCREMENT,
1056  `remote` varchar(512) COLLATE utf8_bin NOT NULL COMMENT 'Url of the remove owncloud instance',
1057  `remote_id` int(11) NOT NULL DEFAULT '-1',
1058  `share_token` varchar(64) COLLATE utf8_bin NOT NULL COMMENT 'Public share token',
1059  `password` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT 'Optional password for the public share',
1060  `name` varchar(64) COLLATE utf8_bin NOT NULL COMMENT 'Original name on the remote server',
1061  `owner` varchar(64) COLLATE utf8_bin NOT NULL COMMENT 'User that owns the public share on the remote server',
1062  `user` varchar(64) COLLATE utf8_bin NOT NULL COMMENT 'Local user which added the external share',
1063  `mountpoint` varchar(4000) COLLATE utf8_bin NOT NULL COMMENT 'Full path where the share is mounted',
1064  `mountpoint_hash` varchar(32) COLLATE utf8_bin NOT NULL COMMENT 'md5 hash of the mountpoint',
1065  `accepted` int(11) NOT NULL DEFAULT '0',
1066  PRIMARY KEY (`id`),
1067  UNIQUE KEY `sh_external_mp` (`user`,`mountpoint_hash`),
1068  KEY `sh_external_user` (`user`)
1069) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1070/*!40101 SET character_set_client = @saved_cs_client */;
1071
1072--
1073-- Dumping data for table `oc_share_external`
1074--
1075
1076LOCK TABLES `oc_share_external` WRITE;
1077/*!40000 ALTER TABLE `oc_share_external` DISABLE KEYS */;
1078/*!40000 ALTER TABLE `oc_share_external` ENABLE KEYS */;
1079UNLOCK TABLES;
1080
1081--
1082-- Table structure for table `oc_storages`
1083--
1084
1085DROP TABLE IF EXISTS `oc_storages`;
1086/*!40101 SET @saved_cs_client     = @@character_set_client */;
1087/*!40101 SET character_set_client = utf8 */;
1088CREATE TABLE `oc_storages` (
1089  `id` varchar(64) COLLATE utf8_bin DEFAULT NULL,
1090  `numeric_id` int(11) NOT NULL AUTO_INCREMENT,
1091  `available` int(11) NOT NULL DEFAULT '1',
1092  `last_checked` int(11) DEFAULT NULL,
1093  PRIMARY KEY (`numeric_id`),
1094  UNIQUE KEY `storages_id_index` (`id`)
1095) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1096/*!40101 SET character_set_client = @saved_cs_client */;
1097
1098--
1099-- Dumping data for table `oc_storages`
1100--
1101
1102LOCK TABLES `oc_storages` WRITE;
1103/*!40000 ALTER TABLE `oc_storages` DISABLE KEYS */;
1104INSERT INTO `oc_storages` VALUES ('home::{{ ADMIN_USER }}',1,1,NULL),('local::/var/www/owncloud/data/',2,1,NULL);
1105/*!40000 ALTER TABLE `oc_storages` ENABLE KEYS */;
1106UNLOCK TABLES;
1107
1108--
1109-- Table structure for table `oc_systemtag`
1110--
1111
1112DROP TABLE IF EXISTS `oc_systemtag`;
1113/*!40101 SET @saved_cs_client     = @@character_set_client */;
1114/*!40101 SET character_set_client = utf8 */;
1115CREATE TABLE `oc_systemtag` (
1116  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1117  `name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
1118  `visibility` smallint(6) NOT NULL DEFAULT '1',
1119  `editable` smallint(6) NOT NULL DEFAULT '1',
1120  PRIMARY KEY (`id`),
1121  UNIQUE KEY `tag_ident` (`name`,`visibility`,`editable`)
1122) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1123/*!40101 SET character_set_client = @saved_cs_client */;
1124
1125--
1126-- Dumping data for table `oc_systemtag`
1127--
1128
1129LOCK TABLES `oc_systemtag` WRITE;
1130/*!40000 ALTER TABLE `oc_systemtag` DISABLE KEYS */;
1131/*!40000 ALTER TABLE `oc_systemtag` ENABLE KEYS */;
1132UNLOCK TABLES;
1133
1134--
1135-- Table structure for table `oc_systemtag_group`
1136--
1137
1138DROP TABLE IF EXISTS `oc_systemtag_group`;
1139/*!40101 SET @saved_cs_client     = @@character_set_client */;
1140/*!40101 SET character_set_client = utf8 */;
1141CREATE TABLE `oc_systemtag_group` (
1142  `systemtagid` int(10) unsigned NOT NULL DEFAULT '0',
1143  `gid` varchar(255) COLLATE utf8_bin NOT NULL,
1144  PRIMARY KEY (`gid`,`systemtagid`)
1145) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1146/*!40101 SET character_set_client = @saved_cs_client */;
1147
1148--
1149-- Dumping data for table `oc_systemtag_group`
1150--
1151
1152LOCK TABLES `oc_systemtag_group` WRITE;
1153/*!40000 ALTER TABLE `oc_systemtag_group` DISABLE KEYS */;
1154/*!40000 ALTER TABLE `oc_systemtag_group` ENABLE KEYS */;
1155UNLOCK TABLES;
1156
1157--
1158-- Table structure for table `oc_systemtag_object_mapping`
1159--
1160
1161DROP TABLE IF EXISTS `oc_systemtag_object_mapping`;
1162/*!40101 SET @saved_cs_client     = @@character_set_client */;
1163/*!40101 SET character_set_client = utf8 */;
1164CREATE TABLE `oc_systemtag_object_mapping` (
1165  `objectid` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
1166  `objecttype` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
1167  `systemtagid` int(10) unsigned NOT NULL DEFAULT '0',
1168  UNIQUE KEY `mapping` (`objecttype`,`objectid`,`systemtagid`)
1169) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1170/*!40101 SET character_set_client = @saved_cs_client */;
1171
1172--
1173-- Dumping data for table `oc_systemtag_object_mapping`
1174--
1175
1176LOCK TABLES `oc_systemtag_object_mapping` WRITE;
1177/*!40000 ALTER TABLE `oc_systemtag_object_mapping` DISABLE KEYS */;
1178/*!40000 ALTER TABLE `oc_systemtag_object_mapping` ENABLE KEYS */;
1179UNLOCK TABLES;
1180
1181--
1182-- Table structure for table `oc_trusted_servers`
1183--
1184
1185DROP TABLE IF EXISTS `oc_trusted_servers`;
1186/*!40101 SET @saved_cs_client     = @@character_set_client */;
1187/*!40101 SET character_set_client = utf8 */;
1188CREATE TABLE `oc_trusted_servers` (
1189  `id` int(11) NOT NULL AUTO_INCREMENT,
1190  `url` varchar(512) COLLATE utf8_bin NOT NULL COMMENT 'Url of trusted server',
1191  `url_hash` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT 'sha1 hash of the url without the protocol',
1192  `token` varchar(128) COLLATE utf8_bin DEFAULT NULL COMMENT 'token used to exchange the shared secret',
1193  `shared_secret` varchar(256) COLLATE utf8_bin DEFAULT NULL COMMENT 'shared secret used to authenticate',
1194  `status` int(11) NOT NULL DEFAULT '2' COMMENT 'current status of the connection',
1195  `sync_token` varchar(512) COLLATE utf8_bin DEFAULT NULL COMMENT 'cardDav sync token',
1196  PRIMARY KEY (`id`),
1197  UNIQUE KEY `url_hash` (`url_hash`)
1198) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1199/*!40101 SET character_set_client = @saved_cs_client */;
1200
1201--
1202-- Dumping data for table `oc_trusted_servers`
1203--
1204
1205LOCK TABLES `oc_trusted_servers` WRITE;
1206/*!40000 ALTER TABLE `oc_trusted_servers` DISABLE KEYS */;
1207/*!40000 ALTER TABLE `oc_trusted_servers` ENABLE KEYS */;
1208UNLOCK TABLES;
1209
1210--
1211-- Table structure for table `oc_users`
1212--
1213
1214DROP TABLE IF EXISTS `oc_users`;
1215/*!40101 SET @saved_cs_client     = @@character_set_client */;
1216/*!40101 SET character_set_client = utf8 */;
1217CREATE TABLE `oc_users` (
1218  `uid` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
1219  `displayname` varchar(64) COLLATE utf8_bin DEFAULT NULL,
1220  `password` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
1221  PRIMARY KEY (`uid`)
1222) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1223/*!40101 SET character_set_client = @saved_cs_client */;
1224
1225--
1226-- Dumping data for table `oc_users`
1227--
1228
1229LOCK TABLES `oc_users` WRITE;
1230/*!40000 ALTER TABLE `oc_users` DISABLE KEYS */;
1231INSERT INTO `oc_users` VALUES ('{{ ADMIN_USER }}',NULL,'1|{{ ADMIN_PWD }}');
1232/*!40000 ALTER TABLE `oc_users` ENABLE KEYS */;
1233UNLOCK TABLES;
1234
1235--
1236-- Table structure for table `oc_vcategory`
1237--
1238
1239DROP TABLE IF EXISTS `oc_vcategory`;
1240/*!40101 SET @saved_cs_client     = @@character_set_client */;
1241/*!40101 SET character_set_client = utf8 */;
1242CREATE TABLE `oc_vcategory` (
1243  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1244  `uid` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
1245  `type` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
1246  `category` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
1247  PRIMARY KEY (`id`),
1248  KEY `uid_index` (`uid`),
1249  KEY `type_index` (`type`),
1250  KEY `category_index` (`category`)
1251) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1252/*!40101 SET character_set_client = @saved_cs_client */;
1253
1254--
1255-- Dumping data for table `oc_vcategory`
1256--
1257
1258LOCK TABLES `oc_vcategory` WRITE;
1259/*!40000 ALTER TABLE `oc_vcategory` DISABLE KEYS */;
1260/*!40000 ALTER TABLE `oc_vcategory` ENABLE KEYS */;
1261UNLOCK TABLES;
1262
1263--
1264-- Table structure for table `oc_vcategory_to_object`
1265--
1266
1267DROP TABLE IF EXISTS `oc_vcategory_to_object`;
1268/*!40101 SET @saved_cs_client     = @@character_set_client */;
1269/*!40101 SET character_set_client = utf8 */;
1270CREATE TABLE `oc_vcategory_to_object` (
1271  `objid` int(10) unsigned NOT NULL DEFAULT '0',
1272  `categoryid` int(10) unsigned NOT NULL DEFAULT '0',
1273  `type` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
1274  PRIMARY KEY (`categoryid`,`objid`,`type`),
1275  KEY `vcategory_objectd_index` (`objid`,`type`)
1276) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1277/*!40101 SET character_set_client = @saved_cs_client */;
1278
1279--
1280-- Dumping data for table `oc_vcategory_to_object`
1281--
1282
1283LOCK TABLES `oc_vcategory_to_object` WRITE;
1284/*!40000 ALTER TABLE `oc_vcategory_to_object` DISABLE KEYS */;
1285/*!40000 ALTER TABLE `oc_vcategory_to_object` ENABLE KEYS */;
1286UNLOCK TABLES;
1287/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1288
1289/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1290/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1291/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1292/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1293/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1294/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1295/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1296
1297-- Dump completed on 2017-01-10 13:31:04
Note: See TracBrowser for help on using the repository browser.