diff options
Diffstat (limited to 'OpenSim/Data/NHibernate/Resources/MySQLDialect/003_RegionStore.sql')
-rw-r--r-- | OpenSim/Data/NHibernate/Resources/MySQLDialect/003_RegionStore.sql | 72 |
1 files changed, 62 insertions, 10 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/MySQLDialect/003_RegionStore.sql b/OpenSim/Data/NHibernate/Resources/MySQLDialect/003_RegionStore.sql index 230e93c..e30287b 100644 --- a/OpenSim/Data/NHibernate/Resources/MySQLDialect/003_RegionStore.sql +++ b/OpenSim/Data/NHibernate/Resources/MySQLDialect/003_RegionStore.sql | |||
@@ -1,26 +1,78 @@ | |||
1 | BEGIN; | 1 | BEGIN; |
2 | 2 | ||
3 | CREATE TABLE `PrimItems` ( | 3 | CREATE TABLE `PrimItems` ( |
4 | `ItemID` char(36) NOT NULL default '', | ||
5 | `GroupID` char(36) default NULL, | ||
6 | `PrimID` char(36) default NULL, | ||
7 | `ParentFolderID` char(36) default NULL, | ||
8 | `AssetID` char(36) default NULL, | ||
9 | `OwnerID` char(36) default NULL, | ||
10 | `LastOwnerID` char(36) default NULL, | ||
11 | `CreatorID` char(36) default NULL, | ||
12 | `CreationDate` bigint(20) default NULL, | ||
4 | `InvType` int(11) default NULL, | 13 | `InvType` int(11) default NULL, |
5 | `Name` varchar(255) default NULL, | 14 | `Name` varchar(255) default NULL, |
6 | `Description` varchar(255) default NULL, | 15 | `Description` varchar(255) default NULL, |
7 | `CreationDate` bigint(20) default NULL, | ||
8 | `NextPermissions` int(11) default NULL, | 16 | `NextPermissions` int(11) default NULL, |
9 | `CurrentPermissions` int(11) default NULL, | 17 | `CurrentPermissions` int(11) default NULL, |
10 | `BasePermissions` int(11) default NULL, | 18 | `BasePermissions` int(11) default NULL, |
11 | `EveryonePermissions` int(11) default NULL, | 19 | `EveryonePermissions` int(11) default NULL, |
12 | `GroupPermissions` int(11) default NULL, | 20 | `GroupPermissions` int(11) default NULL, |
13 | `Flags` int(11) NOT NULL default '0', | 21 | `Flags` int(11) NOT NULL default '0', |
14 | `ItemID` char(36) NOT NULL default '', | ||
15 | `PrimID` char(36) default NULL, | ||
16 | `AssetID` char(36) default NULL, | ||
17 | `ParentFolderID` char(36) default NULL, | ||
18 | `CreatorID` char(36) default NULL, | ||
19 | `OwnerID` char(36) default NULL, | ||
20 | `GroupID` char(36) default NULL, | ||
21 | `LastOwnerID` char(36) default NULL, | ||
22 | PRIMARY KEY (`ItemID`), | 22 | PRIMARY KEY (`ItemID`), |
23 | KEY `primitems_primid` (`PrimID`) | 23 | KEY `primitems_primid` (`PrimID`) |
24 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | 24 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
25 | 25 | ||
26 | COMMIT; \ No newline at end of file | 26 | CREATE TABLE RegionSettings ( |
27 | `RegionID` char(36) default NULL, | ||
28 | |||
29 | `BlockTerraform` bit(1) default NULL, | ||
30 | `BlockFly` bit(1) default NULL, | ||
31 | `AllowDamage` bit(1) default NULL, | ||
32 | `RestrictPushing` bit(1) default NULL, | ||
33 | `AllowLandResell` bit(1) default NULL, | ||
34 | `AllowLandJoinDivide` bit(1) default NULL, | ||
35 | `BlockShowInSearch` bit(1) default NULL, | ||
36 | |||
37 | `AgentLimit` int(11) default NULL, | ||
38 | `ObjectBonus` double default NULL, | ||
39 | `Maturity` int(11) default NULL, | ||
40 | |||
41 | `DisableScripts` bit(1) default NULL, | ||
42 | `DisableCollisions` bit(1) default NULL, | ||
43 | `DisablePhysics` bit(1) default NULL, | ||
44 | |||
45 | `TerrainTexture1` char(36) default NULL, | ||
46 | `TerrainTexture2` char(36) default NULL, | ||
47 | `TerrainTexture3` char(36) default NULL, | ||
48 | `TerrainTexture4` char(36) default NULL, | ||
49 | |||
50 | `Elevation1NW` double default NULL, | ||
51 | `Elevation2NW` double default NULL, | ||
52 | `Elevation1NE` double default NULL, | ||
53 | `Elevation2NE` double default NULL, | ||
54 | `Elevation1SE` double default NULL, | ||
55 | `Elevation2SE` double default NULL, | ||
56 | `Elevation1SW` double default NULL, | ||
57 | `Elevation2SW` double default NULL, | ||
58 | |||
59 | `WaterHeight` double default NULL, | ||
60 | `TerrainRaiseLimit` double default NULL, | ||
61 | `TerrainLowerLimit` double default NULL, | ||
62 | |||
63 | `UseEstateSun` bit(1) default NULL, | ||
64 | `Sandbox` bit(1) default NULL, | ||
65 | |||
66 | `SunVectorX` double default NULL, | ||
67 | `SunVectorY` double default NULL, | ||
68 | `SunVectorZ` double default NULL, | ||
69 | |||
70 | `FixedSun` bit(1) default NULL, | ||
71 | `SunPosition` double default NULL, | ||
72 | |||
73 | `Covenant` char(36) default NULL, | ||
74 | |||
75 | PRIMARY KEY (RegionID) | ||
76 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | ||
77 | |||
78 | COMMIT; | ||