diff options
Diffstat (limited to 'OpenSim/Data/NHibernate/Resources/MySQLDialect/001_RegionStore.sql')
-rw-r--r-- | OpenSim/Data/NHibernate/Resources/MySQLDialect/001_RegionStore.sql | 169 |
1 files changed, 0 insertions, 169 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_RegionStore.sql b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_RegionStore.sql deleted file mode 100644 index eb1d8fe..0000000 --- a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_RegionStore.sql +++ /dev/null | |||
@@ -1,169 +0,0 @@ | |||
1 | CREATE TABLE Prims ( | ||
2 | UUID VARCHAR(36) NOT NULL, | ||
3 | RegionID VARCHAR(36) DEFAULT NULL, | ||
4 | GroupID VARCHAR(36) DEFAULT NULL, | ||
5 | ParentID INT DEFAULT NULL, | ||
6 | ParentUUID VARCHAR(36) DEFAULT NULL, | ||
7 | OwnerID VARCHAR(36) DEFAULT NULL, | ||
8 | LastOwnerID VARCHAR(36) DEFAULT NULL, | ||
9 | CreatorID VARCHAR(36) DEFAULT NULL, | ||
10 | CreationDate INT DEFAULT NULL, | ||
11 | LinkNum INT DEFAULT NULL, | ||
12 | Name VARCHAR(255) DEFAULT NULL, | ||
13 | Text VARCHAR(255) DEFAULT NULL, | ||
14 | Description VARCHAR(255) DEFAULT NULL, | ||
15 | SitName VARCHAR(255) DEFAULT NULL, | ||
16 | TouchName VARCHAR(255) DEFAULT NULL, | ||
17 | ObjectFlags INT DEFAULT NULL, | ||
18 | OwnerMask INT DEFAULT NULL, | ||
19 | NextOwnerMask INT DEFAULT NULL, | ||
20 | GroupMask INT DEFAULT NULL, | ||
21 | EveryoneMask INT DEFAULT NULL, | ||
22 | BaseMask INT DEFAULT NULL, | ||
23 | Material TINYINT DEFAULT NULL, | ||
24 | ScriptAccessPin INT DEFAULT NULL, | ||
25 | TextureAnimation BLOB, | ||
26 | ParticleSystem BLOB, | ||
27 | ClickAction TINYINT DEFAULT NULL, | ||
28 | Color INT DEFAULT NULL, | ||
29 | PositionX DOUBLE DEFAULT NULL, | ||
30 | PositionY DOUBLE DEFAULT NULL, | ||
31 | PositionZ DOUBLE DEFAULT NULL, | ||
32 | GroupPositionX DOUBLE DEFAULT NULL, | ||
33 | GroupPositionY DOUBLE DEFAULT NULL, | ||
34 | GroupPositionZ DOUBLE DEFAULT NULL, | ||
35 | VelocityX DOUBLE DEFAULT NULL, | ||
36 | VelocityY DOUBLE DEFAULT NULL, | ||
37 | VelocityZ DOUBLE DEFAULT NULL, | ||
38 | AngularVelocityX DOUBLE DEFAULT NULL, | ||
39 | AngularVelocityY DOUBLE DEFAULT NULL, | ||
40 | AngularVelocityZ DOUBLE DEFAULT NULL, | ||
41 | AccelerationX DOUBLE DEFAULT NULL, | ||
42 | AccelerationY DOUBLE DEFAULT NULL, | ||
43 | AccelerationZ DOUBLE DEFAULT NULL, | ||
44 | RotationX DOUBLE DEFAULT NULL, | ||
45 | RotationY DOUBLE DEFAULT NULL, | ||
46 | RotationZ DOUBLE DEFAULT NULL, | ||
47 | RotationW DOUBLE DEFAULT NULL, | ||
48 | SitTargetOffsetX DOUBLE DEFAULT NULL, | ||
49 | SitTargetOffsetY DOUBLE DEFAULT NULL, | ||
50 | SitTargetOffsetZ DOUBLE DEFAULT NULL, | ||
51 | SitTargetOrientW DOUBLE DEFAULT NULL, | ||
52 | SitTargetOrientX DOUBLE DEFAULT NULL, | ||
53 | SitTargetOrientY DOUBLE DEFAULT NULL, | ||
54 | SitTargetOrientZ DOUBLE DEFAULT NULL, | ||
55 | -- this is the shape | ||
56 | Shape INT DEFAULT NULL, | ||
57 | ScaleX DOUBLE DEFAULT NULL, | ||
58 | ScaleY DOUBLE DEFAULT NULL, | ||
59 | ScaleZ DOUBLE DEFAULT NULL, | ||
60 | PCode INT DEFAULT NULL, | ||
61 | PathBegin INT DEFAULT NULL, | ||
62 | PathEnd INT DEFAULT NULL, | ||
63 | PathScaleX INT DEFAULT NULL, | ||
64 | PathScaleY INT DEFAULT NULL, | ||
65 | PathShearX INT DEFAULT NULL, | ||
66 | PathShearY INT DEFAULT NULL, | ||
67 | PathSkew INT DEFAULT NULL, | ||
68 | PathCurve INT DEFAULT NULL, | ||
69 | PathRadiusOffset INT DEFAULT NULL, | ||
70 | PathRevolutions INT DEFAULT NULL, | ||
71 | PathTaperX INT DEFAULT NULL, | ||
72 | PathTaperY INT DEFAULT NULL, | ||
73 | PathTwist INT DEFAULT NULL, | ||
74 | ProfileBegin INT DEFAULT NULL, | ||
75 | ProfileEnd INT DEFAULT NULL, | ||
76 | ProfileCurve INT DEFAULT NULL, | ||
77 | ProfileHollow INT DEFAULT NULL, | ||
78 | State INT DEFAULT NULL, | ||
79 | Texture LONGBLOB, | ||
80 | ExtraParams LONGBLOB, | ||
81 | PRIMARY KEY (UUID) | ||
82 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1'; | ||
83 | |||
84 | CREATE INDEX PrimsRegionIdIndex ON Prims (RegionID); | ||
85 | CREATE INDEX PrimsRegionParentUuidIndex ON Prims (ParentUUID); | ||
86 | |||
87 | CREATE TABLE Terrain ( | ||
88 | RegionID VARCHAR(36) not null, | ||
89 | MapData LONGBLOB, | ||
90 | PRIMARY KEY (RegionID) | ||
91 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1'; | ||
92 | |||
93 | CREATE TABLE PrimItems ( | ||
94 | ItemID VARCHAR(36) NOT NULL, | ||
95 | GroupID VARCHAR(36) DEFAULT NULL, | ||
96 | PrimID VARCHAR(36) DEFAULT NULL, | ||
97 | ParentFolderID VARCHAR(36) DEFAULT NULL, | ||
98 | AssetID VARCHAR(36) DEFAULT NULL, | ||
99 | OwnerID VARCHAR(36) DEFAULT NULL, | ||
100 | LastOwnerID VARCHAR(36) DEFAULT NULL, | ||
101 | CreatorID VARCHAR(36) DEFAULT NULL, | ||
102 | CreationDate BIGINT DEFAULT NULL, | ||
103 | Type INT DEFAULT NULL, | ||
104 | InvType INT DEFAULT NULL, | ||
105 | Name VARCHAR(255) DEFAULT NULL, | ||
106 | Description VARCHAR(255) DEFAULT NULL, | ||
107 | NextPermissions INT DEFAULT NULL, | ||
108 | CurrentPermissions INT DEFAULT NULL, | ||
109 | BasePermissions INT DEFAULT NULL, | ||
110 | EveryonePermissions INT DEFAULT NULL, | ||
111 | GroupPermissions INT DEFAULT NULL, | ||
112 | Flags INT DEFAULT NULL, | ||
113 | PRIMARY KEY (ItemID) | ||
114 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1'; | ||
115 | |||
116 | CREATE INDEX PrimItemsPrimIdIndex ON PrimItems (PrimID); | ||
117 | |||
118 | CREATE TABLE RegionSettings ( | ||
119 | RegionID VARCHAR(36) NOT NULL, | ||
120 | |||
121 | BlockTerraform BIT DEFAULT NULL, | ||
122 | BlockFly BIT DEFAULT NULL, | ||
123 | AllowDamage BIT DEFAULT NULL, | ||
124 | RestrictPushing BIT DEFAULT NULL, | ||
125 | AllowLandResell BIT DEFAULT NULL, | ||
126 | AllowLandJoinDivide BIT DEFAULT NULL, | ||
127 | BlockShowInSearch BIT DEFAULT NULL, | ||
128 | |||
129 | AgentLimit INT DEFAULT NULL, | ||
130 | ObjectBonus DOUBLE DEFAULT NULL, | ||
131 | Maturity INT DEFAULT NULL, | ||
132 | |||
133 | DisableScripts BIT DEFAULT NULL, | ||
134 | DisableCollisions BIT DEFAULT NULL, | ||
135 | DisablePhysics BIT DEFAULT NULL, | ||
136 | |||
137 | TerrainTexture1 VARCHAR(36) DEFAULT NULL, | ||
138 | TerrainTexture2 VARCHAR(36) DEFAULT NULL, | ||
139 | TerrainTexture3 VARCHAR(36) DEFAULT NULL, | ||
140 | TerrainTexture4 VARCHAR(36) DEFAULT NULL, | ||
141 | |||
142 | Elevation1NW DOUBLE DEFAULT NULL, | ||
143 | Elevation2NW DOUBLE DEFAULT NULL, | ||
144 | Elevation1NE DOUBLE DEFAULT NULL, | ||
145 | Elevation2NE DOUBLE DEFAULT NULL, | ||
146 | Elevation1SE DOUBLE DEFAULT NULL, | ||
147 | Elevation2SE DOUBLE DEFAULT NULL, | ||
148 | Elevation1SW DOUBLE DEFAULT NULL, | ||
149 | Elevation2SW DOUBLE DEFAULT NULL, | ||
150 | |||
151 | WaterHeight DOUBLE DEFAULT NULL, | ||
152 | TerrainRaiseLimit DOUBLE DEFAULT NULL, | ||
153 | TerrainLowerLimit DOUBLE DEFAULT NULL, | ||
154 | |||
155 | UseEstateSun BIT DEFAULT NULL, | ||
156 | Sandbox BIT DEFAULT NULL, | ||
157 | |||
158 | SunVectorX DOUBLE DEFAULT NULL, | ||
159 | SunVectorY DOUBLE DEFAULT NULL, | ||
160 | SunVectorZ DOUBLE DEFAULT NULL, | ||
161 | |||
162 | FixedSun BIT DEFAULT NULL, | ||
163 | SunPosition DOUBLE DEFAULT NULL, | ||
164 | |||
165 | Covenant VARCHAR(36) DEFAULT NULL, | ||
166 | |||
167 | PRIMARY KEY (RegionID) | ||
168 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1'; | ||
169 | |||