<?php

namespace Podlove\Model;

class FileType extends Base
{
    public function title()
    {
        return $this->name . ' (' . $this->extension . ')';
    }
    public static function get_types()
    {
        global $wpdb;
        return $wpdb->get_col("SELECT DISTINCT `type` FROM " . FileType::table_name());
    }
}
FileType::property('id', 'INT NOT NULL AUTO_INCREMENT PRIMARY KEY');
FileType::property('name', 'VARCHAR(255)');
FileType::property('type', 'VARCHAR(255)');
FileType::property('mime_type', 'VARCHAR(255)');
FileType::property('extension', 'VARCHAR(255)');