Created
December 15, 2021 15:15
-
-
Save tinwritescode/8bb931f3a05f5eead7c9335e60bf4967 to your computer and use it in GitHub Desktop.
chat.sql
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE TABLE users (id integer primary key autoincrement, username string unique, password string, email string unique) | |
| CREATE TABLE messages (id integer primary key autoincrement, message string, time timestamp default current_timestamp not null, sender integer references users(id), receiver integer references users(id)) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment