<?phpclass ModelBlogOcblog extends Model {    public function install() {        $this->db->query("			CREATE TABLE IF NOT EXISTS `" . DB_PREFIX . "article` (			    `article_id` INT(11) NOT NULL AUTO_INCREMENT,	            `sort_order` INT(11) NOT NULL DEFAULT '0',	            `status` TINYINT(1) NOT NULL DEFAULT '0',	            `date_added` DATETIME NOT NULL,	            `date_modified` DATETIME NOT NULL,	        PRIMARY KEY (`article_id`)		) DEFAULT COLLATE=utf8_general_ci;");        $this->db->query("			CREATE TABLE IF NOT EXISTS `" . DB_PREFIX . "article_description` (			    `article_id` INT(11) NOT NULL,                `language_id` INT(11) NOT NULL,                `name` VARCHAR(255) NOT NULL,                `description` TEXT NOT NULL,                `intro_text` TEXT NOT NULL,                `meta_title` VARCHAR(255) NOT NULL,                `meta_description` VARCHAR(255) NOT NULL,                `meta_keyword` VARCHAR(255) NOT NULL,            PRIMARY KEY (`article_id`, `language_id`),	        INDEX `name` (`name`)		) DEFAULT COLLATE=utf8_general_ci;");        $this->db->query("			CREATE TABLE IF NOT EXISTS `" . DB_PREFIX . "article_list` (			    `article_list_id` INT(11) NOT NULL AUTO_INCREMENT,                `name` VARCHAR(255) NOT NULL,                `status` TINYINT(1) NOT NULL DEFAULT '0',            PRIMARY KEY (`article_list_id`),	        INDEX `name` (`name`)		) DEFAULT COLLATE=utf8_general_ci;");        $this->db->query("			CREATE TABLE IF NOT EXISTS `" . DB_PREFIX . "article_to_list` (			    `article_list_id` INT(11) NOT NULL,                `article_id` INT(11) NOT NULL		) DEFAULT COLLATE=utf8_general_ci;");        $this->db->query("			CREATE TABLE IF NOT EXISTS `" . DB_PREFIX . "article_to_store` (			    `article_id` INT(11) NOT NULL,                `store_id` INT(11) NOT NULL		) DEFAULT COLLATE=utf8_general_ci;");        $this->updateImageToTable();        $this->updateAuthorToTable();    }	public function updateImageToTable() {		$check_sql = "SHOW COLUMNS FROM `" . DB_PREFIX . "article` LIKE 'image'";        $query = $this->db->query($check_sql);        if($query->rows) {            return;        } else {            $sql = "ALTER TABLE `" . DB_PREFIX . "article` ADD `image` varchar(255) DEFAULT NULL";            $this->db->query($sql);            return;        }	}		public function updateAuthorToTable() {		$check_sql = "SHOW COLUMNS FROM `" . DB_PREFIX . "article` LIKE 'author'";        $query = $this->db->query($check_sql);        if($query->rows) {            return;        } else {            $sql = "ALTER TABLE `" . DB_PREFIX . "article` ADD `author` varchar(100) DEFAULT NULL";            $this->db->query($sql);            return;        }	}	    public function uninstall() {        $this->db->query("DROP TABLE IF EXISTS `" . DB_PREFIX . "article`");        $this->db->query("DROP TABLE IF EXISTS `" . DB_PREFIX . "article_description`");        $this->db->query("DROP TABLE IF EXISTS `" . DB_PREFIX . "article_list`");        $this->db->query("DROP TABLE IF EXISTS `" . DB_PREFIX . "article_to_list`");        $this->db->query("DROP TABLE IF EXISTS `" . DB_PREFIX . "article_to_store`");        $this->db->query("DELETE FROM `" . DB_PREFIX . "setting` WHERE `code` = 'module_ocblog'");    }}