11 lines
409 B
SQL
Executable File
11 lines
409 B
SQL
Executable File
DROP TABLE IF EXISTS character_spell_effect_targets;
|
|
CREATE TABLE character_spell_effect_targets (
|
|
caster_char_id INTEGER NOT NULL DEFAULT 0,
|
|
target_char_id INTEGER NOT NULL DEFAULT 0,
|
|
target_type INTEGER NOT NULL DEFAULT 0,
|
|
db_effect_type INTEGER NOT NULL DEFAULT 0,
|
|
spell_id INTEGER NOT NULL DEFAULT 0,
|
|
effect_slot INTEGER NOT NULL DEFAULT 0,
|
|
slot_pos INTEGER NOT NULL DEFAULT 0
|
|
);
|