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


1
2
3
4
5
6
7
8
9
10
11

create table Assets (
   ID NVARCHAR(36) not null,
   MetadataID NVARCHAR(36) NOT NULL,  
   Type SMALLINT null,
   Name NVARCHAR(64) null,
   Description NVARCHAR(64) null,
   Local BIT null,
   Temporary BIT null,
   Data VARBINARY(max) null,
   primary key (ID)
)