aboutsummaryrefslogtreecommitdiffstatshomepage
diff options
context:
space:
mode:
authorSean Dague2008-06-12 15:21:34 +0000
committerSean Dague2008-06-12 15:21:34 +0000
commitcee071ea6080ae2c5beb495a5dee636662073734 (patch)
tree8e69c78535407d9725b31c4ea2b7f95eb1cd3545
parentcheck in migration files for mysql (diff)
downloadopensim-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.
-rw-r--r--OpenSim/Data/MySQL/Resources/001_RegionStore.sql150
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 @@
1CREATE 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
51CREATE 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
82CREATE 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
104CREATE TABLE `terrain` (
105 `RegionUUID` varchar(255) default NULL,
106 `Revision` int(11) default NULL,
107 `Heightfield` longblob
108) ENGINE=MyISAM DEFAULT CHARSET=latin1
109
110CREATE 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
146CREATE 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