Changeset 3228
- Timestamp:
- Jan 10, 2017, 5:47:17 PM (4 years ago)
- Location:
- lliurex-owncloud/trunk/fuentes/install-files
- Files:
-
- 1 added
- 1 deleted
- 4 edited
-
etc/apache2/conf-available/owncloud.conf (modified) (3 diffs)
-
usr/share/lliurex-owncloud/llx-data/.htaccess (modified) (2 diffs)
-
usr/share/lliurex-owncloud/llx-data/config/config.php (modified) (1 diff)
-
usr/share/lliurex-owncloud/llx-data/data/ADMIN_USER/files/ownCloud_Manual.pdf (added)
-
usr/share/lliurex-owncloud/llx-data/data/ADMIN_USER/files/ownCloud_User_Manual.pdf (deleted)
-
usr/share/lliurex-owncloud/llx-data/owncloud.sql (modified) (24 diffs)
Legend:
- Unmodified
- Added
- Removed
-
lliurex-owncloud/trunk/fuentes/install-files/etc/apache2/conf-available/owncloud.conf
r1415 r3228 1 # Version:9.0.1.32 # Version: 9.0.1.33 1 <IfModule mod_headers.c> 4 2 <IfModule mod_setenvif.c> … … 59 57 RewriteRule ^\.well-known/caldav /remote.php/dav/ [R=301,L] 60 58 RewriteRule ^remote/(.*) remote.php [QSA,L] 61 RewriteRule ^( build|tests|config|lib|3rdparty|templates)/.* - [R=404,L]59 RewriteRule ^(?:build|tests|config|lib|3rdparty|templates)/.* - [R=404,L] 62 60 RewriteCond %{REQUEST_URI} !^/.well-known/acme-challenge/.* 63 RewriteRule ^(\.|autotest|occ|issue|indie|db_|console).* - [R=404,L] 64 65 # Rewrite rules for `front_controller_active` 66 Options -MultiViews 67 RewriteRule ^core/js/oc.js$ index.php [PT,E=PATH_INFO:$1] 68 RewriteRule ^core/preview.png$ index.php [PT,E=PATH_INFO:$1] 69 RewriteCond %{REQUEST_FILENAME} !\.(css|js|svg|gif|png|html|ttf|woff|ico|jpg|jpeg)$ 70 RewriteCond %{REQUEST_FILENAME} !core/img/favicon.ico$ 71 RewriteCond %{REQUEST_FILENAME} !/remote.php 72 RewriteCond %{REQUEST_FILENAME} !/public.php 73 RewriteCond %{REQUEST_FILENAME} !/cron.php 74 RewriteCond %{REQUEST_FILENAME} !/core/ajax/update.php 75 RewriteCond %{REQUEST_FILENAME} !/status.php 76 RewriteCond %{REQUEST_FILENAME} !/ocs/v1.php 77 RewriteCond %{REQUEST_FILENAME} !/ocs/v2.php 78 RewriteCond %{REQUEST_FILENAME} !/updater/ 79 RewriteCond %{REQUEST_FILENAME} !/ocs-provider/ 80 RewriteCond %{REQUEST_URI} !^/.well-known/acme-challenge/.* 61 RewriteRule ^(?:\.|autotest|occ|issue|indie|db_|console).* - [R=404,L] 81 62 </IfModule> 82 63 <IfModule mod_mime.c> … … 92 73 ModPagespeed Off 93 74 </IfModule> 94 -
lliurex-owncloud/trunk/fuentes/install-files/usr/share/lliurex-owncloud/llx-data/.htaccess
r1415 r3228 1 # Version: 9.0.1.32 1 <IfModule mod_headers.c> 3 2 <IfModule mod_setenvif.c> … … 58 57 RewriteRule ^\.well-known/caldav /remote.php/dav/ [R=301,L] 59 58 RewriteRule ^remote/(.*) remote.php [QSA,L] 60 RewriteRule ^( build|tests|config|lib|3rdparty|templates)/.* - [R=404,L]59 RewriteRule ^(?:build|tests|config|lib|3rdparty|templates)/.* - [R=404,L] 61 60 RewriteCond %{REQUEST_URI} !^/.well-known/acme-challenge/.* 62 RewriteRule ^(\.|autotest|occ|issue|indie|db_|console).* - [R=404,L] 63 64 # Rewrite rules for `front_controller_active` 65 Options -MultiViews 66 RewriteRule ^core/js/oc.js$ index.php [PT,E=PATH_INFO:$1] 67 RewriteRule ^core/preview.png$ index.php [PT,E=PATH_INFO:$1] 68 RewriteCond %{REQUEST_FILENAME} !\.(css|js|svg|gif|png|html|ttf|woff|ico|jpg|jpeg)$ 69 RewriteCond %{REQUEST_FILENAME} !core/img/favicon.ico$ 70 RewriteCond %{REQUEST_FILENAME} !/remote.php 71 RewriteCond %{REQUEST_FILENAME} !/public.php 72 RewriteCond %{REQUEST_FILENAME} !/cron.php 73 RewriteCond %{REQUEST_FILENAME} !/core/ajax/update.php 74 RewriteCond %{REQUEST_FILENAME} !/status.php 75 RewriteCond %{REQUEST_FILENAME} !/ocs/v1.php 76 RewriteCond %{REQUEST_FILENAME} !/ocs/v2.php 77 RewriteCond %{REQUEST_FILENAME} !/updater/ 78 RewriteCond %{REQUEST_FILENAME} !/ocs-provider/ 79 RewriteCond %{REQUEST_URI} !^/.well-known/acme-challenge/.* 61 RewriteRule ^(?:\.|autotest|occ|issue|indie|db_|console).* - [R=404,L] 80 62 </IfModule> 81 63 <IfModule mod_mime.c> -
lliurex-owncloud/trunk/fuentes/install-files/usr/share/lliurex-owncloud/llx-data/config/config.php
r1422 r3228 15 15 'overwrite.cli.url' => 'http://{{ SRV_IP }}/owncloud', 16 16 'dbtype' => 'mysql', 17 'version' => '9. 0.1.3',17 'version' => '9.1.3.1', 18 18 'dbname' => '{{ DB_NAME }}', 19 19 'dbhost' => 'localhost', -
lliurex-owncloud/trunk/fuentes/install-files/usr/share/lliurex-owncloud/llx-data/owncloud.sql
r1415 r3228 1 -- MySQL dump 10.13 Distrib 5.7.1 2, for Linux (i686)1 -- MySQL dump 10.13 Distrib 5.7.15, for Linux (x86_64) 2 2 -- 3 3 -- Host: localhost Database: owncloud 4 4 -- ------------------------------------------------------ 5 -- Server version 5.7.1 2-0ubuntu15 -- Server version 5.7.15-0ubuntu0.16.04.1 6 6 7 7 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; … … 43 43 KEY `activity_user_time` (`affecteduser`,`timestamp`), 44 44 KEY `activity_filter_by` (`affecteduser`,`user`,`timestamp`), 45 KEY `activity_filter_app` (`affecteduser`,`app`,`timestamp`) 45 KEY `activity_filter_app` (`affecteduser`,`app`,`timestamp`), 46 KEY `activity_object` (`object_type`,`object_id`) 46 47 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; 47 48 /*!40101 SET character_set_client = @saved_cs_client */; … … 103 104 PRIMARY KEY (`id`), 104 105 KEY `addressbookid_synctoken` (`addressbookid`,`synctoken`) 105 ) ENGINE=InnoDB AUTO_INCREMENT= 3DEFAULT CHARSET=utf8 COLLATE=utf8_bin;106 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; 106 107 /*!40101 SET character_set_client = @saved_cs_client */; 107 108 … … 112 113 LOCK TABLES `oc_addressbookchanges` WRITE; 113 114 /*!40000 ALTER TABLE `oc_addressbookchanges` DISABLE KEYS */; 114 INSERT INTO `oc_addressbookchanges` VALUES (1,'Database:owncloud_admin.vcf',1,1,1),(2,'LDAP:aa5cff10-a590-1035-9744-679cd252e7a8.vcf',2,1,1);115 115 /*!40000 ALTER TABLE `oc_addressbookchanges` ENABLE KEYS */; 116 116 UNLOCK TABLES; … … 141 141 LOCK TABLES `oc_addressbooks` WRITE; 142 142 /*!40000 ALTER TABLE `oc_addressbooks` DISABLE KEYS */; 143 INSERT 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 143 /*!40000 ALTER TABLE `oc_addressbooks` ENABLE KEYS */; 145 144 UNLOCK TABLES; … … 168 167 LOCK TABLES `oc_appconfig` WRITE; 169 168 /*!40000 ALTER TABLE `oc_appconfig` DISABLE KEYS */; 170 INSERT 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');169 INSERT 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'); 171 170 /*!40000 ALTER TABLE `oc_appconfig` ENABLE KEYS */; 171 UNLOCK TABLES; 172 173 -- 174 -- Table structure for table `oc_authtoken` 175 -- 176 177 DROP TABLE IF EXISTS `oc_authtoken`; 178 /*!40101 SET @saved_cs_client = @@character_set_client */; 179 /*!40101 SET character_set_client = utf8 */; 180 CREATE 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 200 LOCK TABLES `oc_authtoken` WRITE; 201 /*!40000 ALTER TABLE `oc_authtoken` DISABLE KEYS */; 202 INSERT INTO `oc_authtoken` VALUES (1,'owncloud_admin','owncloud_admin','f5a6c14174072369af3e8c508407ad91|kv8NaZIuBwy/o6pv|f2a146fc8d205efc99649af3f297f078f30af0e95348588c2ec0fd3173ae5c9fb1f2b7b725793631e9b6e6951ed03ae9650f42620577ec942f55d2a87b021378','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:49.0) Gecko/20100101 Firefox/49.0','36c07888d583371a3e38c98406d0cc007446b241ff914ee011dfb504a6f6fdb4c13d5a72aee4e92e79bab66e238f1fdc3f19d030c46532c884219b875e74fc78',0,1483963362,1483963195),(3,'owncloud_admin','owncloud_admin','035261d6f12473e525d5c270df452d75|K652fuQ7DwrvULDL|ee76cc2fae49297babb25c713097bef5565aa8a429d4d80902c56bbefb2bbd38b5cdc6890fae0bac4b8c0a2eb7fe6839a823e6e72e1a5de50fffb3c59baa1512','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:48.0) Gecko/20100101 Firefox/48.0','84707555a9511e8fb309e011d9a619a8d8755acd95dde098b08bd2c6c5119f19cf785b14f217515e910e30f9ea3c743366a5872106c5c7925e3207477740070e',0,1484051451,1484051181); 203 /*!40000 ALTER TABLE `oc_authtoken` ENABLE KEYS */; 172 204 UNLOCK TABLES; 173 205 … … 214 246 `etag` varchar(32) COLLATE utf8_bin DEFAULT NULL, 215 247 `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,248 `componenttype` varchar(8) COLLATE utf8_bin DEFAULT NULL, 249 `firstoccurence` bigint(20) unsigned DEFAULT NULL, 250 `lastoccurence` bigint(20) unsigned DEFAULT NULL, 219 251 `uid` varchar(255) COLLATE utf8_bin DEFAULT NULL, 252 `classification` int(11) DEFAULT '0' COMMENT '0 - public, 1 - private, 2 - confidential', 220 253 PRIMARY KEY (`id`), 221 254 UNIQUE KEY `calobjects_index` (`calendarid`,`uri`) … … 249 282 `calendarcolor` varchar(255) COLLATE utf8_bin DEFAULT NULL, 250 283 `timezone` longtext COLLATE utf8_bin, 251 `components` varchar(2 55) COLLATE utf8_bin DEFAULT NULL,284 `components` varchar(20) COLLATE utf8_bin DEFAULT NULL, 252 285 `transparent` smallint(6) NOT NULL DEFAULT '0', 253 286 PRIMARY KEY (`id`), … … 262 295 LOCK TABLES `oc_calendars` WRITE; 263 296 /*!40000 ALTER TABLE `oc_calendars` DISABLE KEYS */; 264 INSERT 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 297 /*!40000 ALTER TABLE `oc_calendars` ENABLE KEYS */; 266 298 UNLOCK TABLES; … … 316 348 `size` bigint(20) unsigned NOT NULL, 317 349 PRIMARY KEY (`id`) 318 ) ENGINE=InnoDB AUTO_INCREMENT= 3DEFAULT CHARSET=utf8 COLLATE=utf8_bin;350 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; 319 351 /*!40101 SET character_set_client = @saved_cs_client */; 320 352 … … 346 378 KEY `card_name_index` (`name`), 347 379 KEY `card_value_index` (`value`) 348 ) ENGINE=InnoDB AUTO_INCREMENT= 9DEFAULT CHARSET=utf8 COLLATE=utf8_bin;380 ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; 349 381 /*!40101 SET character_set_client = @saved_cs_client */; 350 382 … … 474 506 475 507 -- 508 -- Table structure for table `oc_federated_reshares` 509 -- 510 511 DROP TABLE IF EXISTS `oc_federated_reshares`; 512 /*!40101 SET @saved_cs_client = @@character_set_client */; 513 /*!40101 SET character_set_client = utf8 */; 514 CREATE TABLE `oc_federated_reshares` ( 515 `share_id` int(11) NOT NULL, 516 `remote_id` int(11) NOT NULL COMMENT 'share ID at the remote server', 517 UNIQUE KEY `share_id_index` (`share_id`) 518 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; 519 /*!40101 SET character_set_client = @saved_cs_client */; 520 521 -- 522 -- Dumping data for table `oc_federated_reshares` 523 -- 524 525 LOCK TABLES `oc_federated_reshares` WRITE; 526 /*!40000 ALTER TABLE `oc_federated_reshares` DISABLE KEYS */; 527 /*!40000 ALTER TABLE `oc_federated_reshares` ENABLE KEYS */; 528 UNLOCK TABLES; 529 530 -- 476 531 -- Table structure for table `oc_file_locks` 477 532 -- … … 488 543 UNIQUE KEY `lock_key_index` (`key`), 489 544 KEY `lock_ttl_index` (`ttl`) 490 ) ENGINE=InnoDB AUTO_INCREMENT= 10DEFAULT CHARSET=utf8 COLLATE=utf8_bin;545 ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; 491 546 /*!40101 SET character_set_client = @saved_cs_client */; 492 547 … … 497 552 LOCK TABLES `oc_file_locks` WRITE; 498 553 /*!40000 ALTER TABLE `oc_file_locks` DISABLE KEYS */; 499 INSERT INTO `oc_file_locks` VALUES ( 1,0,'files/61ed1f9a7383795ed88817d445e1546b',1462439524),(2,0,'files/c31e581b3c2ec56f9b7b1dca2421b72e',1462439524),(3,0,'files/ef90c82ae6bd9d9a22ee5b7c93d77ca7',1462439524);554 INSERT 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); 500 555 /*!40000 ALTER TABLE `oc_file_locks` ENABLE KEYS */; 501 556 UNLOCK TABLES; … … 540 595 LOCK TABLES `oc_filecache` WRITE; 541 596 /*!40000 ALTER TABLE `oc_filecache` DISABLE KEYS */; 542 INSERT 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);597 INSERT 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,''); 543 598 /*!40000 ALTER TABLE `oc_filecache` ENABLE KEYS */; 544 599 UNLOCK TABLES; … … 659 714 `argument` varchar(4000) COLLATE utf8_bin NOT NULL DEFAULT '', 660 715 `last_run` int(11) DEFAULT '0', 716 `last_checked` int(11) DEFAULT '0', 717 `reserved_at` int(11) DEFAULT '0', 661 718 PRIMARY KEY (`id`), 662 719 KEY `job_class_index` (`class`) 663 ) ENGINE=InnoDB AUTO_INCREMENT=1 4DEFAULT CHARSET=utf8 COLLATE=utf8_bin;720 ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; 664 721 /*!40101 SET character_set_client = @saved_cs_client */; 665 722 … … 670 727 LOCK TABLES `oc_jobs` WRITE; 671 728 /*!40000 ALTER TABLE `oc_jobs` DISABLE KEYS */; 672 INSERT 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);729 INSERT 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); 673 730 /*!40000 ALTER TABLE `oc_jobs` ENABLE KEYS */; 674 731 UNLOCK TABLES; … … 759 816 PRIMARY KEY (`id`), 760 817 UNIQUE KEY `mimetype_id_index` (`mimetype`) 761 ) ENGINE=InnoDB AUTO_INCREMENT= 7DEFAULT CHARSET=utf8 COLLATE=utf8_bin;818 ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; 762 819 /*!40101 SET character_set_client = @saved_cs_client */; 763 820 … … 768 825 LOCK TABLES `oc_mimetypes` WRITE; 769 826 /*!40000 ALTER TABLE `oc_mimetypes` DISABLE KEYS */; 770 INSERT 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');827 INSERT 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'); 771 828 /*!40000 ALTER TABLE `oc_mimetypes` ENABLE KEYS */; 772 829 UNLOCK TABLES; … … 799 856 LOCK TABLES `oc_mounts` WRITE; 800 857 /*!40000 ALTER TABLE `oc_mounts` DISABLE KEYS */; 858 INSERT INTO `oc_mounts` VALUES (1,1,1,'owncloud_admin','/owncloud_admin/'); 801 859 /*!40000 ALTER TABLE `oc_mounts` ENABLE KEYS */; 802 860 UNLOCK TABLES; … … 863 921 INSERT INTO `oc_preferences` VALUES ('{{ ADMIN_USER }}','core','lang','es'),('{{ ADMIN_USER }}','firstrunwizard','show','0'); 864 922 /*!40000 ALTER TABLE `oc_preferences` ENABLE KEYS */; 865 /*!40000 ALTER TABLE `oc_preferences` ENABLE KEYS */;866 923 UNLOCK TABLES; 867 924 … … 1036 1093 PRIMARY KEY (`numeric_id`), 1037 1094 UNIQUE KEY `storages_id_index` (`id`) 1038 ) ENGINE=InnoDB AUTO_INCREMENT= 11DEFAULT CHARSET=utf8 COLLATE=utf8_bin;1095 ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; 1039 1096 /*!40101 SET character_set_client = @saved_cs_client */; 1040 1097 … … 1073 1130 /*!40000 ALTER TABLE `oc_systemtag` DISABLE KEYS */; 1074 1131 /*!40000 ALTER TABLE `oc_systemtag` ENABLE KEYS */; 1132 UNLOCK TABLES; 1133 1134 -- 1135 -- Table structure for table `oc_systemtag_group` 1136 -- 1137 1138 DROP TABLE IF EXISTS `oc_systemtag_group`; 1139 /*!40101 SET @saved_cs_client = @@character_set_client */; 1140 /*!40101 SET character_set_client = utf8 */; 1141 CREATE TABLE `oc_systemtag_group` ( 1142 `systemtagid` int(10) unsigned NOT NULL DEFAULT '0', 1143 `gid` varchar(255) COLLATE utf8_bin NOT NULL, 1144 PRIMARY KEY (`gid`,`systemtagid`) 1145 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; 1146 /*!40101 SET character_set_client = @saved_cs_client */; 1147 1148 -- 1149 -- Dumping data for table `oc_systemtag_group` 1150 -- 1151 1152 LOCK TABLES `oc_systemtag_group` WRITE; 1153 /*!40000 ALTER TABLE `oc_systemtag_group` DISABLE KEYS */; 1154 /*!40000 ALTER TABLE `oc_systemtag_group` ENABLE KEYS */; 1075 1155 UNLOCK TABLES; 1076 1156 … … 1215 1295 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; 1216 1296 1217 -- Dump completed on 201 6-05-05 11:19:261297 -- Dump completed on 2017-01-10 13:31:04
Note: See TracChangeset
for help on using the changeset viewer.
