diff options
| author | lbsa71 | 2008-02-13 20:08:46 +0000 |
|---|---|---|
| committer | lbsa71 | 2008-02-13 20:08:46 +0000 |
| commit | 15c6788dc79e7f6d802f0217198e3af21dff4e57 (patch) | |
| tree | ba6f22296ef68226725ecf224bf0e32dd4a1607b /OpenSim/Framework/Data.MSSQL/Resources/Mssql-regions.sql | |
| parent | *fixed varchar size typo in createuserfriendstable.sql (diff) | |
| download | opensim-SC-15c6788dc79e7f6d802f0217198e3af21dff4e57.zip opensim-SC-15c6788dc79e7f6d802f0217198e3af21dff4e57.tar.gz opensim-SC-15c6788dc79e7f6d802f0217198e3af21dff4e57.tar.bz2 opensim-SC-15c6788dc79e7f6d802f0217198e3af21dff4e57.tar.xz | |
* Moved insertRegionRow into MSSQLGridData
* Split table test and creation into table by table
* Debugged table creation Sql
* Added missing CreateUserFriendsTable.sql
Diffstat (limited to 'OpenSim/Framework/Data.MSSQL/Resources/Mssql-regions.sql')
| -rw-r--r-- | OpenSim/Framework/Data.MSSQL/Resources/Mssql-regions.sql | 9 |
1 files changed, 4 insertions, 5 deletions
diff --git a/OpenSim/Framework/Data.MSSQL/Resources/Mssql-regions.sql b/OpenSim/Framework/Data.MSSQL/Resources/Mssql-regions.sql index b46da16..7875c50 100644 --- a/OpenSim/Framework/Data.MSSQL/Resources/Mssql-regions.sql +++ b/OpenSim/Framework/Data.MSSQL/Resources/Mssql-regions.sql | |||
| @@ -1,10 +1,10 @@ | |||
| 1 | SET ANSI_NULLS ON | 1 | SET ANSI_NULLS ON |
| 2 | GO | 2 | |
| 3 | SET QUOTED_IDENTIFIER ON | 3 | SET QUOTED_IDENTIFIER ON |
| 4 | GO | 4 | |
| 5 | SET ANSI_PADDING ON | 5 | SET ANSI_PADDING ON |
| 6 | GO | 6 | |
| 7 | CREATE TABLE [db_owner].[regions]( | 7 | CREATE TABLE [dbo].[regions]( |
| 8 | [regionHandle] [varchar](255) COLLATE Latin1_General_CI_AS NULL, | 8 | [regionHandle] [varchar](255) COLLATE Latin1_General_CI_AS NULL, |
| 9 | [regionName] [varchar](255) COLLATE Latin1_General_CI_AS NULL, | 9 | [regionName] [varchar](255) COLLATE Latin1_General_CI_AS NULL, |
| 10 | [uuid] [varchar](255) COLLATE Latin1_General_CI_AS NOT NULL, | 10 | [uuid] [varchar](255) COLLATE Latin1_General_CI_AS NOT NULL, |
| @@ -37,5 +37,4 @@ PRIMARY KEY CLUSTERED | |||
| 37 | )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] | 37 | )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] |
| 38 | ) ON [PRIMARY] | 38 | ) ON [PRIMARY] |
| 39 | 39 | ||
| 40 | GO | ||
| 41 | SET ANSI_PADDING OFF | 40 | SET ANSI_PADDING OFF |