9 lines
240 B
SQL
9 lines
240 B
SQL
DROP TABLE IF EXISTS character_pictures;
|
|
CREATE TABLE character_pictures (
|
|
id INTEGER PRIMARY KEY,
|
|
char_id INTEGER NOT NULL DEFAULT 0,
|
|
pic_type INTEGER NOT NULL DEFAULT 0,
|
|
picture TEXT NOT NULL,
|
|
UNIQUE(char_id, pic_type)
|
|
);
|