3 USERNAME
TEXT NOT NULL,
4 TIMESTAMP INT NOT NULL,
5 FOREIGN KEY(username
) references users(username
)
10 MIME_TYPE
TEXT NOT NULL,
11 PIC_B64
TEXT NOT NULL,
12 FOREIGN KEY(POST_ID
) references posts(id)
14 CREATE TABLE comments (
16 POST_ID
TEXT NOT NULL,
18 FOREIGN KEY(POST_ID
) references posts(id)