aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/Resources/FSAssetStore.migrations
diff options
context:
space:
mode:
authoronefang2020-07-31 01:43:03 +1000
committeronefang2020-07-31 01:43:03 +1000
commit78c5071a8f664191c7c837279f7445e280daccf9 (patch)
tree7ed95d289b389a1ec659e6281215a584cc3713fd /OpenSim/Data/MySQL/Resources/FSAssetStore.migrations
parentRemove useless .csproj files. (diff)
downloadopensim-SC-78c5071a8f664191c7c837279f7445e280daccf9.zip
opensim-SC-78c5071a8f664191c7c837279f7445e280daccf9.tar.gz
opensim-SC-78c5071a8f664191c7c837279f7445e280daccf9.tar.bz2
opensim-SC-78c5071a8f664191c7c837279f7445e280daccf9.tar.xz
Various database fixups.
InnoDB -> MyISAM utf8 if not exists white space
Diffstat (limited to '')
-rw-r--r--OpenSim/Data/MySQL/Resources/FSAssetStore.migrations6
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
4BEGIN; 4BEGIN;
5 5
6CREATE TABLE `fsassets` ( 6CREATE 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
18COMMIT; \ No newline at end of file 18COMMIT;