001_AssetStore.sql 252 B

12345678910
  1. CREATE TABLE Assets (
  2. ID VARCHAR(36) NOT NULL,
  3. Type SMALLINT DEFAULT NULL,
  4. Name VARCHAR(64) DEFAULT NULL,
  5. Description VARCHAR(64) DEFAULT NULL,
  6. Local BOOLEAN DEFAULT NULL,
  7. Temporary BOOLEAN DEFAULT NULL,
  8. Data BYTEA,
  9. PRIMARY KEY (ID)
  10. );