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

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

Fix css and https access

File size: 50.6 KB
Line 
1-- MySQL dump 10.13  Distrib 5.7.12, for Linux (i686)
2--
3-- Host: localhost    Database: owncloud
4-- ------------------------------------------------------
5-- Server version       5.7.12-0ubuntu1
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) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
47/*!40101 SET character_set_client = @saved_cs_client */;
48
49--
50-- Dumping data for table `oc_activity`
51--
52
53LOCK TABLES `oc_activity` WRITE;
54/*!40000 ALTER TABLE `oc_activity` DISABLE KEYS */;
55/*!40000 ALTER TABLE `oc_activity` ENABLE KEYS */;
56UNLOCK TABLES;
57
58--
59-- Table structure for table `oc_activity_mq`
60--
61
62DROP TABLE IF EXISTS `oc_activity_mq`;
63/*!40101 SET @saved_cs_client     = @@character_set_client */;
64/*!40101 SET character_set_client = utf8 */;
65CREATE TABLE `oc_activity_mq` (
66  `mail_id` int(11) NOT NULL AUTO_INCREMENT,
67  `amq_timestamp` int(11) NOT NULL DEFAULT '0',
68  `amq_latest_send` int(11) NOT NULL DEFAULT '0',
69  `amq_type` varchar(255) COLLATE utf8_bin NOT NULL,
70  `amq_affecteduser` varchar(64) COLLATE utf8_bin NOT NULL,
71  `amq_appid` varchar(255) COLLATE utf8_bin NOT NULL,
72  `amq_subject` varchar(255) COLLATE utf8_bin NOT NULL,
73  `amq_subjectparams` varchar(4000) COLLATE utf8_bin NOT NULL,
74  PRIMARY KEY (`mail_id`),
75  KEY `amp_user` (`amq_affecteduser`),
76  KEY `amp_latest_send_time` (`amq_latest_send`),
77  KEY `amp_timestamp_time` (`amq_timestamp`)
78) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
79/*!40101 SET character_set_client = @saved_cs_client */;
80
81--
82-- Dumping data for table `oc_activity_mq`
83--
84
85LOCK TABLES `oc_activity_mq` WRITE;
86/*!40000 ALTER TABLE `oc_activity_mq` DISABLE KEYS */;
87/*!40000 ALTER TABLE `oc_activity_mq` ENABLE KEYS */;
88UNLOCK TABLES;
89
90--
91-- Table structure for table `oc_addressbookchanges`
92--
93
94DROP TABLE IF EXISTS `oc_addressbookchanges`;
95/*!40101 SET @saved_cs_client     = @@character_set_client */;
96/*!40101 SET character_set_client = utf8 */;
97CREATE TABLE `oc_addressbookchanges` (
98  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
99  `uri` varchar(255) COLLATE utf8_bin DEFAULT NULL,
100  `synctoken` int(10) unsigned NOT NULL DEFAULT '1',
101  `addressbookid` int(11) NOT NULL,
102  `operation` smallint(6) NOT NULL,
103  PRIMARY KEY (`id`),
104  KEY `addressbookid_synctoken` (`addressbookid`,`synctoken`)
105) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
106/*!40101 SET character_set_client = @saved_cs_client */;
107
108--
109-- Dumping data for table `oc_addressbookchanges`
110--
111
112LOCK TABLES `oc_addressbookchanges` WRITE;
113/*!40000 ALTER TABLE `oc_addressbookchanges` DISABLE KEYS */;
114INSERT INTO `oc_addressbookchanges` VALUES (1,'Database:owncloud_admin.vcf',1,1,1),(2,'LDAP:aa5cff10-a590-1035-9744-679cd252e7a8.vcf',2,1,1);
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 */;
143INSERT INTO `oc_addressbooks` VALUES (1,'principals/system/system','system','system','System addressbook which holds all users of this instance',3),(2,'principals/users/owncloud_admin','default','default',NULL,1);
144/*!40000 ALTER TABLE `oc_addressbooks` ENABLE KEYS */;
145UNLOCK TABLES;
146
147--
148-- Table structure for table `oc_appconfig`
149--
150
151DROP TABLE IF EXISTS `oc_appconfig`;
152/*!40101 SET @saved_cs_client     = @@character_set_client */;
153/*!40101 SET character_set_client = utf8 */;
154CREATE TABLE `oc_appconfig` (
155  `appid` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
156  `configkey` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
157  `configvalue` longtext COLLATE utf8_bin,
158  PRIMARY KEY (`appid`,`configkey`),
159  KEY `appconfig_config_key_index` (`configkey`),
160  KEY `appconfig_appid_key` (`appid`)
161) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
162/*!40101 SET character_set_client = @saved_cs_client */;
163
164--
165-- Dumping data for table `oc_appconfig`
166--
167
168LOCK TABLES `oc_appconfig` WRITE;
169/*!40000 ALTER TABLE `oc_appconfig` DISABLE KEYS */;
170INSERT INTO `oc_appconfig` VALUES ('activity','enabled','yes'),('activity','installed_version','2.2.1'),('activity','types','filesystem'),('backgroundjob','lastjob','12'),('calendar','enabled','no'),('calendar','installed_version','1.1'),('calendar','ocsid','168707'),('calendar','types',''),('comments','enabled','yes'),('comments','installed_version','0.2'),('comments','types','logging'),('core','installedat','1462298827.9119'),('core','lastcron','1462436029'),('core','lastupdatedat','1462298827.9194'),('core','oc.integritycheck.checker',''),('core','public_files','files_sharing/public.php'),('core','public_webdav','dav/appinfo/v1/publicwebdav.php'),('core','remote_caldav','dav/appinfo/v1/caldav.php'),('core','remote_calendar','dav/appinfo/v1/caldav.php'),('core','remote_carddav','dav/appinfo/v1/carddav.php'),('core','remote_contacts','dav/appinfo/v1/carddav.php'),('core','remote_dav','dav/appinfo/v2/remote.php'),('core','remote_files','dav/appinfo/v1/webdav.php'),('core','remote_webdav','dav/appinfo/v1/webdav.php'),('dav','enabled','yes'),('dav','installed_version','0.1.6'),('dav','types','filesystem'),('federatedfilesharing','enabled','yes'),('federatedfilesharing','installed_version','0.1.0'),('federatedfilesharing','types',''),('federation','enabled','yes'),('federation','installed_version','0.0.4'),('federation','types','authentication'),('files','cronjob_scan_files','500'),('files','enabled','yes'),('files','installed_version','1.4.4'),('files','types','filesystem'),('files_pdfviewer','enabled','yes'),('files_pdfviewer','installed_version','0.8'),('files_pdfviewer','ocsid','166049'),('files_pdfviewer','types',''),('files_sharing','enabled','yes'),('files_sharing','installed_version','0.9.1'),('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.8.0'),('files_trashbin','types','filesystem'),('files_versions','enabled','yes'),('files_versions','installed_version','1.2.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','14.5.0'),('gallery','types',''),('notifications','enabled','yes'),('notifications','installed_version','0.2.3'),('notifications','types','logging'),('provisioning_api','enabled','yes'),('provisioning_api','installed_version','0.4.1'),('provisioning_api','types','prevent_group_restriction'),('systemtags','enabled','yes'),('systemtags','installed_version','0.2'),('systemtags','types','logging'),('templateeditor','enabled','yes'),('templateeditor','installed_version','0.1'),('templateeditor','types',''),('updatenotification','enabled','yes'),('updatenotification','installed_version','0.1.0'),('updatenotification','types',''),('user_ldap','cleanUpJobOffset','0'),('user_ldap','enabled','yes'),('user_ldap','has_memberof_filter_support',''),('user_ldap','home_folder_naming_rule',''),('user_ldap','installed_version','0.8.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','1'),('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');
171/*!40000 ALTER TABLE `oc_appconfig` ENABLE KEYS */;
172UNLOCK TABLES;
173
174--
175-- Table structure for table `oc_calendarchanges`
176--
177
178DROP TABLE IF EXISTS `oc_calendarchanges`;
179/*!40101 SET @saved_cs_client     = @@character_set_client */;
180/*!40101 SET character_set_client = utf8 */;
181CREATE TABLE `oc_calendarchanges` (
182  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
183  `uri` varchar(255) COLLATE utf8_bin DEFAULT NULL,
184  `synctoken` int(10) unsigned NOT NULL DEFAULT '1',
185  `calendarid` int(11) NOT NULL,
186  `operation` smallint(6) NOT NULL,
187  PRIMARY KEY (`id`),
188  KEY `calendarid_synctoken` (`calendarid`,`synctoken`)
189) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
190/*!40101 SET character_set_client = @saved_cs_client */;
191
192--
193-- Dumping data for table `oc_calendarchanges`
194--
195
196LOCK TABLES `oc_calendarchanges` WRITE;
197/*!40000 ALTER TABLE `oc_calendarchanges` DISABLE KEYS */;
198/*!40000 ALTER TABLE `oc_calendarchanges` ENABLE KEYS */;
199UNLOCK TABLES;
200
201--
202-- Table structure for table `oc_calendarobjects`
203--
204
205DROP TABLE IF EXISTS `oc_calendarobjects`;
206/*!40101 SET @saved_cs_client     = @@character_set_client */;
207/*!40101 SET character_set_client = utf8 */;
208CREATE TABLE `oc_calendarobjects` (
209  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
210  `calendardata` longblob,
211  `uri` varchar(255) COLLATE utf8_bin DEFAULT NULL,
212  `calendarid` int(10) unsigned NOT NULL,
213  `lastmodified` int(10) unsigned DEFAULT NULL,
214  `etag` varchar(32) COLLATE utf8_bin DEFAULT NULL,
215  `size` bigint(20) unsigned NOT NULL,
216  `componenttype` varchar(255) COLLATE utf8_bin DEFAULT NULL,
217  `firstoccurence` int(10) unsigned DEFAULT NULL,
218  `lastoccurence` int(10) unsigned DEFAULT NULL,
219  `uid` varchar(255) COLLATE utf8_bin DEFAULT NULL,
220  PRIMARY KEY (`id`),
221  UNIQUE KEY `calobjects_index` (`calendarid`,`uri`)
222) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
223/*!40101 SET character_set_client = @saved_cs_client */;
224
225--
226-- Dumping data for table `oc_calendarobjects`
227--
228
229LOCK TABLES `oc_calendarobjects` WRITE;
230/*!40000 ALTER TABLE `oc_calendarobjects` DISABLE KEYS */;
231/*!40000 ALTER TABLE `oc_calendarobjects` ENABLE KEYS */;
232UNLOCK TABLES;
233
234--
235-- Table structure for table `oc_calendars`
236--
237
238DROP TABLE IF EXISTS `oc_calendars`;
239/*!40101 SET @saved_cs_client     = @@character_set_client */;
240/*!40101 SET character_set_client = utf8 */;
241CREATE TABLE `oc_calendars` (
242  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
243  `principaluri` varchar(255) COLLATE utf8_bin DEFAULT NULL,
244  `displayname` varchar(255) COLLATE utf8_bin DEFAULT NULL,
245  `uri` varchar(255) COLLATE utf8_bin DEFAULT NULL,
246  `synctoken` int(10) unsigned NOT NULL DEFAULT '1',
247  `description` varchar(255) COLLATE utf8_bin DEFAULT NULL,
248  `calendarorder` int(10) unsigned NOT NULL DEFAULT '0',
249  `calendarcolor` varchar(255) COLLATE utf8_bin DEFAULT NULL,
250  `timezone` longtext COLLATE utf8_bin,
251  `components` varchar(255) COLLATE utf8_bin DEFAULT NULL,
252  `transparent` smallint(6) NOT NULL DEFAULT '0',
253  PRIMARY KEY (`id`),
254  UNIQUE KEY `calendars_index` (`principaluri`,`uri`)
255) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
256/*!40101 SET character_set_client = @saved_cs_client */;
257
258--
259-- Dumping data for table `oc_calendars`
260--
261
262LOCK TABLES `oc_calendars` WRITE;
263/*!40000 ALTER TABLE `oc_calendars` DISABLE KEYS */;
264INSERT INTO `oc_calendars` VALUES (1,'principals/users/owncloud_admin','Contact birthdays','contact_birthdays',1,NULL,0,'#FFFFCA',NULL,'VEVENT,VTODO',0),(2,'principals/system/system','Contact birthdays','contact_birthdays',1,NULL,0,'#FFFFCA',NULL,'VEVENT,VTODO',0);
265/*!40000 ALTER TABLE `oc_calendars` ENABLE KEYS */;
266UNLOCK TABLES;
267
268--
269-- Table structure for table `oc_calendarsubscriptions`
270--
271
272DROP TABLE IF EXISTS `oc_calendarsubscriptions`;
273/*!40101 SET @saved_cs_client     = @@character_set_client */;
274/*!40101 SET character_set_client = utf8 */;
275CREATE TABLE `oc_calendarsubscriptions` (
276  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
277  `uri` varchar(255) COLLATE utf8_bin DEFAULT NULL,
278  `principaluri` varchar(255) COLLATE utf8_bin DEFAULT NULL,
279  `source` varchar(255) COLLATE utf8_bin DEFAULT NULL,
280  `displayname` varchar(100) COLLATE utf8_bin DEFAULT NULL,
281  `refreshrate` varchar(10) COLLATE utf8_bin DEFAULT NULL,
282  `calendarorder` int(10) unsigned NOT NULL DEFAULT '0',
283  `calendarcolor` varchar(255) COLLATE utf8_bin DEFAULT NULL,
284  `striptodos` smallint(6) DEFAULT NULL,
285  `stripalarms` smallint(6) DEFAULT NULL,
286  `stripattachments` smallint(6) DEFAULT NULL,
287  `lastmodified` int(10) unsigned DEFAULT NULL,
288  PRIMARY KEY (`id`),
289  UNIQUE KEY `calsub_index` (`principaluri`,`uri`)
290) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
291/*!40101 SET character_set_client = @saved_cs_client */;
292
293--
294-- Dumping data for table `oc_calendarsubscriptions`
295--
296
297LOCK TABLES `oc_calendarsubscriptions` WRITE;
298/*!40000 ALTER TABLE `oc_calendarsubscriptions` DISABLE KEYS */;
299/*!40000 ALTER TABLE `oc_calendarsubscriptions` ENABLE KEYS */;
300UNLOCK TABLES;
301
302--
303-- Table structure for table `oc_cards`
304--
305
306DROP TABLE IF EXISTS `oc_cards`;
307/*!40101 SET @saved_cs_client     = @@character_set_client */;
308/*!40101 SET character_set_client = utf8 */;
309CREATE TABLE `oc_cards` (
310  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
311  `addressbookid` int(11) NOT NULL DEFAULT '0',
312  `carddata` longblob,
313  `uri` varchar(255) COLLATE utf8_bin DEFAULT NULL,
314  `lastmodified` bigint(20) unsigned DEFAULT NULL,
315  `etag` varchar(32) COLLATE utf8_bin DEFAULT NULL,
316  `size` bigint(20) unsigned NOT NULL,
317  PRIMARY KEY (`id`)
318) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
319/*!40101 SET character_set_client = @saved_cs_client */;
320
321--
322-- Dumping data for table `oc_cards`
323--
324
325LOCK TABLES `oc_cards` WRITE;
326/*!40000 ALTER TABLE `oc_cards` DISABLE KEYS */;
327/*!40000 ALTER TABLE `oc_cards` ENABLE KEYS */;
328UNLOCK TABLES;
329
330--
331-- Table structure for table `oc_cards_properties`
332--
333
334DROP TABLE IF EXISTS `oc_cards_properties`;
335/*!40101 SET @saved_cs_client     = @@character_set_client */;
336/*!40101 SET character_set_client = utf8 */;
337CREATE TABLE `oc_cards_properties` (
338  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
339  `addressbookid` bigint(20) NOT NULL DEFAULT '0',
340  `cardid` bigint(20) unsigned NOT NULL DEFAULT '0',
341  `name` varchar(64) COLLATE utf8_bin DEFAULT NULL,
342  `value` varchar(255) COLLATE utf8_bin DEFAULT NULL,
343  `preferred` int(11) NOT NULL DEFAULT '1',
344  PRIMARY KEY (`id`),
345  KEY `card_contactid_index` (`cardid`),
346  KEY `card_name_index` (`name`),
347  KEY `card_value_index` (`value`)
348) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
349/*!40101 SET character_set_client = @saved_cs_client */;
350
351--
352-- Dumping data for table `oc_cards_properties`
353--
354
355LOCK TABLES `oc_cards_properties` WRITE;
356/*!40000 ALTER TABLE `oc_cards_properties` DISABLE KEYS */;
357/*!40000 ALTER TABLE `oc_cards_properties` ENABLE KEYS */;
358UNLOCK TABLES;
359
360--
361-- Table structure for table `oc_comments`
362--
363
364DROP TABLE IF EXISTS `oc_comments`;
365/*!40101 SET @saved_cs_client     = @@character_set_client */;
366/*!40101 SET character_set_client = utf8 */;
367CREATE TABLE `oc_comments` (
368  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
369  `parent_id` int(10) unsigned NOT NULL DEFAULT '0',
370  `topmost_parent_id` int(10) unsigned NOT NULL DEFAULT '0',
371  `children_count` int(10) unsigned NOT NULL DEFAULT '0',
372  `actor_type` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
373  `actor_id` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
374  `message` longtext COLLATE utf8_bin,
375  `verb` varchar(64) COLLATE utf8_bin DEFAULT NULL,
376  `creation_timestamp` datetime DEFAULT NULL,
377  `latest_child_timestamp` datetime DEFAULT NULL,
378  `object_type` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
379  `object_id` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
380  PRIMARY KEY (`id`),
381  KEY `comments_parent_id_index` (`parent_id`),
382  KEY `comments_topmost_parent_id_idx` (`topmost_parent_id`),
383  KEY `comments_object_index` (`object_type`,`object_id`,`creation_timestamp`),
384  KEY `comments_actor_index` (`actor_type`,`actor_id`)
385) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
386/*!40101 SET character_set_client = @saved_cs_client */;
387
388--
389-- Dumping data for table `oc_comments`
390--
391
392LOCK TABLES `oc_comments` WRITE;
393/*!40000 ALTER TABLE `oc_comments` DISABLE KEYS */;
394/*!40000 ALTER TABLE `oc_comments` ENABLE KEYS */;
395UNLOCK TABLES;
396
397--
398-- Table structure for table `oc_comments_read_markers`
399--
400
401DROP TABLE IF EXISTS `oc_comments_read_markers`;
402/*!40101 SET @saved_cs_client     = @@character_set_client */;
403/*!40101 SET character_set_client = utf8 */;
404CREATE TABLE `oc_comments_read_markers` (
405  `user_id` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
406  `marker_datetime` datetime DEFAULT NULL,
407  `object_type` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
408  `object_id` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
409  UNIQUE KEY `comments_marker_index` (`user_id`,`object_type`,`object_id`),
410  KEY `comments_marker_object_index` (`object_type`,`object_id`)
411) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
412/*!40101 SET character_set_client = @saved_cs_client */;
413
414--
415-- Dumping data for table `oc_comments_read_markers`
416--
417
418LOCK TABLES `oc_comments_read_markers` WRITE;
419/*!40000 ALTER TABLE `oc_comments_read_markers` DISABLE KEYS */;
420/*!40000 ALTER TABLE `oc_comments_read_markers` ENABLE KEYS */;
421UNLOCK TABLES;
422
423--
424-- Table structure for table `oc_credentials`
425--
426
427DROP TABLE IF EXISTS `oc_credentials`;
428/*!40101 SET @saved_cs_client     = @@character_set_client */;
429/*!40101 SET character_set_client = utf8 */;
430CREATE TABLE `oc_credentials` (
431  `user` varchar(64) COLLATE utf8_bin NOT NULL,
432  `identifier` varchar(64) COLLATE utf8_bin NOT NULL,
433  `credentials` longtext COLLATE utf8_bin,
434  PRIMARY KEY (`user`,`identifier`),
435  KEY `credentials_user` (`user`)
436) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
437/*!40101 SET character_set_client = @saved_cs_client */;
438
439--
440-- Dumping data for table `oc_credentials`
441--
442
443LOCK TABLES `oc_credentials` WRITE;
444/*!40000 ALTER TABLE `oc_credentials` DISABLE KEYS */;
445/*!40000 ALTER TABLE `oc_credentials` ENABLE KEYS */;
446UNLOCK TABLES;
447
448--
449-- Table structure for table `oc_dav_shares`
450--
451
452DROP TABLE IF EXISTS `oc_dav_shares`;
453/*!40101 SET @saved_cs_client     = @@character_set_client */;
454/*!40101 SET character_set_client = utf8 */;
455CREATE TABLE `oc_dav_shares` (
456  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
457  `principaluri` varchar(255) COLLATE utf8_bin DEFAULT NULL,
458  `type` varchar(255) COLLATE utf8_bin DEFAULT NULL,
459  `access` smallint(6) DEFAULT NULL,
460  `resourceid` int(10) unsigned NOT NULL,
461  PRIMARY KEY (`id`),
462  UNIQUE KEY `dav_shares_index` (`principaluri`,`resourceid`,`type`)
463) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
464/*!40101 SET character_set_client = @saved_cs_client */;
465
466--
467-- Dumping data for table `oc_dav_shares`
468--
469
470LOCK TABLES `oc_dav_shares` WRITE;
471/*!40000 ALTER TABLE `oc_dav_shares` DISABLE KEYS */;
472/*!40000 ALTER TABLE `oc_dav_shares` ENABLE KEYS */;
473UNLOCK TABLES;
474
475--
476-- Table structure for table `oc_file_locks`
477--
478
479DROP TABLE IF EXISTS `oc_file_locks`;
480/*!40101 SET @saved_cs_client     = @@character_set_client */;
481/*!40101 SET character_set_client = utf8 */;
482CREATE TABLE `oc_file_locks` (
483  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
484  `lock` int(11) NOT NULL DEFAULT '0',
485  `key` varchar(64) COLLATE utf8_bin NOT NULL,
486  `ttl` int(11) NOT NULL DEFAULT '-1',
487  PRIMARY KEY (`id`),
488  UNIQUE KEY `lock_key_index` (`key`),
489  KEY `lock_ttl_index` (`ttl`)
490) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
491/*!40101 SET character_set_client = @saved_cs_client */;
492
493--
494-- Dumping data for table `oc_file_locks`
495--
496
497LOCK TABLES `oc_file_locks` WRITE;
498/*!40000 ALTER TABLE `oc_file_locks` DISABLE KEYS */;
499INSERT INTO `oc_file_locks` VALUES (1,0,'files/61ed1f9a7383795ed88817d445e1546b',1462439524),(2,0,'files/c31e581b3c2ec56f9b7b1dca2421b72e',1462439524),(3,0,'files/ef90c82ae6bd9d9a22ee5b7c93d77ca7',1462439524);
500/*!40000 ALTER TABLE `oc_file_locks` ENABLE KEYS */;
501UNLOCK TABLES;
502
503--
504-- Table structure for table `oc_filecache`
505--
506
507DROP TABLE IF EXISTS `oc_filecache`;
508/*!40101 SET @saved_cs_client     = @@character_set_client */;
509/*!40101 SET character_set_client = utf8 */;
510CREATE TABLE `oc_filecache` (
511  `fileid` int(11) NOT NULL AUTO_INCREMENT,
512  `storage` int(11) NOT NULL DEFAULT '0',
513  `path` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
514  `path_hash` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
515  `parent` int(11) NOT NULL DEFAULT '0',
516  `name` varchar(250) COLLATE utf8_bin DEFAULT NULL,
517  `mimetype` int(11) NOT NULL DEFAULT '0',
518  `mimepart` int(11) NOT NULL DEFAULT '0',
519  `size` bigint(20) NOT NULL DEFAULT '0',
520  `mtime` int(11) NOT NULL DEFAULT '0',
521  `storage_mtime` int(11) NOT NULL DEFAULT '0',
522  `encrypted` int(11) NOT NULL DEFAULT '0',
523  `unencrypted_size` bigint(20) NOT NULL DEFAULT '0',
524  `etag` varchar(40) COLLATE utf8_bin DEFAULT NULL,
525  `permissions` int(11) DEFAULT '0',
526  `checksum` varchar(255) COLLATE utf8_bin DEFAULT NULL,
527  PRIMARY KEY (`fileid`),
528  UNIQUE KEY `fs_storage_path_hash` (`storage`,`path_hash`),
529  KEY `fs_parent_name_hash` (`parent`,`name`),
530  KEY `fs_storage_mimetype` (`storage`,`mimetype`),
531  KEY `fs_storage_mimepart` (`storage`,`mimepart`),
532  KEY `fs_storage_size` (`storage`,`size`,`fileid`)
533) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
534/*!40101 SET character_set_client = @saved_cs_client */;
535
536--
537-- Dumping data for table `oc_filecache`
538--
539
540LOCK TABLES `oc_filecache` WRITE;
541/*!40000 ALTER TABLE `oc_filecache` DISABLE KEYS */;
542INSERT INTO `oc_filecache` VALUES (1,1,'','d41d8cd98f00b204e9800998ecf8427e',-1,'',2,1,714783,1462298950,1462298950,0,0,'5728e9463cca5',23,NULL),(2,1,'files','45b963397aa40d4a0063e0d85e4fe7a1',1,'files',2,1,714783,1462298828,1462298828,0,0,'5728e8cc77a0f',31,NULL),(3,1,'files/Documents','0ad78ba05b6961d92f7970b2b3922eca',2,'Documents',2,1,36227,1462298828,1462298828,0,0,'5728e8cc43537',31,NULL),(4,1,'files/Documents/Example.odt','c89c560541b952a435783a7d51a27d50',3,'Example.odt',4,3,36227,1462298828,1462298828,0,0,'0bb5554e6014517367b5eaad13ea9b5d',27,NULL),(5,1,'files/Photos','d01bb67e7b71dd49fd06bad922f521c9',2,'Photos',2,1,678556,1462298828,1462298828,0,0,'5728e8cc76df4',31,NULL),(6,1,'files/Photos/San Francisco.jpg','9fc714efbeaafee22f7058e73d2b1c3b',5,'San Francisco.jpg',6,5,216071,1462298828,1462298828,0,0,'0e08474b4ea6dfcf0a435bec88d987f0',27,NULL),(7,1,'files/Photos/Squirrel.jpg','de85d1da71bcd6232ad893f959063b8c',5,'Squirrel.jpg',6,5,233724,1462298828,1462298828,0,0,'850848d39cee59d1ec3b50c37288810d',27,NULL),(8,1,'files/Photos/Paris.jpg','a208ddedf08367bbc56963107248dda5',5,'Paris.jpg',6,5,228761,1462298828,1462298828,0,0,'f0b91bc1e3391e3288cfb9c29ffdf45c',27,NULL),(9,2,'','d41d8cd98f00b204e9800998ecf8427e',-1,'',2,1,-1,1462298836,1462298836,0,0,'5728e8d4a514d',23,NULL),(10,2,'files_external','c270928b685e7946199afdfb898d27ea',9,'files_external',2,1,0,1462298836,1462298836,0,0,'5728e8d4a2830',31,NULL),(11,1,'cache','0fea6a13c52b4d4725368f24b045ca84',1,'cache',2,1,0,1462298950,1462298950,0,0,'5728e9463925f',31,NULL),(12,1,'files/ownCloud_User_Manual.pdf','fbaae4021d9c766fc309c54e81133013',2,'ownCloud_User_Manual.pdf',7,3,3936968,1462463389,1462463389,0,0,'fe367c2e889dbc2d21a5d2c36ce37773',27,NULL);
543/*!40000 ALTER TABLE `oc_filecache` ENABLE KEYS */;
544UNLOCK TABLES;
545
546--
547-- Table structure for table `oc_files_trash`
548--
549
550DROP TABLE IF EXISTS `oc_files_trash`;
551/*!40101 SET @saved_cs_client     = @@character_set_client */;
552/*!40101 SET character_set_client = utf8 */;
553CREATE TABLE `oc_files_trash` (
554  `auto_id` int(11) NOT NULL AUTO_INCREMENT,
555  `id` varchar(250) COLLATE utf8_bin NOT NULL DEFAULT '',
556  `user` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
557  `timestamp` varchar(12) COLLATE utf8_bin NOT NULL DEFAULT '',
558  `location` varchar(512) COLLATE utf8_bin NOT NULL DEFAULT '',
559  `type` varchar(4) COLLATE utf8_bin DEFAULT NULL,
560  `mime` varchar(255) COLLATE utf8_bin DEFAULT NULL,
561  PRIMARY KEY (`auto_id`),
562  KEY `id_index` (`id`),
563  KEY `timestamp_index` (`timestamp`),
564  KEY `user_index` (`user`)
565) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
566/*!40101 SET character_set_client = @saved_cs_client */;
567
568--
569-- Dumping data for table `oc_files_trash`
570--
571
572LOCK TABLES `oc_files_trash` WRITE;
573/*!40000 ALTER TABLE `oc_files_trash` DISABLE KEYS */;
574/*!40000 ALTER TABLE `oc_files_trash` ENABLE KEYS */;
575UNLOCK TABLES;
576
577--
578-- Table structure for table `oc_group_admin`
579--
580
581DROP TABLE IF EXISTS `oc_group_admin`;
582/*!40101 SET @saved_cs_client     = @@character_set_client */;
583/*!40101 SET character_set_client = utf8 */;
584CREATE TABLE `oc_group_admin` (
585  `gid` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
586  `uid` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
587  PRIMARY KEY (`gid`,`uid`),
588  KEY `group_admin_uid` (`uid`)
589) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
590/*!40101 SET character_set_client = @saved_cs_client */;
591
592--
593-- Dumping data for table `oc_group_admin`
594--
595
596LOCK TABLES `oc_group_admin` WRITE;
597/*!40000 ALTER TABLE `oc_group_admin` DISABLE KEYS */;
598/*!40000 ALTER TABLE `oc_group_admin` ENABLE KEYS */;
599UNLOCK TABLES;
600
601--
602-- Table structure for table `oc_group_user`
603--
604
605DROP TABLE IF EXISTS `oc_group_user`;
606/*!40101 SET @saved_cs_client     = @@character_set_client */;
607/*!40101 SET character_set_client = utf8 */;
608CREATE TABLE `oc_group_user` (
609  `gid` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
610  `uid` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
611  PRIMARY KEY (`gid`,`uid`),
612  KEY `gu_uid_index` (`uid`)
613) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
614/*!40101 SET character_set_client = @saved_cs_client */;
615
616--
617-- Dumping data for table `oc_group_user`
618--
619
620LOCK TABLES `oc_group_user` WRITE;
621/*!40000 ALTER TABLE `oc_group_user` DISABLE KEYS */;
622INSERT INTO `oc_group_user` VALUES ('admin','{{ ADMIN_USER }}');
623/*!40000 ALTER TABLE `oc_group_user` ENABLE KEYS */;
624UNLOCK TABLES;
625
626--
627-- Table structure for table `oc_groups`
628--
629
630DROP TABLE IF EXISTS `oc_groups`;
631/*!40101 SET @saved_cs_client     = @@character_set_client */;
632/*!40101 SET character_set_client = utf8 */;
633CREATE TABLE `oc_groups` (
634  `gid` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
635  PRIMARY KEY (`gid`)
636) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
637/*!40101 SET character_set_client = @saved_cs_client */;
638
639--
640-- Dumping data for table `oc_groups`
641--
642
643LOCK TABLES `oc_groups` WRITE;
644/*!40000 ALTER TABLE `oc_groups` DISABLE KEYS */;
645INSERT INTO `oc_groups` VALUES ('admin');
646/*!40000 ALTER TABLE `oc_groups` ENABLE KEYS */;
647UNLOCK TABLES;
648
649--
650-- Table structure for table `oc_jobs`
651--
652
653DROP TABLE IF EXISTS `oc_jobs`;
654/*!40101 SET @saved_cs_client     = @@character_set_client */;
655/*!40101 SET character_set_client = utf8 */;
656CREATE TABLE `oc_jobs` (
657  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
658  `class` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
659  `argument` varchar(4000) COLLATE utf8_bin NOT NULL DEFAULT '',
660  `last_run` int(11) DEFAULT '0',
661  PRIMARY KEY (`id`),
662  KEY `job_class_index` (`class`)
663) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
664/*!40101 SET character_set_client = @saved_cs_client */;
665
666--
667-- Dumping data for table `oc_jobs`
668--
669
670LOCK TABLES `oc_jobs` WRITE;
671/*!40000 ALTER TABLE `oc_jobs` DISABLE KEYS */;
672INSERT INTO `oc_jobs` VALUES (1,'OCA\\Files_Trashbin\\BackgroundJob\\ExpireTrash','null',1462430793),(2,'OCA\\DAV\\CardDAV\\SyncJob','null',1462428872),(3,'OCA\\Federation\\SyncJob','null',1462428881),(4,'OCA\\Files_Versions\\BackgroundJob\\ExpireVersions','null',1462431168),(5,'OCA\\Files_sharing\\Lib\\DeleteOrphanedSharesJob','null',1462430421),(6,'OCA\\Files_sharing\\ExpireSharesJob','null',1462429049),(7,'OCA\\Files\\BackgroundJob\\ScanFiles','null',1462435917),(8,'OCA\\Files\\BackgroundJob\\DeleteOrphanedItems','null',1462435924),(9,'OCA\\Files\\BackgroundJob\\CleanupFileLocks','null',1462435930),(10,'OCA\\Activity\\BackgroundJob\\EmailNotification','null',1462435936),(11,'OCA\\Activity\\BackgroundJob\\ExpireActivities','null',1462365668),(12,'OCA\\user_ldap\\lib\\Jobs','null',1462436029),(13,'\\OCA\\User_LDAP\\Jobs\\CleanUp','null',1462428854);
673/*!40000 ALTER TABLE `oc_jobs` ENABLE KEYS */;
674UNLOCK TABLES;
675
676--
677-- Table structure for table `oc_ldap_group_mapping`
678--
679
680DROP TABLE IF EXISTS `oc_ldap_group_mapping`;
681/*!40101 SET @saved_cs_client     = @@character_set_client */;
682/*!40101 SET character_set_client = utf8 */;
683CREATE TABLE `oc_ldap_group_mapping` (
684  `ldap_dn` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
685  `owncloud_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
686  `directory_uuid` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
687  PRIMARY KEY (`ldap_dn`),
688  UNIQUE KEY `owncloud_name_groups` (`owncloud_name`)
689) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
690/*!40101 SET character_set_client = @saved_cs_client */;
691
692--
693-- Dumping data for table `oc_ldap_group_mapping`
694--
695
696LOCK TABLES `oc_ldap_group_mapping` WRITE;
697/*!40000 ALTER TABLE `oc_ldap_group_mapping` DISABLE KEYS */;
698/*!40000 ALTER TABLE `oc_ldap_group_mapping` ENABLE KEYS */;
699UNLOCK TABLES;
700
701--
702-- Table structure for table `oc_ldap_group_members`
703--
704
705DROP TABLE IF EXISTS `oc_ldap_group_members`;
706/*!40101 SET @saved_cs_client     = @@character_set_client */;
707/*!40101 SET character_set_client = utf8 */;
708CREATE TABLE `oc_ldap_group_members` (
709  `owncloudname` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
710  `owncloudusers` longtext COLLATE utf8_bin NOT NULL,
711  PRIMARY KEY (`owncloudname`)
712) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
713/*!40101 SET character_set_client = @saved_cs_client */;
714
715--
716-- Dumping data for table `oc_ldap_group_members`
717--
718
719LOCK TABLES `oc_ldap_group_members` WRITE;
720/*!40000 ALTER TABLE `oc_ldap_group_members` DISABLE KEYS */;
721/*!40000 ALTER TABLE `oc_ldap_group_members` ENABLE KEYS */;
722UNLOCK TABLES;
723
724--
725-- Table structure for table `oc_ldap_user_mapping`
726--
727
728DROP TABLE IF EXISTS `oc_ldap_user_mapping`;
729/*!40101 SET @saved_cs_client     = @@character_set_client */;
730/*!40101 SET character_set_client = utf8 */;
731CREATE TABLE `oc_ldap_user_mapping` (
732  `ldap_dn` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
733  `owncloud_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
734  `directory_uuid` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
735  PRIMARY KEY (`owncloud_name`),
736  UNIQUE KEY `ldap_dn_users` (`ldap_dn`)
737) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
738/*!40101 SET character_set_client = @saved_cs_client */;
739
740--
741-- Dumping data for table `oc_ldap_user_mapping`
742--
743
744LOCK TABLES `oc_ldap_user_mapping` WRITE;
745/*!40000 ALTER TABLE `oc_ldap_user_mapping` DISABLE KEYS */;
746/*!40000 ALTER TABLE `oc_ldap_user_mapping` ENABLE KEYS */;
747UNLOCK TABLES;
748
749--
750-- Table structure for table `oc_mimetypes`
751--
752
753DROP TABLE IF EXISTS `oc_mimetypes`;
754/*!40101 SET @saved_cs_client     = @@character_set_client */;
755/*!40101 SET character_set_client = utf8 */;
756CREATE TABLE `oc_mimetypes` (
757  `id` int(11) NOT NULL AUTO_INCREMENT,
758  `mimetype` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
759  PRIMARY KEY (`id`),
760  UNIQUE KEY `mimetype_id_index` (`mimetype`)
761) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
762/*!40101 SET character_set_client = @saved_cs_client */;
763
764--
765-- Dumping data for table `oc_mimetypes`
766--
767
768LOCK TABLES `oc_mimetypes` WRITE;
769/*!40000 ALTER TABLE `oc_mimetypes` DISABLE KEYS */;
770INSERT INTO `oc_mimetypes` VALUES (3,'application'),(4,'application/vnd.oasis.opendocument.text'),(1,'httpd'),(2,'httpd/unix-directory'),(5,'image'),(6,'image/jpeg'),(7,'application/pdf');
771/*!40000 ALTER TABLE `oc_mimetypes` ENABLE KEYS */;
772UNLOCK TABLES;
773
774--
775-- Table structure for table `oc_mounts`
776--
777
778DROP TABLE IF EXISTS `oc_mounts`;
779/*!40101 SET @saved_cs_client     = @@character_set_client */;
780/*!40101 SET character_set_client = utf8 */;
781CREATE TABLE `oc_mounts` (
782  `id` int(11) NOT NULL AUTO_INCREMENT,
783  `storage_id` int(11) NOT NULL,
784  `root_id` int(11) NOT NULL,
785  `user_id` varchar(64) COLLATE utf8_bin NOT NULL,
786  `mount_point` varchar(4000) COLLATE utf8_bin NOT NULL,
787  PRIMARY KEY (`id`),
788  UNIQUE KEY `mounts_user_root_index` (`user_id`,`root_id`),
789  KEY `mounts_user_index` (`user_id`),
790  KEY `mounts_storage_index` (`storage_id`),
791  KEY `mounts_root_index` (`root_id`)
792) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
793/*!40101 SET character_set_client = @saved_cs_client */;
794
795--
796-- Dumping data for table `oc_mounts`
797--
798
799LOCK TABLES `oc_mounts` WRITE;
800/*!40000 ALTER TABLE `oc_mounts` DISABLE KEYS */;
801/*!40000 ALTER TABLE `oc_mounts` ENABLE KEYS */;
802UNLOCK TABLES;
803
804--
805-- Table structure for table `oc_notifications`
806--
807
808DROP TABLE IF EXISTS `oc_notifications`;
809/*!40101 SET @saved_cs_client     = @@character_set_client */;
810/*!40101 SET character_set_client = utf8 */;
811CREATE TABLE `oc_notifications` (
812  `notification_id` int(11) NOT NULL AUTO_INCREMENT,
813  `app` varchar(32) COLLATE utf8_bin NOT NULL,
814  `user` varchar(64) COLLATE utf8_bin NOT NULL,
815  `timestamp` int(11) NOT NULL DEFAULT '0',
816  `object_type` varchar(64) COLLATE utf8_bin NOT NULL,
817  `object_id` varchar(64) COLLATE utf8_bin NOT NULL,
818  `subject` varchar(64) COLLATE utf8_bin NOT NULL,
819  `subject_parameters` longtext COLLATE utf8_bin,
820  `message` varchar(64) COLLATE utf8_bin DEFAULT NULL,
821  `message_parameters` longtext COLLATE utf8_bin,
822  `link` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
823  `actions` longtext COLLATE utf8_bin,
824  PRIMARY KEY (`notification_id`),
825  KEY `oc_notifications_app` (`app`),
826  KEY `oc_notifications_user` (`user`),
827  KEY `oc_notifications_timestamp` (`timestamp`),
828  KEY `oc_notifications_object` (`object_type`,`object_id`)
829) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
830/*!40101 SET character_set_client = @saved_cs_client */;
831
832--
833-- Dumping data for table `oc_notifications`
834--
835
836LOCK TABLES `oc_notifications` WRITE;
837/*!40000 ALTER TABLE `oc_notifications` DISABLE KEYS */;
838/*!40000 ALTER TABLE `oc_notifications` ENABLE KEYS */;
839UNLOCK TABLES;
840
841--
842-- Table structure for table `oc_preferences`
843--
844
845DROP TABLE IF EXISTS `oc_preferences`;
846/*!40101 SET @saved_cs_client     = @@character_set_client */;
847/*!40101 SET character_set_client = utf8 */;
848CREATE TABLE `oc_preferences` (
849  `userid` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
850  `appid` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
851  `configkey` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
852  `configvalue` longtext COLLATE utf8_bin,
853  PRIMARY KEY (`userid`,`appid`,`configkey`)
854) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
855/*!40101 SET character_set_client = @saved_cs_client */;
856
857--
858-- Dumping data for table `oc_preferences`
859--
860
861LOCK TABLES `oc_preferences` WRITE;
862/*!40000 ALTER TABLE `oc_preferences` DISABLE KEYS */;
863INSERT INTO `oc_preferences` VALUES  ('{{ ADMIN_USER }}','core','lang','es'),('{{ ADMIN_USER }}','firstrunwizard','show','0');
864/*!40000 ALTER TABLE `oc_preferences` ENABLE KEYS */;
865/*!40000 ALTER TABLE `oc_preferences` ENABLE KEYS */;
866UNLOCK TABLES;
867
868--
869-- Table structure for table `oc_privatedata`
870--
871
872DROP TABLE IF EXISTS `oc_privatedata`;
873/*!40101 SET @saved_cs_client     = @@character_set_client */;
874/*!40101 SET character_set_client = utf8 */;
875CREATE TABLE `oc_privatedata` (
876  `keyid` int(10) unsigned NOT NULL AUTO_INCREMENT,
877  `user` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
878  `app` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
879  `key` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
880  `value` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
881  PRIMARY KEY (`keyid`)
882) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
883/*!40101 SET character_set_client = @saved_cs_client */;
884
885--
886-- Dumping data for table `oc_privatedata`
887--
888
889LOCK TABLES `oc_privatedata` WRITE;
890/*!40000 ALTER TABLE `oc_privatedata` DISABLE KEYS */;
891/*!40000 ALTER TABLE `oc_privatedata` ENABLE KEYS */;
892UNLOCK TABLES;
893
894--
895-- Table structure for table `oc_properties`
896--
897
898DROP TABLE IF EXISTS `oc_properties`;
899/*!40101 SET @saved_cs_client     = @@character_set_client */;
900/*!40101 SET character_set_client = utf8 */;
901CREATE TABLE `oc_properties` (
902  `id` int(11) NOT NULL AUTO_INCREMENT,
903  `userid` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
904  `propertypath` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
905  `propertyname` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
906  `propertyvalue` varchar(255) COLLATE utf8_bin NOT NULL,
907  PRIMARY KEY (`id`),
908  KEY `property_index` (`userid`)
909) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
910/*!40101 SET character_set_client = @saved_cs_client */;
911
912--
913-- Dumping data for table `oc_properties`
914--
915
916LOCK TABLES `oc_properties` WRITE;
917/*!40000 ALTER TABLE `oc_properties` DISABLE KEYS */;
918/*!40000 ALTER TABLE `oc_properties` ENABLE KEYS */;
919UNLOCK TABLES;
920
921--
922-- Table structure for table `oc_schedulingobjects`
923--
924
925DROP TABLE IF EXISTS `oc_schedulingobjects`;
926/*!40101 SET @saved_cs_client     = @@character_set_client */;
927/*!40101 SET character_set_client = utf8 */;
928CREATE TABLE `oc_schedulingobjects` (
929  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
930  `principaluri` varchar(255) COLLATE utf8_bin DEFAULT NULL,
931  `calendardata` longblob,
932  `uri` varchar(255) COLLATE utf8_bin DEFAULT NULL,
933  `lastmodified` int(10) unsigned DEFAULT NULL,
934  `etag` varchar(32) COLLATE utf8_bin DEFAULT NULL,
935  `size` bigint(20) unsigned NOT NULL,
936  PRIMARY KEY (`id`)
937) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
938/*!40101 SET character_set_client = @saved_cs_client */;
939
940--
941-- Dumping data for table `oc_schedulingobjects`
942--
943
944LOCK TABLES `oc_schedulingobjects` WRITE;
945/*!40000 ALTER TABLE `oc_schedulingobjects` DISABLE KEYS */;
946/*!40000 ALTER TABLE `oc_schedulingobjects` ENABLE KEYS */;
947UNLOCK TABLES;
948
949--
950-- Table structure for table `oc_share`
951--
952
953DROP TABLE IF EXISTS `oc_share`;
954/*!40101 SET @saved_cs_client     = @@character_set_client */;
955/*!40101 SET character_set_client = utf8 */;
956CREATE TABLE `oc_share` (
957  `id` int(11) NOT NULL AUTO_INCREMENT,
958  `share_type` smallint(6) NOT NULL DEFAULT '0',
959  `share_with` varchar(255) COLLATE utf8_bin DEFAULT NULL,
960  `uid_owner` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
961  `uid_initiator` varchar(64) COLLATE utf8_bin DEFAULT NULL,
962  `parent` int(11) DEFAULT NULL,
963  `item_type` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
964  `item_source` varchar(255) COLLATE utf8_bin DEFAULT NULL,
965  `item_target` varchar(255) COLLATE utf8_bin DEFAULT NULL,
966  `file_source` int(11) DEFAULT NULL,
967  `file_target` varchar(512) COLLATE utf8_bin DEFAULT NULL,
968  `permissions` smallint(6) NOT NULL DEFAULT '0',
969  `stime` bigint(20) NOT NULL DEFAULT '0',
970  `accepted` smallint(6) NOT NULL DEFAULT '0',
971  `expiration` datetime DEFAULT NULL,
972  `token` varchar(32) COLLATE utf8_bin DEFAULT NULL,
973  `mail_send` smallint(6) NOT NULL DEFAULT '0',
974  PRIMARY KEY (`id`),
975  KEY `item_share_type_index` (`item_type`,`share_type`),
976  KEY `file_source_index` (`file_source`),
977  KEY `token_index` (`token`)
978) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
979/*!40101 SET character_set_client = @saved_cs_client */;
980
981--
982-- Dumping data for table `oc_share`
983--
984
985LOCK TABLES `oc_share` WRITE;
986/*!40000 ALTER TABLE `oc_share` DISABLE KEYS */;
987/*!40000 ALTER TABLE `oc_share` ENABLE KEYS */;
988UNLOCK TABLES;
989
990--
991-- Table structure for table `oc_share_external`
992--
993
994DROP TABLE IF EXISTS `oc_share_external`;
995/*!40101 SET @saved_cs_client     = @@character_set_client */;
996/*!40101 SET character_set_client = utf8 */;
997CREATE TABLE `oc_share_external` (
998  `id` int(11) NOT NULL AUTO_INCREMENT,
999  `remote` varchar(512) COLLATE utf8_bin NOT NULL COMMENT 'Url of the remove owncloud instance',
1000  `remote_id` int(11) NOT NULL DEFAULT '-1',
1001  `share_token` varchar(64) COLLATE utf8_bin NOT NULL COMMENT 'Public share token',
1002  `password` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT 'Optional password for the public share',
1003  `name` varchar(64) COLLATE utf8_bin NOT NULL COMMENT 'Original name on the remote server',
1004  `owner` varchar(64) COLLATE utf8_bin NOT NULL COMMENT 'User that owns the public share on the remote server',
1005  `user` varchar(64) COLLATE utf8_bin NOT NULL COMMENT 'Local user which added the external share',
1006  `mountpoint` varchar(4000) COLLATE utf8_bin NOT NULL COMMENT 'Full path where the share is mounted',
1007  `mountpoint_hash` varchar(32) COLLATE utf8_bin NOT NULL COMMENT 'md5 hash of the mountpoint',
1008  `accepted` int(11) NOT NULL DEFAULT '0',
1009  PRIMARY KEY (`id`),
1010  UNIQUE KEY `sh_external_mp` (`user`,`mountpoint_hash`),
1011  KEY `sh_external_user` (`user`)
1012) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1013/*!40101 SET character_set_client = @saved_cs_client */;
1014
1015--
1016-- Dumping data for table `oc_share_external`
1017--
1018
1019LOCK TABLES `oc_share_external` WRITE;
1020/*!40000 ALTER TABLE `oc_share_external` DISABLE KEYS */;
1021/*!40000 ALTER TABLE `oc_share_external` ENABLE KEYS */;
1022UNLOCK TABLES;
1023
1024--
1025-- Table structure for table `oc_storages`
1026--
1027
1028DROP TABLE IF EXISTS `oc_storages`;
1029/*!40101 SET @saved_cs_client     = @@character_set_client */;
1030/*!40101 SET character_set_client = utf8 */;
1031CREATE TABLE `oc_storages` (
1032  `id` varchar(64) COLLATE utf8_bin DEFAULT NULL,
1033  `numeric_id` int(11) NOT NULL AUTO_INCREMENT,
1034  `available` int(11) NOT NULL DEFAULT '1',
1035  `last_checked` int(11) DEFAULT NULL,
1036  PRIMARY KEY (`numeric_id`),
1037  UNIQUE KEY `storages_id_index` (`id`)
1038) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1039/*!40101 SET character_set_client = @saved_cs_client */;
1040
1041--
1042-- Dumping data for table `oc_storages`
1043--
1044
1045LOCK TABLES `oc_storages` WRITE;
1046/*!40000 ALTER TABLE `oc_storages` DISABLE KEYS */;
1047INSERT INTO `oc_storages` VALUES ('home::{{ ADMIN_USER }}',1,1,NULL),('local::/var/www/owncloud/data/',2,1,NULL);
1048/*!40000 ALTER TABLE `oc_storages` ENABLE KEYS */;
1049UNLOCK TABLES;
1050
1051--
1052-- Table structure for table `oc_systemtag`
1053--
1054
1055DROP TABLE IF EXISTS `oc_systemtag`;
1056/*!40101 SET @saved_cs_client     = @@character_set_client */;
1057/*!40101 SET character_set_client = utf8 */;
1058CREATE TABLE `oc_systemtag` (
1059  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1060  `name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
1061  `visibility` smallint(6) NOT NULL DEFAULT '1',
1062  `editable` smallint(6) NOT NULL DEFAULT '1',
1063  PRIMARY KEY (`id`),
1064  UNIQUE KEY `tag_ident` (`name`,`visibility`,`editable`)
1065) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1066/*!40101 SET character_set_client = @saved_cs_client */;
1067
1068--
1069-- Dumping data for table `oc_systemtag`
1070--
1071
1072LOCK TABLES `oc_systemtag` WRITE;
1073/*!40000 ALTER TABLE `oc_systemtag` DISABLE KEYS */;
1074/*!40000 ALTER TABLE `oc_systemtag` ENABLE KEYS */;
1075UNLOCK TABLES;
1076
1077--
1078-- Table structure for table `oc_systemtag_object_mapping`
1079--
1080
1081DROP TABLE IF EXISTS `oc_systemtag_object_mapping`;
1082/*!40101 SET @saved_cs_client     = @@character_set_client */;
1083/*!40101 SET character_set_client = utf8 */;
1084CREATE TABLE `oc_systemtag_object_mapping` (
1085  `objectid` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
1086  `objecttype` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
1087  `systemtagid` int(10) unsigned NOT NULL DEFAULT '0',
1088  UNIQUE KEY `mapping` (`objecttype`,`objectid`,`systemtagid`)
1089) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1090/*!40101 SET character_set_client = @saved_cs_client */;
1091
1092--
1093-- Dumping data for table `oc_systemtag_object_mapping`
1094--
1095
1096LOCK TABLES `oc_systemtag_object_mapping` WRITE;
1097/*!40000 ALTER TABLE `oc_systemtag_object_mapping` DISABLE KEYS */;
1098/*!40000 ALTER TABLE `oc_systemtag_object_mapping` ENABLE KEYS */;
1099UNLOCK TABLES;
1100
1101--
1102-- Table structure for table `oc_trusted_servers`
1103--
1104
1105DROP TABLE IF EXISTS `oc_trusted_servers`;
1106/*!40101 SET @saved_cs_client     = @@character_set_client */;
1107/*!40101 SET character_set_client = utf8 */;
1108CREATE TABLE `oc_trusted_servers` (
1109  `id` int(11) NOT NULL AUTO_INCREMENT,
1110  `url` varchar(512) COLLATE utf8_bin NOT NULL COMMENT 'Url of trusted server',
1111  `url_hash` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT 'sha1 hash of the url without the protocol',
1112  `token` varchar(128) COLLATE utf8_bin DEFAULT NULL COMMENT 'token used to exchange the shared secret',
1113  `shared_secret` varchar(256) COLLATE utf8_bin DEFAULT NULL COMMENT 'shared secret used to authenticate',
1114  `status` int(11) NOT NULL DEFAULT '2' COMMENT 'current status of the connection',
1115  `sync_token` varchar(512) COLLATE utf8_bin DEFAULT NULL COMMENT 'cardDav sync token',
1116  PRIMARY KEY (`id`),
1117  UNIQUE KEY `url_hash` (`url_hash`)
1118) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1119/*!40101 SET character_set_client = @saved_cs_client */;
1120
1121--
1122-- Dumping data for table `oc_trusted_servers`
1123--
1124
1125LOCK TABLES `oc_trusted_servers` WRITE;
1126/*!40000 ALTER TABLE `oc_trusted_servers` DISABLE KEYS */;
1127/*!40000 ALTER TABLE `oc_trusted_servers` ENABLE KEYS */;
1128UNLOCK TABLES;
1129
1130--
1131-- Table structure for table `oc_users`
1132--
1133
1134DROP TABLE IF EXISTS `oc_users`;
1135/*!40101 SET @saved_cs_client     = @@character_set_client */;
1136/*!40101 SET character_set_client = utf8 */;
1137CREATE TABLE `oc_users` (
1138  `uid` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
1139  `displayname` varchar(64) COLLATE utf8_bin DEFAULT NULL,
1140  `password` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
1141  PRIMARY KEY (`uid`)
1142) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1143/*!40101 SET character_set_client = @saved_cs_client */;
1144
1145--
1146-- Dumping data for table `oc_users`
1147--
1148
1149LOCK TABLES `oc_users` WRITE;
1150/*!40000 ALTER TABLE `oc_users` DISABLE KEYS */;
1151INSERT INTO `oc_users` VALUES ('{{ ADMIN_USER }}',NULL,'1|{{ ADMIN_PWD }}');
1152/*!40000 ALTER TABLE `oc_users` ENABLE KEYS */;
1153UNLOCK TABLES;
1154
1155--
1156-- Table structure for table `oc_vcategory`
1157--
1158
1159DROP TABLE IF EXISTS `oc_vcategory`;
1160/*!40101 SET @saved_cs_client     = @@character_set_client */;
1161/*!40101 SET character_set_client = utf8 */;
1162CREATE TABLE `oc_vcategory` (
1163  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1164  `uid` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
1165  `type` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
1166  `category` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
1167  PRIMARY KEY (`id`),
1168  KEY `uid_index` (`uid`),
1169  KEY `type_index` (`type`),
1170  KEY `category_index` (`category`)
1171) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1172/*!40101 SET character_set_client = @saved_cs_client */;
1173
1174--
1175-- Dumping data for table `oc_vcategory`
1176--
1177
1178LOCK TABLES `oc_vcategory` WRITE;
1179/*!40000 ALTER TABLE `oc_vcategory` DISABLE KEYS */;
1180/*!40000 ALTER TABLE `oc_vcategory` ENABLE KEYS */;
1181UNLOCK TABLES;
1182
1183--
1184-- Table structure for table `oc_vcategory_to_object`
1185--
1186
1187DROP TABLE IF EXISTS `oc_vcategory_to_object`;
1188/*!40101 SET @saved_cs_client     = @@character_set_client */;
1189/*!40101 SET character_set_client = utf8 */;
1190CREATE TABLE `oc_vcategory_to_object` (
1191  `objid` int(10) unsigned NOT NULL DEFAULT '0',
1192  `categoryid` int(10) unsigned NOT NULL DEFAULT '0',
1193  `type` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
1194  PRIMARY KEY (`categoryid`,`objid`,`type`),
1195  KEY `vcategory_objectd_index` (`objid`,`type`)
1196) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1197/*!40101 SET character_set_client = @saved_cs_client */;
1198
1199--
1200-- Dumping data for table `oc_vcategory_to_object`
1201--
1202
1203LOCK TABLES `oc_vcategory_to_object` WRITE;
1204/*!40000 ALTER TABLE `oc_vcategory_to_object` DISABLE KEYS */;
1205/*!40000 ALTER TABLE `oc_vcategory_to_object` ENABLE KEYS */;
1206UNLOCK TABLES;
1207/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1208
1209/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1210/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1211/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1212/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1213/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1214/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1215/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1216
1217-- Dump completed on 2016-05-05 11:19:26
Note: See TracBrowser for help on using the repository browser.