# -----------------
:VERSION 1

BEGIN;

CREATE TABLE IF NOT EXISTS `fsassets` (
  `id` char(36) NOT NULL,
  `name` varchar(64) NOT NULL DEFAULT '',
  `description` varchar(64) NOT NULL DEFAULT '',
  `type` int(11) NOT NULL,
  `hash` char(80) NOT NULL,
  `create_time` int(11) NOT NULL DEFAULT '0',
  `access_time` int(11) NOT NULL DEFAULT '0',
  `asset_flags` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

COMMIT;