diff options
| author | onefang | 2019-05-19 21:56:12 +1000 |
|---|---|---|
| committer | onefang | 2019-05-19 21:56:12 +1000 |
| commit | d6bcc229eba25ae240322f48ea3f31b832d55ab4 (patch) | |
| tree | 7235d35cc1065352e443951fec44c7aadcb4fdfe /OpenSim/Data/MySQL/Resources/FSAssetStore.migrations | |
| parent | Dump OpenSim 0.9.0.1 into it's own branch. (diff) | |
| download | opensim-SC_OLD-d6bcc229eba25ae240322f48ea3f31b832d55ab4.zip opensim-SC_OLD-d6bcc229eba25ae240322f48ea3f31b832d55ab4.tar.gz opensim-SC_OLD-d6bcc229eba25ae240322f48ea3f31b832d55ab4.tar.bz2 opensim-SC_OLD-d6bcc229eba25ae240322f48ea3f31b832d55ab4.tar.xz | |
Various database fixups.
InnoDB -> MyISAM
utf8
if not exists
white space
Diffstat (limited to 'OpenSim/Data/MySQL/Resources/FSAssetStore.migrations')
| -rw-r--r-- | OpenSim/Data/MySQL/Resources/FSAssetStore.migrations | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/OpenSim/Data/MySQL/Resources/FSAssetStore.migrations b/OpenSim/Data/MySQL/Resources/FSAssetStore.migrations index 87d08c6..3f65d9e 100644 --- a/OpenSim/Data/MySQL/Resources/FSAssetStore.migrations +++ b/OpenSim/Data/MySQL/Resources/FSAssetStore.migrations | |||
| @@ -3,7 +3,7 @@ | |||
| 3 | 3 | ||
| 4 | BEGIN; | 4 | BEGIN; |
| 5 | 5 | ||
| 6 | CREATE TABLE `fsassets` ( | 6 | CREATE TABLE IF NOT EXISTS `fsassets` ( |
| 7 | `id` char(36) NOT NULL, | 7 | `id` char(36) NOT NULL, |
| 8 | `name` varchar(64) NOT NULL DEFAULT '', | 8 | `name` varchar(64) NOT NULL DEFAULT '', |
| 9 | `description` varchar(64) NOT NULL DEFAULT '', | 9 | `description` varchar(64) NOT NULL DEFAULT '', |
| @@ -13,6 +13,6 @@ CREATE TABLE `fsassets` ( | |||
| 13 | `access_time` int(11) NOT NULL DEFAULT '0', | 13 | `access_time` int(11) NOT NULL DEFAULT '0', |
| 14 | `asset_flags` int(11) NOT NULL DEFAULT '0', | 14 | `asset_flags` int(11) NOT NULL DEFAULT '0', |
| 15 | PRIMARY KEY (`id`) | 15 | PRIMARY KEY (`id`) |
| 16 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | 16 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
| 17 | 17 | ||
| 18 | COMMIT; \ No newline at end of file | 18 | COMMIT; |