aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL/Resources/Avatar.migrations
diff options
context:
space:
mode:
authorAlexRa2010-05-06 23:16:36 +0300
committerAlexRa2010-05-18 22:16:13 +0300
commit020f38774fbe8e0f53b0cb28ab49b378b9dcd325 (patch)
tree5d936d6450d580cf24e133047df7ff8d759de557 /OpenSim/Data/MSSQL/Resources/Avatar.migrations
parentMigrations for SQLite converted to new format (diff)
downloadopensim-SC-020f38774fbe8e0f53b0cb28ab49b378b9dcd325.zip
opensim-SC-020f38774fbe8e0f53b0cb28ab49b378b9dcd325.tar.gz
opensim-SC-020f38774fbe8e0f53b0cb28ab49b378b9dcd325.tar.bz2
opensim-SC-020f38774fbe8e0f53b0cb28ab49b378b9dcd325.tar.xz
MS SQL migrations converted to the new format
Diffstat (limited to 'OpenSim/Data/MSSQL/Resources/Avatar.migrations')
-rw-r--r--OpenSim/Data/MSSQL/Resources/Avatar.migrations17
1 files changed, 17 insertions, 0 deletions
diff --git a/OpenSim/Data/MSSQL/Resources/Avatar.migrations b/OpenSim/Data/MSSQL/Resources/Avatar.migrations
new file mode 100644
index 0000000..759e939
--- /dev/null
+++ b/OpenSim/Data/MSSQL/Resources/Avatar.migrations
@@ -0,0 +1,17 @@
1:VERSION 1
2
3BEGIN TRANSACTION
4
5CREATE TABLE [Avatars] (
6[PrincipalID] uniqueidentifier NOT NULL,
7[Name] varchar(32) NOT NULL,
8[Value] varchar(255) NOT NULL DEFAULT '',
9PRIMARY KEY CLUSTERED
10(
11 [PrincipalID] ASC, [Name] ASC
12)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
13) ON [PRIMARY]
14
15
16
17COMMIT \ No newline at end of file