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

Last change on this file since 544 was 544, checked in by jrpelegrina, 5 years ago

First release to xenial

File size: 30.4 KB
Line 
1-- MySQL dump 10.13  Distrib 5.5.41, for debian-linux-gnu (i686)
2--
3-- Host: localhost    Database: owncloud
4-- ------------------------------------------------------
5-- Server version       5.5.41-0ubuntu0.14.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 NOT NULL,
30  `user` varchar(64) COLLATE utf8_bin NOT 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(255) COLLATE utf8_bin NOT NULL,
35  `message` varchar(255) COLLATE utf8_bin DEFAULT NULL,
36  `messageparams` varchar(255) COLLATE utf8_bin DEFAULT NULL,
37  `file` varchar(255) COLLATE utf8_bin DEFAULT NULL,
38  `link` varchar(255) COLLATE utf8_bin DEFAULT NULL,
39  PRIMARY KEY (`activity_id`),
40  KEY `activity_user_time` (`affecteduser`,`timestamp`),
41  KEY `activity_filter_by` (`affecteduser`,`user`,`timestamp`),
42  KEY `activity_filter_app` (`affecteduser`,`app`,`timestamp`)
43) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
44/*!40101 SET character_set_client = @saved_cs_client */;
45
46--
47-- Dumping data for table `oc_activity`
48--
49
50LOCK TABLES `oc_activity` WRITE;
51/*!40000 ALTER TABLE `oc_activity` DISABLE KEYS */;
52/*!40000 ALTER TABLE `oc_activity` ENABLE KEYS */;
53UNLOCK TABLES;
54
55--
56-- Table structure for table `oc_activity_mq`
57--
58
59DROP TABLE IF EXISTS `oc_activity_mq`;
60/*!40101 SET @saved_cs_client     = @@character_set_client */;
61/*!40101 SET character_set_client = utf8 */;
62CREATE TABLE `oc_activity_mq` (
63  `mail_id` int(11) NOT NULL AUTO_INCREMENT,
64  `amq_timestamp` int(11) NOT NULL DEFAULT '0',
65  `amq_latest_send` int(11) NOT NULL DEFAULT '0',
66  `amq_type` varchar(255) COLLATE utf8_bin NOT NULL,
67  `amq_affecteduser` varchar(64) COLLATE utf8_bin NOT NULL,
68  `amq_appid` varchar(255) COLLATE utf8_bin NOT NULL,
69  `amq_subject` varchar(255) COLLATE utf8_bin NOT NULL,
70  `amq_subjectparams` varchar(255) COLLATE utf8_bin NOT NULL,
71  PRIMARY KEY (`mail_id`),
72  KEY `amp_user` (`amq_affecteduser`),
73  KEY `amp_latest_send_time` (`amq_latest_send`),
74  KEY `amp_timestamp_time` (`amq_timestamp`)
75) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
76/*!40101 SET character_set_client = @saved_cs_client */;
77
78--
79-- Dumping data for table `oc_activity_mq`
80--
81
82LOCK TABLES `oc_activity_mq` WRITE;
83/*!40000 ALTER TABLE `oc_activity_mq` DISABLE KEYS */;
84/*!40000 ALTER TABLE `oc_activity_mq` ENABLE KEYS */;
85UNLOCK TABLES;
86
87--
88-- Table structure for table `oc_appconfig`
89--
90
91DROP TABLE IF EXISTS `oc_appconfig`;
92/*!40101 SET @saved_cs_client     = @@character_set_client */;
93/*!40101 SET character_set_client = utf8 */;
94CREATE TABLE `oc_appconfig` (
95  `appid` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
96  `configkey` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
97  `configvalue` longtext COLLATE utf8_bin,
98  PRIMARY KEY (`appid`,`configkey`),
99  KEY `appconfig_config_key_index` (`configkey`),
100  KEY `appconfig_appid_key` (`appid`)
101) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
102/*!40101 SET character_set_client = @saved_cs_client */;
103
104--
105-- Dumping data for table `oc_appconfig`
106--
107
108LOCK TABLES `oc_appconfig` WRITE;
109/*!40000 ALTER TABLE `oc_appconfig` DISABLE KEYS */;
110INSERT INTO `oc_appconfig` VALUES ('activity','enabled','yes'),('activity','installed_version','1.2.0'),('activity','ocsid','166038'),('activity','types','filesystem'),('backgroundjob','lastjob','3'),('core','global_cache_gc_lastrun','1425978988'),('core','installedat','1425629184.6554'),('core','lastcron','1425979055'),('core','lastupdatedat','1425629184.6571'),('core','public_files','files_sharing/public.php'),('core','public_gallery','gallery/public.php'),('core','public_webdav','files_sharing/publicwebdav.php'),('core','remote_files','files/appinfo/remote.php'),('core','remote_webdav','files/appinfo/remote.php'),('files','enabled','yes'),('files','installed_version','1.1.9'),('files','types','filesystem'),('files_locking','enabled','yes'),('files_locking','installed_version',''),('files_locking','types','filesystem'),('files_pdfviewer','enabled','yes'),('files_pdfviewer','installed_version','0.7'),('files_pdfviewer','ocsid','166049'),('files_pdfviewer','types',''),('files_sharing','enabled','yes'),('files_sharing','installed_version','0.6.1'),('files_sharing','ocsid','166050'),('files_sharing','types','filesystem'),('files_texteditor','enabled','yes'),('files_texteditor','installed_version','0.4'),('files_texteditor','ocsid','166051'),('files_texteditor','types',''),('files_trashbin','enabled','yes'),('files_trashbin','installed_version','0.6.2'),('files_trashbin','ocsid','166052'),('files_trashbin','types','filesystem'),('files_versions','enabled','yes'),('files_versions','installed_version','1.0.5'),('files_versions','ocsid','166053'),('files_versions','types','filesystem'),('files_videoviewer','enabled','yes'),('files_videoviewer','installed_version','0.1.3'),('files_videoviewer','ocsid','166054'),('files_videoviewer','types',''),('firstrunwizard','enabled','yes'),('firstrunwizard','installed_version','1.1'),('firstrunwizard','ocsid','166055'),('firstrunwizard','types',''),('gallery','enabled','yes'),('gallery','installed_version','0.6.0'),('gallery','ocsid','166056'),('gallery','types',''),('provisioning_api','enabled','yes'),('provisioning_api','installed_version','0.2'),('provisioning_api','types','filesystem'),('templateeditor','enabled','yes'),('templateeditor','installed_version','0.1'),('templateeditor','types',''),('updater','enabled','yes'),('updater','installed_version','0.4'),('updater','ocsid','166059'),('updater','types',''),('user_ldap','cleanUpJobOffset','0'),('user_ldap','enabled','yes'),('user_ldap','installed_version','0.5.0'),('user_ldap','s01has_memberof_filter_support',''),('user_ldap','s01home_folder_naming_rule',''),('user_ldap','s01last_jpegPhoto_lookup','0'),('user_ldap','s01ldap_agent_password',''),('user_ldap','s01ldap_attributes_for_group_search',''),('user_ldap','s01ldap_attributes_for_user_search',''),('user_ldap','s01ldap_backup_host',''),('user_ldap','s01ldap_backup_port',''),('user_ldap','s01ldap_base','{{ LDAP_BASE_USER_TREE }}'),('user_ldap','s01ldap_base_groups','{{ LDAP_BASE_GROUP_TREE }}'),('user_ldap','s01ldap_base_users','{{ LDAP_BASE_USER_TREE }}'),('user_ldap','s01ldap_cache_ttl','600'),('user_ldap','s01ldap_configuration_active','1'),('user_ldap','s01ldap_display_name','cn'),('user_ldap','s01ldap_dn',''),('user_ldap','s01ldap_email_attr',''),('user_ldap','s01ldap_experienced_admin','1'),('user_ldap','s01ldap_expert_username_attr',''),('user_ldap','s01ldap_expert_uuid_group_attr','cn'),('user_ldap','s01ldap_expert_uuid_user_attr','uid'),('user_ldap','s01ldap_group_display_name','cn'),('user_ldap','s01ldap_group_filter','(objectclass=x-lliurex-group)'),('user_ldap','s01ldap_group_filter_mode','1'),('user_ldap','s01ldap_group_member_assoc_attribute','memberUid'),('user_ldap','s01ldap_groupfilter_groups',''),('user_ldap','s01ldap_groupfilter_objectclass',''),('user_ldap','s01ldap_host','ldap://localhost'),('user_ldap','s01ldap_login_filter','(&(|(objectclass=person))(uid=%uid))'),('user_ldap','s01ldap_login_filter_mode','0'),('user_ldap','s01ldap_loginfilter_attributes',''),('user_ldap','s01ldap_loginfilter_email','0'),('user_ldap','s01ldap_loginfilter_username','1'),('user_ldap','s01ldap_nested_groups','0'),('user_ldap','s01ldap_nocase','0'),('user_ldap','s01ldap_override_main_server',''),('user_ldap','s01ldap_paging_size','500'),('user_ldap','s01ldap_port','389'),('user_ldap','s01ldap_quota_attr',''),('user_ldap','s01ldap_quota_def',''),('user_ldap','s01ldap_tls','1'),('user_ldap','s01ldap_turn_off_cert_check','0'),('user_ldap','s01ldap_user_filter_mode','0'),('user_ldap','s01ldap_userfilter_groups',''),('user_ldap','s01ldap_userfilter_objectclass','posixAccount'),('user_ldap','s01ldap_userlist_filter','(objectclass=*)'),('user_ldap','types','authentication');
111/*!40000 ALTER TABLE `oc_appconfig` ENABLE KEYS */;
112UNLOCK TABLES;
113
114--
115-- Table structure for table `oc_file_map`
116--
117
118DROP TABLE IF EXISTS `oc_file_map`;
119/*!40101 SET @saved_cs_client     = @@character_set_client */;
120/*!40101 SET character_set_client = utf8 */;
121CREATE TABLE `oc_file_map` (
122  `logic_path` varchar(512) COLLATE utf8_bin NOT NULL DEFAULT '',
123  `logic_path_hash` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
124  `physic_path` varchar(512) COLLATE utf8_bin NOT NULL DEFAULT '',
125  `physic_path_hash` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
126  PRIMARY KEY (`logic_path_hash`),
127  UNIQUE KEY `file_map_pp_index` (`physic_path_hash`)
128) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
129/*!40101 SET character_set_client = @saved_cs_client */;
130
131--
132-- Dumping data for table `oc_file_map`
133--
134
135LOCK TABLES `oc_file_map` WRITE;
136/*!40000 ALTER TABLE `oc_file_map` DISABLE KEYS */;
137/*!40000 ALTER TABLE `oc_file_map` ENABLE KEYS */;
138UNLOCK TABLES;
139
140--
141-- Table structure for table `oc_filecache`
142--
143
144DROP TABLE IF EXISTS `oc_filecache`;
145/*!40101 SET @saved_cs_client     = @@character_set_client */;
146/*!40101 SET character_set_client = utf8 */;
147CREATE TABLE `oc_filecache` (
148  `fileid` int(11) NOT NULL AUTO_INCREMENT,
149  `storage` int(11) NOT NULL DEFAULT '0',
150  `path` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
151  `path_hash` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
152  `parent` int(11) NOT NULL DEFAULT '0',
153  `name` varchar(250) COLLATE utf8_bin DEFAULT NULL,
154  `mimetype` int(11) NOT NULL DEFAULT '0',
155  `mimepart` int(11) NOT NULL DEFAULT '0',
156  `size` bigint(20) NOT NULL DEFAULT '0',
157  `mtime` int(11) NOT NULL DEFAULT '0',
158  `storage_mtime` int(11) NOT NULL DEFAULT '0',
159  `encrypted` int(11) NOT NULL DEFAULT '0',
160  `unencrypted_size` bigint(20) NOT NULL DEFAULT '0',
161  `etag` varchar(40) COLLATE utf8_bin DEFAULT NULL,
162  `permissions` int(11) DEFAULT '0',
163  PRIMARY KEY (`fileid`),
164  UNIQUE KEY `fs_storage_path_hash` (`storage`,`path_hash`),
165  KEY `fs_parent_name_hash` (`parent`,`name`),
166  KEY `fs_storage_mimetype` (`storage`,`mimetype`),
167  KEY `fs_storage_mimepart` (`storage`,`mimepart`),
168  KEY `fs_storage_size` (`storage`,`size`,`fileid`)
169) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
170/*!40101 SET character_set_client = @saved_cs_client */;
171
172--
173-- Dumping data for table `oc_filecache`
174--
175
176LOCK TABLES `oc_filecache` WRITE;
177/*!40000 ALTER TABLE `oc_filecache` DISABLE KEYS */;
178INSERT INTO `oc_filecache` VALUES (1,1,'','d41d8cd98f00b204e9800998ecf8427e',-1,'',2,1,2462538,1425629185,1425629185,0,0,'54f960019c42d',23),(2,1,'cache','0fea6a13c52b4d4725368f24b045ca84',1,'cache',2,1,0,1425629184,1425629184,0,0,'54f96000ed2bd',31),(3,1,'files','45b963397aa40d4a0063e0d85e4fe7a1',1,'files',2,1,2462538,1425629185,1425629185,0,0,'54f960019cda1',31),(4,1,'files/Documents','0ad78ba05b6961d92f7970b2b3922eca',3,'Documents',2,1,36227,1425629185,1425629185,0,0,'54f960013b6d1',31),(5,1,'files/Documents/Example.odt','c89c560541b952a435783a7d51a27d50',4,'Example.odt',4,3,36227,1425629185,1425629185,0,0,'f8e4e472e051634b587f45d13b3acf84',27),(6,1,'files/Photos','d01bb67e7b71dd49fd06bad922f521c9',3,'Photos',2,1,678556,1425629185,1425629185,0,0,'54f960018e147',31),(7,1,'files/Photos/San Francisco.jpg','9fc714efbeaafee22f7058e73d2b1c3b',6,'San Francisco.jpg',6,5,216071,1425629185,1425629185,0,0,'3d6c292159ba920e7663a9c9cae495a9',27),(8,1,'files/Photos/Squirrel.jpg','de85d1da71bcd6232ad893f959063b8c',6,'Squirrel.jpg',6,5,233724,1425629185,1425629185,0,0,'4d9881b13184a01367878153086615d9',27),(9,1,'files/Photos/Paris.jpg','a208ddedf08367bbc56963107248dda5',6,'Paris.jpg',6,5,228761,1425629185,1425629185,0,0,'00847517b772dfcf79e49d35684ed2e2',27),(10,1,'files/ownCloudUserManual.pdf','c8edba2d1b8eb651c107b43532c34445',3,'ownCloudUserManual.pdf',7,3,1747755,1425629185,1425629185,0,0,'809b9663a6444e83f98c103fcbdb9c86',27);
179/*!40000 ALTER TABLE `oc_filecache` ENABLE KEYS */;
180UNLOCK TABLES;
181
182--
183-- Table structure for table `oc_files_trash`
184--
185
186DROP TABLE IF EXISTS `oc_files_trash`;
187/*!40101 SET @saved_cs_client     = @@character_set_client */;
188/*!40101 SET character_set_client = utf8 */;
189CREATE TABLE `oc_files_trash` (
190  `auto_id` int(11) NOT NULL AUTO_INCREMENT,
191  `id` varchar(250) COLLATE utf8_bin NOT NULL DEFAULT '',
192  `user` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
193  `timestamp` varchar(12) COLLATE utf8_bin NOT NULL DEFAULT '',
194  `location` varchar(512) COLLATE utf8_bin NOT NULL DEFAULT '',
195  `type` varchar(4) COLLATE utf8_bin DEFAULT NULL,
196  `mime` varchar(255) COLLATE utf8_bin DEFAULT NULL,
197  PRIMARY KEY (`auto_id`),
198  KEY `id_index` (`id`),
199  KEY `timestamp_index` (`timestamp`),
200  KEY `user_index` (`user`)
201) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
202/*!40101 SET character_set_client = @saved_cs_client */;
203
204--
205-- Dumping data for table `oc_files_trash`
206--
207
208LOCK TABLES `oc_files_trash` WRITE;
209/*!40000 ALTER TABLE `oc_files_trash` DISABLE KEYS */;
210/*!40000 ALTER TABLE `oc_files_trash` ENABLE KEYS */;
211UNLOCK TABLES;
212
213--
214-- Table structure for table `oc_group_admin`
215--
216
217DROP TABLE IF EXISTS `oc_group_admin`;
218/*!40101 SET @saved_cs_client     = @@character_set_client */;
219/*!40101 SET character_set_client = utf8 */;
220CREATE TABLE `oc_group_admin` (
221  `gid` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
222  `uid` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
223  PRIMARY KEY (`gid`,`uid`),
224  KEY `group_admin_uid` (`uid`)
225) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
226/*!40101 SET character_set_client = @saved_cs_client */;
227
228--
229-- Dumping data for table `oc_group_admin`
230--
231
232LOCK TABLES `oc_group_admin` WRITE;
233/*!40000 ALTER TABLE `oc_group_admin` DISABLE KEYS */;
234/*!40000 ALTER TABLE `oc_group_admin` ENABLE KEYS */;
235UNLOCK TABLES;
236
237--
238-- Table structure for table `oc_group_user`
239--
240
241DROP TABLE IF EXISTS `oc_group_user`;
242/*!40101 SET @saved_cs_client     = @@character_set_client */;
243/*!40101 SET character_set_client = utf8 */;
244CREATE TABLE `oc_group_user` (
245  `gid` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
246  `uid` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
247  PRIMARY KEY (`gid`,`uid`)
248) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
249/*!40101 SET character_set_client = @saved_cs_client */;
250
251--
252-- Dumping data for table `oc_group_user`
253--
254
255LOCK TABLES `oc_group_user` WRITE;
256/*!40000 ALTER TABLE `oc_group_user` DISABLE KEYS */;
257INSERT INTO `oc_group_user` VALUES ('admin','{{ ADMIN_USER }}');
258/*!40000 ALTER TABLE `oc_group_user` ENABLE KEYS */;
259UNLOCK TABLES;
260
261--
262-- Table structure for table `oc_groups`
263--
264
265DROP TABLE IF EXISTS `oc_groups`;
266/*!40101 SET @saved_cs_client     = @@character_set_client */;
267/*!40101 SET character_set_client = utf8 */;
268CREATE TABLE `oc_groups` (
269  `gid` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
270  PRIMARY KEY (`gid`)
271) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
272/*!40101 SET character_set_client = @saved_cs_client */;
273
274--
275-- Dumping data for table `oc_groups`
276--
277
278LOCK TABLES `oc_groups` WRITE;
279/*!40000 ALTER TABLE `oc_groups` DISABLE KEYS */;
280INSERT INTO `oc_groups` VALUES ('admin');
281/*!40000 ALTER TABLE `oc_groups` ENABLE KEYS */;
282UNLOCK TABLES;
283
284--
285-- Table structure for table `oc_jobs`
286--
287
288DROP TABLE IF EXISTS `oc_jobs`;
289/*!40101 SET @saved_cs_client     = @@character_set_client */;
290/*!40101 SET character_set_client = utf8 */;
291CREATE TABLE `oc_jobs` (
292  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
293  `class` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
294  `argument` varchar(256) COLLATE utf8_bin NOT NULL DEFAULT '',
295  `last_run` int(11) DEFAULT '0',
296  PRIMARY KEY (`id`),
297  KEY `job_class_index` (`class`)
298) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
299/*!40101 SET character_set_client = @saved_cs_client */;
300
301--
302-- Dumping data for table `oc_jobs`
303--
304
305LOCK TABLES `oc_jobs` WRITE;
306/*!40000 ALTER TABLE `oc_jobs` DISABLE KEYS */;
307INSERT INTO `oc_jobs` VALUES (1,'OC\\Cache\\FileGlobalGC','null',1425978988),(2,'OCA\\Activity\\BackgroundJob\\EmailNotification','null',1425979054),(3,'OCA\\Activity\\BackgroundJob\\ExpireActivities','null',1425979055),(4,'OCA\\user_ldap\\lib\\Jobs','null',1425629914),(5,'\\OCA\\User_LDAP\\Jobs\\CleanUp','null',1425978987);
308/*!40000 ALTER TABLE `oc_jobs` ENABLE KEYS */;
309UNLOCK TABLES;
310
311--
312-- Table structure for table `oc_ldap_group_mapping`
313--
314
315DROP TABLE IF EXISTS `oc_ldap_group_mapping`;
316/*!40101 SET @saved_cs_client     = @@character_set_client */;
317/*!40101 SET character_set_client = utf8 */;
318CREATE TABLE `oc_ldap_group_mapping` (
319  `ldap_dn` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
320  `owncloud_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
321  `directory_uuid` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
322  PRIMARY KEY (`ldap_dn`),
323  UNIQUE KEY `owncloud_name_groups` (`owncloud_name`)
324) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
325/*!40101 SET character_set_client = @saved_cs_client */;
326
327--
328-- Dumping data for table `oc_ldap_group_mapping`
329--
330
331LOCK TABLES `oc_ldap_group_mapping` WRITE;
332/*!40000 ALTER TABLE `oc_ldap_group_mapping` DISABLE KEYS */;
333/*!40000 ALTER TABLE `oc_ldap_group_mapping` ENABLE KEYS */;
334UNLOCK TABLES;
335
336--
337-- Table structure for table `oc_ldap_group_members`
338--
339
340DROP TABLE IF EXISTS `oc_ldap_group_members`;
341/*!40101 SET @saved_cs_client     = @@character_set_client */;
342/*!40101 SET character_set_client = utf8 */;
343CREATE TABLE `oc_ldap_group_members` (
344  `owncloudname` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
345  `owncloudusers` longtext COLLATE utf8_bin NOT NULL,
346  PRIMARY KEY (`owncloudname`)
347) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
348/*!40101 SET character_set_client = @saved_cs_client */;
349
350--
351-- Dumping data for table `oc_ldap_group_members`
352--
353
354LOCK TABLES `oc_ldap_group_members` WRITE;
355/*!40000 ALTER TABLE `oc_ldap_group_members` DISABLE KEYS */;
356/*!40000 ALTER TABLE `oc_ldap_group_members` ENABLE KEYS */;
357UNLOCK TABLES;
358
359--
360-- Table structure for table `oc_ldap_user_mapping`
361--
362
363DROP TABLE IF EXISTS `oc_ldap_user_mapping`;
364/*!40101 SET @saved_cs_client     = @@character_set_client */;
365/*!40101 SET character_set_client = utf8 */;
366CREATE TABLE `oc_ldap_user_mapping` (
367  `ldap_dn` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
368  `owncloud_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
369  `directory_uuid` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
370  PRIMARY KEY (`owncloud_name`),
371  UNIQUE KEY `ldap_dn_users` (`ldap_dn`)
372) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
373/*!40101 SET character_set_client = @saved_cs_client */;
374
375--
376-- Dumping data for table `oc_ldap_user_mapping`
377--
378
379LOCK TABLES `oc_ldap_user_mapping` WRITE;
380/*!40000 ALTER TABLE `oc_ldap_user_mapping` DISABLE KEYS */;
381/*!40000 ALTER TABLE `oc_ldap_user_mapping` ENABLE KEYS */;
382UNLOCK TABLES;
383
384--
385-- Table structure for table `oc_locks`
386--
387
388DROP TABLE IF EXISTS `oc_locks`;
389/*!40101 SET @saved_cs_client     = @@character_set_client */;
390/*!40101 SET character_set_client = utf8 */;
391CREATE TABLE `oc_locks` (
392  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
393  `userid` varchar(64) COLLATE utf8_bin DEFAULT NULL,
394  `owner` varchar(100) COLLATE utf8_bin DEFAULT NULL,
395  `timeout` int(10) unsigned DEFAULT NULL,
396  `created` bigint(20) DEFAULT NULL,
397  `token` varchar(100) COLLATE utf8_bin DEFAULT NULL,
398  `scope` smallint(6) DEFAULT NULL,
399  `depth` smallint(6) DEFAULT NULL,
400  `uri` longtext COLLATE utf8_bin,
401  PRIMARY KEY (`id`)
402) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
403/*!40101 SET character_set_client = @saved_cs_client */;
404
405--
406-- Dumping data for table `oc_locks`
407--
408
409LOCK TABLES `oc_locks` WRITE;
410/*!40000 ALTER TABLE `oc_locks` DISABLE KEYS */;
411/*!40000 ALTER TABLE `oc_locks` ENABLE KEYS */;
412UNLOCK TABLES;
413
414--
415-- Table structure for table `oc_mimetypes`
416--
417
418DROP TABLE IF EXISTS `oc_mimetypes`;
419/*!40101 SET @saved_cs_client     = @@character_set_client */;
420/*!40101 SET character_set_client = utf8 */;
421CREATE TABLE `oc_mimetypes` (
422  `id` int(11) NOT NULL AUTO_INCREMENT,
423  `mimetype` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
424  PRIMARY KEY (`id`),
425  UNIQUE KEY `mimetype_id_index` (`mimetype`)
426) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
427/*!40101 SET character_set_client = @saved_cs_client */;
428
429--
430-- Dumping data for table `oc_mimetypes`
431--
432
433LOCK TABLES `oc_mimetypes` WRITE;
434/*!40000 ALTER TABLE `oc_mimetypes` DISABLE KEYS */;
435INSERT INTO `oc_mimetypes` VALUES (3,'application'),(7,'application/pdf'),(4,'application/vnd.oasis.opendocument.text'),(1,'httpd'),(2,'httpd/unix-directory'),(5,'image'),(6,'image/jpeg');
436/*!40000 ALTER TABLE `oc_mimetypes` ENABLE KEYS */;
437UNLOCK TABLES;
438
439--
440-- Table structure for table `oc_preferences`
441--
442
443DROP TABLE IF EXISTS `oc_preferences`;
444/*!40101 SET @saved_cs_client     = @@character_set_client */;
445/*!40101 SET character_set_client = utf8 */;
446CREATE TABLE `oc_preferences` (
447  `userid` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
448  `appid` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
449  `configkey` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
450  `configvalue` longtext COLLATE utf8_bin,
451  PRIMARY KEY (`userid`,`appid`,`configkey`)
452) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
453/*!40101 SET character_set_client = @saved_cs_client */;
454
455--
456-- Dumping data for table `oc_preferences`
457--
458
459LOCK TABLES `oc_preferences` WRITE;
460/*!40000 ALTER TABLE `oc_preferences` DISABLE KEYS */;
461INSERT INTO `oc_preferences` VALUES ('{{ ADMIN_USER }}','firstrunwizard','show','0');
462/*!40000 ALTER TABLE `oc_preferences` ENABLE KEYS */;
463UNLOCK TABLES;
464
465--
466-- Table structure for table `oc_privatedata`
467--
468
469DROP TABLE IF EXISTS `oc_privatedata`;
470/*!40101 SET @saved_cs_client     = @@character_set_client */;
471/*!40101 SET character_set_client = utf8 */;
472CREATE TABLE `oc_privatedata` (
473  `keyid` int(10) unsigned NOT NULL AUTO_INCREMENT,
474  `user` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
475  `app` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
476  `key` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
477  `value` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
478  PRIMARY KEY (`keyid`)
479) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
480/*!40101 SET character_set_client = @saved_cs_client */;
481
482--
483-- Dumping data for table `oc_privatedata`
484--
485
486LOCK TABLES `oc_privatedata` WRITE;
487/*!40000 ALTER TABLE `oc_privatedata` DISABLE KEYS */;
488/*!40000 ALTER TABLE `oc_privatedata` ENABLE KEYS */;
489UNLOCK TABLES;
490
491--
492-- Table structure for table `oc_properties`
493--
494
495DROP TABLE IF EXISTS `oc_properties`;
496/*!40101 SET @saved_cs_client     = @@character_set_client */;
497/*!40101 SET character_set_client = utf8 */;
498CREATE TABLE `oc_properties` (
499  `id` int(11) NOT NULL AUTO_INCREMENT,
500  `userid` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
501  `propertypath` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
502  `propertyname` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
503  `propertyvalue` varchar(255) COLLATE utf8_bin NOT NULL,
504  PRIMARY KEY (`id`),
505  KEY `property_index` (`userid`)
506) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
507/*!40101 SET character_set_client = @saved_cs_client */;
508
509--
510-- Dumping data for table `oc_properties`
511--
512
513LOCK TABLES `oc_properties` WRITE;
514/*!40000 ALTER TABLE `oc_properties` DISABLE KEYS */;
515/*!40000 ALTER TABLE `oc_properties` ENABLE KEYS */;
516UNLOCK TABLES;
517
518--
519-- Table structure for table `oc_share`
520--
521
522DROP TABLE IF EXISTS `oc_share`;
523/*!40101 SET @saved_cs_client     = @@character_set_client */;
524/*!40101 SET character_set_client = utf8 */;
525CREATE TABLE `oc_share` (
526  `id` int(11) NOT NULL AUTO_INCREMENT,
527  `share_type` smallint(6) NOT NULL DEFAULT '0',
528  `share_with` varchar(255) COLLATE utf8_bin DEFAULT NULL,
529  `uid_owner` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
530  `parent` int(11) DEFAULT NULL,
531  `item_type` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
532  `item_source` varchar(255) COLLATE utf8_bin DEFAULT NULL,
533  `item_target` varchar(255) COLLATE utf8_bin DEFAULT NULL,
534  `file_source` int(11) DEFAULT NULL,
535  `file_target` varchar(512) COLLATE utf8_bin DEFAULT NULL,
536  `permissions` smallint(6) NOT NULL DEFAULT '0',
537  `stime` bigint(20) NOT NULL DEFAULT '0',
538  `accepted` smallint(6) NOT NULL DEFAULT '0',
539  `expiration` datetime DEFAULT NULL,
540  `token` varchar(32) COLLATE utf8_bin DEFAULT NULL,
541  `mail_send` smallint(6) NOT NULL DEFAULT '0',
542  PRIMARY KEY (`id`),
543  KEY `item_share_type_index` (`item_type`,`share_type`),
544  KEY `file_source_index` (`file_source`),
545  KEY `token_index` (`token`)
546) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
547/*!40101 SET character_set_client = @saved_cs_client */;
548
549--
550-- Dumping data for table `oc_share`
551--
552
553LOCK TABLES `oc_share` WRITE;
554/*!40000 ALTER TABLE `oc_share` DISABLE KEYS */;
555/*!40000 ALTER TABLE `oc_share` ENABLE KEYS */;
556UNLOCK TABLES;
557
558--
559-- Table structure for table `oc_share_external`
560--
561
562DROP TABLE IF EXISTS `oc_share_external`;
563/*!40101 SET @saved_cs_client     = @@character_set_client */;
564/*!40101 SET character_set_client = utf8 */;
565CREATE TABLE `oc_share_external` (
566  `id` int(11) NOT NULL AUTO_INCREMENT,
567  `remote` varchar(512) COLLATE utf8_bin NOT NULL COMMENT 'Url of the remove owncloud instance',
568  `remote_id` int(11) NOT NULL DEFAULT '-1',
569  `share_token` varchar(64) COLLATE utf8_bin NOT NULL COMMENT 'Public share token',
570  `password` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT 'Optional password for the public share',
571  `name` varchar(64) COLLATE utf8_bin NOT NULL COMMENT 'Original name on the remote server',
572  `owner` varchar(64) COLLATE utf8_bin NOT NULL COMMENT 'User that owns the public share on the remote server',
573  `user` varchar(64) COLLATE utf8_bin NOT NULL COMMENT 'Local user which added the external share',
574  `mountpoint` varchar(4000) COLLATE utf8_bin NOT NULL COMMENT 'Full path where the share is mounted',
575  `mountpoint_hash` varchar(32) COLLATE utf8_bin NOT NULL COMMENT 'md5 hash of the mountpoint',
576  `accepted` int(11) NOT NULL DEFAULT '0',
577  PRIMARY KEY (`id`),
578  UNIQUE KEY `sh_external_mp` (`user`,`mountpoint_hash`),
579  KEY `sh_external_user` (`user`)
580) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
581/*!40101 SET character_set_client = @saved_cs_client */;
582
583--
584-- Dumping data for table `oc_share_external`
585--
586
587LOCK TABLES `oc_share_external` WRITE;
588/*!40000 ALTER TABLE `oc_share_external` DISABLE KEYS */;
589/*!40000 ALTER TABLE `oc_share_external` ENABLE KEYS */;
590UNLOCK TABLES;
591
592--
593-- Table structure for table `oc_storages`
594--
595
596DROP TABLE IF EXISTS `oc_storages`;
597/*!40101 SET @saved_cs_client     = @@character_set_client */;
598/*!40101 SET character_set_client = utf8 */;
599CREATE TABLE `oc_storages` (
600  `id` varchar(64) COLLATE utf8_bin DEFAULT NULL,
601  `numeric_id` int(11) NOT NULL AUTO_INCREMENT,
602  PRIMARY KEY (`numeric_id`),
603  UNIQUE KEY `storages_id_index` (`id`)
604) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
605/*!40101 SET character_set_client = @saved_cs_client */;
606
607--
608-- Dumping data for table `oc_storages`
609--
610
611LOCK TABLES `oc_storages` WRITE;
612/*!40000 ALTER TABLE `oc_storages` DISABLE KEYS */;
613INSERT INTO `oc_storages` VALUES ('home::{{ ADMIN_USER }}',1),('local::/var/www/owncloud/data/',2);
614/*!40000 ALTER TABLE `oc_storages` ENABLE KEYS */;
615UNLOCK TABLES;
616
617--
618-- Table structure for table `oc_users`
619--
620
621DROP TABLE IF EXISTS `oc_users`;
622/*!40101 SET @saved_cs_client     = @@character_set_client */;
623/*!40101 SET character_set_client = utf8 */;
624CREATE TABLE `oc_users` (
625  `uid` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
626  `displayname` varchar(64) COLLATE utf8_bin DEFAULT NULL,
627  `password` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
628  PRIMARY KEY (`uid`)
629) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
630/*!40101 SET character_set_client = @saved_cs_client */;
631
632--
633-- Dumping data for table `oc_users`
634--
635
636LOCK TABLES `oc_users` WRITE;
637/*!40000 ALTER TABLE `oc_users` DISABLE KEYS */;
638INSERT INTO `oc_users` VALUES ('{{ ADMIN_USER }}',NULL,'1|{{ ADMIN_PWD }}');
639/*!40000 ALTER TABLE `oc_users` ENABLE KEYS */;
640UNLOCK TABLES;
641
642--
643-- Table structure for table `oc_vcategory`
644--
645
646DROP TABLE IF EXISTS `oc_vcategory`;
647/*!40101 SET @saved_cs_client     = @@character_set_client */;
648/*!40101 SET character_set_client = utf8 */;
649CREATE TABLE `oc_vcategory` (
650  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
651  `uid` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
652  `type` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
653  `category` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
654  PRIMARY KEY (`id`),
655  KEY `uid_index` (`uid`),
656  KEY `type_index` (`type`),
657  KEY `category_index` (`category`)
658) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
659/*!40101 SET character_set_client = @saved_cs_client */;
660
661--
662-- Dumping data for table `oc_vcategory`
663--
664
665LOCK TABLES `oc_vcategory` WRITE;
666/*!40000 ALTER TABLE `oc_vcategory` DISABLE KEYS */;
667/*!40000 ALTER TABLE `oc_vcategory` ENABLE KEYS */;
668UNLOCK TABLES;
669
670--
671-- Table structure for table `oc_vcategory_to_object`
672--
673
674DROP TABLE IF EXISTS `oc_vcategory_to_object`;
675/*!40101 SET @saved_cs_client     = @@character_set_client */;
676/*!40101 SET character_set_client = utf8 */;
677CREATE TABLE `oc_vcategory_to_object` (
678  `objid` int(10) unsigned NOT NULL DEFAULT '0',
679  `categoryid` int(10) unsigned NOT NULL DEFAULT '0',
680  `type` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
681  PRIMARY KEY (`categoryid`,`objid`,`type`),
682  KEY `vcategory_objectd_index` (`objid`,`type`)
683) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
684/*!40101 SET character_set_client = @saved_cs_client */;
685
686--
687-- Dumping data for table `oc_vcategory_to_object`
688--
689
690LOCK TABLES `oc_vcategory_to_object` WRITE;
691/*!40000 ALTER TABLE `oc_vcategory_to_object` DISABLE KEYS */;
692/*!40000 ALTER TABLE `oc_vcategory_to_object` ENABLE KEYS */;
693UNLOCK TABLES;
694
695--
696-- Dumping routines for database 'owncloud'
697--
698/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
699
700/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
701/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
702/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
703/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
704/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
705/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
706/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
707
708-- Dump completed on 2015-03-10 10:21:10
Note: See TracBrowser for help on using the repository browser.