Character xp (Database Table)

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) 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)