XAssetStore.migrations 687 B

123456789101112131415161718192021222324252627
  1. # -----------------
  2. :VERSION 1
  3. BEGIN;
  4. CREATE TABLE `XAssetsMeta` (
  5. `ID` char(36) NOT NULL,
  6. `Hash` binary(32) NOT NULL,
  7. `Name` varchar(64) NOT NULL,
  8. `Description` varchar(64) NOT NULL,
  9. `AssetType` tinyint(4) NOT NULL,
  10. `Local` tinyint(1) NOT NULL,
  11. `Temporary` tinyint(1) NOT NULL,
  12. `CreateTime` int(11) NOT NULL,
  13. `AccessTime` int(11) NOT NULL,
  14. `AssetFlags` int(11) NOT NULL,
  15. `CreatorID` varchar(128) NOT NULL,
  16. PRIMARY KEY (`id`)
  17. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Version 1';
  18. CREATE TABLE `XAssetsData` (
  19. `Hash` binary(32) NOT NULL,
  20. `Data` longblob NOT NULL,
  21. PRIMARY KEY (`hash`)
  22. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Version 1';
  23. COMMIT;