|
現: 2013-01-20 (日) 12:15:25 iseki |
| + | *** land [#f8c58fa2] |
| + | - Percel の情報 |
| | | |
| + | mysql> show columns from land; |
| + | +------------------+--------------+------+-----+--------------------------------------+-------+ |
| + | | Field | Type | Null | Key | Default | Extra | |
| + | +------------------+--------------+------+-----+--------------------------------------+-------+ |
| + | | UUID | varchar(255) | NO | PRI | NULL | | |
| + | | RegionUUID | varchar(255) | YES | | NULL | | |
| + | | LocalLandID | int(11) | YES | | NULL | | |
| + | | Bitmap | longblob | YES | | NULL | | |
| + | | Name | varchar(255) | YES | | NULL | | |
| + | | Description | varchar(255) | YES | | NULL | | |
| + | | OwnerUUID | varchar(255) | YES | | NULL | | |
| + | | IsGroupOwned | int(11) | YES | | NULL | | |
| + | | Area | int(11) | YES | | NULL | | |
| + | | AuctionID | int(11) | YES | | NULL | | |
| + | | Category | int(11) | YES | | NULL | | |
| + | | ClaimDate | int(11) | YES | | NULL | | |
| + | | ClaimPrice | int(11) | YES | | NULL | | |
| + | | GroupUUID | varchar(255) | YES | | NULL | | |
| + | | SalePrice | int(11) | YES | | NULL | | |
| + | | LandStatus | int(11) | YES | | NULL | | |
| + | | LandFlags | int(11) | YES | | NULL | | |
| + | | LandingType | int(11) | YES | | NULL | | |
| + | | MediaAutoScale | int(11) | YES | | NULL | | |
| + | | MediaTextureUUID | varchar(255) | YES | | NULL | | |
| + | | MediaURL | varchar(255) | YES | | NULL | | |
| + | | MusicURL | varchar(255) | YES | | NULL | | |
| + | | PassHours | float | YES | | NULL | | |
| + | | PassPrice | int(11) | YES | | NULL | | |
| + | | SnapshotUUID | varchar(255) | YES | | NULL | | |
| + | | UserLocationX | float | YES | | NULL | | |
| + | | UserLocationY | float | YES | | NULL | | |
| + | | UserLocationZ | float | YES | | NULL | | |
| + | | UserLookAtX | float | YES | | NULL | | |
| + | | UserLookAtY | float | YES | | NULL | | |
| + | | UserLookAtZ | float | YES | | NULL | | |
| + | | AuthbuyerID | varchar(36) | NO | | 00000000-0000-0000-0000-000000000000 | | |
| + | | OtherCleanTime | int(11) | NO | | 0 | | |
| + | | Dwell | int(11) | NO | | 0 | | |
| + | +------------------+--------------+------+-----+--------------------------------------+-------+ |
| + | |
| + | |
| + | mysql> select UUID,RegionUUID,LocalLandID,OwnerUUID from land; |
| + | +--------------------------------------+--------------------------------------+-------------+--------------------------------------+ |
| + | | UUID | RegionUUID | LocalLandID | OwnerUUID | |
| + | +--------------------------------------+--------------------------------------+-------------+--------------------------------------+ |
| + | | 377ad0dd-cb49-46a5-b3be-e9193cc749ea | 34827a0c-0302-4d9c-a28c-36f76311714d | 1 | 61dfee5c-2440-49f7-8668-a47cecb19d04 | |
| + | | 164498d4-132a-4f4f-802b-bb42ff352158 | 088d4478-e4a0-4833-8e41-6706f37e5b60 | 1 | 61dfee5c-2440-49f7-8668-a47cecb19d04 | |
| + | | 8cd11b8a-df6e-4166-8903-b56d0d251167 | 92af7cfc-dfc6-4470-9c2c-25e8ff70484c | 1 | db21ae18-0277-469e-b350-3dd728cf0e2f | |
| + | | 30b61774-220a-47fd-9b12-0f0cbf1a1e20 | 41e37fbc-6e08-4de3-83e9-b72e46089f1c | 1 | 61dfee5c-2440-49f7-8668-a47cecb19d04 | |
| + | | ab7468e2-993a-4ff3-ad5b-a2453d1bdac9 | d4382b69-58c2-43bc-bd78-e093de55d87b | 1 | fa12ae9e-c003-4cb2-9e2d-a68209fceb08 | |
| + | | f970d2b6-d186-401a-9323-c5fd8291a939 | 7399dbdf-97e4-40f8-8e4c-05ce13dfc995 | 1 | 61dfee5c-2440-49f7-8668-a47cecb19d04 | |
| + | | a6a46c89-7109-47ad-84f8-ebb2831a5a01 | 27425ff2-ba01-42d5-9564-d07cffa6b213 | 1 | 61dfee5c-2440-49f7-8668-a47cecb19d04 | |
| + | | c2050123-40f3-4b64-9ed1-f8ebb608eb33 | 87b03ad8-ff29-450b-a070-d82e44b50ed1 | 1 | e5e2c64f-3b92-4406-a4b3-153f2466e5a4 | |
| + | | 4b01e97a-4d0a-48f1-9d0f-0b0ce299a215 | 00000000-0000-0000-0000-000000000000 | 1 | 386f3ea9-6a06-4069-b641-afcf575f4edf | |
| + | | 14294b57-d53e-4f42-bf0d-401e2059f63b | 0272dd43-2a19-4182-bb82-fe4343fce481 | 1 | 386f3ea9-6a06-4069-b641-afcf575f4edf | |
| + | | 5d5f3f4b-7525-47cf-833c-4c4aa31f1fb2 | 4f9324ff-1659-4509-995f-7e8e13dc6594 | 1 | 61dfee5c-2440-49f7-8668-a47cecb19d04 | |
| + | | f0273ac2-1b1d-44ef-9a0f-bb89f6081d1f | 34827a0c-0302-4d9c-a28c-36f76311714d | 2 | 61dfee5c-2440-49f7-8668-a47cecb19d04 | |
| + | | a4af409e-bed2-47f1-b3a5-44602bb6de4f | 34827a0c-0302-4d9c-a28c-36f76311714d | 3 | 61dfee5c-2440-49f7-8668-a47cecb19d04 | |
| + | | 5805e88a-bcc7-4ac0-9e25-2f5b82d5c6d9 | 873f051d-357a-4b61-9280-7957f7b86092 | 1 | 3c0dacbb-f360-43b5-b825-c7fbded9b73f | |
| + | | 7959f692-9b6d-4c27-8606-2fcee106c7fc | 33264fb9-2420-4b96-993e-cddbd8be3992 | 1 | 9534ce55-b18e-451f-9c7d-2423fbc1a431 | |
| + | | 6e07f145-6168-43ee-8b04-c25804a13680 | c43cb0f9-47ac-4409-a2f8-1ec348884455 | 1 | 9534ce55-b18e-451f-9c7d-2423fbc1a431 | |
| + | | 9277765d-6d9c-4f34-8ffc-0e153f74c2d9 | 5b4ffa30-5b21-11de-8a39-0800200c9a66 | 1 | 9534ce55-b18e-451f-9c7d-2423fbc1a431 | |
| + | | be2ef072-29eb-4e42-ba11-11a399bcf57a | 60a8f668-be15-485e-8a2a-d058d3ea880f | 1 | 9534ce55-b18e-451f-9c7d-2423fbc1a431 | |
| + | | 83823109-276b-4945-be32-5e1fd12c7370 | 60a8f669-be15-485e-8a2a-d058d3ea880f | 1 | 9534ce55-b18e-451f-9c7d-2423fbc1a431 | |
| + | | 4e3a3084-25a8-4023-b015-fc7a93efa9a6 | 60a8f667-be15-485e-8a2a-d058d3ea880f | 1 | 9534ce55-b18e-451f-9c7d-2423fbc1a431 | |
| + | | 96ad6008-2a00-483d-94b1-ed2dee3f1de3 | 27425ff2-ba01-42d5-9564-d07cffa6b214 | 1 | 61dfee5c-2440-49f7-8668-a47cecb19d04 | |
| + | | 47987fc1-fe40-4fe5-9bb6-6d2d55a7c6e3 | a6d44dbb-b2ab-4ff5-8835-c0b62ed7fc39 | 1 | 9534ce55-b18e-451f-9c7d-2423fbc1a431 | |
| + | | 2f8867ac-513c-47a1-9e80-fbc23d130a2e | a6d45dbb-b2ab-4ff5-8835-c0b62ed7fc39 | 1 | 9534ce55-b18e-451f-9c7d-2423fbc1a431 | |
| + | | 703b0e95-52dc-4e23-b73b-cf4bc6a74b35 | a6d42dbb-b2ab-4ff5-8835-c0b62ed7fc39 | 1 | 9534ce55-b18e-451f-9c7d-2423fbc1a431 | |
| + | | e1adc3c2-0449-4cff-b9d9-fd8c67adc654 | 3a40dfa9-4e98-4cdf-8d46-8b892d9d0c71 | 1 | 9534ce55-b18e-451f-9c7d-2423fbc1a431 | |
| + | | 402e66ee-f320-46ae-84fe-a58f734aa975 | 3a40dfa6-4e98-4cdf-8d46-8b892d9d0c71 | 1 | 9534ce55-b18e-451f-9c7d-2423fbc1a431 | |
| + | | f24bfbee-2ca9-41e4-b8bf-c264b80b7bd7 | f5d87a3d-2dd9-4f19-8430-c49c0655dcab | 1 | 61dfee5c-2440-49f7-8668-a47cecb19d04 | |
| + | | 8918b599-6925-450e-9797-6d3ba5e97546 | 8ac7ce2f-bcd9-4208-a70a-75c9f80e0c85 | 1 | 61dfee5c-2440-49f7-8668-a47cecb19d04 | |
| + | | febbfd1e-a454-4912-803e-18762ff10f48 | a6d44dbb-b2ab-4ff5-8835-c0b62ed7fc59 | 1 | 9534ce55-b18e-451f-9c7d-2423fbc1a431 | |
| + | | 56ea74f6-1c3c-4811-86e4-78d2fb7af4d9 | a6d45dbb-b2ab-4ff5-8835-c0b62ed7fc79 | 1 | 9534ce55-b18e-451f-9c7d-2423fbc1a431 | |
| + | | a3f8542f-6a1c-4e13-a64c-1e2ea1935751 | f5d87a3d-2dd9-4f19-8430-c49c0655dcab | 2 | 61dfee5c-2440-49f7-8668-a47cecb19d04 | |
| + | | 6f1e39cc-21dc-4518-8c7e-b4c4d07a43f9 | f5d87a3d-2dd9-4f19-8430-c49c0655dcab | 3 | 67e9ea2c-1a43-4f30-bb49-11eac57cb949 | |
| + | | 4233b7a4-f0fc-4f1c-af27-bfaaeefcb3c0 | f5d87a3d-2dd9-4f19-8430-c49c0655dcab | 4 | 9f8a48ee-ab97-4118-8afc-bffcb4684af0 | |
| + | | f4f94607-9e6d-4ba3-b059-97639f3ce60c | f5d87a3d-2dd9-4f19-8430-c49c0655dcab | 5 | 71dbde46-447b-4df7-aa17-b4973b7b2afd | |
| + | | a1548729-e605-4bd7-94bb-6498441162a5 | f5d87a3d-2dd9-4f19-8430-c49c0655dcab | 6 | 61dfee5c-2440-49f7-8668-a47cecb19d04 | |
| + | | 0cb3b15a-d079-42e9-869e-2fd8b9038e0b | f5d87a3d-2dd9-4f19-8430-c49c0655dcab | 7 | 61dfee5c-2440-49f7-8668-a47cecb19d04 | |
| + | | 93fe458e-8723-4e5b-93a6-72187c6a3401 | f5d87a3d-2dd9-4f19-8430-c49c0655dcab | 8 | 61dfee5c-2440-49f7-8668-a47cecb19d04 | |
| + | | 137c0ad9-91a8-4873-bc48-a3c325c3681e | f5d87a3d-2dd9-4f19-8430-c49c0655dcab | 9 | 61dfee5c-2440-49f7-8668-a47cecb19d04 | |
| + | | 4098957d-1010-434a-b9a5-0e4251a3af57 | f5d87a3d-2dd9-4f19-8430-c49c0655dcab | 10 | dbefe036-09c6-4598-acbb-9cfd97139dff | |
| + | | f2ec7ccd-7073-4207-97e2-edcadca77c72 | 21049c4f-37a0-4ac8-80fe-736984e1077c | 1 | 61dfee5c-2440-49f7-8668-a47cecb19d04 | |
| + | | f09df514-3394-4e17-8264-a8f959f657e7 | 80f4a6ad-7bab-410c-ae9f-d81e80462574 | 1 | 61dfee5c-2440-49f7-8668-a47cecb19d04 | |
| + | | 18059d08-8e3b-427f-bf90-9a39d8d22075 | 3bb8f52b-6d41-4d35-a09c-9c8d44ba91a5 | 1 | 3c0dacbb-f360-43b5-b825-c7fbded9b73f | |
| + | | 0d1bd354-e6a0-40e3-a491-dcfa1e83dfab | 28187f4f-673e-4bef-9ce3-ee1f2bcb0ee5 | 1 | 3c0dacbb-f360-43b5-b825-c7fbded9b73f | |
| + | +--------------------------------------+--------------------------------------+-------------+--------------------------------------+ |