Character appearance (Database Table)

From SWGANH Wiki
Revision as of 23:32, 14 June 2007 by Snow (Talk | contribs) (Table Create Script)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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 Structure

Field Type Unsigned Autoinc Null Key Default Value Description
Symbol OK.png Symbol OK.png

Related Tags

25% This document has been partially completed.

Database This document relates to the SWGANH Database Schema.

DB Table This document relates to the SWGANH Database Schema.

Table Create Script

CREATE TABLE `character_appearance` (
  `character_id` bigint(20) unsigned NOT NULL default '0',
  `00FF` int(10) unsigned default NULL COMMENT 'Starting Header',
  `01FF` int(10) unsigned default NULL COMMENT 'Eye Color',
  `02FF` int(10) unsigned default NULL,
  `03FF` int(10) unsigned default NULL,
  `04FF` int(10) unsigned default NULL COMMENT 'Muscle / Torso',
  `05FF` int(10) unsigned default NULL COMMENT 'Weight',
  `06FF` int(10) unsigned default NULL,
  `07FF` int(10) unsigned default NULL COMMENT 'Eye Size',
  `08FF` int(10) unsigned default NULL COMMENT 'Nose Protrusion',
  `09FF` int(10) unsigned default NULL,
  `0AFF` int(10) unsigned default NULL,
  `0BFF` int(10) unsigned default NULL COMMENT 'Cheek Size',
  `0CFF` int(10) unsigned default NULL COMMENT 'Eye Angle',
  `0DFF` int(10) unsigned default NULL COMMENT 'Trunk Height',
  `0EFF` int(10) unsigned default NULL,
  `0FFF` int(10) unsigned default NULL COMMENT 'Nose Width',
  `10FF` int(10) unsigned default NULL,
  `11FF` int(10) unsigned default NULL,
  `12FF` int(10) unsigned default NULL,
  `13FF` int(10) unsigned default NULL COMMENT 'Jaw Size',
  `14FF` int(10) unsigned default NULL COMMENT 'Skin Colour',
  `15FF` int(10) unsigned default NULL COMMENT 'Mouth Size',
  `16FF` int(10) unsigned default NULL,
  `17FF` int(10) unsigned default NULL COMMENT 'Lip size',
  `18FF` int(10) unsigned default NULL,
  `19FF` int(10) unsigned default NULL COMMENT 'Ear Size',
  `1AFF` int(10) unsigned default NULL,
  `1BFF` int(10) unsigned default NULL,
  `1CFF` int(10) unsigned default NULL COMMENT 'Chin / Gullet Size',
  `1DFF` int(10) unsigned default NULL COMMENT 'Nose Color',
  `1EFF` int(10) unsigned default NULL COMMENT 'Eyebrow Type',
  `1FFF` int(10) unsigned default NULL COMMENT 'Facial Hair Color',
  `20FF` int(10) unsigned default NULL,
  `21FF` int(10) unsigned default NULL COMMENT 'Eye Shape',
  `22FF` int(10) unsigned default NULL,
  `23FF` int(10) unsigned default NULL COMMENT 'Facial Hair type',
  `24FF` int(10) unsigned default NULL COMMENT 'Age',
  `25FF` int(10) unsigned default NULL COMMENT 'Freckles',
  `26FF` int(10) unsigned default NULL COMMENT 'Marking Pattern Type',
  `27FF` int(10) unsigned default NULL COMMENT 'Sensor Size / Jowl',
  `28FF` int(10) unsigned default NULL,
  `29FF` int(10) unsigned default NULL,
  `2AFF` int(10) unsigned default NULL,
  `2BFF` int(10) unsigned default NULL,
  `2CFF` int(10) unsigned default NULL COMMENT 'Eyeshadow Color',
  `2DFF` int(10) unsigned default NULL COMMENT 'Eyeshadow',
  `2EFF` int(10) unsigned default NULL COMMENT 'Lip Color',
  `2FFF` int(10) unsigned default NULL,
  `30FF` int(10) unsigned default NULL,
  `31FF` int(10) unsigned default NULL,
  `32FF` int(10) unsigned default NULL COMMENT 'Center Beard Color',
  `33FF` int(10) unsigned default NULL,
  `34FF` int(10) unsigned default NULL,
  `35FF` int(10) unsigned default NULL,
  `36FF` int(10) unsigned default NULL,
  `37FF` int(10) unsigned default NULL,
  `38FF` int(10) unsigned default NULL,
  `39FF` int(10) unsigned default NULL COMMENT 'Head Size',
  `3AFF` int(10) unsigned default NULL,
  `3BFF` int(10) unsigned default NULL COMMENT 'Marking Pattern Color',
  `3CFF` int(10) unsigned default NULL,
  `3DFF` int(10) unsigned default NULL,
  `3EFF` int(10) unsigned default NULL COMMENT 'Ear Shape',
  `3FFF` int(10) unsigned default NULL,
  `40FF` int(10) unsigned default NULL,
  `41FF` int(10) unsigned default NULL,
  `42FF` int(10) unsigned default NULL,
  `43FF` int(10) unsigned default NULL COMMENT 'Brow',
  `44FF` int(10) unsigned default NULL,
  `45FF` int(10) unsigned default NULL,
  `46FF` int(10) unsigned default NULL,
  `47FF` int(10) unsigned default NULL,
  `48FF` int(10) unsigned default NULL COMMENT 'Marking Color',
  `49FF` int(10) unsigned default NULL COMMENT 'Fur Color',
  `4AFF` int(10) unsigned default NULL,
  `4BFF` int(10) unsigned default NULL,
  `4CFF` int(10) unsigned default NULL,
  `4DFF` int(10) unsigned default NULL,
  `4EFF` int(10) unsigned default NULL COMMENT 'Chin Length',
  `4FFF` int(10) unsigned default NULL,
  `50FF` int(10) unsigned default NULL,
  `51FF` int(10) unsigned default NULL,
  `52FF` int(10) unsigned default NULL,
  `53FF` int(10) unsigned default NULL,
  `54FF` int(10) unsigned default NULL,
  `55FF` int(10) unsigned default NULL,
  `56FF` int(10) unsigned default NULL,
  `57FF` int(10) unsigned default NULL,
  `58FF` int(10) unsigned default NULL,
  `59FF` int(10) unsigned default NULL,
  `5AFF` int(10) unsigned default NULL,
  `5BFF` int(10) unsigned default NULL,
  `5CFF` int(10) unsigned default NULL,
  `5DFF` int(10) unsigned default NULL,
  `5EFF` int(10) unsigned default NULL,
  `5FFF` int(10) unsigned default NULL,
  `60FF` int(10) unsigned default NULL,
  `61FF` int(10) unsigned default NULL,
  `62FF` int(10) unsigned default NULL,
  `63FF` int(10) unsigned default NULL COMMENT 'Markings Color (Sullastian)',
  `64FF` int(10) unsigned default NULL,
  `65FF` int(10) unsigned default NULL COMMENT 'Markings Pattern (Sullastian)',
  `66FF` int(10) unsigned default NULL,
  `67FF` int(10) unsigned default NULL,
  `68FF` int(10) unsigned default NULL,
  `69FF` int(10) unsigned default NULL,
  `6AFF` int(10) unsigned default NULL,
  `6BFF` int(10) unsigned default NULL,
  `6CFF` int(10) unsigned default NULL,
  `6DFF` int(10) unsigned default NULL,
  `6EFF` int(10) unsigned default NULL COMMENT 'Center Beard Type (Ithorian)',
  `6FFF` int(10) unsigned default NULL,
  `70FF` int(10) unsigned default NULL COMMENT 'Side Beard Type (Ithorinan)',
  `hair` char(128) default NULL,
  `hairData` bigint(20) default NULL,
  `base_model_string` char(128) default NULL,
  `scale` float NOT NULL default '1',
  PRIMARY KEY  (`character_id`),
  CONSTRAINT `character_appearance_ibfk_1` FOREIGN KEY (`character_id`) REFERENCES `characters` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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)