diff options
author | Sean Dague | 2008-06-12 15:21:34 +0000 |
---|---|---|
committer | Sean Dague | 2008-06-12 15:21:34 +0000 |
commit | cee071ea6080ae2c5beb495a5dee636662073734 (patch) | |
tree | 8e69c78535407d9725b31c4ea2b7f95eb1cd3545 /OpenSim/Data/MySQL | |
parent | check in migration files for mysql (diff) | |
download | opensim-SC_OLD-cee071ea6080ae2c5beb495a5dee636662073734.zip opensim-SC_OLD-cee071ea6080ae2c5beb495a5dee636662073734.tar.gz opensim-SC_OLD-cee071ea6080ae2c5beb495a5dee636662073734.tar.bz2 opensim-SC_OLD-cee071ea6080ae2c5beb495a5dee636662073734.tar.xz |
check in region store initial migration definition,
now on to integrating this approach into the mysql
driver. Beware the next couple of checkins.
Diffstat (limited to '')
-rw-r--r-- | OpenSim/Data/MySQL/Resources/001_RegionStore.sql | 150 |
1 files changed, 150 insertions, 0 deletions
diff --git a/OpenSim/Data/MySQL/Resources/001_RegionStore.sql b/OpenSim/Data/MySQL/Resources/001_RegionStore.sql new file mode 100644 index 0000000..6604c3b --- /dev/null +++ b/OpenSim/Data/MySQL/Resources/001_RegionStore.sql | |||
@@ -0,0 +1,150 @@ | |||
1 | CREATE TABLE `prims` ( | ||
2 | `UUID` varchar(255) NOT NULL, | ||
3 | `RegionUUID` varchar(255) default NULL, | ||
4 | `ParentID` int(11) default NULL, | ||
5 | `CreationDate` int(11) default NULL, | ||
6 | `Name` varchar(255) default NULL, | ||
7 | `SceneGroupID` varchar(255) default NULL, | ||
8 | `Text` varchar(255) default NULL, | ||
9 | `Description` varchar(255) default NULL, | ||
10 | `SitName` varchar(255) default NULL, | ||
11 | `TouchName` varchar(255) default NULL, | ||
12 | `ObjectFlags` int(11) default NULL, | ||
13 | `CreatorID` varchar(255) default NULL, | ||
14 | `OwnerID` varchar(255) default NULL, | ||
15 | `GroupID` varchar(255) default NULL, | ||
16 | `LastOwnerID` varchar(255) default NULL, | ||
17 | `OwnerMask` int(11) default NULL, | ||
18 | `NextOwnerMask` int(11) default NULL, | ||
19 | `GroupMask` int(11) default NULL, | ||
20 | `EveryoneMask` int(11) default NULL, | ||
21 | `BaseMask` int(11) default NULL, | ||
22 | `PositionX` float default NULL, | ||
23 | `PositionY` float default NULL, | ||
24 | `PositionZ` float default NULL, | ||
25 | `GroupPositionX` float default NULL, | ||
26 | `GroupPositionY` float default NULL, | ||
27 | `GroupPositionZ` float default NULL, | ||
28 | `VelocityX` float default NULL, | ||
29 | `VelocityY` float default NULL, | ||
30 | `VelocityZ` float default NULL, | ||
31 | `AngularVelocityX` float default NULL, | ||
32 | `AngularVelocityY` float default NULL, | ||
33 | `AngularVelocityZ` float default NULL, | ||
34 | `AccelerationX` float default NULL, | ||
35 | `AccelerationY` float default NULL, | ||
36 | `AccelerationZ` float default NULL, | ||
37 | `RotationX` float default NULL, | ||
38 | `RotationY` float default NULL, | ||
39 | `RotationZ` float default NULL, | ||
40 | `RotationW` float default NULL, | ||
41 | `SitTargetOffsetX` float default NULL, | ||
42 | `SitTargetOffsetY` float default NULL, | ||
43 | `SitTargetOffsetZ` float default NULL, | ||
44 | `SitTargetOrientW` float default NULL, | ||
45 | `SitTargetOrientX` float default NULL, | ||
46 | `SitTargetOrientY` float default NULL, | ||
47 | `SitTargetOrientZ` float default NULL, | ||
48 | PRIMARY KEY (`UUID`) | ||
49 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 | ||
50 | |||
51 | CREATE TABLE `primshapes` ( | ||
52 | `UUID` varchar(255) NOT NULL, | ||
53 | `Shape` int(11) default NULL, | ||
54 | `ScaleX` float default NULL, | ||
55 | `ScaleY` float default NULL, | ||
56 | `ScaleZ` float default NULL, | ||
57 | `PCode` int(11) default NULL, | ||
58 | `PathBegin` int(11) default NULL, | ||
59 | `PathEnd` int(11) default NULL, | ||
60 | `PathScaleX` int(11) default NULL, | ||
61 | `PathScaleY` int(11) default NULL, | ||
62 | `PathShearX` int(11) default NULL, | ||
63 | `PathShearY` int(11) default NULL, | ||
64 | `PathSkew` int(11) default NULL, | ||
65 | `PathCurve` int(11) default NULL, | ||
66 | `PathRadiusOffset` int(11) default NULL, | ||
67 | `PathRevolutions` int(11) default NULL, | ||
68 | `PathTaperX` int(11) default NULL, | ||
69 | `PathTaperY` int(11) default NULL, | ||
70 | `PathTwist` int(11) default NULL, | ||
71 | `PathTwistBegin` int(11) default NULL, | ||
72 | `ProfileBegin` int(11) default NULL, | ||
73 | `ProfileEnd` int(11) default NULL, | ||
74 | `ProfileCurve` int(11) default NULL, | ||
75 | `ProfileHollow` int(11) default NULL, | ||
76 | `State` int(11) default NULL, | ||
77 | `Texture` longblob, | ||
78 | `ExtraParams` longblob, | ||
79 | PRIMARY KEY (`UUID`) | ||
80 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 | ||
81 | |||
82 | CREATE TABLE `primitems` ( | ||
83 | `itemID` varchar(255) NOT NULL, | ||
84 | `primID` varchar(255) default NULL, | ||
85 | `assetID` varchar(255) default NULL, | ||
86 | `parentFolderID` varchar(255) default NULL, | ||
87 | `invType` int(11) default NULL, | ||
88 | `assetType` int(11) default NULL, | ||
89 | `name` varchar(255) default NULL, | ||
90 | `description` varchar(255) default NULL, | ||
91 | `creationDate` bigint(20) default NULL, | ||
92 | `creatorID` varchar(255) default NULL, | ||
93 | `ownerID` varchar(255) default NULL, | ||
94 | `lastOwnerID` varchar(255) default NULL, | ||
95 | `groupID` varchar(255) default NULL, | ||
96 | `nextPermissions` int(11) default NULL, | ||
97 | `currentPermissions` int(11) default NULL, | ||
98 | `basePermissions` int(11) default NULL, | ||
99 | `everyonePermissions` int(11) default NULL, | ||
100 | `groupPermissions` int(11) default NULL, | ||
101 | PRIMARY KEY (`itemID`) | ||
102 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 | ||
103 | |||
104 | CREATE TABLE `terrain` ( | ||
105 | `RegionUUID` varchar(255) default NULL, | ||
106 | `Revision` int(11) default NULL, | ||
107 | `Heightfield` longblob | ||
108 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 | ||
109 | |||
110 | CREATE TABLE `land` ( | ||
111 | `UUID` varchar(255) NOT NULL, | ||
112 | `RegionUUID` varchar(255) default NULL, | ||
113 | `LocalLandID` int(11) default NULL, | ||
114 | `Bitmap` longblob, | ||
115 | `Name` varchar(255) default NULL, | ||
116 | `Description` varchar(255) default NULL, | ||
117 | `OwnerUUID` varchar(255) default NULL, | ||
118 | `IsGroupOwned` int(11) default NULL, | ||
119 | `Area` int(11) default NULL, | ||
120 | `AuctionID` int(11) default NULL, | ||
121 | `Category` int(11) default NULL, | ||
122 | `ClaimDate` int(11) default NULL, | ||
123 | `ClaimPrice` int(11) default NULL, | ||
124 | `GroupUUID` varchar(255) default NULL, | ||
125 | `SalePrice` int(11) default NULL, | ||
126 | `LandStatus` int(11) default NULL, | ||
127 | `LandFlags` int(11) default NULL, | ||
128 | `LandingType` int(11) default NULL, | ||
129 | `MediaAutoScale` int(11) default NULL, | ||
130 | `MediaTextureUUID` varchar(255) default NULL, | ||
131 | `MediaURL` varchar(255) default NULL, | ||
132 | `MusicURL` varchar(255) default NULL, | ||
133 | `PassHours` float default NULL, | ||
134 | `PassPrice` int(11) default NULL, | ||
135 | `SnapshotUUID` varchar(255) default NULL, | ||
136 | `UserLocationX` float default NULL, | ||
137 | `UserLocationY` float default NULL, | ||
138 | `UserLocationZ` float default NULL, | ||
139 | `UserLookAtX` float default NULL, | ||
140 | `UserLookAtY` float default NULL, | ||
141 | `UserLookAtZ` float default NULL, | ||
142 | `AuthbuyerID` varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000', | ||
143 | PRIMARY KEY (`UUID`) | ||
144 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 2' | ||
145 | |||
146 | CREATE TABLE `landaccesslist` ( | ||
147 | `LandUUID` varchar(255) default NULL, | ||
148 | `AccessUUID` varchar(255) default NULL, | ||
149 | `Flags` int(11) default NULL | ||
150 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 \ No newline at end of file | ||