Last active
October 3, 2022 03:46
-
-
Save itsgitz/4653491aa53747a0982ce6b781259514 to your computer and use it in GitHub Desktop.
Create table query for modul 3
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 IF NOT EXISTS users ( | |
| id serial PRIMARY KEY, | |
| username VARCHAR(50) NOT NULL, | |
| password VARCHAR(50) NOT NULL | |
| ) | |
| CREATE TABLE IF NOT EXISTS notes ( | |
| id serial PRIMARY KEY, | |
| title VARCHAR(50) NOT NULL, | |
| notes TEXT NOT NULL, | |
| file TEXT NULL | |
| ) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment