diff options
| author | Sean Dague | 2008-06-18 21:08:16 +0000 |
|---|---|---|
| committer | Sean Dague | 2008-06-18 21:08:16 +0000 |
| commit | b58dc7fb3320b8da2771d69921b7b8bb96e32806 (patch) | |
| tree | 7c4f85e819479ebce8718f5e16cb924109b213a0 /OpenSim/Data/NHibernate/Resources/MySQLDialect/001_AssetStore.sql | |
| parent | Mantis#1567. Thank you kindly, Dmiles for a patch that addresses: (diff) | |
| download | opensim-SC_OLD-b58dc7fb3320b8da2771d69921b7b8bb96e32806.zip opensim-SC_OLD-b58dc7fb3320b8da2771d69921b7b8bb96e32806.tar.gz opensim-SC_OLD-b58dc7fb3320b8da2771d69921b7b8bb96e32806.tar.bz2 opensim-SC_OLD-b58dc7fb3320b8da2771d69921b7b8bb96e32806.tar.xz | |
add mysql migrations for nhibernate driver
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 |