diff options
author | Sean Dague | 2008-06-12 18:44:58 +0000 |
---|---|---|
committer | Sean Dague | 2008-06-12 18:44:58 +0000 |
commit | 202a4bec13a37d8a2f702f879a5e2b0d2e74085a (patch) | |
tree | f19f849a6d5f742e15100103defbf6b73d50559b /OpenSim/Data/MySQL/Resources/001_AssetStore.sql | |
parent | * minor: Remove and tidy duplicate 'storing object to scene' messages in log (diff) | |
download | opensim-SC-202a4bec13a37d8a2f702f879a5e2b0d2e74085a.zip opensim-SC-202a4bec13a37d8a2f702f879a5e2b0d2e74085a.tar.gz opensim-SC-202a4bec13a37d8a2f702f879a5e2b0d2e74085a.tar.bz2 opensim-SC-202a4bec13a37d8a2f702f879a5e2b0d2e74085a.tar.xz |
Fix mysql migrations. This is tested with an existing up to date schema,
and no schema. It should also work with a non up to date schema as well.
Btw, meetings in which I can get code done are the right kind of meetings.
Diffstat (limited to 'OpenSim/Data/MySQL/Resources/001_AssetStore.sql')
-rw-r--r-- | OpenSim/Data/MySQL/Resources/001_AssetStore.sql | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/OpenSim/Data/MySQL/Resources/001_AssetStore.sql b/OpenSim/Data/MySQL/Resources/001_AssetStore.sql index 2c750fe..6a9a127 100644 --- a/OpenSim/Data/MySQL/Resources/001_AssetStore.sql +++ b/OpenSim/Data/MySQL/Resources/001_AssetStore.sql | |||
@@ -1,3 +1,5 @@ | |||
1 | BEGIN; | ||
2 | |||
1 | CREATE TABLE `assets` ( | 3 | CREATE TABLE `assets` ( |
2 | `id` binary(16) NOT NULL, | 4 | `id` binary(16) NOT NULL, |
3 | `name` varchar(64) NOT NULL, | 5 | `name` varchar(64) NOT NULL, |
@@ -8,4 +10,6 @@ CREATE TABLE `assets` ( | |||
8 | `temporary` tinyint(1) NOT NULL, | 10 | `temporary` tinyint(1) NOT NULL, |
9 | `data` longblob NOT NULL, | 11 | `data` longblob NOT NULL, |
10 | PRIMARY KEY (`id`) | 12 | PRIMARY KEY (`id`) |
11 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1'; \ No newline at end of file | 13 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1'; |
14 | |||
15 | COMMIT; \ No newline at end of file | ||