aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/NHibernate/Resources/MySQLDialect
diff options
context:
space:
mode:
Diffstat (limited to 'OpenSim/Data/NHibernate/Resources/MySQLDialect')
-rw-r--r--OpenSim/Data/NHibernate/Resources/MySQLDialect/001_AssetStore.sql14
1 files changed, 14 insertions, 0 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_AssetStore.sql b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_AssetStore.sql
new file mode 100644
index 0000000..6e0b61a
--- /dev/null
+++ b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_AssetStore.sql
@@ -0,0 +1,14 @@
1START TRANSACTION;
2
3create table Assets(
4 ID varchar(36) not null primary key,
5 Type int default 0,
6 InvType int default 0,
7 Name varchar(64),
8 Description varchar(64),
9 Local boolean,
10 Temporary boolean,
11 Data blob
12);
13
14COMMIT; \ No newline at end of file