suhan1996
14 lines
494 B
SQL
14 lines
494 B
SQL
create table pinned_message
|
|
(
|
|
id integer primary key autoincrement not null,
|
|
gid integer not null,
|
|
mid integer not null,
|
|
created_by integer not null,
|
|
created_at timestamp not null,
|
|
foreign key (created_by) references `user` (uid) on delete cascade,
|
|
foreign key (gid) references `group` (gid) on delete cascade
|
|
);
|
|
|
|
create index pinned_message_gid on pinned_message (gid);
|
|
create unique index pinned_message_gid_mid on pinned_message (gid, mid);
|