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 ++++++------ OpenSim/Data/MySQL/Resources/022_RegionStore.sql | 12 ++++++------ OpenSim/Data/SQLite/Resources/015_RegionStore.sql | 12 ++++++------ 5 files changed, 31 insertions(+), 31 deletions(-) (limited to 'OpenSim/Data') 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 diff --git a/OpenSim/Data/MySQL/Resources/022_RegionStore.sql b/OpenSim/Data/MySQL/Resources/022_RegionStore.sql index af4fdce..df0bb7d 100644 --- a/OpenSim/Data/MySQL/Resources/022_RegionStore.sql +++ b/OpenSim/Data/MySQL/Resources/022_RegionStore.sql @@ -1,6 +1,6 @@ -BEGIN; - -ALTER TABLE prims ADD COLUMN CollisionSound char(36) not null default '00000000-0000-0000-0000-000000000000'; -ALTER TABLE prims ADD COLUMN CollisionSoundVolume float not null default 0.0; - -COMMIT; +BEGIN; + +ALTER TABLE prims ADD COLUMN CollisionSound char(36) not null default '00000000-0000-0000-0000-000000000000'; +ALTER TABLE prims ADD COLUMN CollisionSoundVolume float not null default 0.0; + +COMMIT; diff --git a/OpenSim/Data/SQLite/Resources/015_RegionStore.sql b/OpenSim/Data/SQLite/Resources/015_RegionStore.sql index f9c0eea..c43f356 100644 --- a/OpenSim/Data/SQLite/Resources/015_RegionStore.sql +++ b/OpenSim/Data/SQLite/Resources/015_RegionStore.sql @@ -1,6 +1,6 @@ -BEGIN; - -ALTER TABLE prims ADD COLUMN CollisionSound varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000'; -ALTER TABLE prims ADD COLUMN CollisionSoundVolume float NOT NULL default 0; - -COMMIT; +BEGIN; + +ALTER TABLE prims ADD COLUMN CollisionSound varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000'; +ALTER TABLE prims ADD COLUMN CollisionSoundVolume float NOT NULL default 0; + +COMMIT; -- cgit v1.1