SELECT nd.title, nd.timestamp, nd.textnews, nt.tag, na.authorName, na.email, ni.img
FROM newszapros nz
INNER  JOIN NewsData nd ON nd.id_news = nz.id_news
INNER  JOIN NewsAuthors na ON na.id_author = nz.id_author
INNER  JOIN NewsTag nt ON nt.id_tag = nz.id_tag
INNER  JOIN NewsImg ni ON ni.id_img = nz.id_img

INSERT INTO `NewsData` SET 
			`title`='title',
			`timestamp` ='1',
			`textnews` ='body';
INSERT INTO `NewsTag` SET 
			`tag`='tag';
INSERT INTO `NewsAuthors` SET 
			`authorName`='authorName',
            `email`='email';
INSERT INTO `NewsImg` SET 
			`img`='img'; 

/*таблица - данные*/
CREATE TABLE IF NOT EXISTS `NewsData` (
    `id_news` 		 INT UNSIGNED NOT NULL AUTO_INCREMENT,
	`title` 		 text NOT NULL,										/*заголовок*/
	`textnews` 		 text NOT NULL,										/*сама новость*/
	`hide` 			 int(1) NOT NULL default '0',						/*скрыта/открыта новость дл¤ всех*/
	`prioritet_news` int(6) default null,								/*приоритет новости 0 - обычно, 1 в самом вверху выводитс¤*/
	`timestamp` 	 datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,	/*время размещени¤*/
	PRIMARY KEY (id_news)												/*главный ключ ID*/
)ENGINE=INNODB  DEFAULT CHARSET=UTF8 COLLATE=utf8_unicode_ci;

/*таблица - автор*/
CREATE TABLE NewsAuthors (
	`id_author` 	INT UNSIGNED NOT NULL AUTO_INCREMENT,
	`authorName` 	varchar(100) NOT NULL default '',
	`email` 		varchar(255),	
	PRIMARY KEY 	(id_author)
)ENGINE=INNODB  DEFAULT CHARSET=UTF8 COLLATE=utf8_unicode_ci;
 
 /* таблица - таг*/
CREATE TABLE IF NOT EXISTS `NewsTag` (
	`id_tag` 			INT UNSIGNED NOT NULL auto_increment,		/*уникальный ID*/
	`tag` 				text NOT NULL,										/*заголовок*/
	PRIMARY KEY (id_tag)												/*главный ключ ID*/
)ENGINE=INNODB  DEFAULT CHARSET=UTF8 COLLATE=utf8_unicode_ci;

  /* таблица картинки */
CREATE TABLE IF NOT EXISTS `NewsImg` (
	`id_img` INT UNSIGNED NOT NULL AUTO_INCREMENT,				/*уникальный ID*/
	`img` 	 varchar(255) NOT NULL,							/*картинка*/									
	PRIMARY KEY (id_img)									/*главный ключ ID*/
)ENGINE=INNODB  DEFAULT CHARSET=UTF8 COLLATE=utf8_unicode_ci;

/*таблица запрос*/
CREATE TABLE newsZapros (
	id_tableZapros 	INT UNSIGNED NOT NULL AUTO_INCREMENT,
    id_news   		INT UNSIGNED NOT NULL,
    id_author  		INT UNSIGNED NOT NULL,
    id_tag 			INT UNSIGNED NOT NULL,
    id_img 			INT UNSIGNED NOT NULL,
    PRIMARY KEY(id_tableZapros),
    FOREIGN KEY (id_news) 	REFERENCES NewsData(id_news) ON DELETE CASCADE ON UPDATE CASCADE,
    FOREIGN KEY (id_author) REFERENCES NewsAuthors(id_author) ON DELETE CASCADE ON UPDATE CASCADE,
	FOREIGN KEY (id_tag) 	REFERENCES NewsTag(id_tag) ON DELETE CASCADE ON UPDATE CASCADE,
	FOREIGN KEY (id_img) 	REFERENCES NewsImg(id_img) ON DELETE CASCADE ON UPDATE CASCADE
)ENGINE=INNODB  DEFAULT CHARSET=UTF8 COLLATE=utf8_unicode_ci;
/* т.е. связываем параметр из таблицы  id_news  с таблицей NewsData и  её параметром id_news*/

INSERT INTO `NewsTag` SET 
			`tag`='tag';
SET @TagID = LAST_INSERT_ID();
INSERT INTO `NewsAuthors` SET 
			`authorName`='authorName',
            `email`='email';
SET @AuthID = LAST_INSERT_ID();
INSERT INTO `NewsImg` SET 
			`img`='img'; 
SET @ImgID = LAST_INSERT_ID();
INSERT INTO `NewsData` SET 
			`title`='title',
			`timestamp` ='1',
			`textnews` ='body';
SET @NewsDataID = LAST_INSERT_ID();
INSERT INTO newszapros SET
	id_news = @NewsDataID,
    id_author =  @AuthID,
    id_tag = @TagID,
    id_img = @ImgID;

/* новости */
CREATE TABLE IF NOT EXISTS `NewsData` (
    `id_news` 		 INT UNSIGNED NOT NULL AUTO_INCREMENT,
	`title` 		 varchar(255) NOT NULL,										
	`textnews` 		 varchar(255) NOT NULL,										
	`hide` 			 int(1) NOT NULL default '0',						
	`prioritet_news` int(6) default null,	
	`author` 		 varchar(255) NOT NULL UNIQUE default '',	
	`tag` 			 varchar(255) NOT NULL UNIQUE,	
	`img` 	 		 varchar(255) NOT NULL UNIQUE,				
	`timestamp` 	 datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,	
	PRIMARY KEY (id_news)
)ENGINE=INNODB  DEFAULT CHARSET=UTF8 COLLATE=utf8_unicode_ci;
ALTER TABLE `newsauthors`
  ADD CONSTRAINT `newsauthors_ibfk_1` FOREIGN KEY (`author`) REFERENCES `newsdata` (`author`) ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE `newsimg`
  ADD CONSTRAINT `newsimg_ibfk_1` FOREIGN KEY (`img`) REFERENCES `newsdata` (`img`) ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE `newstag`
  ADD CONSTRAINT `newstag_ibfk_1` FOREIGN KEY (`tag`) REFERENCES `newsdata` (`tag`) ON DELETE CASCADE ON UPDATE CASCADE;