SWGANH Wiki - User contributions [en]

Portal:SWGANH Database Documentation

2010-03-13T17:07:28Z

Nebula: updated list

{{PageHeader|Architecture|Database Documentation}}

{| border="0" width="90%" cellpadding=6
|-
|valign=top|

{| class="wikitable"
|+ '''Table Listing ''Build 75'' '''
|- align="center" style="background-color:#ffffcc;"
|width="200px"|'''Table Name'''||width="150px"|'''Category'''||width="450px"|'''Table Description'''
|-
||'''[[account (Database Table)|account]]'''||align="center"|'''Main::Account'''||This table holds all the user account information.
|-
||'''[[attributes (Database Table)|attributes]]'''||align="center"|'''Items'''||This table holds all the attribute types.
|-
||'''[[badge_categories (Database Table)|badge_categories]]'''||align="center"|'''Badges'''||This table holds all the badge category information.
|-
||'''[[badge_regions (Database Table)|badge_regions]]'''||align="center"|'''Badges'''||This table holds all the badge regions information.
|-
||'''[[badges (Database Table)|badges]]'''||align="center"|'''Badges'''||(Table) -> Player Badges
|-
||'''[[banks (Database Table)|banks]]'''||align="center"|'''Player'''||(Table) -> Player Banks
|-
||'''[[biography_faction (Database Table)|biography_faction]]'''||align="center"|'''Biography'''||(Table) -> Biography Generator
|-
||'''[[biography_planet (Database Table)|biography_planet]]'''||align="center"|'''Biography'''||(Table) -> Biography Generator
|-
||'''[[biography_profession (Database Table)|biography_profession]]'''||align="center"|'''Biography'''||(Table) -> Biography Generator
|-
||'''[[biography_templates (Database Table)|biography_templates]]'''||align="center"|'''Biography'''||(Table) -> Biography Generator
|-
||'''[[biography_wars (Database Table)|biography_wars]]'''||align="center"|'''Biography'''||(Table) -> Biography Generator
|-
||'''[[building_families (Database Table)|building_families]]'''||align="center"|'''Buildings'''||
|-
||'''[[building_types (Database Table)|building_types]]'''||align="center"|'''Buildings'''||
|-
||'''[[buildings (Database Table)|buildings]]'''||align="center"|'''Buildings'''||
|-
||'''[[cells (Database Table)|cells]]'''||align="center"|''' '''||
|-
||'''[[character_appearance (Database Table)|character_appearance]]'''||''' '''||
|-
||'''[[character_attributes (Database Table)|character_attributes]]'''||''' '''||
|-
||'''[[character_badges (Database Table)|character_badges]]'''||''' '''||
|-
||'''[[character_bind (Database Table)|character_bind]]'''||''' '''||
|-
||'''[[character_biography (Database Table)|character_biography]]'''||''' '''||
|-
||'''[[character_buff_attributes (Database Table)|character_buff_attributes]]'''||''' '''||
|-
||'''[[character_buffs (Database Table)|character_buffs]]'''||''' '''||
|-
||'''[[character_clone (Database Table)|character_clone]]'''||''' '''||
|-
||'''[[character_faction (Database Table)|character_faction]]'''||''' '''||
|-
||'''[[character_holoemotes (Database Table)|character_holoemotes]]'''||''' '''||
|-
||'''[[character_matchmaking (Database Table)|character_matchmaking]]'''||''' '''||
|-
||'''[[character_movement (Database Table)|character_movement]]'''||''' '''||
|-
||'''[[character_skills (Database Table)|character_skills]]'''||''' '''||
|-
||'''[[character_stat_migration (Database Table)|character_stat_migration]]'''||''' '''||
|-
||'''[[character_tutorial (Database Table)|character_tutorial]]'''||''' '''||
|-
||'''[[character_xp (Database Table)|character_xp]]'''||''' '''||
|-
||'''[[characters (Database Table)|characters]]'''||''' '''||
|-
||'''[[chat_attachments (Database Table)|chat_attachments]]'''||''' '''||
|-
||'''[[chat_channels (Database Table)|chat_channels]]'''||''' '''||
|-
||'''[[chat_channels_banned (Database Table)|chat_channels_banned]]'''||''' '''||
|-
||'''[[chat_channels_invited (Database Table)|chat_channels_invited]]'''||''' '''||
|-
||'''[[chat_channels_moderators (Database Table)|chat_channels_moderators]]'''||''' '''||
|-
||'''[[chat_char_channels (Database Table)|chat_char_channels]]'''||''' '''||
|-
||'''[[chat_friendlist (Database Table)|chat_friendlist]]'''||''' '''||
|-
||'''[[chat_ignorelist (Database Table)|chat_ignorelist]]'''||''' '''||
|-
||'''[[chat_mail (Database Table)|chat_mail]]'''||''' '''||
|-
||'''[[chat_mail_attachments (Database Table)|chat_mail_attachments]]'''||''' '''||
|-
||'''[[cities (Database Table)|cities]]'''||''' '''||
|-
||'''[[clienteffects (Database Table)|clienteffects]]'''||''' '''||
|-
||'''[[command_table (Database Table)|command_table]]'''||''' '''||
|-
||'''[[commerce_auction (Database Table)|commerce_auction]]'''||''' '''||
|-
||'''[[commerce_bazaar (Database Table)|commerce_bazaar]]'''||''' '''||
|-
||'''[[commerce_bidhistory (Database Table)|commerce_bidhistory]]'''||''' '''||
|-
||'''[[commerce_category (Database Table)|commerce_category]]'''||''' '''||
|-
||'''[[commerce_item_types (Database Table)|commerce_item_types]]'''||''' '''||
|-
||'''[[config_message_routes (Database Table)|config_message_routes]]'''||''' '''||
|-
||'''[[config_process_list (Database Table)|config_process_list]]'''||''' '''||
|-
||'''[[config_server (Database Table)|config_server]]'''||''' '''||
|-
||'''[[config_server_attributes (Database Table)|config_server_attributes]]'''||''' '''||
|-
||'''[[config_zone_scripts (Database Table)|config_zone_scripts]]'''||''' '''||
|-
||'''[[config_zones (Database Table)|config_zones]]'''||''' '''||
|-
||'''[[container_item (Database Table)|container_item]]'''||''' '''||
|-
||'''[[container_types (Database Table)|container_types]]'''||''' '''||
|-
||'''[[containers (Database Table)|containers]]'''||''' '''||
|-
||'''[[conversation_animations (Database Table)|conversation_animations]]'''||''' '''||
|-
||'''[[conversation_event_types (Database Table)|conversation_event_types]]'''||''' '''||
|-
||'''[[conversation_option_batches (Database Table)|conversation_option_batches]]'''||''' '''||
|-
||'''[[conversation_options (Database Table)|conversation_options]]'''||''' '''||
|-
||'''[[conversation_pages (Database Table)|conversation_pages]]'''||''' '''||
|-
||'''[[conversations (Database Table)|conversations]]'''||''' '''||
|-
||'''[[craft_types (Database Table)|craft_types]]'''||''' '''||
|-
||'''[[creature_groups (Database Table)|creature_groups]]'''||''' '''||
|-
||'''[[creature_species (Database Table)|creature_species]]'''||''' '''||
|-
||'''[[csr_categories (Database Table)|csr_categories]]'''||''' '''||
|-
||'''[[csr_comments (Database Table)|csr_comments]]'''||''' '''||
|-
||'''[[csr_knowledgebase (Database Table)|csr_knowledgebase]]'''||''' '''||
|-
||'''[[csr_subcategories (Database Table)|csr_subcategories]]'''||''' '''||
|-
||'''[[csr_tickets (Database Table)|csr_tickets]]'''||''' '''||
|-
||'''[[datapad_types (Database Table)|datapad_types]]'''||''' '''||
|-
||'''[[datapads (Database Table)|datapads]]'''||''' '''||
|-
||'''[[draft_assembly_batches (Database Table)|draft_assembly_batches]]'''||''' '''||
|-
||'''[[draft_assembly_lists (Database Table)|draft_assembly_lists]]'''||''' '''||
|-
||'''[[draft_craft_attribute_weights (Database Table)|draft_craft_atribute_weights]]'''||''' '''||
|-
||'''[[draft_craft_batches (Database Table)|draft_craft_batches]]'''||''' '''||
|-
||'''[[draft_craft_item_attribute_link (Database Table)|draft_craft_item_attribute_link]]'''||''' '''||
|-
||'''[[draft_craft_lists (Database Table)|draft_craft_lists]]'''||''' '''||
|-
||'''[[draft_experiment_batches (Database Table)|draft_experiment_batches]]'''||''' '''||
|-
||'''[[draft_experiment_groups (Database Table)|draft_experiment_groups]]'''||''' '''||
|-
||'''[[draft_experiment_lists (Database Table)|draft_experiment_lists]]'''||''' '''||
|-
||'''[[draft_lists_datatypes (Database Table)|draft_lists_datatypes]]'''||''' '''||
|-
||'''[[draft_schematic_attribute_manipulation (Database Table)|draft_schematic_attribute_manipulation]]'''||''' '''||
|-
||'''[[draft_schematic_customization (Database Table)|draft_schematic_customization]]'''||''' '''||
|-
||'''[[draft_schematic_item_link (Database Table)|draft_schematic_item_link]]'''||''' '''||
|-
||'''[[draft_schematic_manufacture_defaults (Database Table)|draft_schematic_manufacture_defaults]]'''||''' '''||
|-
||'''[[draft_schematics (Database Table)|draft_schematics]]'''||''' '''||
|-
||'''[[draft_schematics_slots (Database Table)|draft_schematics_slots]]'''||''' '''||
|-
||'''[[draft_slot_types (Database Table)|draft_slot_types]]'''||''' '''||
|-
||'''[[draft_slots (Database Table)|draft_slots]]'''||''' '''||
|-
||'''[[draft_weights (Database Table)|draft_weights]]'''||''' '''||
|-
||'''[[entertainer_deny_service (Database Table)|entertainer_deny_service]]'''||''' '''||
|-
||'''[[entertainer_performances (Database Table)|entertainer_performances]]'''||''' '''||
|-
||'''[[faction (Database Table)|faction]]'''||''' '''||
|-
||'''[[factories (Database Table)|factories]]'''||''' '''||
|-
||'''[[frog_items (Database Table)|frog_items]]'''||''' '''||
|-
||'''[[galaxy (Database Table)|galaxy]]'''||''' '''||
|-
||'''[[galaxy_account (Database Table)|galaxy_account]]'''||''' '''||
|-
||'''[[galaxy_account_types (Database Table)|galaxy_account_types]]'''||''' '''||
|-
||'''[[harvester_resources (Database Table)|harvester_resources]]'''||''' '''||
|-
||'''[[harvesters (Database Table)|harvesters]]'''||''' '''||
|-
||'''[[holoemote (Database Table)|holoemote]]'''||''' '''||
|-
||'''[[houses (Database Table)|houses]]'''||''' '''||
|-
||'''[[id_attributes (Database Table)|id_attributes]]'''||''' '''||
|-
||'''[[internal (Database Table)|internal]]'''||''' '''||
|-
||'''[[inventories (Database Table)|inventories]]'''||''' '''||
|-
||'''[[inventory_types (Database Table)|inventory_types]]'''||''' '''||
|-
||'''[[item_attributes (Database Table)|item_attributes]]'''||''' '''||
|-
||'''[[item_customization (Database Table)|item_customization]]'''||''' '''||
|-
||'''[[item_families (Database Table)|item_families]]'''||''' '''||
|-
||'''[[item_family_attribute_defaults (Database Table)|item_family_defaults]]'''||''' '''||
|-
||'''[[item_types (Database Table)|item_types]]'''||''' '''||
|-
||'''[[items (Database Table)|items]]'''||''' '''||
|-
||'''[[lair_attributes (Database Table)|lair_attributes]]'''||''' '''||
|-
||'''[[lair_templates (Database Table)|lair_templates]]'''||''' '''||
|-
||'''[[lairs (Database Table)|lairs]]'''||''' '''||
|-
||'''[[log_error (Database Table)|log_error]]'''||''' '''||
|-
||'''[[loot_groups (Database Table)|loot_groups]]'''||''' '''||
|-
||'''[[loot_templates (Database Table)|loot_templates]]'''||''' '''||
|-
||'''[[manschemcomponents (Database Table)|manschemcomponents]]'''||''' '''||
|-
||'''[[manschemresources (Database Table)|manschemresourcs]]'''||''' '''||
|-
||'''[[manufactureschematic (Database Table)|manufacturesschematic]]'''||''' '''||
|-
||'''[[mission_names (Database Table)|mission_names]]'''||''' '''||
|-
||'''[[mission_terminal_mission_types (Database Table)|mission_terminal_mission_types]]'''||''' '''||
|-
||'''[[mission_text (Database Table)|mission_text]]'''||''' '''||
|-
||'''[[mission_types (Database Table)|mission_types]]'''||''' '''||
|-
||'''[[moods (Database Table)|moods]]'''||''' '''||
|-
||'''[[name_developer (Database Table)|name_developer]]'''||''' '''||
|-
||'''[[name_profane (Database Table)|name_profane]]'''||''' '''||
|-
||'''[[name_reserved (Database Table)|name_reserved]]'''||''' '''||
|-
||'''[[namegen_firstname (Database Table)|namegen_firstname]]'''||''' '''||
|-
||'''[[namegen_lastname (Database Table)|namegen_lastname]]'''||''' '''||
|-
||'''[[non_persistent_npc_attributes (Database Table)|non_persistent_npc_attributes]]'''||''' '''||
|-
||'''[[non_persistent_npcs (Database Table)|non_persistent_npcs]]'''||''' '''||
|-
||'''[[npc_chatter (Database Table)|npc_chatter]]'''||''' '''||
|-
||'''[[object_attributes (Database Table)|object_attributes]]'''||''' '''||
|-
||'''[[object_models (Database Table)|object_models]]'''||''' '''||
|-
||'''[[parking_garage (Database Table)|parking_garage]]'''||''' '''||
|-
||'''[[persistent_npc_attributes (Database Table)|persistent_npc_families]]'''||''' '''||
|-
||'''[[persistent_npcs (Database Table)|persistent_npcs]]'''||''' '''||
|-
||'''[[planet (Database Table)|planet]]'''||''' '''||
|-
||'''[[planet_regions (Database Table)|planet_regions]]'''||''' '''||
|-
||'''[[planetmap (Database Table)|planetmap]]'''||''' '''||
|-
||'''[[planetmapcategory (Database Table)|planetmapcategory]]'''||''' '''||
|-
||'''[[quests (Database Table)|quests]]'''||''' '''||
|-
||'''[[race (Database Table)|race]]'''||''' '''||
|-
||'''[[resource_categories (Database Table)|resource_categories]]'''||''' '''||
|-
||'''[[resource_containers (Database Table)|resource_containers]]'''||''' '''||
|-
||'''[[resource_name_begin (Database Table)|resource_name_begin]]'''||''' '''||
|-
||'''[[resource_name_end (Database Table)|resource_name_end]]'''||''' '''||
|-
||'''[[resource_template (Database Table)|resource_template]]'''||''' '''||
|-
||'''[[resources (Database Table)|resources]]'''||''' '''||
|-
||'''[[resources_spawn_config (Database Table)|resources_spawn_config]]'''||''' '''||
|-
||'''[[schem_crc (Database Table)|schem_crc]]'''||''' '''||
|-
||'''[[schematic_groups (Database Table)|schematic_groups]]'''||''' '''||
|-
||'''[[server (Database Table)|server]]'''||''' '''||
|-
||'''[[shuttle_types (Database Table)|shuttle_types]]'''||''' '''||
|-
||'''[[shuttles (Database Table)|shuttles]]'''||''' '''||
|-
||'''[[skillcommands (Database Table)|skillcommands]]'''||''' '''||
|-
||'''[[skillmods (Database Table)|skillmods]]'''||''' '''||
|-
||'''[[skills (Database Table)|skills]]'''||''' '''||
|-
||'''[[skills_base_xp_groups (Database Table)|skills_base_xp_groups]]'''||''' '''||
|-
||'''[[skills_description (Database Table)|skills_description]]'''||''' '''||
|-
||'''[[skills_jedi_states (Database Table)|skills_jedi_states]]'''||''' '''||
|-
||'''[[skills_preclusions (Database Table)|skills_preclusions]]'''||''' '''||
|-
||'''[[skills_schematicsgranted (Database Table)|skills_schematicsgranted]]'''||''' '''||
|-
||'''[[skills_skill_skillparent (Database Table)|skills_skill_skillparent]]'''||''' '''||
|-
||'''[[skills_skill_skillsrequired (Database Table)|skills_skill_skillsrequired]]'''||''' '''||
|-
||'''[[skills_skillcommands (Database Table)|skills_skillcommands]]'''||''' '''||
|-
||'''[[skills_skillmods (Database Table)|skills_skillmods]]'''||''' '''||
|-
||'''[[skills_species_required (Database Table)|skills_species_required]]'''||''' '''||
|-
||'''[[sounds (Database Table)|sounds]]'''||''' '''||
|-
||'''[[spawn_clone (Database Table)|spawn_clone]]'''||''' '''||
|-
||'''[[spawn_groups (Database Table)|spawn_groups]]'''||''' '''||
|-
||'''[[spawn_regions (Database Table)|spawn_regions]]'''||''' '''||
|-
||'''[[spawn_shuttle (Database Table)|spawn_shuttle]]'''||''' '''||
|-
||'''[[spawns (Database Table)|spawns]]'''||''' '''||
|-
||'''[[starting_attributes (Database Table)|starting_attributes]]'''||''' '''||
|-
||'''[[starting_item_requirements (Database Table)|starting_item_requirements]]'''||''' '''||
|-
||'''[[starting_items (Database Table)|starting_items]]'''||''' '''||
|-
||'''[[starting_location (Database Table)|starting_location]]'''||''' '''||
|-
||'''[[static_objects (Database Table)|static_objects]]'''||''' '''||
|-
||'''[[static_types (Database Table)|static_types]]'''||''' '''||
|-
||'''[[stf_files (Database Table)|stf_files]]'''||''' '''||
|-
||'''[[stf_variable (Database Table)|stf_variable]]'''||''' '''||
|-
||'''[[structure_admin_data (Database Table)|structure_admin_data]]'''||''' '''||
|-
||'''[[structure_attribute_defaults (Database Table)|structure_attribute_defaults]]'''||''' '''||
|-
||'''[[structure_attributes (Database Table)|structure_attributes]]'''||''' '''||
|-
||'''[[structure_deed_data (Database Table)|structure_deed_data]]'''||''' '''||
|-
||'''[[structure_item_templates (Database Table)|structure_item_templates]]'''||''' '''||
|-
||'''[[structure_terminal_link (Database Table)|structure_terminal_link]]'''||''' '''||
|-
||'''[[structure_type_data (Database Table)|structure_type_data]]'''||''' '''||
|-
||'''[[structures (Database Table)|structures]]'''||''' '''||
|-
||'''[[terminal_elevator_data (Database Table)|terminal_elevator_data]]'''||''' '''||
|-
||'''[[terminal_types (Database Table)|terminal_types]]'''||''' '''||
|-
||'''[[terminals (Database Table)|terminals]]'''||''' '''||
|-
||'''[[ticket_collectors (Database Table)|ticket_collectors]]'''||''' '''||
|-
||'''[[travel_planet_routes (Database Table)|travel_planet_routes]]'''||''' '''||
|-
||'''[[vehicle_attributes (Database Table)|vehicle_attributes]]'''||''' '''||
|-
||'''[[vehicle_customization (Database Table)|vehicle_customization]]'''||''' '''||
|-
||'''[[vehicle_families (Database Table)|vehicle_families]]'''||''' '''||
|-
||'''[[vehicle_type_attributes (Database Table)|vehicle_type_attributes]]'''||''' '''||
|-
||'''[[vehicle_types (Database Table)|vehicle_types]]'''||''' '''||
|-
||'''[[vehicles (Database Table)|vehicles]]'''||''' '''||
|-
||'''[[waypoint (Database Table)|waypoint]]'''||''' '''||(Table) -> Datapad: Waypoints
|-
||'''[[weapon_groups (Database Table)|weapon_groups]]'''||''' '''||(Table) -> Weapon Type List
|-
||'''[[xp_types (Database Table)|xp_types]]'''||''' '''||(Table) -> XP Type List
|-
||'''[[zone_regions (Database Table)|zone_regions]]'''||''' '''||(Table) -> Server Zone Regions
|-
|}

|valign=top|

[[Image:db.jpg|thumb|250px|SWGANH Database Schema]]

[[Image:Schema.jpg|thumb|250px|SWGANH Database Schema]]

[[Image:SWGANH---(DB)-Character-Table-Relations.jpg|thumb|250px|Character Table Relation]]

[[Image:SWGANH---(DB)-NPCs-Table-Relations.jpg|thumb|250px|NPC Table Relation]]

[[Image:SWGANH - Table Structure - Conversations.jpg|thumb|250px|Conversation Table Relation]]
|}

Characters (Database Table)

2010-03-13T04:52:21Z

Nebula: New page: {{PageHeader|Database Table|character_skills}} {| border="0" width="90%" cellpadding=6 |- |valign=top| ==Table Structure== {| align="center" |- || {| class = "wikitable" |- align="cente...

{{PageHeader|Database Table|character_skills}}

{| border="0" width="90%" cellpadding=6
|-
|valign=top|

==Table Structure==
{| align="center"
|-
||
{| class = "wikitable"
|- align="center" style="background-color:#ffffcc;"
||'''Field'''||'''Type'''||'''Unsigned'''||'''Autoinc'''||'''Null'''||'''Key'''||'''Default Value'''||'''Description'''
|- align="center"
|align="left"|id||bigint(20)||align="center"|[[Image:Symbol OK.png|10px]]||align="center"|[[Image:Symbol OK.png|10px]]||NO||Primary||NULL||Character ID
|- align="center" style="background-color:#F1F1F1;"
|align="left"|account_id||bigint(20)||align="center"|[[Image:Symbol OK.png|10px]]||align="center"| ||NO|| ||0||Account ID
|- align="center"
|align="left"|galaxy_id||int(5)||align="center"| ||align="center"| ||YES|| ||0||Galaxy ID
|- align="center" style="background-color:#F1F1F1;"
|align="left"|firstname||char(32)||align="center"| ||align="center"| ||YES||Unique||NULL||Character First Name
|- align="center"
|align="left"|lastname||char(32)||align="center"| ||align="center"| ||YES|| ||NULL||Character Last Name
|- align="center" style="background-color:#F1F1F1;"
|align="left"|race_id||int(8)||align="center"|[[Image:Symbol OK.png|10px]]||align="center"| ||YES|| ||0||Race ID
|- align="center"
|align="left"|parent_id||bigint(20)||align="center"|[[Image:Symbol OK.png|10px]]||align="center"| ||YES|| ||0||Parent ID
|- align="center" style="background-color:#F1F1F1;"
|align="left"|planet_id||int(2)||align="center"| ||align="center"| ||NO|| ||1||Planet ID
|- align="center"
|align="left"|x||float(10,6)||align="center"| ||align="center"| ||YES|| ||NULL||
|- align="center" style="background-color:#F1F1F1;"
|align="left"|y||float(10,6)||align="center"| ||align="center"| ||YES|| ||NULL||
|- align="center"
|align="left"|z||float(10,6)||align="center"| ||align="center"| ||YES|| ||NULL||
|- align="center" style="background-color:#F1F1F1;"
|align="left"|oX||float(10,6)||align="center"| ||align="center"| ||YES|| ||NULL||
|- align="center"
|align="left"|oY||float(10,6)||align="center"| ||align="center"| ||YES|| ||NULL||
|- align="center" style="background-color:#F1F1F1;"
|align="left"|oZ||float(10,6)||align="center"| ||align="center"| ||YES|| ||NULL||
|- align="center"
|align="left"|oW||float(10,6)||align="center"| ||align="center"| ||YES|| ||NULL||
|- align="center" style="background-color:#F1F1F1;"
|align="left"|archived||tinyint(1)||align="center"|[[Image:Symbol OK.png|10px]]||align="center"| ||NO|| ||0||
|- align="center"
|align="left"|deletiondate||date||align="center"| ||align="center"| ||YES|| ||NULL||Deletion Date
|- align="center" style="background-color:#F1F1F1;"
|align="left"|jedistate||int(11)||align="center"|[[Image:Symbol OK.png|10px]]||align="center"| ||NO|| ||0||Character Jedi State
|- align="center"
|align="left"|bornyear||char(8)||align="center"| ||align="center"| ||YES|| ||NULL||Born Year
|}
|}

|valign=top|

== Related Tags ==
{|align="center"
|-
||{{D100%}}
|-
||{{Database}}
|-
||{{DatabaseTable}}
|-
|}
|}

==Table Create Script==
<pre>
DROP TABLE IF EXISTS `characters`;
CREATE TABLE `characters` (
`id` bigint(20) unsigned NOT NULL auto_increment COMMENT 'Unique ID',
`account_id` bigint(20) unsigned NOT NULL default '0' COMMENT 'Ties to the ACCOUNT Table',
`galaxy_id` int(5) default '0' COMMENT 'Ties to the GALAXY Table',
`firstname` char(32) default NULL COMMENT 'Character Firstname',
`lastname` char(32) default NULL COMMENT 'Character Lastname',
`race_id` int(8) unsigned default '0' COMMENT 'Ties to the RACE Table',
`parent_id` bigint(20) unsigned default '0' COMMENT 'Ties to ... (Cell)',
`planet_id` int(2) NOT NULL default '1' COMMENT 'Current Planet - Defualt Corellia',
`x` float(10,6) default NULL COMMENT 'Character X Location',
`y` float(10,6) default NULL COMMENT 'Character Y Location',
`z` float(10,6) default NULL COMMENT 'Character Z Location',
`oX` float(10,6) default NULL COMMENT 'Character Cell X Location',
`oY` float(10,6) default NULL COMMENT 'Character Cell Y Location',
`oZ` float(10,6) default NULL COMMENT 'Character Cell Z Location',
`oW` float(10,6) default NULL COMMENT 'Character Cell Orientation',
`archived` tinyint(1) unsigned default '0' COMMENT '0 = active / 1 = scheduled to be deleted',
`deletiondate` date default NULL COMMENT 'DATE to be deleted',
`jedistate` int(11) unsigned NOT NULL default '0',
`bornyear` char(8) DEFAULT NULL COMMENT 'Year character was created.',
PRIMARY KEY (`id`),
UNIQUE KEY `pk_firstname` (`firstname`),
KEY `fk_character_acc_acc` (`account_id`),
KEY `fk_character_gal_gal` (`galaxy_id`),
KEY `fk_character_race_race` (`race_id`),
KEY `fk_character_planetid_planetid` (`planet_id`),
KEY `FK_characters_jedistate_state` (`jedistate`),
CONSTRAINT `characters_ibfk_1` FOREIGN KEY (`planet_id`) REFERENCES `planet` (`planet_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `characters_ibfk_2` FOREIGN KEY (`account_id`) REFERENCES `account` (`account_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `characters_ibfk_3` FOREIGN KEY (`galaxy_id`) REFERENCES `galaxy` (`galaxy_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `characters_ibfk_4` FOREIGN KEY (`race_id`) REFERENCES `race` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_characters_jedistate_state` FOREIGN KEY (`jedistate`) REFERENCES `skills_jedi_states` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=8589935594 DEFAULT CHARSET=utf8;
</pre>

==Table Describe==
<pre>
mysql> describe characters;
+--------------+---------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+---------------------+------+-----+---------+----------------+
| id | bigint(20) unsigned | NO | PRI | NULL | auto_increment |
| account_id | bigint(20) unsigned | NO | MUL | 0 | |
| galaxy_id | int(5) | YES | MUL | 0 | |
| firstname | char(32) | YES | UNI | NULL | |
| lastname | char(32) | YES | | NULL | |
| race_id | int(8) unsigned | YES | MUL | 0 | |
| parent_id | bigint(20) unsigned | YES | | 0 | |
| planet_id | int(2) | NO | MUL | 1 | |
| x | float(10,6) | YES | | NULL | |
| y | float(10,6) | YES | | NULL | |
| z | float(10,6) | YES | | NULL | |
| oX | float(10,6) | YES | | NULL | |
| oY | float(10,6) | YES | | NULL | |
| oZ | float(10,6) | YES | | NULL | |
| oW | float(10,6) | YES | | NULL | |
| archived | tinyint(1) unsigned | YES | | 0 | |
| deletiondate | date | YES | | NULL | |
| jedistate | int(11) unsigned | NO | MUL | 0 | |
| bornyear | char(8) | YES | | NULL | |
+--------------+---------------------+------+-----+---------+----------------+
19 rows in set (0.14 sec)
</pre>

Biography faction (Database Table)

2010-03-13T04:30:59Z

Nebula:

{{PageHeader|Database Table|biography_faction}}

{| border="0" width="90%" cellpadding=6
|-
|valign=top|

==Table Structure==
{| align="center"
|-
||
{| class = "wikitable"
|- align="center" style="background-color:#ffffcc;"
||'''Field'''||'''Type'''||'''Unsigned'''||'''Autoinc'''||'''Null'''||'''Key'''||'''Default Value'''||'''Description'''
|- align="center"
|align="left"|faction||varchar(45)||align="center"| ||align="center"| ||NO||Primary||NULL||
|}
|}

|valign=top|

== Related Tags ==
{|align="center"
|-
||{{D75%}}
|-
||{{Database}}
|-
||{{DatabaseTable}}
|-
|}
|}

==Table Create Script==
<pre>
DROP TABLE IF EXISTS `biography_faction`;
CREATE TABLE `biography_faction` (
`faction` varchar(45) NOT NULL,
PRIMARY KEY (`faction`(1))
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=REDUNDANT;
</pre>

==Table Describe==
<pre>
mysql> describe biography_faction;
+---------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| faction | varchar(45) | NO | PRI | NULL | |
+---------+-------------+------+-----+---------+-------+
1 row in set (0.09 sec)
</pre>

Biography faction (Database Table)

2010-03-13T04:28:47Z

Nebula:

{{PageHeader|Database Table|biography_faction}}

{| border="0" width="90%" cellpadding=6
|-
|valign=top|

==Table Structure==
{| align="center"
|-
||
{| class = "wikitable"
|- align="center" style="background-color:#ffffcc;"
||'''Field'''||'''Type'''||'''Unsigned'''||'''Autoinc'''||'''Null'''||'''Key'''||'''Default Value'''||'''Description'''
|- align="center"
|align="left"|faction|| ||align="center"|[[Image:Symbol OK.png|10px]]||align="center"|||NO||Primary||NULL||
|- align="center" style="background-color:#F1F1F1;"
|| || ||align="center"| ||align="center"| || || || ||
|-
|}
|}

|valign=top|

== Related Tags ==
{|align="center"
|-
||{{D75%}}
|-
||{{Database}}
|-
||{{DatabaseTable}}
|-
|}
|}

==Table Create Script==
<pre>
DROP TABLE IF EXISTS `biography_faction`;
CREATE TABLE `biography_faction` (
`faction` varchar(45) NOT NULL,
PRIMARY KEY (`faction`(1))
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=REDUNDANT;
</pre>

==Table Describe==
<pre>
mysql> describe biography_faction;
+---------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| faction | varchar(45) | NO | PRI | NULL | |
+---------+-------------+------+-----+---------+-------+
1 row in set (0.09 sec)
</pre>

Badges (Database Table)

2010-03-13T04:17:27Z

Nebula:

{{PageHeader|Database Table|badges}}

{| border="0" width="90%" cellpadding=6
|-
|valign=top|

==Table Structure==
{| align="center"
|-
||
{| class = "wikitable"
|- align="center" style="background-color:#ffffcc;"
||'''Field'''||'''Type'''||'''Unsigned'''||'''Autoinc'''||'''Null'''||'''Key'''||'''Default Value'''||'''Description'''
|- align="center"
|align="left"|Id||int(11)||align="center"|[[Image:Symbol OK.png|10px]]||align="center"| ||No||Primary||0||Badge ID
|- align="center" style="background-color:#F1F1F1;"
|align="left"|name||char(255)||align="center"| ||align="center"| ||YES||Unique||NULL||Badge Name
|- align="center"
|align="left"|sound||int(11)||align="center"|[[Image:Symbol OK.png|10px]]||align="center"| ||NO|| ||0||Sound ID
|- align="center" style="background-color:#F1F1F1;"
||category||int(11)||align="center"|[[Image:Symbol OK.png|10px]]||align="center"| ||NO|| ||0||Category ID
|}
|}

|valign=top|

== Related Tags ==
{|align="center"
|-
||{{D100%}}
|-
||{{Database}}
|-
||{{DatabaseTable}}
|-
|}
|}

==Table Create Script==
<pre>
--
-- Definition of table `badges`
--

DROP TABLE IF EXISTS `badges`;
CREATE TABLE `badges` (
`Id` int(11) unsigned NOT NULL default '0',
`name` char(255) default NULL,
`sound` int(11) unsigned NOT NULL default '0',
`category` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`Id`),
UNIQUE KEY `pk_badges_name` (`name`),
KEY `fk_badges_cat_cat` (`category`),
KEY `fk_badges_sound_sound` (`sound`),
CONSTRAINT `fk_badges_cat_cat` FOREIGN KEY (`category`) REFERENCES `badge_categories` (`Id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `fk_badges_sound_sound` FOREIGN KEY (`sound`) REFERENCES `sounds` (`Id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
</pre>

==Table Describe==
<pre>
mysql> describe badges;
+----------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+------------------+------+-----+---------+-------+
| Id | int(11) unsigned | NO | PRI | 0 | |
| name | char(255) | YES | UNI | NULL | |
| sound | int(11) unsigned | NO | MUL | 0 | |
| category | int(11) unsigned | NO | MUL | 0 | |
+----------+------------------+------+-----+---------+-------+
4 rows in set (0.06 sec)
</pre>

Badge regions (Database Table)

2010-03-13T04:09:23Z

Nebula:

{{PageHeader|Database Table|badge_regions}}

{| border="0" width="90%" cellpadding=6
|-
|valign=top|

==Table Structure==
{| align="center"
|-
||
{| class = "wikitable"
|- align="center" style="background-color:#ffffcc;"
||'''Field'''||'''Type'''||'''Unsigned'''||'''Autoinc'''||'''Null'''||'''Key'''||'''Default Value'''||'''Description'''
|- align="center"
|align="left"|Id||bigint(20)||align="center"|[[Image:Symbol OK.png|10px]]||align="center"| ||NO||Primary||0||
|- align="center" style="background-color:#F1F1F1;"
|align="left"|region_id||int(11)||align="center"|[[Image:Symbol OK.png|10px]] ||align="center"| ||NO|| ||0||Region ID
|- align="center"
|align="left"|badge_id||int(11)||align="center"|[[Image:Symbol OK.png|10px]] ||align="center"| ||NO|| ||0||Badge ID
|- align="center" style="background-color:#F1F1F1;"
|align="left"|planet_id||int(2)||align="center"| ||align="center"| ||NO|| ||0||Planet ID
|- align="center"
|align="left"|parent_id||bigint(20)||align="center"|[[Image:Symbol OK.png|10px]] ||align="center"| ||NO|| ||0||Parent ID
|}
|}

|valign=top|

== Related Tags ==
{|align="center"
|-
||{{D100%}}
|-
||{{Database}}
|-
||{{DatabaseTable}}
|-
|}
|}

==Table Create Script==
<pre>
--
-- Definition of table `badge_regions`
--

DROP TABLE IF EXISTS `badge_regions`;
CREATE TABLE `badge_regions` (
`Id` bigint(20) unsigned NOT NULL default '0',
`region_id` int(11) unsigned NOT NULL default '0',
`badge_id` int(11) unsigned NOT NULL default '0',
`planet_id` int(2) NOT NULL default '0',
`parent_id` bigint(20) unsigned NOT NULL default '0',
PRIMARY KEY (`Id`),
KEY `fk_badge_regions_region_region` (`region_id`),
KEY `fk_badge_regions_badge_badge` (`badge_id`),
KEY `fk_badgeregion_planet_planet` (`planet_id`),
CONSTRAINT `fk_badgeregion_planet_planet` FOREIGN KEY (`planet_id`) REFERENCES `planet` (`planet_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `fk_badge_regions_badge_badge` FOREIGN KEY (`badge_id`) REFERENCES `badges` (`Id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `fk_badge_regions_region_region` FOREIGN KEY (`region_id`) REFERENCES `planet_regions` (`region_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=REDUNDANT;
</pre>

==Table Describe==
<pre>
mysql> describe badge_regions;
+-----------+---------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+---------------------+------+-----+---------+-------+
| Id | bigint(20) unsigned | NO | PRI | 0 | |
| region_id | int(11) unsigned | NO | MUL | 0 | |
| badge_id | int(11) unsigned | NO | MUL | 0 | |
| planet_id | int(2) | NO | MUL | 0 | |
| parent_id | bigint(20) unsigned | NO | | 0 | |
+-----------+---------------------+------+-----+---------+-------+
5 rows in set (0.11 sec)
</pre>

Badge categories (Database Table)

2010-03-13T03:54:21Z

Nebula:

{{PageHeader|Database Table|badge_categories}}

{| border="0" width="90%" cellpadding=6
|-
|valign=top|

==Table Structure==
{| align="center"
|-
||
{| class = "wikitable"
|- align="center" style="background-color:#ffffcc;"
||'''Field'''||'''Type'''||'''Unsigned'''||'''Autoinc'''||'''Null'''||'''Key'''||'''Default Value'''||'''Description'''
|- align="center"
|align="left"|Id||int(11)||align="center"|[[Image:Symbol OK.png|10px]]||align="center"| ||NO||Primary||0||ID
|- align="center" style="background-color:#F1F1F1;"
|align="left"|name||char(255)||align="center"| ||align="center"| ||YES||Unique||NULL||Badge Category Name
|-
|}
|}

|valign=top|

== Related Tags ==
{|align="center"
|-
||{{D100%}}
|-
||{{Database}}
|-
||{{DatabaseTable}}
|-
|}
|}

==Table Create Script==
<pre>
--
-- Definition of table `badge_categories`
--

DROP TABLE IF EXISTS `badge_categories`;
CREATE TABLE `badge_categories` (
`Id` int(11) unsigned NOT NULL default '0',
`name` char(255) default NULL,
PRIMARY KEY (`Id`),
UNIQUE KEY `pk_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=REDUNDANT;
</pre>

==Table Describe==
<pre>
mysql> describe badge_categories;
+-------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+------------------+------+-----+---------+-------+
| Id | int(11) unsigned | NO | PRI | 0 | |
| name | char(255) | YES | UNI | NULL | |
+-------+------------------+------+-----+---------+-------+
2 rows in set (0.10 sec)
</pre>

Attributes (Database Table)

2010-03-13T03:28:35Z

Nebula:

{{PageHeader|Database Table|Attributes}}
{| border="0" width="90%" cellpadding=6
|-
|valign=top|
==Table Structure==
{| align="center"
|-
||
{| class = "anhsmalltable"
|- align="center" style="background-color:#ffffcc;"
|width="100px"|'''Field'''||width="60px"|'''Type'''||width="60px"|'''Unsigned'''||width="60px"|'''Autoinc'''||width="40px"|'''Null'''||width="40px"|'''Key'''||width="100px"|'''Default Value'''||width="200px"|'''Description'''
|- align="center"
|align="left"|id||int(11)||align="center"|[[Image:Symbol OK.png|10px]]||align="center"|[[Image:Symbol OK.png|10px]]||NO||Primary||Null||Attribute ID
|- align="center" style="background-color:#F1F1F1;"
|align="left"|name||char(255)||align="center"| ||align="center"| ||YES||Unique||Null||Attribute Name
|- align="center"
|align="left"|internal||tinyint(3)||align="center"|[[Image:Symbol OK.png|10px]]||align="center"| ||NO|| ||0||Attribute Description
|- align="center" style="background-color:#F1F1F1;"
|align="left"|attribute_internal_description||text||align="center"| ||align="center"| ||NO|| ||Null||Attribute Description
|- align="center"
|align="left"|item_tool_internal||int(10)||align="center"|[[Image:Symbol OK.png|10px]]||align="center"| ||NO|| ||0||Attribute Description
|- align="center"
|align="left"|item_tool_internal_2||int(10)||align="center"|[[Image:Symbol OK.png|10px]]||align="center"| ||NO|| ||0||Attribute Description
|}
|}
|valign=top|

== Related Tags ==
{|align="center"
|-
||{{D100%}}
|-
||{{Database}}
|-
||{{DatabaseTable}}
|-
|}
|}

==Table Create Script==
<pre>
DROP TABLE IF EXISTS `attributes`;
CREATE TABLE `attributes` (
`id` int(11) unsigned NOT NULL auto_increment,
`name` char(255) default NULL,
`internal` tinyint(3) unsigned NOT NULL default '0',
`attribute_internal_description` text NOT NULL,
`item_tool_internal` int(10) unsigned NOT NULL default '0',
`item_tool_internal_2` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `pk_attributes_name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=2060 DEFAULT CHARSET=utf8;
</pre>

==Table Describe==
<pre>
mysql> describe attributes;
+--------------------------------+---------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------------------------+---------------------+------+-----+---------+----------------+
| id | int(11) unsigned | NO | PRI | NULL | auto_increment |
| name | char(255) | YES | UNI | NULL | |
| internal | tinyint(3) unsigned | NO | | 0 | |
| attribute_internal_description | text | NO | | NULL | |
| item_tool_internal | int(10) unsigned | NO | | 0 | |
| item_tool_internal_2 | int(10) unsigned | NO | | 0 | |
+--------------------------------+---------------------+------+-----+---------+----------------+
6 rows in set (0.23 sec)
</pre>