OpenSimulator GForge > Projects > SQLite to MySQL converter > SVN

Diff of /trunk/transferRegion

 Legend:



Removed from v.10
 


changed lines


 
Added in v.11
 Legend:



Removed from v.10
 


changed lines


 
Added in v.11
-Removed from v.10
+Added in v.11

	ViewVC Help
Powered by ViewVC 1.0.0

	revision 10, Mon Feb 9 22:33:17 2009 UTC	revision 11, Mon May 11 20:39:41 2009 UTC
#	Line 21	Line 21
21	# SQLite3: TABLE estate_groups(EstateID, uuid)	# SQLite3: TABLE estate_groups(EstateID, uuid)
22	# MySQL: TABLE estate_groups(EstateID, uuid)	# MySQL: TABLE estate_groups(EstateID, uuid)
23	deleteContents($db2, 'estate_groups');	deleteContents($db2, 'estate_groups');
24	transfer($db1, $db2, 'estate_groups', [ 1 ], [ 'EstateID', 'uuid' ]);	transfer($db1, $db2, 'estate_groups', [ 'EstateID', 'uuid' ]);
25
26	# SQLite3: TABLE estate_managers(EstateID, uuid)	# SQLite3: TABLE estate_managers(EstateID, uuid)
27	# MySQL: TABLE estate_managers(EstateID, uuid)	# MySQL: TABLE estate_managers(EstateID, uuid)
28	deleteContents($db2, 'estate_managers');	deleteContents($db2, 'estate_managers');
29	transfer($db1, $db2, 'estate_managers', [ 1 ], [ 'EstateID', 'uuid' ]);	transfer($db1, $db2, 'estate_managers', [ 'EstateID', 'uuid' ]);
30
31	# SQLite3: TABLE estate_map(RegionID, EstateID)	# SQLite3: TABLE estate_map(RegionID, EstateID)
32	# MySQL: TABLE estate_map(RegionID, EstateID)	# MySQL: TABLE estate_map(RegionID, EstateID)
33	deleteContents($db2, 'estate_map');	deleteContents($db2, 'estate_map');
34	transfer($db1, $db2, 'estate_map', [ 0 ], [ 'RegionID', 'EstateID' ]);	transfer($db1, $db2, 'estate_map', [ 'RegionID', 'EstateID' ]);
35
36	# SQLite3: TABLE estate_settings(EstateID, EstateName, AbuseEmailToEstateOwner, DenyAnonymous, ResetHomeOnTeleport,	# SQLite3: TABLE estate_settings(EstateID, EstateName, AbuseEmailToEstateOwner, DenyAnonymous, ResetHomeOnTeleport,
37	# FixedSun, DenyTransacted, BlockDwell, DenyIdentified, AllowVoice, UseGlobalTime,	# FixedSun, DenyTransacted, BlockDwell, DenyIdentified, AllowVoice, UseGlobalTime,
#	Line 44	Line 44
44	# ParentEstateID, SunPosition, EstateSkipScripts, BillableFactor, PublicAccess, AbuseEmail,	# ParentEstateID, SunPosition, EstateSkipScripts, BillableFactor, PublicAccess, AbuseEmail,
45	# EstateOwner, DenyMinors)	# EstateOwner, DenyMinors)
46	deleteContents($db2, 'estate_settings');	deleteContents($db2, 'estate_settings');
47	transfer($db1, $db2, 'estate_settings', [ 22 ], [	transfer($db1, $db2, 'estate_settings', [
48	'EstateID', 'EstateName', 'AbuseEmailToEstateOwner', 'DenyAnonymous', 'ResetHomeOnTeleport', 'FixedSun',	'EstateID', 'EstateName', 'AbuseEmailToEstateOwner', 'DenyAnonymous', 'ResetHomeOnTeleport', 'FixedSun',
49	'DenyTransacted', 'BlockDwell', 'DenyIdentified', 'AllowVoice', 'UseGlobalTime', 'PricePerMeter', 'TaxFree',	'DenyTransacted', 'BlockDwell', 'DenyIdentified', 'AllowVoice', 'UseGlobalTime', 'PricePerMeter', 'TaxFree',
50	'AllowDirectTeleport', 'RedirectGridX', 'RedirectGridY', 'ParentEstateID', 'SunPosition', 'EstateSkipScripts',	'AllowDirectTeleport', 'RedirectGridX', 'RedirectGridY', 'ParentEstateID', 'SunPosition', 'EstateSkipScripts',
#	Line 53	Line 53
53	# SQLite3: TABLE estate_users(EstateID, uuid);	# SQLite3: TABLE estate_users(EstateID, uuid);
54	# MySQL: TABLE estate_users(EstateID, uuid);	# MySQL: TABLE estate_users(EstateID, uuid);
55	deleteContents($db2, 'estate_users');	deleteContents($db2, 'estate_users');
56	transfer($db1, $db2, 'estate_users', [ 1 ], [ 'EstateID', 'uuid' ]);	transfer($db1, $db2, 'estate_users', [ 'EstateID', 'uuid' ]);
57
58	# SQLite3: TABLE estateban(EstateID, bannedUUID, bannedIp, bannedIpHostMask, bannedNameMask)	# SQLite3: TABLE estateban(EstateID, bannedUUID, bannedIp, bannedIpHostMask, bannedNameMask)
59	# MySQL: TABLE estateban(EstateID, bannedUUID, bannedIp, bannedIpHostMask, bannedNameMask)	# MySQL: TABLE estateban(EstateID, bannedUUID, bannedIp, bannedIpHostMask, bannedNameMask)
60	deleteContents($db2, 'estateban');	deleteContents($db2, 'estateban');
61	transfer($db1, $db2, 'estateban', [ 1 ], [ 'EstateID', 'bannedUUID', 'bannedIp', 'bannedIpHostMask', 'bannedNameMask' ]);	transfer($db1, $db2, 'estateban', [ 'EstateID', 'bannedUUID', 'bannedIp', 'bannedIpHostMask', 'bannedNameMask' ]);
62
63	# SQLite3: TABLE land(UUID, RegionUUID, LocalLandID, Bitmap, Name, Desc, OwnerUUID, IsGroupOwned, Area, AuctionID,	# SQLite3: TABLE land(UUID, RegionUUID, LocalLandID, Bitmap, Name, Desc, OwnerUUID, IsGroupOwned, Area, AuctionID,
64	# Category, ClaimDate, ClaimPrice, GroupUUID, SalePrice, LandStatus, LandFlags, LandingType,	# Category, ClaimDate, ClaimPrice, GroupUUID, SalePrice, LandStatus, LandFlags, LandingType,
#	Line 72	Line 72
72	# OtherCleanTime, Dwell)	# OtherCleanTime, Dwell)
73	deleteContents($db2, 'land');	deleteContents($db2, 'land');
74	# NOTE: UUIDs in the this table are without dashes, except AuthbuyerID!	# NOTE: UUIDs in the this table are without dashes, except AuthbuyerID!
75	transfer($db1, $db2, 'land', [ 31 ], [	transfer($db1, $db2, 'land', [
76	'UUID', 'RegionUUID', 'LocalLandID', 'Bitmap', 'Name', 'Desc', 'OwnerUUID', 'IsGroupOwned', 'Area',	'UUID', 'RegionUUID', 'LocalLandID', 'Bitmap', 'Name', 'Desc', 'OwnerUUID', 'IsGroupOwned', 'Area',
77	'AuctionID', 'Category', 'ClaimDate', 'ClaimPrice', 'GroupUUID', 'SalePrice', 'LandStatus', 'LandFlags',	'AuctionID', 'Category', 'ClaimDate', 'ClaimPrice', 'GroupUUID', 'SalePrice', 'LandStatus', 'LandFlags',
78	'LandingType', 'MediaAutoScale', 'MediaTextureUUID', 'MediaURL', 'MusicURL', 'PassHours', 'PassPrice',	'LandingType', 'MediaAutoScale', 'MediaTextureUUID', 'MediaURL', 'MusicURL', 'PassHours', 'PassPrice',
#	Line 83	Line 83
83	# MySQL: TABLE landaccesslist(LandUUID, AccessUUID, Flags)	# MySQL: TABLE landaccesslist(LandUUID, AccessUUID, Flags)
84	deleteContents($db2, 'landaccesslist');	deleteContents($db2, 'landaccesslist');
85	# NOTE: UUIDs in the this table are without dashes!	# NOTE: UUIDs in the this table are without dashes!
86	transfer($db1, $db2, 'landaccesslist', [ ], [ 'LandUUID', 'AccessUUID', 'Flags' ]);	transfer($db1, $db2, 'landaccesslist', [ 'LandUUID', 'AccessUUID', 'Flags' ]);
87
88	# SQLite3: TABLE primitems(itemID, primID, assetID, parentFolderID, invType, assetType, name, description, creationDate,	# SQLite3: TABLE primitems(itemID, primID, assetID, parentFolderID, invType, assetType, name, description, creationDate,
89	# creatorID, ownerID, lastOwnerID, groupID, nextPermissions, currentPermissions,	# creatorID, ownerID, lastOwnerID, groupID, nextPermissions, currentPermissions,
#	Line 92	Line 92
92	# basePermissions, everyonePermissions, groupPermissions, flags, itemID, primID, assetID,	# basePermissions, everyonePermissions, groupPermissions, flags, itemID, primID, assetID,
93	# parentFolderID, creatorID, ownerID, groupID, lastOwnerID)	# parentFolderID, creatorID, ownerID, groupID, lastOwnerID)
94	deleteContents($db2, 'primitems');	deleteContents($db2, 'primitems');
95	transfer($db1, $db2, 'primitems', [ 11, 12, 13, 14, 15, 16, 17, 18 ], [	transfer($db1, $db2, 'primitems', [
96	'invType', 'assetType', 'name', 'description', 'creationDate', 'nextPermissions', 'currentPermissions',	'invType', 'assetType', 'name', 'description', 'creationDate', 'nextPermissions', 'currentPermissions',
97	'basePermissions', 'everyonePermissions', 'groupPermissions', 'flags', 'itemID', 'primID', 'assetID',	'basePermissions', 'everyonePermissions', 'groupPermissions', 'flags', 'itemID', 'primID', 'assetID',
98	'parentFolderID', 'creatorID', 'ownerID', 'groupID', 'lastOwnerID' ]);	'parentFolderID', 'creatorID', 'ownerID', 'groupID', 'lastOwnerID' ]);
#	Line 124	Line 124
124	# CollisionSoundVolume, VolumeDetect, LinkNumber)	# CollisionSoundVolume, VolumeDetect, LinkNumber)
125	deleteContents($db2, 'prims');	deleteContents($db2, 'prims');
126	# NOTE: UUIDs in the this table are partly without dashes (except LoopedSound)!	# NOTE: UUIDs in the this table are partly without dashes (except LoopedSound)!
127	transfer($db1, $db2, 'prims', [ 56 ], [	transfer($db1, $db2, 'prims', [
128	'CreationDate', 'Name', 'Text', 'Description', 'SitName', 'TouchName', 'ObjectFlags', 'OwnerMask',	'CreationDate', 'Name', 'Text', 'Description', 'SitName', 'TouchName', 'ObjectFlags', 'OwnerMask',
129	'NextOwnerMask', 'GroupMask', 'EveryoneMask', 'BaseMask', 'PositionX', 'PositionY', 'PositionZ',	'NextOwnerMask', 'GroupMask', 'EveryoneMask', 'BaseMask', 'PositionX', 'PositionY', 'PositionZ',
130	'GroupPositionX', 'GroupPositionY', 'GroupPositionZ', 'VelocityX', 'VelocityY', 'VelocityZ',	'GroupPositionX', 'GroupPositionY', 'GroupPositionZ', 'VelocityX', 'VelocityY', 'VelocityZ',
#	Line 150	Line 150
150	# Texture, ExtraParams, UUID)	# Texture, ExtraParams, UUID)
151	deleteContents($db2, 'primshapes');	deleteContents($db2, 'primshapes');
152	# NOTE: UUIDs in the this table are without dashes!	# NOTE: UUIDs in the this table are without dashes!
153	transfer($db1, $db2, 'primshapes', [ ], [	transfer($db1, $db2, 'primshapes', [
154	'Shape', 'ScaleX', 'ScaleY', 'ScaleZ', 'PCode', 'PathBegin', 'PathEnd', 'PathScaleX', 'PathScaleY',	'Shape', 'ScaleX', 'ScaleY', 'ScaleZ', 'PCode', 'PathBegin', 'PathEnd', 'PathScaleX', 'PathScaleY',
155	'PathShearX', 'PathShearY', 'PathSkew', 'PathCurve', 'PathRadiusOffset', 'PathRevolutions', 'PathTaperX',	'PathShearX', 'PathShearY', 'PathSkew', 'PathCurve', 'PathRadiusOffset', 'PathRevolutions', 'PathTaperX',
156	'PathTaperY', 'PathTwist', 'PathTwistBegin', 'ProfileBegin', 'ProfileEnd', 'ProfileCurve', 'ProfileHollow',	'PathTaperY', 'PathTwist', 'PathTwistBegin', 'ProfileBegin', 'ProfileEnd', 'ProfileCurve', 'ProfileHollow',
#	Line 159	Line 159
159	# SQLite3: TABLE regionban(regionUUID, bannedUUID, bannedIp, bannedIpHostMask)	# SQLite3: TABLE regionban(regionUUID, bannedUUID, bannedIp, bannedIpHostMask)
160	# MySQL: TABLE regionban(regionUUID, bannedUUID, bannedIp, bannedIpHostMask)	# MySQL: TABLE regionban(regionUUID, bannedUUID, bannedIp, bannedIpHostMask)
161	deleteContents($db2, 'regionban');	deleteContents($db2, 'regionban');
162	transfer($db1, $db2, 'regionban', [ 0, 1 ], [ 'regionUUID', 'bannedUUID', 'bannedIp', 'bannedIpHostMask' ]);	transfer($db1, $db2, 'regionban', [ 'regionUUID', 'bannedUUID', 'bannedIp', 'bannedIpHostMask' ]);
163
164	# SQLite3: TABLE regionsettings(regionUUID, block_terraform, block_fly, allow_damage, restrict_pushing,	# SQLite3: TABLE regionsettings(regionUUID, block_terraform, block_fly, allow_damage, restrict_pushing,
165	# allow_land_resell, allow_land_join_divide, block_show_in_search, agent_limit,	# allow_land_resell, allow_land_join_divide, block_show_in_search, agent_limit,
#	Line 177	Line 177
177	# terrain_lower_limit, use_estate_sun, fixed_sun, sun_position, covenant, Sandbox,	# terrain_lower_limit, use_estate_sun, fixed_sun, sun_position, covenant, Sandbox,
178	# sunvectorx, sunvectory, sunvectorz)	# sunvectorx, sunvectory, sunvectorz)
179	deleteContents($db2, 'regionsettings');	deleteContents($db2, 'regionsettings');
180	transfer($db1, $db2, 'regionsettings', [ 0, 14, 15, 16, 17, 32 ], [	transfer($db1, $db2, 'regionsettings', [
181	'regionUUID', 'block_terraform', 'block_fly', 'allow_damage', 'restrict_pushing', 'allow_land_resell',	'regionUUID', 'block_terraform', 'block_fly', 'allow_damage', 'restrict_pushing', 'allow_land_resell',
182	'allow_land_join_divide', 'block_show_in_search', 'agent_limit', 'object_bonus', 'maturity', 'disable_scripts',	'allow_land_join_divide', 'block_show_in_search', 'agent_limit', 'object_bonus', 'maturity', 'disable_scripts',
183	'disable_collisions', 'disable_physics', 'terrain_texture_1', 'terrain_texture_2', 'terrain_texture_3',	'disable_collisions', 'disable_physics', 'terrain_texture_1', 'terrain_texture_2', 'terrain_texture_3',
#	Line 190	Line 190
190	# MySQL: TABLE terrain(RegionUUID, Revision, Heightfield)	# MySQL: TABLE terrain(RegionUUID, Revision, Heightfield)
191	deleteContents($db2, 'terrain');	deleteContents($db2, 'terrain');
192	# NOTE: UUIDs in the this table are without dashes!	# NOTE: UUIDs in the this table are without dashes!
193	transfer($db1, $db2, 'terrain', [ ], [ 'RegionUUID', 'Revision', 'Heightfield' ]);	transfer($db1, $db2, 'terrain', [ 'RegionUUID', 'Revision', 'Heightfield' ],
194		sub {
195		my $ref = shift;
196		$ref->[0] =~ s/-//g
197		}
198		);
199
200
201	$db2->commit;	$db2->commit;

MyGforge Home

SQLite to MySQL converter

Diff of /trunk/transferRegion