diff options
-rw-r--r-- | OpenSim/Data/NHibernate/Resources/MySQLDialect/002_RegionStore.sql | 9 | ||||
-rw-r--r-- | OpenSim/Data/NHibernate/Resources/MySQLDialect/003_RegionStore.sql | 78 |
2 files changed, 0 insertions, 87 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/MySQLDialect/002_RegionStore.sql b/OpenSim/Data/NHibernate/Resources/MySQLDialect/002_RegionStore.sql deleted file mode 100644 index d34d44e..0000000 --- a/OpenSim/Data/NHibernate/Resources/MySQLDialect/002_RegionStore.sql +++ /dev/null | |||
@@ -1,9 +0,0 @@ | |||
1 | BEGIN; | ||
2 | |||
3 | CREATE TABLE `Terrain` ( | ||
4 | `RegionID` char(36) not null, | ||
5 | `MapData` longblob, | ||
6 | PRIMARY KEY (`RegionID`) | ||
7 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | ||
8 | |||
9 | COMMIT; | ||
diff --git a/OpenSim/Data/NHibernate/Resources/MySQLDialect/003_RegionStore.sql b/OpenSim/Data/NHibernate/Resources/MySQLDialect/003_RegionStore.sql deleted file mode 100644 index e30287b..0000000 --- a/OpenSim/Data/NHibernate/Resources/MySQLDialect/003_RegionStore.sql +++ /dev/null | |||
@@ -1,78 +0,0 @@ | |||
1 | BEGIN; | ||
2 | |||
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, | ||
13 | `InvType` int(11) default NULL, | ||
14 | `Name` varchar(255) default NULL, | ||
15 | `Description` varchar(255) default NULL, | ||
16 | `NextPermissions` int(11) default NULL, | ||
17 | `CurrentPermissions` int(11) default NULL, | ||
18 | `BasePermissions` int(11) default NULL, | ||
19 | `EveryonePermissions` int(11) default NULL, | ||
20 | `GroupPermissions` int(11) default NULL, | ||
21 | `Flags` int(11) NOT NULL default '0', | ||
22 | PRIMARY KEY (`ItemID`), | ||
23 | KEY `primitems_primid` (`PrimID`) | ||
24 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | ||
25 | |||
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; | ||