<?php

/**
 * Generated: 2014-03-07 16:36:44
 * @author Rtn_Module_Tool
 */
class Banner_Module_Initer_DB {

	static $sql_before = "
		SET foreign_key_checks = 0;
			DROP TABLE IF EXISTS bannerconfigs;
			DROP TALBE IF EXISTS bannerslides;
		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 public function createBannerConfigsTable(){
		R::exec('CREATE TABLE `bannerconfigs` (
			`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
			`attribute` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
			`value` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
			PRIMARY KEY (`id`)
		      ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;');

	}
	
	static public function createBannerSlidesTable(){
		R::exec("CREATE TABLE `bannerslides` (
			`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
			`extension` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
			`active` tinyint(1) unsigned NOT NULL DEFAULT '0',
			`order` int(11) unsigned NOT NULL,
			`link` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
			`last_slice_x` int(11) NOT NULL DEFAULT '0',
			`last_slice_y` int(11) NOT NULL DEFAULT '0',
			`last_slice_width` int(11) DEFAULT NULL,
			`last_slice_height` int(11) DEFAULT NULL,
			`url` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
			`created` datetime NOT NULL,
			`updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
			`is_available` int(1) NOT NULL DEFAULT '0',
			`slogan` varchar(220) COLLATE utf8_unicode_ci NOT NULL,
			`alt` varchar(220) COLLATE utf8_unicode_ci NOT NULL,
			PRIMARY KEY (`id`)
		      ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;");
	}

	
	static function init() {
		empty(static::$sql_before) || R::exec(static::$sql_before);
		
		static::createBannerConfigsTable();
		static::storeTimeoutInBannerConfigsTable();
		
		static::createBannerSlidesTable();

		empty(static::$sql_after) || R::exec(static::$sql_after);
	}
	
	static private function storeTimeoutInBannerConfigsTable(){
		$configTime = R::dispense('bannerconfigs');
		$configTime->attribute = 'timeout';
		$configTime->value = '4';
		R::store($configTime);
	}

}