· 8 years ago · Jun 24, 2018, 02:06 AM
1<?php
2$installer = $this;
3$installer->startSetup();
4$installer->run("
5-- DROP TABLE IF EXISTS {$this->getTable('academy_informations/message')};
6CREATE TABLE {$this->getTable('academy_informations/message')} (
7 `message_id` int(11) unsigned NOT NULL auto_increment,
8 `content` text NOT NULL default '',
9 `created_time` datetime NULL,
10 `update_time` datetime NULL,
11 PRIMARY KEY (`message_id`)
12) ENGINE=InnoDB DEFAULT CHARSET=utf8;
13");
14$installer->endSetup();