Diff for QuickDatabase between 4 and 5

On Suse

<code type="bash">

#!/bin/bash

su postgres

psql -d template1 -f /srv/www/htdocs/horde/scripts/sql/create.pgsql.sql

psql -d horde -f /srv/www/htdocs/horde/scripts/sql/horde_datatree.sql

psql -d horde -f /srv/www/htdocs/horde/scripts/sql/horde_vfs.pgsql.sql

psql -d horde -f /srv/www/htdocs/horde/scripts/sql/horde_users.sql

psql -d horde -f /srv/www/htdocs/horde/scripts/sql/horde_tokens.sql

psql -d horde -f /srv/www/htdocs/horde/scripts/sql/horde_sessionhandler.pgsql.sql

psql -d horde -f /srv/www/htdocs/horde/scripts/sql/horde_prefs.sql

psql -d horde -f /srv/www/htdocs/horde/scripts/sql/horde_log.sql

psql -d horde -f /srv/www/htdocs/horde/kronolith/scripts/sql/kronolith.pgsql.sql

psql -d horde -f /srv/www/htdocs/horde/mnemo/scripts/sql/mnemo.sql

psql -d horde -f /srv/www/htdocs/horde/nag/scripts/sql/nag.sql

psql -d horde -f /srv/www/htdocs/horde/rakim/scripts/sql/rakim.sql

psql -d horde -f /srv/www/htdocs/horde/turba/scripts/sql/turba_objects.pgsql.sql

psql -d horde -f /srv/www/htdocs/horde/vilma/scripts/sql/vilma.pgsql.sql

exit

</code>

On Redhat based distro



<code type="bash">

#!/bin/bash

su postgres

psql -d template1 -f /var/www/html/horde/scripts/sql/create.pgsql.sql

psql -d horde -f /var/www/html/horde/scripts/sql/horde_datatree.sql

psql -d horde -f /var/www/html/horde/scripts/sql/horde_vfs.pgsql.sql

psql -d horde -f /var/www/html/horde/scripts/sql/horde_users.sql

psql -d horde -f /var/www/html/horde/scripts/sql/horde_tokens.sql

psql -d horde -f /var/www/html/horde/scripts/sql/horde_sessionhandler.pgsql.sql

psql -d horde -f /var/www/html/horde/scripts/sql/horde_prefs.sql

psql -d horde -f /var/www/html/horde/scripts/sql/horde_log.sql

psql -d horde -f /var/www/html/horde/kronolith/scripts/sql/kronolith.pgsql.sql

psql -d horde -f /var/www/html/horde/mnemo/scripts/sql/mnemo.sql

psql -d horde -f /var/www/html/horde/nag/scripts/sql/nag.sql

psql -d horde -f /var/www/html/horde/rakim/scripts/sql/rakim.sql

psql -d horde -f /var/www/html/horde/turba/scripts/sql/turba_objects.pgsql.sql

psql -d horde -f /var/www/html/horde/vilma/scripts/sql/vilma.pgsql.sql

</code>



RemoveRemove the scripts for the modules not required.

 Default username is 'horde' and password is 'pass' change the scripts with your choice.

Jigish