001_AssetStore.sql 375 B

123456789101112131415
  1. BEGIN;
  2. CREATE TABLE `assets` (
  3. `id` binary(16) NOT NULL,
  4. `name` varchar(64) NOT NULL,
  5. `description` varchar(64) NOT NULL,
  6. `assetType` tinyint(4) NOT NULL,
  7. `invType` tinyint(4) NOT NULL,
  8. `local` tinyint(1) NOT NULL,
  9. `temporary` tinyint(1) NOT NULL,
  10. `data` longblob NOT NULL,
  11. PRIMARY KEY (`id`)
  12. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1';
  13. COMMIT;