diff options
| author | Melanie Thielker | 2009-06-17 14:54:25 +0000 |
|---|---|---|
| committer | Melanie Thielker | 2009-06-17 14:54:25 +0000 |
| commit | 3ee599b900e1d7ecb03b975c04d4e389010c42a7 (patch) | |
| tree | 958bd2fc639efd7968a1cea351959ab875e0ba10 /OpenSim/Data | |
| parent | Implementation of a simple authentication service + in connector in route to ... (diff) | |
| download | opensim-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')
| -rw-r--r-- | OpenSim/Data/MSSQL/Resources/021_RegionStore.sql | 10 | ||||
| -rw-r--r-- | OpenSim/Data/MSSQL/Resources/022_RegionStore.sql | 14 |
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 @@ | |||
| 1 | BEGIN TRANSACTION | ||
| 2 | |||
| 3 | ALTER TABLE prims ADD PassTouches bit not null default 0 | ||
| 4 | |||
| 5 | COMMIT | ||
| 6 | BEGIN TRANSACTION | ||
| 7 | |||
| 8 | ALTER TABLE prims ADD PassTouches bit not null default 0 | ||
| 9 | |||
| 10 | COMMIT | ||
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 @@ | |||
| 1 | BEGIN TRANSACTION | ||
| 2 | |||
| 3 | ALTER TABLE regionsettings ADD loaded_creation_date varchar(20) | ||
| 4 | ALTER TABLE regionsettings ADD loaded_creation_time varchar(20) | ||
| 5 | ALTER TABLE regionsettings ADD loaded_creation_id varchar(64) | ||
| 6 | |||
| 7 | COMMIT | ||
| 8 | BEGIN TRANSACTION | ||
| 9 | |||
| 10 | ALTER TABLE regionsettings ADD loaded_creation_date varchar(20) | ||
| 11 | ALTER TABLE regionsettings ADD loaded_creation_time varchar(20) | ||
| 12 | ALTER TABLE regionsettings ADD loaded_creation_id varchar(64) | ||
| 13 | |||
| 14 | COMMIT | ||