Subversion Repositories php_guestbook

Rev

Blame | Last modification | View Log | RSS feed

  1. -- Changes from 1.3 to 2.x
  2.  
  3. -- TODO: auch als php script
  4.  
  5. -- TODO: tesen
  6.  
  7. ALTER TABLE `page_gaestebuch` RENAME TO `gaestebuch_entries`;
  8. ALTER TABLE `gaestebuch_entries` MODIFY COLUMN `ip` VARCHAR(39);
  9. ALTER TABLE `gaestebuch_entries` DROP COLUMN `md5`;
  10. ALTER TABLE `gaestebuch_entries` ADD `timestamp` DATETIME NOT NULL AFTER `zeit`;
  11. UPDATE `gaestebuch_entries` SET `timestamp` = CONCAT(`datum`, ' ', `zeit`);
  12. ALTER TABLE `gaestebuch_entries` DROP `datum`, DROP `zeit`;
  13.  
  14. ALTER TABLE `page_gaestebuch_smilies` RENAME TO `gaestebuch_smileys`;
  15. ALTER TABLE `gaestebuch_smileys` ADD UNIQUE ( `zeichen` );
  16. ALTER TABLE `gaestebuch_smileys` CHANGE COLUMN `viewable` `enabled` enum('0','1') NOT NULL DEFAULT '0';
  17. ALTER TABLE `gaestebuch_smileys` ADD COLUMN `show_in_editor` enum('1','0') NOT NULL DEFAULT '1' AFTER `beschreibung`;
  18.