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


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

START TRANSACTION;

CREATE TABLE `Assets` (
  `ID` char(36) NOT NULL,
  `Type` smallint(6) default NULL,
  `InvType` smallint(6) default NULL,
  `Name` varchar(64) default NULL,
  `Description` varchar(64) default NULL,
  `Local` tinyint(1) default NULL,
  `Temporary` tinyint(1) default NULL,
  `Data` longblob,
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

COMMIT;