AssetStore.migrations 589 B

123456789101112131415161718192021
  1. # -----------------
  2. :VERSION 10
  3. BEGIN;
  4. CREATE TABLE IF NOT EXISTS `assets` (
  5. `name` varchar(64) NOT NULL,
  6. `description` varchar(64) NOT NULL,
  7. `assetType` tinyint(4) NOT NULL,
  8. `local` tinyint(1) NOT NULL,
  9. `temporary` tinyint(1) NOT NULL,
  10. `data` longblob NOT NULL,
  11. `id` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
  12. `create_time` int(11) DEFAULT '0',
  13. `access_time` int(11) DEFAULT '0',
  14. `asset_flags` int(11) NOT NULL DEFAULT '0',
  15. `CreatorID` varchar(128) NOT NULL DEFAULT '',
  16. PRIMARY KEY (`id`)
  17. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  18. COMMIT;