aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL/Resources
diff options
context:
space:
mode:
authorMelanie Thielker2009-06-17 14:54:25 +0000
committerMelanie Thielker2009-06-17 14:54:25 +0000
commit3ee599b900e1d7ecb03b975c04d4e389010c42a7 (patch)
tree958bd2fc639efd7968a1cea351959ab875e0ba10 /OpenSim/Data/MSSQL/Resources
parentImplementation of a simple authentication service + in connector in route to ... (diff)
downloadopensim-SC_OLD-3ee599b900e1d7ecb03b975c04d4e389010c42a7.zip
opensim-SC_OLD-3ee599b900e1d7ecb03b975c04d4e389010c42a7.tar.gz
opensim-SC_OLD-3ee599b900e1d7ecb03b975c04d4e389010c42a7.tar.bz2
opensim-SC_OLD-3ee599b900e1d7ecb03b975c04d4e389010c42a7.tar.xz
Add the missing resource files for MSSQL
Mantis #3800
Diffstat (limited to 'OpenSim/Data/MSSQL/Resources')
-rw-r--r--OpenSim/Data/MSSQL/Resources/021_RegionStore.sql10
-rw-r--r--OpenSim/Data/MSSQL/Resources/022_RegionStore.sql14
2 files changed, 24 insertions, 0 deletions
diff --git a/OpenSim/Data/MSSQL/Resources/021_RegionStore.sql b/OpenSim/Data/MSSQL/Resources/021_RegionStore.sql
new file mode 100644
index 0000000..1734e90
--- /dev/null
+++ b/OpenSim/Data/MSSQL/Resources/021_RegionStore.sql
@@ -0,0 +1,10 @@
1BEGIN TRANSACTION
2
3ALTER TABLE prims ADD PassTouches bit not null default 0
4
5COMMIT
6BEGIN TRANSACTION
7
8ALTER TABLE prims ADD PassTouches bit not null default 0
9
10COMMIT
diff --git a/OpenSim/Data/MSSQL/Resources/022_RegionStore.sql b/OpenSim/Data/MSSQL/Resources/022_RegionStore.sql
new file mode 100644
index 0000000..b5c555d
--- /dev/null
+++ b/OpenSim/Data/MSSQL/Resources/022_RegionStore.sql
@@ -0,0 +1,14 @@
1BEGIN TRANSACTION
2
3ALTER TABLE regionsettings ADD loaded_creation_date varchar(20)
4ALTER TABLE regionsettings ADD loaded_creation_time varchar(20)
5ALTER TABLE regionsettings ADD loaded_creation_id varchar(64)
6
7COMMIT
8BEGIN TRANSACTION
9
10ALTER TABLE regionsettings ADD loaded_creation_date varchar(20)
11ALTER TABLE regionsettings ADD loaded_creation_time varchar(20)
12ALTER TABLE regionsettings ADD loaded_creation_id varchar(64)
13
14COMMIT