Loading...   


mysql> DESCRIBE character_buffs;
+----------------+-----------------------+------+-----+---------+-------+
| Field          | Type                  | Null | Key | Default | Extra |
+----------------+-----------------------+------+-----+---------+-------+
| character_id   | int(10) unsigned      | NO   | PRI | NULL    |       |
| slot_id        | tinyint(3) unsigned   | NO   | PRI | NULL    |       |
| spell_id       | smallint(10) unsigned | NO   |     | NULL    |       |
| caster_level   | tinyint(3) unsigned   | NO   |     | NULL    |       |
| caster_name    | varchar(64)           | NO   |     | NULL    |       |
| ticsremaining  | int(11)               | NO   |     | NULL    |       |
| counters       | int(10) unsigned      | NO   |     | NULL    |       |
| numhits        | int(10) unsigned      | NO   |     | NULL    |       |
| melee_rune     | int(10) unsigned      | NO   |     | NULL    |       |
| magic_rune     | int(10) unsigned      | NO   |     | NULL    |       |
| persistent     | tinyint(3) unsigned   | NO   |     | NULL    |       |
| dot_rune       | int(10)               | NO   |     | 0       |       |
| caston_x       | int(10)               | NO   |     | 0       |       |
| caston_y       | int(10)               | NO   |     | 0       |       |
| caston_z       | int(10)               | NO   |     | 0       |       |
| ExtraDIChance  | int(10)               | NO   |     | 0       |       |
| instrument_mod | int(10)               | NO   |     | 10      |       |
+----------------+-----------------------+------+-----+---------+-------+
17 rows in set

mysql> 

Raw Paste Data