Character xp (Database Table)

From SWGANH Wiki
Jump to: navigation, search

Database Table - character_xp

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
id int(10) Symbol OK.png Symbol OK.png Symbol OK.png ID
war char(64) War Name

Related Tags

100% This document is complete.

Database This document relates to the SWGANH Database Schema.

DB Table This document relates to the SWGANH Database Schema.

Table Create Script

CREATE TABLE `biography_wars` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `war` char(64) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Table Describe

mysql> desc character_xp;
+--------------+---------------------+------+-----+---------+-------+
| Field        | Type                | Null | Key | Default | Extra |
+--------------+---------------------+------+-----+---------+-------+
| character_id | bigint(20) unsigned | NO   | PRI | 0       |       |
| xp_id        | int(11) unsigned    | NO   | PRI | 49      |       |
| value        | int(10)             | NO   |     | 0       |       |
+--------------+---------------------+------+-----+---------+-------+
3 rows in set (0.00 sec)