17 lines
669 B
SQL
17 lines
669 B
SQL
DROP TABLE IF EXISTS item_details_achievement_profile;
|
|
CREATE TABLE item_details_achievement_profile (
|
|
id INTEGER PRIMARY KEY,
|
|
item_id INTEGER NOT NULL,
|
|
status_reduction INTEGER NOT NULL DEFAULT 0,
|
|
coin_reduction REAL NOT NULL DEFAULT 0,
|
|
house_type INTEGER NOT NULL DEFAULT 0,
|
|
unk_string TEXT,
|
|
unk1 INTEGER NOT NULL DEFAULT 0,
|
|
FOREIGN KEY (item_id) REFERENCES items(id) ON DELETE CASCADE ON UPDATE CASCADE
|
|
);
|
|
CREATE INDEX idx_item_details_achievement_profile_item_id ON item_details_achievement_profile(item_id);
|
|
|
|
INSERT INTO item_details_achievement_profile VALUES
|
|
(1,20101,500,0,1,'',0),
|
|
(2,20100,0,0,0,'',0);
|