Difference between revisions of "Character appearance (Database Table)"
From SWGANH Wiki
(New page: {{PageHeader|Database Table|character_appearance}} {| border="0" width="90%" cellpadding=6 |- |valign=top| ==Table Structure== {| align="center" |- || {| class = "wikitable" |- align="c...) |
(→Table Describe) |
||
Line 41: | Line 41: | ||
==Table Describe== | ==Table Describe== | ||
<pre> | <pre> | ||
− | + | mysql> desc character_appearance; | |
+ | +-------------------+---------------------+------+-----+---------+-------+ | ||
+ | | Field | Type | Null | Key | Default | Extra | | ||
+ | +-------------------+---------------------+------+-----+---------+-------+ | ||
+ | | character_id | bigint(20) unsigned | NO | PRI | 0 | | | ||
+ | | 00FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 01FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 02FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 03FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 04FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 05FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 06FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 07FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 08FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 09FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 0AFF | int(10) unsigned | YES | | NULL | | | ||
+ | | 0BFF | int(10) unsigned | YES | | NULL | | | ||
+ | | 0CFF | int(10) unsigned | YES | | NULL | | | ||
+ | | 0DFF | int(10) unsigned | YES | | NULL | | | ||
+ | | 0EFF | int(10) unsigned | YES | | NULL | | | ||
+ | | 0FFF | int(10) unsigned | YES | | NULL | | | ||
+ | | 10FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 11FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 12FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 13FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 14FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 15FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 16FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 17FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 18FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 19FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 1AFF | int(10) unsigned | YES | | NULL | | | ||
+ | | 1BFF | int(10) unsigned | YES | | NULL | | | ||
+ | | 1CFF | int(10) unsigned | YES | | NULL | | | ||
+ | | 1DFF | int(10) unsigned | YES | | NULL | | | ||
+ | | 1EFF | int(10) unsigned | YES | | NULL | | | ||
+ | | 1FFF | int(10) unsigned | YES | | NULL | | | ||
+ | | 20FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 21FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 22FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 23FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 24FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 25FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 26FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 27FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 28FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 29FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 2AFF | int(10) unsigned | YES | | NULL | | | ||
+ | | 2BFF | int(10) unsigned | YES | | NULL | | | ||
+ | | 2CFF | int(10) unsigned | YES | | NULL | | | ||
+ | | 2DFF | int(10) unsigned | YES | | NULL | | | ||
+ | | 2EFF | int(10) unsigned | YES | | NULL | | | ||
+ | | 2FFF | int(10) unsigned | YES | | NULL | | | ||
+ | | 30FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 31FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 32FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 33FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 34FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 35FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 36FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 37FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 38FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 39FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 3AFF | int(10) unsigned | YES | | NULL | | | ||
+ | | 3BFF | int(10) unsigned | YES | | NULL | | | ||
+ | | 3CFF | int(10) unsigned | YES | | NULL | | | ||
+ | | 3DFF | int(10) unsigned | YES | | NULL | | | ||
+ | | 3EFF | int(10) unsigned | YES | | NULL | | | ||
+ | | 3FFF | int(10) unsigned | YES | | NULL | | | ||
+ | | 40FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 41FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 42FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 43FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 44FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 45FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 46FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 47FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 48FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 49FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 4AFF | int(10) unsigned | YES | | NULL | | | ||
+ | | 4BFF | int(10) unsigned | YES | | NULL | | | ||
+ | | 4CFF | int(10) unsigned | YES | | NULL | | | ||
+ | | 4DFF | int(10) unsigned | YES | | NULL | | | ||
+ | | 4EFF | int(10) unsigned | YES | | NULL | | | ||
+ | | 4FFF | int(10) unsigned | YES | | NULL | | | ||
+ | | 50FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 51FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 52FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 53FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 54FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 55FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 56FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 57FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 58FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 59FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 5AFF | int(10) unsigned | YES | | NULL | | | ||
+ | | 5BFF | int(10) unsigned | YES | | NULL | | | ||
+ | | 5CFF | int(10) unsigned | YES | | NULL | | | ||
+ | | 5DFF | int(10) unsigned | YES | | NULL | | | ||
+ | | 5EFF | int(10) unsigned | YES | | NULL | | | ||
+ | | 5FFF | int(10) unsigned | YES | | NULL | | | ||
+ | | 60FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 61FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 62FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 63FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 64FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 65FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 66FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 67FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 68FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 69FF | int(10) unsigned | YES | | NULL | | | ||
+ | | 6AFF | int(10) unsigned | YES | | NULL | | | ||
+ | | 6BFF | int(10) unsigned | YES | | NULL | | | ||
+ | | 6CFF | int(10) unsigned | YES | | NULL | | | ||
+ | | 6DFF | int(10) unsigned | YES | | NULL | | | ||
+ | | 6EFF | int(10) unsigned | YES | | NULL | | | ||
+ | | 6FFF | int(10) unsigned | YES | | NULL | | | ||
+ | | 70FF | int(10) unsigned | YES | | NULL | | | ||
+ | | hair | char(128) | YES | | NULL | | | ||
+ | | hairData | bigint(20) | YES | | NULL | | | ||
+ | | base_model_string | char(128) | YES | | NULL | | | ||
+ | | scale | float | NO | | 1 | | | ||
+ | +-------------------+---------------------+------+-----+---------+-------+ | ||
+ | 118 rows in set (0.01 sec) | ||
</pre> | </pre> |
Revision as of 23:31, 14 June 2007
Database Table - character_appearance
SWGANH Wiki is a repository of Star Wars Galaxies Developer information. This site is only meant to be used by SWGANH Developer team.
Table Create Script
Table Describe
mysql> desc character_appearance; +-------------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------------+---------------------+------+-----+---------+-------+ | character_id | bigint(20) unsigned | NO | PRI | 0 | | | 00FF | int(10) unsigned | YES | | NULL | | | 01FF | int(10) unsigned | YES | | NULL | | | 02FF | int(10) unsigned | YES | | NULL | | | 03FF | int(10) unsigned | YES | | NULL | | | 04FF | int(10) unsigned | YES | | NULL | | | 05FF | int(10) unsigned | YES | | NULL | | | 06FF | int(10) unsigned | YES | | NULL | | | 07FF | int(10) unsigned | YES | | NULL | | | 08FF | int(10) unsigned | YES | | NULL | | | 09FF | int(10) unsigned | YES | | NULL | | | 0AFF | int(10) unsigned | YES | | NULL | | | 0BFF | int(10) unsigned | YES | | NULL | | | 0CFF | int(10) unsigned | YES | | NULL | | | 0DFF | int(10) unsigned | YES | | NULL | | | 0EFF | int(10) unsigned | YES | | NULL | | | 0FFF | int(10) unsigned | YES | | NULL | | | 10FF | int(10) unsigned | YES | | NULL | | | 11FF | int(10) unsigned | YES | | NULL | | | 12FF | int(10) unsigned | YES | | NULL | | | 13FF | int(10) unsigned | YES | | NULL | | | 14FF | int(10) unsigned | YES | | NULL | | | 15FF | int(10) unsigned | YES | | NULL | | | 16FF | int(10) unsigned | YES | | NULL | | | 17FF | int(10) unsigned | YES | | NULL | | | 18FF | int(10) unsigned | YES | | NULL | | | 19FF | int(10) unsigned | YES | | NULL | | | 1AFF | int(10) unsigned | YES | | NULL | | | 1BFF | int(10) unsigned | YES | | NULL | | | 1CFF | int(10) unsigned | YES | | NULL | | | 1DFF | int(10) unsigned | YES | | NULL | | | 1EFF | int(10) unsigned | YES | | NULL | | | 1FFF | int(10) unsigned | YES | | NULL | | | 20FF | int(10) unsigned | YES | | NULL | | | 21FF | int(10) unsigned | YES | | NULL | | | 22FF | int(10) unsigned | YES | | NULL | | | 23FF | int(10) unsigned | YES | | NULL | | | 24FF | int(10) unsigned | YES | | NULL | | | 25FF | int(10) unsigned | YES | | NULL | | | 26FF | int(10) unsigned | YES | | NULL | | | 27FF | int(10) unsigned | YES | | NULL | | | 28FF | int(10) unsigned | YES | | NULL | | | 29FF | int(10) unsigned | YES | | NULL | | | 2AFF | int(10) unsigned | YES | | NULL | | | 2BFF | int(10) unsigned | YES | | NULL | | | 2CFF | int(10) unsigned | YES | | NULL | | | 2DFF | int(10) unsigned | YES | | NULL | | | 2EFF | int(10) unsigned | YES | | NULL | | | 2FFF | int(10) unsigned | YES | | NULL | | | 30FF | int(10) unsigned | YES | | NULL | | | 31FF | int(10) unsigned | YES | | NULL | | | 32FF | int(10) unsigned | YES | | NULL | | | 33FF | int(10) unsigned | YES | | NULL | | | 34FF | int(10) unsigned | YES | | NULL | | | 35FF | int(10) unsigned | YES | | NULL | | | 36FF | int(10) unsigned | YES | | NULL | | | 37FF | int(10) unsigned | YES | | NULL | | | 38FF | int(10) unsigned | YES | | NULL | | | 39FF | int(10) unsigned | YES | | NULL | | | 3AFF | int(10) unsigned | YES | | NULL | | | 3BFF | int(10) unsigned | YES | | NULL | | | 3CFF | int(10) unsigned | YES | | NULL | | | 3DFF | int(10) unsigned | YES | | NULL | | | 3EFF | int(10) unsigned | YES | | NULL | | | 3FFF | int(10) unsigned | YES | | NULL | | | 40FF | int(10) unsigned | YES | | NULL | | | 41FF | int(10) unsigned | YES | | NULL | | | 42FF | int(10) unsigned | YES | | NULL | | | 43FF | int(10) unsigned | YES | | NULL | | | 44FF | int(10) unsigned | YES | | NULL | | | 45FF | int(10) unsigned | YES | | NULL | | | 46FF | int(10) unsigned | YES | | NULL | | | 47FF | int(10) unsigned | YES | | NULL | | | 48FF | int(10) unsigned | YES | | NULL | | | 49FF | int(10) unsigned | YES | | NULL | | | 4AFF | int(10) unsigned | YES | | NULL | | | 4BFF | int(10) unsigned | YES | | NULL | | | 4CFF | int(10) unsigned | YES | | NULL | | | 4DFF | int(10) unsigned | YES | | NULL | | | 4EFF | int(10) unsigned | YES | | NULL | | | 4FFF | int(10) unsigned | YES | | NULL | | | 50FF | int(10) unsigned | YES | | NULL | | | 51FF | int(10) unsigned | YES | | NULL | | | 52FF | int(10) unsigned | YES | | NULL | | | 53FF | int(10) unsigned | YES | | NULL | | | 54FF | int(10) unsigned | YES | | NULL | | | 55FF | int(10) unsigned | YES | | NULL | | | 56FF | int(10) unsigned | YES | | NULL | | | 57FF | int(10) unsigned | YES | | NULL | | | 58FF | int(10) unsigned | YES | | NULL | | | 59FF | int(10) unsigned | YES | | NULL | | | 5AFF | int(10) unsigned | YES | | NULL | | | 5BFF | int(10) unsigned | YES | | NULL | | | 5CFF | int(10) unsigned | YES | | NULL | | | 5DFF | int(10) unsigned | YES | | NULL | | | 5EFF | int(10) unsigned | YES | | NULL | | | 5FFF | int(10) unsigned | YES | | NULL | | | 60FF | int(10) unsigned | YES | | NULL | | | 61FF | int(10) unsigned | YES | | NULL | | | 62FF | int(10) unsigned | YES | | NULL | | | 63FF | int(10) unsigned | YES | | NULL | | | 64FF | int(10) unsigned | YES | | NULL | | | 65FF | int(10) unsigned | YES | | NULL | | | 66FF | int(10) unsigned | YES | | NULL | | | 67FF | int(10) unsigned | YES | | NULL | | | 68FF | int(10) unsigned | YES | | NULL | | | 69FF | int(10) unsigned | YES | | NULL | | | 6AFF | int(10) unsigned | YES | | NULL | | | 6BFF | int(10) unsigned | YES | | NULL | | | 6CFF | int(10) unsigned | YES | | NULL | | | 6DFF | int(10) unsigned | YES | | NULL | | | 6EFF | int(10) unsigned | YES | | NULL | | | 6FFF | int(10) unsigned | YES | | NULL | | | 70FF | int(10) unsigned | YES | | NULL | | | hair | char(128) | YES | | NULL | | | hairData | bigint(20) | YES | | NULL | | | base_model_string | char(128) | YES | | NULL | | | scale | float | NO | | 1 | | +-------------------+---------------------+------+-----+---------+-------+ 118 rows in set (0.01 sec)