Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE DATABASE ToDoList;
- USE ToDoList;
- CREATE TABLE users(
- id INT AUTO_INCREMENT PRIMARY KEY,
- email VARCHAR(255) NOT NULL,
- password VARCHAR(255) NOT NULL,
- admin BOOLEAN NOT NULL DEFAULT FALSE
- );
- CREATE TABLE tarefas(
- id INT AUTO_INCREMENT PRIMARY KEY,
- user_id INT NOT NULL,
- tarefa VARCHAR(255),
- done BOOLEAN DEFAULT FALSE,
- FOREIGN KEY (user_id) REFERENCES users(id)
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement