22 lines
438 B
MySQL
22 lines
438 B
MySQL
|
-- Up
|
||
|
|
|
||
|
|
CREATE TABLE profiles (
|
||
|
|
id TEXT NOT NULL PRIMARY KEY,
|
||
|
|
userId TEXT NOT NULL,
|
||
|
|
locale TEXT NOT NULL,
|
||
|
|
names TEXT NOT NULL,
|
||
|
|
pronouns TEXT NOT NULL,
|
||
|
|
description TEXT NOT NULL,
|
||
|
|
birthday TEXT,
|
||
|
|
links TEXT NOT NULL,
|
||
|
|
flags TEXT NOT NULL,
|
||
|
|
words TEXT NOT NULL,
|
||
|
|
active INTEGER NOT NULL,
|
||
|
|
FOREIGN KEY(userId) REFERENCES users(id),
|
||
|
|
UNIQUE ("userId", "locale")
|
||
|
|
);
|
||
|
|
|
||
|
|
-- Down
|
||
|
|
|
||
|
|
DROP TABLE "profiles";
|