1
0

CreateAssetsTable.sql 358 B

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