From 8cb889cb0e1a09bee80745b6a6d81641d1c62202 Mon Sep 17 00:00:00 2001
From: Charles Krinke
Date: Mon, 27 Oct 2008 00:46:17 +0000
Subject: Thank you kindly, Ruud Lathrop for a patch that solves: Primary Key
 violation when just linked a lot of prims using MSSQL.

---
 OpenSim/Data/MSSQL/Resources/009_RegionStore.sql | 5 +++++
 1 file changed, 5 insertions(+)
 create mode 100644 OpenSim/Data/MSSQL/Resources/009_RegionStore.sql

(limited to 'OpenSim/Data/MSSQL/Resources/009_RegionStore.sql')

diff --git a/OpenSim/Data/MSSQL/Resources/009_RegionStore.sql b/OpenSim/Data/MSSQL/Resources/009_RegionStore.sql
new file mode 100644
index 0000000..7efc218
--- /dev/null
+++ b/OpenSim/Data/MSSQL/Resources/009_RegionStore.sql
@@ -0,0 +1,5 @@
+BEGIN TRANSACTION
+
+ALTER TABLE prims ADD Material tinyint NOT NULL default 3
+
+COMMIT
-- 
cgit v1.1

