wat

-- --------------------------------------------------------
-- Host:                         127.0.0.1
-- Server version:               5.5.28-29.1 - Percona Server (GPL), Release 29.1
-- Server OS:                    Linux
-- HeidiSQL version:             7.0.0.4053
-- Date/time:                    2012-11-05 23:42:41
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET FOREIGN_KEY_CHECKS=0 */;

-- Dumping structure for event test_forum.delete_old_registry_topics_read
DELIMITER //
CREATE DEFINER=`root`@`localhost` EVENT `delete_old_registry_topics_read` ON SCHEDULE EVERY 1 MONTH STARTS '2012-11-05 23:21:30' ON COMPLETION PRESERVE ENABLE DO BEGIN
    DELETE FROM `registry_topics_read` WHERE `user_id` IN (SELECT `id` FROM `users` WHERE `last_visit`<(SUBTIME(NOW(),'60 00:00:00')));
END//
DELIMITER ;


-- Dumping structure for table test_forum.forum_topics
CREATE TABLE IF NOT EXISTS `forum_topics` (
  `id` INT(10) NOT NULL AUTO_INCREMENT,
  `forum_id` INT(10) NOT NULL DEFAULT '0',
  `title` VARCHAR(255) NOT NULL DEFAULT '0',
  `last_update` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `forum_id` (`forum_id`),
  KEY `last_update` (`last_update`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Data exporting was unselected.


-- Dumping structure for table test_forum.registry_topics_read
CREATE TABLE IF NOT EXISTS `registry_topics_read` (
  `topic_id` INT(10) UNSIGNED NOT NULL,
  `user_id` INT(10) UNSIGNED NOT NULL,
  `read_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  KEY `topic_id` (`topic_id`),
  KEY `user_id` (`user_id`),
  KEY `read_date` (`read_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Data exporting was unselected.


-- Dumping structure for table test_forum.users
CREATE TABLE IF NOT EXISTS `users` (
  `id` INT(10) NOT NULL,
  `registered` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `last_read_all` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  `last_visit` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `registered` (`registered`),
  KEY `last_read_all` (`last_read_all`),
  KEY `last_visit` (`last_visit`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Data exporting was unselected.


-- Dumping structure for trigger test_forum.delete_read
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='';
DELIMITER //
CREATE TRIGGER `delete_read` BEFORE UPDATE ON `forum_topics` FOR EACH ROW BEGIN
    DELETE QUICK FROM `registry_topics_read` WHERE `topic_id`= NEW.id;
END//
DELIMITER ;
SET SQL_MODE=@OLD_SQL_MODE;


-- Dumping structure for trigger test_forum.user_create
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='';
DELIMITER //
CREATE TRIGGER `user_create` BEFORE INSERT ON `users` FOR EACH ROW BEGIN
    SET NEW.last_read_all = NOW();
END//
DELIMITER ;
SET SQL_MODE=@OLD_SQL_MODE;
/*!40014 SET FOREIGN_KEY_CHECKS=1 */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;