Something went wrong. Try again.
Something went wrong. Try again.
525 B · 12 lines
SQL
at main
12345678910111213CREATE TABLE IF NOT EXISTS abyssal_items ( item_id INTEGER NOT NULL PRIMARY KEY, character_id INTEGER NOT NULL REFERENCES characters(id) ON DELETE CASCADE, type_id INTEGER NOT NULL, source_type_id INTEGER NOT NULL, mutator_type_id INTEGER NOT NULL, dogma_attributes TEXT NOT NULL DEFAULT '[]', synced_at INTEGER NOT NULL, muta_price_isk REAL, muta_price_synced INTEGER);CREATE INDEX IF NOT EXISTS idx_abyssal_items_character_id ON abyssal_items(character_id);