diff options
Diffstat (limited to '')
8 files changed, 0 insertions, 412 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_AssetStore.sql b/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_AssetStore.sql deleted file mode 100644 index deee78b..0000000 --- a/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_AssetStore.sql +++ /dev/null | |||
@@ -1,10 +0,0 @@ | |||
1 | create table Assets ( | ||
2 | ID NVARCHAR(36) not null, | ||
3 | Type SMALLINT null, | ||
4 | Name NVARCHAR(64) null, | ||
5 | Description NVARCHAR(64) null, | ||
6 | Local BIT null, | ||
7 | Temporary BIT null, | ||
8 | Data VARBINARY(max) null, | ||
9 | primary key (ID) | ||
10 | ) | ||
diff --git a/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_EstateStore.sql b/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_EstateStore.sql deleted file mode 100644 index dd579f9..0000000 --- a/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_EstateStore.sql +++ /dev/null | |||
@@ -1,72 +0,0 @@ | |||
1 | CREATE TABLE EstateSettings ( | ||
2 | EstateID INT NOT NULL, | ||
3 | ParentEstateID INT NULL, | ||
4 | EstateOwnerID NVARCHAR(36) NULL, | ||
5 | Name NVARCHAR(64) NULL, | ||
6 | RedirectGridX INT NULL, | ||
7 | RedirectGridY INT NULL, | ||
8 | BillableFactor REAL NULL, | ||
9 | PricePerMeter INT NULL, | ||
10 | SunPosition FLOAT NULL, | ||
11 | |||
12 | UseGlobalTime BIT NULL, | ||
13 | FixedSun BIT NULL, | ||
14 | AllowVoice BIT NULL, | ||
15 | AllowDirectTeleport BIT NULL, | ||
16 | ResetHomeOnTeleport BIT NULL, | ||
17 | PublicAccess BIT NULL, | ||
18 | DenyAnonymous BIT NULL, | ||
19 | DenyIdentified BIT NULL, | ||
20 | DenyTransacted BIT NULL, | ||
21 | DenyMinors BIT NULL, | ||
22 | BlockDwell BIT NULL, | ||
23 | EstateSkipScripts BIT NULL, | ||
24 | TaxFree BIT NULL, | ||
25 | AbuseEmailToEstateOwner BIT NULL, | ||
26 | |||
27 | AbuseEmail NVARCHAR(255) NULL, | ||
28 | |||
29 | PRIMARY KEY (EstateID) | ||
30 | ); | ||
31 | |||
32 | CREATE TABLE EstateRegionLink ( | ||
33 | EstateRegionLinkID NVARCHAR(36) NOT NULL, | ||
34 | EstateID INT NULL, | ||
35 | RegionID NVARCHAR(36) NULL, | ||
36 | PRIMARY KEY (EstateRegionLinkID) | ||
37 | ); | ||
38 | |||
39 | CREATE INDEX EstateRegionLinkEstateIDIndex ON EstateRegionLink (EstateID); | ||
40 | CREATE INDEX EstateRegionLinkERegionIDIndex ON EstateRegionLink (RegionID); | ||
41 | |||
42 | |||
43 | CREATE TABLE EstateManagers ( | ||
44 | EstateID INT NOT NULL, | ||
45 | ManagerID NVARCHAR(36) NOT NULL, | ||
46 | ArrayIndex INT NOT NULL, | ||
47 | PRIMARY KEY (EstateID,ArrayIndex) | ||
48 | ); | ||
49 | |||
50 | CREATE TABLE EstateUsers ( | ||
51 | EstateID INT NOT NULL, | ||
52 | UserID NVARCHAR(36) NOT NULL, | ||
53 | ArrayIndex INT NOT NULL, | ||
54 | PRIMARY KEY (EstateID,ArrayIndex) | ||
55 | ); | ||
56 | |||
57 | CREATE TABLE EstateGroups ( | ||
58 | EstateID INT NOT NULL, | ||
59 | GroupID NVARCHAR(36) NOT NULL, | ||
60 | ArrayIndex INT NOT NULL, | ||
61 | PRIMARY KEY (EstateID,ArrayIndex) | ||
62 | ); | ||
63 | |||
64 | CREATE TABLE EstateBans ( | ||
65 | EstateID INT NOT NULL, | ||
66 | ArrayIndex INT NOT NULL, | ||
67 | BannedUserID NVARCHAR(36) NOT NULL, | ||
68 | BannedHostAddress NVARCHAR(16) NOT NULL, | ||
69 | BannedHostIPMask NVARCHAR(16) NOT NULL, | ||
70 | BannedHostNameMask NVARCHAR(16) NOT NULL, | ||
71 | PRIMARY KEY (EstateID,ArrayIndex) | ||
72 | ); \ No newline at end of file | ||
diff --git a/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_GridStore.sql b/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_GridStore.sql deleted file mode 100644 index e4ad525..0000000 --- a/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_GridStore.sql +++ /dev/null | |||
@@ -1,35 +0,0 @@ | |||
1 | create table Regions ( | ||
2 | Uuid NVARCHAR(36) not null, | ||
3 | RegionHandle BIGINT null, | ||
4 | RegionName NVARCHAR(32) null, | ||
5 | RegionRecvKey NVARCHAR(128) null, | ||
6 | RegionSendKey NVARCHAR(128) null, | ||
7 | RegionSecret NVARCHAR(128) null, | ||
8 | RegionDataURI NVARCHAR(255) null, | ||
9 | ServerIP NVARCHAR(64) null, | ||
10 | ServerPort INT null, | ||
11 | ServerURI NVARCHAR(255) null, | ||
12 | RegionLocX INT null, | ||
13 | RegionLocY INT null, | ||
14 | RegionLocZ INT null, | ||
15 | EastOverrideHandle BIGINT null, | ||
16 | WestOverrideHandle BIGINT null, | ||
17 | SouthOverrideHandle BIGINT null, | ||
18 | NorthOverrideHandle BIGINT null, | ||
19 | RegionAssetURI NVARCHAR(255) null, | ||
20 | RegionAssetRecvKey NVARCHAR(128) null, | ||
21 | RegionAssetSendKey NVARCHAR(128) null, | ||
22 | RegionUserURI NVARCHAR(255) null, | ||
23 | RegionUserRecvKey NVARCHAR(128) null, | ||
24 | RegionUserSendKey NVARCHAR(128) null, | ||
25 | ServerHttpPort INT null, | ||
26 | ServerRemotingPort INT null, | ||
27 | RegionMapTextureID NVARCHAR(36) null, | ||
28 | Owner_uuid NVARCHAR(36) null, | ||
29 | OriginUUID NVARCHAR(36) null, | ||
30 | primary key (Uuid) | ||
31 | ) | ||
32 | create index region_handle on Regions (RegionHandle) | ||
33 | create index region_name on Regions (RegionName) | ||
34 | create index overrideHandles on Regions (EastOverrideHandle, WestOverrideHandle, SouthOverrideHandle, NorthOverrideHandle) | ||
35 | |||
diff --git a/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_InventoryStore.sql b/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_InventoryStore.sql deleted file mode 100644 index 82936c4..0000000 --- a/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_InventoryStore.sql +++ /dev/null | |||
@@ -1,36 +0,0 @@ | |||
1 | create table InventoryFolders ( | ||
2 | ID NVARCHAR(255) not null, | ||
3 | Type SMALLINT null, | ||
4 | Version INT null, | ||
5 | ParentID NVARCHAR(255) null, | ||
6 | Owner NVARCHAR(255) null, | ||
7 | Name NVARCHAR(64) null, | ||
8 | primary key (ID) | ||
9 | ) | ||
10 | create table InventoryItems ( | ||
11 | ID NVARCHAR(255) not null, | ||
12 | InvType INT null, | ||
13 | AssetType INT null, | ||
14 | AssetID NVARCHAR(255) null, | ||
15 | Folder NVARCHAR(255) null, | ||
16 | Owner NVARCHAR(255) null, | ||
17 | Creator NVARCHAR(255) null, | ||
18 | Name NVARCHAR(64) null, | ||
19 | Description NVARCHAR(64) null, | ||
20 | NextPermissions INT null, | ||
21 | CurrentPermissions INT null, | ||
22 | BasePermissions INT null, | ||
23 | EveryOnePermissions INT null, | ||
24 | GroupID NVARCHAR(255) null, | ||
25 | GroupOwned BIT null, | ||
26 | SalePrice INT null, | ||
27 | SaleType TINYINT null, | ||
28 | Flags INT null, | ||
29 | CreationDate INT null, | ||
30 | primary key (ID) | ||
31 | ) | ||
32 | create index item_group_id on InventoryItems (GroupID) | ||
33 | create index item_folder_id on InventoryItems (Folder) | ||
34 | create index item_owner_id on InventoryItems (Owner) | ||
35 | create index folder_owner_id on InventoryFolders (Owner) | ||
36 | create index folder_parent_id on InventoryFolders (ParentID) | ||
diff --git a/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_RegionStore.sql b/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_RegionStore.sql deleted file mode 100644 index 181a74c..0000000 --- a/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_RegionStore.sql +++ /dev/null | |||
@@ -1,104 +0,0 @@ | |||
1 | create table Prims ( | ||
2 | UUID NVARCHAR(255) not null, | ||
3 | ParentID INT null, | ||
4 | ParentUUID NVARCHAR(255) null, | ||
5 | RegionID NVARCHAR(255) null, | ||
6 | CreationDate INT null, | ||
7 | Name NVARCHAR(255) null, | ||
8 | Text NVARCHAR(255) null, | ||
9 | Description NVARCHAR(255) null, | ||
10 | SitName NVARCHAR(255) null, | ||
11 | TouchName NVARCHAR(255) null, | ||
12 | ObjectFlags INT null, | ||
13 | CreatorID NVARCHAR(255) null, | ||
14 | OwnerID NVARCHAR(255) null, | ||
15 | GroupID NVARCHAR(255) null, | ||
16 | LastOwnerID NVARCHAR(255) null, | ||
17 | OwnerMask INT null, | ||
18 | NextOwnerMask INT null, | ||
19 | GroupMask INT null, | ||
20 | EveryoneMask INT null, | ||
21 | BaseMask INT null, | ||
22 | PositionX REAL null, | ||
23 | PositionY REAL null, | ||
24 | PositionZ REAL null, | ||
25 | GroupPositionX REAL null, | ||
26 | GroupPositionY REAL null, | ||
27 | GroupPositionZ REAL null, | ||
28 | VelocityX REAL null, | ||
29 | VelocityY REAL null, | ||
30 | VelocityZ REAL null, | ||
31 | AngularVelocityX REAL null, | ||
32 | AngularVelocityY REAL null, | ||
33 | AngularVelocityZ REAL null, | ||
34 | AccelerationX REAL null, | ||
35 | AccelerationY REAL null, | ||
36 | AccelerationZ REAL null, | ||
37 | SitTargetOffsetX REAL null, | ||
38 | SitTargetOffsetY REAL null, | ||
39 | SitTargetOffsetZ REAL null, | ||
40 | RotationX REAL null, | ||
41 | RotationY REAL null, | ||
42 | RotationZ REAL null, | ||
43 | RotationW REAL null, | ||
44 | SitTargetOrientX REAL null, | ||
45 | SitTargetOrientY REAL null, | ||
46 | SitTargetOrientZ REAL null, | ||
47 | SitTargetOrientW REAL null, | ||
48 | ScaleX REAL null, | ||
49 | ScaleY REAL null, | ||
50 | ScaleZ REAL null, | ||
51 | PCode TINYINT null, | ||
52 | PathBegin INT null, | ||
53 | PathEnd INT null, | ||
54 | PathScaleX TINYINT null, | ||
55 | PathScaleY TINYINT null, | ||
56 | PathShearX TINYINT null, | ||
57 | PathShearY TINYINT null, | ||
58 | PathSkew TINYINT null, | ||
59 | PathCurve TINYINT null, | ||
60 | PathRadiusOffset TINYINT null, | ||
61 | PathRevolutions TINYINT null, | ||
62 | PathTaperX TINYINT null, | ||
63 | PathTaperY TINYINT null, | ||
64 | PathTwist TINYINT null, | ||
65 | ProfileBegin INT null, | ||
66 | ProfileEnd INT null, | ||
67 | ProfileCurve TINYINT null, | ||
68 | ProfileHollow INT null, | ||
69 | Texture VARBINARY(8000) null, | ||
70 | ExtraParams VARBINARY(8000) null, | ||
71 | State TINYINT null, | ||
72 | primary key (UUID) | ||
73 | ) | ||
74 | |||
75 | create table PrimItems ( | ||
76 | ItemID NVARCHAR(255) not null, | ||
77 | PrimID NVARCHAR(255) null, | ||
78 | AssetID NVARCHAR(255) null, | ||
79 | ParentFolderID NVARCHAR(255) null, | ||
80 | CreatorID NVARCHAR(255) null, | ||
81 | OwnerID NVARCHAR(255) null, | ||
82 | GroupID NVARCHAR(255) null, | ||
83 | LastOwnerID NVARCHAR(255) null, | ||
84 | CurrentPermissions INT null, | ||
85 | BasePermissions INT null, | ||
86 | EveryonePermissions INT null, | ||
87 | GroupPermissions INT null, | ||
88 | NextPermissions INT null, | ||
89 | Name NVARCHAR(255) null, | ||
90 | Description NVARCHAR(255) null, | ||
91 | CreationDate INT null, | ||
92 | Flags INT null, | ||
93 | Type INT null, | ||
94 | InvType INT null, | ||
95 | primary key (ItemID) | ||
96 | ) | ||
97 | |||
98 | create table Terrain ( | ||
99 | RegionID NVARCHAR(255) not null, | ||
100 | MapData VARBINARY(max) null, | ||
101 | primary key (RegionID) | ||
102 | ) | ||
103 | |||
104 | |||
diff --git a/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_UserStore.sql b/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_UserStore.sql deleted file mode 100644 index c9c6c89..0000000 --- a/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_UserStore.sql +++ /dev/null | |||
@@ -1,77 +0,0 @@ | |||
1 | create table UserAgents ( | ||
2 | ProfileID NVARCHAR(255) not null, | ||
3 | AgentIP NVARCHAR(24) null, | ||
4 | AgentPort INT null, | ||
5 | AgentOnline BIT null, | ||
6 | SessionID NVARCHAR(255) null, | ||
7 | SecureSessionID NVARCHAR(255) null, | ||
8 | InitialRegion NVARCHAR(255) null, | ||
9 | Region NVARCHAR(255) null, | ||
10 | LoginTime INT null, | ||
11 | LogoutTime INT null, | ||
12 | Handle BIGINT null, | ||
13 | primary key (ProfileID) | ||
14 | ) | ||
15 | |||
16 | create table UserProfiles ( | ||
17 | ID NVARCHAR(255) not null, | ||
18 | FirstName NVARCHAR(32) null, | ||
19 | SurName NVARCHAR(32) null, | ||
20 | PasswordHash NVARCHAR(32) null, | ||
21 | PasswordSalt NVARCHAR(32) null, | ||
22 | WebLoginKey NVARCHAR(255) null, | ||
23 | HomeRegionX INT null, | ||
24 | HomeRegionY INT null, | ||
25 | HomeLocationX REAL null, | ||
26 | HomeLocationY REAL null, | ||
27 | HomeLocationZ REAL null, | ||
28 | HomeLookAtX REAL null, | ||
29 | HomeLookAtY REAL null, | ||
30 | HomeLookAtZ REAL null, | ||
31 | Created INT null, | ||
32 | LastLogin INT null, | ||
33 | RootInventoryFolderID NVARCHAR(255) null, | ||
34 | UserInventoryURI NVARCHAR(255) null, | ||
35 | UserAssetURI NVARCHAR(255) null, | ||
36 | Image NVARCHAR(255) null, | ||
37 | FirstLifeImage NVARCHAR(255) null, | ||
38 | AboutText NVARCHAR(255) null, | ||
39 | FirstLifeAboutText NVARCHAR(255) null, | ||
40 | primary key (ID) | ||
41 | ) | ||
42 | create table UserAppearances ( | ||
43 | Owner NVARCHAR(255) not null, | ||
44 | BodyItem NVARCHAR(255) null, | ||
45 | BodyAsset NVARCHAR(255) null, | ||
46 | SkinItem NVARCHAR(255) null, | ||
47 | SkinAsset NVARCHAR(255) null, | ||
48 | HairItem NVARCHAR(255) null, | ||
49 | HairAsset NVARCHAR(255) null, | ||
50 | EyesItem NVARCHAR(255) null, | ||
51 | EyesAsset NVARCHAR(255) null, | ||
52 | ShirtItem NVARCHAR(255) null, | ||
53 | ShirtAsset NVARCHAR(255) null, | ||
54 | PantsItem NVARCHAR(255) null, | ||
55 | PantsAsset NVARCHAR(255) null, | ||
56 | ShoesItem NVARCHAR(255) null, | ||
57 | ShoesAsset NVARCHAR(255) null, | ||
58 | SocksItem NVARCHAR(255) null, | ||
59 | SocksAsset NVARCHAR(255) null, | ||
60 | JacketItem NVARCHAR(255) null, | ||
61 | JacketAsset NVARCHAR(255) null, | ||
62 | GlovesItem NVARCHAR(255) null, | ||
63 | GlovesAsset NVARCHAR(255) null, | ||
64 | UnderShirtItem NVARCHAR(255) null, | ||
65 | UnderShirtAsset NVARCHAR(255) null, | ||
66 | UnderPantsItem NVARCHAR(255) null, | ||
67 | UnderPantsAsset NVARCHAR(255) null, | ||
68 | SkirtItem NVARCHAR(255) null, | ||
69 | SkirtAsset NVARCHAR(255) null, | ||
70 | Texture VARBINARY(8000) null, | ||
71 | VisualParams VARBINARY(8000) null, | ||
72 | Serial INT null, | ||
73 | primary key (Owner) | ||
74 | ) | ||
75 | |||
76 | create index user_surname on UserProfiles (SurName) | ||
77 | create index user_firstname on UserProfiles (FirstName) | ||
diff --git a/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/002_RegionStore.sql b/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/002_RegionStore.sql deleted file mode 100644 index dfaac6e..0000000 --- a/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/002_RegionStore.sql +++ /dev/null | |||
@@ -1,51 +0,0 @@ | |||
1 | ALTER TABLE Prims ADD LinkNum INT null; | ||
2 | ALTER TABLE Prims ADD Material TINYINT null; | ||
3 | ALTER TABLE Prims ADD ScriptAccessPin INT null; | ||
4 | ALTER TABLE Prims ADD TextureAnimation VARBINARY(max) null; | ||
5 | ALTER TABLE Prims ADD ParticleSystem VARBINARY(max) null; | ||
6 | ALTER TABLE Prims ADD ClickAction TINYINT null; | ||
7 | ALTER TABLE Prims ADD Color INT null; | ||
8 | |||
9 | CREATE TABLE RegionSettings | ||
10 | ( | ||
11 | RegionID NVARCHAR(255) NOT NULL, | ||
12 | BlockTerraform bit NOT NULL, | ||
13 | BlockFly bit NOT NULL, | ||
14 | AllowDamage bit NOT NULL, | ||
15 | RestrictPushing bit NOT NULL, | ||
16 | AllowLandResell bit NOT NULL, | ||
17 | AllowLandJoinDivide bit NOT NULL, | ||
18 | BlockShowInSearch bit NOT NULL, | ||
19 | AgentLimit int NOT NULL, | ||
20 | ObjectBonus float(53) NOT NULL, | ||
21 | Maturity int NOT NULL, | ||
22 | DisableScripts bit NOT NULL, | ||
23 | DisableCollisions bit NOT NULL, | ||
24 | DisablePhysics bit NOT NULL, | ||
25 | TerrainTexture1 NVARCHAR(36) NOT NULL, | ||
26 | TerrainTexture2 NVARCHAR(36) NOT NULL, | ||
27 | TerrainTexture3 NVARCHAR(36) NOT NULL, | ||
28 | TerrainTexture4 NVARCHAR(36) NOT NULL, | ||
29 | Elevation1NW float(53) NOT NULL, | ||
30 | Elevation2NW float(53) NOT NULL, | ||
31 | Elevation1NE float(53) NOT NULL, | ||
32 | Elevation2NE float(53) NOT NULL, | ||
33 | Elevation1SE float(53) NOT NULL, | ||
34 | Elevation2SE float(53) NOT NULL, | ||
35 | Elevation1SW float(53) NOT NULL, | ||
36 | Elevation2SW float(53) NOT NULL, | ||
37 | WaterHeight float(53) NOT NULL, | ||
38 | TerrainRaiseLimit float(53) NOT NULL, | ||
39 | TerrainLowerLimit float(53) NOT NULL, | ||
40 | UseEstateSun bit NOT NULL, | ||
41 | FixedSun bit NOT NULL, | ||
42 | SunPosition float(53) NOT NULL, | ||
43 | Covenant NVARCHAR(36) NULL DEFAULT (NULL), | ||
44 | Sandbox bit NOT NULL, | ||
45 | SunVectorX float(53) NOT NULL DEFAULT ((0)), | ||
46 | SunVectorY float(53) NOT NULL DEFAULT ((0)), | ||
47 | SunVectorZ float(53) NOT NULL DEFAULT ((0)), | ||
48 | |||
49 | primary key (RegionID) | ||
50 | ) | ||
51 | |||
diff --git a/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/002_UserStore.sql b/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/002_UserStore.sql deleted file mode 100644 index f5e0c00..0000000 --- a/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/002_UserStore.sql +++ /dev/null | |||
@@ -1,27 +0,0 @@ | |||
1 | ALTER TABLE UserAgents ADD PositionX REAL null; | ||
2 | ALTER TABLE UserAgents ADD PositionY REAL null; | ||
3 | ALTER TABLE UserAgents ADD PositionZ REAL null; | ||
4 | ALTER TABLE UserAgents ADD LookAtX REAL null; | ||
5 | ALTER TABLE UserAgents ADD LookAtY REAL null; | ||
6 | ALTER TABLE UserAgents ADD LookAtZ REAL null; | ||
7 | |||
8 | ALTER TABLE UserProfiles ADD Email NVARCHAR(250) null; | ||
9 | ALTER TABLE UserProfiles ADD HomeRegionID NVARCHAR(36) null; | ||
10 | ALTER TABLE UserProfiles ADD CanDoMask INT null; | ||
11 | ALTER TABLE UserProfiles ADD WantDoMask INT null; | ||
12 | ALTER TABLE UserProfiles ADD UserFlags INT null; | ||
13 | ALTER TABLE UserProfiles ADD GodLevel INT null; | ||
14 | ALTER TABLE UserProfiles ADD CustomType NVARCHAR(32) null; | ||
15 | ALTER TABLE UserProfiles ADD Partner NVARCHAR(36) null; | ||
16 | |||
17 | ALTER TABLE UserAppearances ADD AvatarHeight FLOAT null; | ||
18 | |||
19 | CREATE TABLE UserFriends ( | ||
20 | UserFriendID NVARCHAR(36) NOT NULL, | ||
21 | OwnerID NVARCHAR(36) NULL, | ||
22 | FriendID NVARCHAR(36) NULL, | ||
23 | FriendPermissions INT NULL, | ||
24 | PRIMARY KEY (UserFriendID) | ||
25 | ); | ||
26 | |||
27 | CREATE INDEX UserFriendsOwnerIdFriendIdIndex ON UserFriends (OwnerID,FriendID); | ||