diff options
Diffstat (limited to 'OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_AssetStore.sql')
-rw-r--r-- | OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_AssetStore.sql | 22 |
1 files changed, 9 insertions, 13 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_AssetStore.sql b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_AssetStore.sql index 07994f4..15e10b3 100644 --- a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_AssetStore.sql +++ b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_AssetStore.sql | |||
@@ -1,14 +1,10 @@ | |||
1 | BEGIN TRANSACTION; | 1 | CREATE TABLE Assets ( |
2 | 2 | ID VARCHAR(36) NOT NULL, | |
3 | create table Assets( | 3 | Type TINYINT DEFAULT NULL, |
4 | ID varchar(36) not null primary key, | 4 | Name VARCHAR(64) DEFAULT NULL, |
5 | Type int default 0, | 5 | Description VARCHAR(64) DEFAULT NULL, |
6 | InvType int default 0, | 6 | Local BIT DEFAULT NULL, |
7 | Name varchar(64), | 7 | Temporary BIT DEFAULT NULL, |
8 | Description varchar(64), | 8 | Data BLOB, |
9 | Local boolean, | 9 | PRIMARY KEY (ID) |
10 | Temporary boolean, | ||
11 | Data blob | ||
12 | ); | 10 | ); |
13 | |||
14 | END; \ No newline at end of file | ||