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) )