Difference between revisions of "Character xp (Database Table)"

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)