Character appearance (Database Table)
From SWGANH Wiki
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
|
Related Tags
|
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)
