From ecac5c9c5a18241c62a25834b20be38ee0e38843 Mon Sep 17 00:00:00 2001 From: Jeff Ames Date: Fri, 21 Nov 2008 18:44:48 +0000 Subject: Update svn properties, minor formatting cleanup. --- OpenSim/Data/MSSQL/Resources/003_AssetStore.sql | 12 ++++++------ OpenSim/Data/MSSQL/Resources/010_RegionStore.sql | 14 +++++++------- OpenSim/Data/MSSQL/Resources/011_RegionStore.sql | 12 ++++++------ 3 files changed, 19 insertions(+), 19 deletions(-) (limited to 'OpenSim/Data/MSSQL') diff --git a/OpenSim/Data/MSSQL/Resources/003_AssetStore.sql b/OpenSim/Data/MSSQL/Resources/003_AssetStore.sql index 1776cac..1434330 100644 --- a/OpenSim/Data/MSSQL/Resources/003_AssetStore.sql +++ b/OpenSim/Data/MSSQL/Resources/003_AssetStore.sql @@ -1,6 +1,6 @@ -BEGIN TRANSACTION - -ALTER TABLE assets add create_time integer default 0 -ALTER TABLE assets add access_time integer default 0 - -COMMIT +BEGIN TRANSACTION + +ALTER TABLE assets add create_time integer default 0 +ALTER TABLE assets add access_time integer default 0 + +COMMIT diff --git a/OpenSim/Data/MSSQL/Resources/010_RegionStore.sql b/OpenSim/Data/MSSQL/Resources/010_RegionStore.sql index 2eed71d..74ad9c2 100644 --- a/OpenSim/Data/MSSQL/Resources/010_RegionStore.sql +++ b/OpenSim/Data/MSSQL/Resources/010_RegionStore.sql @@ -1,7 +1,7 @@ -BEGIN TRANSACTION - -ALTER TABLE regionsettings ADD sunvectorx float NOT NULL default 0; -ALTER TABLE regionsettings ADD sunvectory float NOT NULL default 0; -ALTER TABLE regionsettings ADD sunvectorz float NOT NULL default 0; - -COMMIT +BEGIN TRANSACTION + +ALTER TABLE regionsettings ADD sunvectorx float NOT NULL default 0; +ALTER TABLE regionsettings ADD sunvectory float NOT NULL default 0; +ALTER TABLE regionsettings ADD sunvectorz float NOT NULL default 0; + +COMMIT diff --git a/OpenSim/Data/MSSQL/Resources/011_RegionStore.sql b/OpenSim/Data/MSSQL/Resources/011_RegionStore.sql index 2218216..14c71a3 100644 --- a/OpenSim/Data/MSSQL/Resources/011_RegionStore.sql +++ b/OpenSim/Data/MSSQL/Resources/011_RegionStore.sql @@ -1,6 +1,6 @@ -BEGIN TRANSACTION - -ALTER TABLE prims ADD CollisionSound char(36) not null default '00000000-0000-0000-0000-000000000000' -ALTER TABLE prims ADD CollisionSoundVolume float not null default 0.0 - -COMMIT +BEGIN TRANSACTION + +ALTER TABLE prims ADD CollisionSound char(36) not null default '00000000-0000-0000-0000-000000000000' +ALTER TABLE prims ADD CollisionSoundVolume float not null default 0.0 + +COMMIT -- cgit v1.1