30 lines
1.3 KiB
SQL
30 lines
1.3 KiB
SQL
DROP TABLE IF EXISTS item_details_skills;
|
|
CREATE TABLE item_details_skills (
|
|
id INTEGER PRIMARY KEY,
|
|
item_id INTEGER NOT NULL DEFAULT 0 UNIQUE,
|
|
unknown12 INTEGER NOT NULL DEFAULT 0,
|
|
unknown13 INTEGER NOT NULL DEFAULT 0,
|
|
unknown14 INTEGER NOT NULL DEFAULT 0,
|
|
unknown15 INTEGER NOT NULL DEFAULT 0,
|
|
unknown16 INTEGER NOT NULL DEFAULT 0,
|
|
unknown17 INTEGER NOT NULL DEFAULT 0,
|
|
duration INTEGER NOT NULL DEFAULT 0,
|
|
unknown18 INTEGER NOT NULL DEFAULT 0,
|
|
unknown19 INTEGER NOT NULL DEFAULT 0,
|
|
unknown20 INTEGER NOT NULL DEFAULT 0,
|
|
unknown21 INTEGER NOT NULL DEFAULT 0,
|
|
unknown22 INTEGER NOT NULL DEFAULT 0,
|
|
unknown23 INTEGER NOT NULL DEFAULT 0,
|
|
unknown24 INTEGER NOT NULL DEFAULT 0,
|
|
power_req INTEGER NOT NULL DEFAULT 0,
|
|
power_upkeep_req INTEGER NOT NULL DEFAULT 0,
|
|
hp_req INTEGER NOT NULL DEFAULT 0,
|
|
hp_upkeep_req INTEGER NOT NULL DEFAULT 0,
|
|
cast INTEGER NOT NULL DEFAULT 0,
|
|
recovery INTEGER NOT NULL DEFAULT 0,
|
|
recast REAL NOT NULL DEFAULT 0,
|
|
unknown25 REAL NOT NULL DEFAULT 0,
|
|
unknown26 INTEGER NOT NULL DEFAULT 0,
|
|
FOREIGN KEY (item_id) REFERENCES items(id) ON DELETE CASCADE ON UPDATE CASCADE
|
|
);
|