OpenSim/Data/NHibernate/Resources/MySQLDialect/001_AssetStore.sql


1
2
3
4
5
6
7
8
9
10
11

CREATE TABLE Assets (
  ID VARCHAR(36) NOT NULL,
  MetadataID VARCHAR(36) NOT NULL,
  Type TINYINT DEFAULT NULL,
  Name VARCHAR(64) DEFAULT NULL,
  Description VARCHAR(64) DEFAULT NULL,
  Local BIT DEFAULT NULL,
  Temporary BIT DEFAULT NULL,
  Data LONGBLOB,
  PRIMARY KEY (ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1';