diff options
Diffstat (limited to 'OpenSim/Data/NHibernate/Resources/MySQLDialect/001_AssetStore.sql')
-rw-r--r-- | OpenSim/Data/NHibernate/Resources/MySQLDialect/001_AssetStore.sql | 21 |
1 files changed, 11 insertions, 10 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_AssetStore.sql b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_AssetStore.sql index 6e0b61a..3484b64 100644 --- a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_AssetStore.sql +++ b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_AssetStore.sql | |||
@@ -1,14 +1,15 @@ | |||
1 | START TRANSACTION; | 1 | START TRANSACTION; |
2 | 2 | ||
3 | create table Assets( | 3 | CREATE TABLE `Assets` ( |
4 | ID varchar(36) not null primary key, | 4 | `ID` char(36) NOT NULL, |
5 | Type int default 0, | 5 | `Type` smallint(6) default NULL, |
6 | InvType int default 0, | 6 | `InvType` smallint(6) default NULL, |
7 | Name varchar(64), | 7 | `Name` varchar(64) default NULL, |
8 | Description varchar(64), | 8 | `Description` varchar(64) default NULL, |
9 | Local boolean, | 9 | `Local` tinyint(1) default NULL, |
10 | Temporary boolean, | 10 | `Temporary` tinyint(1) default NULL, |
11 | Data blob | 11 | `Data` longblob, |
12 | ); | 12 | PRIMARY KEY (`ID`) |
13 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | ||
13 | 14 | ||
14 | COMMIT; \ No newline at end of file | 15 | COMMIT; \ No newline at end of file |