1
0

sqlite_update_tf-b4rt-92.to.tf-b4rt-93.sql 884 B

12345678910111213141516171819202122232425262728293031
  1. -- -----------------------------------------------------------------------------
  2. -- $Id: sqlite_update_tf-b4rt-92.to.tf-b4rt-93.sql 2607 2007-03-09 19:33:07Z b4rt $
  3. -- -----------------------------------------------------------------------------
  4. --
  5. -- SQLite-Update-File for 'Torrentflux-2.1-b4rt-93'.
  6. -- Updates a 'Torrentflux 2.1-b4rt-92' Database to a 'Torrentflux 2.1-b4rt-93'.
  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. -- begin transaction
  13. --
  14. BEGIN TRANSACTION;
  15. --
  16. -- alter
  17. --
  18. ALTER TABLE tf_torrents ADD hash VARCHAR(40) DEFAULT '' NOT NULL;
  19. --
  20. -- inserts
  21. --
  22. INSERT INTO tf_settings VALUES ('enable_sorttable','1');
  23. INSERT INTO tf_settings VALUES ('drivespacebar','xfer');
  24. --
  25. -- commit
  26. --
  27. COMMIT;