# MySQL-Front Dump  2 . 5 
#
# Host: localhost   Database: test
# --------------------------------------------------------
# Server version  4 . 0 . 18 -max-nt

USE test;


#
# Table structure for table 'forum'
#

DROP TABLE IF EXISTS `forum`;
CREATE TABLE `forum` (
  `frm_id` int( 10 ) unsigned NOT NULL auto_increment,
  `frm_name` varchar( 120 ) NOT NULL default '',
  `frm_site_name` varchar( 64 ) default NULL,
  `frm_descr` text,
  `frm_order` int( 4 ) unsigned NOT NULL default '0',
  PRIMARY KEY  (`frm_id`),
  KEY `frm_site_name_idx` (`frm_site_name`)
) TYPE=MyISAM;



#
# Dumping data for table 'forum'
#

INSERT INTO `forum` (`frm_id`, `frm_name`, `frm_site_name`, `frm_descr`, `frm_order`) VALUES("1", "Форум 1", "forum_1", "Описание форума 1", "1");


#
# Table structure for table 'post'
#

DROP TABLE IF EXISTS `post`;
CREATE TABLE `post` (
  `pst_id` int( 10 ) unsigned NOT NULL auto_increment,
  `tpc_id` int( 10 ) unsigned default NULL,
  `pst_name` varchar( 255 ) default NULL,
  `pst_body` text,
  `pst_date` datetime default NULL,
  `usr_id` int( 10 ) unsigned default NULL,
  `pst_author` varchar( 32 ) default NULL,
  `pst_ip` bigint( 16 ) default NULL,
  PRIMARY KEY  (`pst_id`),
  KEY `usr_id_idx` (`usr_id`),
  KEY `tpc_id_idx` (`tpc_id`)
) TYPE=MyISAM;



#
# Dumping data for table 'post'
#

INSERT INTO `post` (`pst_id`, `tpc_id`, `pst_name`, `pst_body`, `pst_date`, `usr_id`, `pst_author`, `pst_ip`) VALUES("1", "1", NULL, NULL, "2005-11-11 11:11:11", "1", NULL, NULL);
INSERT INTO `post` (`pst_id`, `tpc_id`, `pst_name`, `pst_body`, `pst_date`, `usr_id`, `pst_author`, `pst_ip`) VALUES("2", "1", NULL, NULL, "2005-11-11 11:11:22", "1", NULL, NULL);
INSERT INTO `post` (`pst_id`, `tpc_id`, `pst_name`, `pst_body`, `pst_date`, `usr_id`, `pst_author`, `pst_ip`) VALUES("3", "2", NULL, NULL, "2005-12-12 12:12:12", "1", NULL, NULL);
INSERT INTO `post` (`pst_id`, `tpc_id`, `pst_name`, `pst_body`, `pst_date`, `usr_id`, `pst_author`, `pst_ip`) VALUES("4", "1", NULL, NULL, "2005-12-12 12:12:20", "1", NULL, NULL);


#
# Table structure for table 'topic'
#

DROP TABLE IF EXISTS `topic`;
CREATE TABLE `topic` (
  `tpc_id` int( 10 ) unsigned NOT NULL auto_increment,
  `frm_id` int( 10 ) unsigned NOT NULL default '0',
  `tpc_name` varchar( 255 ) default NULL,
  `tpc_date` datetime default NULL,
  `usr_id` int( 10 ) unsigned default NULL,
  `tpc_usr_name` varchar( 255 ) default NULL,
  `tpc_is_hide` tinyint( 1 ) unsigned default '0',
  `tpc_cnt_view` int( 10 ) unsigned default '1',
  `tpc_cnt_answer` int( 10 ) unsigned default '0',
  `tpc_is_sticky` tinyint( 1 ) unsigned default '0',
  PRIMARY KEY  (`tpc_id`),
  KEY `frm_id_idx` (`frm_id`),
  KEY `usr_id_idx` (`usr_id`)
) TYPE=MyISAM;



#
# Dumping data for table 'topic'
#

INSERT INTO `topic` (`tpc_id`, `frm_id`, `tpc_name`, `tpc_date`, `usr_id`, `tpc_usr_name`, `tpc_is_hide`, `tpc_cnt_view`, `tpc_cnt_answer`, `tpc_is_sticky`) VALUES("1", "1", "Топик 1", "2005-11-11 11:11:11", "1", NULL, "0", "1", "0", "0");
INSERT INTO `topic` (`tpc_id`, `frm_id`, `tpc_name`, `tpc_date`, `usr_id`, `tpc_usr_name`, `tpc_is_hide`, `tpc_cnt_view`, `tpc_cnt_answer`, `tpc_is_sticky`) VALUES("2", "1", "Топик 2", "2005-12-12 12:12:12", "1", NULL, "0", "1", "0", "0");

SELECT usr.usr_name,frm.frm_name, tpc.*  from port_topic tpc
      inner join port_forum frm on frm.frm_id=tpc.frm_id
      left join users usr on usr.usr_id=tpc.usr_id
      where  1 = 1   AND frm.frm_site_name='dial-up' AND  (tpc_is_hide= 0  or tpc.usr_id= 0 ) 
      order by tpc_is_sticky desc, tpc_date desc