FSAssetStore.migrations 446 B

123456789101112131415161718
  1. # -----------------
  2. :VERSION 1
  3. BEGIN;
  4. CREATE TABLE `fsassets` (
  5. `id` char(36) NOT NULL,
  6. `name` varchar(64) NOT NULL DEFAULT '',
  7. `description` varchar(64) NOT NULL DEFAULT '',
  8. `type` int(11) NOT NULL,
  9. `hash` char(80) NOT NULL,
  10. `create_time` int(11) NOT NULL DEFAULT '0',
  11. `access_time` int(11) NOT NULL DEFAULT '0',
  12. `asset_flags` int(11) NOT NULL DEFAULT '0',
  13. PRIMARY KEY (`id`)
  14. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  15. COMMIT;