mysql_update_tf-b4rt-8.to.tf-b4rt-81.sql 1.2 KB

12345678910111213141516171819202122232425262728293031
  1. -- -----------------------------------------------------------------------------
  2. -- $Id: mysql_update_tf-b4rt-8.to.tf-b4rt-81.sql 2607 2007-03-09 19:33:07Z b4rt $
  3. -- -----------------------------------------------------------------------------
  4. --
  5. -- MySQL-Update-File for 'Torrentflux-2.1-b4rt-81'.
  6. -- Updates a 'Torrentflux 2.1-b4rt-8' Database to a 'Torrentflux 2.1-b4rt-81'.
  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. -- tf_settings_user
  13. --
  14. CREATE TABLE tf_settings_user (
  15. uid INT(10) NOT NULL,
  16. tf_key VARCHAR(255) NOT NULL default '',
  17. tf_value TEXT NOT NULL
  18. ) TYPE=MyISAM;
  19. --
  20. -- inserts
  21. --
  22. INSERT INTO tf_settings VALUES ('enable_bigboldwarning','1');
  23. INSERT INTO tf_settings VALUES ('enable_goodlookstats','1');
  24. INSERT INTO tf_settings VALUES ('ui_displaylinks','1');
  25. INSERT INTO tf_settings VALUES ('ui_displayusers','1');
  26. INSERT INTO tf_settings VALUES ('xfer_total','0');
  27. INSERT INTO tf_settings VALUES ('xfer_month','0');
  28. INSERT INTO tf_settings VALUES ('xfer_week','0');
  29. INSERT INTO tf_settings VALUES ('xfer_day','0');