12 lines
416 B
SQL
12 lines
416 B
SQL
DROP TABLE IF EXISTS char_colors;
|
|
CREATE TABLE char_colors (
|
|
id INTEGER PRIMARY KEY,
|
|
char_id INTEGER NOT NULL,
|
|
signed_value INTEGER NOT NULL DEFAULT 0,
|
|
type TEXT NOT NULL,
|
|
red INTEGER NOT NULL DEFAULT 0,
|
|
green INTEGER NOT NULL DEFAULT 0,
|
|
blue INTEGER NOT NULL DEFAULT 0,
|
|
FOREIGN KEY (char_id) REFERENCES characters(id) ON DELETE CASCADE ON UPDATE CASCADE
|
|
);
|