<?php
/**
 * Generated: 2014-03-12 11:08:42
 * @author Rtn_Module_Tool
 */

class Main_News_Module_Initer_DB {

	static $sql_before = "
		SET foreign_key_checks = 0;
		DROP TABLE newsentry;
-- przykład		DROP TABLE IF EXISTS role;
		SET foreign_key_checks = 1;
	";
	static $sql_after = "
-- przykład		ALTER TABLE  `role` ADD UNIQUE (  `name` );
-- przykład		ALTER TABLE `user` ADD UNIQUE `email` (`email`);
	";

	static function init() {
		empty(static::$sql_before) || R::exec(static::$sql_before);

		$sql = <<<EOF
			CREATE TABLE `newsentry` (
			  `id` int NOT NULL AUTO_INCREMENT PRIMARY KEY,
			  `active` tinyint NOT NULL,
			  `user_id` int(11) unsigned NOT NULL,
			  `dtpublished` datetime NOT NULL,
			  `title` varchar(128) NOT NULL,
			  `body` text NOT NULL,
			  FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
			) COMMENT=''; -- 0.249 s
			
			CREATE OR REPLACE VIEW viewnewsentry AS
			SELECT 
				newsentry.*,
				CONCAT(user.name,' ',user.surname) AS authorname
			FROM
				newsentry
			JOIN
				user ON (user.id = newsentry.user_id);
			
EOF;
		
		R::exec($sql);
		
		
		empty(static::$sql_after) || R::exec(static::$sql_after);
	}

}