Geeklog Forums

CREATE TABLE `gl_forum_topic` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `forum` int(3) NOT NULL DEFAULT '0',
 ...
  `date` varchar(12) DEFAULT NULL,
  `lastupdated` varchar(12) DEFAULT NULL,
  ...

SELECT FROM_UNIXTIME(date) AS mydate FROM gl_forum_topic;

CREATE ALGORITHM=UNDEFINED DEFINER=`me`@`localhost` SQL SECURITY DEFINER VIEW `v_forum_posts` AS
SELECT
  `gl_forum_forums`.`forum_name`    AS `forum_name`,
  `gl_forum_topic`.`name`           AS `name`,
  FROM_UNIXTIME(`gl_forum_topic`.`name`) AS `date`,
  FROM_UNIXTIME(`gl_forum_topic`.`lastupdated`) AS `lastupdated`,
  `gl_forum_topic`.`last_reply_rec` AS `last_reply_rec`,
  `gl_forum_topic`.`subject`        AS `subject`,
  `gl_forum_topic`.`comment`        AS `comment`,
  `gl_forum_topic`.`replies`        AS `replies`,
  `gl_forum_topic`.`views`          AS `views`,
  `gl_forum_topic`.`id`             AS `id`
FROM (`gl_forum_forums`
   JOIN `gl_forum_topic`
     ON ((`gl_forum_forums`.`forum_id` = `gl_forum_topic`.`forum`)))
ORDER BY `gl_forum_forums`.`forum_name`,`gl_forum_topic`.`id`

CREATE ALGORITHM=UNDEFINED DEFINER=`user`@`localhost` SQL SECURITY DEFINER VIEW `v_forum_posts` AS
select
  `a`.`forum_name`     AS `forum_name`,
  `b`.`id`             AS `id`,
  `b`.`name`           AS `name`,
  from_unixtime(`b`.`lastupdated`) AS `lastupdated`,
  from_unixtime(`b`.`date`) AS `date`,
  `b`.`last_reply_rec` AS `last_reply_rec`,
  `b`.`subject`        AS `subject`,
  `b`.`comment`        AS `comment`,
  `b`.`replies`        AS `replies`,
  `b`.`views`          AS `views`
from (`gl_forum_forums` `a`
   join `gl_forum_topic` `b`)
where (`a`.`forum_id` = `b`.`forum`)
order by `a`.`forum_name`,`b`.`id`