7 lines
318 B
SQL
7 lines
318 B
SQL
CREATE TABLE IF NOT EXISTS user_follow (
|
|
`user_id` INTEGER NOT NULL REFERENCES user(id) ON DELETE CASCADE,
|
|
`follow_id` INTEGER NOT NULL REFERENCES user(id) ON DELETE CASCADE,
|
|
`created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
PRIMARY KEY (user_id, follow_id),
|
|
CHECK (user_id <> follow_id)
|
|
); |