diff options
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 | ||