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


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

BEGIN TRANSACTION;

create table Assets(
       ID varchar(36) not null primary key,
       Type int default 0,
       InvType int default 0,
       Name varchar(64),
       Description varchar(64),
       Local boolean,
       Temporary boolean,
       Data blob
);

END;