18 lines
777 B
SQL
18 lines
777 B
SQL
DROP TABLE IF EXISTS ho_wheel;
|
|
CREATE TABLE ho_wheel (
|
|
id INTEGER PRIMARY KEY,
|
|
starter_id INTEGER NOT NULL DEFAULT 0,
|
|
order INTEGER NOT NULL DEFAULT 0,
|
|
spell_id INTEGER NOT NULL DEFAULT 0,
|
|
first_ability INTEGER NOT NULL DEFAULT 65535,
|
|
second_ability INTEGER NOT NULL DEFAULT 65535,
|
|
third_ability INTEGER NOT NULL DEFAULT 65535,
|
|
fourth_ability INTEGER NOT NULL DEFAULT 65535,
|
|
fifth_ability INTEGER NOT NULL DEFAULT 65535,
|
|
sixth_ability INTEGER NOT NULL DEFAULT 65535,
|
|
FOREIGN KEY (starter_id) REFERENCES ho_starter_chains(id) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
FOREIGN KEY (spell_id) REFERENCES spells(id)
|
|
);
|
|
CREATE INDEX idx_ho_wheel_starter_id ON ho_wheel(starter_id);
|
|
CREATE INDEX idx_ho_wheel_spell_id ON ho_wheel(spell_id);
|