Difference between revisions of "Character attributes (Database Table)"
From SWGANH Wiki
(New page: {{PageHeader|Database Table|character_attributes}} {| border="0" width="90%" cellpadding=6 |- |valign=top| ==Table Structure== {| align="center" |- || {| class = "wikitable" |- align="c...) |
(→Table Describe) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 36: | Line 36: | ||
==Table Create Script== | ==Table Create Script== | ||
<pre> | <pre> | ||
| − | + | CREATE TABLE `character_attributes` ( | |
| + | `character_id` bigint(20) unsigned NOT NULL default '0' COMMENT 'Character - ID', | ||
| + | `faction_id` int(8) unsigned NOT NULL default '0' COMMENT 'Character - Faction ID', | ||
| + | `health_max` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Health Max', | ||
| + | `strength_max` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Strength Max', | ||
| + | `constitution_max` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Constitution Max', | ||
| + | `action_max` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Action Max', | ||
| + | `quickness_max` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Quickness Max', | ||
| + | `stamina_max` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Stamina Max', | ||
| + | `mind_max` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Mind Max', | ||
| + | `focus_max` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Focus Max', | ||
| + | `willpower_max` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Willpower Max', | ||
| + | `health_current` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Health Fill', | ||
| + | `strength_current` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Strength Fill', | ||
| + | `constitution_current` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Constitution Fill', | ||
| + | `action_current` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Action Fill', | ||
| + | `quickness_current` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Quickness Fill', | ||
| + | `stamina_current` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Stamina Fill', | ||
| + | `mind_current` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Mind Fill', | ||
| + | `focus_current` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Focus Fill', | ||
| + | `willpower_current` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Willpower Fill', | ||
| + | `health_wounds` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Health Wounds', | ||
| + | `strength_wounds` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Strength Wounds', | ||
| + | `constitution_wounds` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Constitution Wounds', | ||
| + | `action_wounds` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Action Wounds', | ||
| + | `quickness_wounds` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Quickness Wounds', | ||
| + | `stamina_wounds` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Stamina wounds', | ||
| + | `mind_wounds` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Mind wounds', | ||
| + | `focus_wounds` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Focus Wounds', | ||
| + | `willpower_wounds` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Willpower Wounds', | ||
| + | `health_encum` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Health Encumberance', | ||
| + | `action_encum` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Action Encumberance', | ||
| + | `mind_encum` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Mind Encumberance', | ||
| + | `battlefatigue` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Battle Fatigue', | ||
| + | `posture` int(3) unsigned NOT NULL default '0', | ||
| + | `moodId` int(11) unsigned NOT NULL default '0', | ||
| + | `title` char(255) default NULL, | ||
| + | `base_speed` float NOT NULL default '5.75', | ||
| + | `base_acceleration` float NOT NULL default '1', | ||
| + | `character_flags` int(11) unsigned NOT NULL default '0', | ||
| + | KEY `fk_attributes_char_char` (`character_id`), | ||
| + | KEY `fk_attributes_fac_fac` (`faction_id`), | ||
| + | KEY `fk_charattributes_mood_mood` (`moodId`), | ||
| + | CONSTRAINT `character_attributes_ibfk_1` FOREIGN KEY (`faction_id`) REFERENCES `faction` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, | ||
| + | CONSTRAINT `character_attributes_ibfk_2` FOREIGN KEY (`character_id`) REFERENCES `characters` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, | ||
| + | CONSTRAINT `fk_charattributes_mood_mood` FOREIGN KEY (`moodId`) REFERENCES `moods` (`id`) ON DELETE CASCADE ON UPDATE CASCADE | ||
| + | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | ||
</pre> | </pre> | ||
==Table Describe== | ==Table Describe== | ||
<pre> | <pre> | ||
| − | + | mysql> desc character_attributes; | |
| + | +----------------------+---------------------+------+-----+---------+-------+ | ||
| + | | Field | Type | Null | Key | Default | Extra | | ||
| + | +----------------------+---------------------+------+-----+---------+-------+ | ||
| + | | character_id | bigint(20) unsigned | NO | MUL | 0 | | | ||
| + | | faction_id | int(8) unsigned | NO | MUL | 0 | | | ||
| + | | health_max | int(6) unsigned | NO | | 0 | | | ||
| + | | strength_max | int(6) unsigned | NO | | 0 | | | ||
| + | | constitution_max | int(6) unsigned | NO | | 0 | | | ||
| + | | action_max | int(6) unsigned | NO | | 0 | | | ||
| + | | quickness_max | int(6) unsigned | NO | | 0 | | | ||
| + | | stamina_max | int(6) unsigned | NO | | 0 | | | ||
| + | | mind_max | int(6) unsigned | NO | | 0 | | | ||
| + | | focus_max | int(6) unsigned | NO | | 0 | | | ||
| + | | willpower_max | int(6) unsigned | NO | | 0 | | | ||
| + | | health_current | int(6) unsigned | NO | | 0 | | | ||
| + | | strength_current | int(6) unsigned | NO | | 0 | | | ||
| + | | constitution_current | int(6) unsigned | NO | | 0 | | | ||
| + | | action_current | int(6) unsigned | NO | | 0 | | | ||
| + | | quickness_current | int(6) unsigned | NO | | 0 | | | ||
| + | | stamina_current | int(6) unsigned | NO | | 0 | | | ||
| + | | mind_current | int(6) unsigned | NO | | 0 | | | ||
| + | | focus_current | int(6) unsigned | NO | | 0 | | | ||
| + | | willpower_current | int(6) unsigned | NO | | 0 | | | ||
| + | | health_wounds | int(6) unsigned | NO | | 0 | | | ||
| + | | strength_wounds | int(6) unsigned | NO | | 0 | | | ||
| + | | constitution_wounds | int(6) unsigned | NO | | 0 | | | ||
| + | | action_wounds | int(6) unsigned | NO | | 0 | | | ||
| + | | quickness_wounds | int(6) unsigned | NO | | 0 | | | ||
| + | | stamina_wounds | int(6) unsigned | NO | | 0 | | | ||
| + | | mind_wounds | int(6) unsigned | NO | | 0 | | | ||
| + | | focus_wounds | int(6) unsigned | NO | | 0 | | | ||
| + | | willpower_wounds | int(6) unsigned | NO | | 0 | | | ||
| + | | health_encum | int(6) unsigned | NO | | 0 | | | ||
| + | | action_encum | int(6) unsigned | NO | | 0 | | | ||
| + | | mind_encum | int(6) unsigned | NO | | 0 | | | ||
| + | | battlefatigue | int(6) unsigned | NO | | 0 | | | ||
| + | | posture | int(3) unsigned | NO | | 0 | | | ||
| + | | moodId | int(11) unsigned | NO | MUL | 0 | | | ||
| + | | title | char(255) | YES | | NULL | | | ||
| + | | base_speed | float | NO | | 5.75 | | | ||
| + | | base_acceleration | float | NO | | 1 | | | ||
| + | | character_flags | int(11) unsigned | NO | | 0 | | | ||
| + | +----------------------+---------------------+------+-----+---------+-------+ | ||
| + | 39 rows in set (0.00 sec) | ||
</pre> | </pre> | ||
Latest revision as of 23:33, 14 June 2007
Database Table - character_attributes
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_attributes` ( `character_id` bigint(20) unsigned NOT NULL default '0' COMMENT 'Character - ID', `faction_id` int(8) unsigned NOT NULL default '0' COMMENT 'Character - Faction ID', `health_max` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Health Max', `strength_max` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Strength Max', `constitution_max` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Constitution Max', `action_max` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Action Max', `quickness_max` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Quickness Max', `stamina_max` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Stamina Max', `mind_max` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Mind Max', `focus_max` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Focus Max', `willpower_max` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Willpower Max', `health_current` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Health Fill', `strength_current` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Strength Fill', `constitution_current` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Constitution Fill', `action_current` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Action Fill', `quickness_current` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Quickness Fill', `stamina_current` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Stamina Fill', `mind_current` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Mind Fill', `focus_current` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Focus Fill', `willpower_current` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Willpower Fill', `health_wounds` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Health Wounds', `strength_wounds` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Strength Wounds', `constitution_wounds` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Constitution Wounds', `action_wounds` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Action Wounds', `quickness_wounds` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Quickness Wounds', `stamina_wounds` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Stamina wounds', `mind_wounds` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Mind wounds', `focus_wounds` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Focus Wounds', `willpower_wounds` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Willpower Wounds', `health_encum` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Health Encumberance', `action_encum` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Action Encumberance', `mind_encum` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Mind Encumberance', `battlefatigue` int(6) unsigned NOT NULL default '0' COMMENT 'Character - Battle Fatigue', `posture` int(3) unsigned NOT NULL default '0', `moodId` int(11) unsigned NOT NULL default '0', `title` char(255) default NULL, `base_speed` float NOT NULL default '5.75', `base_acceleration` float NOT NULL default '1', `character_flags` int(11) unsigned NOT NULL default '0', KEY `fk_attributes_char_char` (`character_id`), KEY `fk_attributes_fac_fac` (`faction_id`), KEY `fk_charattributes_mood_mood` (`moodId`), CONSTRAINT `character_attributes_ibfk_1` FOREIGN KEY (`faction_id`) REFERENCES `faction` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `character_attributes_ibfk_2` FOREIGN KEY (`character_id`) REFERENCES `characters` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_charattributes_mood_mood` FOREIGN KEY (`moodId`) REFERENCES `moods` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Table Describe
mysql> desc character_attributes; +----------------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------------+---------------------+------+-----+---------+-------+ | character_id | bigint(20) unsigned | NO | MUL | 0 | | | faction_id | int(8) unsigned | NO | MUL | 0 | | | health_max | int(6) unsigned | NO | | 0 | | | strength_max | int(6) unsigned | NO | | 0 | | | constitution_max | int(6) unsigned | NO | | 0 | | | action_max | int(6) unsigned | NO | | 0 | | | quickness_max | int(6) unsigned | NO | | 0 | | | stamina_max | int(6) unsigned | NO | | 0 | | | mind_max | int(6) unsigned | NO | | 0 | | | focus_max | int(6) unsigned | NO | | 0 | | | willpower_max | int(6) unsigned | NO | | 0 | | | health_current | int(6) unsigned | NO | | 0 | | | strength_current | int(6) unsigned | NO | | 0 | | | constitution_current | int(6) unsigned | NO | | 0 | | | action_current | int(6) unsigned | NO | | 0 | | | quickness_current | int(6) unsigned | NO | | 0 | | | stamina_current | int(6) unsigned | NO | | 0 | | | mind_current | int(6) unsigned | NO | | 0 | | | focus_current | int(6) unsigned | NO | | 0 | | | willpower_current | int(6) unsigned | NO | | 0 | | | health_wounds | int(6) unsigned | NO | | 0 | | | strength_wounds | int(6) unsigned | NO | | 0 | | | constitution_wounds | int(6) unsigned | NO | | 0 | | | action_wounds | int(6) unsigned | NO | | 0 | | | quickness_wounds | int(6) unsigned | NO | | 0 | | | stamina_wounds | int(6) unsigned | NO | | 0 | | | mind_wounds | int(6) unsigned | NO | | 0 | | | focus_wounds | int(6) unsigned | NO | | 0 | | | willpower_wounds | int(6) unsigned | NO | | 0 | | | health_encum | int(6) unsigned | NO | | 0 | | | action_encum | int(6) unsigned | NO | | 0 | | | mind_encum | int(6) unsigned | NO | | 0 | | | battlefatigue | int(6) unsigned | NO | | 0 | | | posture | int(3) unsigned | NO | | 0 | | | moodId | int(11) unsigned | NO | MUL | 0 | | | title | char(255) | YES | | NULL | | | base_speed | float | NO | | 5.75 | | | base_acceleration | float | NO | | 1 | | | character_flags | int(11) unsigned | NO | | 0 | | +----------------------+---------------------+------+-----+---------+-------+ 39 rows in set (0.00 sec)
