public function __construct() { //创建migration表用于记录动作 if (!Schema::tableExists('migrations')) { $sql = "CREATE TABLE " . c('database.prefix') . 'migrations(migration varchar(255) not null,batch int)CHARSET UTF8'; Db::execute($sql); } if (empty(self::$batch)) { self::$batch = Db::table('migrations')->max('batch') ?: 0; } }
public function cache() { $table = c('database.prefix') . c('cache.mysql.table'); if (Schema::tableExists(c('cache.mysql.table'))) { $this->error('Table already exists'); } $sql = <<<sql CREATE TABLE `{$table}` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` char(20) DEFAULT NULL, `data` mediumtext, `create_at` int(10), `expire` int(10), PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; sql; Schema::sql($sql); }