Tested both the `CREATE TABLE` and `ALTER TABLE` statements locally in TablePlus individually to confirm the table gets created and no syntax errors are present.
```
CREATE TABLE pinned_messages (
messageID bigint(20) NOT NULL,
thread bigint(20) NOT NULL,
pin_time bigint(20) NOT NULL
)
```
```
ALTER TABLE pinned_messages
ADD PRIMARY KEY (messageID),
ADD INDEX thread (thread);
```
```
DROP TABLE pinned_messages;
```