aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_AssetStore.sql
blob: 3484b64e6f343e5e1b6c0aa893b90bc25268396a (plain)
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;