diff options
| author | Charles Krinke | 2009-01-12 20:14:39 +0000 |
|---|---|---|
| committer | Charles Krinke | 2009-01-12 20:14:39 +0000 |
| commit | c00c855cc5decf73d598af5d74a2ef57c547efd3 (patch) | |
| tree | 03a6e3622db531537c2cfb47a99acd5edf4fe6b7 /OpenSim/Data/NHibernate/Resources/MySQLDialect/001_AssetStore.sql | |
| parent | * Separate starting a client thread into a separate Start() method (which mat... (diff) | |
| download | opensim-SC_OLD-c00c855cc5decf73d598af5d74a2ef57c547efd3.zip opensim-SC_OLD-c00c855cc5decf73d598af5d74a2ef57c547efd3.tar.gz opensim-SC_OLD-c00c855cc5decf73d598af5d74a2ef57c547efd3.tar.bz2 opensim-SC_OLD-c00c855cc5decf73d598af5d74a2ef57c547efd3.tar.xz | |
Thank you kindly, Tlaukkan (Tommil) for a patch that:
Cleaned up schema creation scripts of MySQL to compliant form and created
SQLite scripts from them. In future it would be optimal if scripts from
different databases could be generated from MySQL scripts to ensure optimal
consistency between schemas of different databases. Did not yet review
column names. ID columns seem to have variety in naming which can be confusing.
Diffstat (limited to 'OpenSim/Data/NHibernate/Resources/MySQLDialect/001_AssetStore.sql')
| -rw-r--r-- | OpenSim/Data/NHibernate/Resources/MySQLDialect/001_AssetStore.sql | 25 |
1 files changed, 10 insertions, 15 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_AssetStore.sql b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_AssetStore.sql index 3484b64..9573781 100644 --- a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_AssetStore.sql +++ b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_AssetStore.sql | |||
| @@ -1,15 +1,10 @@ | |||
| 1 | START TRANSACTION; | 1 | CREATE TABLE Assets ( |
| 2 | 2 | ID VARCHAR(36) NOT NULL, | |
| 3 | CREATE TABLE `Assets` ( | 3 | Type TINYINT DEFAULT NULL, |
| 4 | `ID` char(36) NOT NULL, | 4 | Name VARCHAR(64) DEFAULT NULL, |
| 5 | `Type` smallint(6) default NULL, | 5 | Description VARCHAR(64) DEFAULT NULL, |
| 6 | `InvType` smallint(6) default NULL, | 6 | Local BIT DEFAULT NULL, |
| 7 | `Name` varchar(64) default NULL, | 7 | Temporary BIT DEFAULT NULL, |
| 8 | `Description` varchar(64) default NULL, | 8 | Data LONGBLOB, |
| 9 | `Local` tinyint(1) default NULL, | 9 | PRIMARY KEY (ID) |
| 10 | `Temporary` tinyint(1) default NULL, | 10 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1'; |
| 11 | `Data` longblob, | ||
| 12 | PRIMARY KEY (`ID`) | ||
| 13 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | ||
| 14 | |||
| 15 | COMMIT; \ No newline at end of file | ||