8 lines
346 B
SQL
8 lines
346 B
SQL
CREATE TABLE `followAcceptActivity` (
|
|
`id` integer PRIMARY KEY NOT NULL,
|
|
`userid` integer NOT NULL,
|
|
`remoteUserid` integer NOT NULL,
|
|
`activity` text,
|
|
FOREIGN KEY (`userid`) REFERENCES `user`(`id`) ON UPDATE no action ON DELETE no action,
|
|
FOREIGN KEY (`remoteUserid`) REFERENCES `remoteUser`(`id`) ON UPDATE no action ON DELETE no action
|
|
);
|