aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_AssetStore.sql
blob: 95737815a49db3d1dc231152de7d207131b9b0a0 (plain)
1
2
3
4
5
6
7
8
9
10
CREATE TABLE Assets (
  ID 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';