<?php

/**
 * Generated: 2014-03-24 15:01:35
 * @author Rtn_Module_Tool
 */
class Conference_Module_Initer_DB {

	static $sql_before = "
		SET foreign_key_checks = 0;
	";
	static $sql_after = "
		SET foreign_key_checks = 1;
	";

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

		$q = <<<EOF
			DROP TABLE IF EXISTS `conferencegroup`;
			CREATE TABLE `conferencegroup` (
			  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
			  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
			  `active` tinyint(1) unsigned DEFAULT NULL,
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
			DROP TABLE IF EXISTS `conferenceitem`;
			
			CREATE TABLE `conferenceitem` (
			  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
			  `conferencegroup_id` tinyint(3) unsigned DEFAULT NULL,
			  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
			  `body` varchar(4096) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
			  `dtpublished` datetime,
			  `extension` varchar(10) NULL,
			  `active` tinyint(1) unsigned DEFAULT NULL,
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
			
			CREATE OR REPLACE VIEW viewconferenceitem AS
			SELECT
				conferenceitem.*,
				conferencegroup.name AS groupname
			FROM
				conferenceitem
			JOIN
				conferencegroup ON (conferencegroup.id = conferenceitem.conferencegroup_id);


EOF;

		R::exec($q);

		empty(static::$sql_after) || R::exec(static::$sql_after);
	}

}