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

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

WIP in database file

File size: 52.6 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 */;
202/*!40000 ALTER TABLE `oc_authtoken` ENABLE KEYS */;
203UNLOCK TABLES;
204
205--
206-- Table structure for table `oc_calendarchanges`
207--
208
209DROP TABLE IF EXISTS `oc_calendarchanges`;
210/*!40101 SET @saved_cs_client     = @@character_set_client */;
211/*!40101 SET character_set_client = utf8 */;
212CREATE TABLE `oc_calendarchanges` (
213  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
214  `uri` varchar(255) COLLATE utf8_bin DEFAULT NULL,
215  `synctoken` int(10) unsigned NOT NULL DEFAULT '1',
216  `calendarid` int(11) NOT NULL,
217  `operation` smallint(6) NOT NULL,
218  PRIMARY KEY (`id`),
219  KEY `calendarid_synctoken` (`calendarid`,`synctoken`)
220) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
221/*!40101 SET character_set_client = @saved_cs_client */;
222
223--
224-- Dumping data for table `oc_calendarchanges`
225--
226
227LOCK TABLES `oc_calendarchanges` WRITE;
228/*!40000 ALTER TABLE `oc_calendarchanges` DISABLE KEYS */;
229/*!40000 ALTER TABLE `oc_calendarchanges` ENABLE KEYS */;
230UNLOCK TABLES;
231
232--
233-- Table structure for table `oc_calendarobjects`
234--
235
236DROP TABLE IF EXISTS `oc_calendarobjects`;
237/*!40101 SET @saved_cs_client     = @@character_set_client */;
238/*!40101 SET character_set_client = utf8 */;
239CREATE TABLE `oc_calendarobjects` (
240  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
241  `calendardata` longblob,
242  `uri` varchar(255) COLLATE utf8_bin DEFAULT NULL,
243  `calendarid` int(10) unsigned NOT NULL,
244  `lastmodified` int(10) unsigned DEFAULT NULL,
245  `etag` varchar(32) COLLATE utf8_bin DEFAULT NULL,
246  `size` bigint(20) unsigned NOT NULL,
247  `componenttype` varchar(8) COLLATE utf8_bin DEFAULT NULL,
248  `firstoccurence` bigint(20) unsigned DEFAULT NULL,
249  `lastoccurence` bigint(20) unsigned DEFAULT NULL,
250  `uid` varchar(255) COLLATE utf8_bin DEFAULT NULL,
251  `classification` int(11) DEFAULT '0' COMMENT '0 - public, 1 - private, 2 - confidential',
252  PRIMARY KEY (`id`),
253  UNIQUE KEY `calobjects_index` (`calendarid`,`uri`)
254) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
255/*!40101 SET character_set_client = @saved_cs_client */;
256
257--
258-- Dumping data for table `oc_calendarobjects`
259--
260
261LOCK TABLES `oc_calendarobjects` WRITE;
262/*!40000 ALTER TABLE `oc_calendarobjects` DISABLE KEYS */;
263/*!40000 ALTER TABLE `oc_calendarobjects` ENABLE KEYS */;
264UNLOCK TABLES;
265
266--
267-- Table structure for table `oc_calendars`
268--
269
270DROP TABLE IF EXISTS `oc_calendars`;
271/*!40101 SET @saved_cs_client     = @@character_set_client */;
272/*!40101 SET character_set_client = utf8 */;
273CREATE TABLE `oc_calendars` (
274  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
275  `principaluri` varchar(255) COLLATE utf8_bin DEFAULT NULL,
276  `displayname` varchar(255) COLLATE utf8_bin DEFAULT NULL,
277  `uri` varchar(255) COLLATE utf8_bin DEFAULT NULL,
278  `synctoken` int(10) unsigned NOT NULL DEFAULT '1',
279  `description` varchar(255) COLLATE utf8_bin DEFAULT NULL,
280  `calendarorder` int(10) unsigned NOT NULL DEFAULT '0',
281  `calendarcolor` varchar(255) COLLATE utf8_bin DEFAULT NULL,
282  `timezone` longtext COLLATE utf8_bin,
283  `components` varchar(20) COLLATE utf8_bin DEFAULT NULL,
284  `transparent` smallint(6) NOT NULL DEFAULT '0',
285  PRIMARY KEY (`id`),
286  UNIQUE KEY `calendars_index` (`principaluri`,`uri`)
287) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
288/*!40101 SET character_set_client = @saved_cs_client */;
289
290--
291-- Dumping data for table `oc_calendars`
292--
293
294LOCK TABLES `oc_calendars` WRITE;
295/*!40000 ALTER TABLE `oc_calendars` DISABLE KEYS */;
296/*!40000 ALTER TABLE `oc_calendars` ENABLE KEYS */;
297UNLOCK TABLES;
298
299--
300-- Table structure for table `oc_calendarsubscriptions`
301--
302
303DROP TABLE IF EXISTS `oc_calendarsubscriptions`;
304/*!40101 SET @saved_cs_client     = @@character_set_client */;
305/*!40101 SET character_set_client = utf8 */;
306CREATE TABLE `oc_calendarsubscriptions` (
307  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
308  `uri` varchar(255) COLLATE utf8_bin DEFAULT NULL,
309  `principaluri` varchar(255) COLLATE utf8_bin DEFAULT NULL,
310  `source` varchar(255) COLLATE utf8_bin DEFAULT NULL,
311  `displayname` varchar(100) COLLATE utf8_bin DEFAULT NULL,
312  `refreshrate` varchar(10) COLLATE utf8_bin DEFAULT NULL,
313  `calendarorder` int(10) unsigned NOT NULL DEFAULT '0',
314  `calendarcolor` varchar(255) COLLATE utf8_bin DEFAULT NULL,
315  `striptodos` smallint(6) DEFAULT NULL,
316  `stripalarms` smallint(6) DEFAULT NULL,
317  `stripattachments` smallint(6) DEFAULT NULL,
318  `lastmodified` int(10) unsigned DEFAULT NULL,
319  PRIMARY KEY (`id`),
320  UNIQUE KEY `calsub_index` (`principaluri`,`uri`)
321) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
322/*!40101 SET character_set_client = @saved_cs_client */;
323
324--
325-- Dumping data for table `oc_calendarsubscriptions`
326--
327
328LOCK TABLES `oc_calendarsubscriptions` WRITE;
329/*!40000 ALTER TABLE `oc_calendarsubscriptions` DISABLE KEYS */;
330/*!40000 ALTER TABLE `oc_calendarsubscriptions` ENABLE KEYS */;
331UNLOCK TABLES;
332
333--
334-- Table structure for table `oc_cards`
335--
336
337DROP TABLE IF EXISTS `oc_cards`;
338/*!40101 SET @saved_cs_client     = @@character_set_client */;
339/*!40101 SET character_set_client = utf8 */;
340CREATE TABLE `oc_cards` (
341  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
342  `addressbookid` int(11) NOT NULL DEFAULT '0',
343  `carddata` longblob,
344  `uri` varchar(255) COLLATE utf8_bin DEFAULT NULL,
345  `lastmodified` bigint(20) unsigned DEFAULT NULL,
346  `etag` varchar(32) COLLATE utf8_bin DEFAULT NULL,
347  `size` bigint(20) unsigned NOT NULL,
348  PRIMARY KEY (`id`)
349) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
350/*!40101 SET character_set_client = @saved_cs_client */;
351
352--
353-- Dumping data for table `oc_cards`
354--
355
356LOCK TABLES `oc_cards` WRITE;
357/*!40000 ALTER TABLE `oc_cards` DISABLE KEYS */;
358/*!40000 ALTER TABLE `oc_cards` ENABLE KEYS */;
359UNLOCK TABLES;
360
361--
362-- Table structure for table `oc_cards_properties`
363--
364
365DROP TABLE IF EXISTS `oc_cards_properties`;
366/*!40101 SET @saved_cs_client     = @@character_set_client */;
367/*!40101 SET character_set_client = utf8 */;
368CREATE TABLE `oc_cards_properties` (
369  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
370  `addressbookid` bigint(20) NOT NULL DEFAULT '0',
371  `cardid` bigint(20) unsigned NOT NULL DEFAULT '0',
372  `name` varchar(64) COLLATE utf8_bin DEFAULT NULL,
373  `value` varchar(255) COLLATE utf8_bin DEFAULT NULL,
374  `preferred` int(11) NOT NULL DEFAULT '1',
375  PRIMARY KEY (`id`),
376  KEY `card_contactid_index` (`cardid`),
377  KEY `card_name_index` (`name`),
378  KEY `card_value_index` (`value`)
379) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
380/*!40101 SET character_set_client = @saved_cs_client */;
381
382--
383-- Dumping data for table `oc_cards_properties`
384--
385
386LOCK TABLES `oc_cards_properties` WRITE;
387/*!40000 ALTER TABLE `oc_cards_properties` DISABLE KEYS */;
388/*!40000 ALTER TABLE `oc_cards_properties` ENABLE KEYS */;
389UNLOCK TABLES;
390
391--
392-- Table structure for table `oc_comments`
393--
394
395DROP TABLE IF EXISTS `oc_comments`;
396/*!40101 SET @saved_cs_client     = @@character_set_client */;
397/*!40101 SET character_set_client = utf8 */;
398CREATE TABLE `oc_comments` (
399  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
400  `parent_id` int(10) unsigned NOT NULL DEFAULT '0',
401  `topmost_parent_id` int(10) unsigned NOT NULL DEFAULT '0',
402  `children_count` int(10) unsigned NOT NULL DEFAULT '0',
403  `actor_type` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
404  `actor_id` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
405  `message` longtext COLLATE utf8_bin,
406  `verb` varchar(64) COLLATE utf8_bin DEFAULT NULL,
407  `creation_timestamp` datetime DEFAULT NULL,
408  `latest_child_timestamp` datetime DEFAULT NULL,
409  `object_type` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
410  `object_id` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
411  PRIMARY KEY (`id`),
412  KEY `comments_parent_id_index` (`parent_id`),
413  KEY `comments_topmost_parent_id_idx` (`topmost_parent_id`),
414  KEY `comments_object_index` (`object_type`,`object_id`,`creation_timestamp`),
415  KEY `comments_actor_index` (`actor_type`,`actor_id`)
416) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
417/*!40101 SET character_set_client = @saved_cs_client */;
418
419--
420-- Dumping data for table `oc_comments`
421--
422
423LOCK TABLES `oc_comments` WRITE;
424/*!40000 ALTER TABLE `oc_comments` DISABLE KEYS */;
425/*!40000 ALTER TABLE `oc_comments` ENABLE KEYS */;
426UNLOCK TABLES;
427
428--
429-- Table structure for table `oc_comments_read_markers`
430--
431
432DROP TABLE IF EXISTS `oc_comments_read_markers`;
433/*!40101 SET @saved_cs_client     = @@character_set_client */;
434/*!40101 SET character_set_client = utf8 */;
435CREATE TABLE `oc_comments_read_markers` (
436  `user_id` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
437  `marker_datetime` datetime DEFAULT NULL,
438  `object_type` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
439  `object_id` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
440  UNIQUE KEY `comments_marker_index` (`user_id`,`object_type`,`object_id`),
441  KEY `comments_marker_object_index` (`object_type`,`object_id`)
442) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
443/*!40101 SET character_set_client = @saved_cs_client */;
444
445--
446-- Dumping data for table `oc_comments_read_markers`
447--
448
449LOCK TABLES `oc_comments_read_markers` WRITE;
450/*!40000 ALTER TABLE `oc_comments_read_markers` DISABLE KEYS */;
451/*!40000 ALTER TABLE `oc_comments_read_markers` ENABLE KEYS */;
452UNLOCK TABLES;
453
454--
455-- Table structure for table `oc_credentials`
456--
457
458DROP TABLE IF EXISTS `oc_credentials`;
459/*!40101 SET @saved_cs_client     = @@character_set_client */;
460/*!40101 SET character_set_client = utf8 */;
461CREATE TABLE `oc_credentials` (
462  `user` varchar(64) COLLATE utf8_bin NOT NULL,
463  `identifier` varchar(64) COLLATE utf8_bin NOT NULL,
464  `credentials` longtext COLLATE utf8_bin,
465  PRIMARY KEY (`user`,`identifier`),
466  KEY `credentials_user` (`user`)
467) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
468/*!40101 SET character_set_client = @saved_cs_client */;
469
470--
471-- Dumping data for table `oc_credentials`
472--
473
474LOCK TABLES `oc_credentials` WRITE;
475/*!40000 ALTER TABLE `oc_credentials` DISABLE KEYS */;
476/*!40000 ALTER TABLE `oc_credentials` ENABLE KEYS */;
477UNLOCK TABLES;
478
479--
480-- Table structure for table `oc_dav_shares`
481--
482
483DROP TABLE IF EXISTS `oc_dav_shares`;
484/*!40101 SET @saved_cs_client     = @@character_set_client */;
485/*!40101 SET character_set_client = utf8 */;
486CREATE TABLE `oc_dav_shares` (
487  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
488  `principaluri` varchar(255) COLLATE utf8_bin DEFAULT NULL,
489  `type` varchar(255) COLLATE utf8_bin DEFAULT NULL,
490  `access` smallint(6) DEFAULT NULL,
491  `resourceid` int(10) unsigned NOT NULL,
492  PRIMARY KEY (`id`),
493  UNIQUE KEY `dav_shares_index` (`principaluri`,`resourceid`,`type`)
494) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
495/*!40101 SET character_set_client = @saved_cs_client */;
496
497--
498-- Dumping data for table `oc_dav_shares`
499--
500
501LOCK TABLES `oc_dav_shares` WRITE;
502/*!40000 ALTER TABLE `oc_dav_shares` DISABLE KEYS */;
503/*!40000 ALTER TABLE `oc_dav_shares` ENABLE KEYS */;
504UNLOCK TABLES;
505
506--
507-- Table structure for table `oc_federated_reshares`
508--
509
510DROP TABLE IF EXISTS `oc_federated_reshares`;
511/*!40101 SET @saved_cs_client     = @@character_set_client */;
512/*!40101 SET character_set_client = utf8 */;
513CREATE TABLE `oc_federated_reshares` (
514  `share_id` int(11) NOT NULL,
515  `remote_id` int(11) NOT NULL COMMENT 'share ID at the remote server',
516  UNIQUE KEY `share_id_index` (`share_id`)
517) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
518/*!40101 SET character_set_client = @saved_cs_client */;
519
520--
521-- Dumping data for table `oc_federated_reshares`
522--
523
524LOCK TABLES `oc_federated_reshares` WRITE;
525/*!40000 ALTER TABLE `oc_federated_reshares` DISABLE KEYS */;
526/*!40000 ALTER TABLE `oc_federated_reshares` ENABLE KEYS */;
527UNLOCK TABLES;
528
529--
530-- Table structure for table `oc_file_locks`
531--
532
533DROP TABLE IF EXISTS `oc_file_locks`;
534/*!40101 SET @saved_cs_client     = @@character_set_client */;
535/*!40101 SET character_set_client = utf8 */;
536CREATE TABLE `oc_file_locks` (
537  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
538  `lock` int(11) NOT NULL DEFAULT '0',
539  `key` varchar(64) COLLATE utf8_bin NOT NULL,
540  `ttl` int(11) NOT NULL DEFAULT '-1',
541  PRIMARY KEY (`id`),
542  UNIQUE KEY `lock_key_index` (`key`),
543  KEY `lock_ttl_index` (`ttl`)
544) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
545/*!40101 SET character_set_client = @saved_cs_client */;
546
547--
548-- Dumping data for table `oc_file_locks`
549--
550
551LOCK TABLES `oc_file_locks` WRITE;
552/*!40000 ALTER TABLE `oc_file_locks` DISABLE KEYS */;
553INSERT 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);
554/*!40000 ALTER TABLE `oc_file_locks` ENABLE KEYS */;
555UNLOCK TABLES;
556
557--
558-- Table structure for table `oc_filecache`
559--
560
561DROP TABLE IF EXISTS `oc_filecache`;
562/*!40101 SET @saved_cs_client     = @@character_set_client */;
563/*!40101 SET character_set_client = utf8 */;
564CREATE TABLE `oc_filecache` (
565  `fileid` int(11) NOT NULL AUTO_INCREMENT,
566  `storage` int(11) NOT NULL DEFAULT '0',
567  `path` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
568  `path_hash` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
569  `parent` int(11) NOT NULL DEFAULT '0',
570  `name` varchar(250) COLLATE utf8_bin DEFAULT NULL,
571  `mimetype` int(11) NOT NULL DEFAULT '0',
572  `mimepart` int(11) NOT NULL DEFAULT '0',
573  `size` bigint(20) NOT NULL DEFAULT '0',
574  `mtime` int(11) NOT NULL DEFAULT '0',
575  `storage_mtime` int(11) NOT NULL DEFAULT '0',
576  `encrypted` int(11) NOT NULL DEFAULT '0',
577  `unencrypted_size` bigint(20) NOT NULL DEFAULT '0',
578  `etag` varchar(40) COLLATE utf8_bin DEFAULT NULL,
579  `permissions` int(11) DEFAULT '0',
580  `checksum` varchar(255) COLLATE utf8_bin DEFAULT NULL,
581  PRIMARY KEY (`fileid`),
582  UNIQUE KEY `fs_storage_path_hash` (`storage`,`path_hash`),
583  KEY `fs_parent_name_hash` (`parent`,`name`),
584  KEY `fs_storage_mimetype` (`storage`,`mimetype`),
585  KEY `fs_storage_mimepart` (`storage`,`mimepart`),
586  KEY `fs_storage_size` (`storage`,`size`,`fileid`)
587) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
588/*!40101 SET character_set_client = @saved_cs_client */;
589
590--
591-- Dumping data for table `oc_filecache`
592--
593
594LOCK TABLES `oc_filecache` WRITE;
595/*!40000 ALTER TABLE `oc_filecache` DISABLE KEYS */;
596INSERT 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,'');
597/*!40000 ALTER TABLE `oc_filecache` ENABLE KEYS */;
598UNLOCK TABLES;
599
600--
601-- Table structure for table `oc_files_trash`
602--
603
604DROP TABLE IF EXISTS `oc_files_trash`;
605/*!40101 SET @saved_cs_client     = @@character_set_client */;
606/*!40101 SET character_set_client = utf8 */;
607CREATE TABLE `oc_files_trash` (
608  `auto_id` int(11) NOT NULL AUTO_INCREMENT,
609  `id` varchar(250) COLLATE utf8_bin NOT NULL DEFAULT '',
610  `user` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
611  `timestamp` varchar(12) COLLATE utf8_bin NOT NULL DEFAULT '',
612  `location` varchar(512) COLLATE utf8_bin NOT NULL DEFAULT '',
613  `type` varchar(4) COLLATE utf8_bin DEFAULT NULL,
614  `mime` varchar(255) COLLATE utf8_bin DEFAULT NULL,
615  PRIMARY KEY (`auto_id`),
616  KEY `id_index` (`id`),
617  KEY `timestamp_index` (`timestamp`),
618  KEY `user_index` (`user`)
619) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
620/*!40101 SET character_set_client = @saved_cs_client */;
621
622--
623-- Dumping data for table `oc_files_trash`
624--
625
626LOCK TABLES `oc_files_trash` WRITE;
627/*!40000 ALTER TABLE `oc_files_trash` DISABLE KEYS */;
628/*!40000 ALTER TABLE `oc_files_trash` ENABLE KEYS */;
629UNLOCK TABLES;
630
631--
632-- Table structure for table `oc_group_admin`
633--
634
635DROP TABLE IF EXISTS `oc_group_admin`;
636/*!40101 SET @saved_cs_client     = @@character_set_client */;
637/*!40101 SET character_set_client = utf8 */;
638CREATE TABLE `oc_group_admin` (
639  `gid` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
640  `uid` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
641  PRIMARY KEY (`gid`,`uid`),
642  KEY `group_admin_uid` (`uid`)
643) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
644/*!40101 SET character_set_client = @saved_cs_client */;
645
646--
647-- Dumping data for table `oc_group_admin`
648--
649
650LOCK TABLES `oc_group_admin` WRITE;
651/*!40000 ALTER TABLE `oc_group_admin` DISABLE KEYS */;
652/*!40000 ALTER TABLE `oc_group_admin` ENABLE KEYS */;
653UNLOCK TABLES;
654
655--
656-- Table structure for table `oc_group_user`
657--
658
659DROP TABLE IF EXISTS `oc_group_user`;
660/*!40101 SET @saved_cs_client     = @@character_set_client */;
661/*!40101 SET character_set_client = utf8 */;
662CREATE TABLE `oc_group_user` (
663  `gid` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
664  `uid` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
665  PRIMARY KEY (`gid`,`uid`),
666  KEY `gu_uid_index` (`uid`)
667) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
668/*!40101 SET character_set_client = @saved_cs_client */;
669
670--
671-- Dumping data for table `oc_group_user`
672--
673
674LOCK TABLES `oc_group_user` WRITE;
675/*!40000 ALTER TABLE `oc_group_user` DISABLE KEYS */;
676INSERT INTO `oc_group_user` VALUES ('admin','{{ ADMIN_USER }}');
677/*!40000 ALTER TABLE `oc_group_user` ENABLE KEYS */;
678UNLOCK TABLES;
679
680--
681-- Table structure for table `oc_groups`
682--
683
684DROP TABLE IF EXISTS `oc_groups`;
685/*!40101 SET @saved_cs_client     = @@character_set_client */;
686/*!40101 SET character_set_client = utf8 */;
687CREATE TABLE `oc_groups` (
688  `gid` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
689  PRIMARY KEY (`gid`)
690) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
691/*!40101 SET character_set_client = @saved_cs_client */;
692
693--
694-- Dumping data for table `oc_groups`
695--
696
697LOCK TABLES `oc_groups` WRITE;
698/*!40000 ALTER TABLE `oc_groups` DISABLE KEYS */;
699INSERT INTO `oc_groups` VALUES ('admin');
700/*!40000 ALTER TABLE `oc_groups` ENABLE KEYS */;
701UNLOCK TABLES;
702
703--
704-- Table structure for table `oc_jobs`
705--
706
707DROP TABLE IF EXISTS `oc_jobs`;
708/*!40101 SET @saved_cs_client     = @@character_set_client */;
709/*!40101 SET character_set_client = utf8 */;
710CREATE TABLE `oc_jobs` (
711  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
712  `class` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
713  `argument` varchar(4000) COLLATE utf8_bin NOT NULL DEFAULT '',
714  `last_run` int(11) DEFAULT '0',
715  `last_checked` int(11) DEFAULT '0',
716  `reserved_at` int(11) DEFAULT '0',
717  PRIMARY KEY (`id`),
718  KEY `job_class_index` (`class`)
719) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
720/*!40101 SET character_set_client = @saved_cs_client */;
721
722--
723-- Dumping data for table `oc_jobs`
724--
725
726LOCK TABLES `oc_jobs` WRITE;
727/*!40000 ALTER TABLE `oc_jobs` DISABLE KEYS */;
728INSERT 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);
729/*!40000 ALTER TABLE `oc_jobs` ENABLE KEYS */;
730UNLOCK TABLES;
731
732--
733-- Table structure for table `oc_ldap_group_mapping`
734--
735
736DROP TABLE IF EXISTS `oc_ldap_group_mapping`;
737/*!40101 SET @saved_cs_client     = @@character_set_client */;
738/*!40101 SET character_set_client = utf8 */;
739CREATE TABLE `oc_ldap_group_mapping` (
740  `ldap_dn` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
741  `owncloud_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
742  `directory_uuid` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
743  PRIMARY KEY (`ldap_dn`),
744  UNIQUE KEY `owncloud_name_groups` (`owncloud_name`)
745) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
746/*!40101 SET character_set_client = @saved_cs_client */;
747
748--
749-- Dumping data for table `oc_ldap_group_mapping`
750--
751
752LOCK TABLES `oc_ldap_group_mapping` WRITE;
753/*!40000 ALTER TABLE `oc_ldap_group_mapping` DISABLE KEYS */;
754/*!40000 ALTER TABLE `oc_ldap_group_mapping` ENABLE KEYS */;
755UNLOCK TABLES;
756
757--
758-- Table structure for table `oc_ldap_group_members`
759--
760
761DROP TABLE IF EXISTS `oc_ldap_group_members`;
762/*!40101 SET @saved_cs_client     = @@character_set_client */;
763/*!40101 SET character_set_client = utf8 */;
764CREATE TABLE `oc_ldap_group_members` (
765  `owncloudname` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
766  `owncloudusers` longtext COLLATE utf8_bin NOT NULL,
767  PRIMARY KEY (`owncloudname`)
768) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
769/*!40101 SET character_set_client = @saved_cs_client */;
770
771--
772-- Dumping data for table `oc_ldap_group_members`
773--
774
775LOCK TABLES `oc_ldap_group_members` WRITE;
776/*!40000 ALTER TABLE `oc_ldap_group_members` DISABLE KEYS */;
777/*!40000 ALTER TABLE `oc_ldap_group_members` ENABLE KEYS */;
778UNLOCK TABLES;
779
780--
781-- Table structure for table `oc_ldap_user_mapping`
782--
783
784DROP TABLE IF EXISTS `oc_ldap_user_mapping`;
785/*!40101 SET @saved_cs_client     = @@character_set_client */;
786/*!40101 SET character_set_client = utf8 */;
787CREATE TABLE `oc_ldap_user_mapping` (
788  `ldap_dn` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
789  `owncloud_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
790  `directory_uuid` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
791  PRIMARY KEY (`owncloud_name`),
792  UNIQUE KEY `ldap_dn_users` (`ldap_dn`)
793) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
794/*!40101 SET character_set_client = @saved_cs_client */;
795
796--
797-- Dumping data for table `oc_ldap_user_mapping`
798--
799
800LOCK TABLES `oc_ldap_user_mapping` WRITE;
801/*!40000 ALTER TABLE `oc_ldap_user_mapping` DISABLE KEYS */;
802/*!40000 ALTER TABLE `oc_ldap_user_mapping` ENABLE KEYS */;
803UNLOCK TABLES;
804
805--
806-- Table structure for table `oc_mimetypes`
807--
808
809DROP TABLE IF EXISTS `oc_mimetypes`;
810/*!40101 SET @saved_cs_client     = @@character_set_client */;
811/*!40101 SET character_set_client = utf8 */;
812CREATE TABLE `oc_mimetypes` (
813  `id` int(11) NOT NULL AUTO_INCREMENT,
814  `mimetype` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
815  PRIMARY KEY (`id`),
816  UNIQUE KEY `mimetype_id_index` (`mimetype`)
817) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
818/*!40101 SET character_set_client = @saved_cs_client */;
819
820--
821-- Dumping data for table `oc_mimetypes`
822--
823
824LOCK TABLES `oc_mimetypes` WRITE;
825/*!40000 ALTER TABLE `oc_mimetypes` DISABLE KEYS */;
826INSERT 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');
827/*!40000 ALTER TABLE `oc_mimetypes` ENABLE KEYS */;
828UNLOCK TABLES;
829
830--
831-- Table structure for table `oc_mounts`
832--
833
834DROP TABLE IF EXISTS `oc_mounts`;
835/*!40101 SET @saved_cs_client     = @@character_set_client */;
836/*!40101 SET character_set_client = utf8 */;
837CREATE TABLE `oc_mounts` (
838  `id` int(11) NOT NULL AUTO_INCREMENT,
839  `storage_id` int(11) NOT NULL,
840  `root_id` int(11) NOT NULL,
841  `user_id` varchar(64) COLLATE utf8_bin NOT NULL,
842  `mount_point` varchar(4000) COLLATE utf8_bin NOT NULL,
843  PRIMARY KEY (`id`),
844  UNIQUE KEY `mounts_user_root_index` (`user_id`,`root_id`),
845  KEY `mounts_user_index` (`user_id`),
846  KEY `mounts_storage_index` (`storage_id`),
847  KEY `mounts_root_index` (`root_id`)
848) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
849/*!40101 SET character_set_client = @saved_cs_client */;
850
851--
852-- Dumping data for table `oc_mounts`
853--
854
855LOCK TABLES `oc_mounts` WRITE;
856/*!40000 ALTER TABLE `oc_mounts` DISABLE KEYS */;
857INSERT INTO `oc_mounts` VALUES (1,1,1,'owncloud_admin','/owncloud_admin/');
858/*!40000 ALTER TABLE `oc_mounts` ENABLE KEYS */;
859UNLOCK TABLES;
860
861--
862-- Table structure for table `oc_notifications`
863--
864
865DROP TABLE IF EXISTS `oc_notifications`;
866/*!40101 SET @saved_cs_client     = @@character_set_client */;
867/*!40101 SET character_set_client = utf8 */;
868CREATE TABLE `oc_notifications` (
869  `notification_id` int(11) NOT NULL AUTO_INCREMENT,
870  `app` varchar(32) COLLATE utf8_bin NOT NULL,
871  `user` varchar(64) COLLATE utf8_bin NOT NULL,
872  `timestamp` int(11) NOT NULL DEFAULT '0',
873  `object_type` varchar(64) COLLATE utf8_bin NOT NULL,
874  `object_id` varchar(64) COLLATE utf8_bin NOT NULL,
875  `subject` varchar(64) COLLATE utf8_bin NOT NULL,
876  `subject_parameters` longtext COLLATE utf8_bin,
877  `message` varchar(64) COLLATE utf8_bin DEFAULT NULL,
878  `message_parameters` longtext COLLATE utf8_bin,
879  `link` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
880  `actions` longtext COLLATE utf8_bin,
881  PRIMARY KEY (`notification_id`),
882  KEY `oc_notifications_app` (`app`),
883  KEY `oc_notifications_user` (`user`),
884  KEY `oc_notifications_timestamp` (`timestamp`),
885  KEY `oc_notifications_object` (`object_type`,`object_id`)
886) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
887/*!40101 SET character_set_client = @saved_cs_client */;
888
889--
890-- Dumping data for table `oc_notifications`
891--
892
893LOCK TABLES `oc_notifications` WRITE;
894/*!40000 ALTER TABLE `oc_notifications` DISABLE KEYS */;
895/*!40000 ALTER TABLE `oc_notifications` ENABLE KEYS */;
896UNLOCK TABLES;
897
898--
899-- Table structure for table `oc_preferences`
900--
901
902DROP TABLE IF EXISTS `oc_preferences`;
903/*!40101 SET @saved_cs_client     = @@character_set_client */;
904/*!40101 SET character_set_client = utf8 */;
905CREATE TABLE `oc_preferences` (
906  `userid` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
907  `appid` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
908  `configkey` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
909  `configvalue` longtext COLLATE utf8_bin,
910  PRIMARY KEY (`userid`,`appid`,`configkey`)
911) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
912/*!40101 SET character_set_client = @saved_cs_client */;
913
914--
915-- Dumping data for table `oc_preferences`
916--
917
918LOCK TABLES `oc_preferences` WRITE;
919/*!40000 ALTER TABLE `oc_preferences` DISABLE KEYS */;
920INSERT INTO `oc_preferences` VALUES  ('{{ ADMIN_USER }}','core','lang','es'),('{{ ADMIN_USER }}','firstrunwizard','show','0');
921/*!40000 ALTER TABLE `oc_preferences` ENABLE KEYS */;
922UNLOCK TABLES;
923
924--
925-- Table structure for table `oc_privatedata`
926--
927
928DROP TABLE IF EXISTS `oc_privatedata`;
929/*!40101 SET @saved_cs_client     = @@character_set_client */;
930/*!40101 SET character_set_client = utf8 */;
931CREATE TABLE `oc_privatedata` (
932  `keyid` int(10) unsigned NOT NULL AUTO_INCREMENT,
933  `user` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
934  `app` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
935  `key` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
936  `value` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
937  PRIMARY KEY (`keyid`)
938) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
939/*!40101 SET character_set_client = @saved_cs_client */;
940
941--
942-- Dumping data for table `oc_privatedata`
943--
944
945LOCK TABLES `oc_privatedata` WRITE;
946/*!40000 ALTER TABLE `oc_privatedata` DISABLE KEYS */;
947/*!40000 ALTER TABLE `oc_privatedata` ENABLE KEYS */;
948UNLOCK TABLES;
949
950--
951-- Table structure for table `oc_properties`
952--
953
954DROP TABLE IF EXISTS `oc_properties`;
955/*!40101 SET @saved_cs_client     = @@character_set_client */;
956/*!40101 SET character_set_client = utf8 */;
957CREATE TABLE `oc_properties` (
958  `id` int(11) NOT NULL AUTO_INCREMENT,
959  `userid` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
960  `propertypath` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
961  `propertyname` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
962  `propertyvalue` varchar(255) COLLATE utf8_bin NOT NULL,
963  PRIMARY KEY (`id`),
964  KEY `property_index` (`userid`)
965) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
966/*!40101 SET character_set_client = @saved_cs_client */;
967
968--
969-- Dumping data for table `oc_properties`
970--
971
972LOCK TABLES `oc_properties` WRITE;
973/*!40000 ALTER TABLE `oc_properties` DISABLE KEYS */;
974/*!40000 ALTER TABLE `oc_properties` ENABLE KEYS */;
975UNLOCK TABLES;
976
977--
978-- Table structure for table `oc_schedulingobjects`
979--
980
981DROP TABLE IF EXISTS `oc_schedulingobjects`;
982/*!40101 SET @saved_cs_client     = @@character_set_client */;
983/*!40101 SET character_set_client = utf8 */;
984CREATE TABLE `oc_schedulingobjects` (
985  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
986  `principaluri` varchar(255) COLLATE utf8_bin DEFAULT NULL,
987  `calendardata` longblob,
988  `uri` varchar(255) COLLATE utf8_bin DEFAULT NULL,
989  `lastmodified` int(10) unsigned DEFAULT NULL,
990  `etag` varchar(32) COLLATE utf8_bin DEFAULT NULL,
991  `size` bigint(20) unsigned NOT NULL,
992  PRIMARY KEY (`id`)
993) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
994/*!40101 SET character_set_client = @saved_cs_client */;
995
996--
997-- Dumping data for table `oc_schedulingobjects`
998--
999
1000LOCK TABLES `oc_schedulingobjects` WRITE;
1001/*!40000 ALTER TABLE `oc_schedulingobjects` DISABLE KEYS */;
1002/*!40000 ALTER TABLE `oc_schedulingobjects` ENABLE KEYS */;
1003UNLOCK TABLES;
1004
1005--
1006-- Table structure for table `oc_share`
1007--
1008
1009DROP TABLE IF EXISTS `oc_share`;
1010/*!40101 SET @saved_cs_client     = @@character_set_client */;
1011/*!40101 SET character_set_client = utf8 */;
1012CREATE TABLE `oc_share` (
1013  `id` int(11) NOT NULL AUTO_INCREMENT,
1014  `share_type` smallint(6) NOT NULL DEFAULT '0',
1015  `share_with` varchar(255) COLLATE utf8_bin DEFAULT NULL,
1016  `uid_owner` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
1017  `uid_initiator` varchar(64) COLLATE utf8_bin DEFAULT NULL,
1018  `parent` int(11) DEFAULT NULL,
1019  `item_type` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
1020  `item_source` varchar(255) COLLATE utf8_bin DEFAULT NULL,
1021  `item_target` varchar(255) COLLATE utf8_bin DEFAULT NULL,
1022  `file_source` int(11) DEFAULT NULL,
1023  `file_target` varchar(512) COLLATE utf8_bin DEFAULT NULL,
1024  `permissions` smallint(6) NOT NULL DEFAULT '0',
1025  `stime` bigint(20) NOT NULL DEFAULT '0',
1026  `accepted` smallint(6) NOT NULL DEFAULT '0',
1027  `expiration` datetime DEFAULT NULL,
1028  `token` varchar(32) COLLATE utf8_bin DEFAULT NULL,
1029  `mail_send` smallint(6) NOT NULL DEFAULT '0',
1030  PRIMARY KEY (`id`),
1031  KEY `item_share_type_index` (`item_type`,`share_type`),
1032  KEY `file_source_index` (`file_source`),
1033  KEY `token_index` (`token`)
1034) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1035/*!40101 SET character_set_client = @saved_cs_client */;
1036
1037--
1038-- Dumping data for table `oc_share`
1039--
1040
1041LOCK TABLES `oc_share` WRITE;
1042/*!40000 ALTER TABLE `oc_share` DISABLE KEYS */;
1043/*!40000 ALTER TABLE `oc_share` ENABLE KEYS */;
1044UNLOCK TABLES;
1045
1046--
1047-- Table structure for table `oc_share_external`
1048--
1049
1050DROP TABLE IF EXISTS `oc_share_external`;
1051/*!40101 SET @saved_cs_client     = @@character_set_client */;
1052/*!40101 SET character_set_client = utf8 */;
1053CREATE TABLE `oc_share_external` (
1054  `id` int(11) NOT NULL AUTO_INCREMENT,
1055  `remote` varchar(512) COLLATE utf8_bin NOT NULL COMMENT 'Url of the remove owncloud instance',
1056  `remote_id` int(11) NOT NULL DEFAULT '-1',
1057  `share_token` varchar(64) COLLATE utf8_bin NOT NULL COMMENT 'Public share token',
1058  `password` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT 'Optional password for the public share',
1059  `name` varchar(64) COLLATE utf8_bin NOT NULL COMMENT 'Original name on the remote server',
1060  `owner` varchar(64) COLLATE utf8_bin NOT NULL COMMENT 'User that owns the public share on the remote server',
1061  `user` varchar(64) COLLATE utf8_bin NOT NULL COMMENT 'Local user which added the external share',
1062  `mountpoint` varchar(4000) COLLATE utf8_bin NOT NULL COMMENT 'Full path where the share is mounted',
1063  `mountpoint_hash` varchar(32) COLLATE utf8_bin NOT NULL COMMENT 'md5 hash of the mountpoint',
1064  `accepted` int(11) NOT NULL DEFAULT '0',
1065  PRIMARY KEY (`id`),
1066  UNIQUE KEY `sh_external_mp` (`user`,`mountpoint_hash`),
1067  KEY `sh_external_user` (`user`)
1068) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1069/*!40101 SET character_set_client = @saved_cs_client */;
1070
1071--
1072-- Dumping data for table `oc_share_external`
1073--
1074
1075LOCK TABLES `oc_share_external` WRITE;
1076/*!40000 ALTER TABLE `oc_share_external` DISABLE KEYS */;
1077/*!40000 ALTER TABLE `oc_share_external` ENABLE KEYS */;
1078UNLOCK TABLES;
1079
1080--
1081-- Table structure for table `oc_storages`
1082--
1083
1084DROP TABLE IF EXISTS `oc_storages`;
1085/*!40101 SET @saved_cs_client     = @@character_set_client */;
1086/*!40101 SET character_set_client = utf8 */;
1087CREATE TABLE `oc_storages` (
1088  `id` varchar(64) COLLATE utf8_bin DEFAULT NULL,
1089  `numeric_id` int(11) NOT NULL AUTO_INCREMENT,
1090  `available` int(11) NOT NULL DEFAULT '1',
1091  `last_checked` int(11) DEFAULT NULL,
1092  PRIMARY KEY (`numeric_id`),
1093  UNIQUE KEY `storages_id_index` (`id`)
1094) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1095/*!40101 SET character_set_client = @saved_cs_client */;
1096
1097--
1098-- Dumping data for table `oc_storages`
1099--
1100
1101LOCK TABLES `oc_storages` WRITE;
1102/*!40000 ALTER TABLE `oc_storages` DISABLE KEYS */;
1103INSERT INTO `oc_storages` VALUES ('home::{{ ADMIN_USER }}',1,1,NULL),('local::/var/www/owncloud/data/',2,1,NULL);
1104/*!40000 ALTER TABLE `oc_storages` ENABLE KEYS */;
1105UNLOCK TABLES;
1106
1107--
1108-- Table structure for table `oc_systemtag`
1109--
1110
1111DROP TABLE IF EXISTS `oc_systemtag`;
1112/*!40101 SET @saved_cs_client     = @@character_set_client */;
1113/*!40101 SET character_set_client = utf8 */;
1114CREATE TABLE `oc_systemtag` (
1115  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1116  `name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
1117  `visibility` smallint(6) NOT NULL DEFAULT '1',
1118  `editable` smallint(6) NOT NULL DEFAULT '1',
1119  PRIMARY KEY (`id`),
1120  UNIQUE KEY `tag_ident` (`name`,`visibility`,`editable`)
1121) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1122/*!40101 SET character_set_client = @saved_cs_client */;
1123
1124--
1125-- Dumping data for table `oc_systemtag`
1126--
1127
1128LOCK TABLES `oc_systemtag` WRITE;
1129/*!40000 ALTER TABLE `oc_systemtag` DISABLE KEYS */;
1130/*!40000 ALTER TABLE `oc_systemtag` ENABLE KEYS */;
1131UNLOCK TABLES;
1132
1133--
1134-- Table structure for table `oc_systemtag_group`
1135--
1136
1137DROP TABLE IF EXISTS `oc_systemtag_group`;
1138/*!40101 SET @saved_cs_client     = @@character_set_client */;
1139/*!40101 SET character_set_client = utf8 */;
1140CREATE TABLE `oc_systemtag_group` (
1141  `systemtagid` int(10) unsigned NOT NULL DEFAULT '0',
1142  `gid` varchar(255) COLLATE utf8_bin NOT NULL,
1143  PRIMARY KEY (`gid`,`systemtagid`)
1144) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1145/*!40101 SET character_set_client = @saved_cs_client */;
1146
1147--
1148-- Dumping data for table `oc_systemtag_group`
1149--
1150
1151LOCK TABLES `oc_systemtag_group` WRITE;
1152/*!40000 ALTER TABLE `oc_systemtag_group` DISABLE KEYS */;
1153/*!40000 ALTER TABLE `oc_systemtag_group` ENABLE KEYS */;
1154UNLOCK TABLES;
1155
1156--
1157-- Table structure for table `oc_systemtag_object_mapping`
1158--
1159
1160DROP TABLE IF EXISTS `oc_systemtag_object_mapping`;
1161/*!40101 SET @saved_cs_client     = @@character_set_client */;
1162/*!40101 SET character_set_client = utf8 */;
1163CREATE TABLE `oc_systemtag_object_mapping` (
1164  `objectid` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
1165  `objecttype` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
1166  `systemtagid` int(10) unsigned NOT NULL DEFAULT '0',
1167  UNIQUE KEY `mapping` (`objecttype`,`objectid`,`systemtagid`)
1168) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1169/*!40101 SET character_set_client = @saved_cs_client */;
1170
1171--
1172-- Dumping data for table `oc_systemtag_object_mapping`
1173--
1174
1175LOCK TABLES `oc_systemtag_object_mapping` WRITE;
1176/*!40000 ALTER TABLE `oc_systemtag_object_mapping` DISABLE KEYS */;
1177/*!40000 ALTER TABLE `oc_systemtag_object_mapping` ENABLE KEYS */;
1178UNLOCK TABLES;
1179
1180--
1181-- Table structure for table `oc_trusted_servers`
1182--
1183
1184DROP TABLE IF EXISTS `oc_trusted_servers`;
1185/*!40101 SET @saved_cs_client     = @@character_set_client */;
1186/*!40101 SET character_set_client = utf8 */;
1187CREATE TABLE `oc_trusted_servers` (
1188  `id` int(11) NOT NULL AUTO_INCREMENT,
1189  `url` varchar(512) COLLATE utf8_bin NOT NULL COMMENT 'Url of trusted server',
1190  `url_hash` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT 'sha1 hash of the url without the protocol',
1191  `token` varchar(128) COLLATE utf8_bin DEFAULT NULL COMMENT 'token used to exchange the shared secret',
1192  `shared_secret` varchar(256) COLLATE utf8_bin DEFAULT NULL COMMENT 'shared secret used to authenticate',
1193  `status` int(11) NOT NULL DEFAULT '2' COMMENT 'current status of the connection',
1194  `sync_token` varchar(512) COLLATE utf8_bin DEFAULT NULL COMMENT 'cardDav sync token',
1195  PRIMARY KEY (`id`),
1196  UNIQUE KEY `url_hash` (`url_hash`)
1197) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1198/*!40101 SET character_set_client = @saved_cs_client */;
1199
1200--
1201-- Dumping data for table `oc_trusted_servers`
1202--
1203
1204LOCK TABLES `oc_trusted_servers` WRITE;
1205/*!40000 ALTER TABLE `oc_trusted_servers` DISABLE KEYS */;
1206/*!40000 ALTER TABLE `oc_trusted_servers` ENABLE KEYS */;
1207UNLOCK TABLES;
1208
1209--
1210-- Table structure for table `oc_users`
1211--
1212
1213DROP TABLE IF EXISTS `oc_users`;
1214/*!40101 SET @saved_cs_client     = @@character_set_client */;
1215/*!40101 SET character_set_client = utf8 */;
1216CREATE TABLE `oc_users` (
1217  `uid` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
1218  `displayname` varchar(64) COLLATE utf8_bin DEFAULT NULL,
1219  `password` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
1220  PRIMARY KEY (`uid`)
1221) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1222/*!40101 SET character_set_client = @saved_cs_client */;
1223
1224--
1225-- Dumping data for table `oc_users`
1226--
1227
1228LOCK TABLES `oc_users` WRITE;
1229/*!40000 ALTER TABLE `oc_users` DISABLE KEYS */;
1230INSERT INTO `oc_users` VALUES ('{{ ADMIN_USER }}',NULL,'1|{{ ADMIN_PWD }}');
1231/*!40000 ALTER TABLE `oc_users` ENABLE KEYS */;
1232UNLOCK TABLES;
1233
1234--
1235-- Table structure for table `oc_vcategory`
1236--
1237
1238DROP TABLE IF EXISTS `oc_vcategory`;
1239/*!40101 SET @saved_cs_client     = @@character_set_client */;
1240/*!40101 SET character_set_client = utf8 */;
1241CREATE TABLE `oc_vcategory` (
1242  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1243  `uid` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
1244  `type` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
1245  `category` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
1246  PRIMARY KEY (`id`),
1247  KEY `uid_index` (`uid`),
1248  KEY `type_index` (`type`),
1249  KEY `category_index` (`category`)
1250) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1251/*!40101 SET character_set_client = @saved_cs_client */;
1252
1253--
1254-- Dumping data for table `oc_vcategory`
1255--
1256
1257LOCK TABLES `oc_vcategory` WRITE;
1258/*!40000 ALTER TABLE `oc_vcategory` DISABLE KEYS */;
1259/*!40000 ALTER TABLE `oc_vcategory` ENABLE KEYS */;
1260UNLOCK TABLES;
1261
1262--
1263-- Table structure for table `oc_vcategory_to_object`
1264--
1265
1266DROP TABLE IF EXISTS `oc_vcategory_to_object`;
1267/*!40101 SET @saved_cs_client     = @@character_set_client */;
1268/*!40101 SET character_set_client = utf8 */;
1269CREATE TABLE `oc_vcategory_to_object` (
1270  `objid` int(10) unsigned NOT NULL DEFAULT '0',
1271  `categoryid` int(10) unsigned NOT NULL DEFAULT '0',
1272  `type` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
1273  PRIMARY KEY (`categoryid`,`objid`,`type`),
1274  KEY `vcategory_objectd_index` (`objid`,`type`)
1275) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1276/*!40101 SET character_set_client = @saved_cs_client */;
1277
1278--
1279-- Dumping data for table `oc_vcategory_to_object`
1280--
1281
1282LOCK TABLES `oc_vcategory_to_object` WRITE;
1283/*!40000 ALTER TABLE `oc_vcategory_to_object` DISABLE KEYS */;
1284/*!40000 ALTER TABLE `oc_vcategory_to_object` ENABLE KEYS */;
1285UNLOCK TABLES;
1286/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1287
1288/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1289/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1290/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1291/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1292/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1293/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1294/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1295
1296-- Dump completed on 2017-01-10 13:31:04
Note: See TracBrowser for help on using the repository browser.