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