mysql_update_tf-b4rt-85.to.tf-b4rt-9.sql 1.7 KB

1234567891011121314151617181920212223242526272829303132333435363738
  1. -- -----------------------------------------------------------------------------
  2. -- $Id: mysql_update_tf-b4rt-85.to.tf-b4rt-9.sql 2607 2007-03-09 19:33:07Z b4rt $
  3. -- -----------------------------------------------------------------------------
  4. --
  5. -- MySQL-Update-File for 'Torrentflux-2.1-b4rt-9'.
  6. -- Updates a 'Torrentflux 2.1-b4rt-85' Database to a 'Torrentflux 2.1-b4rt-9'.
  7. --
  8. -- This Stuff is provided 'as-is'. In no way will the author be held
  9. -- liable for any damages to your soft- or hardware from this.
  10. -- -----------------------------------------------------------------------------
  11. --
  12. -- deletes
  13. --
  14. DELETE FROM tf_settings WHERE tf_key = 'enable_basicauth';
  15. DELETE FROM tf_settings WHERE tf_key = 'enable_rememberme';
  16. --
  17. -- inserts
  18. --
  19. INSERT INTO tf_settings VALUES ('Qmgr_path','/var/www/Qmgr');
  20. INSERT INTO tf_settings VALUES ('Qmgr_maxUserTorrents','2');
  21. INSERT INTO tf_settings VALUES ('Qmgr_maxTotalTorrents','5');
  22. INSERT INTO tf_settings VALUES ('Qmgr_perl','/usr/bin/perl');
  23. INSERT INTO tf_settings VALUES ('Qmgr_fluxcli','/var/www');
  24. INSERT INTO tf_settings VALUES ('Qmgr_host','localhost');
  25. INSERT INTO tf_settings VALUES ('Qmgr_port','2606');
  26. INSERT INTO tf_settings VALUES ('auth_type','0');
  27. INSERT INTO tf_settings VALUES ('index_page_connections','1');
  28. INSERT INTO tf_settings VALUES ('index_page_stats','1');
  29. INSERT INTO tf_settings VALUES ('index_page_sortorder','dd');
  30. INSERT INTO tf_settings VALUES ('index_page','b4rt');
  31. INSERT INTO tf_settings VALUES ('index_page_settings','1266');
  32. INSERT INTO tf_settings VALUES ('enable_move','0');
  33. INSERT INTO tf_settings VALUES ('enable_rename','1');
  34. INSERT INTO tf_settings VALUES ('move_paths','');
  35. INSERT INTO tf_settings VALUES ('bin_sockstat','/usr/bin/sockstat');