Changeset 3228 for lliurex-owncloud


Ignore:
Timestamp:
Jan 10, 2017, 5:47:17 PM (3 years ago)
Author:
jrpelegrina
Message:

Wip in new version of owncloud_9.1.3

Location:
lliurex-owncloud/trunk/fuentes/install-files
Files:
1 added
1 deleted
4 edited

Legend:

Unmodified
Added
Removed
  • lliurex-owncloud/trunk/fuentes/install-files/etc/apache2/conf-available/owncloud.conf

    r1415 r3228  
    1 # Version:9.0.1.3
    2 # Version: 9.0.1.3
    31<IfModule mod_headers.c>
    42  <IfModule mod_setenvif.c>
     
    5957  RewriteRule ^\.well-known/caldav /remote.php/dav/ [R=301,L]
    6058  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]
    6260  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]
    8162</IfModule>
    8263<IfModule mod_mime.c>
     
    9273  ModPagespeed Off
    9374</IfModule>
    94 
  • lliurex-owncloud/trunk/fuentes/install-files/usr/share/lliurex-owncloud/llx-data/.htaccess

    r1415 r3228  
    1 # Version: 9.0.1.3
    21<IfModule mod_headers.c>
    32  <IfModule mod_setenvif.c>
     
    5857  RewriteRule ^\.well-known/caldav /remote.php/dav/ [R=301,L]
    5958  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]
    6160  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]
    8062</IfModule>
    8163<IfModule mod_mime.c>
  • lliurex-owncloud/trunk/fuentes/install-files/usr/share/lliurex-owncloud/llx-data/config/config.php

    r1422 r3228  
    1515  'overwrite.cli.url' => 'http://{{ SRV_IP }}/owncloud',
    1616  'dbtype' => 'mysql',
    17   'version' => '9.0.1.3',
     17  'version' => '9.1.3.1',
    1818  'dbname' => '{{ DB_NAME }}',
    1919  '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.12, for Linux (i686)
     1-- MySQL dump 10.13  Distrib 5.7.15, for Linux (x86_64)
    22--
    33-- Host: localhost    Database: owncloud
    44-- ------------------------------------------------------
    5 -- Server version       5.7.12-0ubuntu1
     5-- Server version       5.7.15-0ubuntu0.16.04.1
    66
    77/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
     
    4343  KEY `activity_user_time` (`affecteduser`,`timestamp`),
    4444  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`)
    4647) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
    4748/*!40101 SET character_set_client = @saved_cs_client */;
     
    103104  PRIMARY KEY (`id`),
    104105  KEY `addressbookid_synctoken` (`addressbookid`,`synctoken`)
    105 ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
     106) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
    106107/*!40101 SET character_set_client = @saved_cs_client */;
    107108
     
    112113LOCK TABLES `oc_addressbookchanges` WRITE;
    113114/*!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);
    115115/*!40000 ALTER TABLE `oc_addressbookchanges` ENABLE KEYS */;
    116116UNLOCK TABLES;
     
    141141LOCK TABLES `oc_addressbooks` WRITE;
    142142/*!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);
    144143/*!40000 ALTER TABLE `oc_addressbooks` ENABLE KEYS */;
    145144UNLOCK TABLES;
     
    168167LOCK TABLES `oc_appconfig` WRITE;
    169168/*!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');
     169INSERT INTO `oc_appconfig` VALUES ('activity','enabled','yes'),('activity','installed_version','2.3.2'),('activity','types','filesystem'),('backgroundjob','lastjob','12'),('comments','enabled','yes'),('comments','installed_version','0.3.0'),('comments','types','logging'),('core','installedat','1483963185.0056'),('core','lastcron','1484051001'),('core','lastupdateResult','[]'),('core','lastupdatedat','1484035499'),('core','oc.integritycheck.checker','[]'),('core','public_files','files_sharing/public.php'),('core','public_webdav','dav/appinfo/v1/publicwebdav.php'),('dav','enabled','yes'),('dav','installed_version','0.2.7'),('dav','types','filesystem'),('federatedfilesharing','enabled','yes'),('federatedfilesharing','installed_version','0.3.0'),('federatedfilesharing','types',''),('federation','enabled','yes'),('federation','installed_version','0.1.0'),('federation','types','authentication'),('files','cronjob_scan_files','500'),('files','enabled','yes'),('files','installed_version','1.5.1'),('files','types','filesystem'),('files_pdfviewer','enabled','yes'),('files_pdfviewer','installed_version','0.8.1'),('files_pdfviewer','ocsid','166049'),('files_pdfviewer','types',''),('files_sharing','enabled','yes'),('files_sharing','installed_version','0.10.0'),('files_sharing','types','filesystem'),('files_texteditor','enabled','yes'),('files_texteditor','installed_version','2.1'),('files_texteditor','ocsid','166051'),('files_texteditor','types',''),('files_trashbin','enabled','yes'),('files_trashbin','installed_version','0.9.0'),('files_trashbin','types','filesystem'),('files_versions','enabled','yes'),('files_versions','installed_version','1.3.0'),('files_versions','types','filesystem'),('files_videoplayer','enabled','yes'),('files_videoplayer','installed_version','0.9.8'),('files_videoplayer','types',''),('firstrunwizard','enabled','yes'),('firstrunwizard','installed_version','1.1'),('firstrunwizard','ocsid','166055'),('firstrunwizard','types',''),('gallery','enabled','yes'),('gallery','installed_version','15.0.0'),('gallery','types',''),('notifications','enabled','yes'),('notifications','installed_version','0.3.0'),('notifications','types','logging'),('provisioning_api','enabled','yes'),('provisioning_api','installed_version','0.5.0'),('provisioning_api','types','prevent_group_restriction'),('systemtags','enabled','yes'),('systemtags','installed_version','0.3.0'),('systemtags','types','logging'),('templateeditor','enabled','yes'),('templateeditor','installed_version','0.1'),('templateeditor','types',''),('updatenotification','enabled','yes'),('updatenotification','installed_version','0.2.1'),('updatenotification','types',''),('user_ldap','enabled','yes'),('user_ldap','has_memberof_filter_support',''),('user_ldap','home_folder_naming_rule',''),('user_ldap','installed_version','0.9.0'),('user_ldap','last_jpegPhoto_lookup','0'),('user_ldap','ldap_agent_password',''),('user_ldap','ldap_attributes_for_group_search',''),('user_ldap','ldap_attributes_for_user_search',''),('user_ldap','ldap_backup_host',''),('user_ldap','ldap_backup_port',''),('user_ldap','ldap_base','{{LDAP_BASE_USER_TREE}}'),('user_ldap','ldap_base_groups','{{LDAP_BASE_GROUP_TREE}}'),('user_ldap','ldap_base_users','{{LDAP_BASE_USER_TREE}}'),('user_ldap','ldap_cache_ttl','600'),('user_ldap','ldap_configuration_active','1'),('user_ldap','ldap_display_name','cn'),('user_ldap','ldap_dn',''),('user_ldap','ldap_dynamic_group_member_url',''),('user_ldap','ldap_email_attr',''),('user_ldap','ldap_experienced_admin','0'),('user_ldap','ldap_expert_username_attr',''),('user_ldap','ldap_expert_uuid_group_attr','cn'),('user_ldap','ldap_expert_uuid_user_attr','uid'),('user_ldap','ldap_group_display_name','cn'),('user_ldap','ldap_group_filter','(objectclass=x-lliurex-group)'),('user_ldap','ldap_group_filter_mode','1'),('user_ldap','ldap_group_member_assoc_attribute','memberUid'),('user_ldap','ldap_groupfilter_groups',''),('user_ldap','ldap_groupfilter_objectclass',''),('user_ldap','ldap_host','ldap://localhost'),('user_ldap','ldap_login_filter','(&(|(objectclass=person))(uid=%uid))'),('user_ldap','ldap_login_filter_mode','0'),('user_ldap','ldap_loginfilter_attributes',''),('user_ldap','ldap_loginfilter_email','0'),('user_ldap','ldap_loginfilter_username','1'),('user_ldap','ldap_nested_groups','0'),('user_ldap','ldap_override_main_server',''),('user_ldap','ldap_paging_size','500'),('user_ldap','ldap_port','389'),('user_ldap','ldap_quota_attr',''),('user_ldap','ldap_quota_def',''),('user_ldap','ldap_tls','1'),('user_ldap','ldap_turn_off_cert_check','0'),('user_ldap','ldap_user_display_name_2',''),('user_ldap','ldap_user_filter_mode','1'),('user_ldap','ldap_userfilter_groups',''),('user_ldap','ldap_userfilter_objectclass','posixAccount'),('user_ldap','ldap_userlist_filter','(objectclass=*)'),('user_ldap','types','authentication'),('user_ldap','use_memberof_to_detect_membership','1');
    171170/*!40000 ALTER TABLE `oc_appconfig` ENABLE KEYS */;
     171UNLOCK TABLES;
     172
     173--
     174-- Table structure for table `oc_authtoken`
     175--
     176
     177DROP TABLE IF EXISTS `oc_authtoken`;
     178/*!40101 SET @saved_cs_client     = @@character_set_client */;
     179/*!40101 SET character_set_client = utf8 */;
     180CREATE TABLE `oc_authtoken` (
     181  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
     182  `uid` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
     183  `login_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
     184  `password` longtext COLLATE utf8_bin,
     185  `name` longtext COLLATE utf8_bin NOT NULL,
     186  `token` varchar(200) COLLATE utf8_bin NOT NULL DEFAULT '',
     187  `type` smallint(5) unsigned NOT NULL DEFAULT '0',
     188  `last_activity` int(10) unsigned NOT NULL DEFAULT '0',
     189  `last_check` int(10) unsigned NOT NULL DEFAULT '0',
     190  PRIMARY KEY (`id`),
     191  UNIQUE KEY `authtoken_token_index` (`token`),
     192  KEY `authtoken_last_activity_index` (`last_activity`)
     193) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
     194/*!40101 SET character_set_client = @saved_cs_client */;
     195
     196--
     197-- Dumping data for table `oc_authtoken`
     198--
     199
     200LOCK TABLES `oc_authtoken` WRITE;
     201/*!40000 ALTER TABLE `oc_authtoken` DISABLE KEYS */;
     202INSERT INTO `oc_authtoken` VALUES (1,'owncloud_admin','owncloud_admin','f5a6c14174072369af3e8c508407ad91|kv8NaZIuBwy/o6pv|f2a146fc8d205efc99649af3f297f078f30af0e95348588c2ec0fd3173ae5c9fb1f2b7b725793631e9b6e6951ed03ae9650f42620577ec942f55d2a87b021378','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:49.0) Gecko/20100101 Firefox/49.0','36c07888d583371a3e38c98406d0cc007446b241ff914ee011dfb504a6f6fdb4c13d5a72aee4e92e79bab66e238f1fdc3f19d030c46532c884219b875e74fc78',0,1483963362,1483963195),(3,'owncloud_admin','owncloud_admin','035261d6f12473e525d5c270df452d75|K652fuQ7DwrvULDL|ee76cc2fae49297babb25c713097bef5565aa8a429d4d80902c56bbefb2bbd38b5cdc6890fae0bac4b8c0a2eb7fe6839a823e6e72e1a5de50fffb3c59baa1512','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:48.0) Gecko/20100101 Firefox/48.0','84707555a9511e8fb309e011d9a619a8d8755acd95dde098b08bd2c6c5119f19cf785b14f217515e910e30f9ea3c743366a5872106c5c7925e3207477740070e',0,1484051451,1484051181);
     203/*!40000 ALTER TABLE `oc_authtoken` ENABLE KEYS */;
    172204UNLOCK TABLES;
    173205
     
    214246  `etag` varchar(32) COLLATE utf8_bin DEFAULT NULL,
    215247  `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,
    219251  `uid` varchar(255) COLLATE utf8_bin DEFAULT NULL,
     252  `classification` int(11) DEFAULT '0' COMMENT '0 - public, 1 - private, 2 - confidential',
    220253  PRIMARY KEY (`id`),
    221254  UNIQUE KEY `calobjects_index` (`calendarid`,`uri`)
     
    249282  `calendarcolor` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    250283  `timezone` longtext COLLATE utf8_bin,
    251   `components` varchar(255) COLLATE utf8_bin DEFAULT NULL,
     284  `components` varchar(20) COLLATE utf8_bin DEFAULT NULL,
    252285  `transparent` smallint(6) NOT NULL DEFAULT '0',
    253286  PRIMARY KEY (`id`),
     
    262295LOCK TABLES `oc_calendars` WRITE;
    263296/*!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);
    265297/*!40000 ALTER TABLE `oc_calendars` ENABLE KEYS */;
    266298UNLOCK TABLES;
     
    316348  `size` bigint(20) unsigned NOT NULL,
    317349  PRIMARY KEY (`id`)
    318 ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
     350) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
    319351/*!40101 SET character_set_client = @saved_cs_client */;
    320352
     
    346378  KEY `card_name_index` (`name`),
    347379  KEY `card_value_index` (`value`)
    348 ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
     380) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
    349381/*!40101 SET character_set_client = @saved_cs_client */;
    350382
     
    474506
    475507--
     508-- Table structure for table `oc_federated_reshares`
     509--
     510
     511DROP TABLE IF EXISTS `oc_federated_reshares`;
     512/*!40101 SET @saved_cs_client     = @@character_set_client */;
     513/*!40101 SET character_set_client = utf8 */;
     514CREATE TABLE `oc_federated_reshares` (
     515  `share_id` int(11) NOT NULL,
     516  `remote_id` int(11) NOT NULL COMMENT 'share ID at the remote server',
     517  UNIQUE KEY `share_id_index` (`share_id`)
     518) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
     519/*!40101 SET character_set_client = @saved_cs_client */;
     520
     521--
     522-- Dumping data for table `oc_federated_reshares`
     523--
     524
     525LOCK TABLES `oc_federated_reshares` WRITE;
     526/*!40000 ALTER TABLE `oc_federated_reshares` DISABLE KEYS */;
     527/*!40000 ALTER TABLE `oc_federated_reshares` ENABLE KEYS */;
     528UNLOCK TABLES;
     529
     530--
    476531-- Table structure for table `oc_file_locks`
    477532--
     
    488543  UNIQUE KEY `lock_key_index` (`key`),
    489544  KEY `lock_ttl_index` (`ttl`)
    490 ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
     545) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
    491546/*!40101 SET character_set_client = @saved_cs_client */;
    492547
     
    497552LOCK TABLES `oc_file_locks` WRITE;
    498553/*!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);
     554INSERT INTO `oc_file_locks` VALUES (5,0,'files/61ed1f9a7383795ed88817d445e1546b',1484039136),(6,0,'files/c31e581b3c2ec56f9b7b1dca2421b72e',1484039136),(7,0,'files/ef90c82ae6bd9d9a22ee5b7c93d77ca7',1484039136),(8,0,'files/cb6b4c11e5e5642185bd52f5896a8bf8',1484038979);
    500555/*!40000 ALTER TABLE `oc_file_locks` ENABLE KEYS */;
    501556UNLOCK TABLES;
     
    540595LOCK TABLES `oc_filecache` WRITE;
    541596/*!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);
     597INSERT INTO `oc_filecache` VALUES (1,1,'','d41d8cd98f00b204e9800998ecf8427e',-1,'',2,1,4770198,1483963185,1483963185,0,0,'58737b31ddc9d',23,''),(2,1,'files','45b963397aa40d4a0063e0d85e4fe7a1',1,'files',2,1,4770198,1483963185,1483963185,0,0,'58737b31dab71',31,''),(3,1,'files/Photos','d01bb67e7b71dd49fd06bad922f521c9',2,'Photos',2,1,678556,1483963185,1483963185,0,0,'58737b319c3eb',31,''),(4,1,'files/Photos/San Francisco.jpg','9fc714efbeaafee22f7058e73d2b1c3b',3,'San Francisco.jpg',4,3,216071,1483963185,1483963185,0,0,'b22ee08e8a5360dc896a9f105356ca34',27,''),(5,1,'files/Photos/Squirrel.jpg','de85d1da71bcd6232ad893f959063b8c',3,'Squirrel.jpg',4,3,233724,1483963185,1483963185,0,0,'722332dbf123f5cd39de6299a54f7d33',27,''),(6,1,'files/Photos/Paris.jpg','a208ddedf08367bbc56963107248dda5',3,'Paris.jpg',4,3,228761,1483963185,1483963185,0,0,'89813fb83bfb35397c4547d638a5b09d',27,''),(7,1,'files/Documents','0ad78ba05b6961d92f7970b2b3922eca',2,'Documents',2,1,36227,1483963185,1483963185,0,0,'58737b31c2efd',31,''),(8,1,'files/Documents/Example.odt','c89c560541b952a435783a7d51a27d50',7,'Example.odt',6,5,36227,1483963185,1483963185,0,0,'7caf14fb4fa10e71a9f19aec00e8b760',27,''),(9,1,'files/ownCloud Manual.pdf','a73aa0f95f162297bbb7ffa3fb5ad709',2,'ownCloud Manual.pdf',7,5,4055415,1483963185,1483963185,0,0,'ebb8e17b20848fa991a805b5a99c1f6c',27,''),(10,2,'','d41d8cd98f00b204e9800998ecf8427e',-1,'',2,1,-1,1484035379,1484035379,0,0,'58749533089cf',23,''),(11,2,'files_external','c270928b685e7946199afdfb898d27ea',10,'files_external',2,1,0,1484035379,1484035379,0,0,'5874953306aa6',31,'');
    543598/*!40000 ALTER TABLE `oc_filecache` ENABLE KEYS */;
    544599UNLOCK TABLES;
     
    659714  `argument` varchar(4000) COLLATE utf8_bin NOT NULL DEFAULT '',
    660715  `last_run` int(11) DEFAULT '0',
     716  `last_checked` int(11) DEFAULT '0',
     717  `reserved_at` int(11) DEFAULT '0',
    661718  PRIMARY KEY (`id`),
    662719  KEY `job_class_index` (`class`)
    663 ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
     720) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
    664721/*!40101 SET character_set_client = @saved_cs_client */;
    665722
     
    670727LOCK TABLES `oc_jobs` WRITE;
    671728/*!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);
     729INSERT INTO `oc_jobs` VALUES (1,'OCA\\Files\\BackgroundJob\\ScanFiles','null',1483963198,1483963198,0),(2,'OCA\\Files\\BackgroundJob\\DeleteOrphanedItems','null',1483963212,1483963212,0),(3,'OCA\\Files\\BackgroundJob\\CleanupFileLocks','null',1484035352,1484035351,0),(4,'OCA\\Federation\\SyncJob','null',1484035362,1484035362,0),(5,'OCA\\Files_Trashbin\\BackgroundJob\\ExpireTrash','null',1484035378,1484035378,0),(6,'OCA\\UpdateNotification\\Notification\\BackgroundJob','null',1484035499,1484035499,0),(7,'OCA\\Files_Versions\\BackgroundJob\\ExpireVersions','null',1484035517,1484035517,0),(8,'OCA\\DAV\\CardDAV\\SyncJob','null',1484035535,1484035535,0),(9,'OCA\\Files_Sharing\\DeleteOrphanedSharesJob','null',1484044841,1484044841,0),(10,'OCA\\Files_Sharing\\ExpireSharesJob','null',1484044865,1484044865,0),(11,'OCA\\Activity\\BackgroundJob\\EmailNotification','null',1484047644,1484047644,0),(12,'OCA\\Activity\\BackgroundJob\\ExpireActivities','null',1484051001,1484051001,0),(13,'\\OC\\Authentication\\Token\\DefaultTokenCleanupJob','null',0,1483963186,0),(14,'OCA\\User_LDAP\\Jobs\\UpdateGroups','null',0,1484050995,0),(15,'OCA\\User_LDAP\\Jobs\\CleanUp','null',0,1484050995,0);
    673730/*!40000 ALTER TABLE `oc_jobs` ENABLE KEYS */;
    674731UNLOCK TABLES;
     
    759816  PRIMARY KEY (`id`),
    760817  UNIQUE KEY `mimetype_id_index` (`mimetype`)
    761 ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
     818) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
    762819/*!40101 SET character_set_client = @saved_cs_client */;
    763820
     
    768825LOCK TABLES `oc_mimetypes` WRITE;
    769826/*!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');
     827INSERT INTO `oc_mimetypes` VALUES (5,'application'),(7,'application/pdf'),(6,'application/vnd.oasis.opendocument.text'),(1,'httpd'),(2,'httpd/unix-directory'),(3,'image'),(4,'image/jpeg');
    771828/*!40000 ALTER TABLE `oc_mimetypes` ENABLE KEYS */;
    772829UNLOCK TABLES;
     
    799856LOCK TABLES `oc_mounts` WRITE;
    800857/*!40000 ALTER TABLE `oc_mounts` DISABLE KEYS */;
     858INSERT INTO `oc_mounts` VALUES (1,1,1,'owncloud_admin','/owncloud_admin/');
    801859/*!40000 ALTER TABLE `oc_mounts` ENABLE KEYS */;
    802860UNLOCK TABLES;
     
    863921INSERT INTO `oc_preferences` VALUES  ('{{ ADMIN_USER }}','core','lang','es'),('{{ ADMIN_USER }}','firstrunwizard','show','0');
    864922/*!40000 ALTER TABLE `oc_preferences` ENABLE KEYS */;
    865 /*!40000 ALTER TABLE `oc_preferences` ENABLE KEYS */;
    866923UNLOCK TABLES;
    867924
     
    10361093  PRIMARY KEY (`numeric_id`),
    10371094  UNIQUE KEY `storages_id_index` (`id`)
    1038 ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
     1095) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
    10391096/*!40101 SET character_set_client = @saved_cs_client */;
    10401097
     
    10731130/*!40000 ALTER TABLE `oc_systemtag` DISABLE KEYS */;
    10741131/*!40000 ALTER TABLE `oc_systemtag` ENABLE KEYS */;
     1132UNLOCK TABLES;
     1133
     1134--
     1135-- Table structure for table `oc_systemtag_group`
     1136--
     1137
     1138DROP TABLE IF EXISTS `oc_systemtag_group`;
     1139/*!40101 SET @saved_cs_client     = @@character_set_client */;
     1140/*!40101 SET character_set_client = utf8 */;
     1141CREATE TABLE `oc_systemtag_group` (
     1142  `systemtagid` int(10) unsigned NOT NULL DEFAULT '0',
     1143  `gid` varchar(255) COLLATE utf8_bin NOT NULL,
     1144  PRIMARY KEY (`gid`,`systemtagid`)
     1145) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
     1146/*!40101 SET character_set_client = @saved_cs_client */;
     1147
     1148--
     1149-- Dumping data for table `oc_systemtag_group`
     1150--
     1151
     1152LOCK TABLES `oc_systemtag_group` WRITE;
     1153/*!40000 ALTER TABLE `oc_systemtag_group` DISABLE KEYS */;
     1154/*!40000 ALTER TABLE `oc_systemtag_group` ENABLE KEYS */;
    10751155UNLOCK TABLES;
    10761156
     
    12151295/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
    12161296
    1217 -- Dump completed on 2016-05-05 11:19:26
     1297-- Dump completed on 2017-01-10 13:31:04
Note: See TracChangeset for help on using the changeset viewer.