Changeset 1391


Ignore:
Timestamp:
May 5, 2016, 1:11:53 PM (3 years ago)
Author:
jrpelegrina
Message:

Wip in update to owncloud 9

Location:
lliurex-owncloud/trunk/fuentes
Files:
1 added
2 deleted
9 edited

Legend:

Unmodified
Added
Removed
  • lliurex-owncloud/trunk/fuentes/debian/control

    r545 r1391  
    99Package: lliurex-owncloud
    1010Architecture: all
    11 Depends: ${shlibs:Depends}, ${misc:Depends}, n4d, python-bcrypt, owncloud-server, python-llxnet, llxcfg-runtime
     11Depends: ${shlibs:Depends}, ${misc:Depends}, n4d, python-bcrypt, owncloud, python-llxnet, llxcfg-runtime
    1212Description: Owncloud lliurex configuration
    1313 Scripts and n4d plugins to initialize owncloud
  • lliurex-owncloud/trunk/fuentes/install-files/etc/apache2/conf-available/owncloud.conf

    r544 r1391  
    1 <Directory /var/www/owncloud>
     1# Version:9.0.1.3
     2<IfModule mod_headers.c>
     3  <IfModule mod_setenvif.c>
     4    <IfModule mod_fcgid.c>
     5       SetEnvIfNoCase ^Authorization$ "(.+)" XAUTHORIZATION=$1
     6       RequestHeader set XAuthorization %{XAUTHORIZATION}e env=XAUTHORIZATION
     7    </IfModule>
     8    <IfModule mod_proxy_fcgi.c>
     9       SetEnvIfNoCase Authorization "(.+)" HTTP_AUTHORIZATION=$1
     10    </IfModule>
     11  </IfModule>
    212
    3 # Version: 8.0.1
    4 <IfModule mod_fcgid.c>
    5 <IfModule mod_setenvif.c>
    6 <IfModule mod_headers.c>
    7 SetEnvIfNoCase ^Authorization$ "(.+)" XAUTHORIZATION=$1
    8 RequestHeader set XAuthorization %{XAUTHORIZATION}e env=XAUTHORIZATION
    9 </IfModule>
    10 </IfModule>
     13  <IfModule mod_env.c>
     14    # Add security and privacy related headers
     15    Header set X-Content-Type-Options "nosniff"
     16    Header set X-XSS-Protection "1; mode=block"
     17    Header set X-Robots-Tag "none"
     18    Header set X-Frame-Options "SAMEORIGIN"
     19    Header set X-Download-Options "noopen"
     20    Header set X-Permitted-Cross-Domain-Policies "none"
     21    SetEnv modHeadersAvailable true
     22  </IfModule>
     23
     24  # Add cache control for CSS and JS files
     25  <FilesMatch "\.(css|js)$">
     26    Header set Cache-Control "max-age=7200, public"
     27  </FilesMatch>
    1128</IfModule>
    1229<IfModule mod_php5.c>
    13 php_value upload_max_filesize 513M
    14 php_value post_max_size 513M
    15 php_value memory_limit 512M
    16 php_value mbstring.func_overload 0
    17 php_value always_populate_raw_post_data -1
    18 AddDefaultCharset UTF-8
    19 php_value default_charset UTF-8
    20 <IfModule mod_env.c>
    21   SetEnv htaccessWorking true
     30  php_value upload_max_filesize 513M
     31  php_value post_max_size 513M
     32  php_value memory_limit 512M
     33  php_value mbstring.func_overload 0
     34  php_value always_populate_raw_post_data -1
     35  php_value default_charset 'UTF-8'
     36  php_value output_buffering 0
     37  <IfModule mod_env.c>
     38    SetEnv htaccessWorking true
     39  </IfModule>
    2240</IfModule>
     41<IfModule mod_php7.c>
     42  php_value upload_max_filesize 513M
     43  php_value post_max_size 513M
     44  php_value memory_limit 512M
     45  php_value mbstring.func_overload 0
     46  php_value default_charset 'UTF-8'
     47  php_value output_buffering 0
     48  <IfModule mod_env.c>
     49    SetEnv htaccessWorking true
     50  </IfModule>
    2351</IfModule>
    2452<IfModule mod_rewrite.c>
    25 RewriteEngine on
    26 RewriteRule .* - [env=HTTP_AUTHORIZATION:%{HTTP:Authorization}]
    27 RewriteRule ^\.well-known/host-meta /public.php?service=host-meta [QSA,L]
    28 RewriteRule ^\.well-known/host-meta\.json /public.php?service=host-meta-json [QSA,L]
    29 RewriteRule ^\.well-known/carddav /remote.php/carddav/ [R]
    30 RewriteRule ^\.well-known/caldav /remote.php/caldav/ [R]
    31 RewriteRule ^apps/calendar/caldav\.php remote.php/caldav/ [QSA,L]
    32 RewriteRule ^apps/contacts/carddav\.php remote.php/carddav/ [QSA,L]
    33 RewriteRule ^remote/(.*) remote.php [QSA,L]
    34 RewriteRule ^(build|tests|config|lib|3rdparty|templates)/.* - [R=404,L]
    35 RewriteRule ^(\.|autotest|occ|issue|indie|db_|console).* - [R=404,L]
     53  RewriteEngine on
     54  RewriteRule .* - [env=HTTP_AUTHORIZATION:%{HTTP:Authorization}]
     55  RewriteRule ^\.well-known/host-meta /public.php?service=host-meta [QSA,L]
     56  RewriteRule ^\.well-known/host-meta\.json /public.php?service=host-meta-json [QSA,L]
     57  RewriteRule ^\.well-known/carddav /remote.php/dav/ [R=301,L]
     58  RewriteRule ^\.well-known/caldav /remote.php/dav/ [R=301,L]
     59  RewriteRule ^remote/(.*) remote.php [QSA,L]
     60  RewriteRule ^(build|tests|config|lib|3rdparty|templates)/.* - [R=404,L]
     61  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/.*
    3680</IfModule>
    3781<IfModule mod_mime.c>
    38 AddType image/svg+xml svg svgz
    39 AddEncoding gzip svgz
     82  AddType image/svg+xml svg svgz
     83  AddEncoding gzip svgz
    4084</IfModule>
    4185<IfModule mod_dir.c>
    42 DirectoryIndex index.php index.html
     86  DirectoryIndex index.php index.html
    4387</IfModule>
    4488AddDefaultCharset utf-8
    4589Options -Indexes
    4690<IfModule pagespeed_module>
    47         ModPagespeed Off
     91  ModPagespeed Off
    4892</IfModule>
    49 <IfModule mod_headers.c>
    50   <FilesMatch "\.(css|js)$">
    51     Header set Cache-Control "max-age=7200, public"
    52   </FilesMatch>
     93#### DO NOT CHANGE ANYTHING ABOVE THIS LINE ####
     94
     95ErrorDocument 403 /owncloud/core/templates/403.php
     96ErrorDocument 404 /owncloud/core/templates/404.php
     97<IfModule mod_rewrite.c>
     98  RewriteRule . index.php [PT,E=PATH_INFO:$1]
     99  RewriteBase /owncloud
     100  <IfModule mod_env.c>
     101    SetEnv front_controller_active true
     102    <IfModule mod_dir.c>
     103      DirectorySlash off
     104    </IfModule>
     105  </IfModule>
    53106</IfModule>
    54 
    55 
    56 
    57 
    58 
    59 </Directory>
    60 
  • lliurex-owncloud/trunk/fuentes/install-files/etc/apache2/sites-available/owncloud.conf

    r544 r1391  
    1 <virtualHost *:80>
    2         ServerName owncloud
    3         ServerAlias owncloud
     1<VirtualHost *:80>
     2        ServerName owncloud             
     3        ServerAdmin owcloud
    44        DocumentRoot /var/www/owncloud/
    5 </virtualHost>
    65
    7 <VirtualHost *:443>
    8         ServerName owncloud
    9         ServerAlias owncloud
    10         DocumentRoot /var/www/owncloud/
    11 
    12         SSLEngine on
    13         SSLCertificateFile /etc/n4d/cert/n4dcert.pem
    14         SSLCertificateKeyFile /etc/n4d/cert/n4dkey.pem
     6        <Directory /var/www/onwcloud>
     7                Options Indexes FollowSymLinks MultiViews
     8                AllowOverride None
     9                Order allow,deny
     10                allow from all
     11        </Directory>
     12       
     13        ErrorLog ${APACHE_LOG_DIR}/error.log
     14        LogLevel warn
     15        CustomLog ${APACHE_LOG_DIR}/access.log combined
     16        ServerSignature Off
    1517</VirtualHost>
    1618
     19
     20<IfModule mod_ssl.c>
     21        <VirtualHost _default_:443>
     22                ServerAdmin owncloud
     23                DocumentRoot /var/www/owncloud/
     24               
     25                ErrorLog ${APACHE_LOG_DIR}/error.log
     26                CustomLog ${APACHE_LOG_DIR}/access.log combined
     27               
     28                SSLEngine on
     29                SSLCertificateFile /etc/n4d/cert/n4dcert.pem
     30                SSLCertificateKeyFile /etc/n4d/cert/n4dkey.pem
     31               
     32        </VirtualHost>
     33</IfModule>
  • lliurex-owncloud/trunk/fuentes/install-files/usr/share/lliurex-owncloud/llx-data/.htaccess

    r544 r1391  
    1 # Version: 8.0.1
    2 <IfModule mod_fcgid.c>
    3 <IfModule mod_setenvif.c>
     1# Version:9.0.1.3
    42<IfModule mod_headers.c>
    5 SetEnvIfNoCase ^Authorization$ "(.+)" XAUTHORIZATION=$1
    6 RequestHeader set XAuthorization %{XAUTHORIZATION}e env=XAUTHORIZATION
    7 </IfModule>
    8 </IfModule>
     3  <IfModule mod_setenvif.c>
     4    <IfModule mod_fcgid.c>
     5       SetEnvIfNoCase ^Authorization$ "(.+)" XAUTHORIZATION=$1
     6       RequestHeader set XAuthorization %{XAUTHORIZATION}e env=XAUTHORIZATION
     7    </IfModule>
     8    <IfModule mod_proxy_fcgi.c>
     9       SetEnvIfNoCase Authorization "(.+)" HTTP_AUTHORIZATION=$1
     10    </IfModule>
     11  </IfModule>
     12
     13  <IfModule mod_env.c>
     14    # Add security and privacy related headers
     15    Header set X-Content-Type-Options "nosniff"
     16    Header set X-XSS-Protection "1; mode=block"
     17    Header set X-Robots-Tag "none"
     18    Header set X-Frame-Options "SAMEORIGIN"
     19    Header set X-Download-Options "noopen"
     20    Header set X-Permitted-Cross-Domain-Policies "none"
     21    SetEnv modHeadersAvailable true
     22  </IfModule>
     23
     24  # Add cache control for CSS and JS files
     25  <FilesMatch "\.(css|js)$">
     26    Header set Cache-Control "max-age=7200, public"
     27  </FilesMatch>
    928</IfModule>
    1029<IfModule mod_php5.c>
    11 php_value upload_max_filesize 513M
    12 php_value post_max_size 513M
    13 php_value memory_limit 512M
    14 php_value mbstring.func_overload 0
    15 php_value always_populate_raw_post_data -1
    16 php_value default_charset UTF-8
    17 <IfModule mod_env.c>
    18   SetEnv htaccessWorking true
     30  php_value upload_max_filesize 513M
     31  php_value post_max_size 513M
     32  php_value memory_limit 512M
     33  php_value mbstring.func_overload 0
     34  php_value always_populate_raw_post_data -1
     35  php_value default_charset 'UTF-8'
     36  php_value output_buffering 0
     37  <IfModule mod_env.c>
     38    SetEnv htaccessWorking true
     39  </IfModule>
    1940</IfModule>
     41<IfModule mod_php7.c>
     42  php_value upload_max_filesize 513M
     43  php_value post_max_size 513M
     44  php_value memory_limit 512M
     45  php_value mbstring.func_overload 0
     46  php_value default_charset 'UTF-8'
     47  php_value output_buffering 0
     48  <IfModule mod_env.c>
     49    SetEnv htaccessWorking true
     50  </IfModule>
    2051</IfModule>
    2152<IfModule mod_rewrite.c>
    22 RewriteEngine on
    23 RewriteRule .* - [env=HTTP_AUTHORIZATION:%{HTTP:Authorization}]
    24 RewriteRule ^\.well-known/host-meta /public.php?service=host-meta [QSA,L]
    25 RewriteRule ^\.well-known/host-meta\.json /public.php?service=host-meta-json [QSA,L]
    26 RewriteRule ^\.well-known/carddav /remote.php/carddav/ [R]
    27 RewriteRule ^\.well-known/caldav /remote.php/caldav/ [R]
    28 RewriteRule ^apps/calendar/caldav\.php remote.php/caldav/ [QSA,L]
    29 RewriteRule ^apps/contacts/carddav\.php remote.php/carddav/ [QSA,L]
    30 RewriteRule ^remote/(.*) remote.php [QSA,L]
    31 RewriteRule ^(build|tests|config|lib|3rdparty|templates)/.* - [R=404,L]
    32 RewriteRule ^(\.|autotest|occ|issue|indie|db_|console).* - [R=404,L]
     53  RewriteEngine on
     54  RewriteRule .* - [env=HTTP_AUTHORIZATION:%{HTTP:Authorization}]
     55  RewriteRule ^\.well-known/host-meta /public.php?service=host-meta [QSA,L]
     56  RewriteRule ^\.well-known/host-meta\.json /public.php?service=host-meta-json [QSA,L]
     57  RewriteRule ^\.well-known/carddav /remote.php/dav/ [R=301,L]
     58  RewriteRule ^\.well-known/caldav /remote.php/dav/ [R=301,L]
     59  RewriteRule ^remote/(.*) remote.php [QSA,L]
     60  RewriteRule ^(build|tests|config|lib|3rdparty|templates)/.* - [R=404,L]
     61  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/.*
    3380</IfModule>
    3481<IfModule mod_mime.c>
    35 AddType image/svg+xml svg svgz
    36 AddEncoding gzip svgz
     82  AddType image/svg+xml svg svgz
     83  AddEncoding gzip svgz
    3784</IfModule>
    3885<IfModule mod_dir.c>
    39 DirectoryIndex index.php index.html
     86  DirectoryIndex index.php index.html
    4087</IfModule>
    4188AddDefaultCharset utf-8
    4289Options -Indexes
    4390<IfModule pagespeed_module>
    44         ModPagespeed Off
     91  ModPagespeed Off
    4592</IfModule>
    46 <IfModule mod_headers.c>
    47   <FilesMatch "\.(css|js)$">
    48     Header set Cache-Control "max-age=7200, public"
    49   </FilesMatch>
     93#### DO NOT CHANGE ANYTHING ABOVE THIS LINE ####
     94
     95ErrorDocument 403 /owncloud/core/templates/403.php
     96ErrorDocument 404 /owncloud/core/templates/404.php
     97<IfModule mod_rewrite.c>
     98  RewriteRule . index.php [PT,E=PATH_INFO:$1]
     99  RewriteBase /owncloud
     100  <IfModule mod_env.c>
     101    SetEnv front_controller_active true
     102    <IfModule mod_dir.c>
     103      DirectorySlash off
     104    </IfModule>
     105  </IfModule>
    50106</IfModule>
  • lliurex-owncloud/trunk/fuentes/install-files/usr/share/lliurex-owncloud/llx-data/config/config.php

    r544 r1391  
    11<?php
    22$CONFIG = array (
    3   'instanceid' => 'ocetdx0jt10m',
    4   'passwordsalt' => '0JGzYalsC3XUPKvGJVPV4yz.Fch2Lp',
    5   'secret' => 'V6PIJ14xj4nfgMIFo7H/oH4UAkFTlRYOTycJLzlxHPbQgBVw',
     3  'updatechecker' => false,
     4  'instanceid' => 'ocfe83h7c4o3',
     5  'passwordsalt' => 'EkA75m0VdzpnaxtY5mDJlJAMjC7t8D',
     6  'secret' => '6ETjicQdpc+xuGoPUAQBYvuBh/tydUxj9Jzx/vLJ5K9hJs1F',
    67  'trusted_domains' =>
    78  array (
     
    1415  'overwrite.cli.url' => 'http://{{ SRV_IP }}/owncloud',
    1516  'dbtype' => 'mysql',
    16   'version' => '8.0.2-8',
     17  'version' => '9.0.1.3',
    1718  'dbname' => '{{ DB_NAME }}',
    1819  'dbhost' => 'localhost',
  • lliurex-owncloud/trunk/fuentes/install-files/usr/share/lliurex-owncloud/llx-data/data/.htaccess

    r544 r1391  
    1 # Generated by ownCloud on 2015-03-06 08:06:26
     1# Generated by ownCloud on 2016-05-03 18:07:09
    22# line below if for Apache 2.4
    33<ifModule mod_authz_core.c>
     
    88<ifModule !mod_authz_core.c>
    99deny from all
     10Satisfy All
    1011</ifModule>
    1112
  • lliurex-owncloud/trunk/fuentes/install-files/usr/share/lliurex-owncloud/llx-data/data/owncloud.log

    r544 r1391  
     1{"reqId":"rKA6XazzkqyA1zH9x3cA","remoteAddr":"127.0.0.1","app":"mysql.setup","message":"Specific user creation failed: An exception occurred while executing 'SELECT user FROM mysql.user WHERE user=?' with params [\"oc_onwcloud_admi\"]:\n\nSQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user 'owncloud_user'@'localhost' for table 'user'","level":3,"time":"2016-05-03T17:59:37+00:00","method":"POST","url":"\/owncloud\/index.php","user":"--"}
     2{"reqId":"rKA6XazzkqyA1zH9x3cA","remoteAddr":"127.0.0.1","app":"mysql.setup","message":"Database creation failed: An exception occurred while executing 'CREATE DATABASE IF NOT EXISTS `owncloud` CHARACTER SET utf8 COLLATE utf8_bin;':\n\nSQLSTATE[42000]: Syntax error or access violation: 1044 Access denied for user 'owncloud_user'@'localhost' to database 'owncloud'","level":3,"time":"2016-05-03T17:59:37+00:00","method":"POST","url":"\/owncloud\/index.php","user":"--"}
     3{"reqId":"j33z6K2YbOtm0DtN3zhI","remoteAddr":"127.0.0.1","app":"mysql.setup","message":"Database creation failed: An exception occurred while executing 'CREATE DATABASE IF NOT EXISTS `owncloud` CHARACTER SET utf8 COLLATE utf8_bin;':\n\nSQLSTATE[42000]: Syntax error or access violation: 1044 Access denied for user 'owncloud_user'@'localhost' to database 'owncloud'","level":3,"time":"2016-05-03T18:00:49+00:00","method":"POST","url":"\/owncloud\/index.php","user":"--"}
     4{"reqId":"UR78SclRjsXcupMSxT7p","remoteAddr":"127.0.0.1","app":"mysql.setup","message":"Database creation failed: An exception occurred while executing 'GRANT ALL PRIVILEGES ON `owncloud` . * TO 'owncloud_user'':\n\nSQLSTATE[42000]: Syntax error or access violation: 1044 Access denied for user 'owncloud_user'@'localhost' to database 'owncloud'","level":3,"time":"2016-05-03T18:07:06+00:00","method":"POST","url":"\/owncloud\/index.php","user":"--"}
     5{"reqId":"UR78SclRjsXcupMSxT7p","remoteAddr":"127.0.0.1","app":"no app in context","message":"Exception: {\"Exception\":\"DomainException\",\"Message\":\"Contacts tables are missing. Nothing to do.\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/lib\\\/migration\\\/migrateaddressbooks.php(83): OCA\\\\Dav\\\\Migration\\\\AddressBookAdapter->setup()\\n#1 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/appinfo\\\/application.php(186): OCA\\\\Dav\\\\Migration\\\\MigrateAddressbooks->setup()\\n#2 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/appinfo\\\/install.php(26): OCA\\\\Dav\\\\AppInfo\\\\Application->migrateAddressbooks()\\n#3 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/installer.php(639): include('\\\/var\\\/www\\\/ownclo...')\\n#4 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/installer.php(590): OC_Installer::includeAppScript('\\\/var\\\/www\\\/ownclo...')\\n#5 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/installer.php(561): OC_Installer::installShippedApp('dav')\\n#6 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/setup.php(370): OC_Installer::installShippedApps()\\n#7 \\\/var\\\/www\\\/owncloud\\\/core\\\/controller\\\/setupcontroller.php(64): OC\\\\Setup->install(Array)\\n#8 \\\/var\\\/www\\\/owncloud\\\/lib\\\/base.php(832): OC\\\\Core\\\\Controller\\\\SetupController->run(Array)\\n#9 \\\/var\\\/www\\\/owncloud\\\/index.php(39): OC::handleRequest()\\n#10 {main}\",\"File\":\"\\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/lib\\\/migration\\\/addressbookadapter.php\",\"Line\":72}","level":3,"time":"2016-05-03T18:07:09+00:00","method":"POST","url":"\/owncloud\/index.php","user":"--"}
     6{"reqId":"UR78SclRjsXcupMSxT7p","remoteAddr":"127.0.0.1","app":"no app in context","message":"Exception: {\"Exception\":\"DomainException\",\"Message\":\"Calendar tables are missing. Nothing to do.\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/lib\\\/migration\\\/migratecalendars.php(84): OCA\\\\Dav\\\\Migration\\\\CalendarAdapter->setup()\\n#1 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/appinfo\\\/application.php(202): OCA\\\\Dav\\\\Migration\\\\MigrateCalendars->setup()\\n#2 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/appinfo\\\/install.php(27): OCA\\\\Dav\\\\AppInfo\\\\Application->migrateCalendars()\\n#3 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/installer.php(639): include('\\\/var\\\/www\\\/ownclo...')\\n#4 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/installer.php(590): OC_Installer::includeAppScript('\\\/var\\\/www\\\/ownclo...')\\n#5 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/installer.php(561): OC_Installer::installShippedApp('dav')\\n#6 \\\/var\\\/www\\\/owncloud\\\/lib\\\/private\\\/setup.php(370): OC_Installer::installShippedApps()\\n#7 \\\/var\\\/www\\\/owncloud\\\/core\\\/controller\\\/setupcontroller.php(64): OC\\\\Setup->install(Array)\\n#8 \\\/var\\\/www\\\/owncloud\\\/lib\\\/base.php(832): OC\\\\Core\\\\Controller\\\\SetupController->run(Array)\\n#9 \\\/var\\\/www\\\/owncloud\\\/index.php(39): OC::handleRequest()\\n#10 {main}\",\"File\":\"\\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/lib\\\/migration\\\/calendaradapter.php\",\"Line\":68}","level":3,"time":"2016-05-03T18:07:09+00:00","method":"POST","url":"\/owncloud\/index.php","user":"--"}
  • lliurex-owncloud/trunk/fuentes/install-files/usr/share/lliurex-owncloud/llx-data/owncloud.sql

    r544 r1391  
    1 -- MySQL dump 10.13  Distrib 5.5.41, for debian-linux-gnu (i686)
     1-- MySQL dump 10.13  Distrib 5.7.12, for Linux (i686)
    22--
    33-- Host: localhost    Database: owncloud
    44-- ------------------------------------------------------
    5 -- Server version       5.5.41-0ubuntu0.14.04.1
     5-- Server version       5.7.12-0ubuntu1
    66
    77/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
     
    2727  `timestamp` int(11) NOT NULL DEFAULT '0',
    2828  `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,
     29  `type` varchar(255) COLLATE utf8_bin DEFAULT NULL,
     30  `user` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    3131  `affecteduser` varchar(64) COLLATE utf8_bin NOT NULL,
    3232  `app` varchar(255) COLLATE utf8_bin NOT NULL,
    3333  `subject` varchar(255) COLLATE utf8_bin NOT NULL,
    34   `subjectparams` varchar(255) COLLATE utf8_bin NOT NULL,
     34  `subjectparams` varchar(4000) COLLATE utf8_bin NOT NULL,
    3535  `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,
     36  `messageparams` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
     37  `file` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
     38  `link` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
     39  `object_type` varchar(255) COLLATE utf8_bin DEFAULT NULL,
     40  `object_id` int(11) NOT NULL DEFAULT '0',
    3941  PRIMARY KEY (`activity_id`),
     42  KEY `activity_time` (`timestamp`),
    4043  KEY `activity_user_time` (`affecteduser`,`timestamp`),
    4144  KEY `activity_filter_by` (`affecteduser`,`user`,`timestamp`),
     
    6871  `amq_appid` varchar(255) COLLATE utf8_bin NOT NULL,
    6972  `amq_subject` varchar(255) COLLATE utf8_bin NOT NULL,
    70   `amq_subjectparams` varchar(255) COLLATE utf8_bin NOT NULL,
     73  `amq_subjectparams` varchar(4000) COLLATE utf8_bin NOT NULL,
    7174  PRIMARY KEY (`mail_id`),
    7275  KEY `amp_user` (`amq_affecteduser`),
     
    8386/*!40000 ALTER TABLE `oc_activity_mq` DISABLE KEYS */;
    8487/*!40000 ALTER TABLE `oc_activity_mq` ENABLE KEYS */;
     88UNLOCK TABLES;
     89
     90--
     91-- Table structure for table `oc_addressbookchanges`
     92--
     93
     94DROP TABLE IF EXISTS `oc_addressbookchanges`;
     95/*!40101 SET @saved_cs_client     = @@character_set_client */;
     96/*!40101 SET character_set_client = utf8 */;
     97CREATE TABLE `oc_addressbookchanges` (
     98  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
     99  `uri` varchar(255) COLLATE utf8_bin DEFAULT NULL,
     100  `synctoken` int(10) unsigned NOT NULL DEFAULT '1',
     101  `addressbookid` int(11) NOT NULL,
     102  `operation` smallint(6) NOT NULL,
     103  PRIMARY KEY (`id`),
     104  KEY `addressbookid_synctoken` (`addressbookid`,`synctoken`)
     105) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
     106/*!40101 SET character_set_client = @saved_cs_client */;
     107
     108--
     109-- Dumping data for table `oc_addressbookchanges`
     110--
     111
     112LOCK TABLES `oc_addressbookchanges` WRITE;
     113/*!40000 ALTER TABLE `oc_addressbookchanges` DISABLE KEYS */;
     114INSERT INTO `oc_addressbookchanges` VALUES (1,'Database:owncloud_admin.vcf',1,1,1),(2,'LDAP:aa5cff10-a590-1035-9744-679cd252e7a8.vcf',2,1,1);
     115/*!40000 ALTER TABLE `oc_addressbookchanges` ENABLE KEYS */;
     116UNLOCK TABLES;
     117
     118--
     119-- Table structure for table `oc_addressbooks`
     120--
     121
     122DROP TABLE IF EXISTS `oc_addressbooks`;
     123/*!40101 SET @saved_cs_client     = @@character_set_client */;
     124/*!40101 SET character_set_client = utf8 */;
     125CREATE TABLE `oc_addressbooks` (
     126  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
     127  `principaluri` varchar(255) COLLATE utf8_bin DEFAULT NULL,
     128  `displayname` varchar(255) COLLATE utf8_bin DEFAULT NULL,
     129  `uri` varchar(255) COLLATE utf8_bin DEFAULT NULL,
     130  `description` varchar(255) COLLATE utf8_bin DEFAULT NULL,
     131  `synctoken` int(10) unsigned NOT NULL DEFAULT '1',
     132  PRIMARY KEY (`id`),
     133  UNIQUE KEY `addressbook_index` (`principaluri`,`uri`)
     134) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
     135/*!40101 SET character_set_client = @saved_cs_client */;
     136
     137--
     138-- Dumping data for table `oc_addressbooks`
     139--
     140
     141LOCK TABLES `oc_addressbooks` WRITE;
     142/*!40000 ALTER TABLE `oc_addressbooks` DISABLE KEYS */;
     143INSERT INTO `oc_addressbooks` VALUES (1,'principals/system/system','system','system','System addressbook which holds all users of this instance',3),(2,'principals/users/owncloud_admin','default','default',NULL,1);
     144/*!40000 ALTER TABLE `oc_addressbooks` ENABLE KEYS */;
    85145UNLOCK TABLES;
    86146
     
    108168LOCK TABLES `oc_appconfig` WRITE;
    109169/*!40000 ALTER TABLE `oc_appconfig` DISABLE KEYS */;
    110 INSERT 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');
     170INSERT INTO `oc_appconfig` VALUES ('activity','enabled','yes'),('activity','installed_version','2.2.1'),('activity','types','filesystem'),('backgroundjob','lastjob','12'),('calendar','enabled','no'),('calendar','installed_version','1.1'),('calendar','ocsid','168707'),('calendar','types',''),('comments','enabled','yes'),('comments','installed_version','0.2'),('comments','types','logging'),('core','installedat','1462298827.9119'),('core','lastcron','1462436029'),('core','lastupdatedat','1462298827.9194'),('core','oc.integritycheck.checker',''),('core','public_files','files_sharing/public.php'),('core','public_webdav','dav/appinfo/v1/publicwebdav.php'),('core','remote_caldav','dav/appinfo/v1/caldav.php'),('core','remote_calendar','dav/appinfo/v1/caldav.php'),('core','remote_carddav','dav/appinfo/v1/carddav.php'),('core','remote_contacts','dav/appinfo/v1/carddav.php'),('core','remote_dav','dav/appinfo/v2/remote.php'),('core','remote_files','dav/appinfo/v1/webdav.php'),('core','remote_webdav','dav/appinfo/v1/webdav.php'),('dav','enabled','yes'),('dav','installed_version','0.1.6'),('dav','types','filesystem'),('federatedfilesharing','enabled','yes'),('federatedfilesharing','installed_version','0.1.0'),('federatedfilesharing','types',''),('federation','enabled','yes'),('federation','installed_version','0.0.4'),('federation','types','authentication'),('files','cronjob_scan_files','500'),('files','enabled','yes'),('files','installed_version','1.4.4'),('files','types','filesystem'),('files_pdfviewer','enabled','yes'),('files_pdfviewer','installed_version','0.8'),('files_pdfviewer','ocsid','166049'),('files_pdfviewer','types',''),('files_sharing','enabled','yes'),('files_sharing','installed_version','0.9.1'),('files_sharing','types','filesystem'),('files_texteditor','enabled','yes'),('files_texteditor','installed_version','2.1'),('files_texteditor','ocsid','166051'),('files_texteditor','types',''),('files_trashbin','enabled','yes'),('files_trashbin','installed_version','0.8.0'),('files_trashbin','types','filesystem'),('files_versions','enabled','yes'),('files_versions','installed_version','1.2.0'),('files_versions','types','filesystem'),('files_videoplayer','enabled','yes'),('files_videoplayer','installed_version','0.9.8'),('files_videoplayer','types',''),('firstrunwizard','enabled','yes'),('firstrunwizard','installed_version','1.1'),('firstrunwizard','ocsid','166055'),('firstrunwizard','types',''),('gallery','enabled','yes'),('gallery','installed_version','14.5.0'),('gallery','types',''),('notifications','enabled','yes'),('notifications','installed_version','0.2.3'),('notifications','types','logging'),('provisioning_api','enabled','yes'),('provisioning_api','installed_version','0.4.1'),('provisioning_api','types','prevent_group_restriction'),('systemtags','enabled','yes'),('systemtags','installed_version','0.2'),('systemtags','types','logging'),('templateeditor','enabled','yes'),('templateeditor','installed_version','0.1'),('templateeditor','types',''),('updatenotification','enabled','yes'),('updatenotification','installed_version','0.1.0'),('updatenotification','types',''),('user_ldap','cleanUpJobOffset','0'),('user_ldap','enabled','yes'),('user_ldap','has_memberof_filter_support',''),('user_ldap','home_folder_naming_rule',''),('user_ldap','installed_version','0.8.0'),('user_ldap','last_jpegPhoto_lookup','0'),('user_ldap','ldap_agent_password',''),('user_ldap','ldap_attributes_for_group_search',''),('user_ldap','ldap_attributes_for_user_search',''),('user_ldap','ldap_backup_host',''),('user_ldap','ldap_backup_port',''),('user_ldap','ldap_base','{{LDAP_BASE_USER_TREE}}'),('user_ldap','ldap_base_groups','{{LDAP_BASE_GROUP_TREE}}'),('user_ldap','ldap_base_users','{{LDAP_BASE_USER_TREE}}'),('user_ldap','ldap_cache_ttl','600'),('user_ldap','ldap_configuration_active','1'),('user_ldap','ldap_display_name','cn'),('user_ldap','ldap_dn',''),('user_ldap','ldap_dynamic_group_member_url',''),('user_ldap','ldap_email_attr',''),('user_ldap','ldap_experienced_admin','1'),('user_ldap','ldap_expert_username_attr',''),('user_ldap','ldap_expert_uuid_group_attr','cn'),('user_ldap','ldap_expert_uuid_user_attr','uid'),('user_ldap','ldap_group_display_name','cn'),('user_ldap','ldap_group_filter','(objectclass=x-lliurex-group)'),('user_ldap','ldap_group_filter_mode','1'),('user_ldap','ldap_group_member_assoc_attribute','memberUid'),('user_ldap','ldap_groupfilter_groups',''),('user_ldap','ldap_groupfilter_objectclass',''),('user_ldap','ldap_host','ldap://localhost'),('user_ldap','ldap_login_filter','(&(|(objectclass=person))(uid=%uid))'),('user_ldap','ldap_login_filter_mode','0'),('user_ldap','ldap_loginfilter_attributes',''),('user_ldap','ldap_loginfilter_email','0'),('user_ldap','ldap_loginfilter_username','1'),('user_ldap','ldap_nested_groups','0'),('user_ldap','ldap_override_main_server',''),('user_ldap','ldap_paging_size','500'),('user_ldap','ldap_port','389'),('user_ldap','ldap_quota_attr',''),('user_ldap','ldap_quota_def',''),('user_ldap','ldap_tls','1'),('user_ldap','ldap_turn_off_cert_check','0'),('user_ldap','ldap_user_display_name_2',''),('user_ldap','ldap_user_filter_mode','1'),('user_ldap','ldap_userfilter_groups',''),('user_ldap','ldap_userfilter_objectclass','posixAccount'),('user_ldap','ldap_userlist_filter','(objectclass=*)'),('user_ldap','types','authentication'),('user_ldap','use_memberof_to_detect_membership','1');
    111171/*!40000 ALTER TABLE `oc_appconfig` ENABLE KEYS */;
    112172UNLOCK TABLES;
    113173
    114174--
    115 -- Table structure for table `oc_file_map`
    116 --
    117 
    118 DROP TABLE IF EXISTS `oc_file_map`;
    119 /*!40101 SET @saved_cs_client     = @@character_set_client */;
    120 /*!40101 SET character_set_client = utf8 */;
    121 CREATE 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 
    135 LOCK TABLES `oc_file_map` WRITE;
    136 /*!40000 ALTER TABLE `oc_file_map` DISABLE KEYS */;
    137 /*!40000 ALTER TABLE `oc_file_map` ENABLE KEYS */;
     175-- Table structure for table `oc_calendarchanges`
     176--
     177
     178DROP TABLE IF EXISTS `oc_calendarchanges`;
     179/*!40101 SET @saved_cs_client     = @@character_set_client */;
     180/*!40101 SET character_set_client = utf8 */;
     181CREATE TABLE `oc_calendarchanges` (
     182  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
     183  `uri` varchar(255) COLLATE utf8_bin DEFAULT NULL,
     184  `synctoken` int(10) unsigned NOT NULL DEFAULT '1',
     185  `calendarid` int(11) NOT NULL,
     186  `operation` smallint(6) NOT NULL,
     187  PRIMARY KEY (`id`),
     188  KEY `calendarid_synctoken` (`calendarid`,`synctoken`)
     189) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
     190/*!40101 SET character_set_client = @saved_cs_client */;
     191
     192--
     193-- Dumping data for table `oc_calendarchanges`
     194--
     195
     196LOCK TABLES `oc_calendarchanges` WRITE;
     197/*!40000 ALTER TABLE `oc_calendarchanges` DISABLE KEYS */;
     198/*!40000 ALTER TABLE `oc_calendarchanges` ENABLE KEYS */;
     199UNLOCK TABLES;
     200
     201--
     202-- Table structure for table `oc_calendarobjects`
     203--
     204
     205DROP TABLE IF EXISTS `oc_calendarobjects`;
     206/*!40101 SET @saved_cs_client     = @@character_set_client */;
     207/*!40101 SET character_set_client = utf8 */;
     208CREATE TABLE `oc_calendarobjects` (
     209  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
     210  `calendardata` longblob,
     211  `uri` varchar(255) COLLATE utf8_bin DEFAULT NULL,
     212  `calendarid` int(10) unsigned NOT NULL,
     213  `lastmodified` int(10) unsigned DEFAULT NULL,
     214  `etag` varchar(32) COLLATE utf8_bin DEFAULT NULL,
     215  `size` bigint(20) unsigned NOT NULL,
     216  `componenttype` varchar(255) COLLATE utf8_bin DEFAULT NULL,
     217  `firstoccurence` int(10) unsigned DEFAULT NULL,
     218  `lastoccurence` int(10) unsigned DEFAULT NULL,
     219  `uid` varchar(255) COLLATE utf8_bin DEFAULT NULL,
     220  PRIMARY KEY (`id`),
     221  UNIQUE KEY `calobjects_index` (`calendarid`,`uri`)
     222) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
     223/*!40101 SET character_set_client = @saved_cs_client */;
     224
     225--
     226-- Dumping data for table `oc_calendarobjects`
     227--
     228
     229LOCK TABLES `oc_calendarobjects` WRITE;
     230/*!40000 ALTER TABLE `oc_calendarobjects` DISABLE KEYS */;
     231/*!40000 ALTER TABLE `oc_calendarobjects` ENABLE KEYS */;
     232UNLOCK TABLES;
     233
     234--
     235-- Table structure for table `oc_calendars`
     236--
     237
     238DROP TABLE IF EXISTS `oc_calendars`;
     239/*!40101 SET @saved_cs_client     = @@character_set_client */;
     240/*!40101 SET character_set_client = utf8 */;
     241CREATE TABLE `oc_calendars` (
     242  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
     243  `principaluri` varchar(255) COLLATE utf8_bin DEFAULT NULL,
     244  `displayname` varchar(255) COLLATE utf8_bin DEFAULT NULL,
     245  `uri` varchar(255) COLLATE utf8_bin DEFAULT NULL,
     246  `synctoken` int(10) unsigned NOT NULL DEFAULT '1',
     247  `description` varchar(255) COLLATE utf8_bin DEFAULT NULL,
     248  `calendarorder` int(10) unsigned NOT NULL DEFAULT '0',
     249  `calendarcolor` varchar(255) COLLATE utf8_bin DEFAULT NULL,
     250  `timezone` longtext COLLATE utf8_bin,
     251  `components` varchar(255) COLLATE utf8_bin DEFAULT NULL,
     252  `transparent` smallint(6) NOT NULL DEFAULT '0',
     253  PRIMARY KEY (`id`),
     254  UNIQUE KEY `calendars_index` (`principaluri`,`uri`)
     255) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
     256/*!40101 SET character_set_client = @saved_cs_client */;
     257
     258--
     259-- Dumping data for table `oc_calendars`
     260--
     261
     262LOCK TABLES `oc_calendars` WRITE;
     263/*!40000 ALTER TABLE `oc_calendars` DISABLE KEYS */;
     264INSERT INTO `oc_calendars` VALUES (1,'principals/users/owncloud_admin','Contact birthdays','contact_birthdays',1,NULL,0,'#FFFFCA',NULL,'VEVENT,VTODO',0),(2,'principals/system/system','Contact birthdays','contact_birthdays',1,NULL,0,'#FFFFCA',NULL,'VEVENT,VTODO',0);
     265/*!40000 ALTER TABLE `oc_calendars` ENABLE KEYS */;
     266UNLOCK TABLES;
     267
     268--
     269-- Table structure for table `oc_calendarsubscriptions`
     270--
     271
     272DROP TABLE IF EXISTS `oc_calendarsubscriptions`;
     273/*!40101 SET @saved_cs_client     = @@character_set_client */;
     274/*!40101 SET character_set_client = utf8 */;
     275CREATE TABLE `oc_calendarsubscriptions` (
     276  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
     277  `uri` varchar(255) COLLATE utf8_bin DEFAULT NULL,
     278  `principaluri` varchar(255) COLLATE utf8_bin DEFAULT NULL,
     279  `source` varchar(255) COLLATE utf8_bin DEFAULT NULL,
     280  `displayname` varchar(100) COLLATE utf8_bin DEFAULT NULL,
     281  `refreshrate` varchar(10) COLLATE utf8_bin DEFAULT NULL,
     282  `calendarorder` int(10) unsigned NOT NULL DEFAULT '0',
     283  `calendarcolor` varchar(255) COLLATE utf8_bin DEFAULT NULL,
     284  `striptodos` smallint(6) DEFAULT NULL,
     285  `stripalarms` smallint(6) DEFAULT NULL,
     286  `stripattachments` smallint(6) DEFAULT NULL,
     287  `lastmodified` int(10) unsigned DEFAULT NULL,
     288  PRIMARY KEY (`id`),
     289  UNIQUE KEY `calsub_index` (`principaluri`,`uri`)
     290) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
     291/*!40101 SET character_set_client = @saved_cs_client */;
     292
     293--
     294-- Dumping data for table `oc_calendarsubscriptions`
     295--
     296
     297LOCK TABLES `oc_calendarsubscriptions` WRITE;
     298/*!40000 ALTER TABLE `oc_calendarsubscriptions` DISABLE KEYS */;
     299/*!40000 ALTER TABLE `oc_calendarsubscriptions` ENABLE KEYS */;
     300UNLOCK TABLES;
     301
     302--
     303-- Table structure for table `oc_cards`
     304--
     305
     306DROP TABLE IF EXISTS `oc_cards`;
     307/*!40101 SET @saved_cs_client     = @@character_set_client */;
     308/*!40101 SET character_set_client = utf8 */;
     309CREATE TABLE `oc_cards` (
     310  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
     311  `addressbookid` int(11) NOT NULL DEFAULT '0',
     312  `carddata` longblob,
     313  `uri` varchar(255) COLLATE utf8_bin DEFAULT NULL,
     314  `lastmodified` bigint(20) unsigned DEFAULT NULL,
     315  `etag` varchar(32) COLLATE utf8_bin DEFAULT NULL,
     316  `size` bigint(20) unsigned NOT NULL,
     317  PRIMARY KEY (`id`)
     318) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
     319/*!40101 SET character_set_client = @saved_cs_client */;
     320
     321--
     322-- Dumping data for table `oc_cards`
     323--
     324
     325LOCK TABLES `oc_cards` WRITE;
     326/*!40000 ALTER TABLE `oc_cards` DISABLE KEYS */;
     327/*!40000 ALTER TABLE `oc_cards` ENABLE KEYS */;
     328UNLOCK TABLES;
     329
     330--
     331-- Table structure for table `oc_cards_properties`
     332--
     333
     334DROP TABLE IF EXISTS `oc_cards_properties`;
     335/*!40101 SET @saved_cs_client     = @@character_set_client */;
     336/*!40101 SET character_set_client = utf8 */;
     337CREATE TABLE `oc_cards_properties` (
     338  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
     339  `addressbookid` bigint(20) NOT NULL DEFAULT '0',
     340  `cardid` bigint(20) unsigned NOT NULL DEFAULT '0',
     341  `name` varchar(64) COLLATE utf8_bin DEFAULT NULL,
     342  `value` varchar(255) COLLATE utf8_bin DEFAULT NULL,
     343  `preferred` int(11) NOT NULL DEFAULT '1',
     344  PRIMARY KEY (`id`),
     345  KEY `card_contactid_index` (`cardid`),
     346  KEY `card_name_index` (`name`),
     347  KEY `card_value_index` (`value`)
     348) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
     349/*!40101 SET character_set_client = @saved_cs_client */;
     350
     351--
     352-- Dumping data for table `oc_cards_properties`
     353--
     354
     355LOCK TABLES `oc_cards_properties` WRITE;
     356/*!40000 ALTER TABLE `oc_cards_properties` DISABLE KEYS */;
     357/*!40000 ALTER TABLE `oc_cards_properties` ENABLE KEYS */;
     358UNLOCK TABLES;
     359
     360--
     361-- Table structure for table `oc_comments`
     362--
     363
     364DROP TABLE IF EXISTS `oc_comments`;
     365/*!40101 SET @saved_cs_client     = @@character_set_client */;
     366/*!40101 SET character_set_client = utf8 */;
     367CREATE TABLE `oc_comments` (
     368  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
     369  `parent_id` int(10) unsigned NOT NULL DEFAULT '0',
     370  `topmost_parent_id` int(10) unsigned NOT NULL DEFAULT '0',
     371  `children_count` int(10) unsigned NOT NULL DEFAULT '0',
     372  `actor_type` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
     373  `actor_id` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
     374  `message` longtext COLLATE utf8_bin,
     375  `verb` varchar(64) COLLATE utf8_bin DEFAULT NULL,
     376  `creation_timestamp` datetime DEFAULT NULL,
     377  `latest_child_timestamp` datetime DEFAULT NULL,
     378  `object_type` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
     379  `object_id` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
     380  PRIMARY KEY (`id`),
     381  KEY `comments_parent_id_index` (`parent_id`),
     382  KEY `comments_topmost_parent_id_idx` (`topmost_parent_id`),
     383  KEY `comments_object_index` (`object_type`,`object_id`,`creation_timestamp`),
     384  KEY `comments_actor_index` (`actor_type`,`actor_id`)
     385) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
     386/*!40101 SET character_set_client = @saved_cs_client */;
     387
     388--
     389-- Dumping data for table `oc_comments`
     390--
     391
     392LOCK TABLES `oc_comments` WRITE;
     393/*!40000 ALTER TABLE `oc_comments` DISABLE KEYS */;
     394/*!40000 ALTER TABLE `oc_comments` ENABLE KEYS */;
     395UNLOCK TABLES;
     396
     397--
     398-- Table structure for table `oc_comments_read_markers`
     399--
     400
     401DROP TABLE IF EXISTS `oc_comments_read_markers`;
     402/*!40101 SET @saved_cs_client     = @@character_set_client */;
     403/*!40101 SET character_set_client = utf8 */;
     404CREATE TABLE `oc_comments_read_markers` (
     405  `user_id` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
     406  `marker_datetime` datetime DEFAULT NULL,
     407  `object_type` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
     408  `object_id` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
     409  UNIQUE KEY `comments_marker_index` (`user_id`,`object_type`,`object_id`),
     410  KEY `comments_marker_object_index` (`object_type`,`object_id`)
     411) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
     412/*!40101 SET character_set_client = @saved_cs_client */;
     413
     414--
     415-- Dumping data for table `oc_comments_read_markers`
     416--
     417
     418LOCK TABLES `oc_comments_read_markers` WRITE;
     419/*!40000 ALTER TABLE `oc_comments_read_markers` DISABLE KEYS */;
     420/*!40000 ALTER TABLE `oc_comments_read_markers` ENABLE KEYS */;
     421UNLOCK TABLES;
     422
     423--
     424-- Table structure for table `oc_credentials`
     425--
     426
     427DROP TABLE IF EXISTS `oc_credentials`;
     428/*!40101 SET @saved_cs_client     = @@character_set_client */;
     429/*!40101 SET character_set_client = utf8 */;
     430CREATE TABLE `oc_credentials` (
     431  `user` varchar(64) COLLATE utf8_bin NOT NULL,
     432  `identifier` varchar(64) COLLATE utf8_bin NOT NULL,
     433  `credentials` longtext COLLATE utf8_bin,
     434  PRIMARY KEY (`user`,`identifier`),
     435  KEY `credentials_user` (`user`)
     436) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
     437/*!40101 SET character_set_client = @saved_cs_client */;
     438
     439--
     440-- Dumping data for table `oc_credentials`
     441--
     442
     443LOCK TABLES `oc_credentials` WRITE;
     444/*!40000 ALTER TABLE `oc_credentials` DISABLE KEYS */;
     445/*!40000 ALTER TABLE `oc_credentials` ENABLE KEYS */;
     446UNLOCK TABLES;
     447
     448--
     449-- Table structure for table `oc_dav_shares`
     450--
     451
     452DROP TABLE IF EXISTS `oc_dav_shares`;
     453/*!40101 SET @saved_cs_client     = @@character_set_client */;
     454/*!40101 SET character_set_client = utf8 */;
     455CREATE TABLE `oc_dav_shares` (
     456  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
     457  `principaluri` varchar(255) COLLATE utf8_bin DEFAULT NULL,
     458  `type` varchar(255) COLLATE utf8_bin DEFAULT NULL,
     459  `access` smallint(6) DEFAULT NULL,
     460  `resourceid` int(10) unsigned NOT NULL,
     461  PRIMARY KEY (`id`),
     462  UNIQUE KEY `dav_shares_index` (`principaluri`,`resourceid`,`type`)
     463) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
     464/*!40101 SET character_set_client = @saved_cs_client */;
     465
     466--
     467-- Dumping data for table `oc_dav_shares`
     468--
     469
     470LOCK TABLES `oc_dav_shares` WRITE;
     471/*!40000 ALTER TABLE `oc_dav_shares` DISABLE KEYS */;
     472/*!40000 ALTER TABLE `oc_dav_shares` ENABLE KEYS */;
     473UNLOCK TABLES;
     474
     475--
     476-- Table structure for table `oc_file_locks`
     477--
     478
     479DROP TABLE IF EXISTS `oc_file_locks`;
     480/*!40101 SET @saved_cs_client     = @@character_set_client */;
     481/*!40101 SET character_set_client = utf8 */;
     482CREATE TABLE `oc_file_locks` (
     483  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
     484  `lock` int(11) NOT NULL DEFAULT '0',
     485  `key` varchar(64) COLLATE utf8_bin NOT NULL,
     486  `ttl` int(11) NOT NULL DEFAULT '-1',
     487  PRIMARY KEY (`id`),
     488  UNIQUE KEY `lock_key_index` (`key`),
     489  KEY `lock_ttl_index` (`ttl`)
     490) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
     491/*!40101 SET character_set_client = @saved_cs_client */;
     492
     493--
     494-- Dumping data for table `oc_file_locks`
     495--
     496
     497LOCK TABLES `oc_file_locks` WRITE;
     498/*!40000 ALTER TABLE `oc_file_locks` DISABLE KEYS */;
     499INSERT INTO `oc_file_locks` VALUES (1,0,'files/61ed1f9a7383795ed88817d445e1546b',1462439524),(2,0,'files/c31e581b3c2ec56f9b7b1dca2421b72e',1462439524),(3,0,'files/ef90c82ae6bd9d9a22ee5b7c93d77ca7',1462439524);
     500/*!40000 ALTER TABLE `oc_file_locks` ENABLE KEYS */;
    138501UNLOCK TABLES;
    139502
     
    161524  `etag` varchar(40) COLLATE utf8_bin DEFAULT NULL,
    162525  `permissions` int(11) DEFAULT '0',
     526  `checksum` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    163527  PRIMARY KEY (`fileid`),
    164528  UNIQUE KEY `fs_storage_path_hash` (`storage`,`path_hash`),
     
    167531  KEY `fs_storage_mimepart` (`storage`,`mimepart`),
    168532  KEY `fs_storage_size` (`storage`,`size`,`fileid`)
    169 ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
     533) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
    170534/*!40101 SET character_set_client = @saved_cs_client */;
    171535
     
    176540LOCK TABLES `oc_filecache` WRITE;
    177541/*!40000 ALTER TABLE `oc_filecache` DISABLE KEYS */;
    178 INSERT 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);
     542INSERT INTO `oc_filecache` VALUES (1,1,'','d41d8cd98f00b204e9800998ecf8427e',-1,'',2,1,714783,1462298950,1462298950,0,0,'5728e9463cca5',23,NULL),(2,1,'files','45b963397aa40d4a0063e0d85e4fe7a1',1,'files',2,1,714783,1462298828,1462298828,0,0,'5728e8cc77a0f',31,NULL),(3,1,'files/Documents','0ad78ba05b6961d92f7970b2b3922eca',2,'Documents',2,1,36227,1462298828,1462298828,0,0,'5728e8cc43537',31,NULL),(4,1,'files/Documents/Example.odt','c89c560541b952a435783a7d51a27d50',3,'Example.odt',4,3,36227,1462298828,1462298828,0,0,'0bb5554e6014517367b5eaad13ea9b5d',27,NULL),(5,1,'files/Photos','d01bb67e7b71dd49fd06bad922f521c9',2,'Photos',2,1,678556,1462298828,1462298828,0,0,'5728e8cc76df4',31,NULL),(6,1,'files/Photos/San Francisco.jpg','9fc714efbeaafee22f7058e73d2b1c3b',5,'San Francisco.jpg',6,5,216071,1462298828,1462298828,0,0,'0e08474b4ea6dfcf0a435bec88d987f0',27,NULL),(7,1,'files/Photos/Squirrel.jpg','de85d1da71bcd6232ad893f959063b8c',5,'Squirrel.jpg',6,5,233724,1462298828,1462298828,0,0,'850848d39cee59d1ec3b50c37288810d',27,NULL),(8,1,'files/Photos/Paris.jpg','a208ddedf08367bbc56963107248dda5',5,'Paris.jpg',6,5,228761,1462298828,1462298828,0,0,'f0b91bc1e3391e3288cfb9c29ffdf45c',27,NULL),(9,2,'','d41d8cd98f00b204e9800998ecf8427e',-1,'',2,1,-1,1462298836,1462298836,0,0,'5728e8d4a514d',23,NULL),(10,2,'files_external','c270928b685e7946199afdfb898d27ea',9,'files_external',2,1,0,1462298836,1462298836,0,0,'5728e8d4a2830',31,NULL),(11,1,'cache','0fea6a13c52b4d4725368f24b045ca84',1,'cache',2,1,0,1462298950,1462298950,0,0,'5728e9463925f',31,NULL);
    179543/*!40000 ALTER TABLE `oc_filecache` ENABLE KEYS */;
    180544UNLOCK TABLES;
     
    245609  `gid` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
    246610  `uid` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
    247   PRIMARY KEY (`gid`,`uid`)
     611  PRIMARY KEY (`gid`,`uid`),
     612  KEY `gu_uid_index` (`uid`)
    248613) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
    249614/*!40101 SET character_set_client = @saved_cs_client */;
     
    292657  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    293658  `class` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
    294   `argument` varchar(256) COLLATE utf8_bin NOT NULL DEFAULT '',
     659  `argument` varchar(4000) COLLATE utf8_bin NOT NULL DEFAULT '',
    295660  `last_run` int(11) DEFAULT '0',
    296661  PRIMARY KEY (`id`),
    297662  KEY `job_class_index` (`class`)
    298 ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
     663) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
    299664/*!40101 SET character_set_client = @saved_cs_client */;
    300665
     
    305670LOCK TABLES `oc_jobs` WRITE;
    306671/*!40000 ALTER TABLE `oc_jobs` DISABLE KEYS */;
    307 INSERT 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);
     672INSERT INTO `oc_jobs` VALUES (1,'OCA\\Files_Trashbin\\BackgroundJob\\ExpireTrash','null',1462430793),(2,'OCA\\DAV\\CardDAV\\SyncJob','null',1462428872),(3,'OCA\\Federation\\SyncJob','null',1462428881),(4,'OCA\\Files_Versions\\BackgroundJob\\ExpireVersions','null',1462431168),(5,'OCA\\Files_sharing\\Lib\\DeleteOrphanedSharesJob','null',1462430421),(6,'OCA\\Files_sharing\\ExpireSharesJob','null',1462429049),(7,'OCA\\Files\\BackgroundJob\\ScanFiles','null',1462435917),(8,'OCA\\Files\\BackgroundJob\\DeleteOrphanedItems','null',1462435924),(9,'OCA\\Files\\BackgroundJob\\CleanupFileLocks','null',1462435930),(10,'OCA\\Activity\\BackgroundJob\\EmailNotification','null',1462435936),(11,'OCA\\Activity\\BackgroundJob\\ExpireActivities','null',1462365668),(12,'OCA\\user_ldap\\lib\\Jobs','null',1462436029),(13,'\\OCA\\User_LDAP\\Jobs\\CleanUp','null',1462428854);
    308673/*!40000 ALTER TABLE `oc_jobs` ENABLE KEYS */;
    309674UNLOCK TABLES;
     
    383748
    384749--
    385 -- Table structure for table `oc_locks`
    386 --
    387 
    388 DROP TABLE IF EXISTS `oc_locks`;
    389 /*!40101 SET @saved_cs_client     = @@character_set_client */;
    390 /*!40101 SET character_set_client = utf8 */;
    391 CREATE 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 
    409 LOCK TABLES `oc_locks` WRITE;
    410 /*!40000 ALTER TABLE `oc_locks` DISABLE KEYS */;
    411 /*!40000 ALTER TABLE `oc_locks` ENABLE KEYS */;
    412 UNLOCK TABLES;
    413 
    414 --
    415750-- Table structure for table `oc_mimetypes`
    416751--
     
    424759  PRIMARY KEY (`id`),
    425760  UNIQUE KEY `mimetype_id_index` (`mimetype`)
    426 ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
     761) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
    427762/*!40101 SET character_set_client = @saved_cs_client */;
    428763
     
    433768LOCK TABLES `oc_mimetypes` WRITE;
    434769/*!40000 ALTER TABLE `oc_mimetypes` DISABLE KEYS */;
    435 INSERT 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');
     770INSERT INTO `oc_mimetypes` VALUES (3,'application'),(4,'application/vnd.oasis.opendocument.text'),(1,'httpd'),(2,'httpd/unix-directory'),(5,'image'),(6,'image/jpeg');
    436771/*!40000 ALTER TABLE `oc_mimetypes` ENABLE KEYS */;
     772UNLOCK TABLES;
     773
     774--
     775-- Table structure for table `oc_mounts`
     776--
     777
     778DROP TABLE IF EXISTS `oc_mounts`;
     779/*!40101 SET @saved_cs_client     = @@character_set_client */;
     780/*!40101 SET character_set_client = utf8 */;
     781CREATE TABLE `oc_mounts` (
     782  `id` int(11) NOT NULL AUTO_INCREMENT,
     783  `storage_id` int(11) NOT NULL,
     784  `root_id` int(11) NOT NULL,
     785  `user_id` varchar(64) COLLATE utf8_bin NOT NULL,
     786  `mount_point` varchar(4000) COLLATE utf8_bin NOT NULL,
     787  PRIMARY KEY (`id`),
     788  UNIQUE KEY `mounts_user_root_index` (`user_id`,`root_id`),
     789  KEY `mounts_user_index` (`user_id`),
     790  KEY `mounts_storage_index` (`storage_id`),
     791  KEY `mounts_root_index` (`root_id`)
     792) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
     793/*!40101 SET character_set_client = @saved_cs_client */;
     794
     795--
     796-- Dumping data for table `oc_mounts`
     797--
     798
     799LOCK TABLES `oc_mounts` WRITE;
     800/*!40000 ALTER TABLE `oc_mounts` DISABLE KEYS */;
     801/*!40000 ALTER TABLE `oc_mounts` ENABLE KEYS */;
     802UNLOCK TABLES;
     803
     804--
     805-- Table structure for table `oc_notifications`
     806--
     807
     808DROP TABLE IF EXISTS `oc_notifications`;
     809/*!40101 SET @saved_cs_client     = @@character_set_client */;
     810/*!40101 SET character_set_client = utf8 */;
     811CREATE TABLE `oc_notifications` (
     812  `notification_id` int(11) NOT NULL AUTO_INCREMENT,
     813  `app` varchar(32) COLLATE utf8_bin NOT NULL,
     814  `user` varchar(64) COLLATE utf8_bin NOT NULL,
     815  `timestamp` int(11) NOT NULL DEFAULT '0',
     816  `object_type` varchar(64) COLLATE utf8_bin NOT NULL,
     817  `object_id` varchar(64) COLLATE utf8_bin NOT NULL,
     818  `subject` varchar(64) COLLATE utf8_bin NOT NULL,
     819  `subject_parameters` longtext COLLATE utf8_bin,
     820  `message` varchar(64) COLLATE utf8_bin DEFAULT NULL,
     821  `message_parameters` longtext COLLATE utf8_bin,
     822  `link` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
     823  `actions` longtext COLLATE utf8_bin,
     824  PRIMARY KEY (`notification_id`),
     825  KEY `oc_notifications_app` (`app`),
     826  KEY `oc_notifications_user` (`user`),
     827  KEY `oc_notifications_timestamp` (`timestamp`),
     828  KEY `oc_notifications_object` (`object_type`,`object_id`)
     829) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
     830/*!40101 SET character_set_client = @saved_cs_client */;
     831
     832--
     833-- Dumping data for table `oc_notifications`
     834--
     835
     836LOCK TABLES `oc_notifications` WRITE;
     837/*!40000 ALTER TABLE `oc_notifications` DISABLE KEYS */;
     838/*!40000 ALTER TABLE `oc_notifications` ENABLE KEYS */;
    437839UNLOCK TABLES;
    438840
     
    517919
    518920--
     921-- Table structure for table `oc_schedulingobjects`
     922--
     923
     924DROP TABLE IF EXISTS `oc_schedulingobjects`;
     925/*!40101 SET @saved_cs_client     = @@character_set_client */;
     926/*!40101 SET character_set_client = utf8 */;
     927CREATE TABLE `oc_schedulingobjects` (
     928  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
     929  `principaluri` varchar(255) COLLATE utf8_bin DEFAULT NULL,
     930  `calendardata` longblob,
     931  `uri` varchar(255) COLLATE utf8_bin DEFAULT NULL,
     932  `lastmodified` int(10) unsigned DEFAULT NULL,
     933  `etag` varchar(32) COLLATE utf8_bin DEFAULT NULL,
     934  `size` bigint(20) unsigned NOT NULL,
     935  PRIMARY KEY (`id`)
     936) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
     937/*!40101 SET character_set_client = @saved_cs_client */;
     938
     939--
     940-- Dumping data for table `oc_schedulingobjects`
     941--
     942
     943LOCK TABLES `oc_schedulingobjects` WRITE;
     944/*!40000 ALTER TABLE `oc_schedulingobjects` DISABLE KEYS */;
     945/*!40000 ALTER TABLE `oc_schedulingobjects` ENABLE KEYS */;
     946UNLOCK TABLES;
     947
     948--
    519949-- Table structure for table `oc_share`
    520950--
     
    528958  `share_with` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    529959  `uid_owner` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
     960  `uid_initiator` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    530961  `parent` int(11) DEFAULT NULL,
    531962  `item_type` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
     
    6001031  `id` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    6011032  `numeric_id` int(11) NOT NULL AUTO_INCREMENT,
     1033  `available` int(11) NOT NULL DEFAULT '1',
     1034  `last_checked` int(11) DEFAULT NULL,
    6021035  PRIMARY KEY (`numeric_id`),
    6031036  UNIQUE KEY `storages_id_index` (`id`)
    604 ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
     1037) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
    6051038/*!40101 SET character_set_client = @saved_cs_client */;
    6061039
     
    6111044LOCK TABLES `oc_storages` WRITE;
    6121045/*!40000 ALTER TABLE `oc_storages` DISABLE KEYS */;
    613 INSERT INTO `oc_storages` VALUES ('home::{{ ADMIN_USER }}',1),('local::/var/www/owncloud/data/',2);
     1046INSERT INTO `oc_storages` VALUES ('home::{{ ADMIN_USER }}',1,1,NULL),('local::/var/www/owncloud/data/',2,1,NULL);
    6141047/*!40000 ALTER TABLE `oc_storages` ENABLE KEYS */;
     1048UNLOCK TABLES;
     1049
     1050--
     1051-- Table structure for table `oc_systemtag`
     1052--
     1053
     1054DROP TABLE IF EXISTS `oc_systemtag`;
     1055/*!40101 SET @saved_cs_client     = @@character_set_client */;
     1056/*!40101 SET character_set_client = utf8 */;
     1057CREATE TABLE `oc_systemtag` (
     1058  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
     1059  `name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
     1060  `visibility` smallint(6) NOT NULL DEFAULT '1',
     1061  `editable` smallint(6) NOT NULL DEFAULT '1',
     1062  PRIMARY KEY (`id`),
     1063  UNIQUE KEY `tag_ident` (`name`,`visibility`,`editable`)
     1064) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
     1065/*!40101 SET character_set_client = @saved_cs_client */;
     1066
     1067--
     1068-- Dumping data for table `oc_systemtag`
     1069--
     1070
     1071LOCK TABLES `oc_systemtag` WRITE;
     1072/*!40000 ALTER TABLE `oc_systemtag` DISABLE KEYS */;
     1073/*!40000 ALTER TABLE `oc_systemtag` ENABLE KEYS */;
     1074UNLOCK TABLES;
     1075
     1076--
     1077-- Table structure for table `oc_systemtag_object_mapping`
     1078--
     1079
     1080DROP TABLE IF EXISTS `oc_systemtag_object_mapping`;
     1081/*!40101 SET @saved_cs_client     = @@character_set_client */;
     1082/*!40101 SET character_set_client = utf8 */;
     1083CREATE TABLE `oc_systemtag_object_mapping` (
     1084  `objectid` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
     1085  `objecttype` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
     1086  `systemtagid` int(10) unsigned NOT NULL DEFAULT '0',
     1087  UNIQUE KEY `mapping` (`objecttype`,`objectid`,`systemtagid`)
     1088) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
     1089/*!40101 SET character_set_client = @saved_cs_client */;
     1090
     1091--
     1092-- Dumping data for table `oc_systemtag_object_mapping`
     1093--
     1094
     1095LOCK TABLES `oc_systemtag_object_mapping` WRITE;
     1096/*!40000 ALTER TABLE `oc_systemtag_object_mapping` DISABLE KEYS */;
     1097/*!40000 ALTER TABLE `oc_systemtag_object_mapping` ENABLE KEYS */;
     1098UNLOCK TABLES;
     1099
     1100--
     1101-- Table structure for table `oc_trusted_servers`
     1102--
     1103
     1104DROP TABLE IF EXISTS `oc_trusted_servers`;
     1105/*!40101 SET @saved_cs_client     = @@character_set_client */;
     1106/*!40101 SET character_set_client = utf8 */;
     1107CREATE TABLE `oc_trusted_servers` (
     1108  `id` int(11) NOT NULL AUTO_INCREMENT,
     1109  `url` varchar(512) COLLATE utf8_bin NOT NULL COMMENT 'Url of trusted server',
     1110  `url_hash` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT 'sha1 hash of the url without the protocol',
     1111  `token` varchar(128) COLLATE utf8_bin DEFAULT NULL COMMENT 'token used to exchange the shared secret',
     1112  `shared_secret` varchar(256) COLLATE utf8_bin DEFAULT NULL COMMENT 'shared secret used to authenticate',
     1113  `status` int(11) NOT NULL DEFAULT '2' COMMENT 'current status of the connection',
     1114  `sync_token` varchar(512) COLLATE utf8_bin DEFAULT NULL COMMENT 'cardDav sync token',
     1115  PRIMARY KEY (`id`),
     1116  UNIQUE KEY `url_hash` (`url_hash`)
     1117) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
     1118/*!40101 SET character_set_client = @saved_cs_client */;
     1119
     1120--
     1121-- Dumping data for table `oc_trusted_servers`
     1122--
     1123
     1124LOCK TABLES `oc_trusted_servers` WRITE;
     1125/*!40000 ALTER TABLE `oc_trusted_servers` DISABLE KEYS */;
     1126/*!40000 ALTER TABLE `oc_trusted_servers` ENABLE KEYS */;
    6151127UNLOCK TABLES;
    6161128
     
    6921204/*!40000 ALTER TABLE `oc_vcategory_to_object` ENABLE KEYS */;
    6931205UNLOCK TABLES;
    694 
    695 --
    696 -- Dumping routines for database 'owncloud'
    697 --
    6981206/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
    6991207
     
    7061214/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
    7071215
    708 -- Dump completed on 2015-03-10 10:21:10
     1216-- Dump completed on 2016-05-05 11:19:26
  • lliurex-owncloud/trunk/fuentes/install-files/var/www/owncloud/themes/lliurex/core/css/header.css

    r544 r1391  
    5757        -moz-box-sizing: border-box;
    5858        box-sizing: border-box;
     59        -ms-filter: "progid:DXImageTransform.Microsoft.Alpha(Opacity=100)";
     60        opacity: 1;
     61}
     62#owncloud:focus {
     63        -ms-filter: "progid:DXImageTransform.Microsoft.Alpha(Opacity=75)";
     64        opacity: .75;
     65}
     66#owncloud:hover,
     67#owncloud:active {
     68        -ms-filter: "progid:DXImageTransform.Microsoft.Alpha(Opacity=100)";
     69        opacity: 1;
    5970}
    6071
    6172#header .logo {
    62         background-image: url(../img/logo.svg);
     73        background-image: url(../img/logo-icon.svg);
    6374        background-repeat: no-repeat;
     75        background-size: 175px;
     76        background-position: center 30px;
    6477        width: 252px;
    6578        height: 120px;
    6679        margin: 0 auto;
    67 }
    68 
    69 #header .logo-wide {
    70         background-image: url(../img/logo-wide.svg);
    71         background-repeat: no-repeat;
    72         width: 150px;
    73         height: 34px;
    7480}
    7581
     
    8389}
    8490
    85 #header .menutoggle {
     91#header .header-appname-container {
    8692        display: inline-block;
    8793        position: absolute;
     
    9399
    94100/* hover effect for app switcher label */
    95 .menutoggle .header-appname,
     101.header-appname-container .header-appname,
    96102.menutoggle .icon-caret {
    97103        -ms-filter: "progid:DXImageTransform.Microsoft.Alpha(Opacity=75)";
    98         filter: alpha(opacity=75);
    99104        opacity: .75;
    100105}
     
    106111.menutoggle.active .icon-caret {
    107112        -ms-filter: "progid:DXImageTransform.Microsoft.Alpha(Opacity=100)";
    108         filter: alpha(opacity=100);
    109113        opacity: 1;
    110114}
     
    116120        color: #fff;
    117121        font-size: 16px;
     122        font-weight: 300;
    118123        margin: 0;
    119124        margin-top: -24px;
     
    143148        position: fixed;
    144149        top: 45px;
     150        left: 10px;
    145151        width: 265px;
    146152        max-height: 85%;
    147153        margin-top: 0;
    148154        padding-bottom: 10px;
    149         background-color: rgba(36, 40, 47, .97);
    150         border-bottom-right-radius: 7px;
    151         box-shadow: 0 0 7px rgba(29,45,68,.97);
     155        background-color: rgba(0, 0, 0, .97);
     156        box-shadow: 0 1px 10px rgba(50, 50, 50, .7);
     157        border-radius: 3px;
     158        border-top-left-radius: 0;
     159        border-top-right-radius: 0;
    152160        display: none;
    153         overflow-y: auto;
    154         overflow-x: hidden;
     161        /*overflow-y: auto;
     162        overflow-x: hidden;*/
    155163        z-index: 2000;
    156164}
     165/* arrow look */
     166#navigation:after, #expanddiv:after {
     167        bottom: 100%;
     168        border: solid transparent;
     169        content: " ";
     170        height: 0;
     171        width: 0;
     172        position: absolute;
     173        pointer-events: none;
     174        border-color: rgba(0, 0, 0, 0);
     175        border-bottom-color: rgba(0, 0, 0, .97);
     176        border-width: 10px;
     177        margin-left: -10px;
     178}
     179/* position of dropdown arrow */
     180#navigation:after {
     181        left: 47%;
     182}
     183#expanddiv:after {
     184        right: 15px;
     185}
     186
    157187#navigation, #navigation * {
    158188        -moz-box-sizing:border-box;
     
    185215        #navigation a img,
    186216        #navigation a span {
    187                 /* 50% opacity when inactive */
    188                 -ms-filter: "progid:DXImageTransform.Microsoft.Alpha(Opacity=50)";
    189                 filter: alpha(opacity=50);
    190                 opacity: .5;
    191         }
    192         #navigation a:hover img, #navigation a:focus img,
    193         #navigation a:hover span, #navigation a:focus span,
     217                -ms-filter: "progid:DXImageTransform.Microsoft.Alpha(Opacity=70)";
     218                opacity: .7;
     219        }
     220        #navigation a:hover img,
     221        #navigation a:focus img,
     222        #navigation a:hover span,
     223        #navigation a:focus span,
    194224        #navigation a.active img,
    195225        #navigation a.active span {
    196                  /* full opacity for the active app or when hovered/focused */
    197226                -ms-filter: "progid:DXImageTransform.Microsoft.Alpha(Opacity=100)";
    198                 filter: alpha(opacity=100);
    199227                opacity: 1;
    200228        }
     
    210238#apps-management {
    211239        -ms-filter: "progid:DXImageTransform.Microsoft.Alpha(Opacity=60)";
    212         filter: alpha(opacity=60);
    213240        opacity: .6;
    214241        min-height: initial;
     
    229256#navigation .app-loading .app-icon {
    230257        -ms-filter: "progid:DXImageTransform.Microsoft.Alpha(Opacity=10)";
    231         filter: alpha(opacity=10);
    232258        opacity: .1;
    233259}
     
    255281        float: left;
    256282        display: inline-block;
    257         margin-right: 5px;
     283        margin-right: 8px;
    258284        cursor: pointer;
    259285        height: 32px;
     
    272298#expand {
    273299        display: block;
    274         padding: 7px 12px 6px 7px;
     300        padding: 7px 30px 6px 10px;
    275301        cursor: pointer;
    276302}
     
    278304        cursor: pointer;
    279305}
    280 #expand:hover, #expand:focus, #expand:active { color:#fff; }
    281 #expand img { -ms-filter:"progid:DXImageTransform.Microsoft.Alpha(Opacity=70)"; filter:alpha(opacity=70); opacity:.7; margin-bottom:-2px; }
    282 #expand:hover img, #expand:focus img, #expand:active img { -ms-filter:"progid:DXImageTransform.Microsoft.Alpha(Opacity=100)"; filter:alpha(opacity=100); opacity:1; }
     306#expand:hover,
     307#expand:focus,
     308#expand:active {
     309        color: #fff;
     310}
     311#expand img {
     312        -ms-filter: "progid:DXImageTransform.Microsoft.Alpha(Opacity=70)";
     313        opacity: .7;
     314        margin-bottom: -2px;
     315}
     316#expand:hover img,
     317#expand:focus img,
     318#expand:active img {
     319        -ms-filter: "progid:DXImageTransform.Microsoft.Alpha(Opacity=100)";
     320        opacity: 1;
     321}
    283322#expanddiv {
    284323        position: absolute;
    285         right: 0;
     324        right: 10px;
    286325        top: 45px;
    287326        z-index: 2000;
    288327        display: none;
    289         background-color: #383c43;
    290         border-bottom-left-radius: 7px;
    291         box-shadow: 0 0 7px rgb(29,45,68);
     328        background-color: rgba(0, 0, 0, .97);
     329        box-shadow: 0 1px 10px rgba(50, 50, 50, .7);
     330        border-radius: 3px;
     331        border-top-left-radius: 0;
     332        border-top-right-radius: 0;
    292333        -moz-box-sizing: border-box; box-sizing: border-box;
    293334}
     
    298339                padding: 4px 12px 0;
    299340                -ms-filter: "progid:DXImageTransform.Microsoft.Alpha(Opacity=70)";
    300                 filter: alpha(opacity=70);
    301341                opacity: .7;
    302342                -moz-box-sizing: border-box;
     
    307347                margin-right: 6px;
    308348        }
    309         #expanddiv a:hover, #expanddiv a:focus, #expanddiv a:active {
     349        #expanddiv a:hover,
     350        #expanddiv a:focus,
     351        #expanddiv a:active,
     352        #expanddiv a.active {
    310353                -ms-filter: "progid:DXImageTransform.Microsoft.Alpha(Opacity=100)";
    311                 filter: alpha(opacity=100);
    312354                opacity: 1;
    313355        }
Note: See TracChangeset for help on using the changeset viewer.